Fees and depreciations
This report displays the distribution by balance sheet line, for the indicated fiscal year, the total at the fiscal year end:
- fees to be paid for the lease contracts subscribed by the company,
- depreciations posted on the selected plan for the assets attached to these contracts.
It also displays, for each balance sheet line, the original value of the assets attached to the contracts.
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 |
|---|---|---|
|
cpydeb |
Company limit |
|
|
plan |
Depreciation plan (Local menu Accounts, Finance, Minimum, Source, Reevaluation 76...) |
|
|
datdeb |
Date range |
D4 |
|
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/ The date ranges are used to calculate the information related to the contract. They are also used to determine the fiscal year to take into account for the display of depreciations of assets attached to the contracts. The date ranges must thus be coherent with the breakdown of fiscal years from the chosen plan.
2/ The Comment parameter: 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 parameters 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 out.Report description
Implicit Selection:
Are selected only the lease contracts:
- From the On hold status with an end of contract date higher than the start date of the fiscal year defined by the date ranges.
- 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
- Start and end dates entered.
Are displayed on each balance sheet line, the following amounts:
|
Information |
Rule |
|
|
Original value |
Sum of the ex. tax entry values of assets assigned to the selected contracts. |
|
|
Contracts (1) |
of the fiscal year |
Total amount of paid fees in the selected fiscal year. |
|
accumulated |
Total of the amounts of the fees paid from the contracts start date to the selected fiscal year end date. |
|
|
Contracts (1) |
of the fiscal year |
Total amount of the financial depreciation on the fiscal year. |
|
accumulated |
Total of the financial depreciation from the contracts start date to the selected fiscal year end date. |
|
|
Contracts (1) |
of the fiscal year |
Total amount of financial costs in the selected fiscal year. |
|
accumulated |
Total of the financial costs from the contracts start date to the selected fiscal year end date. |
|
|
Contracts (1) |
of the fiscal year |
Total amount of the repaid capital in the selected fiscal year. |
|
accumulated |
Total of the amounts of the repaid capital from the contracts start date to the selected fiscal year end date. |
|
|
|
of the fiscal year |
Sum of depreciations of assets attached to the selected contracts, until the fiscal year end date on the chosen plan. |
|
accumulated |
Total of depreciations of assets attached to the selected contracts, until the fiscal year end date. |
|
(1) These amounts are calculated from the "Schedule" tab of the Lease contract function.
(2) These amounts are calculated from the assets attached to the contracts.
Tables concerned
The data extracted from the following tables are processed by the report LEARNTDPR :
|
Table |
Table description |
|---|---|
|
AFCTFCY [AFF] |
Site profile function |
|
COMPANY [CPY] |
|
|
CONTEXT [CNX] |
|
|
DEPREC [DEP] |
Charge |
|
FISCYEAR [FIS] |
Fiscal year |
|
FXDASSETS [FAS] |
|
|
LEABILBOOK [LBB] |
Lease contract schedules |
|
LEASE [LEA] |