20050211Outside Coll TY Hist & Summary.xls

Rate Year Summary
TY Summary
Full Account History
Payables History
NvsParentRef
Journal
Date
Acct
DeptID
Act
C Type
Amount
Line Descr
Ledger
R168
AP00170441
AP00170442
AP00170443
001
AP00171468
AP00172269
AP00172270
001-07
AP00172881
AP00172884
AP00173490
AP00174304
AP00174306
AP00175461
001-10
AP00176478
AP00176481
AP00176832
AP00176833
AP00177385
AP00177915
AP00179372
AP00179374
001-09
AP00180880
AP00180883
AP00180886
AP00181437
001-12
AP00181951
RCLS027
AP00182888
AP00183087
AP00183977
AP00183982
2004-01-01
2004-01-07
2004-01-09
2004-01-06
2004-01-14
2004-01-21
2004-02-01
2004-02-03
2004-02-15
2004-02-12
2004-02-11
2004-02-17
2004-03-05
2004-03-03
2004-03-16
2004-03-15
2004-04-01
2004-04-06
2004-04-07
2004-04-14
2004-04-15
2004-04-22
2004-05-13
2004-05-10
2004-05-15
2004-06-01
2004-06-04
2004-06-11
2004-06-15
2004-07-01
2004-07-02
2004-07-15
2004-07-14
903040
304
300

400
7032
7031
9510
083
036
C02B002
OVERHEAD
Cust.Rec.& Col.E-O/S Collect.
ACCOUNT ANALYSIS
OVERNIGHT DELIVERY
overnight delivery 12/26
overnight delivery 12/19
Nov A/C Analysis Fees BU 060
Oct A/C Analysis Fees BU 060
overnight delivery
fed ex shipping
Dec. 2003 bank fees
1/15/04 fed ex
1/22 fed ex
FedEx 1/30/04
Dec A/C Analysis Fees BU 060
Fed Ex 2/5/04
inv 1-614-48306 2/19/04
Jan A/C Analysis Fees BU 060
inv 1-563-87766 - sullivan
inv 1-615-07727 - sullivan
january 2004 stmt
EDI, ACH Coin & Currency
inv 1-662-18735
Feb A/C Analysis Fees BU 060
sanford, wood, cahoon, foss, c
Foss, Barrett, Smith, Cary
Patty Foss
Foss, Cary
EDI, ACH, coin & currency
cary, foss, wood, smith
foss, wyatt
foss, cary, rhodes, smith, woo
foss, cary
Mar A/C Analysis Fees BU 060
edi, ach, coin & currency, dda
foss, cary, rhodes, smith
foss, rhodes, sanford, wood
Apr A/C Analysis Fees BU 060
FOSS, CARY, WOOD, SMITH
foss, cary, jane wood
EDI, ACH, COIN & CURRENCY
FOSS, CARY, SMITH, RHODES
FOSS, CARY, J. WOOD
foss, smith, cary, doug s
May A/C Analysis Fees
ACTUALS
Line
deliver overnight
customer analysis
AP00166367
2003-11-05
2003-11-19
AP00167447
2003-11-20
AP00167450
Sept A/C Analysis Fees BU 060
overnight
delivery overnight
CUSTOMER ANALYSIS
AP00168142
2003-12-04
AP00169223
2003-12-15
OVERNIGHT
2003-12-16
2003-08-01
AP00160872
AP00160874
June A/C Analysis Fees BU 060
AP00161299
acct analysis
AP00161643
2003-08-18
fed ex chgs #477162963
AP00161646
July A/C Analysis Fees BU 060
2003-08-22
AP00161974
2003-08-21
AP00162922
2003-09-05
AP00163321
2003-09-16
account analysis
2003-09-15
AP00163617
2003-09-22
2003-10-01
AP00164097
AP00164100
Aug A/C Analysis Fees BU 060
AP00164530
2003-10-07
AP00164531
2003-10-08
AP00164881
2003-10-17
2003-10-15
2003-11-01
AP00166042
AP Unit
Control Group
Voucher
Account
Dept
Project
Activity
Cost Type
Facility
Currency
Monetary Amount
Description
Invoice #
Vendor ID
Vendor Name
Year
Per
GL Unit
060
000907
00037354
USD
477122742
0000002158
FEDERAL EX-001
305
001070
00037460
477162963
000909
00037463
482005578
000911
00037546
482082999
00037572
482043582
000910
00036882
306202022
0000003877
MELLON BAN-001
000913
00037108
307201532
000914
00037400
153300513519
0000013980
TREASURY-001
001078
00037810
482162406
000916
00037811
482123199
00037995
486803005
000919
00037895
153300513519-7/0
000923
00038059
486842501
00038060
486878908
000925
00038100
486920130
00038228
486962680
000989
00038279
491600873
000992
00037753
308201492
000993
00038064
AUGUST 2003
000996
00038371
491639610
00038394
491680352
00038457
491722899
000998
00038588
496402037
001003
00038589
491762337
00038509
309201922
00038407
153300513519-9/0
001005
00038632
496440941
00038663
496483199-
001006
00038836
496523620
001012
00038837
496562369
00038631
NOVEMBER 2003
496598709
151285760
151242904
311201342-11/03
310201442-10/03
151320127
DECEMBER 2003
151352999
151390114
156231091
156277245
312201712
156334754
161448306
401201232
156387766
161507727
153300513519-1/0
166218736
153300513519-2
402201192
161560317
166278307
166393347
166338925
171046685
171169190
171108216
175824606
403201612
153300513519-4/0
175880574
175939536
175998623
404201122
180657321
180712695
180766120
185624137
185740037
405201132
001019
00039038
00039046
001020
00039121
00039122
001250
00039091
00039092
001023
00039207
001024
00039215
00039239
001026
00039276
00039277
001030
00039374
001273
00039745
001031
00039411
001035
00039528
001281
00040015
001037
00039646
00039647
00039649
001039
00039725
001040
00039731
001292
00040390
001041
00039775
001042
00039820
001044
00039871
001045
00039931
001046
00039983
001047
00040026
001051
00040145
00040146
00040147
00040972
001055
00040259
001060
00040419
00040420
00040421
001328
00041390
001061
00040445
001063
00040496
001067
00040615
001068
00040626
001069
00040651
001075
00040826
00042150
Month Year
2003-08 Total
2003-09 Total
2003-10 Total
2003-11 Total
2003-12 Total
2004-01 Total
2004-02 Total
2004-03 Total
2004-04 Total
2004-05 Total
2004-06 Total
2004-07 Total
Grand Total
8 Total
9 Total
10 Total
11 Total
12 Total
1 Total
2 Total
3 Total
4 Total
5 Total
6 Total
7 Total
Mellon
US Bank
Fed Ex
Test Year Total
United Water Idaho
JJH
Test Year Ended July 2004
August 2, 2004
Aug-03
Sep-03
Oct-03
Nov-03
Dec-03
Jan-04
Feb-04
Mar-04
Apr-04
May-04
Jun-04
Jul-04
Summary of Account 903-040
Outside Collection
Mellon Bank Lock Box
US Bank Charges
Federal Express
Total Customer Outside Collection
Lockbox Transactions
Lockbox Allocation
Price per Unit
ACH Batches
ACH Allocation
Adjustment
Only Recorded 11 bills in test period
Oct/Nov 2003
Aug-04
AccountingMonth
MellonStatement Date
Adjusted Test Year
Jan & Feb 2004
Test Year
Pro Forma Year June 2005
Estimated Lock Box/ACH Charges
Note: UBS Generated 460,978 bills in test year per UBS Billing;
Lock box transactions were 335,278 as normalized above
Percentage of payments through thro lock box = 72.73%
UBS Billing Transactions
Lockbox Transactions at 72.73%
ACH Batches related to Lockbox Transactions in the adjusted test
year 18,070/335,278= 5.3896%
US Bank Charges TY Monthly Average
Federal Express TY Average
Lockbox Fee Adjustment per Corporate Treasurer
September 15, 2004
filename
S:\ACC\JERRY\Rates 2004 Official\Exh and WP re PR #135\[Outside Coll TY Hist & Summary.xls]Rate Year Summary
?6?/?1?/?2005
39666.00
28849.08
0.73
$0.23
$6,762.23
1554.85
0.05
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
-2500.00
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
?6?/?1?/?2005
39666.00
28849.08
$0.23
$6,762.23
1554.85
$0.35
$539.84
$7,302.07
$1,697.00
$123.00
($2,500.00)
$6,622.07
475992.00
346188.98
$81,146.70
18658.20
$6,478.13
$87,624.82
$20,364.00
$1,476.00
($30,000.00)
$79,464.82
filename
S:\ACC\JERRY\Rates 2004 Official\Exh and WP re PR #135\[Outside Coll TY Hist & Summary.xls]Rate Year Summary
?7?/?1?/?2003
27864.00
$0.22
$6,075.69
1631.00
$0.35
$574.16
$6,649.85
$1,119.47
$180.45
($89.66)
$7,860.11
?8?/?1?/?2003
26938.00
$0.25
$6,804.42
1249.00
$0.55
$688.38
$7,492.80
$1,488.99
$103.32
$9,085.11
$0.00
$2,751.84
$189.42
$2,941.26
?9?/?1?/?2003
29483.00
$0.22
$6,558.02
1629.00
$0.36
$593.53
$7,151.55
$559.29
$196.70
$7,907.54
53127.00
26782.00
26345.00
$0.24
$12,778.87
6022.92
6755.95
2805.00
1374.00
1431.00
$0.43
$1,195.34
687.02
508.32
$13,974.21
$1,416.86
$127.90
$15,518.97
$0.00
$1,331.56
$94.93
$0.00
$1,426.49
?12?/?1?/?2003
27846.00
$0.23
$6,273.10
1557.00
$0.35
$543.08
$6,816.18
$1,586.14
$112.41
$8,514.73
54195.00
25825.00
28370.00
$0.24
$12,798.31
5774.25
7024.06
2738.00
1283.00
1455.00
$0.44
$1,198.96
607.34
591.62
$13,997.27
$1,825.74
$69.36
$140.71
$16,033.08
?2?/?1?/?2004
$0.00
$2,365.77
$191.72
($140.71)
-140.71
$2,416.78
?3?/?1?/?2004
32087.00
$0.23
$7,267.46
1802.00
$0.22
$403.75
$7,671.21
$1,992.22
$60.83
($123.63)
-123.63
$9,600.63
?4?/?1?/?2004
25245.00
$0.26
$6,441.53
1330.00
$0.24
$321.72
$6,763.25
$1,825.71
$98.10
$8,687.06
?5?/?1?/?2004
28674.00
$0.25
$7,069.84
1688.00
$0.22
$377.26
$7,447.10
$2,099.91
$51.54
$9,598.55
305459.00
$72,067.24
16429.00
$5,896.18
$77,963.42
$20,363.50
$1,476.68
($213.29)
$99,590.31
99590.31
?6?/?1?/?2004
29819.00
$0.22
$6,519.69
1641.00
$0.23
$378.22
$6,897.91
$6,897.91
335278.00
$0.23
$78,586.93
18070.00
$0.35
$6,274.40
$84,861.33
$20,363.50
$1,476.68
($213.29)
$106,488.22
$106,488.22

Page
2003-08
-7121.69
1.00
2003-08
7032.04
1.00
2003-08
6649.84
1.00
6560.19
2003-08
89.65
2.00
2003-08
1029.82
2.00
1119.47
2003-08
34.42
3.00
2003-08
34.36
3.00
2003-08
51.54
3.00
2003-08
25.77
3.00
2003-08
34.36
3.00
180.45
7860.11
0.00
9.00
2003-09
7492.80
1.00
7492.80
2003-09
130.80
2.00
2003-09
1358.19
2.00
1488.99
2003-09
34.44
3.00
2003-09
34.44
3.00
2003-09
34.44
3.00
103.32
9085.11
0.00
9.00
2003-10
-7492.80
1.00
2003-10
7492.80
1.00
0.00
2003-10
96.04
2.00
2003-10
1430.62
2.00
2003-10
1225.18
2.00
2751.84
2003-10
34.44
3.00
2003-10
34.44
3.00
2003-10
34.44
3.00
2003-10
43.05
3.00
2003-10
43.05
3.00
189.42
2941.26
0.00
9.00
2003-11
7151.55
1.00
7151.55
2003-11
1641.61
2.00
2003-11
-1225.18
2.00
2003-11
142.86
2.00
559.29
2003-11
45.56
3.00
2003-11
43.19
3.00
2003-11
36.91
3.00
2003-11
25.95
3.00
2003-11
45.09
3.00
196.70
7907.54
0.00
9.00
2003-12
13974.20
1.00
13974.20
2003-12
141.91
2.00
2003-12
1274.95
2.00
1416.86
2003-12
42.95
3.00
2003-12
33.37
3.00
2003-12
34.36
3.00
2003-12
17.22
3.00
127.90
15518.96
0.00
9.00
2004-01
-13974.20
1.00
2004-01
7264.26
1.00
2004-01
6709.94
1.00
0.00
2004-01
101.52
2.00
2004-01
1230.04
2.00
1331.56
2004-01
34.52
3.00
2004-01
25.89
3.00
2004-01
25.89
3.00
2004-01
8.63
3.00
94.93
1426.49
0.00
9.00
2004-02
6816.17
1.00
6816.17
2004-02
107.38
2.00
2004-02
1478.76
2.00
1586.14
2004-02
25.91
3.00
2004-02
25.95
3.00
2004-02
25.95
3.00
2004-02
17.30
3.00
2004-02
17.30
3.00
112.41
8514.72
0.00
9.00
2004-03
6381.59
1.00
2004-03
7756.39
1.00
14137.98
2004-03
76.95
2.00
2004-03
1748.79
2.00
1825.74
2004-03
26.01
3.00
2004-03
8.67
3.00
2004-03
17.34
3.00
2004-03
17.34
3.00
69.36
16033.08
0.00
9.00
2004-04
-7756.39
1.00
2004-04
7615.68
1.00
-140.71
2004-04
105.85
2.00
2004-04
2175.37
2.00
2004-04
84.55
2.00
2365.77
2004-04
34.86
3.00
2004-04
34.68
3.00
2004-04
34.92
3.00
2004-04
43.65
3.00
2004-04
26.19
3.00
2004-04
17.42
3.00
191.72
2416.78
0.00
9.00
2004-05
7547.58
1.00
7547.58
2004-05
1992.22
2.00
1992.22
2004-05
26.07
3.00
2004-05
17.38
3.00
2004-05
17.38
3.00
60.83
9600.63
0.00
9.00
2004-06
6763.25
1.00
6763.25
2004-06
103.00
2.00
2004-06
1722.71
2.00
2004-06
2015.09
2.00
2004-06
-2015.09
2.00
1825.71
2004-06
17.42
3.00
2004-06
17.42
3.00
2004-06
17.38
3.00
2004-06
8.71
3.00
2004-06
37.17
3.00
98.10
8687.06
0.00
9.00
2004-07
7447.11
1.00
7447.11
2004-07
-2015.09
2.00
2004-07
72.15
2.00
2004-07
2027.76
2.00
2004-07
2015.09
2.00
2099.91
2004-07
17.42
3.00
2004-07
17.06
3.00
2004-07
17.06
3.00
51.54
9598.56
0.00
9.00
99590.30
398361.20
9.00
0.00
9.00
1.00
34.42
2003.00
8.00
1.00
34.36
2003.00
8.00
1.00
51.54
2003.00
8.00
1.00
34.36
2003.00
8.00
1.00
25.77
2003.00
8.00
7.00
7032.04
2003.00
8.00
7.00
6649.84
2003.00
8.00
1.00
89.65
2003.00
8.00
13951.98
9.00
0.00
9.00
1.00
34.44
2003.00
9.00
1.00
34.44
2003.00
9.00
1.00
34.44
2003.00
9.00
1.00
130.80
2003.00
9.00
234.12
9.00
0.00
9.00
1.00
34.44
2003.00
10.00
1.00
34.44
2003.00
10.00
1.00
34.44
2003.00
10.00
1.00
43.05
2003.00
10.00
1.00
43.05
2003.00
10.00
7.00
7492.80
2003.00
10.00
1.00
96.04
2003.00
10.00
7778.26
9.00
0.00
9.00
1.00
45.09
2003.00
11.00
1.00
25.95
2003.00
11.00
1.00
45.56
2003.00
11.00
1.00
43.19
2003.00
11.00
1.00
36.91
2003.00
11.00
7.00
7151.55
2003.00
11.00
1.00
142.86
2003.00
11.00
7491.11
9.00
0.00
9.00
1.00
33.37
2003.00
12.00
1.00
42.95
2003.00
12.00
1.00
34.36
2003.00
12.00
1.00
17.22
2003.00
12.00
1.00
141.91
2003.00
12.00
269.81
9.00
0.00
9.00
1.00
34.52
2004.00
1.00
1.00
25.89
2004.00
1.00
1.00
25.89
2004.00
1.00
1.00
8.63
2004.00
1.00
6.00
7264.26
2004.00
1.00
6.00
6709.94
2004.00
1.00
1.00
101.52
2004.00
1.00
14170.65
9.00
0.00
9.00
1.00
25.91
2004.00
2.00
1.00
25.95
2004.00
2.00
1.00
25.95
2004.00
2.00
1.00
17.30
2004.00
2.00
1.00
17.30
2004.00
2.00
6.00
6816.17
2004.00
2.00
1.00
107.38
2004.00
2.00
7035.96
9.00
0.00
9.00
1.00
26.01
2004.00
3.00
1.00
8.67
2004.00
3.00
1.00
17.34
2004.00
3.00
1.00
17.34
2004.00
3.00
6.00
6381.59
2004.00
3.00
1.00
76.95
2004.00
3.00
6527.90
9.00
0.00
9.00
1.00
34.86
2004.00
4.00
1.00
34.68
2004.00
4.00
1.00
34.92
2004.00
4.00
1.00
26.19
2004.00
4.00
1.00
43.65
2004.00
4.00
1.00
17.42
2004.00
4.00
6.00
7615.68
2004.00
4.00
1.00
105.85
2004.00
4.00
2.00
84.55
2004.00
4.00
7997.80
9.00
0.00
9.00
1.00
26.07
2004.00
5.00
1.00
17.38
2004.00
5.00
1.00
17.38
2004.00
5.00
6.00
7547.58
2004.00
5.00
7608.41
9.00
0.00
9.00
1.00
17.38
2004.00
6.00
1.00
17.42
2004.00
6.00
1.00
17.42
2004.00
6.00
1.00
8.71
2004.00
6.00
1.00
37.17
2004.00
6.00
6.00
6763.25
2004.00
6.00
1.00
103.00
2004.00
6.00
6964.35
9.00
0.00
9.00
1.00
17.42
2004.00
7.00
1.00
17.06
2004.00
7.00
1.00
17.06
2004.00
7.00
1.00
7447.11
2004.00
7.00
1.00
72.15
2004.00
7.00
7570.80
9.00
0.00
9.00
87601.15
9.00
0.00
9.00