Versions Compared

Old Version 1

changes.mady.by.user Julie Leake (Unlicensed)

Saved on

compared with

New Version Current

changes.mady.by.user mhigginbotham

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

30/60/90 Forecast

Key Information

  • Allows you to view View each of the three months that you have re-forecasted along with the summary for the three months.
  • Displays data for your 30-Day, 60-Day, and 90-Day Forecasts, as well as a Comparative Dataset. Each forecast is compared to the 30-Day, 60-Day, and 90-Day Forecasts, and Variances are displayed. Totals for 30-60-90-Day, 30-Day, 60-Day, and 90-Day Forecasts and the Variances are also displayed.

Click the image to view a sample report.

Report Options

OptionDescription

Display

Allows you to choose options to be displayed in the report.

Select options as necessary:

  • Summary-Rollup Level P&L View
. Displays
  • —Displays budget line totals by period.
  • Detail-Account Level Data
. Displays
  • —Displays amounts and KBIs by detail for each by profit center.
  • Lines with Zero Values
. Allows you to display
  • —Display all budget lines even if the data entered is zero.
  • Line
. Allows you to select
  • —Select the budget lines you would like to view. You may select any or all of the budget lines.

Base Dataset

Allows you to select the

Select the first month you

wish

want to be displayed. The program automatically selects the next two successive periods to complete the three periods.

  • Period
. Allows you to choose which
  • —Select a period of
the
  • dataset
you wish to view
  • .
  • Year
. Allows you to choose which
  • —Select a year of
the
  • dataset
you wish to view
  • .

Comparative Dataset

Consists of a

Displays the Year and Type of data that are grouped in an organized manner.

The Comparative Dataset is the dataset to which the Base Dataset is compared. This will

Comparative Datasets are compare with the Base Datasets. This is typically be the original budget.

  • Year
. Allows you to choose which
  • —Select a year of
the
  • dataset
you wish to use as a comparison
  • to compare.
  • Type
. Allows you to choose which
  • —Select a type of dataset
you wish to use as a comparison.

Running the Report

To run the report:

  1. Choose Comparative from the Reports menu.
  2. Click 30-60-90 Forecast. The report options screen is displayed.
  3. Select the appropriate View.
  4. Select either Summary-Rollup Level P&L View or Detail-Account Level Data.
  5. Select Lines with Zero Values if desired.
  6. Select or de-select Lines as needed.
  7. Select a Period and Year for the Base Dataset.
  8. Select the Year and Type for your Comparative Dataset.
  9. Click the Run icon. The report is displayed.
  • to compare.


...

Related topics: