How to Import Invoice to NetSuite (2026 Guide)

Each invoice row in your CSV references a customer (Entity field) and one or more items. These records must already exist in NetSuite before you import. Go to Lists > Relationships > Customers and Lists > Accounting > Items to verify. You can match customers by name, internal ID, or external ID.

Warning: Rows that reference a non-existent customer or item will fail. Import missing records before proceeding.

Navigate to Setup > Import/Export > Import CSV Records. Set Import Type to Transactions and Record Type to Invoice. This configures the import wizard to expect invoice header fields (Entity, Tran Date, Due Date, Terms) and line-item fields (Item, Quantity, Rate, Amount).

Structure your CSV with header fields on the first row of each invoice and line items on subsequent rows grouped by External ID. Required header fields include External ID, Entity, and Tran Date. Line items require Item, Quantity, and Amount at minimum. Optional fields like Due Date, Terms, Currency, and Tax Code provide richer invoice detail.

Tip: Use a consistent External ID format (e.g., INV-1001) on every row of a multi-line invoice so NetSuite groups all line items into a single invoice.

On the Scan & Upload CSV File page, click Select to browse for your CSV file. Choose the appropriate character encoding (UTF-8 for most files). Click Open, then Next to move to the field mapping step.

NetSuite auto-maps columns that match known field names. Verify that Entity maps to the Invoice Customer field, Tran Date maps to Date, and Item maps to the line-item Item field. Use drag-and-drop to correct any mismatches and the pencil icon to set default values for unmapped fields like Posting Period or Location.

Import one or two invoices first to validate your mapping. Open the created invoices in NetSuite and confirm the customer, dates, line items, amounts, and payment terms are correct. Check that the Due Date and Terms calculate the expected payment schedule.

After verifying your test batch, upload the complete CSV file, reapply your saved mapping, and click Run. NetSuite processes each row and creates invoice transactions with their associated line items. The invoices will create accounts receivable entries automatically.

If the import completes successfully, the invoices appear under Transactions > Sales > Invoices. If errors occur, the Job Status page provides a CSV Response file with error details for each failed row. Common errors include mismatched entity names, invalid item references, and unbalanced exchange rates. Correct the CSV and re-import only the failed records.