Workflow · People · Opening soon
Headcount report
Turn a BambooHR employees export into a monthly headcount report. See headcount at each month end by department and location, with hires and leavers.
Someone typed
“headcount at each month end by department and location, with hires and leavers”
The agent read it as
Headcount at each month end by department and location, with hires and leavers, from BambooHR Employees Export, from first hire through this month end.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
BambooHR Employees Export
CSV export · 16 rows
Step
Count headcount and movement
Step 1
Result
Department Headcount by Month
111 rows
Schedule
Runs when you say
Proposed
- FileBambooHR Employees ExportCSV export · 16 rows
- StepCount headcount and movementStep 1
- ResultDepartment Headcount by Month111 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 111 rows came out.
- Download BambooHR Employees Export sample (16 rows)BambooHR: Employees > Directory > Export
What you get back
The result of that run, the rows to look at first.
Department Headcount by MonthSample data111 rows
| Month end | Department | Location | Headcount | Hires | Leavers |
|---|---|---|---|---|---|
| 2025-03-31 | Engineering | New York | 1 | 1 | 0 |
| 2025-04-30 | Engineering | New York | 1 | 0 | 0 |
| 2025-05-31 | Engineering | New York | 1 | 0 | 0 |
| 2025-06-30 | Engineering | New York | 1 | 0 | 0 |
| 2025-07-31 | Engineering | New York | 1 | 0 | 0 |
| 2025-07-31 | Sales | Chicago | 1 | 1 | 0 |
| 2025-08-31 | Engineering | New York | 1 | 0 | 0 |
| 2025-08-31 | Sales | Chicago | 1 | 0 | 0 |
| 2025-09-30 | Engineering | New York | 1 | 0 | 0 |
| 2025-09-30 | Sales | Chicago | 1 | 0 | 0 |
| 2025-10-31 | Engineering | New York | 1 | 0 | 0 |
| 2025-10-31 | Sales | Chicago | 1 | 0 | 0 |
How do you build a headcount report from a BambooHR export?
Export your employees list from BambooHR and upload it to Mammoth. Mammoth counts headcount at each month end, grouped by department and location, and tracks hires and leavers from the first hire through the current month end.
How it works
How to use the Department Headcount by Month 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.
Department Headcount by Month: questions
Which export should you use?
Use the BambooHR Employees export. It needs the fields that show each person's hire date, department, location, and end date if they left.
What happens to rows that do not match the rules?
Rows that do not have the needed fields, or that do not fit the month end rules, are left out of the result for that step.
How do you change the rules?
Change the rule text to match the report you want. You can ask for a different time grain, different groupings, or a different way to count joins and leavers.
Get early access to this workflow
It will open already built and checked on the sample files. Swap in your own exports and see your result.
Workflows like this
Match payroll to time sheets, track headcount and hiring, and see what changed since last month.
- Resource capacity by weekCompare booked project hours to weekly availability in an Excel export and show who is over or under capacity.See the workflow Built by the agent
- Salary bands compa-ratioExport employees from BambooHR, pair them with salary bands, and work out each employee's compa-ratio against the band midpoint.See the workflow Built by the agent
- On-time shipping rateCalculate on-time delivery rate from a ShipStation shipments export, grouped by carrier and week.See the workflow Built by the agent
- PTO balance reportShow each employee’s PTO accrued, taken, carryover, and remaining balance this year from BambooHR exports.See the workflow Built by the agent
- Billable utilization by employeeCalculate each employee's utilization rate by month from exported Harvest time entries and capacity files.See the workflow Built by the agent
- Employee turnover rateCalculate monthly employee turnover rate by department from a BambooHR employee export, with turnover, cleaned department names, and a status check.See the workflow Built by the agent