David Carter's previous AccountingWEB pivot table tutorials show you how to create pivot tables from accounting transactions exported into Excel. However, you can also create pivot tables out of monthly balances. This tutorial shows you how.
Prior to this tutorial you have exported a Trial Balance report out of your accounts package into Excel. In the tutorial, you are going to apply pivot tables and Excel's Vlookup function to the Trial Balance file to create a Profit and Loss account for each department of your company.
Note: This tutorial is designed to be used with Excel 2003 and Excel 2000. If you use Excel 97 or earlier there may be one or two small differences.
Before you start you will need to download two Excel files from AccountingWEB ' Trial_Balance.xls and Lookup.xls...