
Export your QuickBooks Online data
by Intuit• Updated 4 days ago
Learn how to export your reports, lists, and other data from QuickBooks Online.
You can save and export your QuickBooks Online reports, lists, and other data to your computer. This lets you share and access the data you need, anytime you need it.
Tip: You can also use third-party apps to backup your data in QuickBooks Online.
Export your reports and lists
You can export your reports and lists as Excel files in one .zip file. This lets you save info from posting transactions that impact your account balances, like invoices, receipts, and bills. Here’s how.
Reports | Lists |
General ledger | Customers |
Profit and loss | Employees |
Balance sheet | Suppliers |
Trial balance | |
Journal |
- Go to Settings
and in the TOOLS column, select Export data.
- On the Reports tab, set the date from the Pre-selected date ranges ▼ dropdown.
- Add or remove items from the Reports and Lists tabs by turning the switch on or off.
- Select Export to Excel.
- Select OK to make sure that it’s done.
You'll be prompted with confirmation that the data has been exported.
Note: You can customise your report to export the data that matters to you most. |
Tip: If you need to export a different report, here's how to export reports to Excel.
Export non-posting transactions and other data
Here's how to export non-posting transactions that don't impact your reports, and other data not included in Reports and Lists.
Sign in now for personalized help
See articles customized for your product and join our large community of QuickBooks users.
More like this
- Export your reports to Excel from QuickBooks Onlineby QuickBooks
- Export customer data to Excelby QuickBooks
- Customise reports in QuickBooks Online using modern viewby QuickBooks
- Export data to Google Sheets with QuickBooks Online Advancedby QuickBooks