Pre-Allocation Statement of Revenues and Expenditures Report

To access this report, go to Reports>Allocation Management>Pre-Allocation Statement of Revenues and Expenditures Report

Use this report to view a standard statement of revenues and expenditures. You can print balance information for posted transactions and unposted allocations for any account combination desired

To use this report, the Statement of Cash Flows report format must first be set up by going to Reports>Financial Statement and clicking the Open Formats button. This is where you will design the statement format to follow either the direct or indirect method of reporting cash flows. See Financial Statement Format Builder Form for more information.

There are requirements for financial statement formats when running the Statement of Activities and any Statement of Revenues and Expenditures report. To see the requirements, go to Financial Statement Format Requirements.

Note: This report does not include sessions with a status of "Batch-to-Suspend". However, it does contain any unposted transactions for allocation sessions (JVA-type transactions).

 

You can choose to use the report as-is by clicking or , or make edits to the report by clicking .

Tip: If you're not familiar with the MIP Cloud Report Builder interface, see Report Builder for an introduction.

If you choose to make edits to the report, the Report Builder page will display. From this page, use the Setup tab to choose the columns you'd like to appear on the report. You can rename the columns under Column Heading.

 

The following fields are available to include in the report:

Financial Statement Section Titles

The titles of the sections on the financial statement that were set up through Reports>Financial Statement>Open Formats>Add Financial Statement Format
Title

The title associated with an account code

  • The report prints the title, such as Housing, Federal Fund, or Service Fees.
Account Code

The code assigned to the account

  • The report prints the account code, such as 201, 05, or 45001.

  • The system displays one column for each of these code types, such as Fund Code or GL Code.

Pre-Allocation Current Period Actual

This pre-allocated amount is calculated by taking the debits minus the credits before the allocation, when the GL Account Code's Section Account Category is "Expenditures".

  • If the above does not apply, this amount is calculated as the credits minus the debits.

Post-Allocation Current Period Actual

This post-allocated amount is calculated by taking the debits minus the credits, including the allocation entries, when the GL Account Code's Section Account Category is "Expenditures".

  • If the above does not apply, this amount is calculated as the credits minus the debits.

Period Allocation Change

The monetary increase or decrease between the pre-allocation current period balance and the post-allocation current period balance

Period Allocation % Change

The percentage increase or decrease between the pre-allocation current period balance and the post-allocation current period balance

Prior Year Current Period Actual

This amount is calculated by taking the debits minus the credits when the GL Account Code's Section Account Category is "Fund Balance".

  • If the above does not apply, this amount is calculated as 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

Pre-Allocation Current Year Actual

This pre-allocated amount is calculated by taking the debits minus the credits before the allocation, when the GL Account Code's Section Account Category is "Expenditures".

  • If the above does not apply, this amount is calculated as the credits minus the debits. This amount is based on the organization's fiscal year.

Post-Allocation Current Year Actual

This post-allocated amount is calculated by taking the debits minus the credits, including the allocation entries, when the GL Account Code's Section Account Category is "Expenditures".

  • If the above does not apply, this amount is calculated as the credits minus the debits. This amount is based on the organization's fiscal year.

Year Allocation Change

The monetary increase or decrease between the pre-allocation current year balance and the post-allocation current year balance

Year Allocation % Change

The percentage increase or decrease between the pre-allocation current year balance and the post-allocation current year balance

Prior Year Actual

This amount is calculated by taking the debits minus the credits when the GL Account Code's Section Account Category is "Expenditures".

  • If the above does not apply, this amount is calculated as the credits minus the debits. This amount is based on the organization's fiscal 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

Use the Filter tab to narrow down and define the data using the available filters.

Use the Options tab to Summarize Amounts on the report, or to implement security features.

  • Select "Summarize Amounts" to add amounts together and display one line item with the total amount. All document information must be identical for the system to add items together.

  • Select "Do Not Allow Changes to this Report" to secure the report so that other users cannot save their changes to it. This option can only be undone by the user that locked the report.

  • You can 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.

  • Select the "Statement Level" option to determine the statement level to print to. These levels (1 through 3) were created when the section titles were entered when building the financial statement format (see Financial Statement Format Builder Form).

  • Select the "Include Equity Section" 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 (see Financial Statement Format Builder Form).

  • Select the "Year End Adjustments" option to include year end adjustments on the report. This entry type was designated during transaction entry.

  • Select the "Suppress Lines with All Zeros" option, along with the "Summarize Amounts" option, so that documents with zero amounts do not print. If the debit and credit on the same line nets to zero, then that line will not appear on the report.

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

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