Reviewing Month-Over-Month Actual Variances
The MoM Actual Var and Comment form shows the Net Income variances between two previously closed periods by Subsidiary and Department. You can use this form to review the month-over-month (MoM) Actual variance as a value and a percentage. The form also lets you add commentary at the Department level.
Substitution variables to set up Years, Current and Previous Periods, and Version members.
The form fills in values based on these calculations:
-
The MoM $ Change column shows the month-over-month variance amount.
MoM $ Change = Period before Previous Amount – Previous Period Amount
-
The MoM % Change column shows 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.
-
To open Forecast Variance Reports, click the 1 tab on the left.
-
Click MoM Actual Var and Comment.
-
In the Point of View, choose a Version, Subsidiary, Currency, and Department.
-
If needed, enter any comments in the open (white) cells in the last column.
Note:You can't enter commentary at Total Department level.
Tip:To see all the text in a row, click the cell to open the text box, then drag the box's handle to resize it.
-
(Optional) To see 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 shows the Actual details for the selected Account by Relationship, Department, Class, Item, and Location.
-
To go back to the initial form, click MoM Actual Var and Comment at the bottom of the page.
-
Click Save.
-
To update the data area with the latest updates, click Refresh.