Columns for Cash Flow Forecast Report
The Cash Flow Forecast report contains a standard set of columns. You do not have the option to select columns for this report.
The first section of the report contains the following information:
- Average Collection Days
- Average Payment Days
- Budget names
- Organizations
- Numbers of Passed Periods Used
The second section of the report contains information about cash flow from operating activities:
Field | Description |
---|---|
Cash Inflow | The Cash Inflow section contains the
Increase/decrease in accounts receivable row, which displays the inflow of cash, either for a year-to-date or for the current period. These amounts are the sum of cash receipts (CR transaction type) posted to the AR accounts specified in
.
Future periods: The future calculations are based on budgeted revenue and the average collection period. The budgeted revenue is based on the General Ledger budget amounts for revenue accounts specified in invoice mapping. Vantagepoint calculates the average collection period based on the Accounts Receivable Ledger. (You can override this value on the Options tab.) Vantagepoint then calculates the future period as a piece of the budget in the relevant months based on the collection period. Example: Future amounts calculation for the first future period after the current period of April. The collection period is 36 days 24/30 of the revenue budget for March plus + 6/30 of the revenue budget for February The result of this calculation is the first future period amount. The next future period amount is calculated similarly. If budgeted revenue is a credit balance, this row displays positive amounts to show an inflow of cash. |
Cash Outflow | The Cash Outflow section contains the
Increase/decrease in accounts payable and
Increase/decrease in salary cost rows.
|
Other Changes in Cash | This row displays changes in cash other than those reflected in the inflow and outflow amounts described above, either for a year-to-date or for the current period. These amounts are the sum of transaction amounts posted to the bank code accounts specified on the Bank Codes form ( | ), excluding any amounts already included in either the inflow or outflow amounts. This row does not show future amounts.
Net Cash | This row displays the difference after subtracting cash outflow from cash Inflow and the value for the Other Changes in Cash column. Net Cash includes all mapped bank code accounts for actual amounts. For future amounts, it shows the total of all future periods. |