Skip to content
Pocket Invoice: Free Invoice MakerFree Invoice Maker

Records and cash balances

Bank reconciliation: steps and a worked example

Definition

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.

Pocket Invoice Editorial Team · Updated

Use the same account and cutoff date

Use the same bank account and the same cutoff date:

Match transactions and explain the differences

  1. Check the opening position. Have funds left outstanding after the last bank reconciliation now cleared?
  2. Match receipts and payments. Date, amount, transaction reference and counterparty details should be checked. Do not just rely on amounts.
  3. 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.
  4. Identify book corrections. Check fees, interest, returned payments, duplicates and wrong amounts. Collect evidence on each difference.
  5. 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.

ItemBank sideBook side
Closing balance$4,900$5,180
You have a deposit in the books, but it is not yet on the bank statement+ $600Already booked. Do not book again.
You have a payment in the books, but it has not yet cleared− $400Already booked. Do not deduct again.
In the books you do not have the bank feeAlready deducted− $30
You booked a $150 payment wrongly as $100Correctly deductedSubtract 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.