Loading...
HomeMy WebLinkAbout20050211Customer Records & Collection Expenses.xlsPro Forma Summary TY Summary TY History NvsParentRef Journal Date Line # Acct DeptID Act C Type Fac Amount Line Descr Ledger AP00170440 AP00170441 AP00171468 AP00172269 AP00172880 AP00172881 AP00173490 AP00175461 AP00176478 PAY0177267 AP00180883 AP00181951 2004-01-06 2004-01-07 2004-01-21 2004-02-01 2004-02-11 2004-02-12 2004-02-17 2004-03-16 2004-04-01 2004-04-15 2004-06-04 2004-06-15 903050 300 400 7035 7033 7028 7031 7032 020 033 046 034 038 temp services 11/30 temp service 12/07 temp service 12/14 door hangers temp services 12/21/03 temp services 12/28/03 1/4/04 1/11/04 133145 national waterworks Temp 1/18/04 temp. 1/25/04 Team Management Briefings Temp 2/1/04 2 part forms - auto pay slips 5200 pmt prob forms inv 76276 Cust.Rec.& Col.Expense 16250 cunsumer connection orde CK 133827 HRDQ - CUST SVC ACTUALS 021 AP00166367 2003-11-05 TEMP SERVICES 10/19 TEMP SERVICES 10/12 AP00167447 2003-11-20 blue door hangers temp services temp service AP00168624 2003-12-12 temp services 11/23 PAY0169067 2003-12-15 AP00169223 temp service 11/169 temp service 11/09 AP00161302 2003-08-06 AP00161643 2003-08-18 temp servics 07/06 temp serices 07/13 AP00161974 2003-08-21 temp services 08/03 TEMP SERVICS 07/20 TEMP SERVICES 07/27 AP00162547 2003-09-02 temp servics 08/10 AP00163617 2003-09-22 temp services 08/17 consumer connection forms temp services 08/24 Crt Clerk 132911 pecina claim AP00164097 2003-10-01 temp services 08/31 temp services 09/07 AP00164531 2003-10-08 temp servicesn 09/21/03 TEMP SERVICE 09/14 AP00166042 2003-11-01 temp services 10/05 Month/Year McDevitt & Miller 1 Total 3 Total 2 Total August September October November December January February March April June Test Year Total United Water Idaho JJH Test Year Ended July 2004 Month 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-050 Customer Records & Collection Expense Contract Temporary Labor Services Supplies Misc Legal Fees / Collection Effort Total Customer Records & Collection Expense September 15, 2004 Pro Forma Year June 2005 Normalize Contract Temporary Labor Services Normalize Misc Legal Fees / Collection Effort Octoberb6, 2004 filename H:\WATER\UWI\UWIW0404\production requests & responses\[20050211Customer Records & Collection Expenses.xls]Pro Forma Summary 0.00 208.62 35.00 243.62 0.00 208.50 40.00 248.50 0.00 209.00 35.00 244.00 0.00 208.00 40.00 248.00 0.00 209.00 35.00 244.00 0.00 208.50 40.00 248.50 0.00 209.00 35.00 244.00 0.00 208.50 40.00 248.50 0.00 209.00 35.00 244.00 0.00 208.00 40.00 248.00 0.00 209.00 35.00 244.00 0.00 208.50 40.00 248.50 0.00 2503.62 450.00 2953.62 2953.62 filename H:\WATER\UWI\UWIW0404\production requests & responses\[20050211Customer Records & Collection Expenses.xls]Pro Forma Summary 2592.00 0.00 453.75 3045.75 1620.00 354.79 0.00 1974.79 1944.00 0.00 0.00 1944.00 2700.00 376.30 0.00 3076.30 1404.00 66.76 0.00 1470.76 1944.00 373.12 0.00 2317.12 2362.50 179.94 0.00 2542.44 0.00 373.12 0.00 373.12 0.00 327.66 0.00 327.66 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 451.79 0.00 451.79 14566.50 2503.48 453.75 17523.73 17523.73 Page 2003-08 57.00 432.00 1.00 2003-08 58.00 540.00 1.00 2003-08 30.00 540.00 1.00 2003-08 154.00 540.00 1.00 2003-08 155.00 540.00 1.00 2592.00 9.00 0.00 9.00 2003-08 4.00 453.75 3.00 453.75 9.00 0.00 9.00 3045.75 2003-09 36.00 540.00 1.00 2003-09 77.00 540.00 1.00 2003-09 126.00 540.00 1.00 1620.00 9.00 0.00 9.00 2003-09 80.00 311.64 2.00 2003-09 174.00 43.15 2.00 354.79 9.00 0.00 9.00 1974.79 2003-10 91.00 432.00 1.00 2003-10 92.00 432.00 1.00 2003-10 18.00 540.00 1.00 2003-10 109.00 540.00 1.00 1944.00 1944.00 2003-11 50.00 540.00 1.00 2003-11 51.00 540.00 1.00 2003-11 53.00 540.00 1.00 2003-11 54.00 540.00 1.00 2003-11 75.00 540.00 1.00 2700.00 0.00 9.00 2003-11 46.00 376.30 2.00 376.30 9.00 0.00 9.00 3076.30 2003-12 96.00 540.00 1.00 2003-12 32.00 324.00 1.00 2003-12 33.00 540.00 1.00 1404.00 9.00 0.00 9.00 2003-12 769.00 66.76 2.00 66.76 9.00 0.00 9.00 1470.76 2004-01 107.00 324.00 1.00 2004-01 36.00 432.00 1.00 2004-01 37.00 432.00 1.00 2004-01 12.00 432.00 1.00 2004-01 13.00 324.00 1.00 1944.00 9.00 0.00 9.00 2004-01 9.00 373.12 2.00 373.12 9.00 0.00 9.00 2317.12 2004-02 107.00 324.00 1.00 2004-02 108.00 540.00 1.00 2004-02 33.00 540.00 1.00 2004-02 34.00 432.00 1.00 2004-02 16.00 526.50 1.00 2362.50 9.00 0.00 9.00 2004-02 47.00 75.00 2.00 2004-02 81.00 104.94 2.00 179.94 2542.44 2004-03 77.00 373.12 2.00 373.12 2004-04 39.00 210.94 2.00 2004-04 839.00 116.72 2.00 327.66 327.66 2004-06 54.00 306.34 2.00 2004-06 142.00 145.45 2.00 451.79 0.00 9.00 451.79 17523.73