GeneralLedgerCS > General Ledger > Reporting menu > GL Income Statement window (Accounting product only)
 
GL Income Statement window (Accounting product only)
Use the Income Statement to print a report showing the income/revenue, expense, and net profit of the company.
Skip Zero Balance 
Select this check box to exclude accounts that have a zero balance for the specified time period on the report. If the accounts have a balance, but not in the time period shown on the report, they will not appear on the report.
Starting Period / Ending Period 
Enter the starting and ending period number(s) that you want included in the report. You can choose any period(s) in your fiscal calendar, from 1 to 60. If you want to include only one period in the report, enter the same number in both the Starting Period and Ending Period boxes. The defaults for these boxes are the Present Period as shown in your fiscal calendar.
When you enter the period number, the first date of the starting period and the last date of the ending period will appear to the right of the corresponding boxes so that you can verify that these are the periods you want to include in the report.
Print Account Number 
Select this check box if you want to print the account numbers on the report. If this check box is selected, the account numbers will appear on the left side of the page before the account descriptions.
Use Advanced Report Groups 
Select this check box if you want to generate a report with an advanced layout. When you select this check box, different options are available from the Report Type drop-down and the Report Group Lookup is enabled.
Report Type 
Choose the Report Type according to the type of information you want to see and the way you want it organized.
NOTE: To print a Classified Income Statement, Profit and Loss, Comparative Classified Income Statement or Comparative Profit and Loss, you must have Group 1 Report Types assigned to all of your GL Accounts. For more information on these groups and how to assign them, see Setting Up Account Groups.
Detailed: A Detailed report type will print out every account and its balance.
Summary: Prints only the account class totals.
Classified: Prints a balance sheet sorted by account class subcategories (report groups). To set up report groups, see Setting Up Account Groups. You must have every account in your general ledger assigned to an appropriate classified report group in order to run this report.
Profit and Loss: The Profit and Loss report type will print the Revenue from Operations, Cost of Goods Sold, and Operating Expenses. You must have every account in your general ledger assigned to an appropriate classified report group in order to run this report. To set up report groups, see Setting Up Account Groups.
Comparative Detailed: Prints the balance of each account selected for both the period you selected in the Ending Period box, and the same period for the prior year.
Comparative Classified: Prints the balance sheet sorted by account class subcategories (report groups) for both the period you selected in the Ending Period box, and the same period for the prior year. To set up report groups, see Setting Up Account Groups. You must have every account in your general ledger assigned to an appropriate classified report group in order to run this report.
Comparative Profit and Loss: The comparative Profit and Loss Statement prints the various account groups and compares the current and previous year account balances. In the Y-T-D Ratios it also shows what percentage each account balance is for the group it is in. You must have every account in your general ledger assigned to an appropriate classified report group in order to run this report. To set up report groups, see Setting Up Account Groups.
Drilldown: Prints a report that allows you to drill down to individual transactions. Double-click any line on the report for more information. A new report will open showing transaction information specific to the line you selected. You can only print this report to screen.
If you selected the Use Advanced Report Groups check box, the following options are available:
Advanced Classified: Prints the Income Statement sorted by account class subcategories using the layout you select in the Report Group field.
Advanced Profit and Loss: Prints the Revenue from Operations, Cost of Goods Sold, and Operating Expenses using the layout you select in the Report Group field.
Advanced Comparative Classified: Prints the Income Statement sorted by account class subcategories for both the period you selected in the Ending Period box and the same period for the prior year using the layout you select in the Report Group field.
Advanced Comparative Profit and Loss: Prints the various account groups and compares the current and previous year account balances using the layout you select in the Report Group field.
Advanced Detailed: Prints the Income Statement sorted by the accounts you added to the Advanced Report Group layout, even if the accounts do not have a Group 1 Report Group assignment in the GL Accounts window.
Use Account Filter 
Select this check box and enter a filter to use to print a customized report which includes only those accounts that meet the filter criteria. This option is not available if you selected the Use Advanced Report Groups check box.
Use Advanced Filter 
Select this check box to use an Advanced Filter Code as a filter for the report.
Account Filter 
If you selected the Use Account Filter check box, enter a filter to specify which accounts to include. Only accounts that match the specified filter criteria will appear on the report. Use wildcards (* and ?) to establish the filter parameters. Substitute a (?) for any single character in the account number, or an (*) for any number of characters. For example, to include all four-digit accounts beginning with a 1, enter 1??? in the Account Filter box. To include all accounts that end in 02, enter *02.
If you selected the Use Advanced Filter radio button, type or use the Lookup to enter the Filter Code to use to select the accounts.
Report Group 
This field is only available if you selected the Use Advanced Report Groups check box. Type the Report Group Code you want to use for this report layout or open the Lookup to select one.
Print Consolidated Ledgers 
Select this check box to include information from all companies that have been consolidated with the current company. This check box is not available if you selected the Use Advanced Report Groups check box. Be sure to consolidate your ledgers in the Consolidate Ledgers window before you run the report with this option.
Use a Custom Report 
This check box is only available if you defined a custom report for this window in Controller. Select this check box if you want to run a custom report instead of the default report. The drop-down is enabled after you select the check box and you can choose the custom report you want to run. 
 
Published date: 03/18/2020