A site subcontractor · Hong Kong

Foremen's Excel work sheets to daily wages and site cost splits

No clock: foremen send daily Excel work sheets by WhatsApp. Trade rates, half-days and cross-site work feed wages and project costs.

171.9 hoursestimated time saved a month
TargetTraceablerules shown with the output
TargetReviewedexceptions reach a person

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 site subcontractor has 60 daily-rated workers across 8 sites. There is no clock-in system. Foremen's daily Excel work sheets sent by WhatsApp are the record of who works where and for how much of the day.

At a glance

The files they already use

  • Foremen's daily work sheets Excel
  • Work sheets sent by WhatsApp
AI systembuilt around their rules
  • No clock: use confirmed foremen's work sheets
  • Day rates are the subcontractor's own rates by trade
  • Half-days and site references remain attached
  • Split employer MPF by days

Done automatically

  • Daily-wage sheet and project cost allocation
  • Exceptions for review

Foremen confirm the work sheets; the office approves wages and site allocations.

How they used to do it

The office opens each foreman's work sheet and retypes attendance into a monthly wage file. Trade rates are kept separately, and a half-day has to remain a half-day when the entries are combined.

A worker moving between sites appears on different sheets. The office must pay the worker once, yet show the wage and employer contribution against the right projects. Sorting only by name loses the site split.

The difficulties

  • Collect work sheets The office retypes each WhatsApp attachment into a wage file.
  • Retain half-days Half-day entries are adjusted manually when combining sheets.
  • Apply trade rates The clerk looks up each worker's trade rate separately.
  • Split site wages Cross-site workers need a second calculation for project accounts.
  • Allocate contributions Employer contributions are assigned after wages have been completed.

Their formula, broken down

Bar-bender Ho has a sample day rate of HK$2,200 set by the subcontractor. Site A and Site B feed the same wage calculation.

Their formulaWage = approved equivalent days × trade day rate; site cost follows days at each site
  1. Convert half-days

    Site A has 17 full days and 2 half days; Site B has 3 days.

    Site A 18 days + Site B 3 days21 days

  2. Calculate and split wages

    The same rate applies to the approved days.

    21 × HK$2,200HK$46,200

  3. Apply employee MPF cap

    Ho is a regular employee paid monthly (all 21 days fall in one monthly wage period), so the monthly cap applies: relevant income exceeds HK$30,000 and employee MPF is capped at HK$1,500. Casual workers under the industry scheme use the daily contribution table instead.

    HK$46,200 − HK$1,500HK$44,700

  4. Split employer MPF

    The capped employer contribution is split by site days.

    HK$1,500: Site A HK$1,285.71 + Site B HK$214.29HK$1,500

Net pay to HoHK$44,700

What the system produces

sample.alveek.ai/payroll-site-workersSample data

Source records

Foremen's daily work sheets ExcelWork sheets sent by WhatsApp
SourceRecord
Site A17 full + 2 half days = 18 days
Site B3 days
Trade day rateHK$2,200

Daily-wage sheet and project cost allocation

Review sheet (Excel)Output for approval (PDF)
ItemResult / basis
Site A / B wage costHK$39,600 / HK$6,600
Gross wageHK$46,200
Employee MPFHK$1,500
Employer MPF: A / BHK$1,285.71 / HK$214.29
Net payHK$44,700

How it was calculated

Wage = approved equivalent days × trade day rate; site cost follows days at each site

HK$44,700

Flagged for a person to confirm

  • A work sheet without confirmed trade, day fraction or site reference waits for the foreman; no clock-in times are invented.

In this example: The output retains the source records and the rule behind each item. Foremen confirm the work sheets; the office approves wages and site allocations.

How we helped

We connect the existing source files to a review sheet, with the company's rules recorded beside the results. Foremen confirm the work sheets; the office approves wages and site allocations.

  1. Collect work sheets Daily Excel work sheets are imported with the foreman and site reference retained.
  2. Retain half-days Full and half days stay visible in the employee's approved day total.
  3. Apply trade rates The worker's confirmed trade selects the subcontractor's recorded day rate.
  4. Split site wages The combined wage retains each site's days and wage cost.

What the system handles

Collect work sheets

Daily Excel work sheets are imported with the foreman and site reference retained.

Retain half-days

Full and half days stay visible in the employee's approved day total.

Apply trade rates

The worker's confirmed trade selects the subcontractor's recorded day rate.

Split site wages

The combined wage retains each site's days and wage cost.

Allocate contributions

Employer MPF is allocated by the approved days at each site, with the split shown for review.

Before and after

TopicBeforeAfter
Collect work sheetsThe office retypes each WhatsApp attachment into a wage file.Daily Excel work sheets are imported with the foreman and site reference retained.
Retain half-daysHalf-day entries are adjusted manually when combining sheets.Full and half days stay visible in the employee's approved day total.
Apply trade ratesThe clerk looks up each worker's trade rate separately.The worker's confirmed trade selects the subcontractor's recorded day rate.
Split site wagesCross-site workers need a second calculation for project accounts.The combined wage retains each site's days and wage cost.
Allocate contributionsEmployer contributions are assigned after wages have been completed.Employer MPF is allocated by the approved days at each site, with the split shown for review.

How much time it saves

  • Retyping: 8 sheets × 22 days × 35 min ≈ 102.7 h; pay: 60 × 1.5 h = 90 h; total ≈ 192.7 h.
  • Checks: 8 × 22 × 3 min ≈ 8.8 h; payroll review: 60 × 12 min = 12 h; total = 20.8 h.
  • Estimated time saved ≈ 171.9 h a month, rounded for display.
  • The estimate values office time at HK$110 an hour (about HK$19,000 a month for a clerk, MPF included); it is not an audited cash return.
  • Unrounded time saved × HK$110 ≈ HK$18,905, about HK$18,900 a month.

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

How a project like this runs

  1. Read the actual source files. We review the existing inputs with the staff who prepare them and identify where each field comes from.
  2. Record the rules. We turn the agreed rules into visible checks, using completed records to compare the output with the office's own calculation.
  3. Run alongside the existing process. The office keeps its normal process while the system handles the same files. Staff compare the results and resolve differences before switching.
  4. Use and maintain it. Once the results agree, staff use the review sheet and handle its flags. Changes to source formats or company rules are checked before they are applied.

Questions owners usually ask

  • Do workers need to clock in?
    No. This case uses the foremen's daily work sheets; it does not introduce a clock.
  • Are the trade rates statutory rates?
    No. The subcontractor sets its own rates; HK$2,200 is sample data in this example.
  • Does this automate site work?
    It handles the office calculation after the foremen report work. Foremen still confirm attendance and site allocation.

The results

  • Daily Excel work sheets are imported with the foreman and site reference retained.
  • Full and half days stay visible in the employee's approved day total.
  • The worker's confirmed trade selects the subcontractor's recorded day rate.
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 →