Loading...
HomeMy WebLinkAboutITEM IV-G . * f.~ CITYOF Interoffice Memorandum 0J, BU WASH[NGTON To: Shelley Coleman From: Rhonda Ewing CC: Date: March 3, 2010 Re: BadDebtWrite-offs A review has been performed of the aged receivable balances for both utility accounts and the miscellaneous accounts receivable. Attached is a detail listing of the following accounts. Utility Cusromer Accounts Services $23,908.00 Penalties $8,433.01 Tolal Utility Accounts $32,341.01 Miscellaneous Accounts Receivable 116,727.50 False Alarms 3,040.00 Bankruptcies (Cavanaugh Contrect) 51,400.00 Total $203,508.51 These accounts are greater than six months old and: • The customer has not responded to repeated notices for payment • The City does not have any current contact information for the customer . The customer has filed bankruptcy • The service was for garbage only and the customer has gone out of business, filed bankruptcy or the customer was a tenant and there is no tenant release form on fle . Md/or there are other circumstances making the payment uncollectible. Page 1 of 2 AUBURN * MORE THAN YOU IMAGINED 7 The above accounts have been deemed uncollectible. We are requesting that these accounts be written-off as bad debt. The Police Department staff has requested that the outstanding parking citations from 1999 and older be written off as bad debt. There are over 2,100 citations that total $70,911.02. Page 2 of 2 AUBURN x MORE THAN YOU IMAG W ED 2 ~ March 2010 Write-Off Proposal Summary Exhibit A Services Penalties Total Amount Utility Customer Accounts $ 23,908.00 $ 8,433.01 $ 32,341.01 Miscellaneous Acoounts Receivable $ 116,727.50 False Alarms $ 3,040.00 Cavanaugh Contract $ 51,400.00 To1al $ 203,508.51 Exhibii B Police Dept - Parking Citations $ 70,91 1.02 Total $ 70,911.02 UTILITY CUSTOMER ACCOUNTS EXHIBIT A Acct last Billed Last Poitl woter Sewer Storm Refuse Poncipol Penally iolol Service Lo<ation CommeNS - See legentl pa9e 7 008085 6/512008 7/e12008 b 10243 S ' b 8.9 $ 10134 y 212.48 b - b 21228 3365 Scenic Or SE BankroPCiy ~ 008877 3/23/2007 4/9/2007 64.03 5698 49.88 170.89 - 170.89 3501 nubumwoyS p59 Bonkrupcly 016940 4/10/2009 515/2009 155.66 299.31 9.30 72.60 536.07 536.87 3860 D PI SE Bankrupcty 016942 4/10/2009 5/5/2009 96.59 167.67 11.11 170.36 d45.73 445J3 3858DPISE BonkNptly 019811 8/ V/2005 9/13/2005 258.90 382.18 247.17 1.024.31 1.912.56 1,91256 4132 8 PI NW Bonkrupcty 027772 10112/2005 I i/4/2005 63.93 28.96 92.89 92.89 31621 Lea NiY Rtl Bonkropcty 034971 8/13/2009 7/6/2009 166.55 178.69 37.06 94.52 417A2 51.92 468.94 1315Pike51NE Bankrupcty 049920 5/2/2006 8N/2006 12.54 13.94 - ]9.]2 - 10620 135.00 241.70 41328%NW Banbupcty 050376 7/3112007 6/14/2007 91.69 184.48 56.15 162.82 494.94 491.94 80250thSi5E BonkrupCty 050597 3/20/2008 4/1/2008 48.84 16.00 64.84 64.84 202862ntlLOapSE Bankmpcty OSPSBd 4/20/2009 9/17/2008 36176 110.35 472.11 230.08 702.19 80362NDSt SE Banlwpcty 054625 314/2009 12/23/2008 174.05 53.62 227.67 227.67 7202 Ouncy Ave SE Bankrupcly 057921 9/4/2008 93.53 93.53 75.OD 168.53 29830 IJBth Ave SE BonkNp<ty 060207 6/12/2009 9115{2008 738.70 70.28 160.45 35.80 404.83 195.00 599.83 9064th515E Bonkrupcty , 012128 7/22/2009 3/11/2009 44636 128.43 574J9 269.00 843J9 6631 ElizabethnveSE BanWUpcty ' 022394 2122/2006 2/23/2006 113.05 151.82 47.56 13436 446.79 44619 116JSf5E Bankrvpcty 035447 10/1612006 5/16/2006 1,419.08 1,419.08 120.09 1.539.17 4520 B StNW Bdnkrupcty 035842 10/31/2004 11123/2004 15823 15823 150.00 30823 2105AUbumwoySNE Bonknipcty 036068 1016/2008 12/11/2008 551.44 551.44 551.44 3500 W volley Hwy BonkNpCty 036384 11/17/2005 5/2112005 568.08 568.08 15.00 583.08 122037ihSiNW Bankrupcty 050435 4/30/2006 4113l2006 336.94 336.94 240.00 576.94 4132B%NW BonkrupCfy 02020.5 5/2412005 512412005 38.75 55.45 16726 261.46 261.46 1702 Pike St NW COnv¢2iOn 005492 6/20@006 4/2/2007 86.80 28.16 407.62 322.58 570.00 892.58 4675 N SI NE Fscww Nolification W3031 8131/2006 7/24/2006 131J2 7531 43.46 4337 29386 240.00 533.86 22NStNE BcrowNOtifcafion 023841 4/13/2005 3/712005 47.36 109.53 31]7 75.00 263.06 263.06 308MSiNE FscrowNOtiFiCOlion 043844 8l1212005 16.68 24.40 6.93 779 55.80 55.80 308MSiNE B<mwNOtiticotion 028054 8/24/2005 8/16l2005 11426 40.65 11.55 166A6 15.00 181A6 110263E316th ESCrowNOtifiCOtion 034984 2110/2006 5/25/2005 100.3] 100.37 105.00 205.37 5222 Bridget Ave SE Exempt Service 034574 311212008 9/17/2007 198.47 198.47 165.00 363.47 3400ACOtlemyOrSE GbgOnly - noiRF 035553 I I/30/2008 9/1212008 130.32 130.32 90.00 220.32 11 I S Division Gbg Only - no TRF 035572 2/29/2004 12/2912003 43723 43723 437.23 202 37ih St NE 1t2 Gbg Only - no iRF 037008 3/1312008 1/22/2006 67371 673J1 810.00 1,483J1 3270 BSINw GbgOnN -noiRF 037221 3/29/2006 4/19/2005 1,084.69 1,084.69 135.00 1,219.69 2801ACOtlemyDr GbgOnry - noTRF . Page i UTiLITY CUSTOMER ACCOUNTS EXHIBIT A ~ ncct Lost &Oetl Lost Paitl '/✓ater Sewer Storm Retuse Principal Penalty Tolal dervice Locatian Commenk - See Legentl page 3 037461 3/31 /2005 418/2005 b - S - b - b 480.00 b 480.00 $ - $ 480.00 <Oa Aubum way S aC Gbg OnN - no TRF 037489 513112004 6/312004 935A3 935.43 I5.00 950.43 215CIOySt NW BI GbgOny - noTRF 037536 9/2012005 9/27/2005 8474 80J4 300.00 384]< 2100 nubum Way S Gbg OnN - no TRF 037673 4/25/2007 2/15/2007 541.28 54128 360.00 90128 4 150 BPINW0 106 GbgOnH - noTRF 049300 91112005 6/28/2005 124.09 124.09 240.00 364.09 4210 Aoborn Way N AB Gbg OnN - no TRF 049696 8/31/2007 7/30/2007 20134 20334 210.00 613.34 221HStNW GbgOnN - noTRf 050628 1/3112006 4/28/YW6 665.19 665.19 240.00 905.19 1441 nuburnWayN GbgOnly - noTRF 050914 414/2006 177.54 177.54 165.00 342.54 801CSISW GbgOnN - noiRF 051489 6/2@006 3/10@006 1.460.12 1,460.12 13637 1,596.89 21037ihSiSEk149 GbgOnN - noTRF 053255 12/5/2006 9/712006 1,110.96 1,410.96 90.00 1.500.96 2201 C St NW 85 Gbg Ony - no TRF 053465 72/5/2006 I12/2007 I74.46 174.46 330.00 504.46 I10IS,pertnallWOy GbgOnly - nOTRF 055192 71612007 4/20/2007 28831 288.31 225.00 51331 IIDISUpermallwoy GbgOnly - noTRF 061675 1/31/2009 1/7/2009 38.39 38.39 150.00 188.39 413AUbumAVe GbgOnly - noTRF 035670 3/1/2004 1/29/2004 76.06 76.06 45.00 121.06 116CIayStNW Gb90nry-uncoAectable 037568 II/ISROOa 11/30/2004 2,015.65 2.015.65 20.15 2.035.80 2302westvalleyHwy GbgOny - uncoilectable ' 060830 10/3112008 8/5/20D9 251 83 251.83 210.00 461.83 4503 D 51 NW Gbg Temp Dump 027627 5/2/2006 5/8/2006 52.13 52.13 255.00 307.13 30809 137ntl Ave SE House Demo 051984 8/10/2006 52.13 52.13 225.00 277.13 30809 132ntl Ave SE House Demo OSZWI 9/I5/2006 8/25/2006 I0478 104J8 751)0 17978 30917 132ntlAVe5E HouseDemo 007272 8/28/2009 71/2212005 37375 37375 225.00 59815 2121AUbumWayS Muckleshaat water 009081 ' 8/9/2006 3/I5/2006 66.00 66.00 270.00 33600 36823AUb-EnumcHwy Muckleshootwater 009083 8/9/2006 41512006 176.90 176.90 270.00 446.90 36901 Aub-Enum Hwy Mucklezhool water 009097 4/24/2006 3130/2007 60.80 60.80 270.00 330.80 36926 Aub-Enum Hwy Muckleshoot water 009114 81912006 4/11/2006 198.40 198.40 270.00 468.40 36807148ihAVeSE MUCkleshootwater 010304 5/31/2006 6/5/2006 59.50 720J0 19.80 200.00 225.00 425.00 5718HOxelLOOpSE NSFCheCk iotol § 2,892.47 b 2.858.52 b 1,271.57 b 76.84544 b 23.908.00 E 8.433.01 5 32.341.01 Page 2 UTILITY CUSTOMER ACCOUNTS EXHIBIT A Legend tO Acwonl was cbsetl tlue to bankrupl<y. Cily of nubum was onoble io collect on the account. II any money is receivetl trom the coad the Cily wiC recortl it as o recovery ol ihol BanWvptcy time. Conversion golonce was on o closetl account, was not tmnsfemetl to new owner ol time of the sofiware conversion. ES<!O`i+ nOlifCalions FuntlS were n0t wilhheitl ot ¢iCrow. By IhE fime City w05 ObIE 10 tletermine luntln were not vnihheltl, there hatl been subsequenl 5a1E5 On the prOpetly. &empt SeniCe Properly is exempt fram mondalory garboge service tlue lo location. Costomer tlisputetl billing pnor lo <horges being stoppetl. Gbg Only - no ihe a<count was a garbage only account that was set up in tenom's name only without owner approvol (no tenont release torm (TRFJ). The Legal Oept. staff advised thot we shoultl ' iRF write ofl the unpaitl tlebls. Gbg Only - Garboge onN customer. The customer wenl oul of buvness. iheit occounl wos senf to the Legal Depl. for <olledion, however. the Legal Depl. stotf wos unoble to collect antl uncollectable recommended vrtiting off this occount. Gbg Temp Dump Customer biletl br tempomry dumpster ond will npt pQy. ANempls Io coNOCt customerlor poymenl were vnsvccessfol. House Demo House wos tlemofishetl. Final bill unpoitl. htuckleshoot woler Firql Ws not pdtl when accoonis were conne<tetl to Muckleshoot water system. Unable fo lien Tribal propetly. NSf Check Check was returneC for non sufli<ienf funtls four months after poyment wos motle. nftempts to colleU wera unsuccessful. Pa9= 3 MISCELLANEOUS ACCOUNTS RECEIVABLE EXHIBIT A r Customer - Amount Bill Date Commenis-See Legend page 3 MM-M040615 $ 132.10 1/25/2005 Disposalcleanup MM-20040807 749.58 9/I5/2004 FocilityDamage WW-17000000 164.46 8/16/2004 Hydranicharges MM-20071107 520.00 3/18/2008 Leases MM-20071109 2,080.00 11/19/2007 Leases MM3200PARK 2,420.00 4/17/2008 Leases MM-20071105 1.660.00 2/17/2009 Leases . MM-20071103 120.00 5/15/2009 Leases MM-OT00040 180.00 7/6/2007 Police Off Duty MM-OT00005 . 1,87125 3/9/2007 Police Off Duty ST-07D7025 1,153J0 10/26/2007 PropertyDamoge - ST-07D7022 289.64 10/26/2007 Property Domoge ST-08D8002 1,354.48 5/21/2008 PropertyDamoge ST-06D6012 10,159.30 5/28/2008 Property Damage ST-06D6018 980.28 11/27/2006 ProperiyDamage ST-07D8012A 2,368.33 9/22/2008 Property Damoge ST-07D01304 31.50 2/26/2008 Property Damage ST-08D8017 2,096.47 6/12/2008 Property Damage 5T-08D8023 91.92 7/21/2008 PropertyDamage ST-08D8006 5,812.97 5/7/2008 Property Damage - ST-05D5003 15.294.59 6/24/2005 Property Damoge ST-07D7032 88.98 12/12/2007 PropertyDamage, ST-06D6003 . 1,873.86 5/18/2006 ProperlyDamage ST-06D6009 1,324.66 9/12/2006 Property Damage ST-08D8024 1,210.49 7/23/2008 Property Damoge . ST-08D7026 363.08 1/14/2008 Property Damage ST-08D8010 3.339.35 5/21/2008 PropertyDamage ST-06D6034 120.96 2/27/2007 Property Damage Page 1 MISCELLANEOUS ACCOUNTS RECEIVABLE EXHIBIT A ~ Cusiomer Amouni Bill Date Comments - See Legend page 3 ST-07D7005 $ , 60.48 2/27/2007 Property Damage ST-07D7029 102.77 11/I5/2007 ProperlyDamage ST-08D8008 20,926.55 5/22/2008 Property Damage ST-08D8016 614.58 5/30/2008 Property Damage ' ST-08D8027 875.90 8/28/2008 Property Damage ST-07D7024 1,389.36 10/26/2007 Property Damage ST-0503141 275.00 5/26/2005 PropertyDamage S7-06D6037 6,957.91 5/28/2008 Property Damage ST-06D6022 18,123.11 5/30/2008 ProperlyDamage ST-08D8013 75.27 5/22/2008 Property Damage ST-0500621 195.26 3/16/2005 Property Damage ST-08D8005 4,0I2.35 4/29/2008 Property Damage ST-06D6025 53.27 12/19/2006 Property Damage . ST-OSD5011 103.09 7/1/2005 ProperlyDamage ST-08D8031 75.46 10/16/2008 Property Damage . ST-08D8007 2,244.45 5/22/2008 Property Damage ST-08D8021 1,316.32 7/21/2008 PropertyDamage SS-T0876710 10.00 7/25/2003 Restitution SG20060003 400.00 1 1/22/2006 Shopping Carts . SC-20090006 60.00 2/5/2009 Shopping Carfs SC-20090004 70.00 2/5/2009 Shopping Caris TM-9900445P 934.42 6/11 /2003 Traffic Mitigation $ 116,727.50 Page 2 MISCELLANEOUS ACCOUNTS RECEIVABLE EXHIBIT A ~ Legend Disposal cleanup Repeated attempts fo collect were unsuccessfull. Facility Damage Repeated atfempis io collecf were unsuccessfull for pork renial damages. Hydrant charges The City was unable to collect balance after deposit was applied fo charges. Leases Tenant evicied, affempis to colleci were unsuccessful Police Off Dury Disputed charges over contract rate; unable to colled Properfy Damage The Lega6Depf. staff recommended writeoff as the statute of limiiotion was expired. Restitufion Bolance remaining ofter court closed case. Shopping Caris No response to repeafed requests for impound fees on abandoned shopping carfs. Traffc Mitigafion Disputed charges; unabie to collect. Page 3 MISCELLANEOUS ACCOUNTS RECEIVABLE (Alarms) EXHIBIT A . 0 Customer Amount Date Descrip}ion ^ AL-20030256 $ 57.00 5/I8/2009 False Alarms AL-20030278 50.00 6/18/2007 False Alarms AL-20030633 270.00 11/17/2008 False Alarms . AL-20030651 57.00 4/15/2009 False Alarms AL-20030665 50.00 II/17/2006- False Alarms AL-20030686 378.00 10/16/2008 False Alarms AL-20030688 54.00 11/17{2008 False Alarms - AL-20030710 100.00 5/17/2007 False Alarms AL-20030712 104.00 1/17/2008 FdISe AtOrmS AL-20030745 50.00 8/17/2007 False Alarms AL-20030748 61.00 3/16/2009 false Alarms AL-20030750 50.00 9/14/2007 FdISe Aldrms AL-20030758 108.00 11/17/2008 False Alarms AL-20030788 104.00 11/19/2007 False Alarms AL-20030790 50.00 II/19/2007 . False Alarms AL-20030823 222.00 5/18/2009 False Alarms nL-20030835 54.00 7/14/2008 False Alarms AL-20030843 108.00 4/17/2008 False Alarms AL-20030859 54.00 7/14/2008 False Alarms AL-20030866 54.00 7/14/2008 False Alarms AL-20030900 54.00 11/17/2008 False Alarms AL-20030901 54.00 11 /17/2008 Fdlse AlatmS AL-20030902 54.00 11/17/2008 Faise Alarms AL-20030916 54.00 12/16/2008 False Alarms AL-20030919 108.00 12/16/2008 False Alarms Page 1 MISCELLANEOUS ACCOUNTS RECEIVABLE (Alarms) EXHIBIT A AL-20030923 54.00 1/16/2009 Faise Alarms ~ AL-20030933 57.00 3/16/2009 False Alarms AL-20030934 57.00 3/16/2009 Folse Alorms . A1-20030947 114.00 7/16/2009 False Alarms AL-20030948 228.00 5/18/2009 Folse Alarms AL-20030949 114.00 7/16/2009 False Alarms AL-20030955 57.00 7/16/2009 False Alarms $ 3,040.00 False Alarms: Repeated attempts to collect were unsuccessfull. Addresses were cross checked against Last cycle billed July 2009 due to program change. . Page 2 Cavanaugh Contract N Customer Name Amouni Description ~ MM-2005ACE Cavanaugh Coniract $ 51,400.00 UNDERGROUND UTILITY CONTRACT Project Cosis for underground power ufilities design and construction services per agreement were not paid by property owner or developer who subsequently filed for Chapter 1 I Bankrupicy. Page 1 . Parking Citations Exhibit B n Cusiomer Amouni Date Description ~ Vorious - over 2,100 $ 70,911.02 1999 and older Outsfanding parking citaiions from 1999 and older The Police Depar}ment staff is recommending fhat ihe outsianding parking citations from 1999 and older be written off. There are more than 2,100 acwunts that total $70,911.02. Page 1