Statement of Activities

Access this report using Reports>Financial Statements>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.
  • The Drill Down feature, which allows you to view report data from the report balances level, down to the individual debits and credits that make up the balance. It is based on the financial statement formatting (Reports>Financial Statements>Create Statement Formats) and report setup criteria that was entered for this report. However, Drill Down does not offer report totals, such as, "Total Revenue," "Total Expenditures," and "Ending Net Assets," for example but report totals like these are available in the printed report.

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 activities was set up using Reports>Financial Statements>Create Statement Formats.) This will ensure that the Fund Balance/Net Assets section totals correctly. See Requirements for the Financial Statement Format for specific information about these requirements.

 

Use this tab to assign a report name and determine whether or not to include it on the actual report. The report name can be printed in the header or the footer of the report.

Specify the date range for the data included in the report by entering Balances Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date. Additionally, Current Period Dates are also required to specify the reporting period for this report.

Use the Financial Statement Format box to select the financial statement to include in this report. And, the Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be processed for closed years and cross-years at the same time.

Use this tab to determine what data to include in the report and to define the report layout.

  • By selecting Available Items, the data is divided onto separate pages. The report starts a new page for each item, and the item is printed in the page header of the report.
  • By selecting Available Columns, the data that appears in the body of the report is determined.

Column

Description

Financial Statement Section Titles

The financial statement level Section Titles that were set up using the Reports>Financial Statements>Create Statement Formats>Create Outline tab. 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 group box, 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 group box, 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.

Use this tab to narrow down and more explicitly define the data to include in the report by selecting from the Available Filters.

Use this tab to designate the Group Sets for the report. Groups provide an alternate way of reporting summarized accounting data. Selecting a group code on the report is the same as filtering by group code on the entire report. Any accounts not included in a Group Set will not be included in the report. In order for groups to be applied to the report, the group selected on the Groups tab must also be selected in at least one of the following: Content tab, Filter tab, or Segment to Substitute for GL Segment on the Options tab.

If the report is printed using groups rather than individual account codes, only account codes included in the groups created for this Group Set print on the report. If there are account codes not included in a group, they do not print on the report.

Use this tab to subtotal any combination of codes and to print those subtotals in a column on the report. This tab is only available if a Type of Column was selected in the Items by Page group box on the Contents tab.

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

Options

Description

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.

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 Reports>Financial Statements>Create Statement Formats>Create Outline tab.

Budget Version ID

Select a budget version in which to base the budget amounts. Budget versions are created by the Administrator using Organization>Set Up Modules>Budget>Budget Versions.

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 Reports>Financial Statements>Create Statement Format>Create Outline tab.

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.

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.

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.

Rounding

Select this option to round the amounts to the nearest whole number when printing the report. Select "None" to not round the amounts.

Currency

Select a non-functional currency type from the drop-down list to translate the financial statement to another currency that was previously set up by the Administrator (Organization>Currency Setup). Alternatively, select None to run the report in the functional currency.

Rate Type

Select an existing exchange rate type from the drop-down list. The system lists any custom types you created, along with two predefined rate types—Daily Spot Rate and Monthly Average Rate.

Rate

The system displays the exchange rate for the selected currency based on the rate type and report Ending Balances. This was entered on the Maintain>Multicurrency>Exchange Rates form. The system multiplies the Rate times the functional amount of the financial statement to translate the statement into the selected currency.

Exchange Rate Override

Enter the exchange rate of the currency selected. This overrides the Rate displayed. The system multiplies this new rate times the functional amount of the financial statement to translate the statement into the selected currency.

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

Use this tab to secure the active report so that other users cannot save their changes to it. The user that selects the check box, and then saves the report, is the only user that can change or save it later. This check box cannot be cleared by any user other than the user that locked the report.

  • You must select at least one numeric column in order to print, print preview, or print to screen.
  • This report contains the print detail option that allows you to define (using the Reports>Financial Statements>Create Statement Formats form) whether a general ledger account prints in detail or not.
  • When any option from the Date Items drop-down list (except Custom) is selected, report dates are automatically adjusted each time the report is processed. For example, choose a Report Date of This Month and process the report on 10/15/20xx, you get a report with the month of October. If the report is processed on 11/15/20xx, you get a report with the month of November. In other words, you do not have to return to this tab each month to change the Current Period Dates.
  • If Custom is chosen as the Date Item, you are required to enter the dates MM/DD/YYYY through MM/DD/YYYY on this tab. These Opening and Ending Balances dates do not change each time the report is processed.
  • This report prints all Account Codes in one column and all Account Titles in another column. Additionally, the Title column is required.
  • Use segment columns to produce a comparative report by segment code. The system allows up to 100 separate segment columns for each, such as Fund and Department.
  • The report always contains the Financial Statement Section Titles column. This column is the financial statement level Section Title that was set up using the Reports>Financial Statements>Create Statement Formats>Create Outline tab. One to three sections (or levels) could have been set up in the outline. However, set the report options (using the Options tab) to three levels for all levels to appear on the report.
  • In the Report Body group box, similar columns are grouped together and identified with a heading preceded by a collapsed or expanded symbol . A collapsed symbol indicates the columns that belong to the heading are hidden. Click the collapsed symbol to expand the heading to see the columns contained within it. Likewise, an expanded symbol indicates the columns below it belong to that heading. For example, when you see Account Code with a symbol next to it, this means that Account Code is a heading and that every code name under it (such as GL Code, Fund Code) stays with the heading when it is moved to the Selected box.
  • Use the Mover buttons to move one item under a heading. However, if an item is moved from under one heading and then a different item is moved from another heading, the system keeps the items parallel. For example, move Fund Code from the Title heading. Then, move GL Code from the Account Code heading. The system automatically moves Fund Code from the Title heading and GL Code from the Account Code heading.

    Since this report contains this feature, the line header is built in. Therefore, an item is printed one time per unique value. Each column, directly related to the item selected, prints in the line header on the same line.