Forecast Report

The Forecast report will always show all 12 months in the fiscal year. Actuals will be shown through the Ending Date (defaulted to the Last Closed Month) and the budget for the remaining months. All 12 months will be totaled and compared to the annual budget. This is an excellent report for end-users as it indicates the remaining budget and any anomalies of which to be aware.

Forecast-Specific Report Criteria

• Detail - Provides a drop down to choose All Dimensions or Expand
  • All Dimensions - When rows are set to a Dimension or Account Category clicking Expand will display the sub-departments with the appropriate sub-totals
  • Expand - When rows are set to a Dimension or Account Category clicking Expand will display the sub-departments as well as accounts within the department and sub-departments as well as the appropriate sub-totals.

Forecast General Report Criteria

• Ending Date - Will show actuals in the months through the ending date.
• Months - Determines how many months of data will be reviewed with the most recent being the ending date. This will default to the month in the fiscal year that corresponds to the Ending date. 
• Budget - Allows the user to choose which budget to compare actuals to. By default, non-admin-users will only see the default budgets. 
• Rows - Controls the grouping of data on the rows. The rows can be set to accounts, account categories, or any of the dimensions within the system.
• Include Excluded Data - Will show accounts or dimensions that are set to Excluded via the Setup section.
• Dimension Filters - When applied, will filter the report to the selected dimension. When a top-level dimension is selected, the report will show all sub-dimensions.
• Account Category - When applied, will filter the report to the selected account category.
• Load - Refreshes the report with whatever criteria have been applied.
• Export - Most reports can be exported to either MS Excel or PDF.