SPREADSHEET
Budget versus actual template
Enter the budget and the actuals of the P&L and see, for the month and year to date, the variance in R$ and in %, the traffic light that respects the sign of each line, and what needs explaining.
What's inside
Budget versus actual is the comparison, line by line of the P&L, between what the company planned and what happened. Its value is not in the table, it is in the conversation that follows: why it drifted, who answers for it and what will be done. This template calculates the variances, separates favourable from unfavourable and organises the explanations.
- Before you fill it in3
- Reading the comparison3
- Turning it into action3
- For whom
- Controllers, FP&A analysts, finance managers and business owners
The material is right below
Open the spreadsheetGet the spreadsheet
We hand it over right away, on this same screen.