Finance and payments
Connect Netsuite to DataxLand
The NetSuite connector reads record types from your NetSuite account through the REST API - for example invoices, sales orders, purchase orders, item receipts, customers, vendors, items and journal entries - based on the list of record types you choose. Si maps them to the finance and operations models, giving you booked revenue, cost of goods sold, gross profit, expenses, operating profit, receivables and payables, purchase order value and received goods value, and lets you ask Si questions in plain language on the same definitions.
Free plan with no time limit · No card required · Sample workspace ready in minutes
What you can do with Netsuite
- Give leadership a profit and loss and receivables dashboard without building separate saved searches.
- Track purchase order value and received goods value by vendor.
- Combine NetSuite figures with marketplace, website or ad data in the same workspace.
What data you get
Each stream lands as its own table in the workspace warehouse, as is; personal-data columns are hashed on load.
| Stream (table) | Contents |
|---|---|
| <record type> | Each record type you choose (object types) becomes a table, for example invoice, salesorder, purchaseorder, itemreceipt. |
| customer, vendor | Customers and vendors (personal-data columns are hashed on load). |
| journalentry | Journal entries by account, used for booked revenue and expenses. |
Connection details
| Sign-in method | Connection details (API key, account), encrypted at rest |
|---|---|
| Sync modes | Full (reloaded each run) · Incremental (new or changed rows only) |
| Fields to fill in | Consumer Key, Consumer Secret, Realm (Account Id), Start Date, Token Key (Token Id), Token Secret |
| Developer | Airbyte (community), run inside DataxLand |
| License | ELv2 |
Passwords and keys are encrypted at rest. Personal-data columns are hashed on load.
Metrics computed from this source
Real definitions from the analytics packs; dashboards and Si share them.
| Metric | Definition | Unit |
|---|---|---|
| Booked revenue | General ledger revenue: credit postings minus debit postings on revenue accounts (account 511), net of revenue deductions (account 521). Excludes financial income and other income. | Currency |
| Cost of goods sold (ledger) | Debit postings minus credit postings on the cost of goods sold account (account 632). | Currency |
| Gross profit | Booked revenue minus cost of goods sold.= Booked revenue - Cost of goods sold (ledger) | Currency |
| Gross margin % | Gross profit divided by booked revenue.= (Booked revenue - Cost of goods sold (ledger)) / Booked revenue | Ratio (%) |
| Selling and administrative expenses | Debit postings minus credit postings on selling expense (account 641) and general administrative expense (account 642) accounts; under Circular 133 these are accounts 6421, 6422. | Currency |
| Operating profit | Gross profit minus selling and administrative expenses. Excludes financial income and expenses and other income and expenses.= Booked revenue - Cost of goods sold (ledger) - Selling and administrative expenses | Currency |
| Credit sales | Total value of credit sales invoices (creating accounts receivable) by invoice date. | Currency |
| Receivables collected | Total value of receivable invoices collected, by collection date. | Currency |
| Overdue receivables | Total value of invoices due in the period that remain uncollected as of the data date. | Currency |
| Vendor payments | Total value of payable invoices paid, by payment date. | Currency |
| Purchase order value | Total ordered value (ordered quantity times unit price) of purchase orders placed in the period, excluding cancelled orders. | Currency |
| Received goods value | Total received quantity times unit price for purchase orders received in the period (by receipt date). | Currency |
Connect Netsuite in 3 steps
- 1
Prepare the tokens
In NetSuite, enable Token-Based Authentication, create an integration to get a consumer key and secret, then create an access token (token ID, token secret) for a read-only role.
- 2
Add the source
In the workspace choose Add source, find Netsuite in the connector library, enter the Realm (Account ID), consumer key, consumer secret, token ID, token secret, start date and record types, then click Test connection.
- 3
Choose streams and review
Pick the record types you need; Si proposes a mapping to the accounting and operations models, and you approve before the build.
Limits and caveats
- This is a community connector from the Airbyte library (ELv2 license) run inside DataxLand; accounts with many custom fields should test on a short date range first.
- The token's role decides which records can be read; if it lacks a permission, that stream comes back empty.
- NetSuite limits concurrent calls per account; the first load can take a while.
Frequently asked questions
Does DataxLand write to NetSuite?
No. Use a read-only role; DataxLand only reads records.
Are custom fields read?
Custom fields returned with a record become columns; Si uses them as dimensions once they are mapped.
What about multiple subsidiaries?
Records carry a subsidiary code; dashboards filter by subsidiary once Si has mapped that field.
Dashboard templates that use this source
Connect Netsuite and get verified dashboards
Free plan with no time limit · No card required · Sample workspace ready in minutes