QuickBooks HelpQuickBooksHelpIntuit

Export data, reports, lists, and more from QuickBooks Online

SOLVEDby QuickBooks102Updated 7 days ago

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 format in one process:

ReportsLists
General LedgerCustomers
Profit and LossEmployees
Balance SheetSuppliers
Trial Balance
Journal

To export your report or list:

  1. Select the Settings ⚙ icon from the tool bar.
  2. Under Tools, select Export Data.
  3. On the Reports tab, set the date range.
  4. Add or remove items from the Reports and Lists tabs by toggling the slider.
  5. 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.

Note: You can customise your report to export the data that matters to you most.

Export non-posting transactions and attachments

Exported reports will include the data from posting transactions such as invoices, receipts, bills, balances and so on. Here's how to export non-posting information that's not included in Reports and Lists.

  1. Go to Bookkeeping, select Transactions, then select All sales (Take me there).
  2. Select Filter.
  3. Under Type, choose Estimates.
  4. Set your date range and any other filters you need, then Apply.
  5. Select the Export to Excel icon.
  1. Go to Bookkeeping, select Transactions, then select Expenses (Take me there).
  2. Select Filter.
  3. Under Type, choose Purchase Order.
  4. Set your date range and any other filters you need, then Apply.
  5. Select the Export to Excel icon.
  1. Go to Bookkeeping , select Transactions, then select All sales (Take me there).
  2. Select Filter.
  3. Under Type, choose Statements
  4. Set the date range and any other filters you need, then select Apply.
  5. Select the Export to Excel icon.
  1. Select the Settings ⚙ icon from the tool bar.
  2. Under Lists, select Attachments.
  3. On this page, select the attachments you want to export.
  4. Select Batch Actions and then Export.

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

  1. Go to Business overview and select Reports (Take me there).
  2. Search for Recurring Template List report.
  3. Select the Export icon, then choose Export to Excel.
  1. Go to Business overview and select Reports (Take me there).
  2. Search for Account List.
  3. Select the Export icon, then choose Export to Excel.
  1. Go to Get paid & pay and select Products & services (Take me there).
  2. Select the More dropdown arrow, then select Run report.
  3. Select the Export icon, then choose Export to Excel.

Was this helpful?

You must sign in to vote, reply, or post
QuickBooks Online EssentialsQuickBooks Online PlusQuickBooks Online Simple Start

Sign in for the best experience

Ask questions, get answers, and join our large community of QuickBooks users.

More like this