Skip to main content

Trust Account Data Migration for QuickBooks Online

TJ Fraser avatar
Written by TJ Fraser
Updated today

Practice Pro (formerly ZenCase) creates a sub-liability account for every client for its trust accounts (under the account “zencase-client trust liability”). For this reason, it is important not to use journal entries to create a starting balance for trust accounts. Rather, Practice Pro (formerly ZenCase) should populate all of the historic information for a trust account as part of a Data Migration.

The steps for performing a Data Migration for a trust account are:

  1. Contact your designated Practice Pro ) Data Migration Success Representative to have the attribute where the client/matter trust balance is zero at the time of the data migration set to "do not send in Practice Pro."

  2. After confirming that the "do not send Practice Pro" attribute has been set (see Step 1), contact your Practice Pro Data Migration Success Representative so that they can activate Practice Pro sending the trust account transaction information to QuickBooks Online for the trust accounts.

  3. After Practice Pro sends all of the trust account information to QuickBooks Online, confirm that the trust account balance in Practice Pro is the same as in the legacy system, and is the same in QuickBooks Online. We recommend exporting a detailed balance sheet showing each of the trust account balances from QuickBooks Online also exporting a spreadsheet showing the trust account balances from ZenCase to perform a comparison. Remember that clients who have multiple trust balances for multiple matters will be summed together so that all of the individual matters for that particular client will be reflected as one line item on the QuickBooks online balance sheet under the name of the client.

  4. If any of the trust account balances do not match between Practice Pro, QuickBooks Online and the legacy system, determine the root cause by performing a comparison of the client/matter trust balances referenced in step 4, above.

Also, remember to instruct the client that any information after the data export date will not be reflected in Practice Pro, so be sure that the data that you are using to compare Practice Pro, QuickBooks Online and the legacy system are for the same time period.

Did this answer your question?