in the Budget and Actual worksheets, each month will have 3 columns: Actual, Budgeted and Variance. Copy and paste in the data (including totals) from the Actual and Budget worksheets.

Then calculate the differences between the actual and budgeted figures. To do this, create the column titled, Variance. Use red font to show negative variance.

Use relevant help functions to rectify any issued you experience when preparing the spreadsheet.