How to do bank reconciliation: easy step-by-step guide

Published Tuesday 21 April 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• How often should you do bank reconciliation?
• How to do bank reconciliation step by step
• How to use bank reconciliation software
• Bank reconciliation problems and solutions
• Streamline your reconciliation process
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank account regularly — daily or weekly for busy businesses, monthly for quieter ones — so errors and unusual transactions are easier to spot and fix before they become bigger problems.
• Follow a consistent nine-step process that starts from your last matched balance, checks every deposit and withdrawal in both directions, and adjusts for timing differences like outstanding cheques or unrecorded bank fees.
• Use accounting software with automated bank feeds to match transactions automatically, cutting down on manual data entry and reducing the chance of mistakes.
• When balances don't match, check for common causes first — timing differences, unrecorded bank fees, or data entry errors — and work through transactions in date order to find the issue faster.

What is bank reconciliation?

Bank reconciliation is the process of matching transactions in your business's books with those on your bank statement. If you're operating a business through a partnership, company, or trust, you must have a separate bank account for that business. Think of it as a regular health check for your finances: it confirms your numbers are accurate, spots where they differ, and gives you a clear picture of your cash flow.

Why bank reconciliation matters

Regular bank reconciliation helps you feel confident in your financial data. By keeping your books and bank in sync, you can:

• Track cash flow accurately: Know exactly how much money you have available
• Spot issues early: Catch bank errors or fraudulent transactions before they escalate
• Make smarter decisions: Base business choices on real-time financial information
• Simplify tax time: Prepare for lodgement with clean, reliable records, noting that banking records need to be kept for five years from when they were prepared or obtained

How often should you do bank reconciliation?

The best frequency for bank reconciliation depends on your transaction volume.

• Daily or weekly: Ideal for high-volume businesses like retail or food services, where frequent reconciliation keeps the task manageable and helps you monitor cash flow closely
• Monthly: A common choice for businesses with fewer transactions, aligning with when you receive your bank statements

The key is consistency. The more often you reconcile, the quicker it is to spot and fix any issues.

How to do bank reconciliation step by step

Follow these nine steps to reconcile your bank account:

1. Get bank records

Gather these documents from your bank:

• Bank statements: Download from online banking or request paper copies
• Credit card statements: Include all business credit accounts
• Transaction lists: Export directly from your bank's website
• Automated feeds:Connect direct data transfer to your accounting software

2. Get business records

Collect these documents from your business:

• Accounting software: Access your digital ledger and transaction history
• Spreadsheets: Open your Excel or Google Sheets financial records
• Physical records: Gather logbooks, receipts and invoices
• Automated data: Review software that captures bills and receipts automatically

3. Find your starting point

Start from the last date when your business records matched your bank balance exactly. This opening balance becomes your reconciliation starting point, ensuring you only check new transactions since your last successful match.

4. Run through bank deposits

Check that each deposit on your bank statement appears as income in your accounts. If something is missing, enter it and categorise the source: a sale, interest, refund, or other income type.

5. Check the income on your books

Verify that each income entry in your books matches a deposit on your bank statement. If something is missing from the bank, investigate: the payment may have bounced, been deposited elsewhere, or not yet cleared.

6. Run through bank withdrawals

Check that each withdrawal on your bank statement appears as an expense in your accounts. This includes bank fees, direct debits, and automatic payments you may not have recorded yet.

7. Check the expenses on your books

Verify that each expense entry in your books matches a withdrawal on your bank statement. If something is missing from the bank, investigate: the payment may not have cleared, or you may have paid using cash or a different account.

8. Adjust for outstanding items

Account for transactions that appear in one record but not the other due to timing:

• Deposits in transit: Money you've recorded but the bank hasn't processed yet
• Outstanding cheques: Payments you've written that haven't cleared the bank
• Bank fees: Charges on your statement you haven't recorded in your books
• Interest earned: Bank credits you haven't entered into your accounts

These items explain why your balances may differ before you finish reconciling.

9. End balance

After checking all deposits, withdrawals, and adjustments, your business bank balance should match the totals in your accounts. Record this matched balance as the starting point for your next reconciliation.

How to use bank reconciliation software

Automated bank reconciliation eliminates the need to compare records manually and saves significant time. Modern accounting software offers:

• One-click matching: Pairs transactions between records automatically
• Smart suggestions: Identifies likely matches for your review
• Real-time updates: Syncs bank data directly into your accounting system
• Fewer errors: Minimises human mistakes in data entry

Most banks can send transaction data directly to accounting software through a secure online connection. When you reconcile, the software pulls up each bank transaction and either suggests a match with an entry in your accounts or asks you to categorise the transaction.

See Xero's bank reconciliation features.

Bank reconciliation problems and solutions

When amounts don't match during bank reconciliation, there's usually a simple reason. Common reasons include:

• Timing issues: Cheques written but not yet cleared
• Bank fees: Charges not yet recorded in your books
• Outstanding deposits: Money banked but not yet processed
• Data entry errors: Typos in amounts or transaction details

When your business books show transactions not on your bank statement

If a transaction in your books doesn't appear on your bank statement, check whether you received income that wasn't banked, or paid for something using cash or a different account. Note why this happened and adjust your records accordingly.

When your bank statement shows transactions not in your business books

If a transaction on your bank statement doesn't appear in your books, check for keystroke errors or transactions you forgot to enter. Add missing entries or correct errors to bring your records up to date.

Tips for resolving problems faster

Resolve issues faster with these practices:

• Reconcile weekly: Reduce mystery transactions and save time investigating
• Reconcile daily: Keep transactions fresh in your memory for high-volume businesses
• Block calendar time: Schedule uninterrupted time to reconcile
• Organise documents: Maintain easy access to invoices, receipts and transaction records
• Work chronologically: Check transactions in date order to spot patterns

Streamline your reconciliation process

Keeping your books in order can be straightforward. An efficient bank reconciliation process gives you a clear, up-to-date view of your finances, freeing you up to focus on running your business.

With smart tools that automate the heavy lifting, you can save time, reduce errors, and manage your money with confidence. Ready to make reconciliation easy? Get one month free on Xero pricing plans when you try Xero.

FAQs on bank reconciliation

Here are answers to some common questions about bank reconciliation.

What is the bank reconciliation formula?

The basic bank reconciliation formula is: Bank statement ending balance + deposits in transit − outstanding cheques = adjusted bank balance. This adjusted balance should match your book balance after accounting for unrecorded bank fees and errors.

How do I reconcile a bank account in Xero?

Connect your bank account to Xero via a secure feed. Transactions flow in automatically, and Xero suggests matches to your invoices and bills. Review each suggestion and click 'OK' to reconcile, turning hours of manual work into minutes.

What should I do if my balances never match?

Start by checking for data entry errors: look for transposed numbers, duplicates, or transactions you missed. If amounts still don't match, review your opening balance from the previous reconciliation. When you're still stuck, ask your accountant or bookkeeper to help identify the issue.

How far back should I go when starting reconciliation?

If you're starting from scratch, go back to the beginning of the financial year to ensure your records are accurate for tax purposes. The ATO requires you to keep banking records for five years, so do a thorough initial reconciliation.

Is daily reconciliation better than monthly?

Both approaches work well depending on your situation. Daily reconciliation suits high-volume businesses by keeping the task small and manageable. Monthly reconciliation works well for businesses with fewer transactions. Choose a schedule and stick to it.