Hospitality · Hong Kong
Invoicing and commission automation for a Hong Kong hotel
Every invoice and every commission, worked out from the booking data.
Corporate, group and agent bookings were invoiced by hand, and every month the commissions were worked out by hand too. We built a system that does both straight from the booking data, with a person approving before anything is sent.
The challenge
Corporate and group invoices were typed up from booking-system exports. Each month, staff worked out what the hotel owed every online travel agency and travel agent — a different rate for each, with cancellations and no-shows taken out — then argued over the invoices that didn't match. Sales-staff commission was a spreadsheet of its own.
The solution
Invoices are generated from the booking data. Commission is calculated per booking by the agreed rules, each agent's commission invoice is checked against what is owed, and monthly statements per agent and per salesperson are prepared — a person approves them before anything is sent.
The workflow we built
- Booking data in. The hotel's booking system export is picked up on a schedule — nothing changes for the front desk or the sales team.
- Invoices generated. Corporate and group invoices are filled from the booking record, not retyped.
- Commission calculated. Each booking's commission is worked out at the agreed rate for its channel or agent; cancellations and no-shows are left out automatically.
- Checked, approved, sent. An agent invoice that doesn't match what is owed lands on a mismatch report, and monthly statements wait for a person to approve them.
A week before, a week after
| Topic | Before | After |
|---|---|---|
| Invoicing | Corporate and group invoices were typed up by hand from booking-system exports. | Invoices are generated from the booking data — nothing changes for the front desk. |
| Commission | Each month, staff worked out what was owed to every online travel agency and travel agent, at a different rate for each. | Commission is calculated per booking at the agreed rate for each channel and agent. |
| Cancellations | Cancellations and no-shows had to be found and taken out by hand. | Cancellations and no-shows are left out automatically. |
| Disputes | When an agent's commission invoice didn't match, settling it meant going back through the bookings one by one. | A mismatch report shows exactly which lines of an agent's invoice don't match what is owed. |
| Sales commission | Sales-staff commission lived in a separate spreadsheet, rebuilt every month. | Monthly statements per agent and per salesperson are ready for a person to approve before anything is sent. |
How the saving adds up
- About 1,550 bookings a month carry an invoice or a commission, at roughly 12 minutes each to invoice, work out the commission, check it against the agent's claim and add it to the salesperson's sheet.
- 1,550 bookings × 12 minutes ≈ 310 hours a month.
- 310 hours × HK$110 an hour ≈ HK$34,000 a month.
- 310 ÷ 173 hours (one full-time month) ≈ 1.8 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 invoices and commission worked out from the booking-system exports.
- Built on their own files. The rules were built and tested on their own past bookings, agent agreements and commission invoices, checked against what the team had already worked out.
- Side by side. For a month the team kept working out commission by hand while the system ran on the same bookings, and the two were compared line by line.
- Live, then monitored. Once they matched, the manual month-end stopped and only mismatches 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 month-end hours went back to guests and 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 booking that doesn't fit an agreed rule, or an agent line that doesn't match, is flagged for the team to check — never guessed. - Where does our data live?
The booking data stays in the hotel's booking system and its own spreadsheets. Who has access to what is agreed with you during the free audit, before anything is built.
Tools we used
The results
- A month-end of working out commissions by hand became a review of the mismatch report.
- Agent disputes are settled line by line from the report, not by going back through the bookings.
- Around HK$34,000 of admin cost saved every month — the work of about 1.8 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 →