Trust Account Reporting

This section outlines the key reports DebtCol has to assist in managing your trust account.

Instructions on how to run reports can be found here.

TRUST MOVEMENT BY CLIENT (UN-REMITTED)

Found under report classification "Trust Accounting Reports", this report shows all cleared trust receipts awaiting payment. The report groups and sub-totals trust transactions by client. This report should always match the results in the trust liability screen where the only filter used is the bank account.

TRUST LIABILITY

The Trust Liability screen allows you to print a report of your liability at any point in time. After locating the data for your selected criteria, click "View Report". The report shows your cleared trust funds per client and calculated refund and transfer deductions. A copy of this report gets produced when committing to generate the refunds. It cannot be produced retrospectively, however the following two reports can.

TRUST REFUNDS POSTED

Found under report classification "Trust Accounting Reports", this report can be run for a specific date and will list all the refunds posted that day.

TRUST TRANSFERS POSTED

Found under report classification "Trust Accounting Reports", this report can be run for a specific date and will list all the transfers posted that day, which were used to deduct from charges.

TRUST REGISTER SCREEN

The Trust Register screen allows you to build your own criteria to display trust transactions. The results are displayed in the table on the screen. The user can right-mouse click on the tables heading row and choose to extract the data from the table and directly into Excel.

BANK RECONCILIATION REPORT

From the bank reconciliation screen, select a reconciled bank statement then click the "Report" button to view a reconciliation report.

TRUST TRIAL BALANCE REPORT

From the bank reconciliation screen, select a reconciled bank statement then click the "Report" button to view a trust trial balance report. The trust trial balance shows what the systems closing balance is for each client. This is calculated by the previous statement closing balance plus deposits and withdrawals found in this bank rec.