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-FINISHED PRODUCT-CA	364,280.00
29									CLOSING STOCK-RAW MATERIAL-CA		2746,849.65
30									CLOSING STOCK-SEMI FINISHED PRODUCT-CA	260,755.60
31					STOCK 			Total					3,371,805.28

TRADE DEBTOR

CUSTOMER A

1,670,204,00

CUSTOMER B

1715.415.02

CUSTOMER C

2.071.225.71

CUSTOMER D

1,264,076 37

CUSTOMER E

2.199.702.74

CUSTOMER E

1,423,315.51

CUSTOMER G

2,839,528.18

1510530701

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.
If you change the underlying data in sheet DATA and/or sheet TB, the PivotTable is not updated automatically. You can update the PivotTable report by refreshing it in the following simple way:

1. Click any cell within the report.
2. Right click.
3. A floating menu will appear.
4. Select Refresh data. The report will be updated.

64