Income Expense Statement

Income Expense Statement

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 StatementThis 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 fieldAt 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 IncomeExpense 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.


    • Related Articles

    • Report Format Maintenance

      This module is used to design custom Financial Statements. The RollMaster System automatically prints a Trial Balance report, but cannot print a Balance Sheet, Income & Expense Statement or any other customized financial report until they have been ...
    • Print Chart of Accounts

      Once you have added General Ledger accounts through the Account Maintenance/ Inquiry module, this report module will print a list of those accounts. The report lists the account number, account description, and account type. When you enter this ...
    • Vendor Reference List

      The Vendor Reference List is a much simpler report than the Vendor Listing. It lists only the Vendor ID and the Vendor Name. There are no customization options for sorting this report. When you enter this module, the screen will appear as follows: ...
    • A/R Detail List

      This report module prints a listing of every open Invoice, Credit Memo, Prior Payment, and Journal Entry by Customer currently entered in the system. It will then print a list of open Deposits by Customer at the end of the first list. The items are ...
    • AR Statement Header Mtc

      This is a set-up module that should be completed prior to printing A/R Statements in the system if you are using Plain Paper instead of Nebs or pre-printed forms. This module allows you to enter your store name and information by Branch to print out ...