To display this screen of options, click the Special options button of any report setup screen.
If you choose multiple selection options, a lease must match all selection criteria to be included. For the selection options other than lease numbers, a list of all current values for the field pops up. Check the boxes of one or more values that you want to match on for that field.
Select only lease numbers starting with
Enter one or more match items. If you enter a single match item, the result is the same as selecting a group of leases in the main report options screen, but this option allows you to select leases that match any of several starting values, of varying lengths. Separate multiple items by commas.
Select only leases with asset classes, with financial groups, with account number group, with lessor name
Select one or more asset classes, financial groups, account number groups, or lessor names to match on, from the list of all values found in your database.
User-defined date 1, 2
If you have set a title for the user-defined date fields in System Options, that title will be displayed here. Select a date to match on.
Case sensitive matches
If this box is checked, then all of the matching conditions above require the exact case to match, so “a” is not a match for “A”. If this box is unchecked, all matching conditions are case-insensitive.
Operating lease classification
In some cases, you may wish to treat operating leases as capital. This is sometimes required by lenders; it is also similar, though not identical, to the treatment of leases under ASC 842/IFRS 16/GASB 87. If you wish to capitalize operating leases, you may do so in either of two ways: using the incremental borrowing rate entered for the lease, or using a fixed rate for all leases. If you choose the incremental rate, but a lease does not have an incremental rate entered, EZLease uses the “fixed rate” entered here, if any; otherwise, the lease is capitalized at 0% interest (that is, no present valuing of the rents is done).
Setting operating leases capital in this way allows you to calculate the Present Value of Operating Leases (PVOL). The PVOL is the sum of the current obligation, long term obligation, and accrued interest at any given date, and can be found on either of the Income Statement/Balance Sheet reports (Detail and Compact). The spreadsheet output for IS/BS Detail shows this in a column titled Net Present Value.
You can choose a cutover date, as of which the remaining rents for each lease are capitalized, with all rent prior to that being ignored. Note that if you specify a date here, no activity of any sort (capital or operating) is shown before this date for the operating leases that are being capitalized.
This method was provided in the software before the finalization of ASC 842/IFRS 16/GASB 87. Do not use it to calculate actual accounting under the new standard, since it is not fully consistent with the new standard; instead, choose the new standard as the accounting method for the report on the main report setup window.
Operating lease selection
ASC 842/IFRS 16: Short term and low value leases are considered varieties of operating leases for selection purposes. You may choose to include any or all of operating (not IFRS 16), short term, and low value (IFRS 16 only) leases.
You may choose to select only leveled leases or only non-leveled leases. The default is to use all operating leases for a report. "Non-leveled" applies both to leases with a single rent step and to those whose level operating checkbox is turned off. This selection checks the operating portion of split capital/operating (land & building leases); for instance, if the land portion is leveled (which happens only when there is a rent holiday, or there is a deferred rent rollover), the entire lease is excluded if only non-leveled leases are requested.
Exclude month-to-month leases
Check the box to exclude leases that have expired, but are active as month-to-month leases.
The default is All. Choose Final to use just the final revision for the lease (i.e., treat the lease as if it had always been accounted for using the current data). Choose Historical to use the revision that was active on the “Active as of” date.
If you have set a title for the user-defined fields in System Options, that title will be displayed here. As with the other match options, select one or more choices to match on.