Workflow · People · Opening soon
BambooHR headcount by department
Turn your BambooHR employee export into a monthly headcount by department report. Include joiners and leavers for each month across all available months.
Someone typed
“headcount by department each month from the bamboohr employee export, with joiners and leavers”
The agent read it as
headcount by department each month from the BambooHR employee export, with joiners and leavers, covering all available months.
What the agent built
1 step, each one an ordinary Mammoth step you can open and change.
File
BambooHR employee export
CSV export · 27 rows
Step
Count headcount, joiners and leavers
Step 1
Result
Monthly Department Headcount
126 rows
Schedule
Runs when you say
Proposed
- FileBambooHR employee exportCSV export · 27 rows
- StepCount headcount, joiners and leaversStep 1
- ResultMonthly Department Headcount126 rows
- ScheduleRuns when you sayProposed
Checked on the sample files: every step ran, 126 rows came out.
- Download BambooHR employee export sample (27 rows)BambooHR: People > All Employees > Export
What you get back
The result of that run, the rows to look at first.
Monthly Department HeadcountSample data126 rows
| Department | Month | Headcount | Joiners | Leavers |
|---|---|---|---|---|
| Engineering | 2025-06-01 | 0 | 0 | 0 |
| Finance | 2025-06-01 | 0 | 0 | 0 |
| Marketing | 2025-06-01 | 0 | 0 | 0 |
| Operations | 2025-06-01 | 0 | 0 | 0 |
| People Operations | 2025-06-01 | 0 | 0 | 0 |
| Sales | 2025-06-01 | 1 | 1 | 0 |
| Support | 2025-06-01 | 0 | 0 | 0 |
| Engineering | 2025-07-01 | 1 | 1 | 0 |
| Finance | 2025-07-01 | 0 | 0 | 0 |
| Marketing | 2025-07-01 | 0 | 0 | 0 |
| Operations | 2025-07-01 | 0 | 0 | 0 |
| People Operations | 2025-07-01 | 0 | 0 | 0 |
How do you build a BambooHR headcount report by department?
Export your employee data from BambooHR, then upload the file to Mammoth. It counts headcount, joiners, and leavers by department for each month in the file.
How it works
How to use the Monthly Department Headcount 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.
Monthly Department Headcount: questions
Which export should you use?
Use the employee export from BambooHR. The workflow reads the rows in that file and uses the dates and department values it finds there.
What happens to rows that do not match the rules?
Rows that do not match the rules are left out of the matched result for that step. You can review them and adjust the rules if you want them included.
How do you change the rules?
Edit the rules in plain words. You can change which columns matter, how rows are grouped, and what counts as a joiner or leaver.
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