Connect Sage Intacct to Pigment and plan from actuals
Bring Sage Intacct general ledger, entity, and contract data into Pigment through a native connector, so budgets, forecasts, and board reporting start from the actuals in your books. Built for Finance leaders and consolidation teams who want to stop rebuilding exports every month.

Sage Intacct
Import Sage Intacct ledger, contract, and master data into Pigment for planning and reporting
Category
Integration method
Best for
Actuals vs. budget · Multi-entity reporting · Cash planning
What can you do with Sage Intacct and Pigment?
- Run variance analysis on closed periods. FP&A teams import account balances for a named Sage Intacct period, such as Month Ended June, and compare them against budget in Pigment.
- Plan cash from bills and invoices. Finance leaders bring in Sage Intacct bills, invoices, vendors, and customers to model upcoming payables and receivables alongside the plan.
- Forecast revenue from contract schedules. Revenue and FP&A teams import recognition, billing, and contract revenue schedules to forecast from what's already contracted.
- Compare and trace entity results. Consolidation teams load journal entry lines from every entity into one model, so they can compare entity results and check each figure against its source entry before statutory reporting.
How the Sage Intacct integration works
A Sage Intacct Full Admin enables Web Services, creates a read-only Pigment role, and assigns it to a new Web Service User. A Pigment Workspace Admin then adds the connection under Settings > Integrations with the Company ID, User ID, and password, and chooses which Applications can use it. Model builders import data in Data Source mode, which lets them pick a source, fields, and filters, or in Custom Report mode, which loads a report already built in Sage Intacct.
Key capabilities
- Keep the ledger read-only. Pigment connects through a dedicated Web Service User with a read-only role, so it can read Sage Intacct data but can’t change it.
- Match dimensions to your ledger. Departments, locations, employees, vendors, and customers import as master data, so Pigment dimensions come from the same records as Sage Intacct.
- Load only the fields you need. You select the fields to import from each Data Source, so Lists and Metrics carry only the columns your model uses.
- Set imports to run on their own. Schedule Sage Intacct imports so actuals refresh automatically, without anyone running each load by hand.
- Restrict access to approved Applications. Choose which Pigment Applications can use the Sage Intacct connection, so ledger data only reaches the models that need it.
Frequently Asked Questions
What Sage Intacct data can I import into Pigment?
You can import general ledger accounts, account balances, details, journal entries, and journal entry lines. You can also load revenue recognition schedules, contract billing, expense, and revenue schedules, plus bills, contracts, customers, departments, employees, entities, invoices, locations, and vendors.
Should I use Data Source or Custom Report mode?
Use Data Source mode for most imports: you pick a source, select fields, and apply basic or advanced filters. Use Custom Report mode only for small loads under 10,000 lines, since its performance is much more limited.
Can FP&A work with Sage Intacct actuals without a Sage Intacct login?
Yes. The connection authenticates with a single Web Service User, so FP&A teams work with imported actuals in Pigment based on their Pigment access. Application Access controls which Pigment Applications can use the connection.
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