NetSuite CSV Import Template for Journal Entries — Free Download + Explained
Published 2026-05-08
NetSuite’s CSV import for journal entries requires a specific column structure. Here’s the exact template, what each column means, and the common errors that prevent imports from working.
The required columns
| Column | Required? | Example value | Notes |
|---|---|---|---|
| External ID | Yes | STRIPE-2026-04-001 | Must be unique per journal entry. Used for idempotency on re-imports. |
| Subsidiary | Yes | Acme Corp | Must match your NetSuite subsidiary name exactly |
| Currency | Yes | USD | ISO 4217 code |
| Trandate | Yes | 04/30/2026 | Format: MM/DD/YYYY. No other format accepted. |
| Account | Yes | Stripe Clearing | Must match NetSuite account name or internal ID |
| Debit | No* | 1250.00 | Positive number. No currency symbol. |
| Credit | No* | 1250.00 | Positive number. |
| Line Memo | No | April Stripe payout | Per-line description |
*Debit or Credit must be present on each line; both can’t be blank.
The two-line structure (why Stripe exports don’t map directly)
Every journal entry needs at least two lines: a debit and a credit. A Stripe payment of $100 looks like this in NetSuite:
External ID, Subsidiary, Currency, Trandate, Account, Debit, Credit, Line Memo
STRIPE-2026-04-001, Acme Corp, USD, 04/30/2026, Stripe Clearing, 100.00, , April payment
STRIPE-2026-04-001, Acme Corp, USD, 04/30/2026, Revenue, , 100.00, April paymentSame External ID on both lines (they’re part of the same entry). The two lines balance: $100 debit to Stripe Clearing, $100 credit to Revenue.
Stripe’s CSV export gives you one row per charge. You need to split each row into two. That’s the hard part, and it’s what the planned csvtocsv.com/stripe-to-netsuite adapter automates.
Common import errors
- “Invalid subsidiary”: The subsidiary name doesn’t exactly match. Copy the name from NetSuite → Setup → Company → Subsidiaries.
- “Account not found”: The account name doesn’t match exactly (case-sensitive). Use the internal ID instead.
- “Invalid date”: Date format must be MM/DD/YYYY with leading zeros. 4/1/2026 will fail; 04/01/2026 works.
- “Journal entry is not in balance”: The total of Debit and Credit columns across all lines for the same External ID must be equal.
Download the template
Copy this template, fill in your values, save as UTF-8 CSV, then import via NetSuite → Setup → Import/Export → Import Records → Transactions → Journal Entry.
External ID,Subsidiary,Currency,Trandate,Account,Debit,Credit,Line Memo
JE-001,Acme Corp,USD,04/30/2026,Stripe Clearing,1250.00,,April payout debit
JE-001,Acme Corp,USD,04/30/2026,Revenue,,1250.00,April payout credit