Cash Forecast Position

The Cash Forecast Position model calculates the forecasted ending balance by retrieving the ending balance from the last previous day bank statement and adding the active forecast amount net change. This model does a full refresh every orchestration.

Analyze by Date: Forecast Date

Measure	Source and/or calculation
Cash Forecast Position Account Amount	SUM(CashForecastPeriodAmount.ForecastAmount)
Cash Forecast Position Account Beginning Balance	Account Beginning Balance – Account Amount
Cash Forecast Position Account Ending Balance	Bank Statement Ending Balance + SUM(CashForecastPeriodAmount.ForecastAmount)
Cash Forecast Position Enterprise Amount	SUM(CashForecastPeriodAmount.ForecastAmount) * CashForecastAccount.CorporateBaseCurrencyRate
Cash Forecast Position Enterprise Beginning Balance	Enterprise Beginning Balance – Enterprise Amount
Cash Forecast Position Enterprise Ending Balance	(Bank Statement Ending Balance + SUM(CashForecastPeriodAmount.ForecastAmount)) * CashForecastAccount.CorporateBaseCurrencyRate
Cash Forecast Position Location Amount	SUM(CashForecastPeriodAmount.ForecastAmount) * CashForecastAccount.LocationCurrencyRate
Cash Forecast Position Location Beginning Balance	Location Beginning Balance – Location Amount
Cash Forecast Position Location Ending Balance	(Bank Statement Ending Balance + SUM(CashForecastPeriodAmount.ForecastAmount)) * CashForecastAccount.LocationCurrencyRate