Labour pages in our reports map scheduled hours to cover counts by daypart. When timesheets lack daypart tags, analysts split hours proportionally — a less precise method we note in the reconciliation appendix.
Include actual clock-in and clock-out times
Scheduled hours alone miss overtime patterns. Actual times reveal early-clock events and late stays that explain labour ratio drift. If your system records both, export both columns.
Tag shifts by daypart
Use consistent labels: breakfast, lunch, dinner, close. Mixed labels (AM, morning, 오전) force manual normalisation. Pick one set and document it in your intake email when starting a new cycle.
Separate management hours
Manager salaries often appear in the same export as hourly staff. Flag management rows or use a distinct employee category code. Otherwise prep labour ratios include non-floor hours and read artificially high.
Overtime and statutory holiday markers
Mark overtime rows explicitly. Holiday pay lines should reference the holiday date. Analysts cross-reference these against sales spikes — a public holiday with normal staffing shows differently than a holiday with reduced hours.
Late timesheet policy
Standard cycles require timesheets by Tuesday noon. Late files produce sales-only delivery on Friday; labour pages follow when data arrives. Plan internal deadlines for store managers accordingly.