This report is designed to create a clear overview of client funds for a freely selectable period. The report evaluates transactions on defined accounts and shows, by client, which funds were moved during the selected period and what balance results. During execution, the desired evaluation period, the account numbers to be considered, and optionally the display of clients with zero balance are first queried; these inputs are saved and automatically suggested on later calls. Then the algorithm determines the transactions on these accounts within the chosen period, reduces the selection to clients with relevant movements, and calculates the respective account balances. Optionally, cases without a closing balance can be hidden. The results are sorted by client and account and presented in a detailed overview showing individual transactions, the case, counter-account, debit and credit amounts, as well as the running balance. The report thus enables transparent control and evaluation of client funds available per client and supports especially financial overview, billing, as well as internal control and audit purposes.

Click "Run Script" to start the script contained in the report. Three queries will be made:

	Enter the desired evaluation period here. Valid entries are: leave empty for 'all data' YTD for the period from January 1 to the current date of this year q1, q2, q3 or q4 for the 1st, 2nd, 3rd or 4th quarter of This Year or q1/20, q2/2020 for other years s1, s2 for the 1st or 2nd semester of This Year YYYY or YY for the data of the respective year -DD.MM.YYYY all data up to this date DD.MM.YYYY- all data from this date to today DD.MM.YYYY-DD.MM.YYYY
	Enter the desired account numbers here. If you enter multiple codes, separate them with a comma.
	Decide here whether you want to include clients with a zero balance at the end of the period or only clients who show a balance on one of the selected accounts at the end of the period.

Installation

To install the report, you must have administrator rights in timeSensor LEGAL. Copy the attached ZIP file to your desktop and extract it. Then go to the Special section in tSL. Special. Choose the Statistics button to open the Reports. Drag the extracted file with the mouse to the left area with the report templates.

Disclaimer

The community report templates in this section are available to you free of charge and are provided by timeSensor AG, its partners, or customers. They serve as inspiration for creating your own report templates. Please note that neither timeSensor AG nor the authors of the templates assume any warranty for possible errors or suitability for specific purposes. It is possible that certain data structures in the database are required to use the report templates properly, and these structures may vary among different customers. Please note that no support is offered for community report templates.

If you want a custom report template for Your Law Office, please contact the sales team of timeSensor AG at info@timesensor.ch.

History

The number before the dot in the Version field indicates the report number, and the number after the dot indicates the version number. You can update a report at any time to the latest version, provided you have not modified it according to your own needs. Version indicates the report number, and the number after the dot indicates the version number. You can update a report at any time to the latest version, provided you have not modified it according to your own needs, simply by reinstalling the new version. 

Date	Version	Hint
23.11.25	129.0	First Version
21.02.26	129.1	The report now also shows transactions that are not case-bound. The case information has been added as separate columns in the report.