TCSAcctODue
Overdue Debtors Analysis by Account Group as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 130
From first group to last group, ordered by account alpha key
All 1 month plus overdue amounts
Credit Days
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Account Group: D10 - Local Operator
10120
Balmoral Transport Co
1,157.41 Dr
358.88 Dr
498.47 Cr
02 Mar 2007
1,516.29 Dr
30
10350
Davies Transport
991.13 Dr
829.75 Cr
22 Dec 2006
991.13 Dr
30
11480
Highways Freight Services Ltd
2,115.51 Dr
1,835.20 Dr
4,294.88 Cr
20 Jan 2007
3,950.71 Dr
30
11520
Hutt Transport Services
2,370.94 Dr
8,799.57 Cr
28 Feb 2007
2,370.94 Dr
30
11650
Rangitikei Transport Co
3,098.43 Dr
1,745.72 Dr
447.61 Dr
1,500.00 Cr
22 Mar 2007
5,291.76 Dr
30
11900
Wanganui Transport Ltd
3,008.61 Dr
1,247.91 Dr
1,901.37 Cr
28 Mar 2007
4,256.52 Dr
30
1,438.74 Dr
1,606.79 Dr
5,951.86 Dr
9,379.96 Dr
18,377.35 Dr
Total for D10 - Local Operator:
100.00%
7.83%
8.74%
32.39%
51.04%
Percentage Summary:
Page 1 of 5
Printed on 12 Apr 2007 at 03:59 PM
TCSAcctODue
Overdue Debtors Analysis by Account Group as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 130
From first group to last group, ordered by account alpha key
All 1 month plus overdue amounts
Credit Days
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Account Group: D20 - National Operator
10773
Freightline NZ Ltd
3,581.20 Dr
1,241.25 Dr
4,800.00 Cr
19 Mar 2007
4,822.45 Dr
60
12570
Nationwide Freighters Ltd
7,164.54 Dr
3,716.49 Dr
281.25 Cr
30 Jan 2007
10,881.03 Dr
60
11890
Transport NZ Ltd
1,365.40 Dr
1,671.76 Dr
2,257.15 Dr
701.25 Cr
23 Mar 2007
5,294.31 Dr
60
2,257.15 Dr
6,629.50 Dr
12,111.14 Dr
20,997.79 Dr
Total for D20 - National Operator:
100.00%
10.75%
31.57%
57.68%
Percentage Summary:
Page 2 of 5
Printed on 12 Apr 2007 at 03:59 PM
TCSAcctODue
Overdue Debtors Analysis by Account Group as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 130
From first group to last group, ordered by account alpha key
All 1 month plus overdue amounts
Credit Days
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Account Group: D30 - Owner Driver
11985
Mr T J Robinson
1,346.07 Dr
635.47 Dr
150.76 Cr
28 Jan 2007
1,981.54 Dr
30
635.47 Dr
1,346.07 Dr
1,981.54 Dr
Total for D30 - Owner Driver:
100.00%
32.07%
67.93%
Percentage Summary:
Page 3 of 5
Printed on 12 Apr 2007 at 03:59 PM
TCSAcctODue
Overdue Debtors Analysis by Account Group as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 130
From first group to last group, ordered by account alpha key
All 1 month plus overdue amounts
Credit Days
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
Account Group: D90 - Export Customer
19305
Deagon Transport Services Ltd
864.57 Dr
232.23 Dr
463.80 Cr
05 Nov 2006
1,096.80 Dr
90
232.23 Dr
864.57 Dr
1,096.80 Dr
Total for D90 - Export Customer:
100.00%
21.17%
78.83%
Percentage Summary:
Page 4 of 5
Printed on 12 Apr 2007 at 03:59 PM
TCSAcctODue
Overdue Debtors Analysis by Account Group as at 31 Mar 2007
ACME TRUCK SERVICING LTD
Control account 130
From first group to last group, ordered by account alpha key
All 1 month plus overdue amounts
Credit Days
Date Paid
Last Payment
Over 3 Mths
3 Months
2 Months
1 Month
Current
Total Due
Account Name
Account
42,453.48 Dr
1,438.74 Dr
1,606.79 Dr
3,124.85 Dr
13,927.43 Dr
22,355.67 Dr
Total for Overdue Accounts:
100.00%
3.39%
3.78%
7.36%
32.81%
52.66%
Percentage Summary for Overdue Accounts:
1,438.74 Dr
1,606.79 Dr
3,124.85 Dr
13,927.43 Dr
27,296.57 Dr
47,394.38 Dr
Total for All Accounts:
3.04%
3.39%
6.59%
29.39%
57.59%
100.00%
Percentage Summary for All Accounts:
Overdue Accounts Percentage of All Accounts:
89.57%
100.00%
81.90%
100.00%
100.00%
100.00%
Page 5 of 5
Printed on 12 Apr 2007 at 03:59 PM