Free Starter Pack Before you start using Claude for Excel, apply these best practices
← All Integrations
NetSuite Logo

NetSuite + Go Fig

AccountingERP Premium

Connect NetSuite ERP to Go Fig for comprehensive financial data integration and real-time reporting.

NetSuite is the system of record for thousands of mid-market companies running OneWorld, SuiteSuccess, or standard editions, but its strategic reporting story is a patchwork of saved searches, financial reports, and SuiteAnalytics workbooks that rarely consolidate in one place. Go Fig connects to NetSuite via SuiteTalk and the SuiteQL endpoint, lands every GL transaction line with its subsidiary, department, class, location, and custom-segment context intact, and makes the data available to Celeste and your finance team inside the Financial Intelligence Graph. OneWorld subsidiaries are pulled as first-class entities with their consolidation and elimination books preserved, so a single mapping table rolls local charts of accounts into one reporting structure. Multi-currency postings keep both transaction and base-currency values, and custom segments populated by SuiteScript appear automatically so capital-allocation, segment-margin, and working-capital analyses run against one governed dataset rather than a stack of exported saved searches.

Key facts

Editions
OneWorld, SuiteSuccess, standard
Grain
GL transaction line with segments
Multi-subsidiary
Up to 200 OneWorld subsidiaries
Custom segments
Department, class, location, custom
Sync cadence
Hourly incremental, on-demand refresh

SOC 2 Type II ยท All integrations

What you can do with NetSuite data in Go Fig

Real-Time Financial Reporting

See P&L, balance sheet, and cash flow updated continuously instead of waiting for the month-end saved search.

Multi-Subsidiary Consolidation

Consolidate across OneWorld entities with currency conversion and intercompany eliminations expressed in Go Fig flows.

Operational Integration

Combine NetSuite financials with Salesforce, HubSpot, and Snowflake to diagnose margin and segment performance.

Data available from NetSuite

Go Fig extracts and normalizes the following data from your NetSuite account:

General ledger
Accounts payable
Accounts receivable
Inventory
Sales orders
Purchase orders
Journal entries
Custom records
Saved searches
Subsidiaries
Departments
Classes

How to connect NetSuite

1

Create the Go Fig integration record in NetSuite

In Setup, Integration, Manage Integrations, create a new integration with TBA enabled. Note the Consumer Key and Consumer Secret. These are shown once, so capture them when generated.

2

Provision a read-only role and tokens

Create a custom role granting view-level access to Transactions, Lists, Reports, and any custom records you want exposed. Issue an Access Token tied to a service user assigned that role. Limit subsidiary access if you want to scope what Go Fig sees.

3

Map segments and saved searches

Go Fig auto-discovers your chart of accounts, subsidiaries, departments, classes, and locations. If your team relies on specific saved searches for reporting, point them in during setup so Celeste can reference the same definitions you do.

4

Tune sync cadence around concurrency

NetSuite SuiteTalk enforces a per-account concurrency limit (typically 5 concurrent requests at the standard tier, higher with the SuiteCloud Plus add-on). Hourly incremental sync stays well under that ceiling. Backfills run during off-peak hours so your end-of-month saved searches keep their headroom.

Authentication: Token-Based Authentication (TBA) is the recommended production path, using a NetSuite integration record with a role scoped to read-only on the segments you want to expose. OAuth 2.0 is supported for tenants on 2024.x where TBA is being phased toward sunset.

Common Questions About NetSuite Integration

Does Go Fig support OneWorld and multi-subsidiary consolidation?

Yes. OneWorld is a first-class deployment. Go Fig pulls each subsidiary as its own entity, preserves the consolidated and elimination books, and lets you build mapping tables that translate local charts of accounts into a single reporting structure. Currency conversion uses NetSuite's posted FX rates by default, with the option to override with your own rate table for management reporting.

Which NetSuite editions and bundles are required?

Any NetSuite edition with SuiteTalk enabled works, including SuiteSuccess and standard NetSuite. The Token-Based Authentication feature must be turned on, which is standard since 2018.2. SuiteCloud Plus is optional but recommended for tenants that want higher API concurrency. We do not require SuiteAnalytics Connect, since Go Fig pulls via SuiteTalk and saved-search APIs directly.

How does Go Fig handle custom segments, custom records, and SuiteScript-driven fields?

Custom segments (departments, classes, locations, plus user-defined ones) are pulled as native dimensions on every transaction. Custom record types are exposed as queryable tables once selected during setup. Fields populated by SuiteScript appear as soon as NetSuite writes them to the underlying record, so user event scripts and workflows do not require any extra configuration.

What's the impact of Go Fig sync on NetSuite performance and concurrency limits?

Go Fig respects the SuiteTalk per-account concurrency limit (5 at standard, higher with SuiteCloud Plus) and ramps backfills during off-peak windows. Steady-state hourly incremental sync uses a small fraction of available capacity. We expose a real-time view of API requests in the connector dashboard so your administrator can confirm we are not interfering with month-end close jobs.

Can I keep using NetSuite saved searches for reporting alongside Go Fig?

Yes, and many customers do during their first few months. Go Fig can ingest specific saved searches as their own tables, so a report your controller already trusts continues to land the same numbers. Over time, teams typically rebuild board and operating reviews on top of the GL grain inside Go Fig because they can slice across CRM, payments, and HRIS sources that NetSuite alone cannot reach.

Ready to connect NetSuite?

See how your NetSuite data looks in Go Fig with a personalized demo.

Book a Demo