Food import · Hong Kong
Delivery billing automation for a Hong Kong food importer
Every delivery priced from that customer's own price list and checked against its signed note.
Deliveries to restaurants, hotels and shops were priced and billed by hand, each customer from its own price list. We built a system that works out every charge from the delivery sheet and the signed delivery notes, with a person approving each statement before it is sent.
The challenge
The importer delivers to restaurants, hotels and shops, and each customer has its own agreed price list: goods prices plus delivery terms — a base delivery charge, extra charges for weight or volume over the agreed limit, and extras such as parking, tunnel tolls, remote-area surcharges, unloading and urgent same-day delivery. Every month about one and a half accounts staff matched each delivery in the delivery sheet to its signed delivery note, looked up that customer's prices and delivery terms, added the extras by hand and typed up each customer's statement. Short or part deliveries, goods the customer collected themselves and deliveries already billed slipped through, or were caught only when the customer disputed the statement — and prices from one customer's list sometimes ended up on another's.
The solution
The system reads the delivery sheet the team already keeps and the scanned signed delivery notes, checks each delivery against its note, prices it with that customer's own price list and delivery terms, and adds the extras. Anything that doesn't match is flagged for a person to confirm, and each customer's monthly statement waits for a person to approve it before it is sent.
The workflow we built
- Deliveries in. The system reads the delivery sheet in the format the team already keeps, together with the scanned signed delivery notes.
- Checked against the signed note. Each delivery is checked against its signed note: note number, quantity delivered this time and quantity already billed. Mismatches, part deliveries and orders the customer collected themselves are flagged for a person to confirm — never guessed.
- Priced from the customer's own list. Each delivery is priced with that customer's own price list and delivery terms — the base delivery charge plus any charge for weight or volume over the agreed limit — and the extras are added. A customer with no price list on file is flagged “cannot price”; another customer's prices are never used.
- Statements prepared, approved, sent. Each customer's monthly statement is produced as a separate Excel file showing every charge and how it was worked out. The original delivery sheet is never changed, and a person reviews and approves each statement before it is sent.
A week before, a week after
| Topic | Before | After |
|---|---|---|
| Delivery notes | Each delivery in the sheet was matched to its signed delivery note by hand. | Every delivery is checked against its signed note: note number, quantity delivered and quantity already billed. |
| Pricing | Each customer's prices and delivery terms were looked up by hand, and one customer's prices sometimes ended up on another's statement. | Each delivery is priced from that customer's own price list; a customer with no list on file is flagged “cannot price”. |
| Extras | Over-weight and over-volume charges, parking, tunnel tolls, remote-area surcharges, unloading and urgent deliveries were added by hand. | Delivery charges and extras are added by that customer's own delivery terms, each one shown on the statement. |
| Part deliveries | Short or part deliveries, self-collected orders and deliveries already billed slipped through. | Part deliveries, self-collected orders and quantities already billed are flagged for a person to confirm. |
| Statements | Each customer's monthly statement was typed up by hand, and mistakes were often found only when the customer disputed it. | Each customer's statement is a separate Excel file showing how every charge was worked out, approved by a person before it is sent. |
How the saving adds up
- About 1,410 deliveries a month, at roughly 12 minutes each to match the signed delivery note, look up that customer's prices and delivery terms, add the extras and type the line onto the statement.
- 1,410 deliveries × 12 minutes ≈ 282 hours a month.
- 282 hours × HK$110 an hour ≈ HK$31,000 a month.
- 282 ÷ 173 hours (one full-time month) ≈ 1.6 full-time staff.
- HK$110 an hour is about HK$19,000 a month for one full-time admin staff, MPF included.
These are the working assumptions behind the figure, not an audited result.
How the project ran
- Free audit. We sat with the accounts team through a real month-end and watched deliveries matched to signed notes, priced and typed onto customer statements.
- Built on their own files. The pricing rules were built and tested on their own past delivery sheets, signed notes and customer price lists, checked against the statements the team had already sent.
- Side by side. For a period the team kept preparing statements by hand while the system ran on the same deliveries, and the two were compared line by line.
- Live, then monitored. Once they matched, the manual statements stopped and only flagged deliveries reach a person. We monitor it and fix anything that comes up after go-live.
Questions owners usually ask
- Did anyone lose their job?
The accounts team stopped typing up statements line by line and went back to the rest of the accounts work. What to do with freed-up time is always the owner's decision, not ours. - What happens when it gets something wrong?
Nothing is sent until a person approves it. A delivery that doesn't match its signed note, a part delivery, a self-collected order or a customer with no price list on file is flagged for the team to confirm — never guessed. - Where does our data live?
The delivery sheet and the signed delivery notes stay the importer's own files, and the statements come back as separate Excel files — the original sheet is never changed. Who has access to what is agreed with you during the free audit, before anything is built.
Tools we used
The results
- Every delivery is priced from that customer's own price list and checked against its signed note before it is billed.
- Part deliveries, self-collected orders and deliveries already billed are caught before the statement goes out, not when the customer disputes it.
- Around HK$31,000 a month of billing time saved — the work of about 1.6 full-time staff.
Representative example — figures illustrative, client anonymised.
Have an operation that looks like this?
Tell us the process and we'll show you exactly how to automate it — free, and no obligation.
Get a Free Automation Audit →