Deltek Vantagepoint Help

Using the Help Search
Using the Help Search
  • Phrase:Returns all topics that contain the exact phrase in the search criteria. Use quotation marks around the phrase.
    Ex."system administration"
  • And:Returns all topics that contain all the words in the search criteria, in any combination. Insert a plus sign between all words in the search criteria.
    Ex.system + administration
  • Or:Returns all topics with any combination of words in the search criteria. This is the default.
    Ex.system administration
For more information:Searching Online Help

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 Settings > Billing > Invoice Accounts.

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.
  • Increase/decrease in accounts payable: This row displays outflow of cash for AP, either for a year-to-date or for the current period..

    These amounts are the sum of payment processing transactions (PP transaction type) posted to the accounts specified on the Liability Accounts tab of the Accounts Payable settings form in Settings > Cash Management > Accounts Payable.

    Future Periods: The future calculations are based on budgeted reimbursable, direct, and indirect expenses in conjunction with average payment terms. This includes all expense accounts except Labor Types accounts (labor accounts), Time Analysis accounts (labor accounts), the Job Cost Variance account, and Other Charges and Revenue accounts. Average payment terms are based on the Accounts Payable Voucher report. (You can override this value on the Options tab.) Vantagepoint then calculates the future period as a piece of the budget based on the average payment terms.

    Example: Future amounts calculation for the first future period after the current period of April. The collection period is 26 days.

    4/30 of the expense budget for April + 26/30 of the expense budget for March

    The result of this calculation is the first future period amount. The next future period amount is calculated similarly.

    This row displays a negative amount using parentheses to show outflow of cash.

  • Increase/decrease in salary cost: This row displays outflow of cash for salaries, either for a year-to-date or for the current period. For actual amounts, this is the gross salary expense.

    These amounts are the sum of amounts posted to the following accounts:

    • Direct and indirect accounts specified on the Labor Posting form (Settings > Accounting > Labor Posting).
    • Accounts specified on the Time Analysis Setup form (Settings > Accounting > Time Analysis).

    Future periods: For future columns, this is the expected salary expense based on labor budgets. Vantagepoint calculates the budgets from the general ledger budgets for the set of accounts used to calculate the year-to-date and current period amounts.

    The Increase/decrease in salary cost row displays both actual and future amounts as negative amounts using parentheses to show outflow of cash.

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 (Settings > Cash Management > Banks), 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.