1. NetSuite Enterprise Performance Management
  2. NetSuite Planning and Budgeting
  3. Planning and Budgeting Financials
  4. Planning and Budgeting Financials User Guide
  5. Reporting and Analytics
  6. Working With Forecast Variance Reports
  7. Comparing the Actual and Forecast Variances

Comparing the Actual and Forecast Variances

The Act vs Fcst Var and Comment form shows the Actual and Fcst values of a Period by the selected Year, for comparison. The variances between Actuals and Forecast are shown as a value and percentage. The form also includes the option to add commentary at the Departmental 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:

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 Act vs Fcst Var and Comment.

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

    If you use Forms 1.0, click the Go icon Screenshot of the Go icon to apply the changes to the POV.

  5. 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 see 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 Income Statement Details.

    The Income Statement -Account Details form opens in a new tab. The form shows 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 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

General Notices