Statement of Revenues and Expenditures by Period Reports

Access this report using Reports>Financial Statement >Statement of Revenues and Expenditures by Period.

Use this report to view or print the posted balance information for any account combination desired. You can view the statement of revenues and expenditures with periods in columnar format across the page. The reporting periods can be viewed as monthly, quarterly, or yearly as defined on the Options tab.

Note: Certain requirements must be followed for the Financial Statement Format when running the Statement of Activities and any Statement of Revenues and Expenditures type report. (The statement of revenues and expenditures was set up using the Report Builder Setup Tab for adjusting Financial Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly.

This is the System Default report available for Statement of Financial Position by Period:

  • Statement of Revenues & Expenditures by Period

Note: Additional Statement of Revenues and Expenditures by Period reports may be available depending on your MIP implementation.

Setup

Use this tab to assign:

  • Balance Dates
  • Current Period Dates
  • Financial Statement Formats
  • Report Groups
  • Columns
  • Items by Page (Page Breaks)

Balance Dates

The Balance Dates for the report display.

See Report Builder Setup Tab for more information on adjusting Balance Dates.

Current Period Dates

The Current Period Dates for the report display.

See Report Builder Setup Tab for more information on adjusting Current Period Dates.

Financial Statement Formats

The Financial Statement Format for the report displays.

See Report Builder Setup Tab for more information on adjusting Financial Statement Formats.

Report Groups

Selecting a Report Group in Columns, Items by Page (Page Breaks), or Filter displays the Select\Edit Group Code dialog box.

See Report Builder Setup Tab for more information on working with Report Groups.

Columns

The current column configuration for the reports displays.

See Report Builder Setup Tab for more information on adjusting report columns.

These are the available columns with their descriptions for Statement of Revenues and Expenditures by Period reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column

Description

Financial Statement Section Titles

The financial statement level Section Titles that were set up using the Report Builder Setup Tab for adjusting Financial Statement Formats. This column always prints on the report.

Title

The actual title assigned to the account code. The report prints the title, such as Housing, Federal Fund, or Service Fees.

Account Code

The actual code assigned to the account. The report prints the account code, such as 201, 05, or 45001.

Period Amount

A "by-period" column, which includes amounts for each actual and budget version. This amount is based on the dates entered for the Opening and Ending Balances on the Setup tab. It is also calculated by the reporting period selected on the Options tab—Monthly, Quarterly, or Yearly. For example, if Actual and Budget - Original was selected as the Period Amount, 1/1/15through 12/31/15 was selected as the dates for the Opening and Ending Balances, and Monthly as the reporting period, the system prints 12 separate columns displaying for those months, and two columns displaying the reporting period amounts for each month.

Total

The sum of each Period Amount column.

{Custom Column}

A custom column that was created.

Items by Page (Page Breaks)

The current data arrangement per page for the report displays.

Use Items by Page to divided report items onto separate pages, starting a new page for each item.

See Report Builder Setup Tab for more information on separating report pages.

These are the available columns with their descriptions for Statement of Revenues and Expenditures by Period reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column

Description

{Segment Name} Code

The code assigned to the segment. The report shows a segment code—01, 201, 11001, for example. The report prints one column for each segment, such as Fund Code or GL Code.

{Segment Name} Group Code

The group code that was defined. The report prints a column for each group code, such as Fund Group Code.

Filters

The current column filtering for the reports displays.

Use filtering to narrow down and more explicitly define the data to include in the report.

See Report Builder Filter Tab for more information on adjusting report filters.

These are the available columns with their descriptions for Statement of Revenues and Expenditures by Period reports.

Note: Fewer or additional report columns may be available depending on your MIP implementation.

Column

Description

{Segment Name} Code

The code assigned to the segment. The report shows a segment code—01, 201, 11001, for example. The report prints one column for each segment, such as Fund Code or GL Code.

{Segment Name} Group Code

The group code that was defined. The report prints a column for each group code, such as Fund Group Code.

Options

Use this tab to set up any Available Options for the report.

See Report Builder Options Tab for more information on adjusting report options.

These are the available options with their descriptions for Statement of Revenues and Expenditures by Period reports.

Options

Description

Financial Statement|Segment to Substitute for GL Segment

Select a segment to substitute for the General Ledger segment, or leave it at the default, None. The GL Code or GL Group Code must be selected in the Report Body in order to use this option. Selecting a group code is the same as filtering by group code on the entire report.

Financial Statement|
Statement Level

Select this option to determine the statement level to print to. These levels (1-3) were created when the section titles were entered using the Report Builder Setup Tab for adjusting Financial Statement Formats.

Financial Statement|
Reporting Period

Select how to display the reporting period amounts—Monthly, Quarterly, or Yearly. This period is based on the dates selected for the Opening and Ending Balances on the Setup tab. The reporting period amounts display in the Reporting Period Amount column on the Content tab.

Include|Equity Section

Select this option to include (when the box is checked) or exclude (when the box is not checked) the Equity Section on the printed report. Whether the box is checked or not, this Equity information is only available if you have set up the report format to include Equity. The report format setup is found at Report Builder Setup Tab for adjusting Financial Statement Formats.

Include|
Encumbrances as Expenditures

Select this option to include (when the box is checked) or exclude (when the box is not checked) the encumbrances as expenditures. This option is only available if the Encumbrances module is installed.

Include|Year End Adjustments

Select this option to mark the entry type as A (Year End Adjustments). The entry is posted to the last day of the fiscal year. It allows the user to make year-end adjustments and print reports including or excluding an adjustment.

Miscellaneous|
Suppress Lines with All Zeros

Select this option to suppress any activity lines and Show Totals in the financial statement that net to a zero value. Totaling lines, as designated by the Financial Statement Format, will not be suppressed even if they net to a zero value. If it is not selected, every line prints, even if it has a zero value.
Security|Do Not Allow Changes to this Report Select this option to lock the report and disallow changes.

Layout

Use this tab to change the font and page setup for a report.

See Report Builder Layout Tab for more information on adjusting the report layout.