Leasing commitments
This report shows the breakdown, by balance sheet line, of the lease commitments made by a company.
It reproduces, in the form of a grid:
- on the one hand, the fees paid as regards to the current fiscal year and also the total of the fees already paid at the end of the fiscal year,
- on the other hand, the amount of the fees remaining to be paid on the next fiscal year (N+1), the total of the fees remaining to be paid on the fiscal years from N+2 to N+5 and also the total of the fees remaining to be paid from the N+6 fiscal year.
The current fiscal year is the one of the context specified in the print request setups.
Prerequisite
Access to the report
This report can be accessed from the report menu of the group Fixed Assets - Funding.
List of criteria
Parameter | Parameter title | Type |
|---|---|---|
soc | Company | |
type | Contract type (Local menu Lease , Long term rent, Rent) | |
contexte | FY type (Local menu Finance, Context 2, Context 3, Context 4...) | |
comment | Comment | DCO |
impselections | Print selections (Local menu No, Yes) |
Comments
The data is filtered by site according to the rights granted to the user on the function GESLEA (Lease contracts).
Miscellaneous
1/ For the Context setup: Fiscal year type, only the choice of the Accounting and Financial context or the IAS/IFRS context is authorized.
2/ The Comment setup: Comment is used to enter a free text of a maximum length of 60 characters. This text appears in page 2 of the report.
3/ Entering values for the setups is not mandatory. The values displayed by default are those entered in the Report dictionary.
When values are entered, any existence control is carried out. In the case where they are inexistent or inconsistent, any print is carried outDescription of the report
Implicit Selection:
Are selected only the lease contracts:
- From the On hold status with an end of contract date higher than the start of fiscal year date.
- From the Buyback, status, with a purchase option removal date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; purchase option removal date] interval are taken into account.
- From the Terminated status, with a termination date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; termination date] interval are taken into account.
- From the Complete status, with a termination date higher than the fiscal year start date and lower or equal to the fiscal year end date. In that case, only the due dates situated in the [fiscal year start date; end of contract date] interval are taken into account.
Grouping/sorting criteria and aggregation
The amounts of fees paid are accumulated by Balance sheet line with a sub-total by nature (Fixed assets/Movable assets), and also a general total.
Restored information
- Header
The header recalls the following information:
- Company reference
- Current fiscal year start and end date of the selected plan.
- Current fiscal year start and end date of the selected plan.
- Start date of the N+2 fiscal year and end date of N+5 fiscal year
- The start date for the N+6 fiscal year.
Are displayed on each balance sheet line, the following amounts:
Information | Rule | |
| Of the fiscal year | Total amount of paid fees in the current fiscal year of the selected context. |
Accumulated | Total of the amounts of the paid fees from the contracts start date to the selected context current fiscal year end date. | |
| Up to 1 year | Total of the amounts of fees remaining to be paid for the due dates contained between the next fiscal year start date (N+1) and the next fiscal year end date. |
+ 1 year to 5 years | Total of the amounts of fees remaining to be paid for the due dates contained between the N+2 fiscal year start date and the N+5 fiscal year end date. | |
+ 5 years | Total of the amounts of fees remaining to be paid for the due date higher than the N+6 fiscal year start date. | |
Total to pay | Total of the fees remaining to be paid: | |
Residual purchase price | Total of the contract buyback values still active by the end of the of the current fiscal year of the selected context. | |