Workflow · People · Opening soon

Overtime report

Turn Gusto exports into an overtime report by employee, department, and pay period. Add overtime pay, then flag rows where the department lookup or pay rate is missing.

Book a demo

Someone typed

“show employee by department and pay period from the gusto timesheets, with overtime pay and a Status that says "Agrees" when the department is in the departments lookup and rate exists, else what's off”

The agent read it as

show employee by department and pay period from the Gusto timesheets, joined to the Gusto employees for rate and the Gusto departments lookup, with overtime pay and a Status that says "Agrees" when the department is in the lookup and rate exists, else what's off

What the agent built

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

File

Gusto timesheets

CSV export · 32 rows

File

Gusto employees

CSV export · 10 rows

File

Gusto departments

CSV export · 7 rows

Step

Make employee key

Step 1

Step

Make department key

Step 2

Step

Make timesheet keys

Step 3

Join

Get employee rate

32 of 32 paired

Join

Check department lookup

32 of 32 paired

Step

Sum by pay period

Step 6

Result

Timesheet overtime report

18 rows · 2 flagged

Schedule

Runs when you say

Proposed

File
Gusto timesheets
CSV export · 32 rows
File
Gusto employees
CSV export · 10 rows
File
Gusto departments
CSV export · 7 rows
Step
Make timesheet keys
Step 3
Step
Make employee key
Step 1
Step
Make department key
Step 2
Join
Get employee rate
32 of 32 paired
Join
Check department lookup
32 of 32 paired
Step
Sum by pay period
Step 6
Result
Timesheet overtime report
18 rows · 2 flagged
Schedule
Runs when you say
Proposed

Checked on the sample files: every step ran, 18 rows came out, and the join paired 32 of 32 rows; the join paired 32 of 32 rows.

Download Gusto timesheets sample (32 rows)Gusto: Time > Timesheets > Export
Download Gusto employees sample (10 rows)Gusto: People > Employees > Export
Download Gusto departments sample (7 rows)Gusto: Company > Settings > Departments > Export

What you get back

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

Timesheet overtime reportSample data18 rows

16 agrees2 rate missing

Employee	Department	Pay Period	Regular Hours	Overtime Hours	Hourly Rate	Overtime Pay	Status
Jules Martin	Warehouse	PP_2026_20	8	0.75	·	·	Rate missing
Jules Martin	Warehouse	PP_2026_21	16	1	·	·	Rate missing
Alyssa Chen	Operations	PP_2026_21	23.50	2	28.5	57	Agrees
Dante Moore	Sales	PP_2026_21	16	1.25	30	37.50	Agrees
Elena Novak	Finance	PP_2026_20	24	0.50	33.3	16.63	Agrees
Farah Iqbal	Engineering	PP_2026_20	24	1.50	38	57	Agrees
Hana Brooks	Customer Support	PP_2026_21	16	2	23.5	47	Agrees
Iris Patel	Field Ops	PP_2026_21	8	1	27	27	Agrees
Brandon Pierce	Customer Support	PP_2026_19	8	0.50	24	12	Agrees
Carmen Ruiz	Warehouse	PP_2026_19	8	1	21.8	21.75	Agrees
Brandon Pierce	Customer Support	PP_2026_21	22.50	1	24	24	Agrees
Carmen Ruiz	Warehouse	PP_2026_21	24	2.75	21.8	59.81	Agrees

18 rows in the result · 12 shown, problems first. Sample data: illustrative figures, not business results.

How do you build an overtime report from Gusto exports?

Export Gusto timesheets, employees, and departments, then load them into Mammoth. Join timesheets to employees for rate, check the department lookup, and sum overtime by pay period. Rows that do not match stay in the report with a status that shows what is missing.

How it works

How to use the Timesheet overtime report 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.