Pre-Allocation Statement of Cash Flows
|
Access this report using Reports>Allocation Management>Pre-Allocation Statement of Cash Flows. |
Use this report to produce a statement of cash flows. The purpose of a statement of cash flows is to provide relevant information about the cash receipts and cash disbursements during a period 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. Sessions with a status of Batch-to-Suspend are not included in this report. However, it does contain any unposted transactions for allocation sessions (JVA).
To use this report, the Statement of Cash Flows must first be set up using Reports>Financial Statements>Create Statement Formats. This format is where you will design the statement format to follow, either the direct or indirect method of reporting cash flows.
Advanced Security Users
Account Level Security is available for this report. This feature allows the Administrator to define the account codes and related amounts a user can view in the report. When account level security is activated by the Administrator for the organization (Security>Set Up Account Level Segments) and enabled for a user or group (Security>Set Up Account Level Security), the report will only print account information the user is allowed to see. Note that if a user does not have Account Level Security enabled, the user will see all account codes.
If the "Print Disclaimer on Report" check box is selected on the Security>Set Up Account Level Segments form, "This report may be affected by Account Level Security" prints in the header of this report. In that case, an * also prints after the report title.
Multicurrency Users
The Currency, Rate Type, Rate, and Exchange Rate Override options are only available if the Administrator has installed and added the Multicurrency module (Organization>Add a Module).
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 and Current Period Dates. The Account Balances Begin date and Current Reporting Year Begins date are used to obtain the beginning balances for the Opening Balances date.
Use the Financial Statement Format box to select the financial statement to include in the report. And, the Cross Year Reporting feature (A Year-End Close will be simulated for this report) allows reports to be run 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. |
|
Account Code |
The actual code assigned to the account. The report prints the account code, such as 201, 05, or 45001. |
|
Title |
The actual 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, which is between the Opening Balances date and the Ending Balances date (on the Setup tab). |
|
Prior Year Current Period |
The actual amounts received or expended for the prior year current reporting period, which is between the Prior Year Opening Balances date and the Prior Year Ending Balances date. |
|
Current Year |
The actual amount received or expended for the current fiscal year through the end of the report, which is between the Current Report Year Begins date and the Ending Balances Date (on the Setup tab). |
|
Prior Year |
The actual amounts received or expended for the prior fiscal year through the prior year-end of the report, which is 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 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 or Filter tab.
Use this tab to set up any Available Options for the report.
|
Options |
Description |
|
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. |
|
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 Lines with All Zeros |
Select this option so that documents with zero amounts do not print. This eliminates records having zero in all amount columns. 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 the Administrator has previously set up (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.