Loading...
The URL can be used to link to this page
Your browser does not support the video tag.
Home
My WebLink
About
02-17-2004 ITEM V-C
CITY OF ° AGENDA BILL APPROVAL FORM 00, WASHINGTON Agenda Subject: Date: Bad Debt Write Off February 10, 2004 Department: Attachments: Budget Impact: Finance Lists of Bad Debt Accounts Administrative Recommendation: City Council to authorize the write-off of bad debts in accordance with City policy in the total amount of $60,433.37. Background Summary: The attached lists of accounts in the amount of $60,433.37 is being submitted for approval to write-off. The lists are categorized as follows: Accounts Receivable Uncollectible $15,256.56 Utilities — over 1 yr old & sent to collection 26,360.14 Utilities — over 1 yr old & not sent to collection 3,848.87 Utilities — Bankruptcy/Uncollectible 14,552.80 Parks Dept. Receivables Uncollectible 415.00 N0217-1 Reviewed by council & committees: Reviewed by Departments & Divisions: ❑ Arts Commission COUNCIL COMMITTEES: ❑ Airport ❑ Human Resources ❑ Hearing Examiner ❑ Finance ❑ Building ❑ M&O ❑ Human Services ❑ Municipal Serv. ❑ Cemetery ❑ Mayor ❑ Library Board ❑ Planning & CD ❑ Finance ❑ Parks ❑ Park Board ❑ Public Works ❑ Fire ❑ Planning ❑ Planning Comm. ❑ Other ❑ Legal ❑ Police ❑ Public Works Action: Committee Approval: ❑Yes ❑No Council Approval: ❑ Yes []No Call for Public Hearing Referred to Until Tabled Until Councilmember: Backus Staff: Coleman Meeting Date: February 17, 2004 1 Item Number: V.0 .AUBURN * M©RE THAN YOU IMAGINED Accounts Receivable Uncollectible Account # Principal Last Bill Date Acct Type Comments AA -H7200000 $ 207.97 7/17/2002 AIRPORT RETURNED MAIL AA-HT108ZZ00 $ 24.00 2/15/1997 AIRPORT SMALL BALANCE AA -T1230000 $ 60.83 12/17/2002 AIRPORT DISPUTED RENT AA -T3800000 $ 58.66 3/16/2001 AIRPORT BAD ADDRESS BI -A0713200 $ 375.00 11/18/2002 BIA PER MJR RECOMMENDATION BB-IAZ00864 $ 232.00 6/16/1994 BIA AT COLLECTION BB-IAZ02375 $ 258.22 6/16/1994 BIA AT COLLECTION BB-IAZ03013 $ 563.40 6/30/1994 BIA AT COLLECTION BU -S0521700 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION BU -S0546100 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION BU -S0640400 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION BU -S0656700 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION BU -S0663400 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION BU -S0708700 $ 45.00 3/14/2000 BUSINESS LICENSE AT COLLECTION MM -00050000 $ 216.70 6/19/2000 MISC AT COLLECTION -PENALTY REMAINS MM -10300000 $ 1,857.23 11/19/2001 MISC BANKRUPTCY-REC'D $392.02 FROM CLAIM MM -10400000 $ 2,474.59 4/17/2001 MISC BANKRUPTCY MM -C0069600 $ 4.23 6/19/2000 MISC SMALL BALANCE MM -02054670 $ 2,010.75 7/17/2002 VEHICULAR DAMAGE NO RESPONSE SS -T0001681 $ 105.51 5/22/2000 DAMAGE NO RESPONSE -OVER 3 YRS SS -T0002733 $ 437.47 5/22/2000 DAMAGE NO RESPONSE -OVER 3 YRS ST -20035201 $ 50.00 6/16/2003 DAMAGE SMALL BALANCE VI -00033298 $ 1,450.00 1/15/1999 BLDG CODE AT COLLECTION VIOLATION VI -00033898 $ 1,200.00 1/15/1999 BLDG CODE AT COLLECTION VIOLATION VI -00033998 $ 1,500.00 1/15/1999 BLDG CODE AT COLLECTION VIOLATION VI -00036698 $ 1,100.00 1/15/1999 BLDG CODE AT COLLECTION VIOLATION VI -00039098 $ 700.00 1/15/1999 BLDG CODE AT COLLECTION VIOLATION VI -00257990 $ 100.00 12/15/1999 BLDG CODE AT COLLECTION VIOLATION nts Receivable Uncollectible Attachment for N0217-1 Page 1 of 5 Utilities - Accounts Over 1 Year Old and Sent to Collection Account # Last Bill Date Date Sent to Alliance Comments Principal 01-08-010000-02 $ 159.66 8/16/02 12/13/02 CLOSING BILL 8/16/02 01-08-343800-02 $ 91.53 9/12/02 1/31/03 CLOSING BILL 9/12/02 01-12-054000-04 $ 170.76 6/12/01 11/16/01 CLOSING BILL 6/12/01 01-12-090000-00 $ 318.10 11/4/02 1/31/03 CLOSING BILL 11/4/02 01-12-279600-03 $ 93.68 9/12/02 1/31/03 CLOSING BILL 9/12/02 01-16-120000-01 $ 224.88 10/31/02 4/10/02 CLOSING BILL 10/31/02 01-16-372000-00 $ 173.32 12/10/01 5/24/02 CLOSING BILL 12/10/01 01-16-411000-02 $ 543.33 7/25/02 12/13/02 CLOSING BILL 7/25/02 01-17-015600-02 $ 413.75 2/26/02 10/31/02 CLOSING BILL 2/26/02 01-17-017400-04 $ 39.23 2/19/02 12/13/02 CLOSING BILL 2/19/02 01-17-017400-05 $ 323.85 9/12/02 1/31/03 CLOSING BILL 9/12/02 01-17-017400-06 $ 106.79 10/17/02 1/31/03 CLOSING BILL 10/17/02 01-19-390000-07 $ 127.44 2/1/02 10/31/02 CLOSING BILL 2/1/02 01-23-162000-03 $ 231.85 2/12/02 10/31/02 CLOSING BILL 2/12/02 01-27-501000-02 $ 164.29 5/31/01 11/16/01 CLOSING BILL 5/31/01 01-43-081200-00 $ 54.11 3/9/02 10/31/02 CLOSING BILL 3/6/02 01-46-021000-01 $ 195.11 9/28/01 10/31/02 CLOSING BILL 9/28/01 01-46-057000-01 $ 217.09 1/17/02 10/31/02 CLOSING BILL 1/17/02 01-48-054100-00 $ 123.91 9/17/02 12/13/02 CLOSING BILL 9/17/02 01-50-282000-02 $ 200.96 6/5/02 10/31/02 CLOSING BILL 6/5/02 01-50-327000-08 $ 122.46 5/31/02 11/16/01 CLOSING BILL 5/31/01 02-04-273000-04 $ 130.52 10/9/01 5/24/02 CLOSING BILL 10/9/01 02-04-333000-02 $ 240.17 7/13/01 6/28/02 CLOSING BILL 7/13/01 02-08-138000-00 $ 297.21 12/18/01 12/27/02 CLOSING BILL 12/18/01 02-08-186000-01 $ 111.27 6/25/01 11/16/01 CLOSING BILL 6/25/01 02-08-282000-08 $ 196.06 2/1/02 10/31/02 CLOSING BILL 2/1/02 02-08-381000-03 $ 140.20 1/23/02 5/29/02 CLOSING BILL 1/23/02 02-12-153000-02 $ 105.99 11/30/01 10/31/02 CLOSING BILL 11/30/01 02-12-339000-03 $ 108.61 2/5/02 10/31/02 CLOSING BILL 2/5/02 02-16-219000-02 $ 181.18 11/1/01 5/24/02 CLOSING BILL 11/1/01 02-19-177000-01 $ 355.88 7/19/02 12/13/02 CLOSING BILL 7/19/02 02-23-105000-05 $ 139.99 8/14/02 12/13/02 CLOSING BILL 8/14/02 02-23-294000-02 $ 129.15 3/29/02 10/31/02 CLOSING BILL 3/29/02 02-23-363000-02 $ 109.87 12/7/01 5/24/02 CLOSING BILL 12/7/01 02-27-219000-00 $ 264.64 5/8/01 11/16/01 CLOSING BILL 5/8/01 02-31-115500-02 $ 254.93 11/1/01 5/24/02 CLOSING BILL 11/1/01 02-31-117100-03 $ 313.62 4/3/02 10/31/02 CLOSING BILL 4/3/02 02-31-119000-04 $ 230.88 12/10/01 5/24/02 CLOSING BILL 12/10/01 02-31-295000-01 $ 480.65 5/15/01 11/16/01 CLOSING BILL 5/15/01 02-31-439600-00 $ 614.40 12/20/01 5/28/02 CLOSING BILL 12/20/01 02-31-439600-01 $ 122.10 3/4/02 10/31/02 CLOSING BILL 3/4/02 02-31-051000-00 $ 262.23 5/24/02 10/31/02 CLOSING BILL 5/24/02 02-34-117000-02 $ 152.79 8/16/02 12/13/02 CLOSING BILL 8/16/02 02-38-357000-01 $ 196.37 3/19/02 10/31/02 CLOSING BILL 3/19/02 02-42-147000-02 $ 382.08 12/20/01 5/28/02 CLOSING BILL 12/1/01 02-42-174000-04 $ 236.92 9/12/02 1/31/03 CLOSING BILL 9/12/02 02-42-297800-02 $ 196.13 5/10/01 11/16/01 CLOSING BILL 5/10/01 02-42-298300-01 $ 163.93 8/14/02 12/31/02 CLOSING BILL 8/14/02 02-42-298800-05 $ 125.40 9/10/01 5/23/02 CLOSING BILL 9/10/01 02-42-509000-04 $ 139.47 12/20/01 10/31/02 CLOSING BILL 12/20/01 02-47-044200-00 $ 61.71 8/30/01 5/23/02 CLOSING BILL 8/30/01 02-47-050050-01 $ 120.53 6/14/02 12/27/02 CLOSING BILL 6/14/02 02-47-050050-02 $ 147.24 10/29/02 1/31/03 CLOSING BILL 10/29/02 02-53-009000-01 $ 1,374.78 8/14/02 12/31/02 CLOSING BILL 8/14/02 02-60-198000-04 $ 67.95 7/17/02 12/13/02 CLOSING BILL 7/13/02 03-04-105000-05 $ 216.46 3/29/02 12/13/02 CLOSING BILL 3/29/02 03-04-129000-05 $ 271.54 9/18/01 5/23/02 CLOSING BILL 9/18/01 03-04-129000-06 $ 42.72 9/20/01 5/23/02 CLOSING BILL 9/20/01 03-04-378000-00 $ 120.42 7/2/02 12/13/02 CLOSING BILL 7/2/02 03-12-429000-01 $ 155.48 5/10/02 10/28/02 CLOSING BILL 5/10/02 Attachment for N0217-1 Page 2 of 5 Attachment for N0217-1 Page 3 of 5 Date Sent Account # Principal Last Bill Date to Alliance Comments 03-12-444000-02 $ 490.74 4/30/02 12/13/02 CLOSING BILL 4/30/02 03-16-103500-00 $ 163.21 6/21/02 12/13/02 CLOSING BILL 6/21/02 03-16-279000-01 $ 141.59 6/15/01 11/16/01 CLOSING BILL 6/15/01 03-23-057000-02 $ 219.73 5/7/01 11/16/01 CLOSING BILL 5/7/01 03-23-057000-03 $ 154.50 8/14/01 5/23/02 CLOSING BILL 8/14/01 03-27-003000-02 $ 168.32 10/22/02 1/31/03 CLOSING BILL 10/22/02 03-30-003000-04 $ 30.01 5/10/01 11/16/01 CLOSING BILL 5/10/01 03-30-045000-03 $ 297.15 10/7/02 1/31/03 CLOSING BILL 10/7/02 03-31-069000-03 $ 155.85 9/6/02 1/31/03 CLOSING BILL 9/6/02 03-31-210000-05 $ 268.85 5/2/01 11/16/01 CLOSING BILL 5/2/01 03-34-020500-02 $ 33.69 4/24/02 1/8/03 CLOSING BILL 4/24/02 03-34-147000-00 $ 148.31 9/7/01 5/23/02 CLOSING BILL 9/7/01 03-34-276000-04 $ 162.38 7/16/02 1/31/03 CLOSING BILL 7/16/02 03-34-276000-05 $ 152.95 11/7/02 1/31/03 CLOSING BILL 11/7/02 03-46-057000-02 $ 304.73 4/24/02 12/13/02 CLOSING BILL 4/24/02 03-46-249000-00 $ 119.39 3/1/02 12/13/02 CLOSING BILL 3/1/02 03-46-408000-04 $ 47.65 4/6/01 11/16/01 CLOSING BILL 4/6/01 03-50-009000-01 $ 89.96 9/6/01 5/23/02 CLOSING BILL 9/6/01 03-50-010000-04 $ 133.56 11/7/01 5/24/02 CLOSING BILL 11/7/01 03-57-060000-02 $ 175.93 9/7/01 5/23/02 CLOSING BILL 9/7/01 03-61-183000-01 $ 226.02 1/10/02 5/28/02 CLOSING BILL 1/10/02 03-61-357000-01 $ 177.36 6/27/02 12/13/02 CLOSING BILL 6/27/02 04-08-003000-00 $ 46.83 6/11/02 12/13/02 CLOSING BILL 6/11/02 04-12-057000-02 $ 234.67 5/6/02 12/13/02 CLOSING BILL 5/6/02 04-12-099000-04 $ 133.20 9/6/01 10/31/02 CLOSING BILL 9/6/01 04-12-294000-02 $ 81.26 9/13/00 5/23/02 NSF CK ON CLOSING BILL 9/13/00 04-12-465000-01 $ 161.86 10/7/02 1/31/03 CLOSING BILL 10/7/02 4-16-081000-02 $ 155.28 10/1/01 10/31/02 CLOSING BILL 10/1/01 04-16-264000-00 $ 106.38 7/3/02 12/27/02 CLOSING BILL 7/3/02 04-18-368000-02 $ 44.25 4/20/01 11/16/01 CLOSING BILL 4/20/01 04-19-404000-00 $ 122.75 11/30/01 5/24/02 CLOSING BILL 11/30/01 04-19-619000-00 $ 216.27 6/26/01 11/16/01 CLOSING BILL 6/26/01 04-23-117000-03 $ 141.10 12/19/01 10/31/02 CLOSING BILL 12/19/01 04-23-195000-00 $ 156.12 12/13/01 5/24/02 CLOSING BILL 12/13/01 04-25-015000-03 $ 70.81 11/19/01 10/31/02 CLOSING BILL 11/19/01 04-25-134000-06 $ 298.27 9/12/02 1/31/03 CLOSING BILL 9/12/02 04-25-155000-00 $ 119.92 5/28/02 10/31/02 CLOSING BILL 5/28/02 04-26-066400-01 $ 79.05 1/16/02 5/29/02 CLOSING BILL 1/16/02 04-26-201600-01 $ 122.84 4/10/01 11/16/01 CLOSING BILL 4/10/01 04-38-186000-03 $ 110.68 7/16/02 12/13/02 CLOSING BILL 7/16/02 04-38-319000-00 $ 410.26 9/5/02 1/31/03 CLOSING BILL 9/5/02 04-49-269000-01 $ 268.08 5/10/02 12/27/02 CLOSING BILL 5/10/02 05-90-237800-01 $ 86.79 8/31/01 5/23/02 CLOSING BILL 8/31/01 05-90-246500-02 $ 47.40 6/21/02 12/13/02 CLOSING BILL 6/21/02 05-90-250700-00 $ 91.72 9/30/02 1/31/03 CLOSING BILL 9/30/02 05-90-255100-00 $ 503.63 4/30/01 11/16/01 CLOSING BILL 4/30/01 05-90-258200-00 $ 278.85 3/31/01 11/16/01 CLOSING BILL 3/31/01 05-90-267700-00 $ 125.03 9/30/01 5/23/02 CLOSING BILL 9/30/01 - BANKRUPTCY 05-90-291800-00 $ 1,523.45 7/31/02 12/13/02 CLOSING BILL 7/31/02 05-90-297100-00 $ 436.41 5/23/02 1/31/03 CLOSING BILL 5/23/02 05-90-507700-00 $ 249.83 4/1/02 12/13/02 CLOSING BILL 4/1/02 05-90-755900-00 $ 1,853.25 5/31/02 12/13/02 CLOSING BILL 5/31/02 05-90-772200-00 $ 128.40 8/31/01 5/23/02 CLOSING BILL 8/31/01 05-90-782100-00 $ 475.92 11/30/01 10/31/02 CLOSING BILL 11/30/01 05-90-782500-00 $ - 11/30/01 11/30/01 CLOSING BILL 11/30/01 05-90-794500-00 $ 560.13 8/31/02 1/31/03 CLOSING BILL 8/31/02 $ 26,360.14 Utilities - Accounts Over 1 Year Old and Sent to Collection Attachment for N0217-1 Page 3 of 5 Utilities - Over 1 Year Old and Not Sent to Collection Account # 01-00-101400-00 01-08-150000-00 01-12-201000-01 01-12-279600-02 01-38-030000-02 02-08-282000-07 02-31-247000-00 02-38-342000-01 02-49-453200-01 02-49-453200-02 02-49-693200-01 03-04-318000-01 03-12-201000-02 03-12-201000-03 03-19-177000-01 03-42-096000-02 03-42-099000-01 03-57-216000-03 04-25-134000-07 05-90-796700-00 Principal $ 50.02 La 10/30/02 $ 155.59 11/5/02 $ 93.44 2/19/02 $ 317.34 7/3/02 $ 297.28 5/22/02 $ 216.39 11/1/01 $ 113.10 11/2/02 $ 44.36 $ 417.14 11/5/02 $ 51.50 7/3/02 $ 57.29 12/6/02 $ 90.19 11/5/02 $ 96.70 12/6/02 $ 77.19 7/16/02 $ 702.24 9/26/02 $ 183.80 12/31/02 $ 357.10 10/30/02 $ 29.33 10/30/02 $ 167.13 12/17/02 $ 331.74 12/13/02 $ 3,848.87 Uti st Bill Date Comments 10/30/02 CLOSING BILL 10/30/02 11/5/02 CLOSING BILL 11/5/02 2/19/02 CLOSING BILL 2/19/02 7/3/02 CLOSING BILL 7/3/02 5/22/02 CLOSING BILL 5/22/02 11/1/01 CLOSING BILL 11/1/01 11/2/02 CLOSING BILL 11/2/02, ARR $50/MO COMPLETED 3/31/04 11/5/02 CLOSING BILL 11/5/02, NO FORWARD ON FILE 7/3/02 CLOSING BILL 7/3/02 12/6/02 CLOSING BILL 12/6/02 11/5/02 CLOSING BILL 11/5/02 12/6/02 CLOSING BILL 12/6/02 7/16/02 CLOSING BILL 7/16/02 9/26/02 CLOSING BILL 9/26/02 12/31/02 CLOSING BILL 12/31/02 10/30/02 CLOSING BILL 10/30/02 10/30/02 CLOSING BILL 10/30/02 12/17/02 CLOSING BILL 12/17/02 12/13/02 CLOSING BILL 12/13/02 9/30/02 CLOSING BILL 9/30/02 lities - Over 1 Year Old and Not Sent to Collection Utilities - Bankruptcy/ Uncollectible Account # Principal Last Bill Comments Date 05-90-244800-00 $ 296.27 7/31/01 MJR RECOMMENDS TO W/O AS BUSINESS NO LONGER EXISTS 02-49-453200-01 $ 417.14 7/3/02 FORECLOSURE 05-90-286800-00 $ 2,042.70 9/30/02 MJR RECOMMENDS TO W/O AS UNCOLLECTIBLE 04-20-118000-01 $ 200.44 10/3/02 FORECLOSURE OCT 2002 02-00-686000-01 $ 501.57 12/6/02 CLOSING BILL 12/6/02, MJR RECOMMENDS W/O AS UNCOLLECTIBLE 02-49-453200-02 $ 51.50 12/6/02 FORECLOSURE 02-57-007600-00 $ 136.93 12/13/02 BANKRUPTCY 02-57-008000-00 $ 756.71 12/13/02 BANKRUPTCY 03-42-177000-00 $ 247.16 4/17/03 BANKRUPTCY 4/2003, DISCHARGE 7/2003 02-04-333000-03 $ 293.32 7/15/03 CITY ERROR -BALANCE NOT INCLUDED W/ESCROW ESTIMATE 05-90-259800-00 $ 1,017.34 8/31/03 MJR RECOMMENDS TO W/O AS BUSINESS NO LONGER EXISTS 02-04-177000-01 $ 1,038.48 9/25/03 BANKRUPTCY 8/2003, DISCHARGE 11/2003 05-90-808200-00 $ 7,292.13 9/30/03 BANKRUPTCY-MJR RECOMMENDS TO W/O AS BUSINESS NO LONGER EXISTS 04-19-588000-01 $ 109.46 11/14/03 BANKRUPTCY 10/2003 05-90-441200-00 $ 151.65 11/30/01 CLOSING BILL 11/30/01, BANKRUPTCY JAN 2002 $ 14,552.80 Utilities - Bankruptcy/ Uncollectible Attachment for N0217-1 Page 4 of 5 Parks Dept. Receivables Uncollectible Customer Name Total Description Owing Since 1. $ 120.00 NSF Ck & fees April 1999 2. $ 5.00 Residential fee diff Nov 1999 3. $ 50.00 Extra key fee April 2002 4. $ 15.00 Pant deposit fee June 1998 5. $ 30.00 NSF Ck & fees Jan 1999 6. $ 10.00 Player add fee Aug 1998 7. $ 5.00 Camping contract balance June 2001 8. $ 50.00 Extra key fee Oct 1999 9. $ 45.00 Daycamp late pickup fee Oct 2002 10. $ 15.00 Player add fee July 1998 11. $ 70.00 Day camp registration fee June 1998 $ 415.O01IParks Dept. Receivables Uncollectible Attachment for N0217-1 Page 5 of 5