Connect QuickBooks to Pigment and plan from your actuals
Bring QuickBooks accounting data into Pigment through a native connector, so Finance leaders and FP&A teams plan and report from the same actuals. Scheduled imports replace manual exports, and combining your books with CRM data puts cash and customer acquisition cost in one plan.

QuickBooks
Connect QuickBooks to Pigment to build budgets, forecasts, and board reporting on your accounting actuals
Category
Integration method
Best for
Budget vs actuals · Cash and runway planning · Board reporting
What can you do with QuickBooks and Pigment?
- Run budget vs. actuals without rework. FP&A imports QuickBooks actuals for the period they choose, then compares them against budget and investigates variances in the same model.
- Reforecast from the latest numbers. FP&A updates the forecast with QuickBooks actuals through the import date, then tests spend and hiring scenarios before the next review
- Model cash and runway. CFOs track payables and receivables next to the cash forecast to spot collection or payment gaps early, then combine QuickBooks data with CRM pipeline to see how hiring or spend changes affect runway.
- Build board reporting on the plan. Finance leaders create board and investor reporting in Pigment on imported QuickBooks actuals, so the pack and the plan share one source
How the QuickBooks integration works
A Pigment Workspace Admin sets up the connection once from Settings > Integrations. They name it, choose which Applications can use it, and sign in to QuickBooks in a pop-up window. Your team then imports into a Block, such as a Transaction List, by selecting the QuickBooks connection, a report type, and a time window. Dates are inclusive, and if you leave the end date empty, Pigment imports through the date of import. You can schedule the import so actuals refresh without anyone rerunning it, with schedules set per Application.
Key capabilities
- Choose the report and period. Select a QuickBooks report type and set the time window for each import, so you bring in only the period you plan against
- Restrict access to approved Applications. A Workspace Admin sets up QuickBooks once and chooses which Applications can use it, so accounting data lands only in the models you intend.
- Set imports to run on their own. Schedule QuickBooks imports so actuals are current before each review, and get notified if a run fails.
- Keep imports rolling forward. Leave the end date empty, and each import runs through the day it runs, so scheduled imports always pick up the newest transactions.
- Connect with your QuickBooks login. A Workspace Admin signs in to QuickBooks once during setup, and Pigment uses that authorization for every import.
Frequently Asked Questions
What QuickBooks data can I import into Pigment?
For each import, you select a QuickBooks report type and set a time window, then load the data into a Block such as a Transaction List. Supported report types include [list needed from Product].
Does Pigment change any data in QuickBooks?
No. The connector imports QuickBooks data into Pigment and doesn’t write anything back to QuickBooks.
Can I connect more than one QuickBooks company?
Yes. A Workspace Admin sets up a separate connection for each QuickBooks company, and your team can import from each one and combine the entities in Pigment.
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