NetSuite
The NetSuite integration lets you automatically sync your financial data with Runway, eliminating manual data entry and ensuring your actuals stay up to date. With this connection, your financial models always reflect the latest numbers from NetSuite.
Runway supports three different ways to integrate with NetSuite. This guide focuses on Runway’s preferred and recommended method.
Prerequisites
Before getting started, make sure you have:
- A NetSuite administrative account
- The SuiteAnalytics Connect Service enabled, with access to either the NetSuite.com or NetSuite2.com data source.
Setting up NetSuite via Fivetran
Connecting the integration
-
Open your Runway instance.
-
In the left sidebar, hover over Integrations and click the + button to open the Integrations Directory.
-
Search for NetSuite and click + Set up under the Fivetran option.
-
For the Schema Name, leave it as
netsuite_suiteanalytics. -
Click Authorize to be redirected to Fivetran to complete the connection.
-
Follow Fivetran’s setup instructions to finish configuring the integration.
-
Click Save & Test to begin syncing your data. You’ll be redirected back to Runway.
Syncing your data into Runway
Runway provides integration templates to make it easy to bring in Income Statement and Balance Sheet data from NetSuite.
- In the left sidebar, go to Templates.
- Search for NetSuite Data Import.
- Click + Add to Runway on the template card.
- This will automatically:
- Add prebuilt Income Statement and Balance Sheet queries to your NetSuite integration.
- Create the following databases in Runway:
- IS Data (Income Statement)
- BS Data (Balance Sheet)
Supported data from NetSuite via Fivetran
When using the NetSuite Data Import integration template, the following financial data becomes available in Runway:
Income statement data
| Data name | Example | Data type | Availability |
|---|---|---|---|
| Transaction Date | Mar 28, 2025 | Date Driver | Via Template (used to group by Month in Timeseries) |
| Income Statement Amount (converted) | 15,000 | Number Driver | via Template |
| Account Name | 200 Sales | Dimension | via Template |
| Subsidiary | Acme | Dimension | via Template |
| Department | Sales | Dimension | via Template |
| Vendor Name | Microsoft | Dimension | via Template |
| Class Full Name | Revenue | Dimension | via Template |
| Account Type Name | Income | Dimension | via Template |
| Parent Account Name | Sales | Dimension | via Template |
| Account Number | 200 | Dimension | Can be added |
| Account Name (no number) | Sales | Dimension | Can be added |
| Vendor Category | Supplies | Dimension | Can be added |
| Customer | John Doe | Dimension | Can be added |
| Item ID | 123 | Dimension | Can be added |
| Item Name | Hosting | Dimension | Can be added |
| Item Type Name | Service | Dimension | Can be added |
| Location Name | ABC | Dimension | Can be added |
| Location City | New York | Dimension | Can be added |
| Location Country | US | Dimension | Can be added |
| Currency Name | US Dollars | Dimension | Can be added |
| Currency Symbol | USD | Dimension | Can be added |
Balance sheet data
| Data name | Example | Data type | Availability |
|---|---|---|---|
| Account Name | 1001 - Chase Checking | Dimension | via Template |
| Account Category | Asset | Dimension | via Template |
| Account Type | Bank | Dimension | via Template |
| BS Amount | 10,000 | Number Driver | via Template |
| Month | Mar 28, 2025 | Date Driver | via Template (used to group by Month in Timeseries) |
| Subsidiary | Acme Subsidiary | Dimension | Can be added |
The NetSuite Data Import integration template includes the most commonly used financial data, but you can add additional supporting data to your database configurations for more detail if needed.