Display running balance in client account transactions screen

Overview

To ensure compliance with SRA (Solicitors Regulation Authority) requirements for client money handling, a new Running Balance field has been added to various Client Transaction screens. This field enables users to view the progressive balance after each transaction in the client account.

Key benefits:

• Regulatory compliance: Meets SRA guidelines for transparent handling of client funds.
• Enhanced visibility: Allows users to view running balances for improved transaction tracking and auditing.

How it works:

A read-only field named Running balance has been introduced to show the cumulative account balance after each transaction.
This field will appear in the following screens:

• MMA > Inquiries and reports > Transactions inquiries > Client
• MMA > Matters > All matter > Transactions > Client
• MMA > Matters > Inquiry > Client monies

Field visibility rules

• The running balance field is only visible when there is a one-to-one relationship between the selected header combinations and a single bank account.
• If multiple bank accounts are present based on header selection, the running balance field will not be displayed.
• Visibility depends on the presence of a value in the Bank account field.
• A new flag ‘Show running balances’ is introduced to control display:
  • Set to ‘No’ and is non-editable when no bank account is selected.
  • Can be toggled to ‘Yes’ when a single bank account is selected.

Running balance calculation logic:

With start date:

Includes opening cleared balance in the calculation.
Example: Opening cleared balance is 10,000

Without start date:

Only the transaction amounts are considered.
Example:

Performance optimisation

• A trigger has been added to manage performance impact.
• A flag ‘Show running balances’ ensures the field is computed only when necessary.