Overview
EZLease empowers users to efficiently manage leases, and entering lease data is a breeze. There are a few ways to add a lease in EZLease; manually entering the lease data from scratch, copying an existing lease and making appropriate changes, or bulk uploading a group of leases. In this article, we'll guide you through the process of manually entering leases in the user-interface (UI).
For more details on bulk uploading leases, see: Bulk importing new leases
Entering a lease manually in the user-interface
To manually enter a new lease in EZLease, click the Lease menu at the top of the screen and select New, or click the blue Add New Lease button:
There are multiple tabs and fields on this screen that you will use to enter the appropriate lease information. Some fields will default to specific values based on the System Options that were configured, but you may change them if necessary.
While best practice is to enter all of the lease information available on these tabs, in the steps below we will focus primarily on required fields.
Note: All required fields are on the main data tab.
Reminder: If you have questions about when or how to use fields on any of the tabs, click in the fields and press F1 on your keyboard for additional information.
Adding Leases - Video
In this video:
- Adding leases manually - 00:11
- Adding leases using the bulk import template - 08:32
- Required fields - 08:48
Main Data Tab
Follow the steps below to complete the Main data tab.
Step |
Action |
1 |
Enter the Lease Number and a Description. Note: The Description field is optional, but highly recommended. |
2 |
Typically, you should leave the Classification drop-down as To Be Classified, which allows the system to classify the lease. If you want to explicitly classify the lease, check the "Manually classify" checkbox, and select the appropriate classification. |
3 |
If this is a manually-classified finance lease, enter the Discount Rate as a percentage. Example: 10% would be entered as 10. |
4 |
Select the Begin Date (lease start date) and Base End Date (lease end date). Note: If you don’t know the end date, you can double click the Base Term field, enter the lease term in months and then click OK and it will auto-calculate. |
5 |
Update the Original Booking Date, as needed. This field determines when the lease entries will appear in reporting. By default, the Original Booking Date is the same date as the Begin Date. If you need the lease to be recognized for reporting purposes as of a different date, enter that date in this field. Note: Use a date later than the Begin Date if you didn't receive the information on the lease until later, and reports were run for intervening periods. If the lease is signed but use of the asset is delayed to a later date, enter a date earlier than the Begin Date. |
6 |
If this is a system classified lease (meaning you left the Classification as To Be Classified), enter the Incremental Borrowing Rate (IBR). |
7 |
Add a Transition Incremental Borrowing Rate - Applies only to leases that are operating under FAS 13/IAS 17. This is the incremental borrowing rate at the transition date (the date the lease transitions from the old standard to the new, usually 2017 for U.S. preparers and 2018 for IFRS preparers). The lease will be capitalized using this rate as the discount rate for the lease (the Right-of-Use asset and initial liability will be the present value of the rents at this rate, with possible adjustments to the asset for rent leveling, prepaid or accrued rent, and initial direct costs). |
8 |
In the Current Economic Life field, enter the estimated economic life of the asset in months. |
9 |
In the Rent steps table, enter the gross rent due for each payment, per full payment period in the Gross Rent field. Be sure to include any executory costs and non-lease components but exclude variable lease payments. To add Rent Escalation, click Lease -> Rent Escalation System automatically computers a percent/dollar rent increase and generate rent steps in the background…In the pop-up window, specify start/end dates, frequency, initial amount, increase %/$ |
10 |
If there’s an executory cost included in the Gross Rent, enter that amount in the Exec cost #1 field. If the Gross Rent is negative, any executory costs must also be negative. You may choose to combine all executory costs into a single amount or enter up to five different executory costs (to see those columns in the table they must be configured in System Options on the Text tab). Note: Do not enter executory costs which you pay directly to a third party, rather than through your rent. |
11 |
If there are multiple rent steps, use the last row in the table to continue adding those amounts and make sure to adjust the Step End dates and Pym Frequency accordingly. Note: You may enter an unlimited number of rent steps. They can be entered in any order and then sorted by the Step End date. |
12 |
Enter the fair market value in the Fair Value of Building/Equipment field. Note: This field is not required if the lease is user-classified operating or capital. If it is part land and part building, enter the building portion here and the land portion in the Fair Value of Land field. If it is not possible to determine a fair value for an asset, leave the Fair Value fields blank and check the Far Value Not Determinable box. ASC 842-10-15-29 permits combining the land and building if “the accounting effect of doing so would be insignificant.” To do so, check the Combine Land and Building for Classification checkbox. |
13 |
If the lease is partly or completely land, enter the fair value of the land portion of the leased assets in the Fair Value of Land field. Note: This field is not required if the lease is user-classified operating or capital. |
For more information about this tab, please see: Main Data Tab
Additional Data Tab
Follow the steps below to complete the Additional Data tab. A lot of the fields mentioned below are optional, or only required if applicable.
Step |
Action |
1 |
Click the Additional Data tab. |
2 |
Optional: In the Lease Incentives field, enter any landlord incentives for construction or leasehold improvements (payments made to you or on your behalf which should be amortized over the life of the lease). Enter such incentives as a negative number. See Lease Incentive (Tenant Allowance) for more. |
3 |
Optional: Enter any Initial Direct Costs. If IDC is entered for a lease that starts before the new standard effective date, IDC is first recognized as of the transition date. See Initial Direct Costs (IDC) for more. |
4 |
Enter Lessee's Guaranteed Residual. See Guaranteed Residual for more. |
5 |
Optional: Enter an Expected Guaranteed Residual Payment if applicable. See Expected Guaranteed Residual Payment for more. |
6 |
Optional: Enter an Unguaranteed Residual Value. See Unguaranteed Residual Value for more. |
7 |
Verify the Amortization Method is correct and change if necessary. Note: A capital lease should be depreciated over its economic life if it has an ownership transfer or reasonably certain purchase option at the end of the lease. Otherwise, it should be depreciated over its lease term. See Depreciation Method for more. |
8 |
Select Lease Term or Economic Life for Amortization Life. |
9 |
Optional: Check the Transfer addition checkbox. See Transfer addition for more. |
10 |
Optional: Enter an Asset Adjustment - an amount to be added to or subtracted from the right-of-use asset at initial setup. This can be either a positive or negative value. See Asset Adjustment for more. |
11 |
Optional: Enter a Salvage Value. See Salvage Value for more. |
12 |
Optional: Enter a Deferred Rent Rollover. If you early terminate an operating lease with rent leveling, there will be a termination gain or loss. If the terminated lease is being replaced by a new, related lease, you may want to roll over the gain/loss into the new lease, rather than immediately recognizing it. Enter a rollover of a deferred liability (a gain, the most common situation) as a negative and a rollover of a deferred asset (a loss) as a positive; an inverse loss or gain will be recognized at the start of the new lease, balancing the original lease’s gain or loss. This can also be used to amortize landlord incentives for construction or leasehold improvements (payments made to you or on your behalf which should be amortized over the life of the lease). Enter such incentives as a negative number. See Deferred Rent Rollover for more. |
13 |
Optional: Check the Asset in service prior to lease checkbox if the asset was previously in service. You may enter an in-service date and the original economic life, in which case EZLease will calculate the remaining life, and automatically determine if the lease starts in the last 25% of the asset's economic life. |
14 |
Optional: The Original Economic Life of the asset. This is used in tandem with Asset in Service Date; when entered, EZLease will calculate the remaining life, and automatically determine if the lease starts in the last 25% of the asset's economic life. |
15 |
Optional: Linked Lease allows you to link two leases together so that you can see the rent combined. This is most commonly used for a lease which has land and building components, where the land is treated as operating and the building as finance. Since ASC 842 requires operating and finance leases to be reported separately, the two pieces must be separated. If you link this lease to its mate, you can view the combined rent for both by clicking on the Combined Rent button. You can optionally combine the rents for a Listing report or Current Rent report on the Special report options window. Please see Linked Lease for more. |
16 |
Optional: The Show Combined Rent button is only active if this is a linked lease (see previous step). Clicking on it shows the rent for the lease displayed and its linked lease. If the rent schedule (when the rents change, or the payment frequency) is inconsistent for two linked leases, it may be impossible to display a combined rent report. |
17 |
Required if applicable: If the lease agreement conveys ownership to you at the end of the lease term, check the Ownership Transfer box. Note: If you user-classify the lease operating, this box cannot be checked. See Ownership Transfer for more. |
18 |
For ASC 842/IFRS 16, if you have an option to purchase the underlying asset and are reasonably certain to exercise (not limited to reasons of option price), check the Reasonably Certain Purchase Option box and on the Main data tab, enter the purchase price in the Lessee’s Guaranteed Residual field. See Reasonably Certain Purchase Option for more. |
19 |
If you are renewing a lease or leasing a used asset and previous use of the asset has covered 75% or more of its original economic life, check the Last 25% of Economic Life box. See Last 25% of Economic Life for more. |
20 |
Optional: IAS 17 has, and ASC 842 introduces, a fifth test for whether a lease should be capitalized: "The underlying asset is of such a specialized nature that it is expected to have no alternative use to the lessor at the end of the lease term." [ASC 8420-10-25-2(e)] While one would normally expect such a lease to meet other criteria as well, check this box if appropriate. Any lease with the Specialized asset box checked is considered a finance lease. See Specialized asset for more. |
21 |
If applicable: Uncheck the Payments in Advance box if the payment is made at the end of the period (payments in arrears, much less common but used for some leases, primarily real estate). By default, this box will be checked if the rental payment is made at the beginning of each payment period as this is the most common scenario. See Payments In Advance for more. |
22 |
Optional: Level Operating Rents See Level Operating Rents for more. |
23 |
Optional: By default, the Specified Right-of-Use-Asset box is checked. In almost all cases, you should let EZLease determine the right-of-use asset value for finance leases. Please see the following article for information on scenarios where you should uncheck this box: Specified Right-of-Use Asset. |
For more information, about this tab please see: Additional Data Tab
Term/Options Tab
Follow the steps below to enter renewal options on the Term/Options tab.
Important: You should enter all renewal options, regardless of whether you expect to exercise them.
Step |
Action |
1 |
Click the Term/Options tab. |
2 |
In the Renewal options table, check the Recognize box if the option should be included in the minimum lease term because it has already been exercised, exercise is “reasonably assured,” or it meets the other criteria of FAS 13, ¶5f. Note: EZLease automatically checks the boxes of earlier options or unchecks the boxes of later options when you check or uncheck this box. |
3 |
If the contract has been signed for the option, check the Contract box. Note: If this box is checked, Recognize is automatically checked. EZLease automatically checks the boxes of earlier options or unchecks the boxes of later options when you check or uncheck this box. |
4 |
The Begin date of the option is set automatically. The first option begins the day after the Base End Date of the lease. Each additional option begins the day after the prior option ends. |
5 |
By default, the first option runs for five years. Change the End date as needed. Note: After you set the first option’s end date, the next option by default has the same length as the option preceding it. |
6 |
If you leave the Notice box checked, the Notice Dates report will display a notice when this option is scheduled to expire, just like the expiration of a lease (assuming that you have set the System Option to display expirations in the report). |
For more information about this tab, please see: Terms/Options Tab
Descriptive Tab
Follow the steps below to enter descriptive information or add picture attachments on the Descriptive tab:
Step |
Action |
||||
1 |
Click the Descriptive tab. |
||||
2 |
The Lessor information fields are optional but completing them will allow you to select leases to report on based on Lessor name. |
||||
3 |
The Asset Class and Financial Group fields can be used for selecting subgroups of leases for reports. If you choose to use this functionality, enter the desired information (up to 50 characters). |
||||
4 |
The user-defined fields can be used to hold whatever information you want (up to 100 characters each). Note: You can select leases that contain particular entries in any of these fields when you run reports. These fields are also configurable if you would like to choose from a list of values. (Refer to User Guide – Configuring System Options for additional detail.) |
||||
5 |
You can use the user-defined date fields to store additional dates. This allows you to select leases that match the date shown when you run reports. |
||||
6 |
Do you need to add any attachments to the lease record?
|
||||
7 |
If you wish to add a memo to the lease record, click Add/Edit Memo. Enter the appropriate information and then close the window. You’ll receive a prompt to save or discard the changes. Example: You can capture who is responsible for the lease, any arm’s-length renewal options (not included in the original lease term), or anything else you deem necessary. |
||||
8 |
The Last Update: and by: fields show which user most recently made changes to this lease, and on what date. |
For more information about this tab, please see: Descriptive Tab
Acct Numbers Tab
Follow the steps below to assign the appropriate account number group to the lease:
Step |
Action |
||||
1 |
Click the Acct Numbers tab. |
||||
2 |
From the Account Group drop-down, select an existing account number group or leave the field blank. You can manually customize the account numbers for this lease by checking the Customize checkbox and entering the appropriate account number(s). Note: For variable lease payments, the Var payments field is used in reporting for the cash credit. The other seven fields are for the debits to various expense accounts.
Is there an existing account number group you wish to use for this lease?
|
||||
3 |
Click the Account Group drop-down. |
||||
4 |
Select the appropriate account number group from the list. |
||||
5 |
Do you need to change any of the account numbers?
|
For more information about this tab, please see: Account Numbers Tab
Variable Tab
Follow the steps below to record variable lease payments on the Variable tab.
Important: Variable payment amounts can be positive or negative. A negative number indicates that rent was estimated based on a rate (such as an interest rate) in effect at the inception of the lease, and the rate later decreased.
Step |
Action |
||||
1 |
Go to the Variable tab. |
||||
2 |
Which of the following do you need to enter?
|
||||
3 |
Enter the amount of the variable payment in the appropriate field. |
||||
4 |
Enter the date the variable payment is made in the Pmt Date field. Note: If you specify a date when no rent is scheduled to be paid, EZLease finds the closest rent payment date and offers it as an option. Because variable payments may happen out of cycle with the regular payments, you can choose to keep the date you entered. |
||||
5 |
If you need to enter additional variable payment amounts, use the last line to create them. Make sure to enter amounts in the correct fields and adjust the Pmt Date accordingly for each payment. |
For more information about this tab, please see: Variable Lease Payments Tab
ARO Tab
Follow the steps below to enter any Asset Retirement Obligations (AROs).
Note: If you have an ARO that is not actually connected to a lease (that is, an ARO connected to an owned asset), you may set up a lease record with classification type ARO Only and leave the rent and other lease-specific information blank.
Step |
Action |
||||
1 |
Click the ARO tab. |
||||
2 |
Click the Add ARO icon. Result: The ARO tree appears, which contains a layer. |
||||
3 |
Do you expect to retire the asset in stages and settle the ARO at each step?
|
||||
4 |
Enter the ARO Name. |
||||
5 |
Select the appropriate Depreciation Method. |
||||
6 |
If the ARO is known but not required, you can uncheck the Required? box. Note: If unchecked, values for the ARO will be calculated and displayed on screen, but not included in any actual reports. |
||||
7 |
If desired, enter a Layer Name. |
||||
8 |
By default, the Display End Notice box is checked, and the Notice Dates report will display a notice when the ARO is approaching its scheduled end date (if enabled in System Options). Note: You may uncheck it if you don’t need to see the notice on the report. |
||||
9 |
For the Begin Date, enter the date the retirement obligation was identified. Note: This date cannot be earlier than the lease Begin Date. |
||||
10 |
For the Booking Date, enter the date the ARO should be recognized on your books. Note: This date cannot be earlier than the lease Begin Date. |
||||
11 |
Do you want to specify the ARO end date as a number of months (useful life) or as a particular end date?
|
||||
12 |
Enter the assumed inflation rate between now and when the ARO will be satisfied (at the end of the lease or use of asset) as a percentage in the Inflation Rate field. |
||||
13 |
Enter the credit-adjusted risk-free borrowing rate for present valuing the ARO from the end of the lease to the present as a percentage in the Credit Adjusted Risk-Free Rate field. |
||||
14 |
If the requirement or cost is uncertain, you may enter a Probability of less than 100%. This can be used either to reflect a possibility that the ARO will not need to be paid, or a range of estimates. (E.g., 30% chance of $10,000, 50% chance of $15,000, or 20% chance of $25,000) |
||||
15 |
Enter the current cost to remove the asset in the Current Cost field. Note: Alternatively, you can enter the expected future cost and specify an inflation rate of 0%. |
||||
16 |
If you need to set up the ARC asset at inception at a different value than the ARO liability, enter the amount by which the asset should vary from the liability in the Asset Adjust field. Example: If the liability is $10,000 and the asset should be $8,000, enter -2,000. |
For more information about this tab, please see: ARO Tab
Notice Dates Tab
Follow the steps below to enter reminders, for a specific lease, that EZLease will then display on the Notice Dates report.
Note: EZLease automatically displays notifications of rent changes and lease expirations (if configured in System Options). This tab allows you to enter any other desired notices for a lease.
Step |
Action |
1 |
Click the Notice Dates tab. |
2 |
Enter the desired notice Description. |
3 |
Select the appropriate Notice Start and Notice End dates to indicate when it should be included in a Notice Dates report. |
4 |
By default, the Display box is checked, and the notice is included in the Notice Dates report. Note: You may uncheck it at any time if you no longer need to see the notice on the report. |
5 |
The Display End Date Notice box is also checked so EZLease will notify you when the lease expiration is approaching (if configured in System Options). Note: You may uncheck it if you do not need this notification. |
For more information about this tab, please see: Notice Dates Tab
After ALL required fields have been completed on each of the above-mentioned tabs, click Save Lease. EZLease rechecks to make sure you haven’t missed any required information and that no entries are inconsistent with each other. If there are no errors, the lease is classified (if not User classified), and the Discount Rate and Right-of-Use asset (if finance) are displayed.
Related links
Adding Leases | Video: Bulk Import | Key Data fields for lease abstraction | Video: Sustaining compliance