How to do bank reconciliation: 8 steps for your business

Published Monday 26 October 2026

Table of contents

• What is bank reconciliation?
• Why bank reconciliation matters
• Bank reconciliation steps
• Bank reconciliation example for a Malaysian business
• Common bank reconciliation problems
• How to fix bank reconciliation discrepancies
• How to do bank reconciliation the easy way
• How to use bank reconciliation software
• How often should you reconcile your accounts?
• Simplify bank reconciliation with Xero
• FAQs on bank reconciliation

Key takeaways

• Reconcile your bank accounts weekly or daily to catch errors early, detect fraud quickly, and make troubleshooting faster since you'll remember recent transactions more clearly.
• Follow a systematic eight-step process starting with gathering your bank statement 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 cut down manual work, as it imports transactions automatically and matches them for you while flagging discrepancies.
• Address common discrepancies by checking for timing differences, missing transactions, data entry errors, and payments made from different accounts or with cash that may not appear on your main bank statement.

What is bank reconciliation?

Bank reconciliation is the process of comparing your business records with your bank statement to make sure they match. It's how you verify that every transaction in your books appears correctly in your bank account.

When you reconcile, you're checking two sets of records:

• Your business books: the income and expenses you've recorded
• Your bank statement: the deposits and withdrawals your bank has processed

Most businesses reconcile monthly, but you can do it weekly or even daily. You can complete bank reconciliation manually or use accounting software to speed up the process.

Why bank reconciliation matters

Regular bank reconciliation protects your business finances and improves your decision-making. Here's why it's worth the effort:

• Catches errors early: Spot data entry mistakes, duplicate transactions, or missing records before they become bigger problems.
• Detects fraud: Identify unauthorised charges or suspicious withdrawals quickly. This is crucial, as the Association of Certified Fraud Examiners (ACFE) found that financial statement fraud made up 6% of cases in Occupational Fraud 2026: A Report to the Nations.
• Improves cash flow visibility: Know exactly how much money you have available to spend, invest, or save.
• Prepares you for tax time: Maintain accurate records that make filing easier and reduce audit risk.
• Prevents overdrafts: Avoid bounced payments and the fees that come with them.
• Supports better decisions: Base your business choices on numbers you can trust.

Skipping reconciliation means working with unreliable data. The longer you wait, the harder it becomes to track down discrepancies.

Bank reconciliation steps

Follow these eight steps to reconcile your bank account.

1. Get bank records

Gather your bank statement for the period you're reconciling. Include all accounts your business uses, such as current accounts and credit cards.

2. Get business records

Open your ledger of income and expenses. This could be a logbook, spreadsheet, or accounting software.

3. Find your starting point

Identify the last date when your book balance matched your bank balance exactly. Start your reconciliation from that date and work forward.

4. Run through bank deposits

Check that each deposit on your bank statement appears as income in your books. If something is missing, add it and categorise it correctly as a sale, interest, refund, or other income.

5. Check the income on your books

Verify that each income entry in your books matches a deposit on your bank statement. If an entry doesn't appear, investigate whether the payment bounced, cleared to a different account, or hasn't been processed yet.

6. Run through bank withdrawals

Check that every withdrawal on your bank statement appears in your books. Look for bank fees, automatic payments, and direct debits that you may not have recorded yet.

7. Check the expenses on your books

Verify that each expense in your books matches a withdrawal on your bank statement. If something doesn't match, the payment may still be pending, or you may have paid from a different account or with cash.

8. End balance

After checking all deposits and withdrawals, your book balance should match your bank balance. If the numbers match, you've completed the reconciliation.

If they don't, review the previous steps to find the discrepancy. Record this ending balance as your starting point for the next reconciliation.

Bank reconciliation example for a Malaysian business

Here's how the eight steps work for a Malaysian business reconciling its current account at the end of the month. All figures are in Malaysian ringgit (RM).

Start with the bank side, adjusting the statement for items your books already show but the bank hasn't processed yet.

• Take the bank statement closing balance of RM8,400.00
• Add the deposit in transit of RM2,300.00, a DuitNow/FPX (Financial Process Exchange) customer payment that's in your books but not yet on the statement
• Deduct the outstanding cheque of RM1,250.00, which you issued to a supplier and they haven't presented yet
• Work out the adjusted bank balance: RM8,400.00 + RM2,300.00 − RM1,250.00 = RM9,450.00

Next, adjust your cashbook for items the bank has processed that you haven't recorded yet.

• Take the cashbook balance before adjustments of RM9,465.00
• Deduct the RM15.00 bank charge shown on the statement but not yet in your books, giving an adjusted book balance of RM9,465.00 − RM15.00 = RM9,450.00

Both balances now agree at RM9,450.00, so the reconciliation is complete. Record the RM15 bank charge in your books and carry RM9,450.00 forward as the starting balance for next month.

Common bank reconciliation problems

Discrepancies between your books and bank statement are normal. Here are the most common issues and what they typically mean.

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

This usually happens when:

• you received cash or a cheque that you haven't deposited yet
• you paid from a different account or with cash
• you entered a transaction with the wrong date

Check your records and update them with the correct details.

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

This usually happens when:

• you forgot to record a transaction
• you made a data entry error with the amount or date
• the bank processed a fee or automatic payment you weren't expecting

Add the missing transaction or correct the error in your books.

How to fix bank reconciliation discrepancies

When your balances don't match, work through these steps to find the issue:

• Recheck your maths: verify that you've added and subtracted correctly
• Review recent transactions: look at invoices, receipts, and emails from the period you're reconciling
• Check for timing differences: some transactions may be pending or dated differently than expected
• Look at the previous period: the error may have carried forward from an earlier reconciliation

Reconciling weekly or daily makes troubleshooting faster because you'll remember recent transactions more clearly.

How to do bank reconciliation the easy way

Accounting software automates most of the reconciliation process, saving you hours of manual work. Proactive data analytics also helps reduce risk; according to the ACFE's Occupational Fraud 2026: A Report to the Nations, organisations using it as an anti-fraud control have fraud losses 53% lower than those that don't. Instead of switching between documents and comparing numbers line by line, software matches transactions for you and flags anything that needs attention.

How to use bank reconciliation software

Bank reconciliation software connects directly to your bank and imports transactions automatically. This eliminates manual data entry and reduces errors.

When you reconcile in software like Xero, the system:

• matches bank transactions with entries in your accounts automatically
• suggests likely matches for transactions it can't confirm
• prompts you to categorise any unmatched transactions

Check out Xero's bank reconciliation features.

How often should you reconcile your accounts?

Reconcile weekly or daily for best results. The more frequently you reconcile, the faster each session takes because you'll remember recent transactions clearly.

Here's how to make reconciliation easier:

• Set a recurring schedule: block time weekly or daily so it becomes routine
• Keep records organised: store invoices, receipts, and statements where you can access them quickly
• Use software with bank feeds: automatic transaction imports reduce manual work significantly

The longer you wait between reconciliations, the more transactions you'll need to review and the harder it becomes to track down discrepancies.

Simplify bank reconciliation with Xero

Bank reconciliation keeps your financial records accurate and helps you make confident business decisions. Whether you reconcile manually or use software, doing it regularly prevents small errors from becoming big problems.

Xero automates bank reconciliation with direct bank feeds and smart transaction matching. Xero's AI, JAX, automatically reconciles bank transactions when it's highly confident they match and suggests matches for the rest, so you stay in control. Instead of comparing numbers line by line, you can reconcile in just a few clicks.

See how much time you could save when you get one month free.

FAQs on bank reconciliation

Here are answers to common questions about bank reconciliation.

What is the formula for bank reconciliation?

The basic formula is: Adjusted bank balance = Bank statement balance + Deposits in transit − Outstanding cheques ± Bank errors. Your adjusted bank balance should equal your adjusted book balance when reconciliation is complete.

How long does bank reconciliation take?

Manual reconciliation time depends on your transaction volume, and it's quicker when you reconcile often. With accounting software like Xero, you review and confirm suggested matches instead of checking each line yourself.

What should I do if I can't find the source of a discrepancy?

Recheck your calculations, review the previous reconciliation period, and contact your bank if needed. If you still can't find the error, document the discrepancy and consult your accountant.

What is a three-way bank reconciliation?

A three-way reconciliation matches three records: your bank statement, your book balance, and a third source such as a client trust ledger. This method is common for businesses that manage funds on behalf of others, such as law firms.

Can I reconcile without bank statements?

Yes, if you have online banking, you can download your transaction history or connect your bank to accounting software. If you're missing historical statements, contact your bank to request copies.

How often should Malaysian businesses reconcile for SST and e-invoicing?

Reconcile at least monthly: Sales and Service Tax (SST) returns are filed every two months, and consolidated e-invoices must be issued within seven calendar days after month end. Reconciling monthly keeps your figures ready for both.