Comparing the Actual and Forecast Variances for the Last Closed Period

The CurMo Act vs Fcst Var and Comment form displays net income variances between the current month Actuals and the Forecast for the last closed month. You can use this form to review and compare Actuals against an active or archived Forecast. Each variance appears as a value and percentage. The form also includes the option to add commentary at the Department level.

Note:

Substitution variables are used to set up Years, Current and Previous Periods, and Version members.

Form values populate based on the following calculations:

• The Act vs Fcst $ column displays the variance between the Actual and Forecast values for the current period.

  Act vs Fcst $ = Actual – Forecast

• The Act vs Fcst % column displays the variance between the Actual and Forecast values for the current period, expressed as a percentage.

  Act vs Fcst % = ((Actual – Forecast) ÷ Forecast) × 100

To review Actual and Forecast variances:

1. From the Home page, click the Reporting and Analytics card.

2. Click the 1 tab on the left-hand side to go to the Forecast Variance Reports.

3. Click CurMo Act vs Fcst Var and Comment.

4. In the Point of View, select a Version, Subsidiary, Currency, and Department.

5. To apply the changes, click the Go icon .

   The Actuals for the current month appear in the Actual column. The Forecast values of the selected Version for the current month appear in the Forecast column, for comparison.

6. If necessary, enter any comments in the open (white) cells in the last column.

   Note:

   You cannot enter commentary at Total Department level.

   Tip:

   To show all the text on a row, click the cell to open the text box and drag the box's handle to resize the box.

7. (Optional) To view a detailed analysis of a specific Account member, right-click the Account and select Drill to CurMo Inc Stmt - Account Details.

   The CurMo Inc Stmt - Account Details form opens in a new tab. The form displays the current year Actual and Forecast data at a detailed level in the context of Relationship, Department, Class, Item, and Location.

   1. To return to the initial form, click CurMo Act vs Fcst Var and Comment at the bottom of the page.

8. Click Save.

9. To refresh the data area with the latest updates, click Refresh.

Related Topics

Working With Forecast Variance Reports

Comparing the Actual and Forecast Variances

Reviewing Month-Over-Month Actual Variances

Comparing the Year-to-Date Actual and Forecast Variances

Comparing the Full-Year Actual and Forecast Variances

General Notices