How to reconcile your business bank account

What bank reconciliation is and why it matters

Bank reconciliation is the process of comparing every transaction in your accounting software against every transaction on your bank statement, and confirming that the closing balance on both is the same. The comparison runs in both directions: every entry in your books should appear on the statement, and every entry on the statement should be in your books.

When these don't agree, something has gone wrong: a transaction was entered twice, a payment wasn't recorded, a bank fee was missed, or — occasionally — a fraudulent transaction has appeared. Reconciling monthly catches these early, while the amounts are small and the memory of what happened is fresh. Leaving it for a year means untangling a year's worth of discrepancies in one go, which is where significant errors and write-offs tend to surface. Any lender looking at your management accounts or bank statements will expect a reconciled position — unreconciled books undermine confidence in every other figure you present.

Step by step: how to reconcile

The process is the same whether you use Xero, QuickBooks, Sage or a spreadsheet. Do it at the end of each month, using the final bank statement for that month:

1. Get the bank statement. The closing balance as at the last day of the month is your target figure.
2. Open the bank reconciliation in your accounting software. Most packages have a dedicated reconciliation screen that lists unmatched transactions.
3. Import or enter bank transactions. If you use bank feeds, the software will have pulled most transactions automatically. Review and categorise any uncategorised items.
4. Match each bank entry to an entry in your books. When both sides agree, mark it as matched. Invoices cleared, payments made, bank charges, and direct debits should all find a counterpart.
5. Investigate unmatched items. Anything left unmatched on either side is an error or an omission. Enter missing transactions, correct duplicates, and reconcile until the balance agrees.
6. Confirm the closing balance. When all transactions are matched and the software's reconciled balance equals the bank statement closing balance, the reconciliation is done. Save or lock it.

Common reasons for mismatches

Most discrepancies fall into a small set of categories. Working through them systematically gets every reconciliation done:

• Bank feeds missing a transaction — bank fees, interest, or a direct debit not yet pulled through. Add it manually, coded to the right account.
• Duplicate entry — a transaction entered manually and then also imported via the feed. Delete the duplicate.
• Timing difference — a cheque or BACS payment your books show but that hasn't cleared the bank yet. Leave it as an outstanding item; it will appear on next month's statement.
• Categorisation error — a transaction matched in the previous month to the wrong account. Correct the coding and it will drop off the unmatched list.
• Currency rounding — small differences on foreign-currency transactions due to exchange-rate rounding. Most software handles this automatically.

If you cannot identify the cause of a difference after checking the above, check for a possible duplicate or reversed transaction, and consider whether a payment was received or made that was never recorded in the books at all.

What to do with the reconciled accounts

A completed, locked monthly reconciliation becomes part of your financial record. Keep the reconciliation confirmation alongside each month's bank statement so there is a clear audit trail. Many accounting packages let you attach the statement PDF directly to the completed reconciliation — use that feature.

Once reconciled, your bank balance in the accounting system is reliable, which means your management accounts are reliable, and your cash-flow forecast starting position is solid. Banks and lenders can see unreconciled books in a management-accounts pack — vague or inconsistent figures trigger more questions and slower decisions. A clean, reconciled position is one of the fastest, cheapest things you can do to improve the quality of your financial reporting. See our guides on preparing management accounts and forecasting cash flow for how this feeds into wider financial management.