A logistics warehouse · Hong Kong

Paper timecard photos to payroll: night allowance and overtime from punch times

OCR reads paper timecard photos; night allowance and overtime follow the warehouse's rules, with unclear punches sent to the supervisor.

156 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 logistics warehouse has 60 workers and uses paper timecards. Payroll starts with photos of those cards, not an app export. The difficult part is reading each punch correctly before applying the company's overtime and night-allowance rules.

At a glance

The files they already use

  • Paper timecard photos
AI systembuilt around their rules
  • OCR extracts punches; unclear entries require confirmation
  • Overtime follows the company's own rule
  • Night allowance uses confirmed nights

Done automatically

  • Payroll sheet with timecard evidence
  • Exceptions for review

The supervisor confirms flagged punches; payroll staff approve the pay before payment.

How they used to do it

The clerk enlarges each timecard photo and copies the punches into Excel. A faded stamp or a missing punch sends the clerk back to the supervisor, while the rest of that worker's calculation waits.

Night allowance is counted separately from overtime. The office then combines basic pay, approved overtime and night allowance before checking contributions and net pay. Retyping makes it difficult to trace a disputed figure back to the card.

The difficulties

  • Read the cards Punch times are retyped from photos into Excel.
  • Resolve unclear punches Faded or missing stamps leave unresolved gaps in the wage sheet.
  • Calculate overtime Overtime is worked out separately on a calculator.
  • Count night allowance Night shifts are counted again when preparing allowances.
  • Review net pay Basic pay, additions and deductions sit in separate working files.

Their formula, broken down

Worker Wong has monthly pay of HK$16,500. The overtime rule below is the warehouse's own rule, not a statutory rate.

Their formulaGross pay = monthly pay + approved overtime + night allowance; net pay = gross − employee MPF
  1. Apply the company overtime rule

    Use the monthly-pay basis and the confirmed overtime hours.

    HK$16,500 ÷ 26 ÷ 8 × 1.5 ≈ HK$118.99/h; 18.5 hHK$2,201.32

  2. Add night allowance

    Use the confirmed nights and the company's allowance.

    12 nights × HK$80HK$960

  3. Combine gross pay

    Keep basic pay, overtime and allowance visible.

    HK$16,500 + HK$2,201.32 + HK$960HK$19,661.32

  4. Deduct employee MPF

    Employee MPF is 5% of relevant income.

    HK$19,661.32 × 5% = HK$983.07HK$18,678.25

Net payHK$18,678.25

What the system produces

sample.alveek.ai/payroll-warehouseSample data

Source records

Paper timecard photos
SourceRecord
Monthly payHK$16,500
Approved overtime18.5 h
Night shifts12 nights

Payroll sheet with timecard evidence

Review sheet (Excel)Output for approval (PDF)
ItemResult / basis
OvertimeHK$2,201.32
Night allowanceHK$960
Gross payHK$19,661.32
Employee MPFHK$983.07
Net payHK$18,678.25

How it was calculated

Gross pay = monthly pay + approved overtime + night allowance; net pay = gross − employee MPF

HK$18,678.25

Flagged for a person to confirm

  • An unreadable or missing punch remains an exception until the supervisor confirms it.

In this example: The output retains the source records and the rule behind each item. The supervisor confirms flagged punches; payroll staff approve the pay before payment.

How we helped

We connect the existing source files to a review sheet, with the company's rules recorded beside the results. The supervisor confirms flagged punches; payroll staff approve the pay before payment.

  1. Read the cards OCR places extracted punches beside their source image for checking.
  2. Resolve unclear punches Missing and unclear punches are flagged for the supervisor, rather than filled by inference.
  3. Calculate overtime Confirmed overtime hours use the warehouse's monthly-pay divisor and multiplier, with the calculation shown.
  4. Count night allowance Confirmed night shifts feed the allowance line on the same review sheet.

What the system handles

Read the cards

OCR places extracted punches beside their source image for checking.

Resolve unclear punches

Missing and unclear punches are flagged for the supervisor, rather than filled by inference.

Calculate overtime

Confirmed overtime hours use the warehouse's monthly-pay divisor and multiplier, with the calculation shown.

Count night allowance

Confirmed night shifts feed the allowance line on the same review sheet.

Review net pay

Gross pay, employee MPF and net pay stay together with their source evidence.

Before and after

TopicBeforeAfter
Read the cardsPunch times are retyped from photos into Excel.OCR places extracted punches beside their source image for checking.
Resolve unclear punchesFaded or missing stamps leave unresolved gaps in the wage sheet.Missing and unclear punches are flagged for the supervisor, rather than filled by inference.
Calculate overtimeOvertime is worked out separately on a calculator.Confirmed overtime hours use the warehouse's monthly-pay divisor and multiplier, with the calculation shown.
Count night allowanceNight shifts are counted again when preparing allowances.Confirmed night shifts feed the allowance line on the same review sheet.
Review net payBasic pay, additions and deductions sit in separate working files.Gross pay, employee MPF and net pay stay together with their source evidence.

How much time it saves

  • Existing work: 60 workers × 3 h = 180 h a month.
  • Review: 60 × 24 min = 24 h.
  • Estimated time saved: 180 − 24 = 156 h.
  • 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.
  • 156 h × HK$110 = HK$17,160, about HK$17,200 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

  • Does OCR approve the punches?
    No. It extracts the text; the supervisor resolves missing or unclear punches.
  • Is the overtime multiplier a legal rule?
    No. The example uses the warehouse's own overtime rule.
  • Can staff trace a disputed amount?
    The review sheet retains the timecard image and shows the approved hours and calculation.

The results

  • OCR places extracted punches beside their source image for checking.
  • Missing and unclear punches are flagged for the supervisor, rather than filled by inference.
  • Confirmed overtime hours use the warehouse's monthly-pay divisor and multiplier, with the calculation shown.
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 →