GL: Cross Tab Income Statement

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.

You will need to indicate the dates for the actuals you want to include on the report.

If you select the Use Budgets instead of Actuals check box, the Dates area is removed and the Fiscal Year and Periods displays.

This area is enabled when the Use Budgets instead of Actuals check box is selected.

Enter the Fiscal Year and the Period From and To for the budgets you want to include on the report. The system the GL Budget information for the given Tier and prints this information as details for the report.

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.

Note:  This is not applicable if you Use Budgets instead of Actuals. If your company is not using the Tax Allocation program and instead uses the system calculated payroll tax and insurance dollars to show the calculated tax and insurance dollars for your jobs, the Contra Line that is normally printed at the company level will not be shown on this report. This can understate your bottom line total if the tier of the job that you normally expense your tax and insurance dollars is included on this report. You will want to exclude the Tier which is set up with your Applied Costs job number (the job/department where you expense the Tax and Insurance $’s to). Your bottom line total will then reflect a more accurate dollar amount.

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.

This option does not display if you select the Use Budgets instead of Actuals >check box.

This check box is selected by default (does not display if you selected to Use Budgets instead of Actuals).

Selecting this check box includes sales ratio information on the report. The Sales Ratio information displays beside each line item on the report.

Select the Use Budgets instead of Actuals check box to pull all of the GL Budget information for the given Tier and print this information as details for the report. The selection criteria changes when this option is selected. You will need to indicate the Fiscal Year and the Period From and To for the budgets you want to include on the report.

Select the Include Zero Balance Accounts check box to include accounts with zero balances on the report.

Including zero balance accounts standardizes the report for exporting.

This check box is not selected by default.

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.

Print

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).

This setting will sort by Tier Descriptions. The Tier Descriptions will also display when previewing and using the Toggle Group Tree.