What is bank reconciliation? Steps, problems and tips

Published Saturday 7 March 2026

Table of contents

• What is bank reconciliation?
• Bank reconciliation steps
• Common bank reconciliation problems and how to fix them
• How to use bank reconciliation software
• Bank reconciliation best practices
• How Xero simplifies bank reconciliation
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank accounts weekly or daily rather than monthly to catch errors faster, keep each session shorter, and make transactions easier to remember and investigate.
• Follow the systematic eight-step process starting with gathering your bank and business records, then methodically checking deposits and withdrawals in both directions to ensure every transaction matches.
• Use accounting software with automatic bank feeds to reduce manual work significantly, as it can cut reconciliation time from several hours to just 15-30 minutes for most small businesses.
• Investigate common discrepancies systematically by checking for cash transactions, different accounts, timing delays, forgotten entries, data entry errors, and bank fees when your records don't match your bank statement.

What is bank reconciliation?

Bank reconciliation is the process of comparing your business's financial records against your bank statement to make sure they match. It confirms that the cash balance in your books reflects the actual cash in your bank account.

Reconciling regularly helps you:

• Catch errors: spot data entry mistakes, duplicate entries, or missed transactions
• Detect fraud: identify unauthorised withdrawals or suspicious activity early. According to the Association of Certified Fraud Examiners (ACFE), regular reconciliation helps reduce fraud losses and speeds up detection. Typical organisations lose 5% of revenue to fraud annually.
• Understand your cash position: know exactly how much money you have available
• Prepare for tax time: keep accurate records that make reporting easier

Most businesses reconcile monthly. Government accounting standards support this frequency and require reconciliation at least monthly. However, weekly or daily reconciliation helps you catch issues faster and keeps each session short.

Bank reconciliation steps

Follow these eight steps to reconcile your bank account and verify your business numbers are accurate.

1. Get your bank records. Download or print your bank statement, or connect your bank directly to your accounting software. Include all accounts you use for business, such as current accounts and credit cards.
2. Get your business records. Open your ledger of income and expenses. This might be a logbook, spreadsheet, or accounting software.
3. Find your starting point. Identify the last date when your book balance matched your bank balance. Starting from a known match makes it easier to spot new discrepancies.
4. Check bank deposits against your records. Confirm each deposit appears as income in your books. If something is missing, add it and categorise it as a sale, interest, refund, or other income type.
5. Check income entries in your books. Each recorded income should match a bank deposit. If a deposit is missing from your statement, investigate whether a payment bounced or you deposited it elsewhere.
6. Check bank withdrawals against your records. Confirm every withdrawal appears in your books. Look for bank fees, automatic payments, and other charges you still need to record.
7. Check expense entries in your books. Each recorded expense should match a bank withdrawal. If a withdrawal is missing, check whether the payment is still pending or you made it from a different account. Banks may consider cheques older than 90 to 180 days 'stale', meaning they never clear.
8. Confirm your ending balance. After checking all deposits and withdrawals, your book balance should match your bank balance. Record this date as the starting point for your next reconciliation.

Common bank reconciliation problems and how to fix them

Mismatches between your records and bank statement are normal. Finding and fixing them is exactly why you do bank reconciliation. Most discrepancies have straightforward explanations.

Your books show a transaction that's not on your bank statement

This usually means the money moved outside your bank account. Common causes include:

• Cash transactions: you received or paid cash outside the bank
• Different account: the transaction went through a different bank account
• Timing: the transaction is still clearing through the bank. For example, some electronic transfers can take three working days to settle.

Check your records, identify the cause, and update your notes accordingly.

The opposite situation can also occur.

Your bank statement shows a transaction that's not in your books

This usually means you missed a transaction or entered it incorrectly. Common causes include:

• Forgotten entries: a transaction was missed when it happened
• Data entry errors: a typo caused the amounts to differ
• Bank fees: automatic charges that slipped past your notice

Review the transaction, identify the cause, and add or correct the entry in your books.

Once you understand common causes, you can resolve issues efficiently.

Tips for fixing mismatches quickly

Tracking down discrepancies takes less time when you reconcile regularly. Here's how to speed up the process:

• Reconcile weekly or daily: recent transactions are easier to remember and investigate
• Keep records organised: store invoices, receipts, and emails where you can find them quickly
• Note unusual transactions: add comments to entries that might need explanation later
• Fix errors immediately: correct mistakes as soon as you find them to avoid confusion later

Software can streamline the entire process.

How to use bank reconciliation software

Bank reconciliation software automates the matching process, reducing manual work and the risk of errors. For example, the International Monetary Fund noted that one country reduced workloads by an estimated two and a half people after implementing an automated tool.

Most banks send transaction data directly to accounting software like Xero through a secure connection. When you reconcile, the software pulls up each transaction and either:

• suggests a match with a corresponding entry in your accounts, or
• asks what the transaction was for and enters the information automatically

Building good habits keeps the process manageable long term.

Bank reconciliation best practices

Reconcile frequently to keep the process quick and manageable. The longer you wait, the more transactions pile up and the harder it becomes to remember details.

Here's how to build a maintainable reconciliation habit:

• Set a regular schedule: reconcile weekly or daily, depending on your transaction volume
• Block time in your calendar: treat reconciliation as a recurring appointment
• Organise your records: keep invoices, receipts, and statements where you can access them quickly
• Use software to automate: bank feeds and smart matching reduce manual work significantly

Regular reconciliation catches errors early, keeps your cash position accurate, and makes tax time less stressful.

The right tools can make reconciliation even easier.

How Xero simplifies bank reconciliation

Xero's automated bank reconciliation features help you save time and maintain accurate records with less manual effort.

Here's how Xero makes reconciliation easier:

• Automatic bank feeds: transactions flow directly from your bank into Xero daily
• Smart matching: Xero suggests matches between bank transactions and your recorded invoices or bills
• One-click reconciliation: confirm matches with a single click instead of entering data manually
• Mobile access: reconcile on the go from your phone or tablet
• Real-time view: see your cash position at any time, including between reconciliations

Whether you reconcile daily or weekly, Xero reduces the time and effort involved. See how much time you can save: get one month free and try Xero's bank reconciliation today.

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

How often should I do bank reconciliation?

Most businesses reconcile monthly, but weekly or daily reconciliation catches errors faster and keeps each session shorter. Choose a frequency that matches your transaction volume.

What do I do if my bank reconciliation doesn't balance?

Review your entries for data entry errors, missing transactions, or duplicates. Check for bank fees, pending transactions, or payments you made from a different account.

Do I need accounting software to do bank reconciliation?

You can reconcile manually using spreadsheets or paper records. However, accounting software with bank feeds automates much of the process and reduces errors.

What is the journal entry for bank reconciliation?

Bank reconciliation is complete without a journal entry. However, you may need to adjust entries for bank fees, interest, or errors you discover during reconciliation.

How long does bank reconciliation take?

Manual reconciliation can take several hours monthly, depending on transaction volume. With accounting software and bank feeds, most small businesses complete reconciliation in 15 to 30 minutes. Modern AI-powered tools can speed this up even more, with processing times for bank statements as fast as 1–8 seconds per page.