BankStatementDesk

Bank reconciliation statement: format, example and how to prepare one

A bank reconciliation statement explains why the balance in your accounting records differs from the balance on your bank statement, and shows that the two agree once the differences are accounted for. The differences are usually timing (a cheque you wrote has not cleared yet) or items the bank recorded before you did (a monthly fee). This guide shows the standard format, a worked example with real numbers, and a repeatable way to prepare one.

In this guide
  1. The standard format
  2. A worked example
  3. How to prepare it step by step
  4. Common reasons the balances differ
  5. Using a spreadsheet and the free tools

The standard format

There are several layouts. The one below adjusts both sides to the same true balance, and it is the version most people meet first. Use whichever layout your accountant or software expects.

Bank side. Start with the balance on the bank statement. Add deposits in transit (money you recorded but the bank has not yet credited). Subtract outstanding cheques or payments (recorded by you, not yet paid by the bank). Correct any bank error. The result is the adjusted bank balance.

Book side. Start with the balance in your cash book or ledger. Add items the bank credited that you have not recorded, such as interest or a customer’s direct deposit. Subtract items the bank deducted that you have not recorded, such as service fees or a returned (bounced) cheque. Correct any bookkeeping error. The result is the adjusted book balance.

The reconciliation is complete when the adjusted bank balance equals the adjusted book balance.

A worked example

A business’s statement for the month shows a closing balance of 12,450.00. Its ledger cash account shows 13,602.00. Comparing the two lists of transactions turns up these differences:

Bank statement sideAmount
Balance per bank statement12,450.00
Add: deposit in transit1,820.00
Less: cheque 1043(640.00)
Less: cheque 1046(215.50)
Adjusted bank balance13,414.50
Ledger (books) sideAmount
Balance per ledger13,602.00
Add: interest earned15.50
Less: bank service fee(28.00)
Less: returned customer cheque(175.00)
Adjusted book balance13,414.50

Both sides arrive at 13,414.50, so the account is reconciled. The bank-side items (deposit in transit, outstanding cheques) need no ledger entry because the bank will catch up on its own. The book-side items (interest, fee, returned cheque) do need entries in the ledger so that it shows the true balance.

How to prepare it step by step

  1. Fix the period. Use the statement’s start and end dates and compare the same period in your ledger.
  2. Confirm the opening balance. The statement’s opening balance should equal last month’s closing bank balance. If it does not, last month’s reconciliation was not finished.
  3. Tick off matching items. Mark each transaction that appears in both the statement and the ledger.
  4. List what is left. Unmatched statement lines are usually fees, interest or deposits you have not recorded. Unmatched ledger lines are usually deposits in transit and outstanding cheques.
  5. Prepare the statement in the format above, then record the book-side adjustments in your ledger.
  6. Confirm the two adjusted balances agree and keep the statement with the supporting PDF.

Common reasons the balances differ

If the remaining difference is exactly twice a transaction’s amount, look for a sign error. If it is divisible by 9, look for a transposed number. These are rules of thumb, not guarantees.

Using a spreadsheet and the free tools

Most of the effort is getting the statement into a spreadsheet and matching rows. The free bank statement to Excel converter turns a digital PDF into rows you can review in your browser, and the balance checker traces the running balance to find where a difference begins. The reconciliation tool helps match statement activity against your ledger. If the totals still do not agree, read why a converted statement won’t balance.

Accounting practice and rules differ by country and business type. Treat this guide as an explanation of the method and follow your accountant’s requirements for your own records.