The URL can be used to link to this page

Home My WebLink About15. 15-106 MARCH 10, 2015 15-106 RESOLUTION (CARRIED __7-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,949.45) 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 proper amounts to the appropriate accounts. 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, ($10,137.56). 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 these purposes appropriated from each Account Number as follows: Acct. No. 541-1890-6469-08903 ($4,204.58), Acct. No. 551-1950-6469-00000 ($3,694.63), and Acct. No. 561-2050-6469-00000 ($1,151.76). � City of Oshkosh � Finance Department 215 Church Ave.,PO Box 1130 Oshkosh,WI 54903-1130 O1HKOIH (920)236-5006 (920)236-5039 FAX ON THE WATER MEMORANDUM TO: Honorable Mayor and Members of the Common Council FROM: Trena Larson, Director of Finance DATE: March 10, 2015 RE: Cancel Outstanding Checks/Write-Off Delinquent& 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 the following: o Cancel outstanding accounts payable and payroll checks that were issued more than 1 year ago, and up to 2 years ago, i.e. the request in 2015 is to cancel checks that were issued in 2013, o Adjust our accounting records to reflect the likelihood that we may not collect past due receivables (various purposes), and o Write-off bankruptcies. ANALYSIS This is an annual process that is completed to maintain current and accurate records. The details for each section are as follows: Cancel Outstanding Checks—Per the detailed sheets, this recommendation includes $1,949.45 of combined accounts payable and payroll checks. Please note that it is very possible/likely that a substantial number of these checks have been cashed but did not make it back through the federal banking system to be charged against our accounts. However, written correspondence is made with those payees with outstanding check amounts greater than$100. Also, if at any time in the future any of the checks are presented for payment, the City will honor them. Delinquent Invoice Write-O�'s - This recommendation includes $10,137.56 of receivables from 2010 through 2014. It is the City's policy to adjust our accounting records to reflect the likelihood that these receivables may not be collectible. This is an accounting entry only and does not relinquish the obligor of the debt as collection efforts are still taking place on these accounts. Bankruptcv Write-O�f's - This recommendation includes $9,050.97 receivables from 2013. These are amounts that have been discharged through bankruptcy proceedings. Once the Utility is notified of the discharge by the courts, these amounts are no longer collectible; therefore need to be written off. FISCAL IMPACT The `Cancel Outstanding Checks'item increases the City's cash position, while the `Bankruptcy Write- Off's' item reduces the cash position of each of the respective utilities. However,the `Delinquent Invoice Write-Off's'item will not change the City's cash position. Rather, this will affect our financial statements in that they lower the accounts receivable amounts stated in those documents. RECOMMENDATION Staff recommends that Council authorize this resolution to execute these transactions as outlined. Respectfully Submitted, Approved: � i Nr '�°�� ,�� /��+�,d"' 1�^�9 �l` � �� LJ i C�L_�C�'Z Trena Larson Mark Rohloff Director of Finance City Manager OUTSTANDING CHECK LISTING AS OF DECEMBER 2013 FOR PAYROLL AND PAYABLES-A 'ASSOCIATED PAYABLES ACCOUNT 'ACCOUNTS PAYABLE OUTSTANDING CHECKS, FOR 2013 AS OF DECEMBER 2014 � i 'Check# ,Issue Date Payable to Amount Department 177447 1/18/2013 FIRST AMERICAN �', $ 4.52 TAX OVERPAYMENT REFUND '' 177462' 1/18/2013 HAZMAT IQ 300.00 ; OFD HAZMAT CHARTS ' 177625 1/25/2013 RHONDA HALLER 15.00 ' PARKING TICKET REFUND ' 177669 1/25/2013 TIFFANY PETERSON 10.00 PARKING TICKET REFUND ' 177957 2/8/2013 TIMMY PAGEL 3.00 PARKING TICKET REFUND ' 177969 2/8/2013 QUINTERO JOSE MARTIN RUIZ 3.00 iPARKING TICKET REFUND ' 177979�' 2/8/2013 CHRISTOPHER TOBEY 18.00 �PARKING TICKET REFUND ' 178566 3/15/2013 DAVID KRAUSE 59.28 ;WATER METER REFUND ' 178612 3/15/2013 !MELISSA SWAN 64.22 WATER METER REFUND 178645 3/22/2013 ,CHANDA ANDERSON 36.69 TAX OVERPAYMENT REFUND 179014 4/12/2013 �SAM BINDER I 12.00 PARKING TICKET REFUND 180081 5/31/2013 � JUSTIN MURPHY 3.00 PARKING TICKET REFUND ' 180097 5/31/2013 JULIE POLLNOW 10.00 i PARKING TICKET REFUND ' 181164 7/25/2013 LIBERTY UNIVERSITY 40.00 LIBRARY MATERIALS 181557 8/9/2013 PETER WESTORT 2.00 TAX OVERPAYMENT REFUND ' 181596 8/16/2013 ANTHONY COATS 3.00 PARKING TICKET REFUND ' 181597 8/16/2013 MARGARET COOPER 2.00 PARKING TICKET REFUND ' 181638 8/16/2013 KATHLEEN KELL 2.00 PARKING TICKET REFUND 181643 8/16/2013 CHIA KUE 10.00 PARKING TICKET REFUND ' 181672 8/16/2013 �MICHAEL MORGANO 3.00 PARKING TICKET REFUND ' 181673 8/16/2013 I KEVIN &SHANNON MRAZ 2.83 TAX OVERPAYMENT REFUND 181703 8/16/2013 !,JAMES REYNARD 10.00 PARKING TICKET REFUND ' 181708'' 8/16/2013 'CURT SCHMIDT ' 2.00 � PARKING TICKET REFUND ' 181716 i 8/16/2013 �'DONALS SKALSTAD 2.13 'i TAX OVERPAYMENT REFUND ' 181826 8/23/2013 �' OSHKOSH NORTH HIGH SCHOOL 10.00 ' PARK PERMIT OVERPAYMENT REFUND' ' 181951 8/30/2013 SILVIA GARCIA 15.00 PARKING TICKET REFUND 181971' I 8/30/2013 RICHARD JOHNSON 3.00 PARKING TICKET REFUND 182010 ! 8/30/2013 TIMOTHY PAYNE 10.00 ' PARKING TICKET REFUND 182018 ! 8/30/2013 STEVEN SAWE 10.00 PARKING TICKET REFUND I 182479 9/27/2013 �KELLI BOESE 2.00 PARKING TICKET REFUND ' 182482 9/27/2013 ',REBECCA BOWMAN 2.00 PARKING TICKET REFUND ' 182501, 9/27/2013 'DALE DEDERICH SR 10.00 PARKING TICKET REFUND ' 182509 9/27/2013 : DUSTIN DUGGAN 20.00 PARKING TICKET REFUND ' 182511 9/27/2013 ,CHRISTOPHER DUVALL 3.00 PARKING TICKET REFUND ' 182528 9/27/2013 � JESUS GARCIA-MURILLO 3.00 PARKING TICKET REFUND ': 182541 9/27/2013 DENISE HARRIS 11.00 PARKING TICKET REFUND ' 182563 9/27/2013 MACKENZIE KLOEHN ' 3.00 PARKING TICKET REFUND ' 182583 ! 9/27/2013 BRADLEY LLOYD 3.00 PARKING TICKET REFUND 182599 9/27/2013 ALYSSA MOLL 3.00 ' PARKING TICKET REFUND 182604 9/27/2013 BRENT MULHOLLAND II 10.00 '' PARKING TICKET REFUND 182626 9/27/2013 BRITTANY POLLEY � 2 00 PARKING TICKET REFUND _ OUTSTANDING CHECK LISTING AS OF DECEMBER 2013 FOR PAYROLL AND PAYABLES-A � � 182631 9/27/2013 STEPHANIE MARGARITA RAMIREZ 3.00 PARKING TICKET REFUND ' 182637 9/27/2013 MIKE SARAY 3.00 PARKING TICKET REFUND 182646 9/27/2013 iJESSE SIMMONS 18.00 PARKING TICKET REFUND '; 182656 9/27/2013 GARY STETSON 38.00 PARKING TICKET REFUND `, 182657 9/27/2013 MARTHA STOLLBERG 3.00 , PARKING TICKET REFUND ': 182861 � 10/11/2013 JONATHON HELZ 10.00 PARKING TICKET REFUND 182897 ' 10/11/2013 JOEL MINNIECHESKE 3.00 �PARKING TICKET REFUND ' 182905� 10/11/2013 NOURSE, KELLY L 18.00 PARKING TICKET REFUND ! 182916 10/11/2013 CLANCI PAYNE 2.00 PARKING TICKET REFUND ' 182935 j 10/11/2013 KIERA SIMPSON � 10.00 PARKING TICKET REFUND ' 182949' ' 10/11/2013 SAMANTHA STROSCHEIN 3.00 PARKING TICKET REFUND '. 182959 10/11/2013 GILBERT MANUEL VALENCIA 10.00 PARKING TICKET REFUND 183347 11/1/2013 ; MICHAEL POZORSKI 4.00 PARKING TICKET REFUND ' 183582 '� 11/15/2013 NEW TITLE SERVICES 93.40 WATER FINAL BILL REFUND 183603 ; 11/15/2013: SCHMITT TITLE 6.14 WATER FINAL BILL REFUND ' 184194 12/20/20131 LAUREN BUSCHKE 18.00 PARKING TICKET REFUND 184208 12/20/2013 ECOVA INC 557.49 i WATER BILL OVERPAYMENT REFUND ' 184238�, 12/20/2013' TAMARA JONES 6.00 iPARKING TICKET REFUND ! 184244 12/20/2013 SCOTT KOPSI 18.00 'PARKING TICKET REFUND ! 184253 12/20/2013 DANIEL LONGSINE 11.85 WATER FINAL BILL REFUND ' 184310 � 12/20/2013 BRIAN SLUSAREK(PLANNING) 11.87 MILEAGE REIMBURSEMENT ' Subtotal-Payables $ 1,585.42 � - 'ASSOCIATED PAYROLL ACCOUNT `PAYROLL ACCOUNT OUTSTANDING CHECKS, FOR 2013,AS OF DECEMBER 2014 ' I 'Check# Issue Date i Payable to Amount Department '602565 4/11/2013 'HANNAH MACKENZIE $ 3.35 PARKS 603064 6/6/2013 BAILEY WILLIAMS 160.16 LIBRARY '603795 ' 9/26/2013 TODD MATTES 34.29 GOLF COURSE !603864 10/10/2013 RONALD BERRY JR. 166.23 GOLF COURSE Subtotal-Payroll $ 364.03 I 2014 Check Cancellations $ 1,949.45 i Accounts Receivable to be written off as of December 31, 2014 - B Invoice Invoice Balance Date to Number Date Name Description Dept. Due Coll Agency Comments 18712 09/15/10 Anbar, Dan Differential Payment 1040 4,902.50 N/A Per Planning Director 20379 05/12/11 Anbar, Dan Differential Payment 1040 2,144.31 N/A Per Planning Director 25455 03/05/13 Robl Properties Parking lot rent 1717 280.00 10/18/2013 No activity 25481 03/05/13 Odehnal,Gary Traffic signal repair 0801 1,280.87 N/A Restitution Ordered 25459 03/06l13 Brueckner,April Misc Materials 1810 12.96 N/A No response 25608 04/08/13 Robl Properties Parking lot rent 1717 280.00 10/18/2013 No activity 25877 05/02l13 Robl Properties Parking lot rent 1717 280.00 10/18/2013 No activity 26273 06/05/13 Pask Marine,Jenny Chair setup/Leach Am 0610 50.00 11/5/2014 No activity 26277 06/11/13 Robl Properties Parking lot rent 1717 140.00 10/18/2013 No activity 26585 06/27/13 JR Van Genderen Farms Traffic signal repair 0801 606.48 1/16/2014 No activity 27665 09/24/13 Rhode,Amy Chair setup/Leach Am 0610 24.95 11/05/14 Collection Fee 27757 10/08/13 Averbeck&Hammer SC Ambulance Records 0240 30.37 N/A No response 27931 10/23/13 Carroll,Greg Misc Materials 1810 45.12 9/5/2014 No activity 29366 05/06/14 Edson,Joel NSF Fee 0073 25.00 N/A No response 28740 06/24/14 Saarinen-Barr, Kay Traffic signal repair 0801 35.00 N/A Administrative Fee $ 10,137.56 Water Delin uent Accounts to be Written off as of December 31, 2014 - C Account Name Address Date Amount Reason 1002-760000.01 CHRISTINA GILKES 44 W SOUTH PARK AVE 2/14/2013 80.25 BANKRUPTCY 1007-480000.03 JEROME MUEHLENBERG 166 W 17TH AVE 12/10/2013 154.31 BANKRUPTCY 1008-800000.01 RONALD &JENNIFER KENDALL 758 W 18TH AVE 4/26/2013 283.89 BANKRUPTCY 1014-496000.11 ROBERT& LORI WILLIAMS 1204 MICHIGAN ST 8/2/2013 111.36 BANKRUPTCY 1022-120000.02 CARRIE HUGHES 672 W 8TH AVE 12/10/2013 48.33 BANKRUPTCY 1029-296800.00 JOHN J UNGER 826 GRACELAND DR 11/18/2013 473.20 BANKRUPTCY 1033-195000.00 DEBORAH JOLIN 1733 MICHIGAN ST 4/26/2013 40.17 BANKRUPTCY 2043-175000.00 LOUISE PERCIVAL 934 PIERCE AVE 11/18/2013 571.87 BANKRUPTCY 2057-530000.02 TERA GIRDAUSKAS 762 VINE AVE 12/10/2013 163.54 BANKRUPTCY 2070-200000.00 CINDY HARRIS 1125 N MAIN ST 8/2/2013 126.10 BANKRUPTCY 3073-645000.05 ROBERT& LORI WILLIAMS 409 WAUGOO AVE 8/2/2013 98.31 BANKRUPTCY 3073-650000.15 ROBERT& LORI WILLIAMS 409 WAUGOO AVE A 8/2/2013 41.07 BANKRUPTCY 3078-300000.00 LESLIE JACOBSON 1213 HARNEYAVE 11/18/2013 476.15 BANKRUPTCY 3081-190000.02 JOHN HERBST 2113 HARRISON ST 7/8/2013 210.92 BANKRUPTCY 3082-815000.00 JEFF CYSIEWSKI 2351 MT VERNON ST 8/2/2013 565.29 BANKRUPTCY 3086-650000.01 JUDY KWASNY 532 BOYD ST 3/14/2013 358.18 BANKRUPTCY 3096-585000.04 PAUL GEST 1223 GROVE ST 10/17/2013 401.64 BANKRUPTCY $4,204.58 Sewer Delin uent Accounts to be Written off as of December 31, 2014 - D Account Name Address Date Amount Reason 1002-760000.01 CHRISTINA GILKES 44 W SOUTH PARK AVE 2/14/2013 67.90 BANKRUPTCY 1007-480000.03 JEROME MUEHLENBERG 166 W 17TH AVE 12/10/2013 132.91 BANKRUPTCY 1008-800000.01 RONALD 8�JENNIFER KENDAL 758 W 18TH AVE 4/26/2013 243.37 BANKRUPTCY 1014-496000.11 ROBERT&LORI WILLIAMS 1204 MICHIGAN ST 8/2/2013 95.78 BANKRUPTCY 1022-120000.02 CARRIE HUGHES 672 W 8TH AVE 12/10/2013 77.97 BANKRUPTCY 1029-296800.00 JOHN J UNGER 826 GRACELAND DR 11/18/2013 406.91 BANKRUPTCY 1033-195000.00 DEBORAH JOLIN 1733 MICHIGAN ST 4/26/2013 33.47 BANKRUPTCY 2043-175000.00 LOUISE PERCIVAL 934 PIERCE AVE 11/18/2013 492.78 BANKRUPTCY 2057-530000.02 TERA GIRDAUSKAS 762 VINE AVE 12/10/2013 202.71 BANKRUPTCY 2070-200000.00 CINDY HARRIS 1125 N MAIN ST 8/2/2013 102.84 BANKRUPTCY 3073-645000.05 ROBERT&LORI WILLIAMS 409 WAUGOO AVE 8/2/2013 78.13 BANKRUPTCY 3073-650000.15 ROBERT& LORI WILLIAMS 409 WAUGOO AVE A 8/2/2013 32.31 BANKRUPTCY 3078-300000.00 LESLIE JACOBSON 1213 HARNEY AVE 11/18/2013 402.34 BANKRUPTCY 3081-190000.02 JOHN HERBST 2113 HARRISON ST 7/8/2013 191.98 BANKRUPTCY 3082-815000.00 JEFF CYSIEWSKI 2351 MT VERNON ST 8/2/2013 485.07 BANKRUPTCY 3086-650000.01 JUDY KWASNY 532 BOYD ST 3/14/2013 306.10 BANKRUPTCY 3096-585000.04 PAUL GEST 1223 GROVE ST 10/17/2013 342.06 BANKRUPTCY $3,694.63 Storm Water Delin uent Accounts to be Written off as of December 31, 2014 - E Account Name Address Date Amount Reason 1002-760000.01 CHRISTINA GILKES 44 W SOUTH PARK AVE 2/14/2013 20.45 BANKRUPTCY 1007-480000.03 JEROME MUEHLENBERG 166 W 17TH AVE 12/10/2013 42.94 BANKRUPTCY 1008-800000.01 RONALD&JENNIFER KENDALL 758 W 18TH AVE 4/26/2013 65.04 BANKRUPTCY 1014-496000.11 ROBERT&LORI WILLIAMS 1204 MICHIGAN ST 8/2/2013 16.27 BANKRUPTCY 1022-120000.02 CARRIE HUGHES 672 W 8TH AVE 12/10/2013 43.76 BANKRUPTCY 1029-296800.00 JOHN J UNGER 826 GRACELAND DR 11/18/2013 118.13 BANKRUPTCY 1033-195000.00 DEBORAH JOLIN 1733 MICHIGAN ST 4/26/2013 24.32 BANKRUPTCY 2043-175000.00 LOUISE PERCIVAL 934 PIERCE AVE 11/18/2013 138.06 BANKRUPTCY 2057-530000.02 TERA GIRDAUSKAS 762 VINE AVE 12/10/2013 34.31 BANKRUPTCY 2070-200000.00 CINDY HARRIS 1125 N MAIN ST 8/2/2013 57.99 BANKRUPTCY 3073-645000.05 ROBERT&LORI WILLIAMS 409 WAUGOO AVE 8/2/2013 46.71 BANKRUPTCY 3073-650000.15 ROBERT&LORI WILLIAMS 409 WAUGOO AVE A 8/2/2013 23.47 BANKRUPTCY 3078-300000.00 LESLIE JACOBSON 1213 HARNEY AVE 11/18/2013 101.62 BANKRUPTCY 3081-190000.02 JOHN HERBST 2113 HARRISON ST 7/8/2013 76.44 BANKRUPTCY 3082-815000.00 JEFF CYSIEWSKI 2351 MT VERNON ST 8/2/2013 104.54 BANKRUPTCY 3086-650000.01 JUDY KWASNY 532 BOYD ST 3/14/2013 64.38 BANKRUPTCY 3096-585000.04 PAUL GEST 1223 GROVE ST 10/17/2013 105.76 BANKRUPTCY 3502-003190.00 ROBERT&LORI WILLIAMS 118 E IRVING AVE 8/2/2013 67.57 BANKRUPTCY $1,151.76