Why reconciliation matters
A reconciliation proves that the cash balance in the books is the balance the bank holds, adjusted for items still in transit. It catches duplicate payments, unrecorded bank charges, customer payments applied to the wrong invoice and, occasionally, fraud. Every statutory audit starts with the bank balance, because it is the most independent evidence available: the auditor will write to the bank for a confirmation and compare it to your books.
Companies that skip monthly reconciliation usually pay for it at the year-end. A year's worth of unmatched lines has to be investigated at the same time as accruals, depreciation and tax provisions, and the people who knew what a payment was for may have left or forgotten.
The records also underpin tax. The Inland Revenue Department expects a company to keep books explaining its transactions for seven years, and an unexplained credit on a bank statement can be treated as income unless the company shows otherwise.
A monthly routine that works
Download the statement for each account as soon as the month closes. Take the opening balance from the prior month's reconciled balance, then tick every line against a ledger entry. Receipts match to invoices or other income entries, payments to supplier bills, payroll, MPF, tax payments or director transactions. Anything left unmatched on either side is a reconciling item.
The common reconciling items are cheques written but not yet cleared, deposits made but not yet credited, bank charges not yet booked, interest, foreign exchange differences on overseas transfers and timing differences at the month-end. List each with its date and the person who will clear it. Banks commonly treat a cheque as stale after about six months, so old uncleared cheques should be investigated and either re-issued or reversed.
Finish with three lines: balance per bank statement, adjusted for reconciling items, equals balance per books. Sign the reconciliation, date it and have a second person review it. That signature trail is exactly what an auditor looks for.
Here is a worked example. The statement shows HK$512,400. Add a deposit of HK$38,000 made on the last day and not yet credited, and subtract two cheques of HK$21,500 and HK$9,800 that have not cleared: the adjusted bank balance is HK$519,100. The books show HK$519,620, so HK$520 is missing from them, which turns out to be an overseas transfer fee of HK$400 and a monthly account fee of HK$120. Booking those two charges brings the books to HK$519,100 and the reconciliation closes with no difference.
Reading different payment types
FPS credits show the payer's name and amount, plus whatever reference the payer typed, and they arrive in real time at any hour. Payments sometimes come from a different person than the customer, such as a director paying personally, so keep a note of who paid.
Bank transfers from overseas often arrive net of intermediary bank charges, so the amount received is less than the invoice. Decide in advance whether the customer or the company bears those charges, and book the difference to bank charges with a note, rather than leaving the invoice partially paid forever.
Cheques are listed by cheque number and may be paid, returned or stopped. Card settlements arrive in batches, net of fees, so you need the merchant statement to see which sales they cover. For payments in foreign currency, record the rate used and the Hong Kong dollar equivalent at the date of transaction, as set by your accounting policy.
Multi-currency accounts need one reconciliation each, in the account's own currency, plus a note of the Hong Kong dollar equivalent at the closing rate used in the accounts. Because the Hong Kong dollar is linked to the US dollar within a narrow band, differences on US dollar balances are small, but renminbi and other currencies can move enough to matter.
Controls that protect cash
Separate duties where possible. The person who prepares payments should not be the person who approves them, and neither should do the reconciliation alone. In a very small team, a director can review the reconciliation and sign it off monthly.
Keep access tidy: when staff leave, remove their online banking access the same day, and review the list of authorised signatories at least once a year. Check unusual items such as round-sum payments to individuals, repeated small transfers just under an approval limit and payments to new payees.
Never leave a suspense account to grow. If you cannot identify a receipt within a month, ask the payer or the bank, record it in a suspense line with a note, and clear it before year-end.
Restrict who can set up new payees and who can release large transfers. Ask the bank to send alerts for outgoing payments above a threshold you set, and review the bank's list of authorised users whenever a director or finance officer changes.
How 4b2b helps and what it does not do
4invoices keeps PDF invoices in an invoice archive, so you can look up the number, amount and date of any sales invoice when matching a receipt. It does not import bank statements and does not match payments automatically; the matching is done by you in your books.
4notify can send an SMS or e-mail that you write, for instance a payment reminder for an invoice that your reconciliation shows is still open, or a note to the manager who must sign off the month. It is triggered by you, not by bank data.