
96 Software Sdn Bhd
Access UBS implementation in Klang Valley—can you trust the first bank reconciliation?
Use the first bank reconciliation to check an Access UBS implementation: tie the opening figure to a dated statement, keep uncleared items traceable and test the exact bank export before relying on it.
You can trust the first bank reconciliation only when the opening balance ties to the bank statement at a clear cut-off date and outstanding items remain individually traceable. During Access UBS implementation in Klang Valley, the key check is whether someone can explain each difference between the old cashbook and the first reconciliation in the new setup. A tidy total can still hide a mismatch.
Date the opening balance during Access UBS implementation
Set a cut-off date, then compare the bank statement closing balance with the cash ledger through that same date. A 30 June statement should be matched to transactions recorded through 30 June, not a report dated 1 July or a ledger that includes backdated entries. Write down the statement date and the balance you intend to carry forward.
Say a Klang Valley retailer is changing systems at 30 June. The statement closes at RM124,680 while the old cash ledger shows RM129,180. That RM4,500 gap is not an opening balance to round away. Check for bank charges dated 30 June, late customer receipts, duplicate deposits or an entry posted to another bank account. Compare the statement with the cashbook and explain the difference before carrying the balance across.
Keep uncleared cheques and deposits visible
A cheque dated 29 June for RM3,200 may not clear until 2 July; a deposit of RM8,500 lodged on 30 June may appear on the statement on 1 July. These timing items can explain a difference between the book and bank balances, but only while they are genuinely outstanding. Keep the cheque or deposit reference, date, amount and follow-up status with the opening reconciliation.
The costly mistake is carrying only the net difference, then entering the same payment or receipt again when it clears. When the July statement arrives, mark each old item against its bank entry. Check that a replaced or voided cheque has not been carried forward as if it were still payable, and retain the supporting remittance advice or deposit slip so the next reviewer can trace the amount.
Give each bank account its own trail
Keep separate opening balances and reconciliation records for each company bank account. Combining the operating account and payroll account into one cash figure makes it harder to identify which statement supports a difference, even if both accounts belong to the same business.
A transfer of RM12,000 from one company account to another should appear as money leaving one account and entering the other, not as an operating expense and new revenue. Match the amount and transfer reference on both statements; if one bank deducts a fee, record that charge separately. This gives you a clear way to explain a timing difference when the money leaves one account before it appears in the other.
Test the statement export, not just the screen
Bank files can differ in small ways that cause large reconciliation headaches: a date may appear as DD/MM/YYYY or MM/DD/YYYY, debits may be positive numbers or shown with a minus sign, and reference fields may be blank. A CSV opening in a spreadsheet does not prove that the exact proposed accounting setup can import or read it correctly. Check the bank’s actual export format and ask how the setup will handle it.
96 Software Sdn Bhd works with businesses across Selangor and the Klang Valley on Access UBS accounting software implementation and training. Bring a redacted statement or sample export and test a beginning balance, one uncleared cheque, one deposit in transit and a bank charge against the statement’s ending balance. Confirm that the proposed edition and setup can support the way your team will perform those checks; do not assume every bank file imports automatically.
Frequently asked questions
What if a cheque from the old system still has not cleared?
Check its date, payee, amount and reference against the bank statement and any replacement or cancellation record. Carry it forward only if it remains a genuine outstanding item, then match it when it clears. Ask your accountant how to treat a stale or disputed cheque.
Can I assume a bank statement CSV will import into Access UBS?
No; a CSV file can use different date formats, debit signs, column names and reference fields. Test the exact bank export against the proposed edition and setup before relying on an import. Use a redacted sample rather than sharing online banking credentials.
How should I record a transfer between two company bank accounts?
Record the money leaving the first account and arriving in the second as the two sides of the same transfer, not as an expense and income. Match the reference and amount across both statements. Record any bank fee separately so the two sides still reconcile.
For a Klang Valley SME, the first reconciliation is a practical test: the statement date, opening book figure and every uncleared line should tell one consistent story. Have your accountant review any unresolved opening difference before finalising the books.
Related articles: How Selangor Buyers Can Test Margins Before Choosing Access UBS Inventory & Billing · Subang Jaya Buyers Should Test Access UBS POS at the Counter