To reconcile cash receipts to bank deposits, compare each day's receipts log to the deposit slip prepared for that day, then compare the slip to the credit on the bank statement. The three should agree. Any difference has a named reason, such as a combined deposit or a late trip to the bank, or it is a shortfall to investigate.
What records does a cash receipts to bank deposit tie-out compare?
A cash receipts to bank deposit tie-out compares three records made by different hands: the log of money received, the deposit slip that lists what went to the bank, and the bank statement credit that proves the bank counted it. Each pair tests something different, and skipping one pair leaves a gap a thief can use.
The three comparisons and what each one proves:
- Receipts log to deposit slip. Everything received was put in the bag. A shortfall here means money left between the counter and the deposit.
- Deposit slip to bank credit. The bank received what the slip says. A shortfall here points to the trip to the bank, a counting error, or a slip prepared after the fact.
- Receipts log to bank credit. The end-to-end check, used when the slip is missing or untrustworthy.
The term cash receipts here covers currency and checks received in person or by mail. Card and electronic payments follow their own trail through a processor and are reconciled from processor reports, so keep them out of this tie-out unless they share a deposit with paper items. A business that also sells gift cards has a fourth record to watch, because gift card sales bring in cash without creating sales revenue. Gift card liability reconciliation covers that side.
Building a daily cash receipts log that can be matched
A daily cash receipts log can only be matched if it records each receipt at the moment it arrives, by someone other than the person who prepares the deposit. It needs a date, payer, form of payment, amount and reference. A log written up from the deposit slip proves nothing, because it copies the record it should test.
Columns that make the log usable for matching:
| Column | Why it matters for the match |
|---|---|
| Date received | Places the item in a deposit day |
| Payer | Lets you trace the item to a customer account |
| Form (currency or check) | Separates the two totals on the deposit slip |
| Check number and bank | Identifies the exact item on a returned-check notice |
| Amount | The figure that must reach the bank |
| Logged by | Shows who recorded it, for the segregation test |
| Deposit date | Filled in when the item goes to the bank |
The deposit date column is the piece most logs lack. Without it, a reviewer has to infer which receipts went into which deposit, and two days merged into one bank credit become guesswork. With it, the log groups itself.
For a shop with a register, the log is often the register's end-of-day report plus a count sheet for the drawer. The count sheet should show the starting float, the counted cash and the difference, signed by the person who counted. Daily sales reconciliation covers the register side of that count.
Matching cash receipts to deposit slips and bank credits, day by day
Match cash receipts to deposits in a fixed order each day: total the log, compare it to the slip, then find the slip's amount on the bank statement. Record the result in a running schedule so that each day has a status of agreed, explained or open. Explained items carry the reason and the evidence beside them.
The daily routine, written as steps:
- Total the receipts log for the day, splitting currency and checks.
- Compare the totals to the deposit slip's currency and check lines.
- Confirm the slip lists the same checks, by number and amount, as the log.
- Find a bank credit for the slip total, usually one or two business days later.
- Note the bank credit date and mark the day agreed, or write down the reason it is not.
The table below is an example week for an illustrative service business. The figures are invented to show each kind of result.
| Day (example) | Per receipts log | Per deposit slip | Bank credit | Credit date | Status |
|---|---|---|---|---|---|
| Mon | 1,240.00 | 1,240.00 | 1,240.00 | Tue | Agreed |
| Tue | 865.50 | 865.50 | 2,015.75 | Thu | Combined with Wed |
| Wed | 1,150.25 | 1,150.25 | (in Tue credit) | Thu | Combined with Tue |
| Thu | 1,410.00 | 1,390.00 | 1,390.00 | Fri | Open: 20.00 short |
| Fri | 1,025.00 | 1,025.00 | none yet | In transit at week end |
Monday is clean. Tuesday and Wednesday were deposited together, and the credit equals the sum of the two slips, 2,015.75. Thursday is short by 20.00 between the log and the slip, so the money went missing before it reached the bag. Friday's deposit is in transit and should appear early the next week. Only Thursday needs a question asked today.
Combined deposits: two days of cash receipts in one bank credit
A combined deposit is one bank credit that carries cash receipts from two or more days. It happens when Monday's money is banked with Tuesday's, or when a night drop is processed with the next morning's deposit. The match still works if the slips are kept separate and their totals add up to the credit.
The rule for combined deposits is simple: add the slips, not the logs. If two slips exist and their sum equals the bank credit, both days are agreed. If only one slip was written for two days of money, compare it to the sum of the two logs, and note that the business lost a control, because a single slip makes it harder to tell which day was short.
Combined deposits are not a fault in themselves. A small office that receives a few checks a day may decide to bank twice a week. The problem is a combined deposit that nobody planned. When deposits that are usually daily start arriving every second day, ask why. The answer is often a staffing change, but holding cash longer is also how a cash shortage gets time to be covered with the next day's receipts.
How long can cash receipts wait before the bank deposit?
Cash receipts should reach the bank by the next business day in most businesses, and on the same day when amounts are large or the premises are not secure. Put a deadline in the cash policy, then measure every deposit against it. A delay beyond the deadline is an exception even when the money eventually arrives in full.
Measure the delay from the date in the receipts log to the date on the bank credit. A one-day gap is normal. Two days over a weekend is normal. Anything longer deserves a note with the reason, such as a holiday or a closed branch.
Patterns of delay matter more than single late deposits:
- The same person's days are always late. That points to a habit worth correcting, or to money being held for a reason.
- Delays grow over time. A deposit that slips from one day to three over a few months suggests the person is short and catching up.
- Late deposits cluster at month end. Holding receipts across a statement date shifts them between periods and makes a reconciliation look different from the business's real cash position.
If you want practice spotting delay and timing items on a full reconciliation, bank reconciliation practice problems include deposits in transit worked with answers.
Shortfalls between cash receipts and deposits that point to skimming
Skimming is theft of cash before it is recorded, or between recording and deposit. A shortfall between cash receipts and deposits is the trace it leaves when the receipt was logged first. Single small shortfalls are usually counting errors. Repeated shortfalls, round amounts, or shortfalls tied to one person or one shift are the patterns that suggest theft.
Look for these signs in the daily schedule:
- Currency short, checks complete. Checks are traceable to a payer, so a thief takes cash. A deposit that always has every check and slightly less currency than the log is a classic shape.
- Round-number shortfalls. Counting errors produce odd amounts. A run of 20.00, 50.00 and 100.00 differences is not random.
- Shortfalls on the same weekday or shift. Line the differences up against the staff rota.
- A log total that is revised after the fact. A receipts log with crossings-out or later entries that bring it down to the slip total has been changed to hide a gap.
- Customer complaints about payments not credited. A payer who insists they paid in cash, with no entry in the log, suggests the money was taken before it was ever recorded. That kind of theft leaves no shortfall in this tie-out at all, which is why the log must be kept by someone who does not prepare the deposit.
A shortfall that fits these patterns is a matter for the owner or the audit committee, not a line to adjust. Write down what you found, keep the logs and slips, and stop the person under suspicion from handling the next deposit until the question is answered.
Gift cards, voids and over-rings that distort the cash receipts total
Gift cards, voids and over-rings are the edge cases that make an honest day look short or long. A gift card sold for cash raises receipts without raising sales. A void not reversed in the drawer, or an over-ring corrected the next day, shifts amounts between days. Each needs a note before the day is called a shortfall.
Common cases and how to treat them:
- Gift card sold for currency. The cash is real and should reach the bank. The register may report it outside sales, so make sure the receipts total includes it.
- Gift card redeemed. No cash comes in, but the register may count the redemption in tendered amounts. Exclude it from the cash total.
- Void after the drawer was counted. The log and the drawer disagree for a reason that the void slip explains.
- Over-ring. The register shows more than was received. A signed over-ring slip, approved by someone other than the cashier, supports the correction.
- Change fund errors. A float that was not restored to its set amount carries a difference into the next day.
Voids and over-rings without a second signature are themselves a red flag, because they are also the way a cashier removes a recorded sale and keeps the money.
PreciseBankFlow reads the bank statement, confirms that it foots, and matches each credit to the deposit you recorded, so a deposit with no bank credit, or a credit for a different amount, lands on the exception report. You can see the checks it runs on the homepage.