Creating Creditor ageing report using Pivot Table sample 5 pg 84 85

Sample 5

We can design the PivotTable differently. Sometimes we want to see creditors' names appear on the leftmost column of the report while the age groups appear on the topmost row. You can do this just by merely dragging the relevant buttons into appropriate places in the Layout dialog. Drag the ACCOUNT-CREDIT button into the ROW box, and drag the CREDIT-AGE GROUP column into the COLUMN box. A sample result shown below:

	A	B	C	D	E	F	G	H
1
2
3	Sum of RM-CREDIT AGE GROUP	CREDIT 
4	ACCOUNT–		OTHER REF	DATE 	0-30	30-60		60-90		90-120		Grand Total
	CREDIT
5	OTHER
	CREDITOR A		Al/00/0268	8-Jan-01								(216.00)	(216.001
6
7	STACC/11/20	4-Apr-01	(1,650.00)	(1,650.00)
	STACC/9/200	3-Feb-01	(1,224.00)	(1,224.00)
8 	OTHER CREDITOR B	0003	23-Feb-01	(45,720.00)	(45,720.00)
9						AC23116	14-Apr-01	(870.00)	(870.00)
10 	OTHER CREDITOR C	AC22694	2-Feb-01	(870.00)	(870.00)
11						AC23072	6-Apr-01	(2,750.00)	(2,750.00)
12 	OTHER CREDITOR D	AC22689	7-Feb-01	(6,875.00)	(8,875.00)
13						1924788	11-Apr-01	(10,800.00)	(10,800.00)
14  OTHER CREDITOR E	17396	20-Feb-01 	(611.22)	(811.22)
15						17697	(402.75)	(402:75)
16 	OTHER CREDITOR F	17192	7-Feb-01	(2,634.35)	(2.634.35)
17						17696	11-Apr-01	[2,301.86)	[2,301.86)
18 	OTHER CREDITOR G OVERSEA	17680	11-Apr-01	(4,712.15)	(4,712.15)
19 	CREDITOR A			N4901	14-Jan-01
20	(31,224.00)			N5133	8-Mar-01	(31,224.00)	(53,174.19)
21
22	N5498	20-Apr-01	(92,919.25)
23 						TQA0X254T	12-Feb-01	(53,174.19)	(82,919.25)
24	OVERSEA	(423,098.83)	(423,09883)

2960019

RM 1.50

94

Initially all unique account names will appear in the column under the ACCOUNT. CREDIT button. You have to remove non-creditors' names and leave only creditors' names. Here are the steps:

1. Click on the arrowhead on the right of ACCOUNT CREDIT button.

2. A list of accounts will appear.

3. Remove the check marks on the left of a non-creditors name.

4. Click OK.

You should get the desired report.

95