Telecom sales · Hong Kong
Quotation and document automation for a Hong Kong telecom sales business
From order log to finished forms and quotes — in seconds.
This team sells telecom plans to business customers. Every order used to be re-typed by hand into supplementary order forms and quotation documents. We built a generator that reads their order log and produces every document automatically — formatted, accurate and ready to send.
The challenge
Two staff spent most of every day copying details from the order log into forms and quotes, one at a time — close to an hour per batch, several batches a day. Manual copying meant the occasional wrong figure or missed field — and a customer chasing a corrected quote.
The solution
A tool that reads the Customer Order Log spreadsheet and generates a filled order form plus quotation for every customer — individually or the whole batch as a ZIP — using their exact document templates.
The workflow we built
- Upload once. The team drops in the order log exactly as they already keep it — no new format to learn.
- Parse & validate. Each row is checked for missing or inconsistent fields before any document is generated.
- Generate documents. Order form + quotation per customer, correctly formatted and filled from the source data.
- Batch export. One click produces the full batch as a ZIP, named and ready to send.
A week before, a week after
| Topic | Before | After |
|---|---|---|
| Data entry | Two staff copied each order from the log into an order form and a quotation, one field at a time. | The team uploads the order log exactly as they already keep it. |
| Time per batch | Each batch took close to an hour, and there were several batches a day. | The batch takes seconds; staff look it over and send it. |
| Errors | A wrong figure or a missed field was often found only when the customer spotted it. | Every row is checked for missing or inconsistent fields before anything is generated. |
| Corrections | A corrected quote meant redoing the document by hand while the customer waited. | One click produces the order form and quotation for every customer, as one ZIP. |
| Same-day quotes | Orders that came in late in the day often waited until the next day for a quote. | A quarter more quotes go out the same day the order arrives. |
How the saving adds up
- Two staff each spent about 145 hours a month on this work — roughly 6½ hours of every working day copying orders into forms and quotes, and fixing mistakes.
- 2 staff × 145 hours ≈ 290 hours a month.
- 290 hours × HK$110 an hour ≈ HK$32,000 a month.
- 290 ÷ 173 hours (one full-time month) ≈ 1.7 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 two staff and watched a real batch go from the order log to finished forms and quotes.
- Built on their own files. The generator was built and tested on a sample of their real order log, using their exact document templates.
- Side by side. For a period the team kept preparing batches by hand while the generator ran on the same orders, and the two were compared line by line.
- Live, then monitored. Once the output matched, the manual batches stopped. We monitor it and fix anything that comes up after go-live.
Questions owners usually ask
- Did anyone lose their job?
The hours went into selling. What to do with freed-up time is always the owner's decision, not ours. - What happens when it gets something wrong?
Every row is checked before any document is generated. A row with a missing or inconsistent field is flagged for the team to fix, so it never becomes a wrong quote. - Where does our data live?
The order log stays in the spreadsheet the team already keeps, and the finished documents come back to them as a ZIP. Who has access to what is agreed with you during the free audit, before anything is built.
Tools we used
The results
- A batch that took close to an hour is now generated in seconds, with zero copying errors.
- A quarter more quotes go out the same day the order arrives, which customers notice.
- Around HK$32,000 of admin time saved every month — the work of about 1.7 full-time admin staff, redirected into selling.
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 →