Fixed assets > Funding > Lease contracts > Lease contracts 

Use this function to manage lease contracts, whether entered directly or imported using the Leases import/export template.

Lease contracts cover lease, rent, and long-term rent contracts. Each contract can include one or several assets that the company is renting.

You can also create, modify, or delete (under certain conditions) a contract and print the contract record.
Other actions include entering the funding open item schedule, updating the contract characteristics, managing the purchase option exercises, recording the terminations and end of contract, and viewing the assets for which the contract applies.

Prerequisite

SEEREFERTTO Refer to documentation Implementation

Screen management

The entry screen comprises a header displaying the identification information of the contract and one to six tabs, depending on the level of detail required and the entry screens set up in the Business object transactions function:

  • The Main tab contains the characteristics, as well as the data pertaining to the terms of the contract.
  • The Allocations tab contains the geographic, economic and analytical allocations of the contract.
  • The Open item schedule is used to enter the funding schedule.
  • The Assts for contrct tab is used to view the list of assets concerned by the contract.
  • The Valuation tab tracks the different updates of the borrowed capital amount.
  • The Other info tab is for free fields.

Certain contract information can be entered or modified only through actions that can be carried out on the contract. These actions, grouped in the Actions sub-menu, are the following:

- Record the end of contract
- Lift purchase option
- Terminate contract
- Update the contract

Header

Presentation

The header contains the identification information of the contract: the company and the financial site to which it is allocated, its reference, its description, its status as well as the contract type.

Close

 

Fields

The following fields are present on this tab :

Block number 1

This field displays the company for the financial site.

Enter the financial site in which the contract is recorded.

The choice of the financial site is subject to management and authorization rules given to the user.
The site can also be automatically loaded, by default, with the financial site reference previously displayed. It is possible to activate/deactivate this load by default, via the setup REMAFCY -  Persistence of the site, defined in the AAS chapter - Fixed assets.

If the user is limited to a single site, the financial site is automatically loaded and cannot be modified.

  • Events (field EVTLIST)

 

Block number 2

  • Reference (field LEAREF)

The reference, composed of 20 alphanumerical characters max., is used to identify a financial leasing contract for a given company.
The management of the contract reference is based on the LEAAUTNUM - Lease contract numbering (AAS chapter, LEA group) parameter value:

  • None: A reference must be entered if automatic numbering is not managed.
  • Mandatory: A reference cannot be entered and is automatically assigned when validating the creation.
  • Optional: You can enter a reference or one is automatically assigned.

The reference assigned to the asset is the function of the setup of the sequence number counter assigned to the Contract reference field in Sequence number counter Structure and Sequence number counter assignment functions.

  • Description 1 (field LEADES)

This field contains the main description of the contract.

  • Description 2 (field LEADES2)

This field contains the additional description of the financial leasing contract.

  • Status (field LEASTA)

When creating the contract, the status is To validate. The assets can be attached to it but it must not be the object of any action. In addition, there is no information on the Open item schedules tab; this information is optional.

  • When the contract definition is finalized, you can change the status to In process.
  • When you change the status from To validate to In process, either in creation or in modification, this results in:
    - A Contract creation event (LEACRT) is generated
    - The event is automatically posted by generating an automatic journal: LECRT – Contract creation, designed for the IFRS consolidated accounts.
  • When you click Save after this status change, you receive a warning message that the contract has no schedule. That is, there is no information on the Open Item Schedule tab.
  • A contract with the status In processcannot be deleted. It cannot be directly modified either. It can only change at the end of the different actions applied to the contract. The status changes to:
    - Completed after implementing the action Enter the contractend
    - Buyback after implementing the action Remove the purchase option
    - Terminated after implementing the action Terminate the contract
  • Contract type (field LEATYP)

Select the contract type: Lease, Rent, or Long term rent.
This information can no longer be modified, even though the contract status is To validate,once an asset is assigned to the contract.
Certain information, such as Capital amount, Buyback value, and Purchase option removal date, are only entered if the contract type is Lease.

Close

 

Events

Click the Events icon to display the event log for the contract. When you perform certain actions for any contract type, data is recorded in the event log. The values in the event log are initialized from information in the contract.
Events include

  • Contract creation and changing the status to In process.
  • Contract actualization
  • End of contract
  • Purchase option exercise (lease only)
  • Contract termination
  • Contract deletion

The list can be limited to the events matching the selection criteria. These criteria correspond to the displayed information: the depreciation plan (if required), the user originating the event, the creation date and time, the effective and posting dates, as well as an indicator specifying if the event has already been posted or not.

Special features:

From the Action icon menu on a line, select Detail to view the event content, detailed over several tabs:

- The Generaltab displays the information linked to the creation, modification, and posting of an event. Select Details from the Action icon on the journal number to view the Accounting entry created to post the event.

- The Alphanumeric tab displays account information for the contract such as account code and analytical dimensions.

- The Numeric tab includes values from the contract related to the event. These values update when the contract is updated through a new event.

Amounts managed on this tab include, but are not limited to:

  • Advance rent (if any)
  • Incremental borrowing rate
  • Implied interest rate
  • Initial direct costs
  • Init. present value
  • Capital amount
  • Application fees
  • Interest rate
  • Restoration cost
  • Scrap value

How info displays for Split by month and Periods on several months

When you generate fees for a contract or contracts, you see the events listed in the grid on the Event journal screen.

Split by month

When the contract period is a full month or within a single month, one event or line per month is generated. When you view the details for the event (Action icon menu), on the Numeric tab, you see the full amounts for each field.

For example

First period: 1 Jan 2017 to 31 Jan 2017

Second period: 1 Feb 2017 to 28 Feb 2017

Third period: 1 Mar 2017 to 31 Mar 2017

This generates 3 events, one event for each month. The details on the Numeric tab show the full amounts for each month.

Periods split over several months

When a contract period spans more than one month, events and amounts are calculated differently and depend on the number of days in each period.

For example:

First period: 1 Jan 2017 to 20 Jan 2017 (20 days in the period)

Second period: 21 Jan 2017 to 20 Feb 2017 (31 days in the period)

This generates 3 total events.

First period:

One event for the first period because the 20 days are within the same month.

No calculation based on the number of days.

Second period:

The second period generates 2 events, one for each month within the period. The values for each of these periods/events is calculated as follows:

1st event for the 11 days 21 Jan to 31 Jan. The 11 days are divided by the 31 days in the first month, January.

2nd event for the 20 days (1 Feb to 20 Feb). The 20 days are divided by the 31 days in the period (21 Jan to 20 Feb).

-The Local menu tab displays basic information related to the contract.

-The Datetab displays dates related to the contract.

- The Archived plan tab is only loaded for the Revaluation, the Change in method, or the Change in production plan events and only if the asset belongs to a company subjected to French legislation. In this case, an icon is displayed along with the depreciation plan to specify that the plan has been archived.

The tab displays the depreciation plan (or the production plan) of the asset as it was before the action that has generated the event (revaluation, change in method or change in the production plan). This information is included in an archiving table (DEPRECARC) which primary key is composed of the event identification information: type of event, Change in method, Revaluation, or Change in production plan, and Event time stamp.

Tab Main

Presentation

This tab is used to enter all the contract characteristics.
As long as the contract status is To be validated, all the information can be modified (with the exception of Contract type if at least one asset has been attached to the contract).

If its status is In process, only the following fields on this tab can be updated:

  • Lessor
  • Line of the balance sheet to which the contract belongs
  • Source of the contract
  • Nature
  • Advance rent
  • Interest rate
  • Application fees

Close

 

Fields

The following fields are present on this tab :

Characteristics

This is mandatory information. It is the organization which entered into the lease contract. The lessor must be identified as the Supplier in the BP accounting table.

  • Bal sht line (field BSENAT)

This field is used to enter the balance sheet line involved in the financial lease contract. This information is notably used for editing the summary reports to attach to the annual accounting reports. These tables (referenced as LEALIALeasing commitments and LEARNTDPRLeasingCharges and depreciations) indicate the global situation of the lease contracts, grouped and ordered by balance sheet lines. It is mandatory that the balance sheet line be entered for the contract values to be taken into account in these tables.

  • Source (field LEAORI)

This field is used to specify the origin of the contract. It can be either a new contract or a transferred contract.

  • Nature (field LEANAT)

This field is used to specify the nature (Fixed assets or Movable assets) of the lease contract.

  • Start date (field STRLEADAT)

The Start date for the contract is mandatory. It can only be modified whilst the contract has the status To be validated. This modification leads to the deletion of the financial payment schedule. When the contract is for company vehicles and the registration number is entered, it also leads to the update of the lease start date (Financial assets function, option Vehicle).

  • End date (field ENDLEADAT)

The end date for the contract is mandatory. It can be modified whilst the contract has the status To be validated.
When the contract status is In process, this date can be updated via the Update the contract action. It can also be updated during the use of the Record the end of contract action.
This update, when the date entered is less than the previous date, leads to the deletion of the financial payment schedule for the due dates later than the new date entered.
When the contract involves company vehicles which registration numbers are provided, it also leads to the update of the lease end date (Vehicle option window of the Financial assets management function).

The accounting code is mandatory. It is used to define the CoA and IAS/IFRS accounts to be posted when generating the accounting entries related to the rental contract. If the contract status is In process, it can be updated via the Update the contract action.

Valuations

This field is used to enter the contract financing currency. It remains editable as long as the contract status is: To validate.

  • Borrowed capital (field LEAAMT)

It is mandatory that the borrowed capital amount should be entered if the contract type is Leasing. This amount must be entered in the contract financing currency. It is automatically converted and displayed:
- in the company currency, after the conversion based on the type of rate defined for the Accounting and fiscal context,
- in the IAS/IFRS context currency, after the conversion based on the type of rate defined for the IAS/IFRS context.
If the contract status is In process, this amount can only be updated using the Revise the contract action. The different revisions of the borrowed capital can be viewed in the Valuation tab.

  • Buy-back value (field RPUVAL)

This field is used to enter the buyback price of the asset(s), at the end of the leasing period during the removal of the purchase option planned for a lease contract.
This date, expressed in the financing currency of the contract, can be updated on a contract In progess, either through the action Update the contract, or through the action Lift purchase option.

This field displays the company management currency, as a reminder.

  • Borrowed capital (field LEAAMTDEV)

This non-editable field displays the borrowed capital amount, converted into the company currency.

  • Buy-back value (field RPUVALDEV)

This non-editable field displays the buyback price, converted into the company currency.

  • Rate (field RATCUR)

This field displays the exchange rate used to convert the borrowed capital amount into the company currency.
This rate is automatically generated via the rate type defined for the Accounting andfiscal context.

This field displays the IFRS currency in the IAS depreciation plan for a company.

  • Borrowed capital (field LEAAMTIAS)

This non-editable field displays the borrowed capital amount, converted into the IAS/IFRS context currency.

  • Buy-back value (field RPUVALIAS)

This non-editable field displays the buyback price, converted into the IAS/IFRS context currency.

  • Rate (field IASRATCUR)

This field displays the exchange rate used to convert the borrowed capital amount into the IAS/IFRS context currency.
This rate is automatically generated via the rate type defined for the IAS/IFRS context.

Additional information

  • Interest rate (field LEARAT)

This field defines the interest rate applied to the borrowed capital for a lease contract. This amount is display-only because the payment schedule is not impacted by Fixed Assets (GESFAS). This amount is display-only because the payment schedule is not automatically impacted by the rate.

This value in this field, along with the Implied interest rate and Incremental borrowing rate fields, also populate the Rate field on the Open item schedule tab in the Yearly present values grid according to the following conditions:

-If the three interest rate fields (Incremental borrowing rate, Interest rate, and Implied rate) all contain values, the Implied rate is used in the Yearly present value grid.

-If the Implied rate is 0, then the Incremental borrowing rate is used in the Yearly present value grid, even if the Interest rate field has a value.

-If the Interest rate field is the only one with a value, that rate is used in the Yearly present value grid.

-If all three of these rate fields are empty, the Rate in the Yearly present values grid is not updated.

  • Implied interest rate (field IMPLEARAT)

This field displays the implied interest rate applied to the borrowed capital for a lease contract.

The Implied or Implicit interest rate is equal to the fair value of the underlying asset and any initial direct costs of the lessor.

This amount is display-only because the payment schedule is not impacted by Fixed Assets (GESFAS). This amount is display-only because the payment schedule is not automatically impacted by the rate.

This value in this field, along with the Incremental borrowing rate and Interest rate fields, also populate the Rate field on the Open item schedule tab in the Yearly present values grid according to the following conditions:

-If the three interest rate fields (Incremental borrowing rate, Interest rate, and Implied rate) all contain values, the Implied rate is used in the Yearly present value grid.

-If the Implied rate is 0, then the Incremental borrowing rate is used in the Yearly present value grid, even if the Interest rate field has a value.

-If the Interest rate field is the only one with a value, that rate is used in the Yearly present value grid.

-If all three of these rate fields are empty, the Rate in the Yearly present values grid is not updated.

  • Incremental borrowing rate (field ICRBRWRAT)

This field defines the incremental borrowing rate applied to the borrowed capital for a lease contract.

The incremental borrowing rate is “the rate of interest that a lessee would have to pay to borrowover a similar term, and with a similar security, the funds necessary to obtain an asset of a similar value to the right-of-use asset in a similar economic environment.”*

This amount is display-only because the payment schedule is not impacted by Fixed Assets (GESFAS). This amount is display-only because the payment schedule is not automatically impacted by the rate.

This value in this field, along with the Implied interest rate and Interest rate fields, also populate the Rate field on the Open item schedule tab in the Yearly present values grid according to the following conditions:

-If the three interest rate fields (Incremental borrowing rate, Interest rate, and Implied rate) all contain values, the Implied rate is used in the Yearly present value grid.

-If the Implied rate is 0, then the Incremental borrowing rate is used in the Yearly present value grid, even if the Interest rate field has a value.

-If the Interest rate field is the only one with a value, that rate is used in the Yearly present value grid.

-If all three of these rate fields are empty, the Rate in the Yearly present values grid is not updated.

*Source: IFRS Foundation

  • Advance rent (field BEFRNT)

This field enables entering the amount of advance charges when signing a financial lease contract.

  • Application fees (field LEAEXS)

This field is used to enter the preliminary expenses for a lease contract.

  • Initial direct costs (field INIDIRCST)

The value in this field originates in the lease contract.

The initial direct cost represents the “Incremental costs of obtaining a lease that would not have been incurred if the lease had not been obtained, except for such costs incurred by a manufacturer or dealer lessor in connection with a finance lease.”*

*Source: IFRS Foundation

  • Restoration cost (field RESCOS)

The value in this field originates in the lease contract.

“It is an estimate of costs to be incurred by the lessee in dismantling and removing the underlying asset, restoring the site on which it is located or restoring the underlying asset to the condition required by the terms and conditions of the lease.”*

*Source: IFRS Foundation

  • Update date (field CUTDAT)

The contract revision date is not modifiable. It is filled in automatically at the end of the launch of the action Revise the contract.

  • Option exercise date (field RPUDAT)

This field is used to enter the date of the Purchase option removal planned for a Lease contract. This date can be updated on a contract In progress, either through the action Update the contract, or through the action Lift purchase option.

  • Termination date (field TRMLEADAT)

The contract termination date is not modifiable. It is filled in automatically at the end of the launch of the Terminate contract action.

Close

 

Tab Allocations

Presentation

This tab is used to enter the economic and analytical allocations of the asset.

 

Fields

The following fields are present on this tab :

Economic

Analytical

This field is used in creation mode to enter an analytical distribution key, previously defined in the Analytical allocations function (GESDSP). Click the Jump-to icon in the field to access this function. Entering a distribution key disables the entry of analytical sections.

Grid

 

An Analytical dimension is a part of the analytical general ledger accounts. It is divided into Analytical dimension types where each dimension type constitutes a particular breakdown of the company into a set of analytical payment attributes.
The setup of the folder permits the definition of 1 to 9 dimension types.
An analytical dimension is thus an analytical payment attribute within a dimension type. The dimensions of a dimension type represent the Analytical plan of the dimension type.
This field is used to enter the analytical dimension to which the current recording is allocated.

The entry of analytical dimensions can be set to mandatory using the setup carried out at the level of the Company (Accounting tab).
In creation mode, allocations can be initialized with respect to the setup of Default dimensions (FXDASSETS code for assets and expenses, FXDGRANTS for subsidies and FXDLEASE for lease contracts).

 

Tab Open item schedule

Presentation

This tab is used to enter the funding schedule associated with the lease contract.

The columns that display in the grid depend on the type of contract to define the open item schedule:
For all contract types:

  • Period start and Period end
  • Rental amount
  • Invoice date
  • Invoice ref
  • GL acct


For Lease contract types:

  • Remaining for reimbursement
  • Financial depreciation
  • Financial cost
  • Repaid capital

For Rent and Long-term rent contract types:

  • Variable payments
  • Purchase option
  • Residual value guarantee
  • Penalties

This schedule, expressed in the funding currency of the contract, is in the form of a grid containing (once entered) as many lines as there are open items.

After the you enter the start and end dates for the 1st open item, the following periods are automatically created:

  • The period start date, which corresponds to the previous period end date plus one day.
  • The period end date, which is determined according to that of the 1st period:

    -If the period end date used as the starting point corresponds to the last day of a month, the end date of each of the following periods will correspond to the last day of a month.

    -If the end date of the first period does not correspond to the last day of a month, each period created will end on the same day as the period selected as the starting point. Each period created will have the same number of months as the first period.
     
    Examples:
    1. Period entered by the user: 01/01/2005 – 28/02/2005
      Periods created by the application: 01/03/2005 – 30/04/2005 and 01/05/2005 – 30/06/2005 …
    2. Period entered by the user: 05/04/2005 – 04/05/2005
      Periods created by the application: 05/05/2005 – 04/06/2005 and 05/06/2005 – 04/07/2005 …

Then you can:

  • Specify, for each open item, the amounts of Rental, Financial depreciation and Financial costs. The amount Remaining for reimbursement is loaded by default on the first open item, with the Capital amount; it can be modified.
  • Enter only the 1st period and then request, via to the Carry forward open items option from the Actions icon menu on the line, the automatic carry forward of the amounts to the following open items:

    - The amount Remaining for reimbursement is automatically calculated and cannot be modified.

    - The Financial costs are automatically calculated and correspond to the result of the following calculation: Rental amount of the period – Financial depreciation of the period. They can be modified.

    - The Repaid capital is automatically calculated and corresponds to the result of the following calculation:
    Repaid capital of the previous period + Financial depreciation of the current period.
    It can be modified.

    ..\FCT\SEEINFO Notes:
  • If one of the amounts of an open item is modified, the amounts of the following lines are not updated; they must either be modified by hand, or automatically revised with the amounts of the modified open item using the Actions icon menu option: Carry forward open items.
  • If the company is subjected to French legislation, the sum of the bases of the assets linked to the contract must be less than or equal to the total of the contract charges.
  • - The Invoice date and Invoice reference are optional and may be entered by the user.
  • - The CoA and IFRS accounting indicators cannot be entered. They are automatically activated when the rental events pertaining to the open item have been generated (via the Generation of fee events processing).
Yearly present values grid
The second grid on the tab defines the values for each year in the contract as defined by the periods listed in the first grid.

Close

 

Fields

The following fields are present on this tab :

Grid Open items

  • Period start (field STRPERDAT)

This field displays the period start date which the due date deals with. The first period start date must be entered. The following period start dates are calculated by adding a day to the previous period end date.

  • Period end (field ENDPERDAT)

This field displays the period end date which the due date is about. The end date of the first period must be entered. The end dates of the next periods are automatically defined as follows:
1/ If the period end date corresponds to the last day of a month, the end date of each of the following periods will correspond to the last day of a month.
2/ If the end date of the first period does not correspond to the last day of a month, each created period will terminate with the same day as the first period. Each created period will have the same number of months as the first period.

  • Remaining for reimbursement (field RMNTPA)

This field displays the amount of capital to repay at the beginning of the period concerned by a leasing contract payment. It is expressed in the contract currency.
The balance to repay of the first payment is loaded by default with the capital amount of the leasing contract. It remains modifiable.
The balance to repay of the following payments equals the capital amount of the leasing contract minus the financial depreciation of the previous payments.

  • Rental amount (field RNTAMT)

This field contains the amount of the charge due for the rental of the assets referenced in the financial lease contract. It is expressed in the contract financing currency.
This rental charge corresponds to the increased financial depreciation for the financial costs in the period.
SEEINFO The sum of the bases of the assets linked to the contract must necessarily be lower or equal to the total of the contract charges.

  • Financial depre (field FINDPR)

This field enables the user to enter the amount corresponding to the capital refund. This amount, expressed in the financing currency of the contract, must mandatorily be entered if it is a leasing contract.

  • Financial cost (field FINEXS)

For Lease contract types, this field displays the financial expenses in the contract currency for a given period, which is equal to the fee minus the financial amortization. You can modify this amount.

For Rent contract types, this field represents the interest portion of the lease payment amount that is already stored in the Rental amount column for each period and month. The value in the Financial cost column is not included when calculating the current values and rights of use. This amount is not calculated from the contract characteristic; you need to enter or import it manually.

  • Repaid capital (field RPACAP)

This amount is automatically calculated according to the following formula: Reimbursed capital for the previous period + Financial depreciation for the current period. It can be modified by the user.

  • Variable payments (field VARPAY)

This field displays a portion of payments for the right to use an asset during the contract term and after the start date. This applies to changes in circumstances other than the passage of time.*

*Source IFRS Foundation

  • Purchase option price (field PUROPT)

This field displays the value of an underlying asset should the lessee chose to purchase the asset and terminate the contract. This is a stand-alone price and does not include any payment of penalties for terminating the contract.

It represents "the exercise price of a purchase option if the lessee is reasonably certain to exercise that option."*

*Source: IFRS Foundation

  • Resid. val. guarantee (field RSDVAL)

This field displays the guaranteed value, or a portion of the value, of an underlying asset at the end of the lease.

It is the amount expected to be paid by the lessee under the residual value guarantees.

  • Penalties (field TERPEN)

This field displays the payment amount for penalties for terminating the lease if the lease term shows that the lessee opts to terminate the lease contract.

  • Invoice date (field PAYDAT)

This field enables the user to enter the date of the invoice.
When a date is entered, the open item is not taken into account by the Fee event generation process.

  • Invoice ref (field PAYREF)

This field enables the user to enter the description of the invoice.
When a reference is entered, the open item is not taken into account by the Fee event generation process.

  • General acct. (field FARFLG)

This tick box cannot be entered by the user. It is automatically activated when the annual fee events dealing with the open item and designed for the CoA accounting have been generated.

  • IFRS acct (field FARFLGI)

This check box is automatically checked when the annual fee events for the open item and designed for IFRS accounting have been generated.

Totals

This field displays the contract funding currency.

  • Charge total (field CUMRNTAMT)

 

Grid Yearly present values

  • Year (field PERSTRYEA)

This field displays the year, with one line for each year of the contract term.

  • Index (field NUMYEA)

This field displays the sequential year of the contract: 1 for the first year, 2 for the second year, etc.

  • Rate (field RATYEA)

This field displays the contract interest rate according to the following conditions:


-If the three interest rate fields on the Main tab (Incremental borrowing rate, Interest rate, and Implied rate) all contain values, the Implied rate is used.

-If the Implied rate is 0, then the Incremental borrowing rate is used, even if the Interest rate field has a value.

-If the Interest rate field is the only one with a value, that rate is used.

-If all three of these rate fields are empty, this rate is not updated.

  • Open item total (field PAYYEA)

This field displays the total amount for all open items for each contract year from the Open Item schedule grid.

  • Present value (field CVAYEA)

This field displays the value based on the following formula:

Present value formula = payment / (1+rate) open period

Payment = open item total for the given year

Rate = interest rate or implied interest or incremental borrowing rate depending on the rules for the Rate field

Period = index of the given year (1 for 1st year, 2 for 2nd year …)

Block number 4

This field displays the contract funding currency.

  • Init. present value (field INIPREVAL)

When the contract status changes from To be validated to In process, the field displays the value in the Last present value field. This is amount is displayed in the funding currency and does not change.

  • Initial right of use (field INIPREUSE)

This field displays the sum of the following fields: Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the funding currency.

  • Last present value (field CUMCVAYEA)

This field is contains the sum of the Present value fields for all years of the contract in the funding currency. When the contract status becomes To process, this value is frozen in the Init. present value field and these two fields are used to estimate the Right-of-use of the rent contract associated with the future fixed assets.

  • Current right of use (field CUMCVAUSE)

This field is a sum of the Last present value + Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the funding currency.

This field displays the company currency.

  • Init. present value (field INIPREVALC)

When the contract status changes from To be validated to In process, the field displays the value in the Last present value field. This is amount is displayed in the company currency and does not change.

  • Initial right of use (field INIPREUSEC)

This field displays the sum of the following fields: Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the company currency.

  • Last present value (field CUMCVAYEAC)

This field contains the sum of the Present value fields for all years of the contract in the company currency. When the contract status becomes To process, this value is frozen in the Init. present value field and these two fields are used to estimate the Right-of-use of the rent contract associated to the future fixed assets.

  • Current right of use (field CUMCVAUSEC)

This field is a sum of the Last present value + Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the company currency.

This field displays the IFRS currency in the IAS depreciation plan (GESCNX) for a company.

  • Init. present value (field INIPREVALI)

When the contract status changes from To be validated to In process, the field displays the value in the Last present value field. This is amount is displayed in the IFRS currency and does not change.

  • Initial right of use (field INIPREUSEI)

This field displays the sum of the following fields: Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the IFRS currency.

  • Last present value (field CUMCVAYEAI)

This field contains the sum of the Present value fields for all years of the contract in the IFRS currency. When the contract status changes to To process, this value is frozen in the Init. present value field and  these two fields are used to estimate the Right-of-use of the rent contract associated with the future fixed assets.

  • Current right of use (field CUMCVAUSEI)

This field is a sum of the Last present value + Advanced rent + Application fees + Initial direct cost + Restoration cost + Initial present value in the IFRS currency.

Close

 

Action icon

Carry forward open items

This function helps the entry by enabling the automatic carry forward of the amounts of Rental, Financial depreciation and Financial costs of the period from which the function is called, to the next periods.

RTZ period

This function helps the entry by enabling the blanking of all the periods present in the grid.

 

Close

 

Tab Assts for contrct

Presentation

This tab displays the list of the assets linked to the lease contract and lists, for each one: the reference, the description, the purchase date, and the tax-excl. receipt value expressed in funding currency, company currency and IAS/IFRS currency (if the IAS/IFRS plan is managed). This information cannot be modified.
 
..\FCT\SEEINFO The linking of an asset to a contract is carried out in the Allocations tab of theAssets management screen, by entering the lease contract reference for the asset.

Close

 

Fields

The following fields are present on this tab :

Grid

This field, non modifiable, contains the reference of the financial asset linked to the financial lease contract.

  • Description (field AASDES1)

This field cannot be modified and contains the description of the asset.

  • Purchase date (field PURDAT)

This field, that cannot be modified, contains the purchase date of the financial asset.

  • Receipt value (fin.curr) (field BSEDEVLEA)

This field, that cannot be modified, displays the ex. tax IAS/IFRS entry value of the fixed asset, expressed in the financing currency.

  • Receipt value (comp. cur) (field BSEDEVSOC)

This field, that cannot be modified, displays the ex-tax IAS/IFRS entry value of the financial asset, expressed in company currency.

  • Receipt val (IFRS cur.) (field BSEDEVIAS)

This non-editabe field contains the IAS/IFRS receipt value ex-tax of the financial asset.

Totals

  • Receipt value (fin.curr) (field CUMBSELEA)

Total of the asset ex-tax receipt value, expressed in financing currency.

This field displays the contract financing currency, as a reminder.

  • Receipt value (comp. cur) (field CUMBSESOC)

Total of the asset ex-tax receipt value, expressed in company currency.

This field displays the company management currency, as a reminder.

  • Receipt val (IFRS cur.) (field CUMBSEIAS)

Total of the asset ex-tax receipt value, expressed in IAS/IFRS currency.

This field displays the IFRS currency in the IAS depreciation plan for a company.

  • Ias-fees total variance (field DIFRNTBSE)

 

 

Close

 

Action icon

Asset

This function is used to access, in inquiry mode, the asset management screen from which the function is called.

 

Close

 

Tab Valuation

Presentation

This tab is loaded if one or several updates of the borrowed capital have been performed on the contract.

It contains a table displaying, on the first line, the initial amount of the contract at creation, expressed in funding currency, company currency and (if managed) IAS/IFRS context currency.
Each following line corresponds to an update of the capital and contains the variance of the capital.
The updated amount of the borrowed capital is displayed at the bottom of the screen in the Totals area.

Close

 

Fields

The following fields are present on this tab :

Grid Valuations

  • Update date (field VCUTDAT)

In the 1st line, this field contains the contract start date, and in the following lines, the date when the revision of the borrowed capital has been done.

  • Capital amount (field VLEAAMT)

In the 1st line, this field contains the contract initial amount and in each following line, the variation amount of the borrowed capital.

  • Company currency rate (field VRATCUR)

This field displays the exchange rate used to convert the borrowed capital amount into the company currency.
This rate is automatically generated via the rate type defined for the Accounting andfiscal context.

  • Capital in company currency (field VLEAAMTDEV)

This non-editable field displays the borrowed capital amount, converted into the company currency.

  • IFRS currency exch rate (field VIASRATCUR)

This field displays the exchange rate used to convert the borrowed capital amount into the IAS/IFRS context currency.
This rate is automatically generated via the rate type defined for the IAS/IFRS context.

  • Capital in IFRS currency (field VLEAAMTIAS)

This non-editable field displays the borrowed capital amount, converted into the IAS/IFRS context currency.

Close

 

Tab Other info

Presentation

This tab is for free fields. The number of free fields managed, their titles, the miscellaneous tables assigned to the control of the Code-type free fields and the currency for each Amount-type free field depend on the setup carried out at Free field properties level.
These free fields can be used depending on the management requirements, to store unplanned data in the Main tab.

This tab also displays information useful to contract tracking: origin of the creation (transaction entry, import, etc.), code of the user at the origin of the creation followed by the creation date, and finally the code of the user who carried out the last modification followed by the date of this modification.

Close

 

Fields

The following fields are present on this tab :

Codes

Enter an alphanumeric value that can be linked to a miscellaneous table.   

 

 

 

 

 

 

 

 

 

Amounts

  • field USRFLDM1

Enter an amount, expressed in a currency based on the Free field properties settings.

  • field USRFLDM2

 

  • field USRFLDM3

 

  • field USRFLDM4

 

  • field USRFLDM5

 

  • field USRFLDM6

 

Coefficients

  • field USRFLDC1

Enter a value for the coefficient  type.

  • field USRFLDC2

 

Dates

  • field USRFLDD1

Enter a value for the date type.

  • field USRFLDD2

 

  • field USRFLDD3

 

  • field USRFLDD4

 

Record tracking

  • Entry origin (field CREORI)

This field displays the origin of the record.

This field displays the user who created (entered) the record.

  • Date (field CREDAT)

This field displays the creation (entry) date of the object.

This field displays the user that made the last modification on the recording.

  • Date (field UPDDAT)

This field displays the date of the last modification entered for the object.

Close

 

Other conditions

Deletion

You cannot delete a contract if:

  • The contract status is To be validatedand assets are linked to it.
  • The contract status is In process.

Deleting a contract with the status Terminated or Completed releases the financial assets attached to it.

Reports

By default, the following reports are associated with this function :

 FICHELEA : Leasing contract

 LISLEA : List of rental contracts

This can be changed using a different setup.

Menu Bar

Actions / Record the end of contract

This option in the Actions menu is available for contracts whose status is In process.
It opens a window with the contract end date entered in the Main tab and which can be used to record the end of the contract. The contract end date may also be modified in this window.

Note: the contract end date must be less than or equal to the next fiscal year end date of the Accounting and fiscal context.

This action leads to:

  • The modification of the contract status, which becomes Failed.
  • The recording of the contract end date.
  • The recording of an End of contract (LEAEND) event. (Events can be viewed in the Event journal window which can be accessed from the Other info tab).
  • The disposal of the assets linked to the contract, recording the following information for each one:

    - Disposal reason = End of rent contract if the contract type is Long term rent or End of lease contract if the contract type is Lease.
    - Disposal date = contract end date.
    - Update of the Lease end date in the Vehicle window accessible from the Assets function, if the asset is a vehicle whose registration number is specified.
     
  • The recording of an Asset sale (FASISS) event for each asset. You view the event details in the Event journal window that you can access from the Events icon in the header.
  • The AssetContract link is maintained.

Actions / Lift purchase option

This option in the Actions menu is available for Lease-type contracts whose status is In process.
It opens a window with the Option exercise date and Scrap value entered in the Main tab.
These two values may be modified in this window, which is primarily used to record the purchase option exercise of the lease contract.

This action leads to:

  • The modification of the contract status, which becomes Buyback.
     
  • The recording of the Purchase option exercise date for the contract.
     
  • The recording of the Scrap value.
     
  • The deletion of the AssetContract link.
     
  • The recording of:
    - a Fixed asset creation (FASCRT) event for each asset released,
    - an Exercise of purchase option LEARPU) event.
    You view the event details in the Event journal window that you can access from the Events icon in the header.

     
  • The automatic posting of the LEARPU event by generating a LERPU – Lease: Purchase option automatic journal, for the individual CoA accounts and IFRS consolidated accounts.
     
  • The update of the following information for each of these assets:
     
    - Holding type, which becomes: Property
    - Receipt nature, which becomes: Lease buyback
    - Lease agreement: the reference is blanked out. (The contract reference is recorded in the LEAREFORI Original lease contract reference field; this field, not visible in the Assets screen, is available for example in selections, reports, etc.).
    - The CoA account is updated and loaded with the IFRS account.
     
  • The update of the depreciation plans of the Accounting and fiscal context, for each of the released assets, as follows:

    - the Depreciation start date is updated using the purchase option exercise date,
    - the Receipt value is loaded with the value resulting from the following calculation:
    --> if the IAS/IFRS plan is managed: Contract buyback value * (IAS/IFRS receipt value of the asset / Sum of the IAS/IFRS receipt values of the assets linked to the contract),
    -> if the IAS/IFRS plan is not managed: Contract buyback value (converted in company currency) / Number of assets.
    - the Depreciation method takes the following value: SA,
    - the Depreciation duration is loaded with the value 0.

Note: this action is irreversible; the purchase option exercise cannot be cancelled.

Actions / Terminate contract

This option in the Actions menu is available for contracts whose status is In process.
It opens a window which is used to terminate the lease contract.

This action leads to:

  • The modification of the contract status, which becomes Terminated.
     
  • ‎‎‎The recording of the Termination date of the contract.
    Note: this termination date must be less than or equal to the end date of the next fiscal year of the Accounting and fiscal context.
     
  • The disposal of the assets linked to the contract, recording the following information for each one:

    Disposal reason = Terminated contract
    Disposal date = contract termination date.
     
  • The recording of:
    - an Asset release (FASISS) event for each asset,
    - a Contract termination (LEATRM) event.
     You view the event details in the Event journal window that you can access from the Events icon in the header.
     
  • The automatic posting of the LEATRM event by generating an automatic journal: LETRM - Lease: Early termination, for the IFRS consolidated accounts.
     
  • The AssetContract link is maintained.

..\FCT\SEEINFO This action is irreversible; the termination of the contract cannot be cancelled.

Actions / Update the contract

This option in the Actions menu is available for contracts whose status is In process.
 It opens a window that is used to modify the following information of the contract: 
- Contract end date.
For the Lease-type contract:
- Loaned capital variation: positive or negative correction to apply to the borrowed capital; this variation, specified in the funding currency, is automatically converted and displayed in company currency and management currency of the IAS/IFRS context (if it is managed).
- Scrap value (specified in the funding currency, and displayed in the company currency and management currency of the IAS/IFRS context if it is managed).
- Purchase option exercise date.
- Accounting code.

This action leads to:

  • The recording of the update date and the new values entered, in the Main date.
     
  • Prohibiting the modification of the open items which are earlier than the update date of the contract.
     
  •  The recording of a Contracts update(LEAACTU) event.
    You view the event details in the Event journal window that you can access from the Events icon in the header.
     
  • The automatic posting of this event by generating an automatic journal: LEACT – Lease : Update, for the IFRS consolidated accounts.

The pre-update data are therefore archived and can be viewed using the LEAACTUContracts actualization specific report, which displays the different stages in the life of the contract.
When the update pertains to the amount of borrowed capital, the capital variations can be viewed in the Valuation tab.

When the update of the contract affects the contract end date, it also:

  • Modifies the schedule as follows: if this date is earlier than the former date, the open items further than the new date entered are deleted. If this date is further than the former date, the periods further than the new date are created and the amount of the new open items must be entered by hand.
     
  • Modifies, in the Vehicle window in the Assets function, the lease end date of the assets linked to the contract in the case of vehicles whose registration numbers is specified.

Error messages

In addition to the generic error messages, the following messages can appear during the entry :

"You must unlink the assets from the contract before changing its type".

The holding type of the assets must be coherent with the contract type: the assets linked to a lease-type contract must necessarily have the holding type: Lease; those linked to a contract of the long term rent-type contract must necessarily have the holding type: Long term rent.

Tables used

SEEREFERTTO Refer to documentation Implementation