In the ‘Maturity Report’ notes we will split your future lease payments between different maturities. You need the report in your Financial Notes.
If you want to see the lease maturity view of, for example the 31.12.2019 situation, run the report with the date of 1.1.2020.
Please note that when you are closing your financial year and want to have the balance of your future payments and the lease liability to match exactly, you should not have changes or new leases in the system before the report date. If your report date is 1.1.2020, you should not have any changes where "date of change" is or new lease leases where start date is after 1.1.2020.
Click on Reporting > Notes maturity report
Update all fields that are relevant to your report. All mandatory files will be in essentials area.
Entity is the company that is doing the reporting. (New Companies can be created under Settings > Companies).
The Counterparty is the Lessor. (New Companies can be created under Settings > Companies and ticking counter party).
The Lease type highlights the asset group the lease belongs to. (New types can be created under Leasing > Lease types).
The Cost center helps to categorise your data in reports. (New Cost centers can be created under Settings > Cost center).
The Portfolio helps to categorise your data in reports. (New portfolios can be created under Settings > Portfolios).
Select Currency from the drop down menu.
It is mandatory to select the currency. All columns with the “in base” name will be converted to the currency selected.
Select the report Start date from the calendar.
Start date is the first day after the end date of your reporting period. (So if you want to look at, for example, the year 2018 end situation, you should select here 1.1.2019).
Note that this report will not work when running multiple reports from the library because of this start date. But you can still save this report to your automation.
With this report you can easily run the maturity table of your lease liabilities. Use the “Repayment of loan in base currency” column in your notes.
Lease Id (Optional) is used to filter the results. If you only need information relating to one particular lease, enter the lease ID here. The lease number is automatically assigned. To see a list of all leases with their lease IDs click Leasing > Register (called Trade ID)
Report Name (Optional) is used to identify the report. You will see it listed in the report library as Custom Report Name:
Click Show to view the Lease Change Report. Click Save to save the report, and an email with a zip file will be sent to your email. Click Back to abandon your changes.
Use these buttons so Copy to clipboard, download as a CSV, an Excel file or a PDF. Or click to Print.
Values column by column.
Payment Duration is the duration and breakdown of payments by time.
Total cost amount in currency is total payment amount (Fixed + Service) in agreement currency
Total cost amount in base currency is the converted total payment amount in the selected currency.
Fixed asset amount in currency is the payment that is related to the actual asset, in the agreement’s currency.
Fixed asset amount in base currency is the converted fixed asset payment, in the selected currency.
Repayment of a loan in currency is the repayment of your lease liability, in the agreement's currency.
Repayment of loan in base currency is the converted repayment, in the selected currency.
USE THIS COLUMN FOR YOUR NOTES!
Interest cost in currency is the amount of interest being paid from the fixed payment.
Interest cost in base currency is the converted interest amount in the selected currency.