GL: Comparative Income Statement
Overview
The Comparative Income Statement consists of the item amounts from two of a company's statements arranged side by side in a single statement, with dollar changes and percentage changes shown in the additional columns. The Comparative Income Statement compares a selected period with the same period from last year.
To print an Income Statement for the current year select the Exclude Last Year Totals check box.
You can filter, group, and print by Tiers, allowing for total customization of the report. To make filtering easier, for any Tier, you can include All, Pick/Create or Exclude parameters. Using Tier Templates to set up and save report templates makes it easy to generate a specific report each time you need it, without having to recreate the criteria. See Using Tier Templates for more information.
In addition, you may also include budgeted figures for each line item, Current, and YTD.
It is important to note that when using Dated Tiers that are in the middle of the month, the budget amount will go to the tier at the beginning of the month, rather than the tier selected for the remainder of the month.
Key Functionality
Type a description to name the report. This description prints above the Report Title.
The Default Company Name for Report is populated from the Company Setup screen. The list contains all companies for which you have security permissions to view. If you have permission for only one company, that will be the only one displayed in the list. If you have permissions to multiple companies, the list will display those companies PLUS the default reporting company.
When discernible, WinTeam will print the appropriate company name and logo on each page; otherwise the Default Company Name will print. That is, if a Company level is included in the tiered section and is displayed in the tiered information at the bottom of the page, then that company's Report Name and Logo (if selected) prints on that page.
If there is not a Company identified in the tier area of the page, then the Default Company Name for Reports is used. The default Company Name and Logo is also used for the Total Enterprise report. For more information see Learning about WinTeam Reports.
Use the Format Description list to select the Profit and Loss statement from the Formatting of Financial Statements. Only the statements entered in the Formatting of Financial Statements screen as Profit and Loss Format Types will display on the list.
Current Period Dates
Use the Current Period Dates category to select the Current Period Dates to include on the report.
Type the beginning Period Date in the From field and the ending Period Date in the To field.Same Period Dates Last Year
Use the Same Period Dates Last Year category to select the Same Period Dates from the year prior to the selected Current Period.
Type the beginning date in the From field and the ending date in the To field.Note: The Same Period Dates Last Year field will default to the same period for the year prior to the date entered in the Current Period Dates field. You may modify these dates if necessary.
Use the Tier Template to define and save customized settings for a report. To use an existing template, select the template from the list and click Load.
To create a new template, you can load an existing template, make the necessary modifications, click Save, and define a new template name in the Save As dialog box. Alternatively, you can start with a blank template by clicking the Clear button.
To modify an existing template, load the template, make the necessary modifications, and then click Save. The name of the existing template display in the Save As dialog box. Click OK.
For more information see Using Tier Templates and Using Tier Parameters.
Select the Group by Parent Job # check box to include amounts for Sub Jobs with the Parent Job.
Note: The Group and Print check boxes in the Tier Pattern Template must be selected for the Group by Parent Job # to function.
The Print Company Totals check box is available to users who have only one company, and may be selected to print company totals on the report.
The Print Enterprise Totals check box is available to users who have more than one company, and may be selected to print enterprise totals on the report. This check box is selected by default.
If this is not selected, the report prints only the tiered reports that are marked for printing.
Select the Exclude Last Year Totals check box to print an Income Statement only, rather than a Comparative Income Statement.
You can also use this check box in conjunction with the Include Current/YTD Budgets check box to display an Income Statement with budget information.
If the ‘Exclude Last Year Totals' check box is selected the report will print in Portrait mode.
Select the Include Current/YTD Budgets check box to print budgeted figures for each line item, as well as the Actual figures on the report.
Select this check box to print the company logo on the report. It is selected or cleared by default based on the option selected in SYS:Defaults. However, you can modify the setting on each report.
Select this check box to include a list of the report options selected for the report. The Report Criteria page includes any ranges specified and each Category/Record selection made for the report. This check box is cleared selected by default.
Preview
Click the Preview button (or use the shortcut key, ALT + V) to view the report before printing.
Click the Print button (or press ALT + P) to send the report to your default printer.
Export
Click the Export button (or press ALT + X) to export the report to a specified format. Reports may be exported to Adobe Acrobat (PDF), Excel, Comma-Separated Values (CSV), Grid View and E-mail (available for premise-based clients only).
Custom Settings
Section | Item | Value | Module and Purpose |
---|---|---|---|
GLReport | SortbyTierDescription | Yes | This setting will sort by Tier Descriptions (instead of the Tier ID). The Tier Descriptions will also display when previewing and using the Toggle Group Tree. |
GLReport | UseDailyBudgets | Yes | If you want the Comparative Income Statement to use daily labor budgets, add this Custom Setting. This is applicable only when the Include Current/YTD Budgets check box is selected. For more information, see Use Daily Labor Budgets. |