Budgeting with Pivot Tables #3. Reporting Actual vs Budget
Continuing his series of tutorials on using pivot tables with budgets, David Carter now produces the monthly reports comparing actual to budget, Month and Year to Date.
In tutorial #1 we assembled budgets for the London, Birmingham and Edinburgh regions. We transposed them all into the Combined worksheet of the Budget-tut-master.xls workbook, then used pivot tables to create a consolidated company budget.