What the template includes
- Plan sheet: revenue, cost of goods, expenses and profit for 12 months.
- Actual sheet: the same structure for actual figures.
- Variance sheet: choose a month to see plan, actual, variance and percentage for the month and the year to date.
The sign of a variance is read by line item: a negative variance in revenue and a positive variance in expenses are unfavourable and highlighted in red.
A plan vs actual routine
- Close the previous month's actuals by the 5th.
- Write down the reason for variances above 10%: price, volume, a one-off event.
- In the meeting with management, discuss only significant variances and actions.
- Once a quarter, update the forecast for the rest of the year.
For one-page indicators: KPI dashboard.