How to export your data from QuickBooks

Whether you need a copy of your reports, contact lists, or other business data, QuickBooks makes it straightforward to export. Here's how to do it depending on which product you're using.

QuickBooks Online

There are two ways to export your data:

Using the Export Data tool

This is the best option if you want to download multiple reports and contact lists at once into a single Excel file.

What you can export: Profit and Loss report, Balance Sheet report, Trial Balance report, General Ledger report, Customer List, Supplier List, and Employee List.

1. Go to Settings and select Export data
2. In the Reports tab, set your date range from the Pre-selected date ranges dropdown
3. Add or remove items from the Reports and Lists tabs by turning them on or off
4. Select Export to Excel
5. Choose the folder where you want to save your file, then select Save
6. Select OK to confirm

You can customise your report before exporting if you only need specific data. If you need to export a different report, here's how to export reports to Excel.

Need to export individual items instead? Check out this guide 

QuickBooks Sole Trader

Using the Export Data tool

What you can export: Profit and Loss report and your Customer List.

1. Go to Settings and select Export data
2. In the Reports tab, set your date range from the Pre-selected date ranges dropdown
3. Add or remove items from the Reports and Lists tabs
4. Select Export to Excel
5. Choose where to save your file, then select Save
6. Select OK to confirm

You'll get a confirmation once the export is complete.

Need to export individual items instead? Check out this guide