Direct answer

Mappd converts ERP system exports (NetSuite, SAP, Sage) to a clean Excel dashboard layout by renaming system field names like TRANDOC.TRANDATE to plain-English equivalents like Date, stripping currency codes from amount fields, reformatting dates to ISO 8601, and removing technical column prefixes. Processing is client-side. Typical run time: 5 minutes.

2 hrmanual time
5 minwith Mappd
1,340monthly runs
Freeto start
Recipes → Finance
Finance · NetSuite Transaction Detail → Excel

NetSuite Transaction Detail to Excel converter

1,340 runs this month
2 hr → 5 min
Free to use
Load this recipe free → Watch it work
45 min
manual time per run
3 min
with this recipe
1,140
runs this month

The problem

NetSuite's Transaction Detail saved search exports columns like Date, Document Number, Memo, Type, Name, Account, Amount (Debit) and Amount (Credit) — the labels are correct but the values arrive as 'GBP 12,400.00' strings, the dates are DD/MM/YYYY UK format, and your Excel template wants something flatter. Every period-end you spend 45 minutes hand-fixing it.

What Mappd does

Mappd reads the Transaction Detail export, normalises dates to ISO, strips the GBP prefix from the separate Debit and Credit columns, trims the Memo into a usable Description column, and keeps Type, Name, and Account exactly as NetSuite gives them — so the result imports cleanly into any Excel template.

Column transformations

Date → Date (ISO 8601 format)
Document Number → Reference (trimmed)
Type → Type (passthrough)
Name → Entity (trimmed)
Account → Account (trimmed)
Memo → Description (trimmed)
Amount (Debit) → Debit (currency prefix stripped)
Amount (Credit) → Credit (currency prefix stripped)

How to use this recipe

1. Click "Load this recipe free" above — or watch the live demo first.
2. Drop your ERP export file into Mappd.
3. The column mapping loads automatically — adjust anything you need.
4. Review the change summary, then download your transformed file.

Use this recipe

Free for files under 5 MB. No signup required.

Load recipe → Watch the demo →
Free forever · No credit card
CategoryFinance
Time before45 min
Time after3 min
Monthly runs1,140

Common questions

How do I convert a ERP export to Excel format?

Mappd converts ERP system exports (NetSuite, SAP, Sage) to a clean Excel dashboard layout by renaming system field names like TRANDOC.TRANDATE to plain-English equivalents like Date, stripping currency codes from amount fields, reformatting dates to ISO 8601, and removing technical column prefixes. Processing is client-side. Typical run time: 5 minutes.

What columns does this recipe rename?

Transaction Date → Date (ISO format). Document Number → Reference. Debit/Credit Amount → Debit/Credit (currency prefix stripped). Running Balance → Balance. Department → Cost Centre. Memo → Description (trimmed).

Does my file get uploaded to a server?

No. All processing happens entirely in your browser. Your file data never leaves your computer.

Is this free?

Yes. Mappd is free for three saved recipes and unlimited rows. No signup required for files under 5 MB. Pro (£15/month) adds currency conversion, Excel export, and AI column matching.