Best way to compare actuals with your budgets/ forecasts
One of the most common mistakes we see in forward looking spreadsheets is that when it is time to compare the actual results to the budget/ forecast, the formulas for the budget, forecast or financial model are overwritten with the actual numbers.
In all likelihood the spreadsheet will stop working correctly and you will have difficulty trying to piece together what:
- you initially budgeted/ planned for,
- the revisions made to your initial planning
- and what actually happened.