/01 Receive
A new report lands in your inbox
One week of corporate card charges: lines across cardholders and subsidiaries. Mapping this report with JEMapper turns every line of this report, as well as all future reports, into a NetSuite Credit Card Charge automatically.
Canavar BBQ Credit Card Expense Report.csv
/02 Set up
Every new mapping starts with the transaction header
The transaction header setup has been completed for you below. Click Continue to map the GL accounts to each line.
Transaction header
- Record type
- Credit Card Charge
- External ID
- Credit Card - [Cardholder] - [Subsidiary] - [Date]
- Date
- Latest Transaction Date on the charge
- Card account
- Looked up from Cardholder
- Entity
- Credit Card Vendor, on every charge
- Subsidiary
- Looked up from Location
- Memo
- Same as External ID
Expense lines
- Account
- Chosen for each line, in the next step
- Amount
- Amount
- Memo
- [Merchant from Description] - [Cardholder Notes]
- Location
- Location
Cardholder lookup
| Cardholder | Card account |
|---|
/03 Map
Where does each line belong?
Pick an account for each charge on the report. Every choice is a real account from your chart, and the charges will balance whichever you pick.
Expense lines
/04 Review
Five charges, balanced
One Credit Card Charge per cardholder and subsidiary. Marcus Whitfield's card paid for stores in Nebraska and Kansas, and a charge belongs to one subsidiary, so his week becomes two charges. The Nebraska one is shown in full.
Balance validation
Charges
| Cardholder | Subsidiary | Card account | Lines | Amount |
|---|
| Account | Line memo | Location | Debit | Credit |
|---|
/05 Export
Your file, ready for NetSuite
Built from the accounts you picked, highlighted below. One row per expense line, and NetSuite groups the rows into charges by External ID.
What happens in NetSuite
- Import
- Credit Card Charge, CSV Import Assistant
- Splits on
- External ID, giving 5 charges
That is a new report source, mapped once. Click Learn more to become an early adopter! Here is how we handle your data.