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.
|
||||||||||||||||||||||||||
7 |
Click the Account numbering button, and continue to step 8. |
||||||||||||||||||||||||||
8 |
Follow the below steps, based on what action you need to perform:
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?
|
||||||||||||||||||||||||||
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?
|
||||||||||||||
6 |
Next, indicate whether any of the following options apply by selecting the corresponding checkbox:
|
Text Tab
Follow the steps below to configure User-defined fields (UDFs).
Step |
Action |
1 |
In System Options, click the Text 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 Selections tab):
Step |
Action |
1 |
In System Options, click the Fiscal Dates tab. |
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. Notes: 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. |