How to do bank reconciliation in 8 practical steps

Published Monday 30 March 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• Bank reconciliation steps
• How to use bank reconciliation software
• Bank reconciliation problems
• Common bank reconciliation mistakes to avoid
• Best practices for efficient bank reconciliation
• Bank reconciliation made simple with Xero
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank accounts weekly or daily rather than monthly to catch errors and fraud early, as many banks limit error resolution to 60 days after transactions occur.
• Follow the eight-step process systematically by gathering bank records and business records, then checking deposits, income, withdrawals, and expenses to ensure every transaction matches between your books and bank statement.
• Use accounting software with automatic bank feeds to connect directly to your bank and automate the matching process, turning hours of manual reconciliation into minutes.
• Investigate all discrepancies thoroughly, including missing bank fees, unrecorded cash transactions, timing differences, and data entry errors, as small mismatches can signal larger underlying issues.

What is bank reconciliation?

Bank reconciliation is the process of matching your business records against your bank statement to make sure they agree. It confirms that every transaction in your books has a corresponding entry at the bank, and vice versa.

Think of it as a regular check-up for your finances. You're verifying that what you recorded actually happened, catching any errors before they become bigger problems.

Why bank reconciliation matters

Regular bank reconciliation helps you catch errors early, prevent fraud, and maintain accurate financial records. For small businesses, this helps you make confident decisions and stay prepared for tax time.

Here's why it matters:

• Error detection: spot data entry mistakes, duplicate payments, or missing transactions before they compound. This is critical because many banks limit error resolution to 60 days after the transaction, making it impossible to fix old mistakes.
• Fraud detection: identify unauthorised charges or suspicious activity early. According to the Association of Certified Fraud Examiners (ACFE), many asset misappropriation schemes involve reimbursement claims for fictitious or inflated expenses, which regular reconciliation can help uncover.
• Cash flow visibility: know exactly how much money you have available
• Tax preparation: maintain accurate records that make filing faster and reduce audit risk
• Stakeholder trust: show lenders, investors, or partners that your books are reliable

Bank reconciliation steps

Follow these eight steps to complete a thorough bank reconciliation.

1. Get bank records

You need a list of transactions from your bank. Here's where to get them:

• Bank statement: download from online banking or request a paper copy
• Credit card statement: gather this separately if you use a business credit card
• Automatic bank feed: connect your bank directly to accounting software like Xero for real-time data

1. Get business records

Open your ledger of income and outgoings. Your business records might be in:

• A logbook: manual records of transactions
• A spreadsheet: digital tracking of income and expenses
• Accounting software: platforms like Xero that automatically pull in bills and receipts

1. Find your starting point

Identify the last time your business books and bank account showed the same balance. This is your starting point: the last confirmed reconciliation. Begin your current reconciliation from this date and work forward through new transactions.

1. Run through bank deposits

Check that each bank deposit appears in your accounts. If something is missing, add it and categorise it correctly:

• Sales revenue: payments from customers for products or services
• Interest income: interest earned on your account
• Refunds: returns from suppliers or vendors
• Other income: transfers, grants, or miscellaneous deposits

1. 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, investigate:

• Bounced payment: the customer's cheque or payment was returned
• Pending deposit: the transaction hasn't cleared yet
• Recording error: the income was logged to the wrong date or account

1. Run through bank withdrawals

Check that all bank withdrawals appear in your books. Commonly missed items include:

• Bank fees: monthly service charges, transaction fees, or overdraft charges
• Automatic payments: subscriptions, loan repayments, or recurring bills
• Interest charges: credit card or loan interest
• Foreign exchange fees: charges for international transactions

1. Check the expenses on your books

You should be able to trace cash expenses paid from the bank account to withdrawals on the bank statement, allowing for timing differences and payment method. If something is missing, investigate:

• Outstanding payment: the transaction hasn't cleared yet
• Different payment method: you paid using cash or a different account
• Recording error: the expense was logged incorrectly

1. End balance

After you record necessary adjustments and account for timing differences, your adjusted bank balance and adjusted book cash balance should match. This will be the starting point for your next reconciliation.

How to use bank reconciliation software

Accounting software can turn hours of manual reconciliation into minutes. Instead of switching between documents and comparing numbers line by line, software automates the matching process and flags discrepancies for you.

Bank reconciliation software connects directly to your bank and automates the matching process. Here's how it works in Xero:

• Automatic import: your bank sends transaction data through a secure connection
• Smart matching: the software suggests matches with entries already in your accounts
• Quick categorisation: you select what new transactions were for and the software records them

Bank reconciliation problems

Discrepancies are amounts that appear in one set of records but not the other. Identifying them is exactly why you do bank reconciliation. Most mismatches have straightforward explanations once you investigate.

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

If a transaction isn't showing on your bank statement, check for these common causes:

• Unbanked income: cash or cheques received but not yet deposited
• Different account: payment made from another bank account or credit card
• Cash payment: expense paid with cash that bypassed your bank account

Note the reason and update your records accordingly.

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

If a transaction isn't showing in your business books, check for these common causes:

• Data entry error: keystroke mistake when recording the original transaction
• Missing entry: transaction you forgot to record
• Bank fees: automatic charges like service fees or interest that you haven't logged

Make the required corrections and update your records.

Common bank reconciliation mistakes to avoid

Avoiding common mistakes makes bank reconciliation faster and more accurate. Watch out for these pitfalls:

• Waiting too long between reconciliations: delaying this task means more transactions to review and harder-to-trace discrepancies. In fact, some official guidelines require businesses to reconcile every account at least monthly.
• Ignoring small differences: small mismatches can signal larger underlying issues or compound over time. While a few cents might seem trivial, auditors determine what is material by calculating percentages of key accounts, so even seemingly minor errors could become significant.
• Forgetting bank fees: you often miss automatic charges like service fees, interest, or foreign exchange fees
• Not recording cash transactions: cash payments and deposits bypass your bank but still need to appear in your books
• Skipping the final check: always confirm your ending balance matches before moving on
• Using outdated statements: reconcile with the most recent bank data to avoid working with incomplete information

Best practices for efficient bank reconciliation

Reconciling weekly or daily helps you avoid searching through records for mismatches. When transactions are fresh in your memory, you can identify and resolve discrepancies faster.

Here are best practices to keep the process quick and manageable:

• Set a schedule: reconcile weekly or daily rather than monthly
• Organise your records: create a system to access bank statements and receipts quickly
• Use software: automate matching to reduce time per transaction

Bank reconciliation made simple with Xero

Bank reconciliation can be quick and straightforward. With the right approach and tools, automated reconciliation saves you significant time.

You can connect directly to your bank accounts, automatically import transactions, and get suggested matches. You spend less time on admin and more time running your business. Get one month free and see how much time you can save.

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

What is the formula for bank reconciliation?

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

What is a three-way bank reconciliation?

Three-way reconciliation compares three records: your bank statement, your general ledger, and a third source like a sub-ledger or accounts receivable. It's commonly used in trust accounting or when managing multiple accounts.

How long does bank reconciliation take?

Reconciliation time depends on transaction volume and frequency. Daily reconciliation might take 10–15 minutes, while monthly reconciliation for a busy account could take several hours. Using software significantly reduces this time.

How often should I do bank reconciliation?

For best results, reconcile as frequently as your transaction volume requires. Reconciling more frequently means fewer transactions to review, fresher memory of details, and faster ability to identify discrepancies.

Do I need to reconcile credit card accounts too?

Yes. Reconcile any account used for business transactions, including credit cards, PayPal, and other payment platforms. This ensures you record all expenses accurately in your books.

Xero does not provide accounting, tax, business or legal advice. This guide provides information only. You should consult your own professional advisors for advice directly relating to your business or before taking action in relation to any of the content provided.