Import & trading · Hong Kong

Invoice automation for a Hong Kong trading company

1,500 supplier invoices a month — entered by no one.

-95%manual keying time
1,500+invoices automated / month
HK$30,000saved / month

Every supplier invoice — scans, photos and PDFs — was re-typed into a spreadsheet by hand. We built an OCR pipeline that turns them into clean, structured rows on their own, with a human touch only where confidence is low.

The challenge

Keying 1,500+ supplier invoices a month kept 1.6 full-time clerks busy, and typos in amounts or invoice numbers caused reconciliation headaches that took even longer to untangle.

The solution

Invoices are forwarded to one inbox. The pipeline reads each document, extracts supplier, date, line items and totals, validates the arithmetic, writes clean rows to the ledger sheet, and flags only low-confidence documents for review.

The workflow we built

  1. One inbox. Suppliers and staff forward invoices to a single address — nothing else changes for them.
  2. Read & extract. OCR plus AI parsing pulls supplier, dates, line items and totals from scans, photos and PDFs.
  3. Validate. Totals are recomputed and cross-checked; anything that doesn't add up is flagged, not guessed.
  4. File & reconcile. Clean rows land in the ledger automatically, ready for monthly reconciliation.

A week before, a week after

TopicBeforeAfter
ReceivingEvery supplier invoice — scan, photo or PDF — was typed into the spreadsheet by hand.Invoices are forwarded to one inbox — nothing changes for suppliers.
Data entryOver 1,500 invoices a month kept 1.6 full-time clerks busy.Supplier, date, line items and totals are read from each document.
ErrorsA typo in an amount or an invoice number often showed up only at reconciliation.Totals are recomputed; anything that doesn't add up is flagged, not guessed.
Fixing mistakesUntangling one typo could take longer than keying the invoice in the first place.Clerks spend minutes reviewing the flagged items instead of keying all day.
Month-endMonth-end close waited for the keying to catch up.Clean rows land in the ledger sheet on their own.

How the saving adds up

  • About 1,500 invoices a month, at roughly 11 minutes each to open, key, check and later correct at reconciliation.
  • 1,500 invoices × 11 minutes ≈ 275 hours a month.
  • 275 hours × HK$110 an hour ≈ HK$30,000 a month.
  • 275 ÷ 173 hours (one full-time month) ≈ 1.6 full-time clerks.
  • 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

  1. Free audit. We watched the clerks key real supplier invoices — scans, photos and PDFs — into the spreadsheet.
  2. Built on their own files. Extraction was built and tested on a sample of their own past invoices, checked against what the clerks had already keyed.
  3. Side by side. For a period the clerks kept keying as normal while the pipeline read the same invoices, and the two ledgers were compared row by row.
  4. Live, then monitored. Once they matched, keying stopped and only flagged invoices 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 keying hours went to checking flagged items 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?
    Totals are recomputed and cross-checked. Anything that doesn't add up, or that the pipeline is not confident about, is flagged for a person to check — never guessed.
  • Where does our data live?
    Invoices arrive at one inbox and the rows land in their own ledger sheet. Who has access to what is agreed with you during the free audit, before anything is built.

Tools we used

ClaudeGoogle SheetsEmail

The results

  • Keying that kept 1.6 clerks busy full-time became minutes of reviewing flagged items.
  • Amount and invoice-number typos disappeared, so reconciliation stopped throwing surprises.
  • Around HK$30,000 of admin time saved monthly — the work of about 1.6 full-time clerks — and month-end closes faster.

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 →