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

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.

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 General tab 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 Date tab 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

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

Tab Allocations

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

Tab Open item schedule

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 
  • 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.

Tab Assts for contrct

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.

Tab Valuation

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.

Tab Other info

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.

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.

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