How to Export QuickBooks Online Lists


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 QBO copy.

In this guide, learn how to:

  • Export necessary QBO 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. You do not have to do this using Rewind Copy.

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 QBO file.

This article originally appeared by our friends at Rewind.

Leave a Reply

Your email address will not be published. Required fields are marked *

8 Ways You Can Improve Your Consumers’ Online Trust of Your Products

8 Ways You Can Improve Your Consumers’ Online Trust of Your Products

13 Spooktacular Halloween SMS Templates

13 Spooktacular Halloween SMS Templates


Steve has entrepreneurship in his DNA. Starting in the early 2000s, Steve achieved eBay Power Seller status which propelled him to become a founding partner of, a contact lens and eyewear retailer. Four years later through a successful exit from that startup, he embarked on his next journey into digital strategy for direct-to-consumer brands.

Currently, Steve is a Senior Merchant Success Manager at Shopify, where he helps brands to identify, navigate and accelerate growth online and in-store.

To maintain his competitive edge, Steve also hosts the top-rated twice-weekly podcast eCommerce Fastlane. He interviews Shopify Partners and subject matter experts who share the latest marketing strategy, tactics, platforms, and must-have apps, that assist Shopify-powered brands to improve efficiencies, profitably grow revenue and to build lifetime customer loyalty.

You May Also Like
payday loans loans for bad credit
where can i buy clomid buy clomid