Connect BambooHR to Pigment and plan headcount costs
Bring BambooHR employee data into Pigment so your workforce plan and your financial plan start from the same records. Workforce planning and HR leaders can model headcount and compensation against the budget without re-keying HR exports.

BambooHR
Import BambooHR report data into Pigment for headcount and workforce cost planning
Category
Integration method
Best for
Headcount planning · Compensation modeling · Workforce cost forecasting
Why connect BambooHR with Pigment?
- Tie headcount costs to the plan. Start workforce plans from the employee records HR already keeps in BambooHR, so people costs sit in the same model as the budget.
- Stop re-keying HR exports. Pull a BambooHR report into Pigment directly instead of downloading a file, cleaning it, and uploading it again each cycle.
- Leave HR records with HR. BambooHR stays the system of record, and Pigment only imports report data, so employee records stay as HR maintains them.
- Give Finance the same headcount actuals. FP&A can feed BambooHR headcount into the opex forecast and compare budget vs actual by department without asking HR for an export.
What can you do with BambooHR and Pigment?
- Build headcount plans from current staff. A workforce planner imports a BambooHR report of current employees, then adds planned hires and attrition assumptions on top in Pigment.
- Check hiring plans against accepted offers. Include future employees in the import to compare the pre-hires who've signed against the hires each team's plan assumed.
- Test compensation changes against budget. Import the compensation fields your BambooHR report contains, then model raises or new salary bands against each department's budget before approving them.
- Review org design with faces attached. Export employee image links from BambooHR so the people in your Pigment Org Chart appear with their photos.
How the BambooHR integration works
Your team stops moving spreadsheets between BambooHR and the plan: you pick a BambooHR report, and its data lands in Pigment within a few seconds. A Pigment Workspace Admin creates the connection once in the Integrations library with your company subdomain and an API key from a BambooHR Admin. They then choose which Applications can use it.
To import, open Import Data on the target object, such as a Transactions list, and choose Integration instead of Upload file. Select the BambooHR connection, enter the report ID, and choose which employees to include. You'll find the report ID by hovering the report name on the BambooHR reports page. Data moves one way, from BambooHR into a Pigment Block.
Key capabilities
- Use the reports HR already built. Pigment imports data from any BambooHR report, so you work from report definitions your HR team already maintains.
- Control which fields come through. Pigment imports whatever fields the report contains, so adding a field to the BambooHR report is how you add it to the import.
- Choose who counts as headcount. Filter the import to only current employees, or include future employees with accepted offers and later start dates.
- Reuse one connection across Applications. Add one or more Applications to the connection's Application Access list, so teams don't each manage their own BambooHR credentials.
- Get updated numbers in seconds. Imported BambooHR data loads within a few seconds, so pulling the latest report doesn't hold up a planning review.
- Land data where you plan. Start the import from the target object's Import Data menu, so BambooHR data lands directly in the list you plan with.
Frequently Asked Questions
What BambooHR data can I import into Pigment?
You can import the data from any BambooHR report into a Pigment Block, including whatever fields that report contains. When you import, you choose only current employees or current and future employees. Future employees are pre-hires with accepted offers and later start dates.
Which Pigment Applications can use the BambooHR connection?
You create the connection once and add one or more Applications to its Application Access list. Only the Applications on that list can use the connection to import BambooHR data.
Can Finance see headcount data without BambooHR access?
Yes. The connection authenticates with an API key from a BambooHR Admin, so Finance doesn't need individual BambooHR logins. Once the data is in a Pigment Application, people with access to that Application can work with it there.
How much manual re-entry does the BambooHR integration remove?
It removes the export, clean-up, and upload step between BambooHR and the plan. Instead of downloading a BambooHR file and uploading it, you select the BambooHR connection and enter a report ID. The data loads within a few seconds.
Related integrations
See Pigment in action
The fastest way to understand Pigment is to see it in action. Sign up today and explore how agentic AI can transform the way you plan.

From 8 days to 4 min
Update P&L actuals & financial forecasting
80%
Time cut on data aggregation
12 hours
Saved per month on executive reporting
6 days faster
For scenarios creation and analysis