Creating Balance Sheet using Pivot Table show Accounts in sub-categories pg 63

If we want to go further to show the accounts in each of the sub-categories, repeat the steps:

1. Click any filled cell in the report.
2. Right-click once.
3. A floating menu will appear.
4. Select Wizard.
5. A dialog titled PivotTable and PivotChart Wizard Step 3 of 3 will appear.
6. Click the Layout button.
7. A dialog titled PivotTable and PivotChart Wizard Layout will appear.
8. The button BALANCE SHEET-MAIN CATEGORY (partly hidden) is already in the ROW box. The button BALANCE SHEET-SUB CATEGORY (partly hidden) is also already in the ROW box. The button RM-NET is also in the DATA box.
9. Now, drag the button ACCOUNTS into the ROW box but below the BALANCE SHEET-SUB 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 another additional column) in the sheet.
63

	A				B				C							D
4	BALANCE SHEET	BALANCE SHEET	ACCOUNTS	      			Total 
	MAIN CATEGORY	SUB CATEGORY
5	RM-NET
6	CAPITAL			CAPITAL		SHARE CAPITAL 					11,000,000.00
7	CAPITAL 		Total										(11,000,000.00)
8	CURRENT ASSETS	CASH IN BANK	BANK C						42,117.17
9									BANK D						120,600.00
10									BANK E-FIXED DEPOSIT		250,000.00
11					CASH IN BANK 	Total						412,717.17
12					CASH IN HAND	PETTY CASH A				23,362.22
13									PETTY CASH B				2,067.64
14					CASH IN HAND 	Total						25,429.86
15					OTHER DEBTOR	DEPOSIT-ELECTRICITY			200,784.37
16									DEPOSIT TELEPHONE			10,000.00
17									DEPOSIT-WATER				4,000.00
18									DIRECTOR A					43,004.06
19									LEVY						16,310.00
20									STAFF A						5,599.50
21									STAFF B						600.00
22									STAFF C						300.00
23									STAFF D						100.00
24									STAFF E						(1,000.00)
25									STAFF F						(3,300.00)
26									STAFF G						(2,200.00)
27					OTHER DEBTOR 	Total						274,269.20
28					STOCK			CLOSING STOCK-				364,280.00
									FINISHED PRODUCT-CA
29									CLOSING STOCK-				2,746,849.65
									RAW MATERIAL-CA	
30									CLOSING STOCK-				260,755.60
									SEMI FINISHED PRODUCT-CA	
31					STOCK 			Total						3,371,805.28
32					TRADE DEBTOR	CUSTOMER A					1,670,204,00
33									CUSTOMER B					1,715.415.02
34									CUSTOMER C					2,071.225.71
35									CUSTOMER D					1,264,076 37
36									CUSTOMER E					2,199,702.74
37									CUSTOMER F					1,423,315.51
38 									CUSTOMER G					2,839,528.18
39

You can copy, cut, paste and format the report produced by the PivotTable function.
You can create each report above from scratch by dragging appropriate buttons into the Layout dialog box.
64