Workflow · People · Opening soon

Employee overtime cost

See total overtime hours and overtime cost by department and week. Flag each week as Agrees or Spike based on the prior three weeks.

Book a demo

Someone typed

“show overtime hours and overtime cost by department and week; status Agrees when this week’s hours are within 25% of the prior 3 weeks’ median, otherwise Spike”

The agent read it as

Show overtime hours and overtime cost by department and week; status Agrees when this week’s hours are within 25% of the prior 3 weeks’ median, otherwise Spike, using Check-date calendar weeks from ADP Payroll Register Detail.

What the agent built

1 step, each one an ordinary Mammoth step you can open and change.

File

ADP Payroll Register Detail

CSV export · 40 rows

Step

Compare overtime by week

Step 1

Result

Overtime Spike Review

6 rows · 5 flagged

Schedule

Runs when you say

Proposed

File
ADP Payroll Register Detail
CSV export · 40 rows
Step
Compare overtime by week
Step 1
Result
Overtime Spike Review
6 rows · 5 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 6 rows came out.

Download ADP Payroll Register Detail sample (40 rows)ADP Workforce Now: Reports > Payroll > Payroll Register Detail > Export

What you get back

The result of that run, the rows to look at first.

Overtime Spike ReviewSample data6 rows

1 agrees5 spike

Department	Week	Overtime hours	Overtime cost	Status	Prior 3 weeks median
Customer Support	2026-11-02	8.50	291.38	Spike	4
Finance	2026-11-09	2	93.76	Spike	1.50
Manufacturing	2026-11-09	10	415.52	Spike	5.50
Operations	2026-10-26	11.75	439.88	Spike	8.50
Warehouse	2026-11-02	5	153.75	Spike	8
Sales	2026-11-09	4.25	190.31	Agrees	3.50

6 rows in the result. Sample data: illustrative figures, not business results.

How do you track overtime cost by department and week?

Export the ADP Payroll Register Detail file from ADP, then load it into Mammoth. It shows overtime hours and overtime cost by department and calendar week, and marks each week Agrees when this week’s hours stay within 25% of the median of the prior 3 weeks, otherwise Spike.

How it works

How to use the Overtime Spike Review workflow

1Get early accessWe invite people in small batches, job by job. You'll land on this workflow, already built and checked on the sample files.
2Swap in your exportsUpload your own files as they come out of your tools. The agent checks the workflow on your rows.
3Change it in words, then turn it onSay what to change and see the new result before anything saves. Then choose when it runs.

Overtime Spike Review: questions

What export do I use from ADP?

Use the ADP Payroll Register Detail export. It should include the overtime hours, overtime cost, department, and pay date or week fields needed for the check.

What happens to rows that do not match the rule?

Rows that do not match are still kept in the output, but they are marked Spike instead of Agrees. That lets you review the weeks that fall outside the rule.

How do I change the rule in words?

Edit the rule text to say what should be compared, what time window to use, and what counts as a match. For example, you can change the percent band, the lookback period, or the week grouping.