Reporting Actuals vs Budget with pivot tables
Seven of David Carter's self-teach tutorials on Excel pivot tables are about budgets. The first ever AccountingWEB tutorial back in 1999 was entitled Budgeting with Pivot Tables, while the most recent are the series of three tutorials issued in February 2007. In this aricle he sets them all in context.
Handling budgets with pivot tables is easy. The hard bit comes when you have to compare the budgets to the actuals.