This report provides the necessary accrual figures for the annual financial statements: total work begun, total outstanding debtors, and total advances that have not yet been credited.
The report first asks for the key date for the annual financial statements, which is usually December 31st. of the previous year. The database will now be reset to this status, which means that any bookings recorded or invoices issued after the cut-off date will not be taken into account. Three worksheets are then created:
Work in progress: All mandates are listed here, sorted by file number, for which services were provided that had not yet been billed by the deadline. These services are totalized. At the end of the list, any advances that have been paid but not yet credited will be deducted.
Debtors: This list shows all invoices that are still open as of the key date with the corresponding outstanding amounts.
Advance and partial invoices: This list shows all advance and partial invoices for which there is a balance. This means that corresponding advance payments had been received as of the key date but had not yet been credited. These advances must be accrued. They are therefore deducted from these on the “Work in progress” worksheet.
Installation
To install the report, you must have administrator rights in timeSensor LEGAL. Copy the enclosed ZIP file to your desktop and unzip it. Go to the Special section in tSL. In the Statistics button, select the Reports window. Drag the unzipped file to the left report templates pane.
Click "Run Script" to start the script included in the report. A query is made:
History
The number before the period in the Version field indicates the report number, and the number after the period indicates the version number. Unless you have modified it to suit your needs, you can update a report at any time by simply reinstalling the new version.