Overview

The Lease Amortisation screen displays the amortisation schedule for a leased asset. It shows a period-by-period breakdown of lease liability and depreciation, detailing how each payment is split between interest (finance charge) and capital repayment. You can use this screen to review lease positions, track posted transactions, and export the schedule in several formats.

Getting here

Open the sidebar.
Click Reports.
Click Lease Amortisation.

You need the insights permission to access this screen.

What you can do on this screen

Search for and select a leased asset to view its amortisation schedule.
View period-by-period lease liability and right-of-use (RoU) asset values.
Sort the schedule by any column.
Navigate through pages of results.
Select individual rows or all rows on the current page.
Export the schedule to CSV, Excel, or PDF.
Filter the data using the side panel.
Choose which columns to display and reorder them.
Save and manage filter presets.
Navigate to an asset's detail page from the schedule.

Select an asset

In the Search assets by code or name field at the top right of the screen, type an asset code or name.
Select the asset from the results that appear.
The amortisation schedule loads automatically.

To clear the current selection, remove the value from the search field. The schedule data is cleared and the screen returns to its initial state.

View the amortisation schedule

Once you select an asset, the screen displays:

A lease information banner showing the lease reference, lease description, asset code, asset description, and the total number of periods.
A table with one row per period in the schedule.
A footer showing summary totals for total interest, total payments, and total depreciation, along with pagination controls.

You can click the asset code or asset description in the lease information banner to navigate to that asset's detail page.

Sort the schedule

Select a column header to sort the table by that column in ascending order.
Select the same column header again to sort in descending order.
Select it a third time to remove sorting for that column.

A sort arrow appears next to the active sort column to indicate the current sort direction.

Navigate between pages

The table displays 25 rows per page. Use the pagination controls at the bottom of the screen to move between pages:

Click First to go to the first page.
Click Previous to go back one page.
Click Next to go forward one page.
Click Last to go to the last page.

The footer shows which rows you are viewing (for example, "Showing 1-25 of 60 periods").

Select rows

You can select rows using the checkboxes on the left side of the table.

To select a single row, tick the checkbox next to that row.
To select all rows on the current page, tick the checkbox in the column header.
To deselect all rows, untick the checkbox in the column header.

When you select one or more rows, the Actions panel opens on the right side of the screen.

Export the schedule

You can export the amortisation schedule from the Actions tab in the side panel. Export options are only available after you have loaded a schedule.

Export to CSV

Open the Actions tab in the side panel.
Click Export to CSV.
The file downloads to your device.

Export to Excel

Open the Actions tab in the side panel.
Click Export to Excel.
The file downloads to your device.

Export to PDF

Open the Actions tab in the side panel.
Click Export to PDF.
The file downloads to your device in landscape orientation.

All exports include the currently visible columns in their displayed order, and cover all rows (not just the current page). A confirmation message appears when the export completes successfully.

Filter the schedule

Use the Filters tab in the side panel to narrow down the data. The number of active filters is shown as a badge on the Filters tab.

The following filters are available:

Filter	Description
As at Date	Set the report date for lease positions. Defaults to today's date.
Asset Type	Select one or more asset types (for example, Buildings, Vehicles, Equipment).
Lease Treatment	Select one or more FRS 102 accounting treatments: On-Balance Sheet (RoU) or Short-term / Low-value (Exempt).
Lease Status	Select one or more lease statuses: Active, Expired, Terminated Early, or Renewed.
Lease Start Date	Set a date range to filter by lease commencement date.
Lease End Date	Set a date range to filter by lease expiry date.
Remaining Term (Months)	Enter minimum and/or maximum values to filter by remaining lease term in months.
Liability Amount	Enter minimum and/or maximum values to filter by lease liability balance.
Lease Reference	Type a lease reference to search for a specific lease.

Apply filters

Open the Filters tab in the side panel.
Set the filters you need.
Click Apply Filter.

An "Unsaved changes" badge appears when you have changed filters that have not yet been applied.

Save a filter preset

Set the filters you need.
Click Save and Apply.
Enter a name for the filter preset.
Click Save.

The filter is saved and applied. You can load it again later from the Saved Filters dropdown at the top of the Filters tab.

Manage saved filters

From the Saved Filters dropdown, you can:

Select a saved filter to load and apply it.
Edit a saved filter's name or settings.
Duplicate a saved filter.
Delete a saved filter.

Clear all filters

Click Clear All within the Filters tab to remove all active filters and reset to default values.

Choose and reorder columns

Use the Columns tab in the side panel to control which columns are visible and their order.

Open the Columns tab in the side panel.
Use the search field to find a column by name.
Select the eye icon next to a column to show or hide it.
Drag a column using the grip handle to change its position in the table.

You can also:

Click Show All to make all columns visible.
Click Reset to return columns to their default visibility and order.

Changes are saved automatically.

You can also resize columns by dragging the divider between column headers.

Field reference

The following table describes each column available in the amortisation schedule.

Column	Description
Period	The period number within the lease schedule.
Date	The date of the period.
Opening Liability	The lease liability balance at the start of the period, shown in your home currency.
Interest (Finance Charge)	The interest or finance charge applied during the period, shown in your home currency.
Payment	The total lease payment for the period, shown in your home currency.
Capital Repayment	The portion of the payment that reduces the lease liability (payment minus interest), shown in your home currency.
Closing Liability	The lease liability balance at the end of the period, shown in your home currency.
RoU Depreciation	The depreciation charge for the right-of-use asset during the period, shown in your home currency.
RoU Asset NBV	The net book value of the right-of-use asset at the end of the period, shown in your home currency.
Posted Ref	The reference for the posted transaction, if the period has been posted.
Posted Date	The date and time the period was posted, if applicable.

The footer displays the following summary totals:

Total	Description
Total Interest	The sum of all interest (finance charge) amounts across the schedule.
Total Payments	The sum of all payment amounts across the schedule.
Total Depreciation	The sum of all RoU depreciation amounts across the schedule.

Warnings and messages

Message	When it appears
"Failed to load amortisation schedule"	The system could not retrieve the schedule for the selected asset. Try selecting the asset again.
"Failed to export data"	An export to CSV, Excel, or PDF did not complete. Try the export again.
"Exported [number] record(s) to CSV"	A CSV export completed successfully.
"Exported [number] record(s) to Excel"	An Excel export completed successfully.
"Exported [number] record(s) to PDF"	A PDF export completed successfully.
"Load a schedule to enable export actions"	Shown in the Actions panel when no asset has been selected. Select an asset to load a schedule first.
"Select an asset"	Shown when no asset is selected. Use the search field to find and select a leased asset.
"No periods found"	The selected asset has a lease but no schedule entries are available.
"Please configure at least one filter before saving"	You tried to save a filter preset without setting any filter values. Set at least one filter before saving.
"Failed to load saved filters"	Saved filter presets could not be retrieved. Try reloading the page.
"Failed to save filter"	The filter preset could not be saved. Try saving again.
"Filter deleted successfully"	A saved filter preset was removed.
"Failed to delete filter"	The saved filter preset could not be removed. Try again.
"Failed to duplicate filter"	The saved filter preset could not be duplicated. Try again.