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 								CREDIT
	RM-CREDIT 							AGE GROUP	 
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.00)
6				STACC/11/20	4-Apr-01	(1,650.00)										(1,650.00)
7				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)				(6,875.00)
13				1924788		11-Apr-01	(10,800.00)										(10,800.00)
14  OTHER 
	CREDITOR E	17396		20-Feb-01 							(611.22)				(611.22)
15				17697		11-Apr-01	(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 	17680		11-Apr-01	(4,712.15)										(4,712.15)
19 	OVERSEA 
	CREDITOR A	N4901		14-Jan-01										(91,224.00)	(91,224.00)	
20				N5133		8-Mar-01				(53,174.19)							(53,174.19)
21				N5498		20-Apr-01	(92,919.25)										(92,919.25) 22					TQA0X2		12-Feb-01							(423,098.83)			(423,098.83)
23														

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