Statement of Revenues and Expenditures Reports

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

Use this report to view the standard statement of revenues and expenditures with budget to actual comparisons. This report is used to view your current budget position with previous years. It contains:

  • Additional items and filters if any user defined fields were created by the Administrator. Only user defined fields with a field type of String, Editable Drop-Down List, or Non-Editable Drop-Down List are available in the Items by Page on the Report Builder Setup Tab and are listed as an available filter.

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 Report Builder Setup Tab for adjusting Financial Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly.

These are the System Default reports available for Statement of Financial Position:

  • Budget Stmt of Revenue & Expenditures - Monthly

  • Stmt of Revenues and Expenditures - Comparative

  • Stmt of Revenues and Expenditures - Monthly

Note: Additional Statement of Revenues and Expenditures 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 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. 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.

Beginning Period Actual

The actual amounts for the current reporting period. The reporting period was designated using the Opening Balances date and Ending Balances date on the Setup tab.

Current Period Actual

Calculated by taking the debits minus the credits when the G/L Account Code's Section Account Category is Expenditures. Otherwise, calculated by taking the credits minus the debits.

Prior Year Current Period Actual

Calculated by taking the debits minus the credits when the G/L Account Code's Section Account Category is Fund Balance. Otherwise, calculated by taking the credits minus the debits.

Current Period Change

The monetary increase or decrease between the current balance and the balance at the beginning of the period.

Current Period % Change

The percentage increase or decrease between the current balance and the balance at the beginning of the period.

Current Year Actual

Calculated by taking the debits minus the credits when the G/L Account Code's Section Account Category is Expenditures. Otherwise, calculated by taking the credits minus the debits. This amount is based on the organization's fiscal year.

Prior Year Actual

Calculated by taking the debits minus the credits when the G/L Account Code's Section Account Category is Expenditures. Otherwise, calculated by taking the credits minus the debits. This amount is based on the organization's prior year. Prior year actual only builds totals up through the current period end month for the previous year.

Current Year Change

The monetary increase or decrease between the current year balance and the prior year balance for the same time frame.

Current Year % Change

The percentage increase or decrease between the current year balance and the prior year balance for the same time frame.

Current Period Budget - {Budget Version Display Name}

Calculated by taking the net amount of budget decreases and increases for the period Opening Balances Date through the Ending Balances Date for the specified Budget Version.

Current Period Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Period Actual amounts and the Current Period Original Budget amounts.

YTD Budget - {Budget Version Display Name}

Calculated by taking the net amount of budget decreases and increases for the period Current Reporting Year Begins Date through the Ending Balances Date of the current year for the specified Budget Version.

YTD Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Year Actual amounts and the YTD Original Budget amounts.

Total Budget - {Budget Version Display Name}

Calculated by taking the net amount of decreases and increases for the period Total Budget From date through the Total Budget Through date for the specified Budget Version.

Total Budget Variance - {Budget Version Display Name}

This is the expense and revenue variance for the calculation between the Current Year Actual amount and the Total Original Budget amounts.

Percent Total Budget Remaining - {Budget Version Display Name}

This amount, which is represented using a percentage, is calculated by taking the Total Original Budget less the Current Year Actual, and then dividing the result by the Total Original Budget.

{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 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.

{User Defined Field} - {Segment Name} Code

A segment type user defined field and its data. There is a separate column for each field.

{User Defined Field} - {Segment Name} Contract Code

A segment type user defined field and its data. There is a separate column for each field.

{User Defined Field} - {Segment Name} Division Code

A segment type user defined field and its data. There is a separate column for each field.

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 reports.

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

Column

Description

Transaction Source (Unposted)

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

Session ID (Unposted)

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

{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.

{User Defined Field} - {Segment Name} Code

A segment type user defined field and its data. There is a separate column for each field.

{User Defined Field} - {Segment Name} Contract Code

A segment type user defined field and its data. There is a separate column for each field.

{User Defined Field} - {Segment Name} Division Code

A segment type user defined field and its data. There is a separate column for each field.

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 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.

Total Budget|
From/Through

Select the start and end date you want to use to calculate and print total budget amounts. This range can exceed a 12 month interval.

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 in the Report Builder Options Tab.

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.

Include|
Unposted Transactions

Select this option to include all unposted transactions.

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.

Miscellaneous|
Rounding

Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.
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.