Creating Balance Sheet using Pivot Table page 61

18. You should see a Balance Sheet report in a new sheet.

Here is a sample of the result:

3	Sum of RM-NET
4 	BALANCE SHEET-MAIN CATEGORY			Total
5 	CAPITAL						(11,000,000.00)
6 	CURRENT ASSETS					17,267,769 15
7 	CURRENT LIABILITIES				(15,890,305 14)
8	FIXED ASSETS					13,291,438.72
9	INTER-COMPANY					15,274,004.33
10 	INVESTMENT					62,500.00
11	UNAPPROPRIATED PROFIT				(19,005,407 06)
12	Grand Total					0.00
13

This would become the most basic form of our Balance Sheet report created using PivotTable function. This report shows only the main categories in the Balance Sheet.