Data Migration General Information

Have more questions? Submit a request

Data migration process

In Clio, data migration is the process of exporting your practice management data from one software and importing it into another. The table below shows what data can and cannot be migrated into Clio. The steps below the table outline what the data migration process is generally like at Clio.

What can be migrated? What can't be migrated?
Unbilled time and expense activities  
Contacts

Accounting and financial history including:

  • Outstanding accounts receivable balances
  • Historical bills and trust requests
  • Bill and trust payments
  • Billable rates (e.g. user rate, client rate, matter rate)
Matters Documents
Calendars Reports
Tasks User permissions

 

Step 1: Consultation
You will speak with a member of our team to discuss what your data migration will look like. This includes what can be exported from your current practice management software, any limitations in the exported data, timelines for data processing, and what to expect once that data has been imported into Clio.
Step 2: Data export
Our team can help you to export the data from your previous practice management program so that it can be processed into a form that can be imported into Clio. We can also provide some instructions on how to export your information for some popular programs. If you export the information yourself, it will eliminate the need for an export appointment and will likely speed up the migration process.
Step 3: Data processing
Our experts will convert your data exports into a format that can be imported into Clio. Depending on the size and complexity of the data set, the time required to process the data can vary. A member of our team will be in regular contact throughout the migration process to make sure that we are setting and meeting reasonable expectations.
Step 4: Data import
After the data is processed, we will work with you to import the data to your Clio account. Once the import has been completed, you will have three business days to review the data in your account to assess its accuracy and let us know if any corrections need to be made. If you modify the imported data in your account in the interim, data may be lost if the import needs to be reverted.

 

Prepare your data for migration

Clio's Migrations team will not clean your data or remove duplicate data. Before sending your data to the Clio Migrations team, review your data. If the data was wrongly entered in the previous system, it will appear in Clio in that format. This list details key areas you should look for in your data.

Contacts: Verify that the proper data is in the right column. For example, phone numbers should not be in an email address field. Include the following fields:

  • First Name
  • Last Name
  • Company Name

 

Matters: The Matter Description should not be blank, otherwise your matter will be assigned a description during the import. Matters should have an assigned client, otherwise matters will be assigned to an unknown client during the import process. Include the following fields:

  • Matter Status (Open, Pending, Closed)
  • Matter Custom Number
  • Matter Description
  • Client

 

Activities: Time entries need an assigned user, otherwise they will not import. If you would like to import data for a user that will not be added to the Clio account, your Migrations representative can help you with this. Include the following fields:

  • Date
  • Quantity
  • Rate
  • User

 

Calendar events: We highly recommend making sure that your events have exported correctly by picking four or five events in the past and in the future to make sure court dates and scheduled meetings are all included. Include the following fields:

  • Calendar Summary
  • Start Date
  • Start Time
  • End Date
  • End Time
  • Destination/ User Calendar. 

 

Contact notes: Contact notes will not import without a contact or company name. Include the following fields:

  • Date
  • Subject
  • Note Description

 

Matter notes: Matter notes will not import without a matter number. Include the following fields:

  • Date
  • Subject
  • Note Description

 

Related contacts: Each related contact requires a matter. Include the following fields:

  • Matter
  • First Name
  • Last Name
  • Company Name

 

Tasks: Tasks must have an assigned user. If your tasks do not have an assigned user, you can choose to remove them from the data set. You can also confirm this with your Migrations representative and they can remove this information for you. Include the following fields:

  • Status (Pending, In-Progress, Complete)
  • Task Name
  • Due Date
  • Assigned User

 

Balances forward (outstanding balances): It is very important to make sure that you review the balances that were exported from your previous system to make sure they are the correct value. If there are multiple columns with outstanding amounts, identify which amount is to be imported and inform your Migrations representative. Include the following fields:

  • Balance
  • User
  • Date

 

Manage your firm data during migration

Once your export is scheduled with a Clio data migrations specialist, set a cut-off time for your firm. Any data added to your previous software after the export session will not be migrated to Clio and will need to be manually transferred after the migration has been completed. Additionally, you can follow the steps below to manage your firm during data migration transition period.

Step 1: Close out your data in your old software:

  1. Generate bills for any outstanding time and expense entries in your previous software to obtain the most up-to-date outstanding balances for your clients.
  2. Apply credits and trust payments to outstanding bills in your previous software. Credits and trust balances will not be migrated. 
  3. Export historical banking and trust reports that you want to back up in Clio.

 

Step 2: Manage your firm data during the transition period:

  1. Do not turn on contact or calendar syncs until after the migration has been completed in order to reduce the possibility of duplicate contacts being created. 
  2. Add new clients, matters, time entries, and all other data in Clio.
  3. Track activities for your historical clients in one of two ways:
    • Placeholder matter: This is a temporary matter that you can add time to while waiting for a data migration to complete. Once the migration has been complete, and you have confirmed that the data is free of errors, an administrator can move the time entries in bulk from the placeholder matter to the respective matters. 
      1. Create a new company contact with your firm's name.
      2. Create a new matter for this contact. Enter "Placeholder—Migrations" for the matter's Description. 
      3. Add time entries and use the Description field to specify which matter the time entry belongs to.
      4. Repeat step 3 for all time entries incurred during the data migration process.
      5. Once migration has been completed, move the time entries in bulk to their respective matters.
    • Import templates: Use Clio's migration import templates to track activities and matter notes. Your data migrations specialist will upload this spreadsheet data into Clio and link the time and expense entries and matter notes to their respective matters. 
  4. Upload reports that you exported from your previous system into Clio under the Documents tab. You can create a folder called "Historical data" for future reference. Learn more about creating folders and uploading documents here.
  5. Get started with Clio's Quick Start training webinars.

 

Step 3: Manage your data after migration:

  1. Review your imported data for accuracy within three business days of the import's completion.
  2. Add deposits to client trust accounts.
  3. Upload the data from the transition period that you tracked to either a placeholder matter or for which you used import templates.

 

Export your data from Clio

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, consult with your Clio representative before proceeding. Follow the steps below to export your data from Clio and prepare it for importing back into Clio.

Note: Only users with administrator permissions can export data in bulk for migration.

Important: Exporting from any practice management software other than Clio depends entirely on what program you currently use. Data that cannot be exported from the original source in CSV format cannot be imported into Clio. See the appropriate alphabetical section of one of the Migration Capabilities articles for steps on how to export data from the practice management software that you were using.
  1. Log in to Clio Manage.
  2. Go to the exports page.
    • For North American accounts, click here.
    • For Canadian accounts, click here(if this link does not work for you, try the North American link above).
    • For European and UK accounts, click here.
    • For Australian accounts, click here.
  3. Click Excel ready CSV next to the following:
    • Calendar Entries
    • Communications
    • Contact Notes
    • Contact Related Matters
    • Contacts
    • Expense Entries
    • Matter Notes
    • Matters
    • Tasks
    • Time Entries
  4. For outstanding balances, you will need to download the accounts receivable report.
    • Go to Reports > Reports > Accounts receivable.
    • Change the Output Format to CSV.
    • Click Generate Report.

 

Review migration import errors

  1. Go to Clio Importer.
  2. Click the underlined errors.
  3. Change the file that downloads to a .CSV file and open the file in excel.
  4. Read the errors in the left hand side column. 

 

Need more help?

Was this article helpful?
0 out of 0 found this helpful