20050211Uncoll TY Hist & Summary.xls

Summary
Detailed History
Summary
Aug-03
22,422.29
(2,959.35)
19,462.94
Sep-03
27,964.58
(7,020.72)
20,943.86
Oct-03
12,223.81
(6,389.87)
5,833.94
Nov-03
12,815.19
(5,635.37)
7,179.82
Dec-03
18,197.27
(4,580.59)
13,616.68
Jan-04
22,948.99
(5,138.41)
17,810.58
Feb-04
27,584.58
(6,283.83)
21,300.75
Mar-04
36,368.54
(9,960.68)
26,407.86
Apr-04
10,155.01
(9,879.68)
275.33
May-04
15,713.10
(6,480.74)
9,232.36
Jun-04
21,315.50
(6,926.53)
14,388.97
Jul-04
13,279.80
(7,026.52)
6,253.28
240,988.66
(78,282.29)
162,706.37
Journal
Date
Month/Year
Acct
Act
C Type
Amount
Line Descr
001
2003-08-22
2003-08
904000
7031
085
(218.46)
Uncollectible Accounts
(68.45)
(62.02)
(2,323.23)
(51.13)
(46.89)
2003-08-28
(0.35)
(2,770.53)
002
2003-08-15
RCLS025
0.62
0.54
(189.98)
(188.82)
2003-09-15
2003-09
(95.64)
(284.80)
(86.41)
(53.26)
(273.49)
(4,243.72)
(226.24)
(213.12)
(252.17)
(475.29)
(114.11)
2003-09-29
(48.39)
(74.07)
(133.50)
(6,574.21)
AP00162922
2003-09-05
(3.55)
(0.01)
(442.95)
(442.96)
2003-10-15
2003-10
(60.96)
(272.32)
(23.10)
(180.10)
(190.16)
(108.32)
(57.38)
(3,865.66)
(170.50)
(85.00)
(159.93)
(134.67)
2003-10-30
(74.14)
(28.19)
(5,410.43)
027
(189.87)
RCLS026
(146.94)
73.44
(56.03)
(45.83)
(0.03)
(10.38)
(8.89)
(591.17)
(3.73)
(789.57)
2003-11-19
2003-11
(20.00)
(19.79)
(92.23)
(143.30)
(141.49)
(101.90)
(44.20)
(5,320.96)
(83.09)
(55.16)
2003-11-25
(48.78)
(17.71)
(6,088.61)
2003-11-15
AP00166366
2003-11-04
107.38
reconciliation corrections
379.74
(33.88)
345.86
2003-12-16
2003-12
(53.30)
(63.40)
(141.09)
(54.48)
(3,868.74)
(90.27)
2
(61.15)
(4,332.43)
2003-12-15
(248.11)
(0.05)
(248.16)
2004-01-09
2004-01
(29.19)
2004-01-13
(92.32)
2004-01-14
(3,918.20)
2004-01-16
(105.23)
2004-01-21
(39.54)
2004-01-23
(30.59)
2004-01-27
(41.77)
(4,256.84)
2004-01-15
RCLS027
28,576.82
(881.56)
27,695.25
RCLS029
(28,576.82)
001-06
2004-02-15
2004-02
(27.00)
001-07
(5,002.75)
001-10
(623.10)
001-11
(76.89)
001-13
(166.35)
001-14
(153.78)
001-16
(89.95)
001-18
(33.21)
001-19
(110.80)
001-03
2004-03-15
2004-03
(69.19)
001-04
(48.64)
(260.22)
001-08
(74.65)
001-09
(75.24)
(6,188.33)
(24.17)
001-12
(210.43)
(328.22)
(275.15)
001-15
(147.77)
(145.18)
001-20
(115.13)
001-21
(107.88)
001-22
(53.28)
001-23
(117.91)
(8,241.39)
(1,719.29)
24.17
001-01
2004-04-15
2004-04
(58.46)
001-02
(234.46)
(161.74)
(269.57)
001-05
(204.42)
(28.45)
(69.24)
(190.00)
(185.78)
(6,674.80)
(62.60)
(152.91)
(354.40)
(460.87)
(111.80)
(57.14)
(9,276.64)
AP00176833
2004-04-07
252.99
chk 132852 cshd 12/03, org chk
(825.41)
(6.32)
(12.15)
(856.03)
2004-05-15
2004-05
(50.87)
(339.47)
(502.74)
(246.14)
(4,882.04)
(73.04)
(42.53)
(61.99)
001-17
(168.57)
(53.85)
(124.15)
162.23
(97.58)
2004-06-15
2004-06
(210.34)
(206.90)
(70.00)
(253.16)
2004-06-11
(22.57)
(4,396.49)
(363.11)
(218.03)
(25.39)
(380.50)
(60.92)
(99.29)
(6,306.70)
(619.83)
2004-07-15
2004-07
(143.16)
(123.44)
(98.32)
(49.51)
(81.21)
(5,326.83)
(176.13)
(57.87)
(35.00)
(67.55)
(300.59)
(38.38)
(101.77)
(54.93)
(6.18)
(6,804.03)
13,019.28
002B
260.52
(218.31)
(4.18)
(222.49)
August 2003
September 2003
October 2003
November 2003
December 2003
January 2004
February 2004
March 2004
Apri 2004
May 2004
June 2004
July 2004
Month
Write Offs
Collections
United Water Idaho
Test Year Ended July 2004
Summary of Account 904-000
Uncollectible Accounts Expense
Net Expense
JJH
Fiscal Period
Gross Revenue
Net Uncollectibles
Percentage
July 03 to Aug 02
July 02 to Aug 01
July 04 to Aug 03
3 Yr Average
July 01 to Aug 00
4 Yr Average
YE July 2003, 2002,2001
YE July 2004, 2003,2002
ProForma Revenue at Existing Rates
Pro Forma Uncollectibles
October 24, 2004

Page
filename
S:\ACC\JERRY\Rates 2004 Official\OPEX\Customer Accounting Expenses\[Uncoll TY Hist & Summary.xls]Summary
$31,000,222.34
$162,706.37
5.25E-03
$29,884,880.82
$124,358.84
4.16E-03
$30,406,923.75
$105,384.22
3.47E-03
$28,694,018.00
$106,277.19
3.70E-03
$119,986,044.91
$498,726.62
4.16E-03
$88,985,822.57
$336,020.25
3.78E-03
$91,292,026.91
$392,449.43
4.30E-03
31527396.00
4.16E-03
$131,044.84