Skip to main content
All CollectionsGetting StartedImport From Another System
Import Legacy Billing Records Into ZenCase
Import Legacy Billing Records Into ZenCase

How To Import Legacy Billing Records From Another System Into ZenCase

Christine Clark avatar
Written by Christine Clark
Updated over 5 months ago

Overview

You can choose to import client and matter ledgers from another system into ZenCase during data migration phase only. A ZenCase staff member will enable your data migration permissions and once Go Live is completed, the data migration permission will be removed.

Full Billing Migration Versus WIP Billing Migration

There are two approaches you can take with migration the billing data from another system into ZenCase:

  • Full Billing Migration: Migrate the entire billing data as actual invoices, charges, payments, and payment allocations from another system into ZenCase which will allow users to work with old invoices and payments. This approach will require verification of ALL of the billing data to ensure the legacy data is accurate and correct before import. We also recommend verifying the ZenCase A/R matches the other system's A/R. This migration can be completed in approximately 3-6 months depending on the amount of data to migrate and the accuracy of the data.

  • WIP Billing Migration: Migrate only the WIP (unsettled invoices and payments) billing data as actual invoices, charges, payments, and payment allocations from another system into ZenCase which will allow users to work with only unsettled invoices and payments. All settled invoices and payments will be imported into a legacy billing records table as-is and can be viewed for reference. This approach will require verification of only the WIP data to ensure the legacy data is accurate and correct before import. We also recommend verifying the ZenCase A/R matches the other system's A/R. This migration can be completed in approximately 1-3 months depending on the amount of data to migrate and the accuracy of the data.

We fully recommend the WIP Billing Migration which will provide the user with their legacy billing data for reference so they can focus on working with unsettled invoices and payments going forward.

The following guides below will walk you through how to perform a WIP Billing Migration.

Import Settled Invoices In Client and Matter Ledgers

All settled invoices and payments should be imported into your client and matter ledgers. We recommend unbilled or unsettled invoices and payments (WIP data) to be imported individually using the invoices, charges, payments, and payment allocations CSV importers.

Please refer to the following guides to import client and matter ledgers:

Import Legacy Billing Records

All settled invoices and payments should be imported into the Legacy Billing Records table so that you always have a reference of the past settled billing data.

You can use our CSV template file to ensure you format your CSV correctly.
Download Legacy Billing Records Template

Fields that can be imported:

The legacy billing records template is unique in that it only requires a few columns with values and any additional columns that are added to the CSV file will automatically be added to the table as new columns.

Field Name

Data Type

Required

Import Rules

Record Type

string

Required

Options: AR, Fee, Expense, Invoice, Payment, Payment Allocation, Credit Memo, Trust

Number

number or string

Required

This is the record number which supports a string value.

For example, if you are importing invoices, this would represent the invoice number.

Client Number

number or string

Required

Client must exist in ZenCase in the Contacts table.

Matter Number

number or string

Matter must exist in ZenCase in the Matters table.

Member Number

number

Member must exist in ZenCase in the Members table.

Task Number

number

Task must exist in ZenCase in the Tasks table.

Date

date string

Required

The date of the record transaction.

For example, if you are importing invoices, this may represent the invoice date.

Format: MM/DD/YYYY or MM/DD/YY or MM-DD-YYYY or MM-DD-YY.
Example: 05/01/2020 or 05-01-20 for May 1, 2020.

Amount

number or string

Required

The amount of the record which supports both negative and positive values.

Invoice Number

number or string

Required for Payment Allocations

Recommended to set invoice number for Fees and Expenses.

Payment Number

number or string

Required for Payment Allocations

Actual Hours

number or string

Recommended to set invoice number for Fees and Quantity Rate Expenses.

Adjusted Hours

number or string

Recommended to set invoice number for Fees and Quantity Rate Expenses.

Bill Rate

number or string

Recommended to set invoice number for Fees and Quantity Rate Expenses.

Description

string

Status

string

External Link

string

  • Additional Columns:

    • You can add any additional columns in the CSV file and they will be imported as-is raw into the legacy billing table. For example, if you are importing invoices, you can add a new column for “Legacy Invoice Number” in the CSV file, and this will automatically be created and imported into the legacy billing table for Invoices as a new column in the table.


Upload Your CSV File

Once you have your CSV file filled out, you can then upload your CSV from ZenCase:

  • Go to Firm Settings > System > Legacy Billing page

    • Note: A ZenCase staff member will need to enable your data migrations permissions to be able to import into this table

  • Click the "Import Legacy Billing Records From CSV" button

  • Choose the CSV file you want to upload

  • Click "Save"

  • Once your import is complete, you will receive an email letting you know whether your import has successfully been imported or if there are any failures.

Import WIP Billing Data

After you have imported all of your settled billing data, you can now import the WIP billing data into the invoices, charges, payment, and payment allocations CSV importers.

Once all of the data has been imported, you can view the client and matter A/R reports from the Reports page in ZenCase. We recommend you verify the A/R reports from another system with ZenCase to verify accuracy of your import.

Let us know if you have any questions!

Did this answer your question?