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.
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.
Column transformations
Common questions
How do I convert a ERP export to Excel format?
Mappd flattens a NetSuite General Ledger report export into a board-pack-ready Excel sheet by reformatting Date to ISO 8601 (YYYY-MM-DD), renaming Document Number to Reference and Memo to Description, and stripping the currency symbol from Amount. The Amount column stays signed — debits positive, credits negative. Processing is client-side. Typical run time: 2 minutes.
What columns does this recipe rename?
Date → Date (ISO format). Document Number → Reference. Memo → Description. Amount → Amount (currency symbol stripped, sign preserved). Type and Account pass through trimmed.
Does my file get uploaded to a server?
No. All processing happens entirely in your browser. Your file's data is only sent to Mappd if you save the conversion to your history.
Is this free?
Yes. Mappd is free for three saved recipes and unlimited rows. Free to use, with no card required. Pro (£15/month) lifts the recipe limit and keeps your last 50 conversions. AI column matching is on Pro+ (£25/month).