Skip to Content

Creating and updating forecasts

Use Budget & Forecast → Forecasts to generate a profit-and-loss forecast and adjust the future periods. Review the source data and rules before treating generated values as your working forecast.

Set up a forecast

  1. Click New Forecast.
  2. Enter Forecast Name and select the fiscal year and Forecast for period.
  3. Choose Forecast using.
  4. Select the source actuals period or budget required by that method.
  5. Review Summary.
  6. Use Set rules if you need account-group adjustments.
  7. Click Next.

Average of actuals supports recent-month ranges and a custom range. Budgets uses a selected budget as its source. Inspect the generated summary to confirm which method and period are in use.

Apply account rules

Use Set rules to increase or decrease the selected income, cost-of-goods-sold, expense, or other account groups. Search the accounts, then use Select all or Deselect all to set the scope.

Check the percentage and included accounts before applying the rule. Accounts you deselect are not adjusted by that rule. Use Edit rule or Remove rule to maintain the setup.

Review and save values

Inspect the generated worksheet and adjust the future-period cells that need a different assumption. Use the row copy control when a value should repeat, and review the resulting totals.

Click Save Forecast for the first save. Later saves use Update Forecast. Forecast settings lets you change the saved name and inspect setup; use Back to revisit setup options that require the first step.

Refresh actuals or regenerate

Use the update-actuals control to refresh past-month data while preserving forecast values. Regenerate recalculates the forecast; review the result after using it.

Rule changes do not override manually edited values. Check those cells separately when you revise an assumption.

Adjust the view and export

Display options includes Autosave forecast, Hide blank rows, Compact, and Round off numbers. Click Apply for the display settings.

Select rows for Batch Actions → Clear data when removing forecast values, and confirm the selection. Use Export/Print → Export to Excel or Print/Save as PDF to save the worksheet output.

Return to the list to open Forecast vs Actuals, edit a forecast, or use Delete and confirm an unwanted plan.

Last updated on