ASC 842, IFRS 16, and GASB 87 have a series of required quantitative disclosures which the standards say should be presented in tabular form. While all of the information is available on other reports, this report brings everything together. ASC 842-20-55-53 provides an example of its needed disclosures, while IFRS 16 lists the required items in paragraph 53, and GASB 87 lists its disclosure requirements in paragraph 37.
This report can be run for one or more comparative years. Enter the dates for the period desired during the current year, then the number of comparative years, which precede the current year (1 meaning the current year only, 2 meaning the current and 1 previous years, etc.). A reporting period for the disclosures table may not be more than one year (a full fiscal year is permitted even if it is 53 weeks long). Enter the dates for the current year, not a comparative year. So, if you enter 1/1/2020 as the start date and 3/31/2020 as the end date with 2 comparative years, you will get a column for 1/1-3/31/2019 and a column for 1/1-3/31/2020.
--------------------------------------------------------------------------------------------------------------------
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 “Period 2, 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). This option is not displayed for reports that include only capital or only operating leases. If a lease is part-capital, part-operating, the appropriate portion is included if you choose one or the other.
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.
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; each account of a journal entries transaction 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 considerably different to facilitate data manipulation. 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
Select Fixed if you want one or more whole calendar periods: months, quarters (3 months), years, or 28-day 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-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.
Comparative years
This report can be run for one or more comparative years. Enter the number of comparative years, which precede the current year (1 meaning the current year only, 2 meaning the current and 1 previous years, etc.).
Special options
Click this button to get a secondary screen which allows you to select special groups of leases and temporarily capitalize operating leases.