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.

164.75 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 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
AI systembuilt around their rules
  • 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.

Their formulaPeriod pay = approved hours × hourly rate; 468 checks duration and each 4-week period's hours
  1. Total the weekly hours

    Keep each week's entry visible.

    15 + 19 + 16 + 20 h70 h

  2. 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

  3. 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

  4. Calculate the period's wage

    Use the approved hours and Cheung's hourly rate.

    70 h × HK$62HK$4,340

Pay for the periodHK$4,340

What the system produces

sample.alveek.ai/payroll-retail-parttimeSample data

Source records

Shop managers' weekly timesheet Excel
SourceRecord
Weekly hours15 / 19 / 16 / 20 h
Hourly rateHK$62

Pay sheet and continuous-contract review

Review sheet (Excel)Output for approval (PDF)
ItemResult / basis
4-week hours70 h
468 hours test70 h ≥ 68 h; check employment duration
Pay basis70 × HK$62
Period payHK$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.

  1. Collect weekly hours Weekly timesheets are imported by employee and shop while preserving each week.
  2. Confirm the period The review lists the weekly records behind each 4-week period and flags missing inputs.
  3. Run the 468 check The 468 review uses employment duration and the hours in each 4-week period, with the basis shown.
  4. 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

TopicBeforeAfter
Collect weekly hoursManagers' weekly Excel sheets are copied into a pay workbook.Weekly timesheets are imported by employee and shop while preserving each week.
Confirm the periodA 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 checkStaff 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 payWeekly hours are added again for the hourly wage calculation.Approved period hours feed the hourly pay calculation without replacing the weekly detail.
Review personnel recordsContract 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

  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 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.
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 →