The following reports are available in EZLease:
- Income Statement/Balance Sheet Detail
- Income Statement/Balance Sheet Compact
- Amortization Schedules - Finance Leases
- Amortization Schedules - Operating Leases
- Asset Components
- Future Minimum Rents
- Journal Entries
- Depreciation over Economic Life
- Operating Leases Depreciation Verification
- Disclosures Table
When you create a report, you have several options regarding the type of report, leases to use, and output destination. Options grayed out cannot be changed, because they are dependent on other options you have selected.
If you choose a Text format report, the report is displayed on your screen. You then have the option of printing any or all pages, or exporting the report to a file in any of several formats.
Spreadsheet reports can be created in any of three formats: native Excel® .xls/.xlsx files, XML spreadsheet files, or .csv comma-delimited files. Creating output in Excel files requires the presence of a licensed and properly installed copy of Excel (version 2000 or later) on your computer. XML output does not require any other software present, and can be read by Excel 2002 (also called Excel XP) or later or a number of other spreadsheet programs, including OpenOffice Calc. You need Excel 2007 or later to create .xlsx files. Comma-delimited files contain no special formatting. (Please do not use Excel for other purposes in the middle of creating an Excel report in EZLease.)
Accounting reports can be run for one or many periods of any length. The classification and listing reports can be run for all leases or just those active on a particular date. All reports allow selections of subgroups of leases via the Special Options window.
The Income Statement/Balance Sheet (both Detail and Compact), Journal Entries, Depreciation Over Economic Life, and Expiration reports all require entry of report period dates. The Amortization, Future Minimum Rents, Classification, Current Rent, and Listing reports ask for a single date, “Active as of date.”
Report Period Dates
Select Fixed if you want one or more whole calendar periods: months, quarters (3 months), years, 28-day (4-week) periods, or 35-day (5-week) periods. Select Fiscal to use fiscal periods (calendar months or 4- or 5-week periods based on your company’s calendar). Select Variable if you want to enter each report end date.
If you choose Fixed, select which type of period (months, quarters, years, or 28- or 35-day periods) and how many of those periods you want. The end date of the last report period is automatically calculated and displayed. The default is 1 month. You may enter up to 999 periods.
If you choose Fiscal, the fiscal date pattern you specified in System Options is used. Specify the starting fiscal period, then whether the report period(s) should be a single fiscal period each, a fiscal quarter, or a fiscal year. The start and end dates for the entire report are shown immediately below. The default is the current fiscal period.
If you choose Variable, you may enter any number of end dates. If you wish to enter more than one date, press Enter once you have completed a date entry, and another date appears. Dates are immediately sorted if you enter a new date that is earlier than the previous date. To delete a date, click on it to highlight it, then press Delete.
See Entering dates for ways and shortcuts to enter dates.