Skip to main content

Reporting - Special Options

When running reports, users can click the "Special Options" button, at the bottom-left of the Report Options window, to get a secondary screen which allows you to select special groups of leases and make other alterations to a report.

For all selection options except lease numbers and dates, if you check the box, a list pops up showing all the values found for that field in the current database; you may select one or more values to match on. If you choose multiple selection options, a lease must match all selection criteria to be included.

Field

Definition/Format

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, in 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.

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.

Exclude Month to Month

Check the box to exclude leases that have expired but are active as month to month leases.

Treat AROs as Expiring on Scheduled End Date

AROs normally continue until explicitly terminated (and optionally continue to accrete the liability after the scheduled end date; see the System Option “Continue to accrete ARO”).

Check this box to treat all AROs as normally terminating on their scheduled end date. This is particularly useful for projection reports, which may be skewed by keeping the AROs active indefinitely.

User-Defined Dates 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.

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.

Use Revisions

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 "as of” date.

Combine rent for linked leases

This option is found on the Special Options window. It combines the rent for linked leases (usually finance and operating components of a single billed lease).

Note: Only applicable to Listing reports and Current Rent reports.

User-Defined Fields

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.

Was this article helpful?

We're sorry to hear that.