Tabellab
Accounting & financial statements

Bank reconciliation example: step by step, with journal entries

A bank reconciliation explains why the balance on the bank statement differs from the cash balance in your books on the same date, and finds the true cash figure. This bank reconciliation example covers every common item: a deposit in transit, three outstanding checks, interest, a bank charge, a customer check returned unpaid (NSF) and a transposition error in the books. The bank statement shows $18,452.30 and the books $18,784.15, and after the adjustments both sides agree at $17,651.55. Then it shows which items need a journal entry and which do not.

Updated 19 Oct 2026 6 min read By Tabellab team

Why the two balances differ

The bank and your books record the same transactions, but not at the same time and not always with the same information. Every difference falls into one of two groups:

  • The books know it, the bank does not yet. Deposits in transit and outstanding checks. These are timing differences, and they adjust the bank side.
  • The bank knows it, the books do not yet. Bank charges, interest, direct debits, customer checks returned unpaid, and errors in your own records. These adjust the book side and need journal entries.

Errors made by the bank are rare but possible. They go on the bank side and you ask the bank to correct them.

Step 1: adjust the bank balance

Start with the balance per bank statement, $18,452.30. Add deposits in transit: the $3,615.00 paid in on the last afternoon of September is in the books but reaches the bank statement only in October. Subtract outstanding checks: checks #2207, #2211 and #2214, $4,415.75 in total, were written and recorded but have not yet been cashed by the payees.

Adjusted bank balance = 18,452.30 + 3,615.00 − 4,415.75 = 17,651.55

To find the items, tick off every deposit and every check in the cash account against the statement. Whatever is in the books but not on the statement is in transit or outstanding. Check last month's reconciliation too: an outstanding check from August that still has not cleared stays on the list.

Step 2: adjust the book balance

Start with the balance per books, $18,784.15, and work through the statement for items you have not recorded:

  • Add interest earned, $12.40, credited by the bank.
  • Subtract the bank service charge, $35.00.
  • Subtract the NSF check, $480.00. A customer's check you deposited bounced, so the bank took the money back. The customer still owes it.
  • Correct the book error. Check #2203 was written and cleared for $1,920.00 but entered in the books as $1,290.00. The books show $630.00 too much cash, so subtract the difference.

Adjusted book balance = 18,784.15 + 12.40 − 35.00 − 480.00 − 630.00 = 17,651.55

Step 3: prove that both sides agree

The adjusted bank balance and the adjusted book balance must be identical, here both $17,651.55, so the difference cell shows 0. That figure is the cash you report on the balance sheet. If the two do not agree, look for the classic causes before you force a plug:

  • A difference divisible by 9 often points to a transposition, as with 1,290 and 1,920: the gap of 630 is 9 × 70.
  • A difference equal to one item, or twice one item, suggests it was missed or entered with the wrong sign.
  • An item from last month's list that cleared this month but was not taken off.

Worked example: Harbor Lane Studio, 30 September 2026

The top half adjusts the bank balance, the middle the book balance, and the bottom lists the journal entries for the book-side items. The business and its figures are fictional.

Worked example: Harbor Lane Studio, 30 September 2026
ABCDFormula in D
1Harbor Lane Studio, bank reconciliation, 30 Sep 2026USD
2Balance per bank statement18,452.30
3Add: deposit in transit (paid in on 30 Sep)3,615.00
4Less: outstanding checks
5 Check #22071,240.00
6 Check #2211865.75
7 Check #22142,310.00
8Adjusted bank balance17,651.55=D2+D3-SUM(D5:D7)
9
10Balance per books (Cash account)18,784.15
11Add: interest earned12.40
12Less: bank service charge35.00
13Less: NSF check from a customer, returned unpaid480.00
14Check #2203 as recorded in the books1,290.00
15Check #2203 as paid by the bank1,920.00
16Less: error on check #2203630.00=D15-D14
17Adjusted book balance17,651.55=D10+D11-D12-D13-D16
18Difference (must be 0)0.00=D8-D17
19
20Journal entry (30 Sep)DebitCreditAmount
21Interest earnedCashInterest income12.40=D11
22Bank service chargeBank chargesCash35.00=D12
23NSF checkAccounts receivableCash480.00=D13
24Error on check #2203Accounts payableCash630.00=D16
25Cash after the entries17,651.55=D10+D21-D22-D23-D24
Yellow cells are inputs, green cells are formulas. Hover a result to see its formula.

Only rows 21 to 24 become journal entries. The deposit in transit and the outstanding checks clear at the bank on their own.

Step 4: record the journal entries

Only the book-side items get journal entries, because only they change what you know about your cash:

  • Interest: debit Cash, credit Interest income, $12.40.
  • Bank charge: debit Bank charges (an expense), credit Cash, $35.00.
  • NSF check: debit Accounts receivable, credit Cash, $480.00. The receivable is back, and you follow up with the customer. If the bank also charged a returned-check fee, record it like any other bank charge, and many businesses pass that fee on to the customer.
  • Error on check #2203: debit Accounts payable, credit Cash, $630.00. The check paid a supplier invoice, so the supplier balance was reduced by too little.

After posting, the cash account shows $17,651.55, the same as the reconciliation. Deposits in transit and outstanding checks need no entry: they are already in the books and clear at the bank on their own in the next few days. The corrected cash balance then flows into the trial balance.

How often to reconcile, and who should do it

At least monthly, when the statement arrives, and as part of every month-end close. Businesses with many transactions reconcile weekly or even daily, which accounting software makes easy by matching bank feed lines to ledger entries. For internal control, the person who reconciles should not be the one who writes checks or records cash receipts. Old outstanding checks and unexplained differences are early signs of errors or fraud, so investigate them instead of carrying them forward month after month.

Common mistakes

  • Adding outstanding checks instead of subtracting them. The bank still has the money the checks will take away. They reduce the bank balance.
  • Putting items on the wrong side. Deposits in transit and outstanding checks adjust the bank balance. Charges, interest, NSF checks and book errors adjust the book balance.
  • Booking entries for timing differences. Outstanding checks and deposits in transit are already recorded. An entry would count them twice.
  • Forgetting last month's outstanding items. A check outstanding in August that has not cleared yet must stay on September's list.
  • Treating an NSF check as a bank expense. The customer still owes the money, so it goes back to accounts receivable.
  • Plugging the difference. An unexplained difference booked to a suspense or miscellaneous account hides errors. Find the cause first.

Frequently asked questions

What is a deposit in transit?

Money you have recorded as deposited but that the bank has not yet credited by the statement date, for example a deposit made on the last afternoon of the month. It is added to the bank balance on the reconciliation.

Do outstanding checks need a journal entry?

No. They were recorded when the checks were written. Only the bank has not processed them yet, so they are a timing difference that clears by itself.

Which items in a bank reconciliation need journal entries?

Only the book-side items: bank charges, interest earned, NSF checks, direct debits or credits you did not know about, and errors in your own records.

What is an NSF check in a bank reconciliation?

A customer's check that bounced because the account did not have sufficient funds. The bank removes the amount from your account, so you subtract it from the book balance and debit accounts receivable, because the customer still owes you.

Practise it in a lab

Related guides

Reading is step one. Doing is step two.

Every guide links to a lab where you build the same calculation in an online spreadsheet and get instant feedback.

Open the lab