Trust Cash Balance in the GL Does Not Match Client-Matter Trust Ledger

If you are attempting to balance to the Client-Matter Trust Ledger run through the last day of the month, there are several things you can check.

1.    If you are on a Cash basis, make sure there are no Open Vouchers on the Trust Account that are dated for the month you are balancing. The TAP and TDS transactions are created on the Client-Matter file and their Trust Balance would be reduced when the voucher is posted.  However, the General Ledger transactions are not created until you pay the Voucher.

2.    Check for any improperly dated trust activity (future dates).  You can do this by running the Client-Matter Trust Ledger report using “tomorrow’s” date through December 31, 2020.

3.    If none of the above show you the problem, the issue is most likely that you wrote a check on the trust account but did not use a TDS or TAP code.  The easiest way to check for this is to run a Check Register for the Trust Account and compare it to items listed in the AR Manager.  Set your AR Manager Filter for the month in question and the Bank Code in question.  Once the transactions are displayed, sort them by check number.  Compare the amounts to the Check Register.