Using the Timecard Tool's cross-BU overtime check

The Timecard Tool (/timecard) catches overtime that gets miscoded when an employee splits hours across business units in the same week — each BU's own export only sees its own hours, so the 40-hour threshold can be crossed without any single export showing it. It's unchanged from its earlier life as a BENCH tool, just restyled to match FLEX.

Everything stays in your browser

The page makes no network calls of any kind — files you drop are read and processed locally, never uploaded to FLEX's server, because HCSS exports contain employee PII.

Step 1 — load files

Drag in every business unit's HCSS export for the same pay week. Required columns are Employee Name, Employee_Code, Pay_Type, Hours_Employee, Cost_Type, Work_Date, Job_Number, and Phase_Code; a file missing any of them is rejected outright.

Step 2 — confirm settings

• Weekly overtime threshold defaults to 40 hours.
• Business unit column is auto-detected (checking Batch_Code, Employee Company, Inter_Company_Code, Department_Code, and Cost_Center, in that order, for the first one that's actually filled in). A warning appears if the selected column is empty or partly blank — overtime totals are still correct either way, but the business-unit breakdown won't be.
• The pay types found table lets you mark, per pay type, whether it counts toward the 40-hour threshold, whether it converts to overtime once the threshold is crossed (and to what), whether it's already a premium/overtime rate, and whether it should only ever appear once per employee per day (for flagging duplicate Per Diem/Truck Pay/Rig Pay entries).
• Cost type mapping (Regular → Overtime) is auto-detected from rows where the same employee/job/phase/date has both a regular and overtime entry; add any missing mapping manually — an unmapped pay type is flagged for manual review instead of guessed.

Settings save in your browser, so you shouldn't need to redo them every week.

Step 3 — process and download

Process files totals each employee's counted hours across every BU loaded, and flags only employees whose actual excess-over-threshold doesn't already match their existing Overtime hours. Download the combined payroll file (every row, corrected Pay_Type/Cost_Type/Hours only for flagged employees, plus Business_Units_Worked and Adjusted columns), or a standalone summary report (HTML).

Note: exports carry only a work date, not a clock time — hours are allocated in date order, and within a single day, hours already coded as overtime are treated as happening after that day's regular hours.