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
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:
- A deposit of 1,820.00 made on the last day of the month is in the ledger but not yet on the statement.
- Cheque 1043 for 640.00 and cheque 1046 for 215.50 were written but have not cleared.
- The bank charged a monthly service fee of 28.00 that is not in the ledger.
- A customer’s cheque for 175.00 was deposited and then returned unpaid. The bank deducted it, but the ledger still counts it.
- The bank paid interest of 15.50 that is not in the ledger.
| Bank statement side | Amount |
|---|---|
| Balance per bank statement | 12,450.00 |
| Add: deposit in transit | 1,820.00 |
| Less: cheque 1043 | (640.00) |
| Less: cheque 1046 | (215.50) |
| Adjusted bank balance | 13,414.50 |
| Ledger (books) side | Amount |
|---|---|
| Balance per ledger | 13,602.00 |
| Add: interest earned | 15.50 |
| Less: bank service fee | (28.00) |
| Less: returned customer cheque | (175.00) |
| Adjusted book balance | 13,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
- Fix the period. Use the statement’s start and end dates and compare the same period in your ledger.
- 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.
- Tick off matching items. Mark each transaction that appears in both the statement and the ledger.
- 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.
- Prepare the statement in the format above, then record the book-side adjustments in your ledger.
- Confirm the two adjusted balances agree and keep the statement with the supporting PDF.
Common reasons the balances differ
- Deposits in transit and outstanding cheques (timing).
- Bank fees, interest and returned items not yet in the ledger.
- A transposed number, such as recording 540.00 as 450.00.
- A transaction entered twice, or not at all.
- A sign error, where a withdrawal was entered as a deposit. The difference is then twice the transaction amount.
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.