Skip to main content
All CollectionsThinking about the Switch?Migrating from Other Software
How to Export Data from PCLaw for Migration to LeanLaw
How to Export Data from PCLaw for Migration to LeanLaw

This article will guide you through the steps for exporting your data from PCLaw to prepare for your switch to LeanLaw.

Jessica McCullough avatar
Written by Jessica McCullough
Updated over 6 months ago

Migrating data from PCLaw to LeanLaw involves several critical steps to ensure that all your important information is accurately and securely transferred. Following each step carefully is crucial to avoid data loss, maintain data integrity, and ensure a smooth transition. This guide outlines the process to export clients, matters, time entries, and some billing information from PCLaw to LeanLaw.

Select the option below for steps on exporting the PCLaw data by type:

Contacts

Note: If you need additional fields for contact or matters, check the box next to the fields.

  1. Go to File > Contact Manager.

  2. Click Export.

  3. Select Layout Name > All.

  4. Click Change.

  5. Select the Common tab and check boxes for all fields.

  6. Click the Other tab and check boxes for all fields.

  7. Click Ok.

  8. Under File Format select CSV.

  9. Under Output File select Browse and pick a destination for saving.

  10. Check the boxes for Contacts, Clients, and Vendors, and then click Export.

  11. Click Yes when asked to save changes.

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

  1. Click File > Matter > Export.

  2. Select Layout Name > Open Matt.

  3. Click Change.

  4. Select the Main tab and check boxes for all fields except Disable updates with other software.

  5. Select the Address tab and check boxes for all applicable fields.

  6. Select the Selections tab and check boxes for all fields under Court and File.

  7. Click OK.

  8. Under File Format select CSV.

  9. Under Output File select Browse and pick a destination for saving .

  10. Leave the Name field as Open Matt.

  11. Click Export.

  12. Click Yes when asked to save changes.

  13. Select Active Cases only.

  14. Click OK to start Export.

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

  1. Click File > Matter > Export.

  2. Select Layout Name > Open Matt.

  3. Click Change.

  4. Select the Main tab and check boxes for all fields except Disable updates with other software.

  5. Select the Address tab and check boxes for all applicable fields.

  6. Select the Selections tab and check boxes for all fields under Court and File.

  7. Click OK.

  8. Under File Format select CSV.

  9. Under Output File select Browse and pick a destination for saving .

  10. Leave the Name field as CloseMat .

  11. Click Export.

  12. Click Yes when asked to save changes.

  13. Select Inactive and/or Archived Cases only.

  14. Click OK to start Export.

  15. 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)

  1. Click Data Entry > Register.

  2. Select the Time tab.

  3. Check the box next to Filters and click Filters.

  4. Select Unbilled and click OK.

  5. Check that the date range is what you want and click select.

  6. Click the Excel button. Filename: Reg Time [date].xls

  7. Pick an accessible destination and click Save.

Unbilled Disbursements (Expense Entries)

  1. Click Reports > Client > Ledger.

  2. Click the Matters subtab or Advanced if the Matter tab is not visible.

  3. Complete the appropriate fields.

  4. Click the Common subtab, and select Adv. Search.

    • From the drop-down, under Field, select Invoice Number.

    • Under Comparison, select Is Blank.

  5. Click the Other subtab and only leave Disbs selected.

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

  7. Click export to Excel. Filename: Client Ledger.xls

  8. Pick an accessible destination and click Save.

Accounts Receivable (Outstanding Balances)

  1. Click Reports > Journal > Billing (Fees) Journal.

  2. On the Common subtab select an End Date.

  3. Uncheck the box for Include Paid Invoices.

  4. Optional: Filter by attorney.

  5. Click ok. The report will display on the screen.

  6. Review the report and once satisfied click export to Excel. Filename: Billing (Fee) Journal.xls

  7. Pick an accessible destination and click Save.

If you have any questions, please reach out to your onboarding specialist.

Did this answer your question?