The expirations report lists all leases scheduled to expire within a range of dates you specify.
Both base term expirations and last recognized option expirations (the “effective end date”) are displayed. Report options unique to this report:
Sort by expiration date
If unchecked (the default), leases are listed in lease number order. If checked, leases are listed in order of expiration date, and within each date by lease number.
List leases even if early terminated
If unchecked (the default), leases with an early termination type are excluded from the report. If checked, such leases are included based on the original expiration date (not the early termination date).
Include only contracted options
If checked, options that have the Recognize but not Contract box checked are excluded from the report.
The report is always run for a single period, so the Fixed dates choice allows you to get a report for one month, quarter, year, or 28- or 35-day period. If you wish to see leases expiring over a different length of time, use the Variable end date.
For each lease, the report lists the lease number, begin & end date, description, and classification.
If a lease’s base term or a recognized option expires during the period specified but it is followed by a recognized option, the end date is shown in italics.
--------------------------------------------------------------------------------------------------------------------
Your report title
Enter any title you want to give to the report. The type of report is always displayed at the top left corner; you can use this title to describe the report (such as “Midwest Division”).
Type of leases to use
You may limit the report to just the capital leases, just the operating leases, or use both (the default).
Sort by expiration date
If unchecked (the default), leases are listed in lease number order. If checked, leases are listed in order of expiration date, and within each date by lease number.
List leases even if early terminated
If unchecked (the default), leases with an early termination type are excluded from the report. If checked, such leases are included based on the original expiration date (not the early termination date).
Group of leases to use
You may choose All leases, a Group of leases starting with the same character(s), or a Single lease. If you choose Single lease, a popup displays the leases in the file; choose the one you want. If you choose Group, you are prompted for the beginning character(s) to search for.
Include only contracted options
If selected, options which have the Recognize but not the Contract box checked are excluded from consideration.
Output to
You can create a text report that displays on the screen (and which can then be exported in HTML, PDF, Rich Text Format (.rtf), Microsoft Word® (.doc), Microsoft Excel® (.xls), and Crystal Reports (.rpt) formats). Please note that the Excel output exported from a text report is laid out the same way as the text report, which is generally not well-suited for sorting and otherwise manipulating the data inside Excel. If you export a text report, please wait for the “Export completed successfully” message to display before continuing with EZLease.
You can also create spreadsheet output. This is specifically designed to manipulate inside a spreadsheet program; a report period is displayed on a single line, so you can select, sort, and sum results. The same information is provided as on the text report, but the layout is designed to facilitate data manipulation. The spreadsheet format includes all the fields shown in the text layout. If you select spreadsheet output, you are prompted to specify an output filename.
In System Options, you can select whether the spreadsheet output should be generated as an Excel .xls file, or as an XML-format spreadsheet. Output in Excel format requires that you have a licensed copy of Excel on your computer.
Starting date
Enter the beginning day of the first period of the report.
Ending dates
The report is always run for a single period, so the Fixed dates choice allows you to get a report for one month, quarter, year, or 28-day period. If you wish to see leases expiring over a different length of time, use the Variable end date.
Special options
Click this button to get a secondary screen which allows you to select special groups of leases and temporarily capitalize operating leases.