Direct answer

Mappd converts QuickBooks invoice exports to Xero sales-invoice import format by renaming Customer to ContactName, Invoice No to InvoiceNumber and Amount to Total (currency prefix stripped), keeping Invoice Date and Due Date in DD/MM/YYYY for UK Xero. Processing is client-side. Typical run time: 2 minutes.

8 minmanual work
2 minwith Mappd
Freeto start
Client-sidefile never uploaded
Recipes → Finance
Finance · QuickBooks → Xero

QuickBooks invoices into Xero (UK) — recipe

Built for Finance / Bookkeeping teams
8 min → 2 min
Free to use
Load this recipe free → Watch it work
Go from 8 min manual work to 2 min with Mappd.

The problem

Migrating from QuickBooks to Xero means re-shaping every open invoice. QuickBooks gives you Customer, Invoice No, Invoice Date, Amount and Due Date. Xero's sales-invoice import wants ContactName, InvoiceNumber, InvoiceDate, DueDate and Total — and the dates have to be DD/MM/YYYY for UK Xero.

What Mappd does

Mappd reads a QuickBooks invoice export and re-shapes it into Xero's sales-invoice import template. Columns rename to Xero's exact headers, dates land in DD/MM/YYYY (what UK Xero requires), and the currency prefix is stripped from the total so the upload succeeds first time.

Column transformations

Customer → ContactName (trimmed)
Invoice No → InvoiceNumber (trimmed)
Invoice Date → InvoiceDate (DD/MM/YYYY)
Due Date → DueDate (DD/MM/YYYY)
Amount → Total (currency stripped)

How to use this recipe

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

Use this recipe

Free for files under 5 MB. No card required.

Load recipe → Watch the demo →
Free forever · No credit card
CategoryFinance
Time before8 min
Time after2 min
AudienceFinance / Bookkeeping

Common questions

How do I import a QuickBooks export into Xero?

Mappd converts QuickBooks invoice exports to Xero sales-invoice import format by renaming Customer to ContactName, Invoice No to InvoiceNumber and Amount to Total (currency prefix stripped), keeping Invoice Date and Due Date in DD/MM/YYYY for UK Xero. Processing is client-side. Typical run time: 2 minutes.

What columns does this recipe rename?

Customer → ContactName (trimmed). Invoice No → InvoiceNumber (trimmed). Invoice Date → InvoiceDate (DD/MM/YYYY). Due Date → DueDate (DD/MM/YYYY). Amount → Total (currency stripped).

Does my file get uploaded to a server?

No. The conversion runs in your browser. Your 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. No card required. Pro+ adds AI column matching for non-standard exports and cell-level editing.