Creating Trial Balance using Pivot Table operation Sample page 54

A sample Trial Balance constructed using the PivotTable operation is shown below. In your own results, you should check that the total figure at the bottom of the report is 0 (zero) indicating a balance Trial Balance.

	A
3
4 Sum of Value	Column
5 Row	RM-CREDIT	RM-DEBIT	Grand Total
6	ACCOMODATION						34.473.62
7 	ACCRUAL AUDIT FEE					(2.000.00)
8	ACCRUAL-SECRETARIAL FEE				(400.00)
9	ACCRUED-COMPANY TAX					(152.000.00)
10	ACCRUED-EPF							(125,610.00)
11	ACCRUED-INCOME TAX					(12,667.00)
12	ACCRUED-KOPERASI					(14,578.20)
13 	ACCRUED-NET BONUS					(1.781.00)
14 	ACCRUED-NET SALARY					25.480.00
15	ACCRUED-SOCSO						(8,943.10)
16 	ACCRUED-UNION						(790.00)
17 	ANNUAL DINNER						4.854.22
18	ASSOCIATE COMPANY A					8,000,000.00
19 	ATTENDANCE ALLOWANCE-ADMIN			4,090.00
20	ATTENDANCE ALLOWANCE-FACTO			12,460.00
21	AUDIT FEE							2,000.00
22 	BANK A								(535,494.17)
23 	BANK B								(1.397.293.78
24	BANK C								42,117.17
25	BANK CHARGE							7,889.05
26	BANK D								120,600.00
27	BANK E-FIXED DEPOSIT				250,000.00
28	BONUS-ADMIN							56,200.00
29	BONUS-FACTORY						63,371.00
30	BUILDING							7,253,585.00
31	CANCELLED							0.00
32	CANTEEN COUPON						660.00
33	CLOSING STOCK-FINISHED PRODUCT-CA	364,280.00
34	CLOSING STOCK-FINISHED PRODUCT-COSA	(364,280.00)
35	CLOSING STOCK-RAW MATERIAL-CA		2.746,848.68
36	CLOSING STOCK-RAV MATERIAL-COSA		[2,746,848.68]

NOTE
You will find a beginner's guide on PivotTable operations at the end of the book. Refer to Topic 31.

54