Salesforce

Matter Balances Report

« Go Back
Information
Click to edit heading

Location: LEAP Menu > Reports > Operating Account > Matter Balances.

Purpose: Provides an overview of the financial status of each selected matter as of the designated 'At Date', including balances for outstanding invoices minus Retainer&Credits, Retainer&Credits, unbilled professional fees (WIP) and unbilled expenses, as well as trust account balances. 

Balances for unbilled expenses are categorised into four types: Expense Recoveries, Expense Journals, Expenses, and Anticipated Expenses. 

 
Click to edit heading

Important Notes:

  • When calculating the balances for the designated 'At Date', the report excludes transactions dated after that date.
  • Back dated transactions can alter the report results. Refer to the 'Report Fields' for details. 
  • The report excludes Not-Billable items. This is in relation to the calculation of balances for WIP, Expense Recoveries, Expense Journals, and Anticipated Expenses.
  • When calculating balances for WIP or unbilled expenses, the report treats items on draft invoices as unbilled. 

Filters:

At DateValues are calculated based on the selected date.
MattersSorts results based on whether a matter has been archived: 
  • Non Archived (default): Displays only matters that have not been archived. 
  • Archived: Displays only matters that have been archived. 
  • All: Displays all matters, including those that have been archived.
Matter StatusSorts results to show matters according to their specific statuses (e.g. Complete, In Progress)

NOTE: This filter is only enabled when the 'Matters' filter is set to 'Non Archived'; otherwise, it remains grayed out and inactive.
Inc Matters with Nil Balances
  • Yes: Include matters with nil balances in the report.
  • No (default): Exclude matters with nil balances from the report.

'Matters with Nil Balances' refers to matters where all of the following have zero balances:

  • Trust
  • WIP
  • Receivables
  • Retainer & Credits
  • Unbilled Expense Recoveries
  • Unbilled Expense Journals
  • Unbilled Expenses
  • Unbilled Anticipated Expenses
Inc Inactive StaffInclude or exclude inactive staff members from the 'Staff' list. 
Staff

Provides a staff list to choose from. 

NOTE:

The 'Staff' list will update according to your 'Inc Inactive Staff' selection. 

Staff Type

Select one staff type from the following four options:

  • Staff Responsible
  • Staff Acting
  • Staff Assisting
  • Originating Attorney
 

NOTE: 

The 'Staff' and 'Staff Type' filters collaborate to narrow down the matters featured in the report. Users can select specific staff members from the 'Staff' list and designate a staff role using the 'Staff Type' filter. These two filters work together to limit the results exclusively to matters where the selected staff member(s) fulfill the specified role under the 'Staff Type'.

Example: If a user selects Staff A from the 'Staff' list and 'Staff Responsible' as the Staff Type, the report will only include matters where Staff A is designated as the 'Staff Responsible.' Matters where the 'Staff Responsible' is not Staff A will be excluded from the report, providing a focused view based on the specified staff members and their role within matters.

Billing category

Filter results to display all or only the billing categories selected.

NOTE: For instructions on creating or assigning a billing category, please refer to this article

Inc Draft InvoicesDisplay Draft invoice(s) balances in the Receivables - Rtnr/Credits column.

NOTE: This setting does not impact the calculation of balances for WIP and unbilled expenses, since the report treats items on draft invoices as unbilled. 
Inc Tax

Alters the display of figures to either inclusive or exclusive of tax.

NOTE: This impacts the balance calculation for Debtors, WIP and the four types of unbilled expenses: Expense Recoveries, Expense Journals, Expenses, and Anticipated Expenses. 

Group ByGroup the report results by:
  • None
  • Debtor
  • Staff Responsible
  • Staff Acting
  • Originating Attorney
  • Client
  • Reporting Group
  • Billing Category

Report Fields:

Matter No.The matter Number.
Client
Matter Description
Displays the matter's client name and Matter Description.
StaffDisplays the initials of the matter's Person Responsible, Person Acting, Person Assisting, and Originating Attorney.
Trust

The matter's aggregate General Trust Account balance (excluding Retained Trust Funds). 

NOTE:

  • The figure is determined by adding together the matter's Trust 'Available Balance' and 'Uncleared Amount' as of the 'At Date'. 
  • This field specifically reflects the aggregate matter balance of all relevant General Trust Accounts and does not encompass any Interest-Bearing Accounts. 
  • The amount is expected to match the Trust Trial Balance Report when the two reports share the same 'At Date'. Therefore, when computing the amount, the field captures trust transactions based on their Entry Date rather than their Transaction Date.
WIP The total balance of unbilled professional fees on the matter, excluding Not-Billable items.  
Receivables - Rtnr/CreditsThe total balance of outstanding invoices on the matter less the matter's available Retainer & Credits balance as of the 'At Date'. 
Rtnr/CreditsThe matter's available Retainer & Credits balance as of the 'At Date', with the amount enclosed within parentheses to denote a Retainer & Credits balance.
Expense RecoveriesThe total balance of unbilled Expense Recoveries on the matter as of the 'At Date', excluding Not-Billable items. 
Expense JournalsThe total balance of unbilled Expense Journals on the matter as of the 'At Date', excluding Not-Billable items.  
ExpensesThe total balance of unbilled Expenses on the matter as of the 'At Date'. 

NOTE: Any Expense reversal dated after the 'At Date' is not be taken into account. 
Anticipated ExpensesThe total balance of unbilled Anticipated Expenses on the matter as of the 'At Date', excluding Not-Billable items.  
 
Click to edit heading

 

Tips on How Backdated Transactions Affect the Report:

The following fields (marked with green above) are impacted by backdated transactions:

  • WIP
  • Receivables - Rtnr/Credits
  • Rtnr/Credits
  • Expense Recoveries
  • Expense Journals
  • Expenses 
  • Anticipated Expenses

Specifically, a backdated transaction is captured if the transaction date is on or before the 'At Date'. Such backdated transactions include reversals of Expenses. 

Example:

  1. Suppose a user creates a WIP entry on 03/01/2024 and backdates it to 02/01/2024 (transaction date is 01/02/2024). If the report's 'At Date' is set to 02/01/2024 or later, the WIP field will capture the transaction because the 'At Date' covers the transaction date.

  2. Assume a user creates an Expense entry on 02/01/2024 and dates it the same date. The user then reverses it on 03/01/2024 (reversal date is set to 03/01/2024). If the 'At Date' is set to a date between 02/01/2024 and 02/29/2024, the 'Expenses' field will only capture the Expense entry since the 'At Date' covers its transaction date but not the reversal. If the 'At Date' is set to 03/01/2024 or later, both the Expense entry and its reversal will be captured (cancelling each other out), since the new 'At Date' covers both transactions.

Report Example: 

User-added image

 

3/24/2024 11:04 PM
Matter Balances Report
Matter-Balances-Report-US
Image Gallery

Powered by