QuickBooks HelpQuickBooksHelpIntuit

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.

ReportsLists
General ledgerCustomers
Profit and lossEmployees
Balance sheetSuppliers
Trial balance
Journal
  1. Go to Settings Settings gear icon. and in the TOOLS column, select Export data.
  2. On the Reports tab, set the date from the Pre-selected date ranges ▼ dropdown.
  3. Add or remove items from the Reports and Lists tabs by turning the switch on or off.
  4. Select Export to Excel.
  5. 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.

  1. Go to Sales and select All sales (Take me there).
  2. From the Type ▼ dropdown, select Estimates.
  3. From the Date ▼ dropdown, select the date range you want to pull transactions from.
    Note: You can apply other filters you need.
  4. Select the Export to Excel Image Alt Text icon.
  1. Go to Expenses and select Expenses (Take me there).
  2. From the All transactions ▼ dropdown, select Purchase order.
  3. Select the FilterCustomise alternate icon. icon.
  4. Set the date range and any other filters you need, then select Apply.
  5. Select Export to ExcelImage of the Export to excel icon..
  1. Go to Sales and select Customers (Take me there).
  2. Select a customer whose statement you need to export.
  3. From the Statements tab, select the statement that you want to export. Then, select Print.
    Note: If you can’t find the statement, you can modify the date range from the Date dropdown.
  4. Select the Download icon. Then, select the folder where you want to save your file.
  5. Select Save.
  1. Go to Settings Settings gear icon. and in the LISTS column, select Attachments (Take me there).
  2. Select the attachments you want to export.
  3. Select the Batch actions ▼ dropdown, then select Export.

Note: Your attachments will be exported in a zip file.

  1. Go to Reports (Take me there).
  2. Find and select Recurring Template List.
  3. Select the More actions ▼ dropdown, then select Export to Excel.
  1. Go to Reports (Take me there).
  2. Find and select Account List.
  3. Select the More actions ▼ dropdown, then select Export to Excel.
  1. Go to Settings Settings gear icon. and in the LISTS column, select Products and Services (Take me there).
  2. Select the More ▼ dropdown, then select Run report.
  3. Select the More actions ▼ dropdown, then select Export to Excel.
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in now for personalized help

See articles customized for your product and join our large community of QuickBooks users.