Statement of Activities Reports

Access this report using Reports>Financial Statement >Statement of Activities.

Use this report to print the ASC 958 (FAS 117 superseded) statement of revenues, expenditures, and changes in net assets equivalent. To produce ASC 958 (FAS 117 superseded) compliant reports use the Segment Substitution feature to report the Expense section by Functional Category (on the Options tab). This report contains:

  • Segment columns, which allow you to produce a comparative report by segment code. Assign a Type of Column (on the Contents tab) to one of the segments. Then, use the Column Totals tab to subtotal any combination of codes and to print those subtotals in a column on the report.

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. (See Report Builder Setup Tab for more information on 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 Activities:

  • Statement of Activities Sample

Note: Additional Statement of Activities 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 & Combining Column (Totals)

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 & Combining Column (Totals), 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 Activities 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 Financial Statement Level Titles, Account Titles, and Group Titles, which depend on the selected financial statement levels, account codes, and group codes. The column title does not print on the report.

Account Code

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

Account Amount

Calculated by taking the debits minus the credits when the GL Account Code's Section Account Category is Expenditure. Otherwise, it is calculated by taking the credits minus the debits. If you select a segment with a Type of Column in the Items by Page, the system prints a column for Actual, Budget, and Variance. The Budget column displays the budget figures based on the Budget Version selected on the Options tab.

Total

The amount for all the segment columns. The system sums the debits minus the credits when the GL Account Code's Section Account Category is an Expenditure. Otherwise, it is calculated by taking the credits minus the debits. If you select a segment with a Type of Column in the Items by Page, the system prints a column for Actual, Budget, and Variance. The Budget column displays the budget figures based on the Budget Version selected on the Options tab.

Items By Page & Combining Column (Totals)

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

Column Totals

In addition to arranging data by page, the Statement of Activities reports for Financial Statement include combining column totals.

See Report Builder Setup Tab for more information on combining column totals.

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

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

Budget|
Budget Version

Select a budget version in which to base the budget amounts. Budget versions are created by the Administrator.

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 the 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 Columns When the Column is Zero for the Entire Report

Select this option to suppress columns that have all zeros. Please note that this only applies to columns that have a zero value throughout the entire report.

For example, suppose there is a page break on the report by "Fund" and the columnar segment is "Program." The column may be zero for a Program Code on the first page, but that same column may NOT be zero for the Fund on page two. Therefore, the column will not be suppressed at all because there are values associated with it somewhere in the report that are not zero.

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.