Trading & wholesale · Statements and reconciliation · Hong Kong
Month-end statements and bank reconciliation for a Hong Kong wholesaler
Twelve hundred monthly accounts, bank-ins with no reference — and every short payment now reaches a person instead of disappearing.
Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.
A food and household-goods wholesaler in Kwun Tong supplies about 1,200 restaurants and minimarts on monthly accounts. Every month-end each customer needs a statement, and every payment that comes into the bank has to be matched to the invoices it pays. Until that is done, nobody knows who still owes what.
At a glance
The files they already use
- Sales invoice list
- Credit notes for returns
- Bank statement download
- Scanned cheque copies
- Customers' remittance emails
- Open items per branch, plus a group summary
- PO number on every line where required
- Bank-ins matched to exact invoice combinations
- Short, over and part payments flagged
- Their existing statement format
Done automatically
- Statements — per branch and group
- Bank reconciliation sheet
- Payments needing a person
- Statement emails — drafted
The accounts staff check every statement and every flagged payment before anything is sent.
How they used to do it
At month-end the clerk exported the invoice list to Excel, filtered it customer by customer, and copied the open items into a Word statement. Customers with several branches wanted one statement per branch, and some wanted their own order (PO) number on every line — so those statements took three times as long.
Then came the bank. The clerk downloaded the bank statement and ticked off each bank-in by hand. A lump sum with no reference meant trying combinations of invoices on a calculator, or phoning the customer. Small differences were often left on the ledger, and nobody followed them up.
The difficulties
- Lump sums with no reference. A group paying three branches at once sent one transfer, and finding which invoices it covered could take half an hour.
- Small gaps written off. A payment a hundred-odd dollars short was easier to ignore than to query, so small deductions added up unnoticed.
- Branches mixed up. A payment from head office was sometimes set against the wrong branch, and two statements were then wrong.
- Missing PO numbers. Customers who need their PO number on every line sent statements back when one was missing, and payment waited another month.
- A week at month-end. Statements and reconciliation took most of the first week of every month, while the collectors chased figures that were already out of date.
Their formula, broken down
A statement looks like a list of invoices. The hard part is what happens after it: matching the money that actually arrives. Here is September for Supermarket Group C, a minimart chain with three branches.
List the open invoices, branch by branch
Kwun Tong branch INV-0911 for HK$18,640.00, Ngau Tau Kok branch INV-0918 for HK$22,380.00 and Lam Tin branch INV-0925 for HK$9,870.00.
INV-0911 HK$18,640.00 + INV-0918 HK$22,380.00 + INV-0925 HK$9,870.00HK$50,890.00
Deduct the credit note
Lam Tin returned goods under credit note CN-0407 for HK$1,240.00, so the September statement balance is HK$50,890.00 − HK$1,240.00 = HK$49,650.00.
less credit note CN-0407−HK$1,240.00
Match the FPS transfer
An FPS transfer of HK$41,020.00 arrives with only “SEP PAYMENT” as its reference. The system tries combinations of the open items and finds that INV-0911 + INV-0918 equals it exactly, so both are cleared.
FPS transfer HK$41,020.00 = INV-0911 + INV-0918−HK$41,020.00
Set the cheque against what is left
What remains is INV-0925 less the credit note: HK$8,630.00. The cheque is for HK$8,500.00, which is HK$130.00 short — so it is flagged for a person, not written off.
cheque HK$8,500.00 (due HK$8,630.00, short HK$130.00)−HK$8,500.00
What the system produces
Open items at 30 September
| Document | Branch | HK$ |
|---|---|---|
| INV-0911 · PO 7702 | Kwun Tong branch | 18,640.00 |
| INV-0918 · PO 7719 | Ngau Tau Kok branch | 22,380.00 |
| INV-0925 · PO 7731 | Lam Tin branch | 9,870.00 |
| CN-0407 returned goods | Lam Tin branch | −1,240.00 |
| Group statement balance | 49,650.00 | |
Bank-ins matched
| Item | Matched to | HK$ |
|---|---|---|
| Statement balance | 3 invoices − 1 credit note | 49,650.00 |
| FPS transfer “SEP PAYMENT” | INV-0911 + INV-0918, cleared | −41,020.00 |
| Cheque, no reference | INV-0925 − CN-0407 = HK$8,630.00 | −8,500.00 |
| Still open | 130.00 | |
How it was calculated
Still open = statement balance − bank-ins matched
= HK$49,650.00 − HK$41,020.00 − HK$8,500.00 = HK$130.00
Flagged for a person to confirm
- Cheque HK$8,500.00 against HK$8,630.00: short by HK$130.00 with no explanation — a deduction or a bank charge the customer has not explained. Held for a person; not written off.
- The FPS reference names no invoice. The match was found by amount — INV-0911 + INV-0918 exactly — and is shown for a person to confirm.
In this example: the statement is built branch by branch, the unreferenced transfer is matched to the exact pair of invoices, and the HK$130.00 short payment reaches a person instead of being left on the ledger.
How we helped
We build one record per customer — its branches, its statement format, whether it needs PO numbers, and every invoice, credit note and payment — and a system that prepares the month-end statements and matches each bank-in to the invoices it pays. The sales team changes nothing; the accounts staff stop ticking and start checking the exceptions.
- Invoices and bank-ins come in. The invoice list, credit notes and the bank statement download are read as they are; cheque copies and remittance emails are attached to the payments they belong to.
- Statements built per branch. Each branch gets its own statement in the customer's usual format, with PO numbers where required, plus a group summary.
- Every bank-in matched. Each payment is matched to the invoice or exact combination of invoices it pays. Short, over, part and unreferenced payments are flagged.
- Reviewed, then sent. The accounts staff check the statements and the flagged payments; the statement emails are drafted for a person to send.
What the system handles
Monthly statements
One per branch plus a group summary, in each customer's existing format, with PO numbers on every line where the customer requires them.
Bank reconciliation
FPS transfers, cheques and bank transfers matched to invoices, including lump sums covering several invoices or branches.
Part and over payments
A part payment leaves the rest open on the next statement; an overpayment is held as a credit for a person to decide how to use it.
Unexplained differences
Every short payment is listed with the invoices it relates to, ready for the collector to query.
Collection list
Customers with overdue balances are listed after each reconciliation, with the amounts already matched.
Before and after
| Topic | Before | After |
|---|---|---|
| Statements | Open items were filtered in Excel and copied into Word, customer by customer. | Statements are prepared for every customer in their own format, per branch and as a group. |
| PO numbers | PO numbers were typed in by hand and sometimes missed. | PO numbers are carried from the invoice onto every line for customers who need them. |
| Bank-ins | Each bank-in was ticked off by hand, and lump sums were worked out on a calculator. | Every bank-in is matched to its invoices, including exact combinations with no reference. |
| Differences | Small short payments were often left on the ledger with no follow-up. | Every difference is flagged with its invoices for a person to query. |
| Month-end | Statements and reconciliation took most of the first week of the month. | Statements are ready on the first working day; the staff only check them and handle the flags. |
How much time it saves
- About 1,200 monthly statements, each taking around 10 minutes to filter, copy and check: 1,200 × 10 minutes = 200 hours.
- About 800 bank-ins a month, each taking around 6 minutes to match: 800 × 6 minutes = 80 hours — 280 hours in all.
- With the system: about 1 minute to check each statement (20 hours) and about 100 flagged payments at 6 minutes each (10 hours) — 30 hours in all.
- Time saved ≈ 250 hours a month — about 31 working days.
- At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$27,500 a month — before counting short payments that are now recovered.
These are the working assumptions behind the figure, not an audited result.
How a project like this runs
- Free assessment. We sit with your accounts clerk through one real month-end and collect one statement in each customer format, plus a month of bank statements.
- Built on your own month-end. The statement formats and matching rules are rebuilt from a past month and tested until they reproduce your clerk's reconciliation exactly.
- Side by side. For two month-ends your clerk works by hand while the system runs on the same files, and the two are compared customer by customer.
- Live, then maintained. Once they match, the manual statements stop. New customers are added with their format, and we fix anything that comes up.
Questions owners usually ask
- Do our statements have to change?
No. Your existing statement format is kept, and each customer that needs its own layout or PO numbers gets it. - What happens to a payment the system cannot match?
It is listed for a person with the most likely invoices beside it. Nothing is cleared or written off without someone deciding. - Are statements emailed automatically?
No. The emails are drafted; a person checks each statement and sends it.
The results
- Every customer's statement is prepared on the first working day, per branch and as a group, in its own format.
- Every bank-in is matched to the invoices it pays, including lump sums with no reference.
- Short, part and over payments are flagged for a person instead of being left on the ledger.
Representative example — a composite of typical Hong Kong workflows, written from the duties in current job ads. Company names, documents and figures are sample data.
Related case studies
Also useful: Back-office outsourcing · Try a working demo · Free tools · All case studies
Does your company have a formula like this?
Send us one real example — a quotation, an invoice or a month-end statement — and we will show you how the system would work it out. The assessment is free.
Get a free assessment →