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 GL Report → Excel

NetSuite GL Report to Excel converter

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

The problem

NetSuite's General Ledger report is exhaustive but its CSV export uses single-signed Amount values (debit positive, credit negative), parenthesised negatives, and the same DD/MM/YYYY dates Excel sometimes mis-types as text. Every month you spend an hour cleaning it before the management report can use it.

What Mappd does

Mappd flattens the GL Report into a board-pack-ready Excel layout — ISO dates, plain signed numbers (no parentheses), trimmed memos, and the same Account / Type / Document Number columns the original carries. Drop it straight into your reporting template.

Column transformations

Date → Date (ISO 8601 format)
Type → Type (passthrough)
Document Number → Reference (trimmed)
Account → Account (trimmed)
Memo → Description (trimmed)
Amount → Amount (currency prefix stripped, parentheses normalised)

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 before1 hr
Time after2 min
Monthly runs880

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.