Pre-Allocation Statement of Cash Flows

To access this report, go to Reports > Allocation Management > Pre-Allocation Statement of Cash Flows

Use this report to produce a statement of cash flows. This report shows relevant information about cash receipts and cash disbursements for a period of time and whether they stem from operating, investing, or financing activities. You can print the balance information for posted transactions and any 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 selecting Open Formats. 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).

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

You can choose to use the report as-is by selecting Export or View, or make edits to the report by selecting Edit.

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 the Column Heading.

 

The following columns 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
Account Code

The code assigned to the account

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

Title

The title assigned to the account code

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

The actual amounts received or expended for the current reporting period

  • This is the time between the "Opening Balances" date and the "Ending Balances" date.

Prior Year Current Period

The actual amounts received or expended for the prior year current reporting period

  • This is the time between the "Prior Year Opening Balances" date and the "Prior Year Ending Balances" date.

Current Year

The actual amounts received or expended for the current fiscal year through the end of the report

  • This is the time between the "Current Report Year Begins" date and the "Ending Balances" date.

Prior Year

The actual amounts received or expended for the prior fiscal year through the prior year-end of the report

  • This is the time between the "Prior Year Current Report Year Begins" date and the "Prior Year Ending Balances" date.

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

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