DTR Consolidator
ServiceMaster PH · Timekeeping
Their hours were added into one row. Fine for someone working two accounts. If a whole client is listed, a summary was probably uploaded twice — remove the extra file and run again.
Rows are merged by employee code, so a mistyped code adds one person's hours to another's. A missing middle initial also shows up here and is harmless. Fix any real mistake in the summary and run again.
Excess-of-8 hours with no first 8 hours of the same kind (usually hours in the wrong column); hours typed with a note (“9 icu 6 marcom”), read by adding up the numbers and ignoring the words, as in the manual consolidation; and any column the tool doesn't recognise. Check each one.
Nothing from these was read. Cover sheets, notes and pivots are expected here. If a client's summary sheet is listed, its header row isn't the usual one — fix it or send the file on for a look, then run again. An .xls file needs Save As .xlsx first.
The masterlist has no LocId for them, so it is blank in the report. New hires usually mean the masterlist export is out of date — pull a fresh one from 128 and run again, or fill these in by hand.

Files

Upload the per-client DTR summary workbooks (already-tallied hours). Each may hold one or many client sheets. Hold Ctrl to select multiple files. Starting a new one? Download the blank template — hours are decimal (7.5 is 7 h 30 min) and TARDY is whole minutes.
The current 128 employee masterlist export (the sheet with EmpCode and LocId columns). LocId is looked up in it. Upload it every time; like the summaries, it isn't kept after the report is made.
The last day of the cutoff, e.g. 08/31/2026. Written in the Date column of every row.
Leave empty for a fresh report. To add late-filing clients to a report you already have, upload it here — the new rows are appended and the grand total recalculated. Anyone in both has the hours added into one row, highlighted for you to check.

Output format

FMI billing report The 41-column billing layout (TotDays, TotHrs, ROT, NDF8, OTRDF8…), with the pay-multiplier row and grand totals. Employee codes are written without dashes. TotDays, SPL/PL, HOLIDAY, the monthly special-holiday variants and the premium-rate variants are always 0; LocId comes from the masterlist uploaded above; TotAbs is left blank for P&B to enter LWOP.

Files

Hold Ctrl to select multiple files.

Output

Files

Upload the Grid outputs from the Process tab. Hold Ctrl to select multiple files.