Loading
Knowledge BaseClient Accounts Trial Balance Report
Close
Search for help articles, community posts, ideas ...
End of Search Dialog

Client Accounts Trial Balance Report

  • 18/12/2025
  • Knowledge

How To
Click to edit heading

Location: LEAP Menu > 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 DateDisplays 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 WithDisplays 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:

MatterThe matter number.
ClientThe matter's client.
Matter DescriptionThe description of the matter.
Last Trans. DateThe 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
18/12/2025 10:24 pm
Title
Client Accounts Trial Balance Report
URL Name
Client-Accounts-Trial-Balance-Report

Resolution
Reports
Loading
Client Accounts Trial Balance Report