This report must be formatted in the Report Format Maintenance module prior to printing. It will produce an Income & Expense Statement, also referred to as a Profit & Loss Statement, in the format most people are used to seeing. It is a comparative report that can be printed for any period or year, open or closed, in the system General Ledger. For each account, it will show the balance for the current month, the balance year-to-date, what the balance was this month last year, and what the year-to-date balance was last year. It will also show the increase or decrease for the period or for a range of periods. You can format both a detailed Income & Expense Statement and a consolidated one to print through this report module. When you enter this report module, the screen will appear as follows:
The cursor will be positioned at the Company ID (1) prompt. If applicable, use the drop-down menu to select a different Company. The Beginning (2) and Ending Period (3) fields will default to the current open period in the system G/L. To print for a range of periods, type the applicable period in the Ending Period field. At the Select (4) box fields, if the default period is selected, these fields will not be available. However, if you type an earlier period in the Beginning Period field, you can then access these fields, though you cannot select Next Year if that period is still open in the current year. If you wish to access archived data, click the Previous Year option and the system will display an FYE drop-down menu so you can select a prior year. The Report Type (5) field will default to Income Statement. Switch to All to see a list of all available Report Formats in the next field. At the Report Format (6) field, use the drop-down arrow to select the applicable report to use. Click the Excel icon to export the data, or click the Print button to print to paper or screen. To exit without printing, click the Cancel button.
One additional report feature appears at the top left of the screen as follows: Print Annual Income Statement. This report currently only exports to Excel because of the landscape format required to compare multiple periods in column format. This report looks and works very similarly to the Annual Trial Balance. When you enter this report module, the screen will appear as follows:
The cursor will be positioned at the Company ID (1) prompt. If applicable, use the drop-down menu to select a different Company. One big difference from the regular report is that the Beginning Period (2) field will be hard coded to Period 1. The Ending Period field will default to the current default Posting Period. You can adjust the Ending Period when applicable. The default for the Select (3) box is This Year. You can click Next Year if that period is not open in the current year, or click the Previous Year option and the system will display an FYE drop-down menu so you can select a prior year. The Report Type (4) field will default to Income Statement. Switch to All to see a list of all available Report Formats in the next field. At the Report Format (5) field, even though the report is not yet printing to paper, you must select an option at this field that contains Income & Expense accounts to display in Excel. Next, click the Excel icon to export the data. To exit without exporting, click the Cancel button. The exported data will display a column for each Period included and then a Total column as the last column.