The problem
Migrating from NetSuite to QuickBooks Online means re-shaping every open invoice into a format QBO will swallow. NetSuite gives you Document Number, Name, Date, Total, Due Date. QBO wants InvoiceNo, Customer, InvoiceDate, DueDate, Amount. Same data, different vocabulary — and the dates have to be DD/MM/YYYY for UK QBO. Manual migration takes a finance team three hours per period.
What Mappd does
Mappd reads a NetSuite Customer Invoice saved-search export and re-shapes it into QuickBooks Online's invoice-import schema. Dates land in DD/MM/YYYY (what UK QBO requires), the currency prefix is stripped, and the column names match QBO's importer exactly so the upload succeeds first time.
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 NetSuite invoices to QuickBooks format?
Mappd converts NetSuite invoice exports to QuickBooks import format by renaming Document Number to InvoiceNo and Name to Customer, keeping InvoiceDate and DueDate in DD/MM/YYYY for UK QuickBooks, and stripping the currency prefix from Total to Amount. Processing is client-side. Typical run time: 2 minutes.
What columns does this recipe rename?
Document Number → InvoiceNo (trimmed). Name → Customer (trimmed). Date → InvoiceDate (DD/MM/YYYY). Due Date → DueDate (DD/MM/YYYY). Total → Amount (currency prefix stripped).
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).