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.
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
- 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.
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
Add night allowance
Use the confirmed nights and the company's allowance.
12 nights × HK$80HK$960
Combine gross pay
Keep basic pay, overtime and allowance visible.
HK$16,500 + HK$2,201.32 + HK$960HK$19,661.32
Deduct employee MPF
Employee MPF is 5% of relevant income.
HK$19,661.32 × 5% = HK$983.07HK$18,678.25
What the system produces
Source records
| Source | Record |
|---|---|
| Monthly pay | HK$16,500 |
| Approved overtime | 18.5 h |
| Night shifts | 12 nights |
Payroll sheet with timecard evidence
| Item | Result / basis |
|---|---|
| Overtime | HK$2,201.32 |
| Night allowance | HK$960 |
| Gross pay | HK$19,661.32 |
| Employee MPF | HK$983.07 |
| Net pay | HK$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.
- 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.
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
| Topic | Before | After |
|---|---|---|
| Read the cards | Punch times are retyped from photos into Excel. | OCR places extracted punches beside their source image for checking. |
| Resolve unclear punches | Faded 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 overtime | Overtime 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 allowance | Night shifts are counted again when preparing allowances. | Confirmed night shifts feed the allowance line on the same review sheet. |
| Review net pay | Basic 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
- Read the actual source files. We review the existing inputs with the staff who prepare them and identify where each field comes from.
- Record the rules. We turn the agreed rules into visible checks, using completed records to compare the output with the office's own calculation.
- 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.
- 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.
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.
Related case studies
Also useful: Back-office outsourcing · Try a working demo · Free tools · 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 →