A retail chain · Hong Kong
Managers' weekly timesheet Excel to payroll and the 468 check
No clock: each shop manager's weekly Excel timesheet feeds payroll and the 468 continuous-contract check for every part-timer.
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 retail chain has 6 shops, 55 part-time staff and 14 full-time staff. Shop managers submit weekly timesheet Excel instead of clock-in records. The office needs the weekly detail as well as the pay total to check part-time employment under 468.
At a glance
The files they already use
- Shop managers' weekly timesheet Excel
- Keep weekly hours for every part-timer
- 468: employed 4+ weeks and at least 68 hours in each 4-week period
- Check every 4 weeks; retain the period basis
Done automatically
- Pay sheet and continuous-contract review
- Exceptions for review
Managers confirm weekly hours; personnel staff review contract and leave records before payroll approval.
How they used to do it
The office gathers the managers' weekly sheets, matches the same employee between files and totals the payable hours. Different working patterns can produce a valid period total even when individual weeks look short.
A separate check then reviews the continuous-contract status and related leave records. If the wage workbook retains only a monthly total, the office has to reopen the weekly sheets to see how the period was made up.
The difficulties
- Collect weekly hours Managers' weekly Excel sheets are copied into a pay workbook.
- Confirm the period A pay total can hide missing weekly records.
- Run the 468 check Staff can continue checking each week against the old 418 pattern.
- Calculate pay Weekly hours are added again for the hourly wage calculation.
- Review personnel records Contract status and leave checks are kept apart from the hours.
Their formula, broken down
Part-timer Cheung earns HK$62 an hour. The sample 4-week record demonstrates the 468 hours test; the employment-duration condition must also be checked.
Total the weekly hours
Keep each week's entry visible.
15 + 19 + 16 + 20 h70 h
Check the 468 basis
468 requires employment of 4+ weeks and at least 68 hours in each 4-week period.
70 h ≥ 68 hHours threshold met
Compare the former pattern
This record would have failed 418: two weeks are below 18 h. The current review uses 468.
15 h and 16 h < 18 hUse 468
Calculate the period's wage
Use the approved hours and Cheung's hourly rate.
70 h × HK$62HK$4,340
What the system produces
Source records
| Source | Record |
|---|---|
| Weekly hours | 15 / 19 / 16 / 20 h |
| Hourly rate | HK$62 |
Pay sheet and continuous-contract review
| Item | Result / basis |
|---|---|
| 4-week hours | 70 h |
| 468 hours test | 70 h ≥ 68 h; check employment duration |
| Pay basis | 70 × HK$62 |
| Period pay | HK$4,340 |
How it was calculated
Period pay = approved hours × hourly rate; 468 checks duration and each 4-week period's hours
HK$4,340
Flagged for a person to confirm
- Missing weekly sheets or unconfirmed employment duration require personnel review; a wage total alone does not establish contract status.
In this example: The output retains the source records and the rule behind each item. Managers confirm weekly hours; personnel staff review contract and leave records before payroll approval.
How we helped
We connect the existing source files to a review sheet, with the company's rules recorded beside the results. Managers confirm weekly hours; personnel staff review contract and leave records before payroll approval.
- Collect weekly hours Weekly timesheets are imported by employee and shop while preserving each week.
- Confirm the period The review lists the weekly records behind each 4-week period and flags missing inputs.
- Run the 468 check The 468 review uses employment duration and the hours in each 4-week period, with the basis shown.
- Calculate pay Approved period hours feed the hourly pay calculation without replacing the weekly detail.
What the system handles
Collect weekly hours
Weekly timesheets are imported by employee and shop while preserving each week.
Confirm the period
The review lists the weekly records behind each 4-week period and flags missing inputs.
Run the 468 check
The 468 review uses employment duration and the hours in each 4-week period, with the basis shown.
Calculate pay
Approved period hours feed the hourly pay calculation without replacing the weekly detail.
Review personnel records
Personnel staff review flagged status and leave records beside the supporting timesheets.
Before and after
| Topic | Before | After |
|---|---|---|
| Collect weekly hours | Managers' weekly Excel sheets are copied into a pay workbook. | Weekly timesheets are imported by employee and shop while preserving each week. |
| Confirm the period | A pay total can hide missing weekly records. | The review lists the weekly records behind each 4-week period and flags missing inputs. |
| Run the 468 check | Staff can continue checking each week against the old 418 pattern. | The 468 review uses employment duration and the hours in each 4-week period, with the basis shown. |
| Calculate pay | Weekly hours are added again for the hourly wage calculation. | Approved period hours feed the hourly pay calculation without replacing the weekly detail. |
| Review personnel records | Contract status and leave checks are kept apart from the hours. | Personnel staff review flagged status and leave records beside the supporting timesheets. |
How much time it saves
- Existing work: 26 weekly sheets × 1.5 h = 39 h; pay 69 × 1.5 h = 103.5 h; 468/leave checks 55 × 45 min = 41.25 h; total 183.75 h.
- Review: 26 × 12 min = 5.2 h; 69 × 12 min = 13.8 h; total 19 h.
- Estimated time saved: 183.75 − 19 = 164.75 h a month.
- 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.
- 164.75 h × HK$110 ≈ HK$18,122, about HK$18,100 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 this need a clock-in system?
No. The inputs are each shop manager's weekly Excel timesheets. - Is a 70-hour total enough by itself?
No. Employment of 4+ weeks must also be confirmed, and the hours are checked in each 4-week period. - Who reviews uncertain contract status?
Personnel staff review the supporting weekly sheets and employment record. The system surfaces the basis and the gaps.
The results
- Weekly timesheets are imported by employee and shop while preserving each week.
- The review lists the weekly records behind each 4-week period and flags missing inputs.
- The 468 review uses employment duration and the hours in each 4-week period, with the basis 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 →