Report: Income and Expense Statement

The Income and Expense Statement reports the agency's income and expenses for selected time periods, and indicates either a net profit or a loss.

Report Selections

Current Month and same month prior year comparison columns don't include Beginning Balance Journal Entries (BJE's) or Year End Closing Journal Entries (ZJE's). Current year to date and prior year to date comparison columns include BJE's but don't include ZJE's.

Report Selections

What is this?

Reporting Period

The general ledger posting dates that are considered in selecting data for the report:

Options	What is this?
From List	Use this option to select a pre-defined date range from the list. The default option is Current month minus 1.
Select Dates	Use this option to type in a specific date range not covered by the choices in the From List option.

Business Unit

Click the link to open the Business Unit Selections form and make your selections.

Business Unit Consolidation Option

These options are different depending on the combination of Business Unit options (division, branch, department, group) turned on in the Accounting Options section of Agency Setup.

Division/Department	What does this mean?
All Divs and Depts Consld	Report all divisions and departments consolidated.
Div by Div/Dept Consld within Div	Report divisions separately, consolidating all departments within each division.
Div by Div/Dept by Dept within Div	Report all divisions and departments separately.

Division/Branch/Department	What does this mean?
All Divs, Brnches, and Depts Consld	Report all divisions, branches, and departments consolidated.
Div by Div/Brnch Consld/Dept Consld	Report each division separately, while consolidating all departments into their respective branches, and all branches into their respective divisions.
Div by Div/Brnch by Branch/Dept Consld	Report each division, and branch separately, while consolidating all departments into their respective branches.
Div by Div/Brnch by Brnch/Dept by Dept	Report each division, branch, and department separately.

Division/Branch/Department/Group	What does this mean?
All Divs, Brnches, Depts, and Grps Consld	Report all divisions, branches, departments, and groups consolidated.
Div by Div/Brnch by Brnch/Dept by Dept/Grp by Grp	Report each division, branch, department, and group separately.
Div by Div/Brnch by Brnch/Dept by Dept/Grp Consld	Report each division, branch, and department separately, while consolidating all groups into their respective departments.
Div by Div/Brnch by Brnch/Dept Consld/Grp Consld	Report each division, and branch separately, while consolidating all groups into their respective departments, and all departments into their respective branches.
Div by Div/Brnch Consld/Dept Consld/Grp Consld	Report each division separately, while consolidating all groups into their respective departments, all departments into their respective branches, and all branches into their respective divisions.

Division/Department/Group	What does this mean?
All Divisions, Departments, and Groups Consolidated	Report all divisions, departments, and groups consolidated.
Div by Div/Dept Consld/Grp Consld	Report each division separately, while consolidating all groups into their respective departments, and all departments into their respective divisions.
Div by Div/Dept by Dept/Grp Consld	Report each division, and department separately, while consolidating all groups into their respective departments.
Div by Div/Dept by Dept/Grp by Grp	Report each division, department, and group separately.

Reporting Level

Indicates the level of detail included by general ledger reporting group.

1 - Most Summarized
2 - Summarized
3 - Average
4 - Detailed
5 - Most Detailed

For more on levels, see the Chart of Account Rules section in the Chart of Accounts Setup topic.

Report Format

This selection offers several different formats for displaying income & expense data.

Prior Year Comparisons with % of Income
Prior Year Comparisons with Net Change in Dollars
Prior Year Plus YTD Comparisons with Net Change in Dollars
Prior Year Plus YTD Comparisons with Percentages
Report Range Plus YTD (default)

For more information, see the tables in the Report Format Options section of this topic.

2 Decimal Precision

When you check 2 Decimal Precision, all columns of figures have two decimal places past the decimal point. If you do not check this box, the amounts round to the nearest dollar. The default is checked.

Rounding to the nearest dollar comes in handy when running reports with comparison columns. It provides more room on the report..

Description

Accept the default description, or enter a new one that describes the report you are requesting.

Print Cover Page

Allows you to include a cover page listing the selected options included in the report. This option defaults as unchecked.

Prompt

To set a report reminder that certain selections need to be changed before the report is run, do the following:

Mark the Prompt check box.
Enter the reminder message in the Selections to Verify text box, for example "Report Format."
Save and close the report.

The next time you attempt to print, print preview or create a CSV file for this report, a reminder message advises you that particular selections must be selected before the report can be run. Open the report selections and modify as necessary. Then run the report.

Selections to Verify

Report Format Options

Field Selection

Report Format

Prior Year Comparisons with % of Income

Data Column	Date Range or Source of Data	Calculations
1	Income and Expenses for the user-selected date range.	N/A
2	Calculation of the percent of total income represented in column 1.	Column 1 account balance divided by the Total Income amount in Column 1.
3	Income and Expenses for the user-selected date range one year earlier.	N/A
4	Calculation of the percent of the prior year's total income represented in column 3.	Column 3 account balance divided by the Total Income amount in Column 3.

Prior Year Comparisons with Net Change in Dollars

Data Column	Date Range or Source of Data	Calculations
1	Income and Expenses for the user-selected date range.	N/A
2	Income and Expenses for the user-selected date range one year earlier.	N/A
3	Net change between column 1 and column 2, expressed in dollars.	Column 1 minus column 2.
4	Net change between column 1 and column 2, expressed as a percentage.	Column 1 minus column 2, with the results divided by column 2 times 100 (rounded to one place past the decimal)

Prior Year Plus YTD Comparisons with Net Change in Dollars

Data Column	Date Range or Source of Data	Calculations
1	Income and Expenses for the user-selected date range.	N/A
2	Income and Expenses for the user-selected date range one year earlier.	N/A
3	Income and Expenses year-to-date (YTD) through the user-selected end date.	N/A
4	Income and Expenses year-to-date (YTD) through the user-selected end date one year earlier.	N/A
5	Net change between column 3 and column 4, expressed in dollars.	Column 3 minus column 4.
6	Net change between column 3 and column 4, expressed as a percentage.	Column 3 minus column 4, with the results divided by column 4 times 100 (rounded to one place past the decimal) OR Column 5 divided by column 4, multiplied by 100 (rounded to one place past the decimal).

Prior Year Plus YTD Comparisons with Percentages

Data Column	Date Range or Source of Data	Calculations
1	Income and Expenses for the user-selected date range.	N/A
2	Income and Expenses for the user-selected date range one year earlier.	N/A
3	Net change between column 1 and column 2, expressed as a percentage.	Column 1 minus column 2, with the results divided by column 2 times 100 (rounded to one place past the decimal)
4	Income and Expenses year-to-date (YTD) through the user-selected end date.	N/A
5	Calculation of the percentage of income for data in column 4.	Column 4 account balance divided by the Total Income amount in Column 4.
6	Income and Expenses year-to-date (YTD) through the user-selected end date one year earlier.	N/A
7	Net change between column 4 and column 6, expressed as a percentage.	Column 4 minus column 6, with the results divided by column 6 time 100 (rounded to the one place past the decimal)

Report Range Plus YTD

This format is the default.

Data Column	Date Range or Source of Data	Calculations
1	Income and Expenses for the user-selected date range.	N/A
2	Calculation of the percentage of income for data in column 1.	Column 1 account balance divided by the Total Income amount in Column 1.
3	Income and Expenses Year-to-Date (YTD) through the user-selected end date.	N/A
4	Calculation of the percentage of income for data in column 3.	Column 3 account balance divided by the Total Income amount in Column 3.

CSV Columns

CSV Columns for the Following Formats:

Report Range Plus YTD
Prior Year Comparisons with % of Income
Prior Year Comparisons with Net Change in Dollars

CSV Columns	Description
Division	Displays "All Divisions" when consolidated, otherwise displays the division name.
Department	Displays "All Departments" when consolidated, otherwise displays the department name.
Level 1	Level 1 group for a general ledger detail account number.
Level 2	Level 2 group for a general ledger detail account number.
Level 3	Level 3 group for a general ledger detail account number. This field is blank for a detail level 2 account.
Level 4	Level 4 group for a general ledger detail account number. This field is blank for detail 3, and detail 2 accounts.
Level 5	Level 5 group for a general ledger detail account number. This field is blank for detail 4, detail 3, and detail 2 accounts.
Account	General ledger detail account number.
Description	General ledger account description (name).
Amount	General ledger number net posting for selected reporting period.
CompareAmount	General ledger number net posting for "compare" reporting period.
Branch	Displays "All Branches" when consolidated, otherwise displays the branch name.
Group	Displays "All Groups" when consolidated, otherwise displays the group name.

CSV Columns for the following formats:

Prior Year Plus YTD Comparisons with Percentages
Prior Year Plus YTD Comparisons with Net Change in Dollars

CSV Columns	Description
Division	Displays "All Divisions" when consolidated, otherwise displays the division name.
Department	Displays "All Departments" when consolidated, otherwise displays the department name.
Level 1	Level 1 group for a general ledger detail account number.
Level 2	Level 2 group for a general ledger detail account number.
Level 3	Level 3 group for a general ledger detail account number. This field is blank for a detail level 2 account.
Level 4	Level 4 group for general ledger detail account number. This field is blank for detail 3, and detail 2 accounts.
Level 5	Level 5 group for general ledger detail account number. This field is blank for detail 4, detail 3, and detail 2 accounts.
Account	General ledger detail account number.
Description	General ledger account number description (name).
AmountCurrentPeriod	The general ledger number's net posting for the selected reporting period.
AmountPriorYearPeriod	The general ledger number's net posting for the selected reporting period one year earlier.
AmountCurrentYTD	The general ledger number's net posting for year to date. ending on the last day of the selected reporting period.
AmountPriorYTD	The general ledger number's net posting for prior year to date, ending on the last day of the selected reporting period, one year earlier.
Branch	Displays "All Branches" when consolidated, otherwise displays the branch name.
Group	Displays "All Groups" when consolidated, otherwise displays the group name.