Lacerte Export

Lacerte Export

  1. Go to the Clients list > Tax Type > Choose Entity (go down the list).
  2. Select all of the clients by clicking the top name at the list and clicking the shift key + end key.
  3. Once all selected, go to the Client tab at the top and click Export > Export to Fileā€¦
  4. Leave Export Type to Comma Delimited.
  5. Change the name of the file to the entity type (e.g., Individual, S-Corp, etc.).
  6. Choose the following fields:
    1. Client Information
      1. City
      2. Client Full name
      3. Client Full name, last name first name
      4. Client number
      5. Client ID
      6. Country
      7. Corporation Name *** If it is an S-Corp, it will say S Corporation Name
      8. Due Date of Return
      9. Email Address
      10. Federal ID Number
      11. Firm Number
      12. Fiscal Year End
      13. Partnership Name
      14. Postal Code
      15. Phone Number
      16. Region
      17. State
      18. Street Address
      19. Taxpayer Email Address
      20. Taxpayer First Name
      21. Taxpayer Last Name
      22. Taxpayer Home Telephone Number
      23. Taxpayer Mobile Phone
      24. Taxpayer Occupation
      25. Taxpayer Social Security Number
      26. Taxpayer Title/Suffix
      27. Taxpayer Work Telephone Number
      28. Type of Entity
      29. Zipcode
      30. *** Grab any other fields that may be relevant to our data upload templates
  7. Click OK.

Data Disclaimers:

  1. Do not send data files via email.
  2. The cleanliness of data uploaded depends on the cleanliness of the source data.
  3. If data is in all caps, we will convert to proper case. Please know names such as "MCDONALD" will convert to "Mcdonald".
  4. 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!
  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.

    Contact Us

       Email:  support@liscio.me 
       Call Us: (765) 566-7127
       Hours: Monday - Friday | 8 AM - 8 PM EST
        Subscribe to our YouTube channel Liscio CX



      • Related Articles

      • Gmail Export Instructions

        Open Gmail Contacts. Select Google apps, then choose Contacts. In the left panel, select More to display additional options. Select Export. To export an entire address book, select Contacts. Select the drop-down arrow to choose a Google Contacts ...
      • Outlook Export: 2013 & 2016, 2010, Office 365

        Outlook 2013 & Outlook 2016 Open Outlook and click File.   Click Open & Export > Import/Export.   Select "Export to a file". Click Next.   Select "Comma Separated Values". Click Next.   Select Contacts option under Personal Folders.  Click Next.   ...
      • Xero Export

        In the Contacts menu, select the group of contacts you want to export. For example, to export contacts you've created sales invoices and sales credit notes for, click Customers. Click Export. Contacts will download as a CSV file to computer. Find ...
      • UltraTax Export

        Click Utilities and select Client Listing Reports.  Set report type to Client Contact. Check the box Include all contact phone numbers (export only). Click Continue. Under Focus, check boxes for 1040, 1120, 1165, 1041, Other. Click Select All. Click ...
      • Drake Export

        Note: Drake exports in all caps. If you want to retain all caps, please let us know, otherwise, we will convert to proper case. Please know names such as "MCDONALD" will convert to "Mcdonald". 1. Go to Reports at the top of Drake > Report Manager 2. ...