Fullscreen Image

IFRS 16 Equipment Schedules Page - Equipment Contract Module

A lease accounting schedule is a list of lease payments and related accounting over the course of the lease term. Lucernex supports the creation of Straight-line, ASC 842, GASB 87, and IFRS 16 schedules for contracts, and ASC 842, GASB 87, and IFRS 16 schedules for assets and equipment.

You can view your lease accounting schedule in three ways: by Calendar Year, by Fiscal Year, or by Fiscal Details. The Fiscal Details page breaks down the lease accounting schedule by period, and automatically calculates the period length.

Note:

If your firm has IFRS 16 enabled, you will not be able to see the GASB 87 pages of the application.

To navigate to the IFRS 16 Equipment Schedules page:

  1. Navigate to Equipment Contract > Accounting Info > IFRS 16 Rent Schedule.

    Use the links in the Navigation Pane on the leftmost side of the page.

  2. Select IFRS 16 Equipment Schedules from the field to the left of the Actions menu.

  3. Follow a procedure below.

ClosedImport Data

To learn how to import a spreadsheet to generate your lease accounting schedule, see our Bulk Lease Accounting Data Import article.

ClosedCalculate IFRS 16 Contract Schedule

Important!

There are two ways to generate an IFRS Operating schedule in Lucernex:

  1. Create a Straight Line schedule.

  2. Create an IFRS schedule with a 0% Discount Rate.

You will need to filter all schedules with the 0% discount rate out of your integrations to your ERP.

To generate an IFRS 16 contract schedule:

  1. Click Calculate Schedule.

    This displays in the Actions menu on the right side of the page.

    The Create New IFRS 16 Rent Schedule window opens.

  2. Select the schedule type from the Type field.

    Note:

    The Begin Date, End Date, and Discount Rate automatically populate. Steps 6 – 10 refer to fields that will automatically populate with data entered on the Contract Accounting Assumptions page. This is the last place where you can edit these fields prior to generating your schedule.

    To learn how to select a different discount rate from the Manage Discount Rates table, see our Search for Another Discount Rate article.

    Note:

    The default value of the Schedule Begin Date is the later of the Accounting Begin Date or the first day of the first unposted period for the schedule. You can override the value of the Schedule Begin Date in the Create Schedule window, provided the date you choose is on or after the first day of the first unposted period.

  3. Select the reason for creating the schedule from the Creation Reason field.

    Creation reasons are either user-generated or generated at the company level. However, all creation reasons created at the user level will also be available at the company level.

  4. If you want to specify a percentage or amount of the total asset balance that should remain after the schedule end date, enter the value in the Remaining Asset Balance field.

    There are two option buttons: Currency and Percentage. If you enter a value between 0-100, the system will default the option setting to Percentage. If you enter a value of 100.01 or above, the system will default the option setting to Currency. You can override the default option setting.

  5. If you want to select a date beyond the schedule end date to amortize to, enter the date in the Date to Amortize to field.

    By default, the value of this field is the schedule end date.

    To learn more about asset amortization, see the Amortization of the Asset in Contracts article.

  6. Enter any incentives that have reduced the cost of the lease in the Lease Incentive Amount field.

  7. Enter any other miscellaneous costs that should be accounted for in the schedule in the PV Of Other Adjustments field.

    Note:

    The Purchase Option, Cancellation Option, and Residual Value Guarantees should automatically populate if you have those options entered on the Covenants page. The Initial Liability Balance will be automatically calculated by the system.

  8. Enter the amount paid towards the lease payment prior to the commencement date, minus any incentives that have reduced the cost of the lease, in the Payments Before Commencement (Less Incentives) field.

  9. Enter the incremental costs of a lease that would not have been incurred if the lease had not been obtained in the Initial Direct Costs field.

    For example, costs for originating the lease agreement, and legal fees and commission.

  10. Enter the cost of any activity necessary to restore the asset to its original state prior to the expiration of the lease in the Dismantling / Restoring Costs field.

  11. Enter any deductions related to the diminished value of the asset in the Impairments field.

    Important!

    Impairments should be entered as a negative value.

    If you enter a value in the Impairments field, two read-only fields appear:

    • Prior Accumulated Amortization Balance: Accumulated Amortization Balance of the accounting period prior to the impairment.

    • Total: Sum of the impairment and the Prior Accumulated Amortization Balance.

  12. Enter notes in the Notes field.

  13. Click Create Schedule.

    The page refreshes, and the schedule appears on the page.

ClosedCalculate IFRS 16 Asset Schedule

Creating an asset schedule generates a schedule for all assets assigned to that schedule type for the contract. For example, if you have 100 assets with separate expenses that are all tied to the same schedule type, 100 asset schedules would be generated.

To generate an asset schedule:

  1. Click Calculate Schedule.

    This displays in the Actions menu on the right side of the page.

    The Create New IFRS 16 Rent Schedule window opens.

  2. Select the Create Equipment Schedules tab.

    The Create Equipment Schedule page of the window opens.

  3. Select the schedule type from the Type field.

    If you want to create a new schedule type, follow the Add an Accounting Schedule Type procedures.

    You must select the schedule type associated with your equipment.

  4. Select the creation reason from the Creation Reason field.

    Creation reasons are either user-generated or generated at the company level. However, all creation reasons created at the user level will also be available at the company level.

  5. Enter the discount rate in the Discount Rate field.

    The discount rate is also known as the Interest Rate or Internal Borrower Rate (IBR). To learn how to select a different discount rate from the Manage Discount Rates table, see our Search for Another Discount Rate article.

  6. Click Create Schedule.

    The page refreshes, and the schedule is created. You will receive an email confirmation.

    Note:

    If more than one of your assets have had the value of their Operational Status change to something other than Active, a dialog box will open, with a message that reads: Since last schedule creation, some assets have changed to non-Active status. Do you want to terminate the asset schedules for them? To learn more about bulk termination, see the Asset Schedule Termination > Bulk Termination section below.To learn more about bulk termination, see the Lease Accounting Schedule Termination article.

  7. Select IFRS 16 Equipment Schedules from the field to the left of the Actions menu.

    The IFRS 16 Equipment Schedules page opens. The schedule data appears on the page.

ClosedRe-measure Your IFRS 16 Contract Schedule

Re-measurement is the process by which an entity will adjust the right of use asset and lease liability due to a change. Generally, re-measurement occurs if something has changed in the contract. Maybe the termination option was renegotiated, or maybe additional costs came up that needed to be added to the contract.

When an active schedule is recalculated or terminated, the Inactive Date of the previously active schedule will automatically populate with the date of recalculation or termination.

To re-measure a lease accounting schedule:

  1. Click Calculate Schedule.

    This displays in the Actions menu on the right side of the page.

    The Create New IFRS 16 Rent Schedule window opens.

  2. Enter the dates that your re-measurement should begin and end in the Begin Date and End Date fields.

    You can also click Calendar A small button with a picture of a calendar on it. to open the Date Picker and select the appropriate date.

    Note:

    The default value of the Schedule Begin Date is the later of the Accounting Begin Date or the first day of the first unposted period for the schedule. You can override the value of the Schedule Begin Date in the Create Schedule window, provided the date you choose is on or after the first day of the first unposted period.

  3. Select the schedule type from the Type field.

    Note:

    The data from the existing schedule populates. If there are any posted periods between the Begin Date and the End Date, the Re-measurement Balance Forward will automatically calculate the re-measurement balance forward for those posted periods.

  4. Select the creation reason from the Creation Reason field.

    Creation reasons are either user-generated or generated at the company level. However, all creation reasons created at the user level will also be available at the company level.

  5. Make any changes necessary to the discount rate, the liability values, and the right of use asset values prior to re-measurement.

    To learn how to select a different discount rate from the Manage Discount Rates table, see our Search for Another Discount Rate article.

  6. Enter notes in the Notes field.

  7. Click Create Schedule.

    The window closes, and the Create New IFRS 16 Rent Schedule page refreshes. The re-measured schedule appears in your IFRS 16 Rent Schedule List.

ClosedRe-measure Your IFRS 16 Asset Schedules

Re-measurement is the process by which an entity will adjust the right of use asset and lease liability due to a change. Generally, re-measurement occurs if something has changed in the contract. Maybe the termination option was renegotiated, or maybe additional costs came up that needed to be added to the contract.

When an active schedule is recalculated or terminated, the Inactive Date of the previously active schedule will automatically populate with the date of recalculation or termination.

To re-measure your IFRS 16 asset schedules:

  1. Click Calculate Schedule in the Actions menu on the right side of the page.

    The Create New IFRS 16 Rent Schedule window opens.

  2. Select the Create Equipment Schedule tab.

  3. Select the schedule type you want to re-measure from the Type field.

  4. Select the creation reason from the Creation Reason field.

    Creation reasons are either user-generated or generated at the company level. However, all creation reasons created at the user level will also be available at the company level.

    Note:

    The Discount Rate pre-populates with the default discount rate. Modify the value in the Discount Rate if necessary. To learn how to select a different discount rate from the Manage Discount Rates table, see our Search for Another Discount Rate article.

  5. Click Create Schedule.

    The page refreshes, and the schedule is created. You will receive an email confirmation.

    Note:

    If more than one of your assets have had the value of their Operational Status change to something other than Active, a dialog box will open, with a message that reads: Since last schedule creation, some assets have changed to non-Active status. Do you want to terminate the asset schedules for them? To learn more about bulk termination, see the Asset Schedule Termination > Bulk Termination section below.

  6. Select IFRS 16 Equipment Schedules from the field to the left of the Actions menu.

    The IFRS 16 Equipment Schedules page opens. The schedule data appears on the page.

Override Recalc? Flag on Lease Accounting Schedules

Approve a Lease Accounting Schedule

View the Recalculation Trigger for a Lease Accounting Schedule

View Rent Schedule Values in a Different Currency

View Cash Expense Values via Hyperlink

Export a Lease Accounting Schedule into Excel

ClosedPartial and Full Contract Termination

When you re-measure or terminate a lease and you are going to recalculate your accounting schedules, you can allocate appropriate portions of the Remeasurement Balance Forward to remain on the balance sheet or to be counted as a capital gain/loss (profit & loss impact). This change applies to real estate contracts and lease-level schedules for equipment contracts. A common use case is a change in square footage, the closure of a store, or the retirement of some fraction of equipment assets.

When an active schedule is recalculated or terminated, the Inactive Date of the previously active schedule will automatically populate with the date of recalculation or termination.

The system prorates your termination schedule as of the day prior to the day of termination. For example:

  • If you terminate your schedule as of January 15th, the system will include accounting values for all days in the period up to the 14th.

  • Likewise, if you terminate your schedule as of January 21st, the system will include accounting values for all days in the period up to the 20th.

ClosedPartial Lease Termination

To perform a partial lease termination:

  1. Click Calculate Schedule in the Actions menu on the right side of the page.

    A Create New Schedule window opens.

    The Start Date of your new schedule is the day after your last posted period.

  2. If there is a change in value in the underlying asset, enter either a percentage value in the P&L Impact percentage field or a negative fixed dollar amount in the P&L Impact fixed dollar amount field.

    If there is no change in the underlying asset, you do not need to allocate any of the Remeasurement Balance Forward to P&L Impact.

    Important!

    The P&L Amount requires a negative value because it is a percentage of the Remeasurement Balance Forward field, which is also negative.

    This amount will be held back from your new schedule and posted to a field (SLSummary.ProfitAndLossImpact) which can be fed to an ERP integration as a GL entry. The system will automatically calculate the appropriate fixed amount or percentage; depending upon which field you enter a value.

    Note:

    You can allocate 100% of your remeasurement balance forward to your profit and loss impact without terminating your lease accounting schedule. This functionality supports the use case where you might want to impair the asset or write off the existing balance forward.

  3. Make any other changes to your schedule data as necessary.

  4. Click Create Schedule.

    The window closes. The new schedule appears in the Rent Schedule List.

ClosedFull Lease Termination

To perform a full lease termination:

  1. Click Calculate Schedule in the Actions menu on the right side of the page.

    A Create New Schedule window opens.

  2. Select the Terminate Schedule tab.

    Your Begin and End Date, Schedule Type, and P&L Impact value should pre-populate on the page. In this case, the entire amount of the Remeasurement Balance Forward will populate the P&L Impact field, and it will be uneditable.

  3. Select the appropriate creation reason from the Creation Reason field.

  4. Enter any notes in the Notes field.

  5. Click Create Schedule.

    A dialog opens, asking you to confirm your choice.

  6. Click Yes.

    A new schedule appears in the Rent Schedule List, where all values are listed as $0.00. This is a single-period schedule that is created to close out the prior accounting schedule, so that ERP integrations can close the balance sheet for this schedule.

ClosedImportant Note About Full Lease Termination

The above procedures describe only how to close out the accounting schedules for a terminated lease. If the lease is being fully terminated you will still need to update your Payment End Date at the lease level so that no new rent payments will be generated.

To update your payment end dates:

  1. Do one of the following:

    • Navigate to Contract > Details > Summary using the tabs at the top of the page.

    • Navigate to Equipment Contract > Details > Summary using the tabs at the top of the page.

  2. Click Edit link in the Actions menu on the right side of the page.

    The page becomes editable.

  3. Scroll down to the Critical Dates section of the page.

  4. Change the Payments End Date to the end date of your schedule.

  5. Click Save Changes.

    This displays in the Actions menu on the right side of the page.

    The page refreshes. Your changes are saved.

ClosedAsset Schedule Termination

ClosedSingle Asset Termination

To terminate a single asset schedule:

  1. Select the equipment whose schedule you want to terminate from the Equipment Schedules List.

  2. Click Calculate Schedule in the Actions menu on the right side of the page.

    The Create New Rent Schedule window opens.

  3. Select the Terminate Equipment Schedule tab.

    The Terminate Equipment Schedule tab opens.

    If you did not open the Equipment Schedules page in Step 3, a message will appear which reads: No Equipment to Terminate.

    The Equipment Name will appear below the Creation Reason field. The Begin Date, End Date, Type, and P&L Impact fields will pre-populate.

  4. Select the reason you are creating the termination schedule from the Creation Reason field.

  5. Enter any notes about the termination schedule in the Notes field.

  6. Click Create Schedule.

    The window closes. The termination schedule appears in your Equipment Schedules List.

ClosedBulk Termination

Bulk termination is controlled on the Create Equipment Schedules tab of the Create New Rent Schedule window.

When you generate your asset schedules, any asset schedules with the Recalc? flag set to Yes will be recalculated. One of the recalculation triggers for an asset schedule is if the value of the Operational Status on the asset’s accounting assumptions record is anything other than Active. When you generate or recalculate your asset schedules, the system will ask: Since last schedule creation, some assets have changed to non-Active status. Do you want to terminate the asset schedules for them?

The system behaves as follows:

Dialog box response

Asset Operational Status

Recalc flag?

Action on that asset schedule

Yes

Active

N

No action

Yes

Active

Y

Recalculate

Yes

Not Active

Y

Terminate

No

Active

N

No action

No

Active

Y

Recalculate

No

Not Active

Y

No action

ClosedBulk Termination Example

As an example, if you recalculated the following asset schedules:

  • 100 active assets that have the Recalc? flag triggered by an expense schedule change and

  • 25 non-active assets that have the Recalc? flag triggered by a change in operational status,

Then:

  • Clicking Yes will recalculate the schedules for the 100 active assets and terminate the 25 non-active assets

  • Clicking No will recalculate the schedules for the 100 active assets and do nothing to the schedules for the 25 non-active assets

Delete a Lease Accounting Schedule

Change Accounting Period Status