Reviewing Month-Over-Month Actual Variances
The MoM Actual Var and Comment form displays the Net Income variances between two previously closed periods by Subsidiary and Department. You can use this form to review the month-over-month Actual variance as a value and percentage. The form also includes the option to add commentary at the Department level.
Substitution variables are used to set up Years, Current and Previous Periods, and Version members.
Form values populate based on the following calculations:
-
The MoM $ Change column displays the month-over-month variance value.
MoM $ Change = Period before Previous Amount – Previous Period Amount
-
The MoM % Change column displays the month-over-month variance, expressed as a percentage.
MoM % Change = ((Period before Previous Amount – Previous Period Amount) ÷ Period before Previous Amount) × 100
To review month-over-month variances:
-
From the Home page, click the Reporting and Analytics card.
-
Click the 1 tab on the left-hand side to go to the Forecast Variance Reports.
-
Click MoM Actual Var and Comment.
-
In the Point of View, select a Version, Subsidiary, Currency, and Department.
-
To apply the changes, click the Go icon
. -
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.
-
(Optional) To view a detailed analysis of a specific Account member, right-click the Account and select Drill to Actual Inc Stmt Details.
The Actual Inc Stmt - Account Details form opens in a new tab. The form displays the Actual details for the selected Account in the context of Relationship, Department, Class, Item, and Location.
-
To return to the initial form, click MoM Actual Var and Comment at the bottom of the page.
-
-
Click Save.
-
To refresh the data area with the latest updates, click Refresh.