Client Accounts Trial Balance Report

Apr 29, 2026
Knowledge

How To

Location: LEAP Menu > Accounting > Reports > Client Funds > Client Accounts Trial Balance

Purpose: Lists Client Account ledger account balances by matter as of a specified date for a selected bank account, with options to include matters based on balance or transaction history. The report also includes 'Total Client Ledger Accounts', 'Reconciled Cash Book' and 'Variance', at the conclusion. The Client Accounts Trial Balance Report lists all matters with funds held in Client Accounts and allows you to view a client account's combined balance across multiple matters.

Report Trigger: Users can choose to include either 'Matter with balances only' or 'Matter with balances and/or transactions'. The report excludes a matter which has a nil balance or no transaction entered under the selected bank account as of the specified 'At Date'.

Click to edit heading

1. The report generated is labeled as ‘Interim’ to be distinguished from the final report produced by the Account End of Month (EOM) process for the same account. The final report can be retrieved through the LEAP Menu > Reports > Client Funds > Client Accounts End of Month > View Previous EOMs. For guidance on executing the Account EOM procedure, please consult this article.

2. If your firm has designated a matter as the 'Client Funds Administration Matter' via LEAP Menu > Settings > Application Settings > Matters > Client Funds Administration Matter Number, please note that this matter is excluded from the report.

3. Each matter is displayed as a separate row, with the option to download the Client Account ledger at the end of the row.

Filters:

At Date	Displays Client Accounts balances by matter as of this selected date
Bank Account	Allows users to choose a Client Funds Bank Account to report on.
Matters With	Displays matters that meet one of the following two conditions: With balances only: The report only includes matters containing a balance up to the selected 'At Date'. With balances and/or transactions: The report includes matters that contain a balance as of the 'At Date' or transactions as of the 'At Date'.
Display	Includes two display options: Order By: Sorts the results by: Matter No. Client Last Name Group By: Groups the results by: None Staff Responsible Staff Acting

Report Fields:

Matter	The matter number.
Client	The matter's client.
Matter Description	The description of the matter.
Last Trans. Date	The transaction date of the last Client Funds transaction recorded on the matter as of the 'At Date'.
Amount	The matter's Client Account balance as of the 'At Date'.
Comparison	Located at the bottom of the report, displays: Total Client Ledger Accounts: The selected Client Funds Bank Account's total account balance as of the 'At Date'. Reconciled Cash Book: Reconciled Cash Book Balance as of the 'At Date'.

Last Modified Date

29/04/2026 3:49 AM

Title

Client Accounts Trial Balance Report

URL Name

Client-Accounts-Trial-Balance-Report-IE

Resolution