This article explains what data can be migrated from your current practice management software and how to export the data from that software. Software applications starting with the letters N, O, P, Q, R, and S are listed below.
Tip: See one of the articles below if your current practice management software does not start with the letters N, O, P, Q, R, and S.
Needles
- Contacts
- Matters
- Matter notes
Follow the steps below for contacts, matters, and matter notes. Alternatively, we can pull data from a full backup (Needles.db and Needles.log files) of the database.
Matters:
- Go to Reports and select Case Information.
- Click Case Listings.
- Select Party Name .
- Select Status. The report will appear in the product.
- Click the print button at the top of screen to print to PDF.
- Check Print to file.
- Select Print.
- Save under Excel with headings.
Contacts:
- Go to Reports and select Mailing Labels. The report will appear in the product.
- Click the print button at the top of screen to print to PDF.
- Check Print to file.
- Select Print.
- Save under Excel with headings.
Matter Notes:
- Go to Reports and selectCase Notes. The report will appear in the product
- Click the print button at the top of screen to print to PDF.
- Check Print to file.
- Select Print.
- Save under Excel with headings.
Orion
- Contacts
- Matters
Note: The exports will not format headers properly. You will need to export the client and matter listings in PDF format to manually adjust headers.
Contacts:
- Open Orion.
- On the left side panel, navigate to Desktop > Reports.
- Click Standard Reports > File Maintenance.
- To export contacts, choose Client Listing.
- Ensure that the Style selected is Details (system).
- Apply any filters under the Options section.
- Choose Export > Excel Data File. The file will be automatically open after exporting. An error may occur if there is no valid program installed.
Matters:
- Open Orion.
- On the left side panel, navigate to Desktop > Reports.
- Click Standard Reports > File Maintenance.
- To export contacts, choose Matter Listing.
- Ensure that the Style selected is Details (system).
- Apply any filters under the Options section.
- Choose Export > Excel Data File. The file will be automatically open after exporting. An error may occur if there is no valid program installed.
Osprey
- Contacts
- Matters
- Notes
Step 1: Contact Osprey to get access to your Osprey Database. They will send you three separate emails:
- The first will contain your Download URL and username to sign in to the backup site.
- The second will include you backup password to sign in to the Backup site.
- The third will include your encryption key to access your extracted database.
Step 2: Follow the steps in this article: Download your Osprey backup
Step 3: Follow these steps to access the data in your backup:
- Open SQL Server Management Studio Express and connect to the SQL server.
- Expand Databases.
- Right-click on the database you want to back up, and then select Tasks > Back up (this is not available for version 2018/2019).
- On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
- Select Full for the Backup Type.
- Click Remove to remove the default/last backup file name.
- Click Add to open the Select Backup Destination window.
- Click [...] next to the File Name field.
- On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
- In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
- Click OK to close the Locate Database Files window.
- Click OK to close the Select Backup Destination window.
- Click OK to start the backup. The progress icon displays in the lower-left corner, and a completed successfully message displays when it is done.
PCLaw
- Contacts
- Matters
- Unbilled time and expense entries
- Accounts receivable (outstanding balances)
- Appointments/to dos
- Trust balances
User list:
- Click Options > Lists > Lawyers and Rates.
- Select Include inactive users.
- Click Print. If you are prompted to send to the printer change the settings click File > Printer Setup > Report > Change the printer to Adobe PDF.
- Save the PDF file.
Practice area list:
- Click Options > Lists > Types of Law.
- Click Print. If you are prompted to send to the printer change the settings click File > Printer Setup > Report > Change the printer to Adobe PDF.
- Save the PDF file.
Contacts:
Note: If you need additional fields for contact or matters, check the box next to the fields. These fields will migrate to Clio as custom fields.
- Go to File > Contact Manager.
- Click Export.
- Select Layout Name > All.
- Click Change.
- Select the Common tab and check boxes for all fields.
- Click the Other tab and check boxes for all fields.
- Click Ok.
- Under File Format select CSV.
- Under Output File select Browse and pick a destination for saving.
- Check the boxes for Contacts, Clients, and Vendors, and then click Export.
- Click Yes when asked to save changes.
- Repeat steps 8 - 11 but select Word for Windows as the File Format. This will provide you with the headers for the CSV file.
Open matters:
Note: If you need additional fields for contact or matters, check the box next to the fields. These fields will migrate to Clio as custom fields.
- Click File > Matter > Export.
- Select Layout Name > Open Matt.
- Click Change.
- Select the Main tab and check boxes for all fields except Disable updates with other software.
- Select the Address tab and check boxes for all applicable fields.
- Select the Selections tab and check boxes for all fields under Court and File.
- Click OK.
- Under File Format select CSV.
- Under Output File select Browse and pick a destination for saving .
- Leave the Name field as Open Matt.
- Click Export.
- Click Yes when asked to save changes.
- Select Active Cases only.
- Click OK to start Export.
- Repeat steps 8 - 14 but select Word for Windows as the File Format. This will provide you with the headers for the CSV file.
Closed matters:
- Click File > Matter > Export.
- Select Layout Name > Open Matt.
- Click Change.
- Select the Main tab and check boxes for all fields except Disable updates with other software.
- Select the Address tab and check boxes for all applicable fields.
- Select the Selections tab and check boxes for all fields under Court and File.
- Click OK.
- Under File Format select CSV.
- Under Output File select Browse and pick a destination for saving .
- Leave the Name field as CloseMat .
- Click Export.
- Click Yes when asked to save changes.
- Select Inactive and/or Archived Cases only.
- Click OK to start Export.
- Repeat steps 8 - 14 but select Word for Windows as the File Format. This will provide you with the headers for the CSV file.
Unbilled fees (time entries):
- Click Data Entry > Register.
- Select the Time tab.
- Check the box next to Filters and click Filters.
- Select Unbilled and click OK.
- Check that the date range is what you want and click select.
- Click the Excel button. Filename: Reg Time [date].xls
- Pick an accessible destination and click Save.
Unbilled disbursements (expense entries):
- Click Reports > Client > Ledger.
- Click the Matters subtab or Advanced if the Matter tab is not visible.
- Complete the appropriate fields.
- Click the Common subtab, and select Adv. Search.
- From the drop-down, under Field, select Invoice Number.
- Under Comparison, select Is Blank.
- Click the Other subtab and only leave Disbs selected.
- Click OK, and the report will start displaying on the screen. Wait until the report is done. It will show Report Done in the bottom left.
- Click export to Excel. Filename: Client Ledger.xls
- Pick an accessible destination and click Save.
Accounts receivable (outstanding balances):
- Click Reports > Journal > Billing (Fees) Journal.
- On the Common subtab select an End Date.
- Uncheck the box for Include Paid Invoices.
- Optional: Filter by attorney.
- Click ok. The report will display on the screen.
- Review the report and once satisfied click export to Excel. Filename: Billing (Fee) Journal.xls
- Pick an accessible destination and click Save.
Appointments/To dos:
- Click Data Entry > Register.
- Select the Appointments tab.
- Check the box next to Filters and click Filters.
- Select the box next to Uncompleted.
- Check that the date range is what you want and click OK.
- Click the Excel button.
- Pick an accessible destination and click Save.
- Repeat steps 1 - 7 but select the Completed box in step 4.
Trust listings report (trust balances):
- Click Reports.
- Select Client and then Trust Listing.
- Leave the Matter, Client, Acct, and Resp Lawyer boxes blank to run the report for all matters.
- Enter 12/31/2199 in the End Date box to run the report for all dates.
- Check the Totals Only box to only show the client and firm totals, or uncheck the box to also show matter totals.
- Check the Firm Totals Only box to show only firm totals, or uncheck the box to show all matter, client, and firm totals.
- Check the Negative Balances Only box to show only matters with a negative trust balances, or uncheck the box to include all matters with a trust balances.
- Select Default from the Layout dropdown.
- Select Output options.
- Use the Matters and Other tabs to select additional report options.
- Click Advanced at the bottom of the Client Trust Listing window if the Matters or Other tabs are missing.
- Click OK to generate the report.
Perfect Practice
- Contacts
- Matters
Contacts:
- Go to Reports and double-click Parties.
- Click Export in the toolbar and save as CSV.
Matters:
- Go to Reports and double-click Parties.
- Click Export in the toolbar and save as CSV.
PerfectLaw
- Calendar events
- Contacts
- Matters
- Phone logs
- Related contacts
- Unbilled time and expense activities
- Open SQL Server Management Studio Express and connect to the SQL server.
- Expand Databases.
- Right-click on the database you want to back up, and then select Tasks > Back up (this is not available for version 2018/2019).
- On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
- Select Full for the Backup Type.
- Click Remove to remove the default/last backup file name.
- Click Add to open the Select Backup Destination window.
- Click [...] next to the File Name field.
- On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
- In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
- Click OK to close the Locate Database Files window.
- Click OK to close the Select Backup Destination window.
- Click OK to start the backup. The progress icon displays in the lower-left corner, and a completed successfully message displays when it is done.
Pika
- Contacts
- Contact notes
- Matters
- Matter notes
- Open SQL Server Management Studio Express and connect to the SQL server.
- Expand Databases.
- Right-click on the database you want to back up, and then select Tasks > Back up (this is not available for version 2018/2019).
- On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
- Select Full for the Backup Type.
- Click Remove to remove the default/last backup file name.
- Click Add to open the Select Backup Destination window.
- Click [...] next to the File Name field.
- On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
- In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
- Click OK to close the Locate Database Files window.
- Click OK to close the Select Backup Destination window.
- Click OK to start the backup. The progress icon displays in the lower-left corner, and a completed successfully message displays when it is done.
PracticePanther
- Contacts
- Matters
- Unbilled time and expense entries
- Tasks
- Contact notes
- Matter notes
- Phone/call logs
- Email communications
- Calendar entries
- Trust balances
Note: Only administrators can export client data.
Step 1: Update your PracticePanther settings as follows:
- Click your Name in the top right and select Settings.
- Select Company Settings on the left side.
- Under Display Name set the Contact to First M Last.
- Update Matter to Number-MatterName.
- Update Users to First M Last.
- Click Save.
Step 2: Export data. See sections below for specifics.
Important: Once the data listed below is exported to Excel files, all of the files will export with the same name since they all come from the Activities section. In order to differentiate each exported file, change each file's name to a name relevant to the data within the file. For example, after exporting tasks, you can rename the Excel file to "Tasks."
Contacts:
- Click Contacts in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Primary Contacts
- Assigned To: Any User
- Created Date: All Time
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
Matters:
- Click Matters in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Assigned To: Any User
- Originated By: Any User
- Status: Any
- Created Date: All Time
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
Time entries:
- Click Time Entries in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Billed By: Any User
- Status: Any
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Time Entries.
Expense entries:
- Click Expense in the menu bar at the top of your screen. Or, find Expense under the More dropdown.
-
Set the filters at the top to:
- Billed By: Any User
- Status: Any
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Expenses.
Tasks:
- Click Activities in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Tasks
- Status: Any
- Assigned To: Any User
- Created By: Any User
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Tasks.
Notes:
- Click Activities in the menu bar at the top of your screen
-
Set the filters at the top to:
- Notes
- Status: Any
- Assigned To: Any User
- Created By: Any User
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Notes.
Phone/call logs:
- Click Activities in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Calls
- Status: Any
- Assigned To: Any User
- Created By: Any User
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Call logs.
Emails:
- Click Activities in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Emails
- Status: Any
- Assigned To: Any User
- Created By: Any User
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Emails.
Calendar events:
- Click Activities in the menu bar at the top of your screen.
-
Set the filters at the top to:
- Events
- Status: Any
- Assigned To: Any User
- Created By: Any User
- Date Range: All Time
- Click Choose Columns and check ALL column checkboxes.
-
Click Export to Excel on the top right section and select Export All.
- This button is generally located next to Choose Columns on the far right (look for the page icon with the small x).
- Rename the downloaded file to Calendar.
Trust balances:
- Go to Reports > Payments > Trust Account Reconciliation Report.
- Click Export to Excel.
Prevail
- Contacts
- Matters
- Sign in to Prevail.
- Open the Administration menu. For some versions, go to File > Export.
- Select Export Contacts.
- Select a location to save the export file and name the file.
Note: If these instructions are not applicable or do not work, contact Prevail for a backup of your data.
ProDocs
- Contacts
- Matters
If your firm has access to ProDoc Small Office Suite, Clio can bring this additional information:
- Unbilled time and expense entries
- Click Tools and then select Export.
- Select Contacts.
- Check the box at the top to include Closed Cases/Contacts.
- Click Select All.
- Click OK.
- Check the box for Include Header Information and then include all categories.
- Save the file.
- Repeat the steps above for cases (matters).
ProDoc Small Office Suite:
- Click Tools and then select Export Data.
- Select Export Charges for unbilled time and expenses.
ProLaw
- Contacts
- Matters
Note: Depending on the quality of your data, we may also be able to migrate your calendar, tasks, related contacts, contact and matter notes, and unbilled time and expense entries.
- Open SQL Server Management Studio Express and connect to the SQL server.
- Expand Databases.
- Right-click on the database you want to back up, and then select Tasks > Back up (this is not available for version 2018/2019).
- On the Back Up Database window, make sure the Database field contains the name of the database you want to back up.
- Select Full for the Backup Type.
- Click Remove to remove the default/last backup file name.
- Click Add to open the Select Backup Destination window.
- Click [...] next to the File Name field.
- On the Locate Database Files window, select the folder where you want the backup file to go. By default, it is ..\Microsoft SQL Server\MSSQL.1\MSSQL\Backup.
- In the File Name field, type the name for this backup, with a .bak extension. For example, xyz_20080221.bak for a backup of the XYZ database created on 21 February 2008.
- Click OK to close the Locate Database Files window.
- Click OK to close the Select Backup Destination window.
- Click OK to start the backup. The progress icon displays in the lower-left corner, and a completed successfully message displays when it is done.
QuickBooks Desktop
- Contacts
- Matters (derived from contacts or projects)
- Outstanding balances
- Navigate to the top of QuickBooks Desktop screen to find tabs for Customer List, Vendor List, and Financial data.
- Click the customers tab or vendors tab you want to export.
- Click the Excel dropdown arrow.
- Select Export Customer List or Export Vendor List.
- In the export window, choose whether to create a new worksheet, update an existing worksheet, or export to a CSV file.
- Click Export.
QuickBooks Online
- Contacts
- Matters (derived from contacts or projects)
- Outstanding balance
Contacts:
- Select Reports.
- Scroll down the page to find the Customer Contact List report (it may also be named Client Contact List).
- Click Customize and ensure the Deleted state is set to All in order to capture all contacts.
- Click the gear icon to customize the columns included in the report.
- Check Client, First Name, Last Name, and the billing/shipping Street, City, State, ZIP, and Country. The Client column will be used to generate the matters.
- Select additional columns as needed.
- Deselect the columns you do not need (e.g. Full Name).
- Expand the Header/Footer section and uncheck Company Name and Report Title
- Click Run Report.
- Select the icon that looks like a sheet of paper with an arrow.
- Select Export to Excel.
Accounts receivable:
- Click Reports.
- Select the Standard subtab.
- Choose Accounts Receivable Aging summary.
- Select 30 days for 3 periods.
- Click Run Report.
- Click the icon that shows a square with an arrow pointing upward.
- Select Excel for file format.
QuickBooks Professional Services
- Contacts
- Matters derived from contacts
- Outstanding balances
- Click Reports at the top of the screen and then select Customers and Receivables.
- Select Customer Contacts List to show the contacts list and receivables.
- Optional: Customize the report by adding other columns in the top left.
- Click Export.
- Select CSV file for the output file format.
Rocket Matter
- Contacts
- Matters (includes matter name, matter client, open/closed status, and open date)
- Unbilled time and expense entries
- Matter related contacts
- Trust balances (at client level)
- Outstanding balances (use the "Current Balance" column in the exported matters file. This is a matter level value and not invoice specific)
Contacts:
- Log in to Rocket Matter.
- Select Settings in the left navigation bar.
- Under Data, click Export Contacts.
- Choose a location to save the file.
- Click Save.
Matters:
- Log in to Rocket Matter.
- Select Matters on the left sidebar.
- Select Filters to include Open, Completed, and Closed cases.
- Select the Show/Hide Columns button and check all boxes.
- Select Export Report.
Activities (unbilled time and expense entries):
- Log in to Rocket Matter.
- Select Reports on the left sidebar.
- Click Run Report under Billable Activity by User(s).
- Select Edit Filters and do the following:
- Choose the Date Range of the exported activities.
- Add All Users.
- Exclude Invoiced status. Failure to do this step may slow down the migration.
- Include all Activity types.
- Include Expenses.
- Select Export Report.
Matter related contacts:
- Log in to Rocket Matter.
- Select Reports on the left sidebar.
- Click Run Report under I Want To See All Matter Related Contacts.
- Select Export Report.
Trust balances:
- Log in to Rocket Matter.
- Select Trust on the left sidebar.
- Click Run Report at the top right.
- Click Export.
Outstanding balances:
No additional extraction is required. Use the "Current Balance" column from the matters export for the outstanding balances.
RTG Bills
- Contacts (very limited)
- Matters (very limited)
- Unbilled time and expense entries
Contacts:
- Provide the Microsoft Access Database to the Clio representative. You can get the copy in the RTG Bills folder.
- Navigate to the Supervisor Menu.
- Under the Links heading, click on RTG Bills Menu.
- Click Reports and then select Standard Reports.
- Select Export to File, and then select Client List (No Hidden Clients) (CSV Format) from the options.
- On the next screen, select One Client and then delete the client number and name listed in the text boxes. Re-select All Clients.
- On the next screen, Download the report.
Matters:
- Provide the Microsoft Access Database to the Clio representative. You can get the copy in the RTG Bills folder.
- Navigate to the Supervisor Menu.
- Under the Links heading, click on RTG Bills Menu.
- Click Reports and then select Standard Reports.
- Select Export to File, and then select Matters by Practice Area (CSV) from the options.
- On the next screen, select One Client and then delete the client number and name listed in the text boxes. Re-select All Clients.
- On the next screen, Download the report.
Unbilled activities (time and expense entries):
- Provide the Microsoft Access Database to the Clio representative. You can get the copy in the RTG Bills folder.
- Navigate to the Supervisor Menu.
- Under the Links heading, click on RTG Bills Menu.
- Click Reports and then select Standard Reports.
- Select Export to File, and then select Fees & Expenses (CSV Format) from the options.
- On the next screen, select One Client and then delete the client number and name listed in the text boxes. Re-select All Clients.
- On the next screen, Download the report.
Sales Nexis
- Contacts
- Contact Sales Nexis to request an export.
Salesforce
What:
- Contacts
Smokeball
- Contacts
- Matters
Note: Depending on the quality of the data, we may also be able to migrate incomplete tasks. Tasks without a due date will need to be assigned a due date before bringing them into Clio. Additionally, while we cannot migrate calendar events, you might be able to bring these events to Clio using the calendar sync functions in Smokeball and Clio:
Contacts:
- Go to the Contacts tab on the left side.
- Hover over the column headers and right-click on any of the columns and check all of the boxes.
- Click Export at the top of the page.
- Choose the desired save location and click Save to complete the export.
Matters:
- Go to the Matters tab on the left side.
- Hover over the column headers and right-click on any of the columns and check all of the boxes.
- Click Export at the top of the page.
- Choose the desired save location and click Save to complete the export.
Tasks:
- Go to the Tasks tab on the left side.
- In the top left of the screen, click a user's name dropdown and select All Staff.
- Hover over the column headers and right-click on any of the columns and check all of the boxes.
- Click Export at the top of the page.
- Choose the desired save location and click Save to complete the export.
Soluno
- Contacts
- Matters
- Unbilled time and expense entries
- Outstanding balances (accounts receivables)
Contacts and matters:
- Go to Views and Reports > Contact > Contacts.
- Click the V in the top left.
- Enter All in the search bar and select the relevant option.
- Click Play in the bottom left.
- Click Export to Excel in the top right.
Vendors:
- Go to Views and Reports > Contact > Contacts.
- Click the V in the top left.
- Enter Vendors in the search bar and select the relevant option.
- Click Play in the bottom left.
- Click Export to Excel in the top right.
Other contacts:
- Go to Views and Reports > Contact > Contacts.
- Click the V in the top left.
- Enter Other in the search bar and select the relevant option.
- Click Play in the bottom left.
- Click Export to Excel in the top right.
Time entries:
- Go to Views and Reports > Contact > Ledgers.
- Click the V in the top left.
- Enter Time in the search bar and select the relevant option.
- Scroll down to Show Files and set Unbilled charges greater than or equal to to 0.01.
- Scroll down to Entries and under Include Billed/Unbilled, change the value to Unbilled.
- Check that Fees is turned on.
- Click Play in the bottom left.
- Click Export to Excel in the top right.
Expense entries:
- Go to Views and Reports > Contact > Ledgers.
- Click the V in the top left.
- Enter Expense in the search bar and select the relevant option.
- Scroll down to Show Files and set Unbilled charges greater than or equal to to 0.01.
- Scroll down to Entries and under Include Billed/Unbilled, change the value to Unbilled.
- Check that Fees, Hard Exp, and Soft Exp are turned on.
- Click Play in the bottom left.
- Click Export to Excel in the top right.
Outstanding balances (accounts receivables)
- Go to Views and Reports > Contact > Ledgers.
- Click the V in the top left.
- Enter Summary in the search bar and select the relevant option.
- Click Play in the bottom left.
- Click Export to Excel in the top right.