How to Export QuickBooks Online Lists

by | Oct 15, 2020

After cleaning up and running reports on your QuickBooks Online (QBO) file, you are ready to begin exporting data. You will have quite a few lists to export if you are doing the manual process of creating a QuickBooks Online copy.

In this guide, learn how to:

  • Export necessary QuickBooks Online data.
  • Filter through and export specific data.


Exporting Data

First, click the “Gear” icon, go into “Export Data,” and then go into your “Lists.” Export the three choices of lists: customers, employees, and/or suppliers. If you are using Rewind Copy, you do not need to export your clients, vendors, or any of your products or services lists.

Next, you need to export your recurring templates. Click “Reports” in the sidebar. Search for “recurring templates.” You want to export the recurring templates list so that you have a moment in time when you are looking at it. It will be easier to recover those recurring templates as a result. You will also need to know what these recurring templates look like whether you are using Rewind Copy or whether you are doing this manually.

Specific Reports and Lists to Export

Return to “Reports” and search for “products and services.” Save an Excel CSV file of your products and services as you will later have to import it into the copied file. If you’re using Rewind Copy, go ahead and skip this step.

You will want to export some of the lists from “Sales Transactions.” Filter the reports by their classification. For example, if you want your open invoices, you can filter by that and apply a date range. You can export this as a CSV file. In the “Expenses,” you can also filter reports based on specific classifications and date ranges. Rewind Copy will bring all of this information over during the copy process.

To find “attachments,” click the “Gear” icon and click “Attachments.” Downloading attachments depends on if you are closing out a file and restarting a file. You can export any attachments that you want. Once you have downloaded all of the lists you need, you are prepared to copy your QuickBooks Online file.

Before moving your QuickBooks files around (or any SaaS data), it’s a good idea to have a solid data backup in place. Rewind’s suite of data backup and copy apps is trusted by over 80,000 businesses to secure their data. 

With dedicated backup solutions built for ShopifyBigCommerceGitHubTrelloQuickBooks Online, and more, Rewind is the leading provider of Backup-as-a-Service apps. 

Start your free trial of Rewind today.

Backup QuickBooks Online today

Backup QuickBooks Online today

Kellie Parks
Kellie Parks
Kellie Parks is a relentless organizer and believes cloud financial technology is the key to organization. She is the founder of SaaSy Accounting and Calmwaters Accounting and a Certified Professional Bookkeeper with Calmwaters Accounting. When she isn't coaching forward-thinking financial professionals in the future of accounting, she can typically be found with her partner and dogs at their 100-year-old lakeside cabin (that is chronically under renovation).