Creating Balance Sheet using Pivot Table show sub-categories pg 61 62

Creating Balance Sheet using Pivot Table show sub-categories

We can make the report show the sub-categories in each main category. Here is how to do it

1. Click any cell in the report.

2. Right-click once.

3. A floating menu will appear. Select Wizard.

4. A dialog titled PivotTable and PivotChart Wizard Step 3 of 3 will appear

5. Click the Layout button.

6. A dialog titled PivotTable and PivotChart Wizard - Layout will appear
61
7. The button BALANCE SHEET MAIN CATEGORY (partly hidden) is already in the ROW box.

8. The button RM-NET is already in the DATA box.

9. Now drag the button BALANCE SHEET-SUB CATEGORY (partly hidden) into ROW box but below the BALANCE SHEET MAIN CATEGORY button, and drop it there.

10. Click OK.

11. You will return to the previous dialog (Step 3).

12. In this previous dialog, click Finish.

You should see a Balance Sheet report (now with an additional column) in a new sheet.

Here is a sample of the report:

	A						B						C
2	
3	Sum of RM-NET
4	BALANCE SHEET			BALANCE SHEET
	MAIN CATEGORY			SUB CATEGORY			Total
5	CAPITAL					CAPITAL					(11,000,000.00)
6	CAPITAL 				Total					(11,000,000.00)
7	CURRENT ASSETS			CASH IN BANK			412,717.17
8							CASH IN HAND			25,429.86
9							OTHER DEBTOR			274,269.23
10							STOCK					3,371,885.28
11							TRADE DEBTOR			13,183,467.61
12	CURRENT ASSETS 			Total					17,267,768.15
13	CURRENT LIABILITIES		BANK OVERDRAFT			904,934.63
14							OTHER CREDITOR			(1,663,415.98)
15							OTHER DEBTOR			880.00
16							SHORT-TERM LOAN			600,000.00
17							TRADE CREDITOR			(10.425.614.53)
18	CURRENT LIABILITIES 	Total					(16,890,305.14)
19	FIXED ASSETS			FIXED ASSET				13,291,408.72
20	FIXED ASSETS 			Total					13.291,438.72
21	INTER-COMPANY			ASSOCIATED COMPANY		8,000,000.00
22							HOLDING COMPANY			6,423,336.33
23							SUBSIDIARY A			850,668.00
24	INTER-COMPANY			Total					15,274,004.33
25	INVESTMENT				INVESTMENT				62,500.00
25	INVESTMENT				Total					62,500.00
26	UNAPROPRIATED PROFIT	UNAPROPRIATED PROFIT	(19,005,407.06)	
27	UNAPROPRIATED PROFIT	Total					(19,005,407.06)
28	Grand Total										0.00								

62