/01 Upload

Your reports, exactly as they are received

Nothing renamed, nothing reordered, nothing cleaned up first. JEMapper reads the file and recognizes which of your saved mappings it belongs to. This one is a DoorDash payout summary.

DoorDash FINANCIAL_PAYOUT_SUMMARY.csv

Uploaded a moment ago

25Rows

28Columns

25Locations

9Subsidiaries

What JEMapper found

Report source: DoorDash
Mapping: DoorDash Payout Summary
Record type: Journal Entry
Payout date: 08/20/2026
Currency: USD
Entries to produce: 25, one per location

Mapping found.

Additional features: upload history for every report source

/02 Map

Your mapping, applied automatically

JEMapper applies your approved mapping configuration every time you upload a new report.

Entry header

External ID: DoorDash - [Merchant store ID] - [Payout date]
Memo: Same as External ID
Date: Payout date
Location: Merchant store ID
Subsidiary: Looked up from Location
Currency: Currency

Lines

Source column	Account

15Post to a line

3Marked unmapped

10Identify the row

Additional features: NetSuite data element sync

/03 Review

Twenty-five entries, balanced

One journal entry per location, split on External ID. DENVER-001 is shown in full. All data can be traced back to the uploaded report.

Balance validation

25 of 25 entries balance. Total variance 0.00.

25Entries

202Lines

73,574.89Total debits

73,574.89Total credits

DoorDash - DENVER-001 - 08202026

Colorado/08/20/2026

Account	Line memo	Debit	Credit
Total		1,766.35	1,766.35

Additional features: review each transaction in the report

/04 Export

Import to NetSuite without remapping

Every column header is a NetSuite field name, so the Import Assistant pairs them automatically without rebuilding the field mapping.

JEMapper DoorDash Journal Entry Import.csv

10 columns, 202 lines, 25 transactions

Journal Entry: External ID,Journal Entry: Date,Journal Entry: Memo,Journal Entry: Subsidiary,Journal Entry: Currency,Journal Entry - Line: Account,Journal Entry - Line: Debit,Journal Entry - Line: Credit,Journal Entry - Line: Memo,Journal Entry - Line: Location
DoorDash - DENVER-001 - 08202026,08/20/2026,DoorDash - DENVER-001 - 08202026,Colorado,USD,4300,,1607.52,DoorDash gross sales,DENVER-001
DoorDash - DENVER-001 - 08202026,08/20/2026,DoorDash - DENVER-001 - 08202026,Colorado,USD,2150,,123.30,Sales tax collected by DoorDash and passed through,DENVER-001
DoorDash - DENVER-001 - 08202026,08/20/2026,DoorDash - DENVER-001 - 08202026,Colorado,USD,7000,279.50,,DoorDash commission,DENVER-001
DoorDash - DENVER-001 - 08202026,08/20/2026,DoorDash - DENVER-001 - 08202026,Colorado,USD,4910,113.29,,Promotions funded by the operator,DENVER-001

What happens in NetSuite

Import: Journal Entry, CSV Import Assistant
Splits on: External ID, giving 25 transactions
Field mapping: Automatic, the headers already match
Next time: Upload the file. The mapping is already saved

Additional features: one-click download of a NetSuite-ready CSV

/05 Next upload

What if the report changes?

JEMapper flags changes from your saved mapping so you can make updates to ensure new transactions are recorded correctly.

Balance validation

25 of 25 entries do not balance. Total variance 5,559.96.

Columns in this file

Source column	Account

Additional features: an optional approval step before saving mappings

/06 Add a report source

Got another report? Create a new mapping

Every recurring report for supported transaction types gets its own mapping. Build it once, and the NetSuite import is created automatically.

Canavar BBQ Credit Card Expense Report.csv

Uploaded a moment ago

27Rows

9Columns

0Columns recognized

What JEMapper found

Report source: Not recognized
Mapping: None found
Record type: Not set
Entries to produce: None

No mapping found.

Additional features: NetSuite upload guide for all supported transaction types

Want to try it for yourself? Click Learn more to become an early adopter!