Trust Uncleared Funds Report

« Go Back

Information

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, check information, bank deposit date, and the number of days until the check is cleared. This report aids in tracking Trust check 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 Check (e.g., 'Personal Check'). 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. Check Status:

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

1) Opening the Trust payment.

2) Click User-added image and select Check 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.
Reference No.	Reference number of the payment.
Type	The type of check, such as Personal Check or Bank Check.
Drawer	The drawer entered in the 'Payment Type Details' window when creating a Trust Payment Received.
When Expand Row Groups set to Yes	Further displays matter information, including: Matter No. Client Matter Type
Routing Number	The Routing 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's reference number.
Bank Deposit Date	The relevant Bank Deposit's Transaction Date.
Days until cleared	The number of days until the check clears (Clearance Days). 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 Check – 5 Days • Other Check – 3 Days 2. When the 'Days until cleared' is 0, it indicates that the check clears today. If the value is negative, it indicates that the check has already been cleared based on the 'Clearance Days' settings. Once you manually mark the check as cleared, it will be removed from the report. 3. 'Days Until Cleared' does not take into account public or bank holidays.
Amount	Total paid amount to be cleared.