Loading
Knowledge BaseTrust Trial Balance by Client Report
Close
Search for help articles, community posts, ideas ...
End of Search Dialog

Trust Trial Balance by Client Report

  • Apr 29, 2026
  • Knowledge

How To
Click to edit heading

Location: LEAP Menu > Accounting > Reports > Trust > Trust Trial Balance by Client

Purpose: Lists Trust ledger account balances by clients as of a specified date for a selected Trust Bank Account, with options to include clients based on relevant balance or transaction history. It is useful in monitoring clients with funds in trust.

Fields:

At DateDisplays matters based on other filters at the selected date.
Bank AccountA list of general Trust Bank Accounts. The report will display transactions for the selected Trust Account.
Clients withDisplays the following:
  • With balances only: Containing a Balance at the selected ‘To Date’.
  • With balances and/or transactions: Containing either a transaction or a balance at the selected ‘To Date’.
Expand Row Groups: 

Provides an option to expand or collapse row groups. 

  • No: Collapse row groups, listing only Clients and their respective trust ledger account balance. 
  • Yes: Expand row groups, further including Matter No, Matter Description and Last Transaction Date.


Report Fields:

NOTE: Matter No, Matter Description and Last Transaction Date are displayed when Expand Row Groups is set to Yes. 

ClientList client names. 
Matter No. Matters which meet the filtering criteria containing a Trust balance or transaction.
Matter Description  The description of the matter.
Last Transaction DateThe last Trust transaction recorded on the matter.
AmountThe Trust balance.
Comparison

Located at the bottom of the report (downloaded version), displaying: 

  • Total Client Ledger Accounts: The selected trust bank account's total account balance as of the 'At Date'. 
  • FIT Balance: The selected trust bank account's FIT Balance matter balance balance as of the 'At Date'. 
  • Reconciled Cash Book: Reconciled Cash Book Balance as of the 'At Date'. 
  • Variance (should be Nil): Variance between reconciled Cash Book Balance and System Cash Book Balance as of the 'At Date'. 
Last Modified Date
29/04/2026 3:54 PM
Title
Trust Trial Balance by Client Report
URL Name
Trust-Trial-Balance-by-Client-Report-NZ

Resolution
Reports
Loading
Trust Trial Balance by Client Report