More information

Statement of Revenues and Expenditures

Access this report using Reports>Financial Statements>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 using Organization>Set Up User Defined Fields. 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 group box on the Content tab and are listed as an available filter.
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 "Net Revenue Over Expenditures," for example but report totals like these are available in the printed report.
The Chart Settings feature, which allows you to generate custom line, bar, column, or pie charts from reports. See Chart Settings - Setup Tab.
The Custom Columns feature, which allows you to create report columns that are not provided by the system. These columns can be set up to override report dates or create custom formulas. Budget variance and percentage columns must be set up using custom columns.

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 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. Columns that use a period of Opening Balances Date through Ending Balances Date, or Current Reporting Year Begins Date through Ending Balances Date, use the dates specified on the Setup tab of the report. However, if a column uses the Total Budget Dates, this range was assigned on the Options tab of the report.

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

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.

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.
Total Budget	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.
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.
Unposted Transactions	Select this option to include all unposted transactions.
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..
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.

If you selected rounding to a whole number (Report Setup>Options tab) for this report, the system applies rounding to all columns with amounts, including custom columns. Therefore, even if you enter a number of decimal places for a custom column, the system reports all custom column amounts or numbers rounded to a whole number.
A cross year report can be created with balances outside the organization's fiscal year (Setup tab). However, this report cannot be generated with groups and balances outside the organization's fiscal year.
This report prints all Account Codes in one column and all Account Titles in another column. Additionally, the Title column is required.
This 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.