Practice CS Export

Practice CS Export

Step 1: Preparing for Export

Before exporting from Practice CS, please ensure the following:

  • Practice CS is up to date. Find the latest version here: cs.thomsonreuters.com (may require IT help to install).
  • Entity Types are assigned. Learn how to mass assign Entity Types here.
  • The Preferred Contact on a Business Client should be a person, NOT a business (see image below).
    mceclip1.png
     

Step 2: Create Filters

1. Click Setup > Clients

2. Click the ellipsis (three dots) button next to the filter field at the top. If you don't have the filter field, click the double blue arrow and it will appear.

3. Active Business Clients Filter

  • Create a Filter and call it "Active Business Clients".
  • Filter by: Entity - is in the list, then pick all your Entities other than Individual one(s). 
  • Filter by Status - is Active. 

practice2.png

practice3.png

4. Active Individual Clients

  • Create a Filter and call it "Active Individual Clients". 
  • Filter by: Entity - is in the list, then pick all Individual entities. 
  • Filter by Status - is Active.

practice4.png


Step 3: Import Files

*These files are for importing only, do not open the files.

Download files attached to the bottom of this article: All Clients - Liscio.cfx and Contacts - Liscio.cfx.
  • Click File > Import > Custom Formats
  • Click the ellipsis (three dots) to browse to where the reports are saved.
  • Pick the location, both reports, and click Import Selected.

practice5.png

practice6.png


Step 4: Run Reports

  • Go to File > Print Reports
  • Select All Clients - Liscio report.
  • Select Contacts - Liscio report three times.

practice7.png

  • Click on All Clients - Liscio and Filter by Status - is Active.
  • Change the description to: All Clients.

practice8.png

7. Click on the first Contacts - Liscio report

  • Filter by Client ID - Is in the Filter - Active Individual Clients.
  • Change the description to: Individual Contact Info.

practice9.png

8. Click the second Contacts - Liscio report

  • Filter by Client ID - Is in the Filter - Active Business Client.
  • Change the description to: Business Contact Info.
practice10.png













Note: If you have a newer version of Practice and do not see the 'Contact Type' option, please skip this step.

9. Click the third Contacts - Liscio report.
  • Filter by Contact Type - Is - Standalone.
  • Change the description to: Standalone Contact Info.

practice11.png

10. Click Print Selected and choose Output to file > Microsoft Excel.

practice12.png


 Step 5: Clean Exported Data List

What do we take from each report?**

All Clients: Account Names, EIN/SSN, Entity

Business: Account addresses

Individual: Contact information, Relationships

**(We do not upload the Standalone Contacts report exported from Practice CS)

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

      • Mass Assign Entity Types in Practice CS

        Go to Setup > Clients. Click Edit Multiple Clients. Choose Change Client Information. Filter by Entity Type - is blank. Select all Clients of similar entity and click Next. Choose the appropriate Entity from the drop-down. Click Finish and repeat ...

      • 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.   ...

      • Intuit Practice Management Integration: Troubleshooting

        Troubleshooting Tips for the Liscio-Intuit Practice Management Integration If you have created a record in Intuit Practice Management, ensure you have run a new sync to bring the record onto the Liscio integrations page. Running a sync does not ...

      • Intuit Practice Management Integration: Syncing Records

        After you have established your Liscio-Intuit Practice Management connection, you can begin syncing your records. This can be done automatically or manually. Caution - Do not sync Intuit Practice Management before we have your client data uploaded. ...