Trust Uncleared Funds Report

16/07/2025
Knowledge

How To

Location: LEAP Menu > Reports > Trust > Trust Uncleared Funds

Purpose: The report lists Trust payments that have been received, banked but not yet cleared, providing details such as the amount, cheque information, bank deposit date, and the number of days until the cheque is cleared. This report aids in tracking Trust cheque payments received as well as managing and projecting Trust account cash flow.

Click to edit heading

Report Trigger:

To be included in the report, a Trust payment must meet the following three conditions:

1. Payment Type:

The Trust payment must have a Payment Type of Cheque (e.g., 'Personal Cheque'). Payment Type settings can be found under: Settings > Application Settings > Accounting > Payment Types.

2. Trust Bank Deposit:

A Trust bank deposit must have been created for the Trust payment. Instructions for creating a Trust bank deposit are available here.

3. Cheque Status:

The Cheque associated with the Trust payment must NOT have been marked as cleared. When users manually mark the Cheque as cleared upon verifying the relevant Trust bank account, the Trust payment/cheque will no longer be incuded in the report. To mark a Trust cheque as cleared, follow the steps below:

1) Opening the Trust payment.

2) Click User-added image and select Cheque Cleared.

3) Click Save & Close.

Report Filters:

Bank Account Name

Allows users to tailor the report by selecting a specific Trust Account to focus on.

Display

Includes two display options:

Group By: Groups the report by:
- Matter
- None
Expand Row Groups:

No – The report does not display the relevant client and matter information.
Yes – Expands the report to show the relevant client and matter information.

Report Fields:

Date	The Trust payment's Transaction Date.
Payment Number	Reference number of the payment.
Type	The type of cheque, such as Personal Cheque or Bank Cheque.
Drawer	The drawer entered in the 'Payment Type Details' window when creating a Trust payment.
When Expand Row Groups set to Yes	Further displays matter information, including: Matter No. Client Matter Type
Transit Number	The Transit Number entered in the 'Payment Type Details' window when creating a Trust payment.
Account Number	The Account Number entered in the 'Payment Type Details' window when creating a Trust payment.
Bank Deposit Number	The relevant Bank Deposit reference number.
Bank Deposit Date	The Bank Deposit's transaction date. NOTE: This is based on the 'Transaction Date' entered in the 'New Trust Bank Desposit' window, when creating a new Trust bank deposit.
Days until cleared	The number of days until the cheque clears. NOTE: 1. The 'Days Until Cleared' is calculated based on the 'Clearance Days' for a specific cheque Payment Type, set under the Settings > Application Settings > Accounting > Payment Types. eg., Default Clearance Days: • Bank Cheque – 5 Days • Other Cheque – 3 Days 2. When the 'Days until cleared' is 0, it indicates that the cheque clears today. If the value is negative, it indicates that the cheque has already been cleared based on the 'Clearance Days' settings. Once you manually mark the cheque as cleared upon verifying the relevant Trust bank account, it will be removed from the report. 3. The 'Days Until Cleared' does not take into account public or bank holidays.
Amount	Total paid amount to be cleared.