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.
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 cleans a NetSuite Transaction Detail saved-search export into a flat Excel sheet, keeping Debit and Credit as separate columns. It reformats Date to ISO 8601 (YYYY-MM-DD), renames Document Number to Reference, Name to Entity and Memo to Description, and strips currency symbols from both amount columns. Processing is client-side. Typical run time: 2 minutes.
What columns does this recipe rename?
Date → Date (ISO format). Document Number → Reference. Name → Entity. Memo → Description. Amount (Debit) → Debit and Amount (Credit) → Credit, both with currency symbols stripped. There is no Running Balance column — NetSuite doesn't ship one, and Mappd won't invent it.
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).