Business Bank Reconciliation: Explain the Gap Without Counting Cash Twice
Reconcile a fictional $12,650 cash book and $13,120 bank statement, verify later clearing, and keep an unexplained $200 difference visible.
Estimated reading time: 8 minutes
Bank reconciliation corrections should explain the gap between records. This fictional exercise separates book changes from transactions that haven’t yet cleared.
A fictional business finishes June with $12,650 in its cash book and $13,120 on its bank statement. Neither starting figure is the finished answer. Four book corrections and three clearing differences bring both sides to $13,420.
The useful part is explaining each dollar. This example supplies the complete transaction record, checks what happens when the outstanding items clear in July, and then tests a separate $200 difference that the available evidence can’t resolve.
The IRS recordkeeping guide, Publication 583, recommends monthly reconciliation, matching deposits and checks, correcting omissions and recording errors, and investigating differences that remain.
Bank reconciliation corrections: fix the scope
All amounts below are invented U.S. dollars. The cash book means this business’s record for one checking account. The bank column means transactions posted on its June statement. A zero in either record means no entry there by June 30; it doesn’t necessarily mean nothing happened.
- Both records start June 1 at $10,000. There are no unresolved opening items.
- Customers owe $9,000 at the start, and the business owes suppliers $6,000. Every customer payment and supplier check below settles part of those opening balances. No new sales or purchases occur.
- The exercise uses stipulated accrual bookkeeping. A customer payment settles a receivable, and a supplier payment settles a payable. The $35 bank fee is the only June expense.
- There are no other accounts, transactions, interest, loans, restrictions, holds or overdrafts. The model supplies no bank available-balance figure and no future spending plan.
This deliberately closed example is an educational calculation, not a tax return, accounting-framework certification or audit. Its reconciled balance doesn’t establish what a real business can safely spend.
Read all nine June records
The original cash-book entries below are preserved before correction. A plus adds cash; a minus reduces it. The supporting facts are part of the fictional evidence packet.
June 10: customer receipt batch
Cash book: +$5,000. Bank: +$5,000.
The deposit matches customer receipts for existing invoices. This batch includes a $350 payment that’s returned later in June. Keep both the original receipt and that later return visible.
June 15: supplier check 101
Cash book: −$540. Bank: −$585.
The issued check image and supplier remittance both show $585. The bank posts that amount. Only the book entry is wrong.
June 20: supplier check 102
Cash book: −$2,110. Bank: −$2,110.
The issued check and cleared debit match. No difference remains for this payment.
June 25: customer transfer
Cash book: $0. Bank: +$1,200.
A bank credit and customer remittance identify payment of an existing $1,200 invoice. The business omitted the receipt from its books.
Bank reconciliation corrections: June 27 returned payment
Cash book: $0. Bank: −$350.
The return notice identifies the $350 payment inside the June 10 batch. The customer still owes that amount. There’s no separate return fee or write-off in this model.
June 28: supplier check 103
Cash book: −$1,900. Bank: $0.
The check was issued, delivered and entered in June books. It doesn’t appear on the June statement. The later statement shows it clearing July 2.
June 29: supplier check 104
Cash book: −$600. Bank: $0.
This issued and delivered check is also already in June books. It’s absent from the June statement and clears July 3.
June 30: late deposit
Cash book: +$2,800. Bank: $0.
A deposit receipt confirms acceptance on June 30 for payments against existing customer invoices. The bank credits it July 1. It’s separate from the $350 returned payment.
Bank reconciliation corrections: June 30 service fee
Cash book: $0. Bank: −$35.
The bank fee advice confirms the charge. The business hasn’t entered it in its books.
Rebuild the two original ending balances
The cash book contains $7,800 of receipts: $5,000 plus $2,800. Its recorded payments are $5,150: $540 + $2,110 + $1,900 + $600. Therefore, $10,000 + $7,800 − $5,150 = $12,650.
The statement contains $6,200 of credits: $5,000 plus $1,200. Its debits total $3,080: $585 + $2,110 + $350 + $35. Therefore, $10,000 + $6,200 − $3,080 = $13,120.
The statement exceeds the book by $470. That doesn’t identify a missing $470 transaction. Several differences combine to produce it.
Bank reconciliation corrections: fix the four book entries
The evidence calls for these changes to the original $12,650 book balance:
| Step | Cash amount |
|---|---|
| Original book balance | $12,650 |
| Add omitted customer transfer | +$1,200 |
| Record returned payment | −$350 |
| Record service fee | −$35 |
| Correct check 101 | −$45 |
| Corrected book cash | $13,420 |
Check 101 needs only another $45 reduction. The books already contain $540 of its actual $585 payment. Entering a second $585 payment would count the original $540 twice.
The $1,200 transfer reduces the existing customer receivable; it is not another sale. The $350 return restores the customer’s unpaid amount and reduces cash. It does not erase the other $4,650 from the original $5,000 batch.
The fee reduces cash and is the stipulated $35 expense. The check correction reduces cash and the supplier payable by another $45. Together, the four cash changes are +$770, so $12,650 + $770 = $13,420.
Separate bank-clearing differences from bank reconciliation corrections
The $2,800 deposit and the two outstanding checks already appear in June books. They are missing from the June bank statement, so this side of the comparison accounts for their timing:
| Step | Cash amount |
|---|---|
| June statement balance | $13,120 |
| Add June deposit credited July 1 | +$2,800 |
| Subtract check 103, clearing July 2 | −$1,900 |
| Subtract check 104, clearing July 3 | −$600 |
| Adjusted bank-side amount | $13,420 |
The net timing adjustment is +$300. The original $470 difference is now fully explained: +$770 of book corrections minus +$300 of bank-side timing adjustments equals $470.
Don’t enter these three timing items into the books again. Doing so would incorrectly move corrected book cash from $13,420 to $13,720. They need matching to their later bank entries, not another modeled receipt or payment.
Use July clearing as a second proof
There are no new transactions on July 1–3 in this example. Only the three June items reach the bank statement. Start the bank at $13,120 and the corrected books at $13,420:
| Event | Balances after the event |
|---|---|
| July 1: $2,800 deposit credited | Bank: $15,920 Books: $13,420 Checks still outstanding: $2,500 |
| July 2: $1,900 check clears | Bank: $14,020 Books: $13,420 Check still outstanding: $600 |
| July 3: $600 check clears | Bank: $13,420 Books: $13,420 Outstanding timing items: $0 |
On July 1, subtracting the remaining $2,500 of checks from the bank’s $15,920 still gives $13,420. On July 2, $14,020 less the remaining $600 gives the same result. On July 3, nothing remains to adjust.
July 5 is different. The customer sends a new $350 replacement transfer for the returned payment. This new receipt enters both records, taking each to $13,770 and settling the remaining receivable. It’s neither the July 1 deposit nor a new sale. The earlier return was already recorded once.
Check the other accounts without inventing profit
Within this closed exercise, June customer collections total $9,000 before the $350 return: $5,000 + $2,800 + $1,200. The return leaves $350 of the opening $9,000 still owed at June 30.
The actual supplier checks total $5,195: $585 + $2,110 + $1,900 + $600. That leaves $805 of the opening $6,000 payable. Clearing the two outstanding checks in July does not pay those liabilities a second time in the stipulated books.
Opening equity is $13,000. After the sole $35 June expense, it is $12,965. The June closing accounts agree: $13,420 cash + $350 receivable = $805 payable + $12,965 equity. This cross-check uses every boundary stated above; it is not a general template for a real company’s complete accounts.
For a separate example that begins with reconciled cash and explains why it can fall despite profit, see the profit-to-cash reconciliation.
If another $200 debit has no explanation, leave the difference open
Now consider a separate version of the June statement containing one additional, undocumented $200 debit. Every identified transaction stays unchanged. The statement balance becomes $12,920.
The same known timing adjustments produce $12,920 + $2,800 − $1,900 − $600 = $13,220. Corrected book cash remains $13,420. The remaining difference is $200 unresolved.
The packet doesn’t identify the debit’s date, reference or purpose. Request those details and the supporting bank or business record. The amount alone doesn’t tell us whether it’s a fee, a bank error, an unauthorized payment or something else. No additional book entry is justified by this fictional packet.
Subtracting $200 from books solely to make the totals equal would hide the unanswered question. It wouldn’t supply evidence. This branch deliberately has no finished reconciliation.
Keep a repeatable bank reconciliation corrections record
- Match the account and statement period.
- Compare each deposit and check with its recorded amount.
- Identify missing or incorrect book entries from supporting records.
- Keep unexplained differences visible and investigate them.
For a sheet modeled on this exercise, give each item its own row: original book amount, statement amount, document reference, supported correction, later clearing date and remaining question. Preserve the original entry alongside the correction so another reader can retrace the change.
Before using this cash figure in a forward-looking funding calendar, separately establish actual availability and future obligations. This completed-period exercise answers why two records differ; it doesn’t determine a borrowing request or a spending allowance.
Source checked October 21, 2026. All amounts, dates and transaction facts in the worked example are fictional.
Related reading
For a related question, read Invoice vs. Bank Payments: Find a $1,000 Double Count and Profitable Business, Falling Cash: Reconcile the Difference.


