Bank reconciliation: How to match your records and bank statements

Published Wednesday 22 April 2026

Table of contents

• What is bank reconciliation?
• Bank reconciliation formula
• How often should you reconcile your bank account?
• Bank reconciliation steps
• Bank reconciliation problems
• How to do bank reconciliation the easy way
• Best practices for efficient bank reconciliation
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank accounts at least once a month, but aim for weekly or daily checks if your business handles a high volume of transactions, so discrepancies are easier to spot and fix before they grow.
• Use the bank reconciliation formula to calculate your adjusted bank balance and adjusted book balance, accounting for timing differences like deposits in transit, outstanding cheques, bank fees, and bounced cheques, until both figures match.
• Investigate any transaction that appears in your books but not on your bank statement, or vice versa, as common causes include unrecorded bank fees, missing entries, or payments made from a different account.
• Use accounting software to automate transaction matching and cut manual reconciliation work by up to 75%, reducing human error and completing the process in minutes rather than hours.

What is bank reconciliation?

Bank reconciliation is the process of matching your business's accounting records to your bank statement. The goal is to find differences between the two and correct your records as needed. It's a core part of keeping your financial books accurate.

You need to keep all your business records for seven years after the end of the financial year they relate to.

Why bank reconciliation matters for small business

Regular bank reconciliation helps you stay on top of your finances and catch problems early. Key benefits include:

• Cash flow visibility: Track exactly how much money you have available
• Error detection: Spot bank mistakes or unauthorised transactions quickly
• Reliable reports: Ensure your financial statements reflect reality
• Easier tax time: Accurate records simplify filing, especially for the New Zealand financial year running 1 April to 31 March

Bank reconciliation formula

The bank reconciliation formula calculates your adjusted bank balance to compare against your books. Here's how it works:

Adjusted bank balance = Bank statement ending balance + deposits in transit − outstanding cheques

Adjusted book balance = Book balance + interest earned − bank fees − bounced cheques

When both adjusted balances match, your reconciliation is complete.

Common reconciling items include:

• Deposits in transit: Money you've deposited that hasn't appeared on your statement yet
• Outstanding cheques: Cheques you've written that recipients haven't cashed
• Bank fees: Service charges or transaction fees deducted by your bank
• Interest earned: Interest credited to your account
• Bounced cheques: Customer payments that failed to clear

Understanding these timing differences helps you identify why your balances might not match initially.

How often should you reconcile your bank account?

Reconcile your bank accounts at least once a month, though weekly or daily is better for most small businesses.

The more frequently you reconcile, the easier it is to catch discrepancies and remember what each transaction was for. Higher transaction volumes benefit from more frequent checks. Recent transactions are easier to recall and categorise, and you can resolve problems quickly before they multiply.

Bank reconciliation steps

Following a consistent process helps you catch errors, prevent fraud, and keep your records accurate. Here's how to reconcile your accounts:

Check out Xero's bank reconciliation features.

Bank reconciliation problems

Discrepancies are normal and usually have simple explanations. Bank reconciliation helps you spot and fix these differences early, keeping your records accurate.

Business books show something that's not on your bank statement

If a transaction appears in your books but not on your bank statement, common causes include:

• Unbanked income: Cash or cheques you received but haven't deposited
• Different account: Payment made from another bank account
• Cash payment: Expense paid with cash instead of bank transfer

Investigate the cause and update your records accordingly.

Bank statement shows something that's not in your business books

If a transaction appears on your bank statement but not in your books, common causes include:

• Data entry error: Incorrect amount or date when recording
• Missing entry: Transaction you forgot to record
• Bank fees: Automatic charges you haven't accounted for

Review the transaction details and make the required corrections.

How to do bank reconciliation the easy way

Accounting software can reduce manual reconciliation work by up to 75%. Instead of comparing documents line by line, software matches transactions automatically and flags discrepancies for your review.

Benefits of automated reconciliation:

• Time savings: Complete reconciliation in minutes, not hours
• Accuracy: Reduce human error through automated matching
• Real-time updates: Connect directly to your bank for instant data

Understanding how the automation process works can help you get the most from your software.

How automated bank reconciliation works

Bank reconciliation software connects securely to your bank and automates the matching process:

1. Secure connection: Software links to your bank through encrypted feeds
2. Transaction import: Bank data flows automatically into your accounting system
3. Smart matching: Software suggests matches between bank and business records
4. Manual review: You approve matches or categorise unmatched items

Once set up, most transactions match automatically, leaving you to handle only the exceptions.

Best practices for efficient bank reconciliation

Schedule regular reconciliation to maintain accurate records with minimal effort.

Recommended frequency:

• High transaction volume: Daily or weekly reconciliation
• Moderate activity: Weekly or fortnightly reconciliation
• Lower volume: Monthly reconciliation minimum

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

What happens if my bank reconciliation doesn't balance?

If your reconciliation doesn't balance, review your entries for data entry errors, missing transactions, or timing differences. Check for deposits in transit, outstanding cheques, and bank fees you haven't recorded yet.

Can I reconcile my bank accounts myself?

Yes, you can reconcile your bank accounts yourself using accounting software or spreadsheets. Many small business owners handle their own reconciliation, especially with automated tools that simplify the process.

How long should bank reconciliation take?

With accounting software, bank reconciliation typically takes 10 to 30 minutes per account per month. Manual reconciliation can take several hours depending on transaction volume.

What documents do I need for bank reconciliation?

You need your bank statements and your business accounting records. This includes your general ledger, cash book, or accounting software records that show all income and expenses.