Business services · Air-conditioning maintenance · Hong Kong
Job sheet to invoice automation for a Hong Kong air-conditioning company
Thirty technicians, 400 contract customers, one price list — and every repair invoice now shows the rule behind each line.
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 Hong Kong air-conditioning maintenance company with about 30 technicians looks after about 400 maintenance-contract customers — offices, shops and clinics — and also takes call-out repairs. Each visit ends with a job sheet, and each job sheet has to become the right invoice: whether the customer is on contract, the time of day, the parts used and their warranty all change the price.
At a glance
The files they already use
- Photos of signed job sheets
- Maintenance contract list
- Parts price list
- Technicians' job photos
- Service history per unit
- No call-out charge for contract customers
- Labour by time band: × 1.5 after hours, × 2 on Sundays and holidays
- Parts from the price list, less the contract discount
- Warranty parts not charged
- Repeat visit within 30 days = warranty revisit, unless a new fault
Done automatically
- Repair invoices, one per job
- Quarterly contract bills
- Parts and warranty register
- Cover email — drafted
The service manager reviews every invoice before it is sent.
How they used to do it
Technicians filled in a paper job sheet at every visit — time in, time out, parts used, the customer's signature — and sent a photo of it on WhatsApp at the end of the day. The paper copies came back to the office once a week.
The clerk then looked up whether the customer had a maintenance contract, the part prices and whether the unit had been visited recently, worked out the labour on a calculator and typed each invoice by hand. Quarterly bills for the 400 contract customers were prepared separately from the contract list.
The difficulties
- Warranty parts charged. A part replaced a few weeks earlier was sometimes charged again, and the customer called to complain.
- After-hours rates missed. Evening and Sunday jobs were often billed at the normal rate because the times on the sheet were not checked.
- Discounts by memory. Whether a customer was on contract, and what discount they had, depended on the clerk remembering.
- Unsigned sheets. Invoices went out on job sheets the customer had never signed, and some were disputed months later.
- Slow to bill. With paper sheets arriving weekly, some repairs were invoiced two or three weeks after the job.
Their formula, broken down
A repair invoice looks like parts plus labour. Behind it are five separate rules. Here is one after-hours repair for a contract clinic, Clinic C: a split-type unit whose indoor fan stopped in the evening.
Waive the call-out charge
The standard call-out charge is HK$450. Clinic C is on a maintenance contract, so it is waived.
call-out HK$450, contract customer → waivedHK$0
Check for a repeat visit, then price the labour
The same unit was visited 12 days ago, so this would normally be a warranty revisit with no labour charge. The technician recorded a new fault — a seized fan motor — so labour is charged. The job ran from 19:30 to 21:30, after hours: 2 hours at HK$380 × 1.5.
labour 2 hours × HK$380 × 1.5 (after hours)+HK$1,140
Price the parts from the list, less the discount
The new fan motor is HK$1,280 on the price list. Contract customers get 15% off parts.
fan motor HK$1,280 × (1 − 15% discount)+HK$1,088
Do not charge the warranty part
The run capacitor was replaced on the visit 12 days ago and is still under the company's 90-day parts warranty. It is listed at HK$180 but not charged.
run capacitor HK$180, under warranty → not chargedHK$0
What the system produces
Job sheet from the technician
| Job sheet line | Qty | List HK$ |
|---|---|---|
| Labour, 19:30–21:30 (after hours) | 2 hours | HK$380 an hour |
| Indoor fan motor (FM-220), new fault | 1 | 1,280 |
| Run capacitor, fitted 12 days ago | 1 | 180 |
| Drain pump — not on the price list | 1 | — |
| Customer signature | Signed | |
Repair invoice for Clinic C
| Item | Basis | HK$ |
|---|---|---|
| Call-out charge | Contract customer — waived | 0 |
| Labour, after hours | labour 2 hours × HK$380 × 1.5 (after hours) | 1,140 |
| Indoor fan motor | HK$1,280 less 15% contract discount | 1,088 |
| Run capacitor | Under 90-day parts warranty | 0 |
| Invoice total | 2,228 | |
How it was calculated
Invoice = call-out + labour + parts less the contract discount; warranty parts at nil
= HK$0 + HK$1,140 + HK$1,088 + HK$0 = HK$2,228
Flagged for a person to confirm
- Repeat visit: the same unit was serviced 12 days ago. The technician recorded a new fault, so labour is charged — the service manager confirms before the invoice goes out.
- Drain pump: used on this job but not on the price list — kept off the invoice until the office sets a price.
- Job sheet JS-24822 at another customer has no customer signature — that invoice is held until the signed sheet is received.
In this example: the contract clinic pays no call-out charge, the evening labour carries the after-hours rate, the repeat visit is charged only because a new fault was recorded, and the warranty part is listed at nil.
How we helped
We build one record per customer and per unit — contract terms, discount, service history, and every part fitted with its warranty end date — and a system that reads each signed job sheet and prices it by those rules. The technicians keep their paper sheets and photograph them on the spot; the clerk stops looking things up and starts checking.
- Job sheets come in. Technicians photograph the signed sheet at the end of each job; the system reads the times, parts and signature.
- Checked against the records. Each job is matched to the contract list, the unit's service history and the price list. Missing signatures, unpriced parts and repeat visits are flagged.
- Priced by the company's own rules. Call-out charges, time bands, contract discounts and warranties are applied line by line, and each line shows its rule.
- Reviewed, then sent. Repair invoices and quarterly contract bills come out ready to check. The service manager reviews them, and the cover emails are drafted for a person to send.
What the system handles
Quotations
Repair and replacement quotations are priced from the same parts list, with the contract discount applied.
Repair invoices
Each job sheet becomes an invoice by the call-out, time-band, discount and warranty rules.
Contract billing
Quarterly bills for about 400 contract customers, prepared from the contract list with renewals flagged.
Warranty register
Every part fitted is recorded against its unit with a warranty end date; warranty status is shown and flagged for review before billing.
Job progress
Open jobs, parts on order and follow-up visits are listed for the office to chase with the customer.
Before and after
| Topic | Before | After |
|---|---|---|
| Job sheets | Photos arrived on WhatsApp and paper copies once a week, so jobs were billed weeks late. | Each signed sheet is read on the day of the job and priced by the next morning. |
| Labour | Evening and Sunday jobs were often billed at the normal rate. | Each job's hours are billed in their own time band. |
| Warranty | Parts still under warranty were sometimes charged again. | Every part fitted is tracked, and warranty parts are listed at nil. |
| Repeat visits | A second visit within weeks was billed in full or not at all, depending on who typed it. | Visits within 30 days are treated as warranty revisits unless a new fault is recorded, and the manager confirms. |
| Signatures | Unsigned job sheets were invoiced and disputed later. | An invoice is held until the job sheet carries the customer's signature. |
How much time it saves
- About 600 repair job sheets a month, each taking around 24 minutes to look up and invoice: contract status, part prices, time band and service history.
- 600 × 24 minutes = 240 hours, plus about 14 hours a month for the quarterly contract bills: about 254 hours a month.
- With the system, the manager reviews each invoice in about 6 minutes and the contract bills in about 4 hours: 600 × 6 minutes + 4 hours = 64 hours.
- Time saved ≈ 190 hours a month — about 24 working days.
- At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$20,900 a month — before counting warranty parts and after-hours labour no longer billed wrongly.
These are the working assumptions behind the figure, not an audited result.
How a project like this runs
- Free assessment. We sit with your clerk through a week of job sheets and collect a finished invoice for each kind of job: contract, non-contract, after hours and warranty.
- Built on your own records. The pricing rules are rebuilt from your past invoices and tested until they reproduce the amounts customers have already paid.
- Side by side. For one month your office invoices by hand while the system prices the same job sheets, and the two are compared line by line.
- Live, then maintained. Once they match, manual invoicing stops. New parts and price changes are added to the list, and we fix anything that comes up.
Questions owners usually ask
- Do our technicians have to use a tablet?
No. They keep the paper job sheet and take a photo of it once the customer has signed. A simple form on the phone also works if they prefer. - Who decides whether a repeat visit is charged?
The rule treats a visit within 30 days as a warranty revisit unless the technician records a new fault. Either way it is flagged, and the service manager makes the final call. - Are invoices sent automatically?
No. The system prepares each invoice and drafts the cover email; a person reviews and sends it. Nothing is sent by WhatsApp automatically.
The results
- Every repair invoice applies the call-out, time-band, discount and warranty rules line by line, and shows the rule behind each line.
- Warranty parts and possible warranty revisits are shown and flagged for review before billing.
- Unsigned job sheets and unpriced parts are held for a person instead of being invoiced.
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 →