Why does the current period value not match the forecast I configured?

In Embat, the value shown for the current period may differ from the forecast you configured because it dynamically combines actual transactions with the forecast for the remaining days of the period.

If you’re using manual, historical/AI, or custom forecasts, the system applies the formula:

Cell Value = MAX(F_{Period}, A_{YTD})

Where:

• F_{Period} = total forecasted value for the period
• A_{YTD} = sum of actual transactions to date
•  

This ensures that the displayed value is never lower than the actuals recorded so far, even if the forecasted amount is smaller.

If you’re using automatic forecasts (e.g., from ERP invoices), the calculation is:

Cell Value = Actuals to date + Forecasts with due dates from today to the end of the period

This approach provides a more accurate and up-to-date view of your current cash position.

If you have any further questions, contact the Customer Experience team or submit a request using this link.