30-60-90 Single Period Comparison

The 30-60-90 Single Period Comparison is designed to help you see how well you modify your periodic 30/60/90 forecasts as you approach the actual results.

Key Information

Displays the actual results for the month/period selected and then shows your forecast for that month 30-days out, 60-days out, and 90-days out. With this report, you also can see the original budget for the selected month/period. You may fill one of the columns with the same month from last year for comparative purposes.

Report Options

OptionDescription

Display            

Choose additional options to be displayed in the report.

  • Summary-Rollup Level P&L View—Displays budget line totals by period.
  • Detail-Account Level Data—Displays amounts and KBIs by detail for each by profit center.
  • Lines with Zero Values—Display all budget lines even if the data entered is zero.
  • Budget Lines—Displays the selected budget lines.

Comparative Dataset (Column 2)

Displays the Year and Type of data that are grouped in an organized manner. The Comparative Dataset is compared with the Base Dataset. By default, the Base Dataset appears in the first column and this dataset appears in the second column of the report.

  • Year—Select a year of dataset to compare.
  • Type—Select a type of dataset to compare.

Other Datasets (Columns 3-5)

Displays data that may be 30, 60, 90 days - or may be the results from the same month last year.

  • Period—Select a period of dataset to compare.
  • Year—Select a year of dataset to compare.
  • Columns #3, #4, #5—Select the Thirty, Sixty, Ninety, or Actuals dataset to use as a comparison.

Variances

Displays the differences between the Comparative and the 30/60/90 projections, or displays the difference between Actual and the Comparative in either dollars or percentages.



Related topics: