Records and cash balances
Bank reconciliation: steps and a worked example
Bank reconciliation is a process of matching line by line the bank statement to the entries for the bank account in a business's books. The purpose of it is to:
- detect differences and book entries requiring adjustment;
- reconcile adjusted balances (they should be the same).
Differences can appear due to timing, missing fees and/or errors in recording. Do not make a random adjustment to balance the figures.
Use the same account and cutoff date
Use the same bank account and the same cutoff date:
- Take the bank statement, bank-account ledger, the previous bank reconciliation sheet and documents of receipts/payments.
- First compare the bank account and currency.
- Then use the cutoff date from the statement.
- Sending a customer invoice is a call for payment; it does not prove that money arrived in the bank account.
- For money processed via a payment processor, compare the amount actually settled and check any fees deducted separately.
Match transactions and explain the differences
- Check the opening position. Have funds left outstanding after the last bank reconciliation now cleared?
- Match receipts and payments. Date, amount, transaction reference and counterparty details should be checked. Do not just rely on amounts.
- List timing items. It may be a deposit already in the books that is not yet shown on the bank statement or a recorded payment not yet deducted by the bank.
- Identify book corrections. Check fees, interest, returned payments, duplicates and wrong amounts. Collect evidence on each difference.
- Calculate both adjusted balances. Make any supported book adjustments via the accounting process. Defer timing items for confirmation later. Do not repeat items that are already correctly recorded. Keep looking for explanations for unresolved differences.
A worked reconciliation table
Take, for example, these hypothetical numbers at the end of the month in US dollars. The bank statement does not yet reflect a $600 deposit recorded in your books. A $400 payment recorded in your books has not yet cleared. In your books, you have no entry for a $30 bank fee. Your actual payment was $150. You booked it wrongly as $100.
| Item | Bank side | Book side |
|---|---|---|
| Closing balance | $4,900 | $5,180 |
| You have a deposit in the books, but it is not yet on the bank statement | + $600 | Already booked. Do not book again. |
| You have a payment in the books, but it has not yet cleared | − $400 | Already booked. Do not deduct again. |
| In the books you do not have the bank fee | Already deducted | − $30 |
| You booked a $150 payment wrongly as $100 | Correctly deducted | Subtract another $50 |
| Adjusted balance | $5,100 | $5,100 |
Bank: $4,900 + $600 − $400 = $5,100. Books: $5,180 − $30 − $50 = $5,100.
The $600 and $400 items differ only in time of booking. There is no need to book them again if you booked them correctly.
Correct the records without hiding the cause
You should book the missing $30 fee in the corresponding expense and bank records. Fix the $50 understatement of the payment using original supporting papers, including the corresponding account. Keep the bank statement with evidence of receipts and payments. If a bank debit seems wrong, please clarify it first with the bank. Keep a separate record of how it was addressed. Do not book an unexplained debit as a business expense.
The reconciliation worksheet is mainly for verification purposes. You cannot substitute it for original supporting papers. Do not change the amount in a customer invoice to hide a bank difference. Partial receipts, processor fees and refunds require explanations and separate records.
Keep the completed reconciliation
Keep the account, period, statement, ledger, matched transaction references, outstanding items, approved adjustments (along with their reasons) and final calculation. You can match to monthly statements. If you have a lot of transactions, you can look more often. If possible, let someone else (who is also responsible) review the calculation.
Frequently asked questions
Do deposits in transit need another entry?
No, if the company has already entered them correctly. Put them on your reconciliation worksheet first and come back and look at later bank records.
What if the adjusted balances still differ?
Keep looking at missing/duplicate entries, signs, dates, starting balances and transaction references. Do not simply put in an unsupported number to balance the books. Learn where it went wrong first.
Does an invoice tracker reconcile the bank account?
Invoice trackers are useful for tracking what is owed by customers and what they have paid. But bank reconciliation is checking the ledger plus fees and other receipts/payments against what is in your bank statement. They serve different purposes.
Accounting reference
OpenStax: bank reconciliation and associated entries explains timing differences and book adjustments. The calculation table on this page uses independently chosen example figures.