How variances are calculated
For each category and each month, YourPlanz computes:
Variance (%) = (Actual − Forecast) / |Forecast| × 100
The alert threshold
A variance is considered significant above 10% (absolute value). Beyond this threshold, an automatic alert is created for the affected category and month, only for past or current months with imported real data.
Color coding
- Green: variance below 5%, on track
- Orange: variance between 5% and 10%, to monitor
- Red: variance above 10%, action required
Reading variances
On revenues
- Positive variance = you earn more than planned (favorable)
- Negative variance = revenues below targets (to analyze)
On expenses
- Positive variance = you spend more than planned (unfavorable)
- Negative variance = savings achieved (favorable)
What to do when facing a variance
- Identify the cause: seasonality, payment delay, exceptional expense?
- Update your forecasts in the Forecast page if the trend persists
- Document the reason in a note (comment) for your collaborators