Loading...
HomeMy WebLinkAbout14. 16-71FEBRUARY 23, 2016 16-71 RESOLUTION (CARRIED ___6-0____ LOST _______ LAID OVER _______ WITHDRAWN _______) PURPOSE: CANCEL OUTSTANDING CHECKS; WRITE OFF DELINQUENT AND UNCOLLECTIBLE ACCOUNTS INITIATED BY: DEPARTMENT OF FINANCE BE IT RESOLVED by the Common Council of the City of Oshkosh that because the checks on the attached list "A" ($1,751.97) have been outstanding for more than twelve months, the proper City officials are hereby authorized to notify Associated Bank of Oshkosh to stop payment on these checks and to credit the appropriate accounts the proper amounts. BE IT FURTHER RESOLVED that the proper City officials are hereby authorized to write off, for accounting purposes only, the attached general accounts receivable, list "B", with money for this purpose appropriated from Account No. 100-0908-6469-00000 Tax Refund and Bad Debt, ($13,892.91). BE IT FURTHER RESOLVED that the proper city officials are hereby authorized to write off, for accounting purposes only, the attached water, sewer, and storm water utility accounts receivable, lists “C”, “D” and “E”, with money for the purposes appropriated from each Account Number as follows: Acct. No. 541-1890-6469-08903 ($4,165.12); Acct. No. 551-1950-6469-00000 ($3,801.11); and Acct. No. 561-2050-6469-00000 ($1,953.59). n o��Fi TO: FROM: DATE: Clry at OsFkas� Finance Department 215 Chu¢h Ave., PO Bon 1130 OsM1kosn, WI 5a903�1130 19201 236-5006 19201 236-5039 FAX MEMORANDUM Honorable Mayor and Members of the Common Council Trena Larson, Director of Finance Febmary 12, 2016 RE: Cancel Ou[standing Checks / Write-0ff Delinquen[ & Uncollectible Accounts BACKGROUND As part of the year-end process, staff reviews outstanding checks, past due accounts receivables, and bankruptcy accounts; and requests that Council approve [he following: o Cancel outstanding accoun[s payable and payroll checks that were issued more tha� 1 yeaz agq and up to 2 yeazs ago, i.e. the request in 2016 is to cance] checks that were issued in 2014, o Adjust our accounting records ro reflect the likelihood that we may not collect past due receivables (vazious purposes), and o Write-offbankrup[cies. ANALYSIS This is an annual process that is completed to maintain current and accurate records. The details for each section are as follows: Cancel Outstandin¢ Checks — Per the detailed sheets, this recommendation includes $1,751.97 of combined accounts payable and payroll checks. Please note that it is very possible / likely that e substantial number of these checks have been cashed but did not make it back through Ihe federal banking system to be charged against our accounts. However, I do review the list and make contac[ with those payees with outstanding check amounts greater than $100, as these are the ones that likely would �ot have gotten held up in the federal banking sys[em. Also, if, a[ any time in the futuce, auy of [he checks are presen[ed for payment, [he City will certainly honor them. Delinouent Invoice Write-01T's - This recommendation includes $13,892.91 of receivables from 2011 through 2015. It is the City's policy to adjust our accounting records [o reflect the likelihood that these receivables may not be collectible. This is an accounting entry only and does not celinquish the obligor of the deb[ as collection efforts are still taking place on these accounts. Bankrup[cv Write-OlT's - This recommendation includes $9,919.82 receivables from 2014. These are amounts that have been dischazged through bankruptcy proceedings. Once [he U[ility is notified of the discharge, by the courts, these amoun[s aze no longer legally collectible; therefore need to be written off. FISCAL IMPACT The `Cancel Oues�anding Checks' item ineceases the Ciry's cash positioq while the `Bankrupecy Wri�e- Off's' item reduces the cash position of each of the respective utilities. However, the `Delinquent Invoice Write-Ofj's' item will not change the City's cash position. Rather, this will affect our financial statemen[s in tha[ Ihey lower the accounts receivable amoun[s stated in those documents. S[aff recommends that Council authorize this resolution to execute these transactions as outlined. Respectfully Submi[[ed, Approved: ���C '�t1'� /� — /�iaGL�� Trena Larson Mark Rohloff Director of Finance City Manager OUTSTANDING CHECK LISTING AS OF DECEMBER 2014 FOR PAYROLL AND PAYABLES- A ASSOCIATED PAYABLES ACCOUNT ACCOUNTS PAYABLE OUTSTANDING CHECKS AS OF Check # 184635 184702 184831 185202 185251 185442 185551 185559 185562 185687 185721 186328 186594 186754 187339 187390 187508 187579 187694 188261 188439 188449 188590 188767 188933 188959 189026 189182 189400 189502 190576 190916 191008 191023 Issue Date 1/10/2014 1/10/2014 1/17I2014 1 /31 /2014 2/7/2014 2/14I2014 2/21/2074 2/21/2014 2/21/2014 2/28/2014 2/28/2014 4/4/2014 4/17/2014 4/25/2014 5/30/2014 5/30/2014 6!6/2014 6/13/2014 6/13/2014 7/18/2014 7/252014 7/25/2014 8/1/2014 8/15/2014 822/2014 8/22/2014 8/22/2014 8Y29l2014 9/12/2014 9/19/2014 11/14/2014 12/5/2014 12/12/2014 12/12/2014 Payableto HERMAN & KITTLE PROP BETH ANN THADA CALVIN KEM NGUYEN JAMES WOERPEL NLER 8 KHYRSTEN GOSS STEWART TITLE LETS KNOCK OUT B. CANCER NEW TITLE SERVICES NOVA TITLE CLOSING NATHAN GAZZA NEW TITLE SERVICES HERMAN & KITTLE PROP IHOP REAL ESTATE YU SHEIN ALBERT CLARK IV LEAH WAGNER STEVEN SOSNOSKI EAN HOLDINGS LLC KATELYNZEAMER KELLEY DUHATSCHEK MORTON SAFETY JOSHUA & KELLY NOURSE HENRY O KERE BRIAN & MARGAET BREUER RONALD DICK ROBERTHEROLD KEUNTAETURNER SCHMITT TITLE OSHKOSH AREA UNITED WAY GUAR4NN TITLE SERVICES ELECTRICAL CONST SERVICE BRANDICE COURTNEY FRANK G ADASHUN BUDS ELECTRIC Amount $ 25.00 4.68 6.00 20.01 0.53 19.48 18.74 50.42 45.97 25.00 71.65 75.00 40.00 136.67 10.00 5.00 200.00 13.00 10.00 15.00 529.43 4.38 15.00 6.1 S 70.00 i o.00 11.00 13.01 70.00 84.92 22.00 60.00 59.77 3.00 SubtOfal-Payables $ 1,690.84 ASSOCIATEDPAYROLLACCOUNT � PAYROLL ACCOUNT OUTSTANDING CHECKS AS OF DECEMBER Check # Issue Date Payable to Amount 604586 4/8/2014 JOANNE SCHMELZ $ 18.75 604828 6l5/2014 MONICABEGLEY 3.35 604863 6ISI2014 SAMUEL KRASNY 39.03 Subfotal-Payroll $ 61.13 2014CheckCancellations S 1,751.97 Department Planning Permit Refund Tax Overpayment Refuntl Tax Overpayment Refund Tax Overpayment Refund Tax Overpayment Refund Tax Overpayment Refund Museum Donation Wa[er Final Bill Refund Tax Overpaymen� Refund Parking Ticket Refund Water Final Bill Refund Planning Permit Refund Finance-Admin Snow Removal Retund Water Final Bill Refund Water Final Biil Refund Parking Ticket Refund Clerk License Refund Parking Tickel Refund Parking Ticket Refund Sanitation Special Pickup Refund Wastewater Tax Overpayment Refund Parking Ticket Refund Tax Overpaymen[ Refund Parking Ticket Refund Parking Ticket Refund Parking Ticket Refund Water Final Bill Refund Council and Manager UWO Conf. Reg. Water Final Bill Refund Inspections Permit Refund Clerk License Refund Water Final Bill Re(und Inspections Pertnit Retund Department Poll warker Pollock Community Water Park Library Accounts Receivable to be written off as of December 31, 2015 - B Invoice Invoice Balance Date to Number Date Name Description Dept. Due Coll Aqency Comments 21988 12/0�/11 WPSC Storm Sewer Repair 0430 $1,41626 N/A Disputetl 28970 03/14/14 Rhema Freighters Hazmat Cleanup 0230 85.40 11/15/2014 No Activity 31654 11/11/14 Harnitz Law Office LLC Ambulance Rewrds 0240 8.13 9/2/2015 Collection Fee 31882 12/i6/14 Rachel Wagner Damaged Streetlight OBOt 1,261.99 4/10/2015 No Adivity 32451 03/20I75 ELCO AEministrative Services Traffc Signal Repair OBOi 35.00 N/A Atlministretive Fee 32452 0320/15 DanielEltlritlge TrafficSignalRepair 0801 1,221.06 BA52015 NoACtivity 32950 OS/12/15 LouAru Damaged5treetlight 0801 3,20135 8/5/2015 NoACtiviry 33586 07/09/15 Aamn Batterton Damagetl Streetlight 0807 3,723.67 11/102015 No Activiry 34421 09/15/15 Da�win Grignon Uamaged Streetlight 0801 2,9G0.05 9A5/2015 Deceased. No estate. E13,892.91 Water Delinquent Accounts to be Written off as of December 31, 2015 - C Account Name Address Date Amount Reasan t004/85000.00 STEVE THORNTON 418 W 19TH AVE 7/t4/2014 3.9t BANKRUPTCY 1004-485000.02 STEVE THORNTON 418 W 19TH AVE 7/t4/20t4 284.44 BANKRUPTCV 1006-290000.00 GNDY MARTMEZ 2505 OREGON ST 7/29/2014 925.64 BANKRUPTCY 1008-125000.01 MINDVSUETURINSKE 1629ARIZONAST 5/12I2014 46.40BANKRUPTCY 1008-525000.01 PATRIqA HAVERiY 312 W 18TH AVE 7/i6/2014 483.35 BANKRUPTCY 1008-915000.01 PAT & CYN MCL4UGHLIN 895 W'18TH AVE 11/10/2014 570.98 BANKRUPTCY 1012-675000.00 GLORIA LENTZ 546 W 7TH AVE 9/102014 209.33 BANKRUPTCY '1015-040000.01 LISA WALTHER 655 W SOUTH PARKAVE 1/5/2015 68.16 BANKRUPTCY 1022-095000.01 JOE CORRALES 651 W BTH AVE 5/'12/2014 372.59 BANKRUPTCY 7023-660000.02 2323EASTCAPITALLLC �5185KOELLERST 11/19/20'14 2.978ANKRUPTCV 1032-275000.03 VANESSA FARMER 421 W 15TH AVE SI30/20t4 205.52 BANKRUPTCV 1034340000.07 MATTHEW WALTERS 1550 DELAWARE ST 12/162014 tt22 BANKRUPTCY 2056-130000.00 THOMAS SPANBAUER 125fi WISCONSIN ST 10/7/20�4 3.99 BANKRUPTCV 2064E60000.01 AMYANOERSON-0EDOW 416 W NEW YORKAVE 9/92014 2546 BANKRUPTCY 2065-725000.01 STEVE MARKECH 1326 CENTR4L ST 6/10/2014 �2.30 BANKRUPTCY 3084-170000.08 ANGELA KOHNKE 112 BROAD ST 32�/2014 351.07 BANKRUPTCY 3085-830000.04 SALVADOR RU2 902 EVANS ST 3/62014 4.86 BANKRUPTCY 3089-030000.03 JEFFMANKE 302HUDSONAVE 5212014 96.24BANKRUPTCY 3099845000.02 JAMESGWINN 4115TERLINGAVE 5/30/2014 323.43BANKRUPTCY 3104-020'100.02 LOUISE BROCK t951 S OAKWOOD RD 4/21Y2015 91.71 BANKRUPTCY 3126-000400.02 KEITH POILNOW 3100 WHITE TAIL LN A 11/5/20'14 71.55 BANKRUPTCY ,765.12 Sewer Delinquent Accounts to be Written off as of December 31, 2015 - D Account Name Atltlress Data Amount Reason 1004-485000.00 STEVE THORNTON 4'18 W 19TH AVE 7/14/2014 3.13 BANKRUPTCY 1004-485000.02 STEVE THORNTON 418 W 19TH AVE 7/14/2014 246.61 BANKRUPTCY 1006-290000.04 CINDY MARTINEZ 2505 OREGON ST 7/29/2014 833.00 BANKRUPTCY 1008-125000.01 MINDYSUETURMSKE 1629ARIZONAST 5/12/2014 155.38BANKRUPTCY 1008-525000.01 PATRICIA HAVERTV 312 W 18TH AVE 7/16/2014 42377 BANKRUPTCY 1008-915000A1 PATBCYNMCLAUGHLIN 895W�8THAVE 11/10I2014 484.i6BANKRUPTCV 10'12-675000.00 GLORIALENTZ 546W7THAVE 9/10/2014 177.91 BANKRUPTCV 1015-040000A'I LISA WALTHER 655 W SOUTH PARKAVE 1/5/2015 52.04 BANKRUPTCY 1022-095000.Ot JOE CORRALES 65'I W 8TH AVE 5/12/2014 335.94 BANKRUPTCY 1023-660000A2 2323 EAST CAPITAL LLC i5t8 S KOELLER ST i V'19/2014 2.56 BANKRUPTCV '1032-275000.03 VANESSAFARMER 421W'ISTHAVE 5/30/20�4 178.78BANKRUPTCY '1034340000.07 MATTHEW WALTERS 1550 DELAWARE ST 12/t6/20'14 10.88 BANKRUPTCY 2056-130000.00 THOMAS SPANBAUER 1256 WISCONSIN ST 10/7/2014 3.42 BANKRUPTCY 2064-660000.01 AMY ANDERSON-DEDOW 416 W NEW YORKAVE 9/9I2014 5t41 BANKRUPTCY 2065-725000.01 STEVE MARKECH t326 CENTRAL ST 6/10/2014 9.58 BANKRUPTCV 3084-170000.08 ANGELA KOHNKE 112 BROAD ST 321/2014 310.81 BANKRUPTCV 3085-830000.04 SALVADOR RU2 902 EVANS ST 3/6/2014 4.72 BANKRUPTCY 3089-030000.03 JEFF MANKE 302 HUDSON AVE 5l21/2014 89.90 BANKftUPTCY 3099-645000.02 JAMESGWINN 411STERLINGAVE 5/30/20�4 287.68BANKRUPTCV 31 04-020 7 00A2 LOUISE BROCK 1951 S OAKWOOD RD 4/21/2015 84.17 BANKRUPTCY 3126-000400.02 KEITH POLLNOW 3IDO WHITE TAIL LN A 1 VS/2014 55.86 BANKRUPTCY 3,801.11 Storm Water Delinquent Accounts to be Written off as of December 31, 2015 - E Account Name Address Date Amount Reason '1004-485000.00 STEVE THORNTON 418 W 19TH AVE 7/14/2014 0.97 BANKRUPTCV 1004-085000.02 STEVE THORNTON 418 W 19TH AVE 7/14/2014 121.14 BANKRUPTCY 1006-290000.00 CINDY MARTINEZ 2505 OREGON ST 7/29/2014 823.68 BANKRUPTCY 1008-125000.01 MINDYSUETURINSKE 1629ARIZONAST 5/12/2014 34.31 BANKRUPTCY 1008525000.01 PATRICIA HAVERTV 312 W 18TH AVE 7/162014 119.67 BANKRUPTCY 1008-915000.01 PAT & CVN MCLAUGHLIN 895 W 18TH AVE 11/10Y1014 17523 BANKRUPTCY 1012-675000.00 GLORIA LENTZ 546 W 7TH AVE 9l102014 128.87 BANKRUPTCY 1015-040000.01 LISA WALTHER 655 W SOUTH PARK AVE VS/2015 6070 BANKRUPTCY 1022-095000.01 JOE CORRALES 651 W STH AVE 5/12/2014 54.09 BANKRUPTCY 1032-275000.03 VANESSA FARMER 421 W iSTH AVE 5/30/2014 93.47 BANKRUPTCY 1034340000.07 MATTHEW WALTERS 1550 DELAWARE ST 12/i6/2014 0.66 BANKRUPTCY 2056-130000.00 THOMAS SPANBAUER 1256 WISCONSW ST 10l7/2014 1.76 BANKRUPTCY 2064-660000.01 AMYANDERSON-DEDOW 416 W NEW YORK AVE 9/9/2014 36.47 BANKRUPTCY 2065-725000.01 STEVE MARKECH 1326CENTRALST 6/102014 8.10 BANKRUPTCV 3084-170000.08 ANGELA KOHNKE 112 BROAD ST 3/21/2014 56.56 BANKRUPTCY 3085-630000.04 SALVADOR RUIZ 902 EVANS ST 3/62014 1.06 BANKRUPTCV 3089-030000.03 JEFF MANKE 302 HUDSON AVE 5212014 35.81 BANKRUPTCY 3099-645000.02 JAMESGWINN 411STERLINGAVE 5/30/2014 108.34BANKRUPTCY 3104-420100.02 LOUISE BROCK 1951 S OAKWOOD RD 4/21/2015 55.93 BANKRUPTCY 3126-000400.02 KEITH POLLNOW 3100 WHITE TAIL LN A 11/5/2014 37.37 BANKRUPTCY 1,953.59