Trust Uncleared Funds Report

14/07/2025
Knowledge

How To

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

Purpose: The report lists Trust cheque receipts that have been 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 receipts as well as managing and projecting Trust account cash flow.

Click to edit heading

Report Trigger:

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

1. Payment Type:

The Trust receipt 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 receipt. Instructions for creating a Trust bank deposit are available here.

3. Cheque Status:

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

1) Opening the Trust receipt.

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 Number
- 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 receipt's Transaction Date.
Reference Number	Reference number of the receipt.
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 receipt.
BSB No.	The BSB Number entered in the 'Payment Type Details' window when creating a Trust receipt.
Account No.	The Account Number entered in the 'Payment Type Details' window when creating a Trust receipt.
Bank Deposit No.	The 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.