TCSAcctODue
Overdue Creditors Analysis by Department as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 120
From first department to last department, ordered by account alpha key
All 1 month plus overdue amounts
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Department: 10 - Parts Department
3905
Australian Brake Corp Ltd
6,300.57 Cr
403.43 Cr
6,138.85 Dr
31 Jan 2007
6,704.00 Cr
3275
Engine Rebuilders Ltd
9,193.75 Cr
8,187.50 Cr
8,187.50 Dr
15 Mar 2007
17,381.25 Cr
3010
Hella New Zealand Limited
3,531.38 Cr
255.94 Cr
1,773.80 Dr
20 Dec 2006
3,787.32 Cr
3150
Marshall Batteries Co Ltd
2,189.26 Cr
1,067.62 Cr
5,250.50 Dr
21 Feb 2007
3,256.88 Cr
3918
RST Filter Corporation
8,526.32 Cr
270.18 Cr
333.60 Dr
22 Feb 2007
8,796.50 Cr
9,511.06 Cr
673.61 Cr
29,741.28 Cr
39,925.95 Cr
Total for 10 - Parts Department:
100.00%
23.82%
1.69%
74.49%
Percentage Summary:
Page 1 of 4
Printed on 12 Apr 2007 at 04:04 PM
TCSAcctODue
Overdue Creditors Analysis by Department as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 120
From first department to last department, ordered by account alpha key
All 1 month plus overdue amounts
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Department: 50 - Service Department
3625
Panel & Paint Services Ltd
2,595.31 Cr
4,000.00 Dr
21 Feb 2007
2,595.31 Cr
3675
Radiator Services
1,001.59 Cr
298.97 Dr
20 Dec 2006
1,001.59 Cr
3,596.90 Cr
3,596.90 Cr
Total for 50 - Service Department:
100.00%
100.00%
Percentage Summary:
Page 2 of 4
Printed on 12 Apr 2007 at 04:04 PM
TCSAcctODue
Overdue Creditors Analysis by Department as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 120
From first department to last department, ordered by account alpha key
All 1 month plus overdue amounts
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Department: 90 - Administration Department
3050
Corporate Concepts Ltd
6,440.63 Cr
6,440.63 Cr
3015
Hewlett Packard (NZ) Ltd
2,576.25 Cr
1,203.76 Dr
18 May 2005
2,576.25 Cr
2,576.25 Cr
6,440.63 Cr
9,016.88 Cr
Total for 90 - Administration Department:
100.00%
28.57%
71.43%
Percentage Summary:
Page 3 of 4
Printed on 12 Apr 2007 at 04:04 PM
TCSAcctODue
Overdue Creditors Analysis by Department as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 120
From first department to last department, ordered by account alpha key
All 1 month plus overdue amounts
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
52,539.73 Cr
9,511.06 Cr
3,596.90 Cr
2,576.25 Cr
7,114.24 Cr
29,741.28 Cr
Total for Overdue Accounts:
100.00%
18.10%
6.85%
4.90%
13.54%
56.61%
Percentage Summary for Overdue Accounts:
9,511.06 Cr
3,596.90 Cr
2,576.25 Cr
7,114.24 Cr
35,580.48 Cr
58,378.93 Cr
Total for All Accounts:
16.29%
6.16%
4.41%
12.19%
60.95%
100.00%
Percentage Summary for All Accounts:
Overdue Accounts Percentage of All Accounts:
90.00%
100.00%
83.59%
100.00%
100.00%
100.00%
Page 4 of 4
Printed on 12 Apr 2007 at 04:04 PM