30-60-90 Forecast

Key Information

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

Display

Select options as necessary:

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. Allows you to display all budget lines even if the data entered is zero.
Line. Allows you to select the budget lines you would like to view. You may select any or all of the budget lines.

Base Dataset

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

Period. Select a period of dataset.
Year. Select a year of dataset.

Comparative Dataset

Displays the Year and Type of data that are grouped in an organized manner. Comparative Datasets are compare with the Base Datasets. This is typically be the original budget.

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

Running the Report

To run the report:

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

Related topics: