Bank reconciliation guide: what it is and how to do it

Published Wednesday 10 June 2026

Table of contents

• What is bank reconciliation?
• Why is bank reconciliation important?
• How often should you reconcile your bank account?
• How to do bank reconciliation in 8 steps
• Common bank reconciliation discrepancies
• Bank reconciliation example
• Simplify bank reconciliation with Xero
• FAQs on bank reconciliation

Key takeaways

• Compare your internal financial records against your bank statement to confirm every transaction is accounted for and your balances match.
• Reconcile regularly to catch errors early, spot unauthorised transactions, and maintain accurate cash flow visibility for confident business decisions.
• Retain your financial records for 7 years under Malaysia's Income Tax Act 1967, making consistent reconciliation and documentation a compliance priority.
• Use accounting software with automatic bank feeds and smart matching to turn a time-consuming manual task into a quick daily check.

What is bank reconciliation?

Bank reconciliation is the process of comparing your business's internal financial records with your bank statement for the same period. The goal is to make sure every transaction in your bookkeeping records matches what your bank shows, and that your closing balances agree.

When the 2 sets of records don't match, you investigate the differences. These might be timing gaps, bank fees you haven't recorded yet, or errors that need correcting. Resolving each discrepancy gives you a clear, accurate picture of your finances.

For Malaysian small businesses, bank reconciliation also supports compliance. Section 82 of the Income Tax Act 1967 requires you to keep sufficient records of income and expenditure for 7 years. Regular reconciliation keeps those records reliable and audit-ready.

The main benefits of bank reconciliation include:

• Catch data entry errors and duplicate transactions before they compound.
• Detect unauthorised or fraudulent transactions early.
• Maintain accurate cash flow records for day-to-day decisions.
• Prepare confidently for tax filing with the Lembaga Hasil Dalam Negeri (LHDN).
• Assign costs to specific jobs or projects with reliable figures.

Why is bank reconciliation important?

Skipping bank reconciliation can leave gaps in your financial records that grow harder to fix over time. Making it a regular habit protects your records and your business in the following ways.

Cash flow accuracy. Your bank balance and your accounting records won't always agree on any given day. Outstanding cheques, pending transfers, and unrecorded fees create temporary differences. Reconciling closes those gaps so you know exactly how much cash is available before you commit to spending.

Fraud detection. Comparing your records line by line with your bank statement is one of the most effective ways to spot unauthorised withdrawals, unfamiliar charges, or duplicate payments. The sooner you identify a suspicious transaction, the faster you can act.

LHDN compliance. The Malaysian tax authority expects accurate financial records when you file returns or face an audit. Consistent reconciliation means your books are always in order, reducing the risk of penalties or delays during tax season.

Confident financial decisions. When your records are accurate and up to date, you can trust the numbers behind every business decision.

How often should you reconcile your bank account?

The right frequency depends on how many transactions flow through your business each month. The more transactions you process, the more often you should reconcile.

Daily. If your business handles a high volume of sales or payments, a quick daily check helps you catch issues the same day they happen. This is especially useful for retail or e-commerce businesses with frequent card transactions.

Weekly. For businesses with moderate transaction volumes, a weekly review strikes a good balance between thoroughness and time investment. Set a recurring day each week so it becomes routine.

Monthly. At a minimum, reconcile once a month when your bank statement arrives. Monthly reconciliation is the standard for most small businesses and is usually enough if your transaction volume is low.

Accounting software with automatic bank feeds can import your bank transactions daily, making it possible to reconcile in minutes rather than hours. Automated matching flags transactions that already line up, so you only need to review exceptions.

How to do bank reconciliation in 8 steps

Follow these steps to reconcile your bank account accurately. Whether you use a spreadsheet or accounting software, the logic is the same.

1. Gather your records

Collect your bank statement for the period you're reconciling and your internal financial records for the same dates. Your internal records might be a cashbook, a spreadsheet, or your accounting software ledger. Having both side by side makes comparison straightforward.

2. Compare opening balances

Check that the opening balance on your bank statement matches the opening balance in your records. If these don't align from the start, any previous reconciliation may have an unresolved issue you need to address first.

3. Match deposits

Go through each deposit on your bank statement and find the corresponding entry in your records. Tick off each match. Look for differences in amounts, dates, or missing entries on either side.

4. Match withdrawals

Repeat the same process for withdrawals, including cheques, direct debits, card payments, and bank transfers. Match each outgoing transaction on your statement to your records and note anything that doesn't line up.

5. Identify discrepancies

List every transaction that appears in one set of records but not the other. Common causes include outstanding cheques, deposits in transit, bank fees, or recording errors with incorrect amounts or dates.

6. Adjust your records

For each discrepancy, determine whether your internal records or the bank statement needs correcting. Add any missing transactions to your books, such as bank fees or interest. If the bank has made an error, contact them to request a correction.

7. Recalculate and verify

After making adjustments, recalculate your closing balance. It should now match your bank statement's closing balance exactly. If it doesn't, review your adjustments for errors or missed items.

8. Document the reconciliation

Save a record of the completed reconciliation, including any adjustments you made and the final matched balances. Under the Income Tax Act 1967, you must keep these records for at least 7 years. Good documentation protects you during audits and gives you a clear trail for future reference.

Common bank reconciliation discrepancies

Even with careful record-keeping, differences between your books and your bank statement are normal. Understanding the most common causes helps you resolve them quickly.

• Check for outstanding cheques that you've issued but the recipient hasn't yet deposited or cleared.
• Watch for deposits in transit, where you've recorded a payment in your books but the bank hasn't processed it yet.
• Look for bank fees and charges that the bank has applied but you haven't recorded, such as service fees or interest debits.
• Account for timing differences when transactions are recorded on different dates in your books and your bank statement, especially around month-end cut-offs.
• Review for recording errors such as transposed digits, duplicate entries, or amounts entered incorrectly.

One practical way to reduce discrepancies is to use a dedicated business bank account. Mixing personal and business transactions makes reconciliation significantly harder and increases the chance of errors.

Bank reconciliation example

This simplified example shows how bank reconciliation works for a Malaysian small business. All figures are in MYR.

Start with your bank statement closing balance for the month: RM 12,500.00.

Next, identify transactions recorded in your books that haven't yet appeared on the bank statement. Deduct an outstanding cheque to a supplier (RM 1,200.00) and add a deposit in transit from a client payment (RM 800.00).

Adjusted bank balance: RM 12,500.00 - RM 1,200.00 + RM 800.00 = RM 12,100.00.

Now check your internal records. Your cashbook closing balance is RM 12,150.00. Identify items on the bank statement not yet in your books:

• Deduct a bank service fee: RM 30.00
• Add interest earned: RM 5.00
• Deduct a direct debit for insurance: RM 25.00

Adjusted book balance: RM 12,150.00 - RM 30.00 + RM 5.00 - RM 25.00 = RM 12,100.00.

Both adjusted balances now match at RM 12,100.00. The reconciliation is complete. Record the adjustments in your books and save the documentation.

Simplify bank reconciliation with Xero

Bank reconciliation can be quick and straightforward with the right software. Xero Accounting Software connects directly to your bank through bank feeds, importing transactions automatically every day. Smart matching suggests the most likely matches between your bank transactions and your accounting records, so you can confirm each one with a single click.

You can also reconcile on the go using the Xero Accounting app on your phone. For a detailed walkthrough, visit the bank reconciliation guide on Xero Central. Whether you're at your desk or between meetings, keeping your books up to date takes minutes rather than hours. Get one month free.

FAQs on bank reconciliation

Here are answers to frequently asked questions about bank reconciliation.

What is a bank reconciliation statement?

A bank reconciliation statement is the document produced at the end of the reconciliation process. It lists all adjustments made to both the bank balance and your book balance, showing how the 2 figures were brought into agreement.

What is the difference between bank reconciliation and account reconciliation?

Bank reconciliation specifically compares your cashbook with your bank statement. Account reconciliation is broader and can involve verifying any ledger account, such as accounts receivable or accounts payable, against supporting records.

What should you do if your bank statement doesn't match your records?

Review each unmatched transaction to determine whether the difference is a timing issue, a recording error, or an unrecorded fee. Correct your records where needed, and contact your bank if you suspect a bank-side error.

Does bank reconciliation software work with Malaysian banks?

Yes. Xero supports bank feeds with major Malaysian banks, allowing transactions to flow directly into your accounting software for reconciliation without manual uploads.

What happens if you skip bank reconciliation for several months?

Unreconciled transactions accumulate, making it harder to trace individual errors or missing entries. You may also miss unauthorised charges or bank fees that affect your reported cash position and tax filings.