Tracking & Monitoring
3 min

Understand Actual vs Forecast variances

Calculation method, alert threshold and color coding of variances.

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

  1. Identify the cause: seasonality, payment delay, exceptional expense?
  2. Update your forecasts in the Forecast page if the trend persists
  3. Document the reason in a note (comment) for your collaborators

Related articles

Discover the Pilotage dashboard

Connect Qonto and Wise

Import a CSV bank statement