Comparing actuals to budget & creating rolling forecasts in Excel

How to setup your management accounts so that it is easy to compare actuals to budgets and create rolling forecasts (combining actuals to date and remaining period budget to assess the likely outcome at the end of the year)

------------------------------------------------------------------------------------------------------------------------------------------------------

------------------------------------------------------------------------------------------------------------------------------------------------------
⏲Time Stamps
00:00 Comparing budget, forecast and actuals in Excel
00:10 Stop overwriting budget numbers with actual numbers
00:37 Using consistency, setup the actual and forecast numbers
00:53 Rolling forecast- actuals up to the latest date and forecast from then on
01:35 Create a variance analysis sheet comparing actuals to budget