8.3.4 Income and Expense Statement
Previous Topic  Next Topic 

An Income & Expense Statement reports the results of earning activity for a specific period of time. It consists of Revenue, Expenses, and Net Income.


Use "Financial Reports Setup" (8.3.7) to control the format of this report.


You have a choice of viewing/printing this report for a certain Accounting Period or Year.


You may choose to compare the current Income & Expense Statement to the Budget or to Last Years Amounts.


If answered <Y>es to Show Difference Percentage, this prompt will calculate the percentage difference of the Current Year/Period to the Previous Year/Period or to the Budget figures. This feature is only active when you are doing a comparison of Last Year or Budget figures (answer <B>udget or <Y>ear to the prompt). The report will show the percentage difference, over or under. To accommodate the additional columns, the dollar amount figures will be rounded, and not show decimals (cents).


You can Use Expense/Income Breakdown to link certain Expense accounts to specific Revenue accounts. If set up in "Financial Report Setup" (8.3.7), you can specify that a certain Cost of Goods account show a ratio compared to a specific account other than the main Revenue account. This is very useful if you have multiple sales accounts and multiple Cost of Goods accounts. Enter a <Y> and press <ENTER>, to have the Income & Expense ratio calculate on specific Expense and Revenue accounts set up in "Financial Report Setup."  To have the all ratios of Expense to Income calculate off of the Revenue Account in "Financial Report Setup," just press <ENTER>.


Once the Income & Expense Template is setup in "Income and Expense Template Entry" (8.3.8), you will be able to make use of the Income & Expense Template prompt. You may choose to: Enter Income and Expense Template to use for the Report, Enter <?> for Income and Expense Template Lookup, or Leave Blank to Generate the Report without using a Template.


Please note that when a Template is used to generate the report, all Zero-balance accounts will be

suppressed in the output, regardless of the setting in the Financial Reports Setup (8.3.7, field 7).

The only exception to this will be Header Accounts that have a Total Balance of 0.


The <D>etail report will show each Asset, Liability, and Equity accounts. The <S>ummary report will only show the Header accounts. This report will Not print the lowest level accounts within a major group (example: Assets). For example:  If there are 4-levels of Detail in your Account Format for Assets, then the Summary option will only print 3-levels.


<F>ile Option - When selecting ALL locations, the tab-delimited file will contain each individual location.


You have the option to <P>rint, view this report on the <S>creen or download to a <F>ile.


You have the option to print an Income & Expense Report for each Location. The prompt will be displayed only if you have more than one location and you are asking for ALL locations.


The view screen function requires an AccuTerm© station or terminal capable of viewing 132 columns. Update fields 13, 14, and 16 in “Port Entry” in POINT OF SALE (1.10) to enable this function. You may only view the Summary report.


Once the file is displayed on the screen, you now have the option of download the report to your hard drive. Enter a <D> to download. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: ORDER.RPT10.TXT, where 10 is the port number or ORDER.RPT10TAB.TXT for the TAB Delimited file name.


You may download the Payable Aging Report to a FILE to a Windows© file. The purpose for downloading is for integration with MS Word©, Excel©, or other programs you want to use the data in.


Enter an <F> to capture the file - DISP.RPT.RAW. The ID will be the program concatenated to the port (example ORDER.RPT10, where 10 is the port number). Once the file is displayed on the screen, enter <D> to download. When downloading the file, the path defaults to C:\TEMP but will use the setup in “Port Entry” (1.10 field 16) for the download path. This directory must exist on the PC executing the download. The Windows© file name will be the report name concatenated to the port number, then .TXT. For example: INCOME.EXPENSE.RPT10.TXT, where 10 is the port number or INCOME.EXPENSE.RPT10TAB.TXT for the TAB Delimited file name. When you choose <D>ownload, both files will be downloaded automatically. You may choose either file, but the TAB delimited file will work better for Excel©.


If you receive the following error message:  “Years are inconsistent by location for account xxxx-xx. Press <ENTER>”, you must run the "End of Year Chart of Accounts Roll" (8.4.5).