Connect NetSuite to Pigment and plan from trusted actuals
Bring posted NetSuite actuals into Pigment on a schedule, so your forecasts and board reporting start from the same numbers as your ledger. Designed for Finance leaders and consolidation teams who need every plan to trace back to the books.

NetSuite
Connect NetSuite to Pigment to plan and report from your ERP actuals
Category
Integration method
Best for
Financial planning · Cash forecasting · Variance analysis
What can you do with NetSuite and Pigment?
- Run month-end variance analysis. Load posted income statement transactions through the last closed month, then compare actuals to budget in Pigment without a spreadsheet handoff.
- Build a forward cash view. Import open AP and AR from NetSuite to project cash and runway ahead of board meetings.
- Review vendor spend against budget. Import vendor-level spend from NetSuite so budget owners see where actual spend is running ahead of plan.
- Combine ERP, CRM, and HR data. Model NetSuite actuals alongside pipeline and headcount data to plan costs and hiring together, or pair expenses with sales data to calculate CAC.
How the NetSuite integration works
Pigment connects to NetSuite through Token-Based Authentication (TBA) and SOAP Web Services. A NetSuite admin builds a saved search for the data you need, and Pigment imports it by saved search ID into a Transaction list. A Pigment-supplied RESTlet script asks NetSuite to generate the results as a CSV file, which Pigment then retrieves for faster loads. You can schedule each import on up to 4 different schedules and get alerts when a run fails or only partly completes.
Key capabilities
- Choose exactly what you import. Load anything you can add to a NetSuite saved search, including GL transactions, vendor records, and asset data.
- Skip manual column mapping. Pigment maps saved search results to a Transaction list automatically.
- Pull only posted actuals. Filter saved searches on posted transactions, closed periods, and non-zero amounts, so open periods stay out of the plan.
- Refresh on your close calendar. Split P&L and balance sheet data into separate saved searches, then give each its own import schedule.
- Know when an import fails. Get failed or partial import notifications in Pigment, by email, or in Slack, so nobody plans on stale numbers.
- Keep NetSuite in control of access. A dedicated integration role holds the permissions, so your NetSuite admin decides which records and fields Pigment reads.
- Import within existing permissions. After setup, end users load NetSuite data based on their read permissions, without needing admin access themselves.
Frequently Asked Questions
What NetSuite data can I import into Pigment?
You can import anything you can add to a NetSuite saved search, including financial, vendor, and asset data. For GL data, set the saved search type to Transaction. Use saved searches rather than saved reports, because saved reports don’t convert into a format Pigment can import. See how to create transaction saved searches.
Does the integration replace manual exports and reconciliation?
It replaces manual exports. Scheduled imports take over the recurring download-and-upload step for any data you can put in a saved search. Reconciliation gets simpler when you filter saved searches to posted transactions in closed periods, since the plan starts from actuals already booked in NetSuite. Failure notifications tell you when an import didn't complete, so gaps surface before review.
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