Construction · Fit-out & E&M · Hong Kong

Progress claim automation for a Hong Kong fit-out contractor

Forty jobs, forty claim forms, one set of contract rules — and every figure now shows how it was reached.

220 hoursestimated time saved a month
Target0unsigned variations claimed
TargetSame dayclaims ready after the site report closes

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 fit-out and E&M contractor runs around 40 office and shop fit-outs at a time, each billed by a monthly interim payment application to the main contractor. Getting those claims right — and accepted the first time — decides when the company gets paid.

At a glance

The files they already use

  • Site progress sheet
  • Foremen's site photos
  • Contract bill of quantities
  • Signed variation orders
  • Payment certificates
AI systembuilt around their rules
  • Contract rate × % complete, item by item
  • Signed variations only
  • 10% retention, capped at 5% of the contract
  • Each certificate deducted once
  • Each main contractor's own form

Done automatically

  • Interim payment application
  • Valuation breakdown
  • Retention register
  • Cover email — drafted

The QS reviews and signs every claim before it is sent.

How they used to do it

Every month-end, the office clerk opened last month's Excel claim for each of the 40 jobs and saved a copy. The site foremen reported progress as WhatsApp messages and photos — “partitions about 80%, electrical about 60%” — and the clerk typed those percentages into the claim, item by item.

Variation orders sat in a separate folder, some signed and some only agreed on site. Retention, its cap and the earlier certificates were worked out on a calculator and checked by the QS, and the final figures were then retyped into each main contractor's own claim form.

The difficulties

  • Rejected claims. Claiming a single variation with no signed instruction got the whole claim returned — and pushed the payment back a month.
  • Retention over-deducted. Once the 5% cap was reached, the spreadsheet kept deducting 10% unless someone remembered to stop it.
  • Double deductions. Earlier certificates were found by searching old emails, so a certificate could easily be deducted twice.
  • Every form different. Each main contractor insisted on its own claim form, so the same figures were typed in twice.
  • Knowledge in one head. Only the QS knew every contract's retention terms by heart, so claims waited whenever the QS was on leave.

Their formula, broken down

An interim claim looks like one number. Behind it are four separate rules, and a mistake in any one of them sends the whole claim back. Here is claim No. 4 on a HK$1,280,000 office fit-out.

Their formulaAmount due = (work done + signed variations) − retention (10%, capped at 5% of the contract sum) − amounts already certified
  1. Value the work done, item by item

    Each bill item is valued at its contract sum × the percentage the site team reported: partitions 80%, electrical 60%, air-conditioning 50%, painting 20%.

    partitions HK$336,000 + electrical HK$216,000 + air-con HK$150,000 + painting HK$40,000HK$742,000

  2. Add only the signed variations

    VO-03 adds cove lighting and VO-05 omits the raised floor. VO-06 has only a verbal instruction, so it is left out and flagged for follow-up.

    VO-03 HK$38,500 − VO-05 HK$24,000+HK$14,500

  3. Work out the retention — and its cap

    The contract keeps 10% of the valuation, but never more than 5% of the contract sum. 10% would be HK$75,650, so the cap of HK$64,000 applies instead.

    min(valuation HK$756,500 × 10%, contract sum HK$1,280,000 × 5%)−HK$64,000

  4. Deduct what was certified before

    Claims 1 to 3 were certified for HK$520,000 in total. Each certificate is deducted once — and only once.

    Certificates 1 + 2 + 3−HK$520,000

Amount due on claim No. 4HK$172,500

What the system produces

claims.alveek.ai/J-2611/IPA-04Sample data

Progress reported by the site team

September site report.xlsxContract BQ.xlsxSigned VOs (PDF)
Bill itemContract HK$Done
Partitions and ceilings420,00080%
Electrical installation360,00060%
Air-conditioning and ductwork300,00050%
Painting and finishes200,00020%
VO-03 cove lighting (signed)+38,500100%
VO-05 raised floor omitted (signed)−24,000—
VO-06 extra sockets (verbal only)+12,800100%
Contract sum1,280,000

Interim payment application No. 4

IPA-04.pdf (main contractor's form)Valuation breakdown.xlsx
ItemBasisHK$
Work done to date4 items × % complete742,000
Signed variationsVO-03 and VO-0514,500
Gross valuationHK$742,000 + HK$14,500756,500
Less retention10% = HK$75,650 → capped at 5%−64,000
Less certified, claims 1–3Certificates on file−520,000
Amount due this claim172,500

How it was calculated

Amount due = gross valuation − retention − amounts certified in earlier claims

= HK$756,500 − HK$64,000 − HK$520,000 = HK$172,500

Flagged for a person to confirm

  • VO-06 (+HK$12,800): no signed instruction on file — kept out of this claim until the client's representative signs.
  • Painting jumped from 5% to 20% in one month — the site photos are attached for the QS to confirm.

In this example: the claim is valued item by item from the site report, the unsigned variation is held back, and retention stops at its 5% cap instead of being over-deducted.

How we helped

We build one record per job — the contract bill of quantities, every variation with its instruction, and every certificate received — and a system that turns the site team's normal progress report into a finished claim. The foremen change nothing about how they report; the QS stops typing and starts reviewing.

  1. Progress comes in. The foremen keep filling in the same progress sheet and sending photos; the system reads the percentage complete for each bill item.
  2. Checked against the documents. Every variation is matched to its signed instruction, and every earlier claim to its certificate. Anything without a document is flagged, never claimed.
  3. Valued by the contract's own terms. Work done is valued at the contract rates; retention is applied at that contract's rate and cap; previous certified amounts are deducted.
  4. Reviewed, then sent. The claim and its valuation breakdown come out in the main contractor's own form. The QS reviews them, and the cover email is drafted for a person to send.

What the system handles

Quotations

Priced from the contractor's own rate book, with a separate schedule for each main contractor and quantity tiers for partition and ceiling work.

Interim claims

Valued item by item from the site progress report, in each main contractor's own claim form.

Variations

Each variation is tracked from instruction to quotation to approval; only signed ones are claimed.

Retention

Deducted at each contract's rate, stopped at its cap, and listed for release at practical completion and at the end of the defects liability period.

Subcontractors

Subcontractor invoices are checked against their subcontract rates and the same progress before they are paid.

Before and after

TopicBeforeAfter
ProgressPercentages were copied by hand from WhatsApp messages into each job's Excel claim.The system reads the site progress sheet directly, with the photos attached to each item.
VariationsVerbal instructions were sometimes claimed, then rejected by the main contractor's QS.Only variations with a signed instruction are claimed; the rest are listed for follow-up.
RetentionThe 5% cap was tracked from memory, and retention was sometimes over-deducted.Retention is worked out on every claim at the contract's rate and stops at its cap.
Earlier claimsEarlier certificates were searched for in email, so a certificate could easily be deducted twice.Every certificate is filed against its claim and deducted exactly once.
Month-endForty claims took most of the last week of every month.Claims are ready the day the site reports close; the QS only reviews and handles the flags.

How much time it saves

  • About 40 interim claims a month, each taking around 6 hours to rebuild: copying progress, adding variations, working out retention and checking earlier certificates.
  • 40 claims × 6 hours = 240 hours a month.
  • With the system, the QS reviews each claim in about 30 minutes: 40 × 0.5 = 20 hours.
  • Time saved ≈ 220 hours a month — about 27.5 working days.
  • At HK$110 an hour (about HK$19,000 a month for one full-time clerk, MPF included), that is about HK$24,200 a month — before counting payments no longer delayed by rejected claims.

These are the working assumptions behind the figure, not an audited result.

How a project like this runs

  1. Free assessment. We sit with your QS and clerk through one real month-end and collect one completed claim from each main contractor.
  2. Built on your own claims. The valuation and retention rules are rebuilt from your past claims and tested until they reproduce the certified figures exactly.
  3. Side by side. For two claim cycles your office prepares claims by hand while the system runs on the same reports, and the two are compared line by line.
  4. Live, then maintained. Once they match, the manual claims stop. New contracts are added with their own retention terms, and we fix anything that comes up.

Questions owners usually ask

  • Does this replace our QS?
    No. The system does the arithmetic and the paperwork; the QS still decides what is claimed and signs off every application. Their time goes into checking, not typing.
  • Every main contractor wants a different form. Is that a problem?
    No. Each main contractor's form is set up once, and every claim for that main contractor comes out in it.
  • What if the site report is wrong?
    A jump in progress that is out of line with the previous month, or progress above 100%, is flagged with the site photos for a person to check before it goes into a claim.

The results

  • Every interim claim is valued item by item from the site report and shows how each figure was reached.
  • Unsigned variations are held back and listed for follow-up, instead of being rejected by the main contractor.
  • Retention and earlier certificates are applied exactly once, by each contract's own terms.
PythonClaudeExcelWhatsAppEmail

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.

← Back to 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 →