Employees

Payroll Cutoff Checklist: Reconciling Attendance for Philippine Shops and Cafés

Prepare payroll inputs with worked examples for missing clock-outs, overnight shifts and pay-rate changes, plus a reusable attendance correction record.

Before a payroll cutoff, reconcile each employee’s schedule, attendance records, corrections and effective pay rates. Resolve missing or conflicting entries with evidence, identify the types of hours and days involved, and give the payroll preparer a reviewed input record that preserves how every correction was made.

For a Philippine shop or café, the difficult cases often occur around opening, closing and shift handovers: someone forgets to clock out, a shift crosses midnight, or a rate changes halfway through the pay period. A clean-looking total can still produce the wrong payroll if those details disappear.

This guide covers attendance preparation for an employer’s payroll process. It includes three worked cases and a copyable correction record. It does not calculate withholding tax, contributions or complete take-home pay. All employees, rates and events in the examples are fictional.

What are the cutoff, pay period and payday?

The pay period is the span of work or entitlement the payroll covers. The attendance cutoff is the deadline used to collect and review the records for that run. Payday is when wages are due to be paid. Write down each separately, including the year and the Philippine-time boundary used for attendance.

An administrative cutoff does not determine whether recorded work is compensable. Nor should an unresolved clock entry become an automatic reason to postpone the entire payroll. Assign discrepancies for prompt resolution while meeting the applicable payment requirements. Labor Code Article 103 provides the general rule of wage payment at least every two weeks or twice monthly, with intervals no longer than 16 days, subject to the provisions stated there.

For an overnight operation, arrange the data collection so the reviewer can see the full shift, including a clock-out after the period boundary. Keep the actual timestamps even if the payroll system assigns the shift to a particular business date. Confirm how that assignment affects the applicable pay rules before finalizing it.

What records should be ready before you start?

Use one employee list with a stable employee identifier. Names alone can fail when two staff members share a name or someone works at more than one location.

Record What the reviewer needs to establish
Employee and branch assignment Who worked, where, and whether a transfer or temporary assignment affected the record
Published schedule and changes Expected shifts, rest days, approved swaps and who recorded a change
Original clock entries Actual recorded timestamps, device or source, and any duplicate or missing entries
Leave and attendance explanations The dates, leave category or reported event, and supporting information appropriate to it
Pay-rate history Pay basis, amount, effective date and evidence authorizing the change
Coverage and calendar notes Applicable wage reference, holiday/rest-day classification and relevant employee or establishment coverage
Previous adjustments What was already corrected or paid, so it is not included a second time

Keep original logs alongside reviewed entries. A correction should explain a change, not erase the evidence that a clock-out was missing.

For wage references, consult the NWPC’s regional wage information and the applicable wage order. Confirm the region, establishment classification, effective date and any relevant exemption before using a rate. A rate applicable to one branch’s location does not establish the rate for every Philippine branch.

Which hours need a closer look?

Clocked time and compensable time are related, but they are not always identical. The DOLE–BWC 2024 handbook, printed pages 7–9, covers time required on duty or permitted to be worked. It also identifies short rest breaks of 5–20 minutes as compensable. Apply the relevant conditions rather than automatically deducting every gap as unpaid time.

Investigate opening preparation, closing tasks, work during a scheduled meal break, and time after the planned end of a shift. A schedule shows what was planned; it does not prove when work stopped. Record what happened and have the appropriate reviewer classify it.

Missing clock-out: reconstruct the record without guessing

Suppose an employee has a 09:00 clock-in and no clock-out. The scheduled shift ends at 18:00. The employee reports working until 18:00 with a fully duty-free meal break from 12:00 to 13:00, and the supervisor confirms witnessing the end of the shift and verifies the break.

Item Hypothetical reviewed record
Original entry 09:00 clock-in; clock-out missing
Evidence Employee’s dated explanation and supervisor’s confirmation of the actual shift and break
Corrected interval 09:00–18:00, marked as a reviewed manual correction
Time calculation 9 elapsed hours − 1 verified noncompensable meal hour = 8 work hours
Audit note Original retained; reason, correction date and reviewer recorded

A POS transaction near closing may help identify a period to investigate. It does not prove the employee left immediately afterward. If the evidence establishes a later end time, use that evidence and review the additional work instead of forcing the entry to match the schedule.

If the actual end remains uncertain, label the uncertainty and assign follow-up. Do not invent a timestamp, default the shift to zero, or mark it absent solely because a punch is missing. The reviewer must decide the pay treatment using the available evidence and applicable requirements.

Overnight shift: preserve dates and overlapping hour categories

Consider another hypothetical shift from 21:00 on September 10 to 06:00 on September 11, with a verified duty-free, noncompensable meal break from 01:00 to 02:00. Assume the employee is covered by the applicable hours-of-work and night-work rules; this example identifies hours, not the final amount payable.

Calculation Result
Elapsed time, 21:00–06:00 9 hours
Less verified noncompensable meal break 1 hour
Total work hours 8 hours
Work before midnight, 21:00–24:00 3 hours
Work after midnight, 00:00–06:00 less the break 5 hours
Work within 22:00–06:00, less the break 7 hours

The seven night-work hours are a subset of the eight work hours. Adding them would incorrectly produce 15 work hours. Keep the categories separate so the payroll calculation can apply the appropriate treatment to the same underlying hours.

The DOLE–BWC handbook’s night shift differential chapter, printed page 25, identifies the 22:00–06:00 band and its coverage. Crossing midnight alone does not establish overtime. Check the full shift, applicable working-time arrangement, rest-day status and any holiday boundary before computing pay.

Rate change: split the work by the effective date

Suppose a fictional daily-paid employee works eleven ordinary, full workdays in a September 1–15 pay period. A documented increase takes effect September 8. Five worked days fall before the change and six fall on or after it.

The illustrative agreed daily rates are ₱900 before the change and ₱960 afterward. These are not stated minimum wages. Assume the full-day amounts are applicable and no premium, leave, absence or other adjustment enters this particular base-pay calculation.

Portion of the period Workdays Illustrative daily rate Base pay
Before September 8 5 ₱900 ₱4,500
September 8 onward 6 ₱960 ₱5,760
Total 11 — ₱10,260

Applying ₱960 to all eleven days would give ₱10,560, or ₱300 more than this stated arrangement. Applying ₱900 throughout would give ₱9,900, or ₱360 less. Neither is the correct base-pay input for the example.

Keep the old and new rates, effective date and authorizing record. An effective-date field is useful only if the payroll calculation applies the intended rate to the relevant work. Check the resulting lines after a change. Monthly, fixed and hourly arrangements require their own applicable calculation; do not reuse this daily-paid example automatically.

Do all small shops have the same benefit coverage?

No. For example, the DOLE–BWC handbook lists employees of retail/service establishments regularly employing fewer than ten workers among holiday-pay exclusions, and those regularly employing no more than five workers among night-shift-differential exclusions. See printed page 16 for holiday pay and page 25 for night work.

These are separate benefit rules, not a general exemption from labor standards. Verify establishment classification, employee eligibility, other exclusions and any more favorable agreement or established benefit before applying them. Do not decide coverage simply from how many people happened to work one shift. Refer uncertain cases to the responsible payroll adviser or DOLE office.

Record a coverage question as a question until resolved. For example: “Confirm the establishment’s night-shift coverage before applying the seven identified hours.” Preserve the hours while resolving the pay treatment.

Use an attendance correction record

This is a recommended operating record, not a prescribed government form. Keep one entry per discrepancy so a reviewer can trace the change.

Field What to enter
Reference and person Correction ID, employee ID, branch and pay period
Original record Clock timestamps, source and the exact discrepancy
Evidence reviewed Employee explanation, supervisor confirmation and relevant supporting reference
Correction New value, affected work date and reason; retain the original
Payroll effect Hours/day categories or rate segments affected, with the calculation shown
Review Preparer, reviewer, review date and employee notification or unresolved disagreement
Follow-up Owner, due date, outcome and any related adjustment already processed

Keep the reviewed attendance input distinct from the payroll calculation and from proof of payment. Completing one does not establish completion of the others.

Payroll records contain personal information. The Data Privacy Act, Sections 11 and 20, addresses proportionate processing, appropriate retention and security. Restrict the working file to authorized people, collect only relevant supporting information, and follow applicable retention duties. Do not include attendance PINs in the correction sheet or circulate employees’ pay details in a general staff chat.

What should the final cutoff check cover?

Before handing the attendance record to the payroll preparer:

  1. Confirm the employee list, pay period, branch assignments and complete shift boundaries.
  2. Check duplicates, missing punches, schedule changes and leave records individually.
  3. Confirm work and break durations; preserve overnight timestamps and identify overlapping pay categories.
  4. Resolve rate effective dates and relevant coverage/calendar questions.
  5. Compare corrections with earlier adjustments to prevent double counting.
  6. Have the reviewer check the changed inputs and document any unresolved issue promptly.
  7. Retain the source records, reviewed version and a clear handover to the payroll preparer.

Review commissions separately if they form part of the employee’s arrangement. Use the agreed basis and relevant sale/adjustment evidence; an attendance total cannot establish commission entitlement. The CRM guide’s discussion of commission records provides related context for keeping sales evidence traceable.

In Sentra, employee payroll settings include attendance PINs, Hourly/Daily/Fixed pay types, effective dates and commission settings when available for the account. Confirm the employee and branch before saving. Those settings support preparation, but this guide does not claim that configuring them automatically completes statutory calculations, approval or payment.

Sources and product documentation reviewed September 20, 2026. The cited handbook is the 2024 edition; current wage orders and relevant later issuances must be checked for the actual payroll period. This is an operational preparation guide, not an individualized determination of wages or benefits.

Practical knowledge. A clearer next step.
More from Sentra Insights