Skip to main content
All CollectionsData Export Instructions
QBO (QuickBooks Online) Export
QBO (QuickBooks Online) Export
Liscio Support avatar
Written by Liscio Support
Updated over a month ago

1. Click Reports.

2. Scroll down and select Customer Contact List.

3.Click the gear icon on the right-hand side.

mceclip0.png

4. Select the following columns:

  1. Customer

  2. Phone Numbers

  3. Email

  4. Full Name

  5. Billing Address

  6. Phone

  7. Company Name

  8. Billing Street

  9. Billing City

  10. Billing State

  11. Billing Zip

  12. Billing Country

  13. Last Name

  14. First Name

  15. Customer Type OR Entity Type

5. Select the Export Icon.

mceclip1.png

6. Choose Export to Excel.
​

Data Disclaimers:

  1. Data should include first names, last names, account/client names, email addresses, phone numbers, and entity types.

    1. Email addresses are extremely important. This is how you will send your invites to Liscio. Please include as many as possible!

  2. Do not send data files via email.

  3. The cleanliness of data uploaded depends on the cleanliness of the source data.

  4. If data is in all caps, we will convert to proper case. Please know names such as "MCDONALD" will convert to "Mcdonald".

  5. Mobile numbers must be classified as such in order to go under the Mobile Phone category.

  6. If no entity types (i.e. S-Corp, Partnership, Trust, etc.) are listed, accounts/clients will default to Individual or Organization.

  7. Contacts cannot share an email address.

  8. Phone numbers without area codes cannot be imported.

  9. Duplicate Account Names and Contact Names can occur if they exist in source data.

  10. Certain fields, such as Bank Account, Notes, or Birthdates, cannot be imported.


​

Did this answer your question?