Budgeting With Pivot Tables - The Sequel
Over 1,200 AccountingWEB members read David Carter's first tutorial on budgeting with pivot tables. In the eagerly awaited sequel, Carter goes beyond setting up initial budgets to explain how to add the actuals each month and use Excel pivot tables to report on Monthly and Year-to-Date Actuals versus Budget, plus Variances – both at company and departmental level.
The Formulas function is used to calculate variances between budget and actual. The tutorial then advances to generating standard report formats for Monthly Actuals, Monthly Budget and Monthly Variance, as well as YTD Actual, YTD Budget and YTD Variance.
There are restrictions on how far you can format a pivot table. The tutorial concludes by showing how you can copy a pivot table without the underlying data, then revise its format in any way you want before finally circulating it to management.
Visit AccountingWEB's Expert Guides section to read more of David Carter's pivot table tutorials.
Voice of the Editor
Which isn’t completely true. I mean, occasionally I drop by when I manage to sneak out of the nonstop frat party over at Going Concern, but I’m mostly a wallflower over there. I’m happy to say that I’ve been given express permission (or explicit orders, if you like) to wander over here to AccountingWEB more often.
Why is that, you might ask? My job is to replace the irreplaceable Gail Perry as Editor-in-Chief. What does that mean? I don’t really know! I think it’ll be fun getting a feel for things, throwing in my own thoughts here and there, and listening to the discussions you’re having about the accounting profession.