TCSDocuSCreditAnal
ACME TRUCK SERVICING LTD
Sales Credits Analysis as at 31 May 2009
For all departments, for all sell-to account types, excluding inter-warehouse transfers
Description
May 2009
Apr 2009
Mar 2009
Feb 2009
Jan 2009
Dec 2008
Nov 2008
Oct 2008
Sep 2008
Aug 2008
Jul 2008
Jun 2008
65,652.09
39,877.27
91,850.47
50,266.63
49,286.28
49,254.31
61,336.17
38,322.15
52,616.76
65,155.15
56,952.98
108,419.50
TOTAL VALUE INVOICED
12
14
18
17
24
26
28
20
23
19
23
39
TOTAL NUMBER OF INVOICES
500.00
500.00
2,283.96
1,226.70
Early Settlement Discount
0.54%
0.82%
4.01%
1.13%
Percentage of Total Invoiced
11.26%
7.27%
59.97%
4.49%
Percentage of Total Credited
2
2
15
5
Number of Credits
28.57%
25.00%
83.33%
45.45%
Percentage of Total Credits
318.25
67.38
259.35
237.79
329.49
434.35
393.20
349.45
32.01
71.85
Incorrect Item
0.48%
0.17%
0.52%
0.48%
0.67%
0.71%
0.75%
0.54%
0.06%
0.07%
Percentage of Total Invoiced
67.35%
81.05%
81.15%
45.98%
41.85%
6.32%
5.94%
8.31%
0.84%
0.26%
Percentage of Total Credited
2
1
1
1
3
2
2
1
1
2
Number of Credits
66.67%
50.00%
50.00%
33.33%
60.00%
25.00%
40.00%
20.00%
5.56%
18.18%
Percentage of Total Credits
154.28
15.75
479.38
60.25
279.41
457.86
626.05
343.50
2,791.75
3,447.32
1,492.84
190.25
Not Required
0.23%
0.04%
0.52%
0.12%
0.57%
0.93%
1.02%
0.90%
5.31%
5.29%
2.62%
0.18%
Percentage of Total Invoiced
32.65%
18.95%
10.79%
18.85%
54.02%
58.15%
9.11%
100.00%
42.17%
82.01%
39.19%
0.70%
Percentage of Total Credited
1
1
2
1
2
2
2
1
2
3
2
2
Number of Credits
33.33%
50.00%
28.57%
50.00%
66.67%
40.00%
25.00%
100.00%
40.00%
60.00%
11.11%
18.18%
Percentage of Total Credits
3,462.19
3,091.50
3,435.00
23,044.51
Pricing Incorrect
3.77%
5.04%
6.53%
21.25%
Percentage of Total Invoiced
77.95%
44.96%
51.89%
84.31%
Percentage of Total Credited
3
1
1
1
Number of Credits
42.86%
12.50%
20.00%
9.09%
Percentage of Total Credits
2,223.70
407.00
2,798.75
Wrong Customer Charged
3.63%
0.62%
2.58%
Percentage of Total Invoiced
32.34%
9.68%
10.24%
Percentage of Total Credited
1
1
1
Number of Credits
12.50%
20.00%
9.09%
Percentage of Total Credits
472.53
83.13
4,441.57
319.60
517.20
787.35
6,875.60
343.50
6,619.95
4,203.77
3,808.81
27,332.06
TOTAL VALUE CREDITED
0.72%
0.21%
4.84%
0.64%
1.05%
1.60%
11.21%
0.90%
12.58%
6.45%
6.69%
25.21%
Percentage of Total Invoiced
3
2
7
2
3
5
8
1
5
5
18
11
TOTAL NUMBER OF CREDITS
25.00%
14.29%
38.89%
11.76%
12.50%
19.23%
28.57%
5.00%
21.74%
26.32%
78.26%
28.21%
Percentage of Total Invoices
Page 1 of 1
Printed on 13 Jul 2009 at 11:46 AM