This article may be out of date!
Visit the New Knowledge Center

How to Export from QuickBooks Online

Thinking about trying Clio? Try it for free!

Have some questions? Contact us via email or phone at 1-888-858-2546 ext 1.


  • Get my data out of QuickBooks Online
  • Migrate from QuickBooks Online
  • Export from QuickBooks Online
  • QuickBooks Online migration
  • Get data from QuickBooks Online to Clio 


  • QuickBooks Online

Additional Information:

Please note that the success of any data migration depends primarily on the quality of the data set provided to us. Before attempting to migrate your information into Clio, you should ensure that your data is consistently formatted, well organized, sufficiently backed up, and stored securely. If you are not certain, it is recommended that you consult with your Clio representative before proceeding.



  1. Select Reports
  2. Scroll down the page to find the Customer Contact List report (may also be named Client Contact List)
  3. Click Customize and ensure the Deleted state is set to All, in order to capture all contacts
  4. Click the gear icon to customize the columns included in the report.
  5. Ensure Client, First Name, Last Name is all checked, in addition to Billing and/or Shipping Street, City, State, ZIP, and Country.
    • Note: the Client column will be used to generate the Matters 
  6. Select additional columns as needed.
  7. Deselect the columns you don't need (e.g. Full Name)
  8. Expand the Header/Footer section 
  9. Uncheck Company Name and Report Title
  10. Click Run Report
  11. Select the icon that looks like a sheet of paper with an arrow
  12. Select Export to Excel

Accounts Receivable 

  1. Click Reports
  2. Select the Standard sub-tab
  3. Choose Accounts Receivable Aging summary
  4. Select 30 days for 3 periods
  5. Click Run Report
  6. Click the icon that shows a square with an arrow pointing upward
  7. Select Excel option for file format

Related Content:

What happens to the information that can't be brought to Clio in a data migration? See this article or contact us for information about the best practices for setting up your Clio account!

What data can I migrate from Quickbooks Online to Clio

Was this article helpful?
This information is confusing or wrong
This isn't the information that I was looking for
I don't like this functionality