How to Migrate a Trust Accounting System

Unlike dealing with your firm’s operating accounts, trust bookkeeping involves additional fiduciary responsibility. You’ll need a trust accounting system to help you do the job and a strategy to switch from one system to another.

Choose a System That Puts You in Control

The first order of business is choosing a trust accounting system that meets regulatory requirements and puts you in control. If your firm is using manual bookkeeping, you know the inherent problems. Manual processes are time-consuming, mistakes are difficult to detect and report preparation is next to impossible.

On the other hand, a good trust accounting software program can easily replace all manual bookkeeping tasks, bringing order to your books, tightening controls and helping you comply with state regulations. Trust accounting software that is integrated with law firm billing software allows these dependent systems to work together. A cloud-based solution gives you access to your trust records from anywhere, a valuable feature for keeping records up to date and providing documentation to an auditor.

Evaluate Trust Account Migration Options

Once you have selected the best attorney trust accounting software to manage your trust accounts, it is important to review migration options with your accountant to determine which method is best for your firm. Cloud-based software makes it easy for your accountant to review the new trust management system and ensure it meets state requirements.

Three methods for transferring trust accounts from one bookkeeping system to another are:

Square One Option: Start from scratch and re-enter all trust data in the new software database. If your data was previously entered manually and is not well organized, option one may be the best choice. Once data is entered, the new software can provide a clear picture of both your past and future account transactions.

Fresh Start Option: If you anticipate significant problems entering past transactions and are in a catch-22 situation, meaning until past data is cleaned up future transactions cannot be entered in the new program, you may consider opening a brand new trust account at the same bank or a different bank. You can get a fresh start by using the new bank account and new software. In many instances, this method turns out to be the simplest solution. In a few weeks, once activities in your previous bank account have died down, you can then reconcile the old account and close it permanently. If there are un-disbursed ledger card balances left in the old account, write a check for each ledger card, move balances to the new bank account, and make deposits in the new software.

Minimal Change Option: Use this option if you want to keep the same bank account, want to start doing bookkeeping with the new software, and do not want to re-enter all prior transactions. Follow these steps carefully for this scenario:

Step 1: Fix a month ending date to establish a cut-off from old bookkeeping system to the new one, i.e. April 30, 2014 (“reconciliation date”).

Step 2: Reconcile your previous trust account books up to the reconciliation date and create a ledger card “bank” balance sheet, which shows totals of the actual money for each ledger card in the bank as of the reconciliation date. Total of these ledger card “bank” balances must match with the bank ending balance. Also, create a ledger card “book” balance sheet, which will show totals per your record, and will include transactions that have not yet cleared the bank.

Step 3: Create corresponding ledger cards in the new software, which can be done in one of two ways.

  • Create a positive amount adjustment entry with a memo ‘transfer balance from previous books’ for the ledger card “bank” balance as of the reconciliation date. Then, enter all un-cleared transactions on the corresponding ledger cards (transactions of the ledger card which have not cleared from the bank yet such as outstanding checks or deposits). The total of adjustment entry and all un-cleared transactions must match the total corresponding ledger card “book” balance.
  • Enter all ledger card transactions (regardless of whether these transactions have cleared or not by the reconciliation date) only for cards that have balance left. The transaction total must match the total of the corresponding ledger card “book” balance.

Step 4: All future transactions and bank reconciliation after the final old system reconciliation date must be done only in the new system.

Trust Account Management You Can Count On

Migrating client trust accounts from a manual to an automated bookkeeping system is not a difficult process, especially with the flexibility and mobility of a cloud-based solution. In a few simple steps, you can bring order to your trust accounting system, tighten controls and strengthen state regulation compliance. And, even if you are suddenly facing an audit, with well-managed trust accounts, you’ll be ready.

About Us: CosmoLex is a leader in cloud-based software for lawyers. Our CEO, Dr. Rick Kabra, has worked for many years in the legal software industry, catering to the specialized technology needs of small to medium law firms. Learn more about our law office management software by emailing or calling (866) 878-6798.

– CosmoLex connects with the tools you know and love –