Today, I added a sample Balance Sheet built with a Pivot Table to the 'Excel Charts' section.

Using Pivot Tables to build such accounting reports is nice because it automatically enables drill-down capabilities.

The sample contains both the report and data in one workbook, but of course it makes more sense to link the Pivot Table to data that sits in a corporate database with read-only permissions for the majority of users. That way, only approved data is used in Excel reports.