Appearance
Variance
Also known as
- Variance analysis
- budget vs actual
- BvA
- plan vs actual
- actual vs budget
- variance commentary
- variance explanation
- variance comments
- favourable
- adverse
Variance analysis compares the budget scenario with the actuals for a month or the year to date, account by account, next to the full-year budget and forecast. Accounts beyond the variance threshold are flagged, and controllers explain them with comments that travel into the management pack.
Analyse a period
- Open PlanningVariance.
- Choose the Budget scenario (default: the primary scenario) and the Month (default: the previous month).
- Choose Year to date (from the start of the fiscal year to that month) or Month (that month only).
The line under the title shows the scenario, the period, the threshold (for example threshold 5%) and the forecast used (the latest one, Forecast {number}, or No forecast).
Net income: budget, actual and forecast charts the year by month. The Budget vs actual table has:
| Column | Meaning |
|---|---|
| Budget, Actual | Plan and ledger amount for the period. |
| Variance, Variance % | Actual − budget. Green is favourable (more revenue or less cost), red adverse. |
| Budget (year), Forecast (year) | Full-year budget and full-year forecast (actuals + forecast). |
| Forecast vs budget | Full-year forecast − full-year budget. |
| Comments | Number of comments on the account. |
A warning diamond before the account means "Above the {threshold}% threshold". The threshold is set in General settings.
Explain a variance
Permission:planning.variance.comment- Select an account row. The Commentary drawer opens with the comments already made for this scenario.
- Fill in the form (below) and select Add comment. The message Comment saved appears and the count in Comments goes up.
- To remove your own comment, select the bin next to it and confirm Delete comment.
| Field | What to enter | Required / default |
|---|---|---|
| Category | Timing, Volume, Price, Mix, One-off, Error or Other. | Other |
| Explanation | Why the account differs from plan. Message: "Explain the variance". | Required |
| Action | What will be done about it. | Optional |
| Owner | Who follows up. | None |
| Explains the year to date (not one month) | Tick to attach the comment to the year to date instead of the chosen month. | Off |
Each comment shows its category, month (or Year to date), author and date.
Differences by role
- Only the author of a comment, or a holder of Permission:
planning.variance.manage, can delete or edit it. - Permission:
planning.variance.viewalone shows the analysis without the comment form.
The Budget vs actual vs forecast report (category Planning) in Reports prints the same table with its comments for the management pack.
Related
- Rolling forecast and Scenarios
- Close: "variance commentary" is a default close task
- Close and report
- Statements, Budgets
- Reports, Dashboards and KPIs
