Bank reconciliation in Malaysia: a step-by-step guide for small businesses
Your bank balance and your books rarely agree on the same day. Here is how Malaysian small businesses find out why, line by line, in under an hour a month.
Bank reconciliation (penyesuaian bank) means comparing every transaction in your books with your Malaysian bank statement for the same month, then explaining each difference. Tick off matching lines, list cheques and deposits the bank hasn't processed, record bank and FPX charges you missed, and fix errors. When the adjusted balances agree, your cash figure is reliable.
Your accounting records say you have RM42,000 in the bank. Your Maybank or CIMB app says RM38,600. Which is right? Usually both, for different reasons, and a bank reconciliation (in Bahasa Malaysia, penyesuaian bank) is how Malaysian businesses find those reasons. Skip it and small gaps pile up, such as a supplier paid twice or gateway charges that never reached your expenses, until your accountant bills you to untangle them at year end.
This guide walks through a reconciliation step by step, with a worked example in ringgit from a Klang Valley trading company, and covers the mistakes behind most mismatches.
What is a bank reconciliation?
A bank reconciliation compares two records of the same money and explains every difference between them. It is not about forcing the balances to match on the day you look.
The two records are:
- Your books: the bank account in your accounting system (sometimes called the cash book), built from the invoices, bills, receipts and payments you record.
- The bank statement: what actually cleared through your account at Maybank, CIMB, Public Bank, RHB, Hong Leong or whichever bank you use.
A difference you can't explain is a warning sign: an error, a missing record, or occasionally fraud.
Why don't my books match my bank statement?
Most differences are either timing (the bank hasn't processed something yet) or something one side knows about and the other doesn't. The table shows the usual groups.
| Type of difference | Malaysian example | What to do |
|---|---|---|
| Payments not yet cleared | A cheque you issued on 30 June is banked by the supplier on 3 July | Nothing to fix; list it as outstanding |
| Deposits in transit | Cash takings banked on the evening of 30 June show on 1 July | Nothing to fix; list it as in transit |
| Items only the bank knows about | Monthly service fees, FPX or card-gateway charges, interest, a returned cheque, an auto-debit for your loan | Record them in your books |
| Errors in your books | RM1,250 keyed in as RM1,520, or one DuitNow receipt recorded twice | Correct your books |
| Errors by the bank | Rare, but it happens | Ask the bank to correct it |
Timing items clear themselves next month. Everything else needs an entry in your books or a call to the bank.
How often should a Malaysian SME do a bank reconciliation?
At least once a month, as soon as the statement is available. Businesses with many daily DuitNow and FPX receipts often reconcile weekly, because it is much easier to remember what a RM480 transfer was for after five days than after five months.
For a Sdn Bhd there is a legal reason too. The Companies Act 2016 requires a company to keep accounting records that sufficiently explain its transactions and financial position, to make entries within sixty days of a transaction, and to keep those records for seven years (section 245). A monthly reconciliation is one of the simplest ways to show your cash records meet that standard. For what else to keep, see record keeping in Malaysia.
How do I do a bank reconciliation, step by step?
Work through six steps: gather the statement and your records, check opening balances, tick off matching lines, deal with what is left on each side, then compare the adjusted balances.
1. Gather the right documents
Download the month's statement from your online banking (Maybank2u, CIMB Clicks, Public Bank PBe and the other banks' business portals all provide them). You also need your accounting records for the same account and dates, and last month's reconciliation so you know which items were already outstanding.
2. Check the opening balances
Your books' opening balance should equal last month's adjusted balance, and the statement's opening balance should equal last month's closing statement balance. If they don't, the problem started earlier. Fix last month first.
3. Tick off matching transactions
Go through the statement line by line. For each line, find the same amount on or near the same date in your books, and tick both. Watch for one bank line that covers several of your records, such as one IBG or DuitNow transfer from a customer paying three invoices, or one payment run to five suppliers. Match the total.
4. Deal with what is left on the bank statement
Unticked lines on the statement are things the bank recorded and you didn't: service fees, FPX or card-gateway charges, interest, standing instructions, a customer transfer you never recorded, or a bounced cheque. Record each one in your books under the right account. If you can't identify a receipt, park it in a suspense account and find out who paid before month end.
5. Deal with what is left in your books
Unticked entries in your books are things you recorded that the bank hasn't processed yet. Cheques issued but not yet banked by the payee are outstanding payments. Money banked on the last day that appears next month is a deposit in transit. Anything old, such as a cheque from four months ago, deserves a follow-up call.
6. Prepare the reconciliation and compare
Adjust each side for its own missing items and compare the two adjusted figures. If they agree, you're done. If not, the remaining difference is an error, and the tips further down will help you find it.
What does a bank reconciliation look like? A worked RM example
Here is a reconciliation for an illustrative Klang Valley company, Syarikat Maju Trading Sdn Bhd, for June. Its books show RM42,000 in its Public Bank current account; the statement closes at RM38,600. After ticking off the matching lines, this is what is left:
- Cheque 004512 to a supplier for RM5,200, issued 28 June, not yet presented.
- Takings of RM3,100 banked on the evening of 30 June, on the statement on 1 July.
- A RM25 monthly bank fee and RM275 in FPX and card-gateway fees, not yet in the books.
- A customer's RM1,000 cheque, recorded as received, returned unpaid.
- A RM900 DuitNow receipt from a customer that was recorded twice.
Adjusting the bank statement balance
| Item | RM |
|---|---|
| Balance per bank statement, 30 June | 38,600 |
| Add: deposit in transit | 3,100 |
| Less: outstanding cheque 004512 | (5,200) |
| Adjusted bank balance | 36,500 |
Adjusting the balance in your books
| Item | RM |
|---|---|
| Balance per books, 30 June | 42,000 |
| Less: bank fee | (25) |
| Less: FPX and card-gateway fees | (275) |
| Less: returned customer cheque | (1,000) |
| Less: duplicated DuitNow receipt | (900) |
| Adjusted book balance | 39,800 |
The adjusted figures still differ by RM3,300. Going back through the ticks, the bookkeeper finds a RM3,300 payment to a contractor on 15 June that cleared the bank but was never recorded. Entering it brings the books to RM36,500, and both sides agree.
Only the books were corrected. The outstanding cheque and the deposit in transit stay on the reconciliation until they clear next month.
How do I find a difference that won't go away?
Start by checking whether the difference equals a single missing amount, then look for keying errors. These checks catch most stubborn differences:
- Divide the difference by 9. If it divides evenly, look for swapped digits: RM1,520 entered as RM1,250 is a difference of RM270, which is 30 × 9.
- Halve the difference. If you're out by RM1,800, look for a RM900 item entered as a receipt instead of a payment.
- Search for the exact amount. A missing entry often equals the difference, as in the example above.
- Check dates at month end. Items dated 30 June in your books but 1 July at the bank are common.
- Recheck the opening balance. An unexplained difference from last month carries into this one.
Can accounting software do bank reconciliation for me?
Software can do the tedious matching, but a person still needs to confirm it. Most accounting tools let you import the bank statement and suggest a match for each line based on amount, date and reference. You accept the right suggestions and create entries for fees or unrecorded receipts straight from the unmatched lines.
In HumbleBear, for example, you import your bank statement and it proposes matches between statement lines and your invoices and bills, which you then confirm or correct. The judgement calls, such as whether a RM900 DuitNow receipt is a deposit or the last payment on an old invoice, remain yours.
It also helps to keep your books in double-entry form, so every bank line has a clear opposite entry.
Frequently asked questions
What is bank reconciliation in Bahasa Malaysia?
It is usually called penyesuaian bank, and the statement you prepare is a penyata penyesuaian bank. The process is the same: compare your cash book with the bank statement and explain every difference.
Do I need to reconcile if my business only uses one bank account?
Yes. Even with one account there will be bank fees, FPX or card charges, DuitNow transfers with unclear references and the odd keying error. Reconciling monthly stops those small issues from turning into a year-end problem.
What should I do with a DuitNow or IBG deposit I can't identify?
Record it in a temporary suspense account so your books match the bank, then find out who paid. Check the payment reference, ask your sales team, and compare against unpaid invoices for the same amount. Move it to the right customer as soon as you know.
How long should a bank reconciliation take?
For a small Malaysian business reconciling monthly, often under an hour once you have a routine. It takes much longer when months are skipped, because old transactions are harder to remember. Importing the statement into software that suggests matches cuts the time further.
What happens to an outstanding cheque that is never banked?
It stays on your reconciliation as an outstanding item until it clears. If it is very old, contact the payee, since it may have been lost and need reissuing. Once you are sure it will never be presented, reverse it in your books.
