Forecasting can get complicated quickly. We have put together four popular forecasting methods with additional information on the Dynamic Budgets website. If you have a budgeting tool, you may incorporate one or more of these methods or use our FREE Excel-based tool that pulls data from Dynamics GP.

  1. Duplicate the original budget and make line item updates
  2. Create a blended row of YTD Actuals & update the remaining month values
  3. Create a blended row of YTD Actuals & Budget (or Prior Year or Annualized Values) and add adjustment rows
  4. Use a Standard 4-line calculation: (Forecast * % change) + $ Adjustment = Projection