Reconciliation

Exporting a file is not proof that NetSuite accepted it. Reconciliation is the step where you record which exported orders exist as real transactions, so nothing quietly falls between the two systems. Find it at Settings → Reconcile.

What the screen shows

• Every order with status Exported that has not yet been marked reconciled, oldest first so ageing problems surface.
• Order number, customer, export date, line count, and total, which is enough to match against the NetSuite transaction list.
• A field for the NetSuite transaction ID, so you can store the document number NetSuite assigned.
• A note field for anything a future reader needs to know, such as which error caused a re-import.

Reconciling a batch

1. 1Import the file in NetSuite and open the CSV import status page to see how many rows succeeded.
2. 2Come back to Settings → Reconcile and tick the orders that landed.
3. 3Enter the NetSuite transaction ID for each one if you want the cross-reference; it is optional but makes later questions trivial to answer.
4. 4Add a note if anything about the batch was unusual.
5. 5Mark the selection reconciled. Those orders drop off the outstanding list.

When rows failed

1. 1Leave the failed orders unreconciled — the outstanding list is your worklist.
2. 2Read the error CSV and match each message against the import errors article.
3. 3Fix the underlying data here: the customer Internal ID, the item, the list value, the segment default.
4. 4Re-export just those orders from the Export center with the include-exported option on.
5. 5Re-import in NetSuite with Data Handling set to Add or Update so the External ID updates the existing transaction rather than duplicating it.
6. 6Reconcile once the retry succeeds.

Undoing a mistake

An order marked reconciled in error can be unreconciled, which returns it to the outstanding list along with its transaction ID and note. Reconcile actions are recorded in the audit log with the user and timestamp.

Making reconciliation quick

• Export in predictable batches — once a day is easier to reconcile than ad hoc single orders.
• Keep the NetSuite CSV import status page open while you tick, and compare counts rather than reading every row.
• Record transaction IDs from the start. Retrofitting them later is far more work than typing them as you go.
• If the same error recurs across batches, fix the configuration rather than the individual orders.

What Exported means and what comes after it