Learn how to download your data from QuickBooks Online.
There's a simple way to export your QuickBooks Online reports and lists. This means you can easily download the data entered into your file to your local hard drive.
Export your reports and lists
You can export the following reports and lists into individual Excel files contained in a zip file in one process. To export your report or list:
- Go to Settings ⚙.
- Select Export data.
- On the Reports tab, set the date range.
- Add or remove items from the Reports and Lists tabs by turning the switch on or off.
- Select Export to Excel.
You'll be prompted with confirmation that the data has been exported.
If you need to export a different report, here's how to export reports to Excel.
Export non-posting transactions and attachments
Exported reports will include the data from posting transactions like invoices, receipts, bills, balances, and so on. Here's how to export non-posting information that's not included in Reports and Lists.
Estimates
- Go to Sales, then All sales (Take me there).
- From the Type ▼ dropdown, select Estimates.
- From the Date ▼ dropdown, select the date range you want to pull transactions from.
Note: You can apply other filters you need. - Select the Export to Excel
icon.
Purchase Orders
- Go to Expenses, then Expenses (Take me there).
- Select the Filter ▼ dropdown.
- From the Type ▼ dropdown, select Purchase order.
- Set your date range and any other filters you need, then select Apply.
- Select the Export to Excel icon.
Recurring Templates
- Go to Reports (Take me there).
- Search for the Recurring Template List report and open it.
- Select the Export icon, then select Export to Excel.
Chart of Accounts
- Go to Reports (Take me there).
- Search for Account List.
- Select Export icon, then select Export to Excel.
Products and Services
- Go to Settings ⚙, then Products & services (Take me there).
- Select the More dropdown arrow, then select Run report.
- Select the Export icon, then select Export to Excel.