Exporting Customers From Quickbooks

How to export customers out of Quickbooks into a friendly format to fit Profit Rhino's import template.

Profit Rhino avatar
Written by Profit Rhino
Updated over a week ago

We're able to save our mobile app users a ton of time by importing their customer list into Profit Rhino. The only problem is it can take us hours in Excel to manipulate the data into the proper format depending on how the data is organized.ย 

Help us help you! The video below will detail how to export your customers in the proper format, so that we can quickly complete your customer import project.
โ€‹

Step by step instructions are also listed below.

  1. Once logged into Quickbooks Online, go to Reports

  2. Scroll down to Sales and Customers and click on 'Client Contact List'

  3. In the top right hand corner, click on the Setting (Gear) Icon

  4. Adjust the format to export in separate columns the following...

  • Client

  • First Name

  • Last Name

  • Billing Street

  • Billing City

  • Billing State

  • Billing ZIP

  • Billing Country

  • Phone Numbers

  • Email

Feel free to reach out to our Support Team with any questions!

Did this answer your question?