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 ships no NetSuite file and no NetSuite connection today. This page describes what there is instead.

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

Worth knowing before you import

What we do not ship is as worth stating as what we do, because finding out later is the expensive way to learn it.

The API is the honest recommendation here

A NetSuite instance is usually loaded by something automated rather than by a person uploading a file. The REST API returns the same extraction the exports carry, and the TypeScript SDK on npm wraps it, so the integration is yours to write rather than ours to fake.

The mapping happens on their side

Which columns NetSuite accepts is NetSuite's to define, and it changes between products and editions. We publish our own layouts precisely and do not publish a mapping into theirs that we have not tested, because a confident wrong table would cost you an afternoon.

Why it is not here yet

A file format ships once we can verify it end to end: generate it, import it into NetSuite, and see the transactions land correctly. Until that is done, the honest option is the one above, and this page says so rather than listing a format we have not proved.

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

Four formats produce a file today and nine do not. See all thirteen, grouped