Skip to main content

Configuring System Options

This article discusses the following topics, as they relate to configuring EZLease System Options.

Configuring System Options

Before you import or enter any leases, you must configure your System Options. These options affect all users and may have already been configured by another user.

To configure these settings, click the File menu and select System Options.

EZLease offers multiple options to alter how the program runs and calculations are performed. These options are displayed over several tabs.

Important: For additional information about any of the fields referenced below, click on the portion of the field you interact with and press F1. (E.g., Click a drop-down, radio button, text entry box, checkbox, etc. and then press F1 on your keyboard to see help for that field.)

Password Protection

Since making changes to these options can, in some cases, alter reports, you have the option of locking the changes by entering a password. Once a password is set, any user of EZLease can view the System Options, but must enter the password correctly to make any changes.

The Password field is fixed at the top of the System Options window, and therefore present on all tabs.

Selections Tab

Follow the steps below to configure default selections:

Step

Action

1

When you access System Options, you land on the Selections tab.

In the Accounting methodology field, select the standard that you follow.

2

For compliance with the standards, the Number of separate years in future rent commitment report field defaults to 5.

If you wish to report a different number of years separately, increase this field to the appropriate number.

3

The Default depreciation method field defaults to Straight Line depreciation, which most companies use.

If you normally use a different method that EZLease supports, you may select it here and all new leases will automatically use that method.

Note: When you change this field, a pop-up appears asking if you want to change the depreciation method of all existing leases in the database to the new default method.

4

In the Accrual calculation period section, indicate whether depreciation is calculated monthly or daily.

Note: If monthly is selected, no depreciation is recognized on the 31st day of a month; all months are considered to have 30 days (in February, an extra two days of depreciation is applied on the 28th, or one extra day on the 29th in a leap year).

5

Use the Rent commitments by section to indicate how you define a “year,” either 12 months from the end date of the report or as the next fiscal year end.

Note: The Future Minimum Rent commitment reports show rent due for the next five years by year, then all remaining rent in the “Thereafter” group. (The number of years may differ if you made changes in Step 2.)

6

Next, indicate whether any of the following options apply by selecting the corresponding checkbox.

  • 360 Day Year for Rent & Interest Accrual - This option is only available if the Accrual calculation period is Month.

    • If unchecked, accrued rent and interest are divided evenly over the number of days in the current calendar month.

    • If checked, accrued rent and interest expense are calculated using 30-day months (with no activity on the 31st day of a month), which makes the daily activity the same whether a month has 30 or 31 days.

    Note: Checking this option makes for more consistent recognition of rent accrual, including operating rent expense on non-leveled leases when leases are paid in the middle of the month, but your normal report period end date is the end of the month.

  • Display executory cost types separately in future rent report - You may display up to five executory cost types and five non-lease component types. This option indicates whether the Future Minimum Rents report should show executory costs and non-lease components grouped together or by individual type. If unchecked, all executory cost types are combined.

  • Report lease incentives separately from rent - For FAS 13 and IAS 17, checking this box will amortize lease incentive amounts separately from rent, with their own accounts for income and balance.If unchecked, the lease incentives are subtracted from the overall operating rent due over the life of the lease, reducing the level rent recognized each period. In ASC 842, IFRS 16, and GASB 87 reporting, lease incentives are automatically included in the Right-of-Use Asset and this option has no effect.

  • Include future leases in future minimum rent commitments - If checked, a lease that has a booking date before the report end date and a begin date later than the report end date will be included in future minimum rent commitment reports. If unchecked, such leases are ignored; only leases active as of the report end date are included.

    Note: You must change the booking date on a lease before this selection will have any effect, as the booking date by default is the same as the lease’s begin date.

  • Smooth rent leveling - If checked, “cash rent paid” includes a prorated portion of the rent payment if the report period begins or ends in the middle of a rent payment period.If unchecked, cash payments are counted in full on the day of the payment.

  • Separate level rent from operating rent - Selecting this option will cause the Journal Entries report to show separate expense lines for the current cash and the level rent. The Income Statement/Balance Sheet Compact Report will also show the level rent as just the difference between cash and level rent.

  • XML spreadsheet output - If checked, spreadsheet output is created using the .xml spreadsheet format. If unchecked, spreadsheet output from reports is in the form of Excel spreadsheets using the .xls or .xlsx format.

    Note: Output to .xls and .xlsx spreadsheets requires a licensed copy of Excel on your computer, whereas XML output does not require any other software on your computer.

  • Open Excel to display spreadsheet output - If XML spreadsheet output is unchecked, you can check this box to have Excel open and display a spreadsheet as soon as it is created.

  • Report depreciation after lease expiration - If checked, it allows reporting that tracks depreciation after lease expiration on leases with depreciation over the economic life (leases with ownership transfer or reasonably certain purchase option).

  • Descending asset and liability balances in amort schedule - If checked, the Amortization Schedule - Finance Leases report shows the net asset (gross asset minus accumulated depreciation) and remaining obligation. If unchecked, it shows the accumulated depreciation and cumulative obligation paid.

  • Automatically open most recently used database - If unchecked, EZLease does not open any database automatically. You must select a database using File>New, File>Open, or the most recently used databases list before you can enter leases or run reports. If checked, the most recently used database will open automatically. If the attempt to open the database fails, EZLease reverts to running without an open database until you select another.

    Note: This option is not applicable in the Lite edition because only one database is permitted, and it is always opened automatically.

  • Descriptive fields in all spreadsheet output - This is intended for ease of sorting and selecting data in Excel. If checked, every spreadsheet report contains the description, Lessor name, asset class, financial group, and four user-defined fields at the end of each row (in many cases, the description is automatically part of the spreadsheet format and found at the beginning of the row; if that’s the case, it is not repeated at the end of the row).

 

7

Click the Account numbering button, and continue to step 8.

8

Follow the below steps, based on what action you need to perform:

If you Need to... Then...
Add a group Go to Step 9.
Delete a group
  1. Select the appropriate group from the Account number group drop-down and then click Delete Group.

  2. Click Yes to confirm the deletion.

  3. Click OK.

  4. Click OK to save and exit System Options.

Edit a group
  1. Select the appropriate group from the Account number group drop-down and then update the appropriate fields

  2. Click Save Group.

  3. Click OK.

  4. Click OK to save and exit System Options.

Note: Note: The account number group “(blank)” is provided to facilitate clearing all account number fields. This group cannot be deleted or changed.

9 Click Add Group, enter the name of the group, and then click OK.
10

Enter the account numbers that match your ERP into each field on all three tabs (Lease, Variable, and ARO).

Note: Each account number may be up to 50 characters in length.

11

Do you have any specific account numbers that contain a combination of a fixed number and a lease-specific code (such as a division code or cost center), separated by a dash or some other special character?

Yes
  1. The lease-specific value must first be stored in a list for one of the user- defined fields. Refer to the Text Tab and UDF Choices Tab sections below to set it up.

  2. In the Combination account number section, select either Prefix or Suffix (depending on whether you want the lease-specific value to appear before or after the fixed number).

  3. Make sure the fixed number portion of the account number has been entered in the appropriate field, and then check the box next to the account number(s) that are being updated. If you need to apply this combination to

    Yes    all of the account numbers, hold the Shift key and click the checkbox for another field to select all or de-select all.

  4. In the Separator field, enter the appropriate value (e.g., a dash).

  5. In the User-defined field, select the lease-specific value you set up in Step

  6. Go to Step 12 below.

No Go to Step 12.
12

If you want account numbers to appear on reports, check the Include account numbers on spreadsheets box at the bottom of the screen.

If left unchecked, account numbers chosen are still visible on the lease record but are not output (except on the Listing report).

13 Click Save Group.
14 Click OK.
15 If you wish to use tags, click the Configuration Options button.
16 Enter the tag name in the Option Tag field. (If it already exists, its current value appears in the Option Value field.)
17

Enter the desired value in the Option Value field and then click Save.

Note: Options are stored immediately; clicking Cancel on the System Options window will not undo these changes.

New Standard Tab

Follow the steps below to configure settings necessary for transition to the new standards (FAS 13 to ASC 842 for U.S. reporting entities, IAS 17 to IFRS 16 for entities complying with IFRS, or FAS 13 to GASB 87 for U.S. governments).

Important: To make mass changes to an existing database for the new standard, refer to EZL User Guide – Transition Accounting.

Step

Action

1

In System Options, click the New Standard tab.

2

In the Implementation date field, enter your effective date for the new standard.

3

In the Application date field (also known as the Transition date), enter your transition date to the new standard (for ASC 842 and GASB 87 only).

ASC 842: If following FASB ASU 2018-11, the comparative period date should be the same as the implementation date.

GASB 87: Requires the change to the new standard to be applied retroactively to prior periods presented “if practicable.” Specify the beginning of the prior periods presented as the application date. If restatement is not done, this date should be the same as the effective date above.

 

4

For the Default standard to use, indicate whether by default to use the old lease accounting standard (FAS 13 or IAS 17, depending on whether you chose U.S. GAAP/GASB or IFRS accounting methodology) or the new lease accounting standard (ASC 842, IFRS 16, or GASB 87).

This affects which classification you see when a lease is displayed, and which methodology is chosen by default when you create a report. (You may select the alternative choice once the lease or report setup window is displayed.)

5

Are you following ASC 842?

Yes

A FAS 13 lease with capital building and operating land components must be split into two separate records for reporting under ASC 842, because the new finance and operating lease assets and liabilities must be reported separately.

When you split the lease, if there is any contingent rent on the lease, this setting determines how the contingent rent (variable lease payments) is automatically split between the new land and building records.

Enter the appropriate percentages for building and land.

No Go to Step 6.
6

Next, indicate whether any of the following options apply by selecting the corresponding checkbox:

Field Description
Display executory costs

Indicates whether to display executory costs both on the lease input form and on reports. Generally, this should be turned on for as long as you have active leases with executory costs.

Leases that began before the transition date to ASC 842, IFRS 16, or GASB 87 keep reporting executory costs to the end of their lease term, unless they are modified.

Important: You must display either executory costs or non-leasecomponents; you may choose to display both.

Display non-lease components

Indicates whether to display non-lease components, both on the lease input form and on reports. Generally, this should be turned on as soon as you start entering leases with non-lease components, which is required after the effective date of ASC 842, IFRS 16, and GASB 87.

Important: You must display either executory costs or non-lease components; you may choose to display both.

Prompt to confirm classification

Since ASC 842 is "principles-based," rather than "bright-line," you may want to review and potentially override the classification of each lease as it is entered.

If checked, each time you save a new lease or make a financial change to an existing lease, EZLease displays the results of the classification process (using the FAS 13 75% and 90% tests for finance vs. operating, though based on the ASC 842 definitions of rent and other numeric inputs) and allows you to override the result.

Note: This is the same as editing the lease and changing the classification.

Full retrospective implementation

This field is for IFRS only.

IFRS users have the option to restate all leases using IFRS 16 accounting from inception, or to implement as a transition at the implementation date.

If checked, the effect of applying the new standard (such as differing assets and liabilities recognized) is recorded as an adjustment to retained earnings.

Enable low value

ASC 842 and GASB 87 users may choose to use the Low Value classification for immaterial leases. If checked, the Threshold for low-value assets field appears.

Once enabled, you can mark individual leases as Low Value.

Note: This option does not appear for IFRS 16, since Low Value is part of that standard.

Threshold for low-value assets

Enter a threshold maximum for low-value assets.

Note: For IFRS users, low-value asset leases are treated like IAS 17 operating leases, with rent usually recognized on a straight-line basis. If you do not wish to use the automatic Low Value classification, enter 0 for the threshold.

Text Tab

Follow the steps below to configure User-defined fields (UDFs).

Step

Action

1

In System Options, click the Text Tab tab.

2

In the Maximum interest rate field, indicate the rate at which EZLease should display a warning message if a rate higher than this number is entered for the incremental borrowing rate, implicit rate, or a user-classified discount rate.

Note: You may still enter whatever rate you wish, but this reduces the potential for inadvertent errors.

3

Enter the number of fields you wish to display on reports and screens within EZLease for the following:

  • Number of user-defined fields to display (up to 20)

  • Number of executory cost types to display (up to 5)

  • Number of non-lease component types to display (up to 5)

    Note: If you choose zero for the executory cost types or non-lease component types fields, the “Display” boxes on the New Standard tab will be automatically unchecked.

4

If you want to change the text labels for any of the above-mentioned fields, type your text labels in the fields provided. The changes will then appear on reports and EZlease screens.

Example: To change “User-defined field #1” to “Division”, you would type Division in the text box next to that label.

5

If desired, you may also change the text labels for the User-defined date or Variable pmts fields.

6

EZLease is registered to your company and the company name appears on all reports. Since company names can change, you may enter a different name in the Displayed company name field.

Important: Giving EZLease to another company while continuing to use it yourself is a violation of copyright law.

7

If you wish to move the default location for the System Options file, you can type the path or browse for it in the Options store location field.

Note: This is primarily intended for EZLease users with multiple seat licenses, so they can share a common set of options, but may also be useful to make sure the settings file is backed up regularly.

Notice Dates Tab

Follow the steps below to configure notices that will appear on the Notice Dates report:

Step

Action

1

In System Options, click the Notice Dates tab .

2

If you want the Notice Dates report to include all current notices each time a database is opened, check the box next to Check dates each time EZLease opens a database.

3

If you want the Notice Dates report to include notification that the rent is scheduled to change, check the box next to Notify of rent changes.

Use the accompanying fields to specify how far in advance and how long after the scheduled change the notice is displayed.

4

If you want the Notice Dates report to include notification that a lease is scheduled to expire, check the box next to Notify of Expirations.

Use the accompanying fields to specify how far in advance and how long after the expiration date the notice is displayed.

Note: If a lease is terminated early, no notice is generated.

5

If you want the report to include notification that an ARO is going to end, check the box next to Notify of ARO ends.

Use the accompanying fields to specify how far in advance and how long after the ARO end date the notice is displayed.

6

You can turn the notice date Display flag on or off for each rent step, lease end date, and entered notice in the entire database by unchecking the appropriate box on the lease record.

However, if you want to reset all of the Display flags for every lease in the database, select the desired Display flag in the Reset all drop-down and choose the appropriate option (Display or Don’t Display).

Clicking Display will make those notices appear on reports and Don’t Display will remove them from reports.

Note: This change takes place immediately; clicking Cancel on the System Options window will not undo the change.

Fiscal Dates Tab

Follow the steps below to configure your fiscal calendars or periods (which are used to calculate dates on reports if you selected Fiscal Year in the Rent commitments by field on the Selectionstab):

Step

Action

1

In System Options, click the Fiscal Datestab.

2

Select the appropriate fiscal option (if not already selected). If you need additional information, click on the option, and then press F1.

If none of the options properly describe your actual calendar, please contact EZLease so we can understand your situation and potentially adjust the software accordingly.

Note: When changing from the default option to another, you may receive an “accrual calculation changed” message. Click OK.

3

If you changed the fiscal option, be sure to adjust any accompanying fields for the option selected.

4

Verify the Preferred report dates selection is correct; change if necessary.

5

Review the Next 5 fiscal year end dates section at the bottom of the screen to verify it’s accurate and make changes to the fields above if necessary.

UDF Choices Tab

By default, user-defined fields (UDFs) allow you to enter up to 100 characters of descriptive information, while asset class and financial group fields allow 50 characters.

If you wish to configure your UDF, asset class, or financial group fields as drop-down lists, follow the steps below:

Step

Action

1

In System Options, click the UDF Choices tab.

2

In the Use selection lists for section, check the box next to the field that you want to convert to a list (or make changes to the existing list).

3

In the Valid choices for section, place your cursor in the blank field and enter the first option in the list.

If changing existing values, simply double click the value and modify the text.

4

Press Tab to enter the next option and continue repeating until the list is complete.

Important: Be careful if you click outside of the list entry table. If you click to the left of it, you’ll likely check a box for another field, and your list values will no longer be visible until you unselect it and re-select only the field you were working on.

Note: To populate a list with all values in the current database for the field, hold down the Shift key and click on the checkbox for the field.

ARO Tab

Follow the steps below to configure options for calculating your Asset Retirement Obligations (AROs):

Step

Action

1

In System Options, select the ARO tab.

2

In the Accretion compounding section, indicate whether your AROs are compounded on a Daily basis or Monthly.

Note: The best choice is usually dependent on your fiscal calendar. Week-based fiscal calendars should use Daily, while a period that ends the same day of the month each month should use Monthly.

3

In the ARO rates shown section, indicate whether the inflation rate and the credit-adjusted risk-free rate are shown as Pre-compounding or Post-compounding.

4

For AROs with a begin date that is not the first day of the month, you can use the Start calculating ARO expense section to indicate whether to start calculating ARO expenses (ARO accretion and ARC depreciation) on the first day of that month, or on the begin date.

5

If you enter the options on a lease, you can have EZLease test AROs to see if their cost is high enough to impose an economic penalty that compels renewal of the lease for some or all of the options.

To turn this on, select the Check ARO for economic penalty compelling lease renewal box.

Note: The test applies only to AROs that are attached to actual capital or operating leases. If an ARO is attached to an ARO-only record, the end date of the base record is automatically extended to cover the entire useful life of an attached ARO.

6

If you wish to require recognizing options that cover a specific percentage of the useful life of an ARO’s associated asset (or at least the number of months specified, whichever is less), enter the percentage in the Cover at least % of useful life field or the number of months in the or cover at least months field.

7

If you want EZLease to skip minimal AROs that have a current cost less than a specified amount, enter the amount in the Skip test if less than field.

Note: If the percentage or months are zero, that test is skipped and only this test applies.

8

Next, indicate if you want to Continue to accrete ARO after scheduled end date using inflation rate.

If checked, ARO accretion continues, using the ARO’s inflation rate as the interest rate to calculate accretion. The asset side remains at zero after the scheduled end date either way (unless you change the end date).

If unchecked, the ARO liability does not change after the ARO end date is reached, though it remains on the books until the ARO is explicitly terminated.

9

If you only want to recognize inflation-based ARO accretion after the ARO end date until a specific date, enter the date in the Stop after-end-date accretion effective field.

10

If you need to enter credit-adjusted risk-free rates to be used for accreting the ARO, you will use the Accretion rates table.

To enable this option, IFRS users should check the Recalculate accretion when rate changes (IFRS) box. Other users should leave the box unchecked.

In the table, enter the rate in the Accr Rate field and also the Effective Date.

Note: If you need to delete a rate change, change the rate to 0 and EZLease will confirm that the change should be deleted. You may also create a spreadsheet with the contents of this table by holding the Ctrl key and clicking on the checkbox.

11

If you have different accretion rates for different divisions of your company (most commonly used for countries), check the Group specific rates using box.

Result: A new column titled Group appears in the table.

12

If you have a user-defined field (UDF) set up for the group of divisions, select it from the drop-down that appears next to the Group specific rates using box. Now in the table, you can select the appropriate division from the list of options.

If you do not have a UDF set up, click in Group column for that rate and select the asterisk

from the list of options. You will use this value for any groups that do not have UDFs.

Note: The * catch-all group is only used if there are no entries at all in the rates table for the lease’s group. If the rate changes at the same time for a named group and the * catch-all group, you need to enter two separate rate records.

Was this article helpful?

We're sorry to hear that.