Creating a rental calculation spreadsheet

Filling out the Leasing object card

1. Click the button, which will open the Search function and enter Leasing objects, go to the corresponding link.
2. From the selected Leasing object card or from the Leasing object list, go to the Leasing Calculation List by clicking the Leasing Calculation List button on the card panel or Leasing object list. The system will display a page with calculations of rights to use and obligations for this Leasing object. This page can be either filled or unfilled.
3. To fill/repopulate this page, click the Calculate button, after which monthly calculation records for the entire rental period will appear.

Note

If the records do not appear or appear as zero, check the correctness of the Leasing object card and lease terms card.

The following fields must be filled out on the Leasing Object card:

• Annuity PV Factor,
• Vendor Agreement No.,
• Payment frequency,
• Payment type,
• Payment amount.

The following fields must be filled out on the Lease Terms card for lease terms of the type:

• Type Terms,
• Start and end date terms,
• Price for period,
• Number Of Leasing Units,
• Unit of Measure Code,
• Rental Price Per Unit,
• Currency Code For Calc.,
• Currency Rate,
• Amount In Calc. Currency,
• Amount (LCY).

For lease terms of the "Discount factor" type:

• Type Terms;
• Discount Factor No..

Below is a list and description of the fields on the Leasing Calculation List page that are automatically filled in:

Field	Description
Leasing object No.	The Leasing object number from which Leasing calculations are created.
Period No.	Sequential numbering starting from the first to the last month number in which the contract is valid.
Period Beginning	The start date of the calculation month.
Period Ending	The end date of the calculation month.
Due Date	The system determines whether there is an obligation to charge rent in this period according to the conditions: if "No", the field remains empty, if "Yes", the date of such payment is set.
Payment Full Amount	The total amount of rent, including the non-leasing component.
Non-leasing Component	The amount that, according to IFRS 16, does not participate in calculations and obligations.
Leasing Pay. Liability	Calculated as the difference between the Payment Full Amount.
Leasing Pay. Interest	Calculated as the "Balance Debt Beginning" multiplied by the "Interest Rate" for the given period.
Leasing Pay. Total	Calculated as the difference between the "Total Payment Amount" and the "Non-leasing Component".
Initial/Final Instalment	The amount of the first and last installments, if any, and if it is reflected within the lease agreement.
Discount Amount	Technical field. Displays the size of conditional interest rates after discounting interest rates. Essentially, the "Future Value" of the payment minus the "Present Value" of the payment.
Balance Debt Beginning	For all rows except the first, this value is filled with the value of the "Liability Balance" at the end of the previous period. For the first period, it is calculated by multiplying the "Total Rental Payment" by the "Current Value Annuity Factor".
Balance Debt Ending	Calculated as the "Balance Debt Beginning" minus the "Leasing Pay. Liability" for the current period.
Present Value. Leasing Pay	Calculated as "Payment Full Amount" divided by ((1 + Discount factor for this period) RAISED TO the Period number).
Present Value. Leasing Pay	This field is technical and is used in the process of developing the functionality for reconciliation. Displays the sum of all current values for all periods.
GL Posting Payment	Displays whether the rental payment has been made in the accounting system.
G/L Posting. Leasing Operations	Displays the amount of the rental payment made.
Difference pay accruals	Displays the difference between the actual and accrued payments.
FA Balance Beginning	For the first row, it displays the "Value of the right to use" that should be accounted for. For subsequent rows, it is equal to the "Residual value of the right to use" at the end of the previous period.
FA Balance Ending	Displays the difference between the "Residual value of the right to use" at the beginning of the period and the "Depreciation projection".
Depreciation projection	The calculated (forecast) value of depreciation, calculated by the straight-line method as the "Value of the right to use" divided by the "Total number of monthly periods".
GL Posting Amortization	Displays whether depreciation has been made in the accounting system.
GL Posted Amortization	Displays the amount of accrued depreciation in the accounting system.
Difference Calculation Depreciation	Displays the difference for each period between the values of "Depreciation projection" and "Accrued depreciation" in the accounting system.
Period closed	Displays whether this calculation period is closed.