At the end of the year or period, the accountant needs to delineate various pieces of information. In particular, he wants to know:
timeSensor LEGAL also allows you to subsequently create accrual lists on a key date. Three lists are available:
- Open services year-end
- Open invoices year-end
- Open advances year-end
You will find these lists as normal 4D Write Pro templates in your template collection (usually similar in the "Administration" capital):
If you do not have these lists, you can also install them later. Then follow the instructions in the next section. If you already have the lists, you can skip the next section.
Install accrual lists
If the accrual lists are not yet available, you can also install them later. You need administrator rights and should have at least timeSensor LEGAL 9.0/Build 3276 installed. The installation is very simple: download the three lists attached to this article and drag and drop them into your template collection, directly into the desired chapter.
Use accrual lists
We recommend that you use the accrual lists in connection with the address data set of your law firm. To do this, go to the address administration, to the area "Employees". Select the data record of your law firm. Now click on the printer button, find the accrual lists and print them. Note that the template asks for the year. For example, if you enter "2020", the lists will be prepared for 31.12.2020.
For the technically interested...
Of course, you can also edit the accrual lists. The lists are not very complex. They essentially contain a 4D Write expression that extracts and compiles the desired data from the database:
The 4D expressions of the "ACC_INSERT" family are used here:
- ACC_INSERT ("period_year")
- Returns the year of the key date (e.g. 2019).
- ACC_INSERT ("period_quarter")
- Returns the selected quarter
- ACC_INSERT ("period_semester")
- Returns the selected semester
- ACC_INSERT ("period_startdate")
- Returns the start date of the period
- ACC_INSERT ("period_enddate")
- Returns the end date of the period
- ACC_INSERT ("vat_report or vat_summary")
- Returns the turnover entries for the VAT statement
- ACC_INSERT ("vat_report_by_account")
- Returns the turnover entries for the VAT statement, broken down by account.
- ACC_INSERT ("input_vat_report or input_vat_summary")
- Returns the input tax entries for the VAT statement
- ACC_INSERT ("input_vat_report_by_account")
- Returns the input tax entries for the VAT accounting, broken down by account.
- ACC_INSERT ("dated_installments_report")
- Returns a list of the advances not yet invoiced as at the reference date.
- Option: if "manager" is specified in the third parameter, the list is subdivided by mandate manager
- ACC_INSERT ("dated_invoices_report")
- Returns a list of invoices open by key date
- Option: if "manager" is given in the third parameter, the list will be subdivided by manager of the client
- ACC_INSERT ("dated_services_report")
- Returns a list of work started (services not yet invoiced) by key date
- Option: if "manager" is specified in the third parameter, the list is subdivided according to the manager of the mandate.
- ACC_INSERT ("invoiced_services_report")
- Returns a list of work invoiced by key date by provider.