Showing results for 
Search instead for 
Did you mean: 
Not applicable

Exporting invoices as Excel/CSV files


I'm trying to export my data from QBD 2016 for mac as Excel/CSV files so I can import it to Quickbooks online UK. They're not compatible for a straight transfer

I've managed to export/import customers/vendors and item lists using Excel.

I've tried using Custom Transaction Details reports to export invoices but they don't show all the invoice details.

Any suggestions as to how to export our invoice data and any other info would be great!

1 Comment
Established Community Backer ***

Re: Exporting invoices as Excel/CSV files

UK has different taxes (VAT, etc) and I don't know if it can represent the invoices accurately that were made in the US (which QuickBooks Mac assumes).  So that's the first issue - can you even create a duplicate of a US invoice from the Mac manually by typing it into the UK QuickBooks Online?


Assuming that can be surmounted, the approach I'd try is QuickBooks Mac export to QuickBooks Online US.  And then see if there is a way to migrate QuickBooks Online US to QuickBooks Online UK.   Since the first step (Mac->QuickBooks Online) is doable you have to solve the second (QB online US -> QB Online UK).  So research that second step and see if there is a published method.

Need to get in touch?

Contact us