Getting statement data into NetSuite

NetSuite is the one on this list where the interesting answer is not a spreadsheet. There is no NetSuite file and no NetSuite connection, but there is a REST API and an open-source SDK, which is usually how data reaches a NetSuite instance anyway.

Convert a document All export formats

What you can do today

No NetSuite file

Export a CSV and map the columns in NetSuite's own import, or read the extraction through the REST API or the open-source TypeScript SDK and write it into NetSuite the way your other integrations do. A purpose-built NetSuite file is planned and is not here yet.

The layouts you would be mapping

CSV columns Excel columns

LedgerBox does not create a NetSuite file or connect to NetSuite. Use the available export method shown here.

Getting data into NetSuite today

Convert the documents in LedgerBox

Upload or forward them, or send them through the API. Reconciliation and review work the same way whichever route the document arrives by.
Choose a file or the API

A CSV for a one-off import, JSON for something a script will read, or the REST API and SDK when the loading is going to happen more than once.
Load it into NetSuite

NetSuite's own CSV import is where a file's columns get mapped. A scripted load reads the JSON shape, which is documented on the JSON exports page.

Loading this with a script rather than by hand? The API and the open-source SDK

Import notes

Review the available spreadsheet option and the planned format checks.

API integration

Use the REST API or TypeScript SDK to send extracted data to your NetSuite integration.

Import column mapping

NetSuite defines its accepted columns. LedgerBox publishes its own export layouts. Complete the final mapping in NetSuite.

Planned format checks

LedgerBox will add the format after it can create and import the file in NetSuite. The transactions must import with the correct values.

NetSuite FAQ

Does LedgerBox integrate with NetSuite?

No. QuickBooks Online is the only posting integration. For NetSuite there is a CSV export to import by hand, a JSON export for a script, and a REST API with an open-source TypeScript SDK if you are writing the loader yourself.

What does the API give me that a file does not?

The same extraction without a download step, plus webhooks when a document finishes, so a load can be triggered rather than scheduled. The JSON exports page documents the shape the API returns.

Is a NetSuite export planned?

Yes, and it is not here yet. Like every planned format it ships only after it has been generated, imported, and checked end to end against a real instance.

Clean rows first, then import them anywhere.

Upload a document and download the export in under a minute. No card required.

Get started free

Available and planned export formats. See all thirteen, grouped