Loading...
HomeMy WebLinkAbout10. 13-189 APRIL 23, 2013 13-189 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" ($4,039.47) 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 remaining ambulance balance of the 2009 accounts, with funds for this purpose appropriated from Account No. 100-0908-6469- 00000, Tax Refund & Bad Debt ($392,721.05). 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 ($2,855.28). 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,432.79), Acct. No. 551-1950-6469-00000 ($3,797.16), and Acct. No. 561-2050-6469-00000 ($985.55). OUTSTANDING CHECK LISTING AS OF DECEMBER 2011 FOR PAYROLL AND PAYABLES- A ASSOCIATED PAYABLES ACCOUNT ACCOUNTS PAYABLE OUTSTANDING CHECKS, FOR 2011, AS OF DECEMBER, 2012 Check # Issue Date Payable to Amount Department 163400 1121111 WI DEPT OF NAT. RESOURCES $ 100.00 SANITATION ANNUAL FEE 163611 214111 BRANDON DIDDENS 7.45 TAX OVERPAYMENT REFUND 164975 4121111 NEW TITLE SERVICES 58.42 WATER FINAL BILL REFUND 166618 7115111 INTERNATIONAL GROUP 171.50 TAX OVERPAYMENT REFUND 167900 9122111 CARTERS RETAIL 75.00 HEALTH FEE OVERPAYMENT 167921 9122111 JACKIE HARRINGTON 10.00 WATER FINAL BILL REFUND 168159 1016111 JEFFREY BLANCK 374.14 WATER FINAL BILL REFUND 168191 1016111 KIMBERLY HEMBROOK 18.60 WATER FINAL BILL REFUND 169285 1212111 DEAN MACHOLL 2.00 PARKING TICKET REFUND 169296 1212111 BRENDA OCONNOR 10.00 PARKING TICKET REFUND 169312 1212111 JOHN SHEA 3.00 PARKING TICKET REFUND 169337 1212111 TERRA WILDERMAN 10.00 PARKING TICKET REFUND 169644 12/22/11 KEVIN BENNER 17.66 MILEAGE REIMBURSEMENT 169715 12/22/11 OSHKOSH CHAMBER 1,350.00 TRAINING REGISTRATION' 169817 12/30/11 BRANDON DELROW 3.00 PARKING TICKET REFUND 169821 12/30/11 LEAH DIEDRICH 2.00 PARKING TICKET REFUND 169829 12/30/11 JUNLIANG FAN 10.00 PARKING TICKET REFUND 169837 12/30/11 MICHAEL GALLIGAN 10.00 PARKING TICKET REFUND 169845 12/30/11 SANDRA GUTIERREZ 71.90 WATER FINAL BILL REFUND 169846 12/30/11 CLAYTON HACKNEY 18.00 PARKING TICKET REFUND 169885 12/30/11 LINDA MAAS 5.00 PARKING TICKET REFUND 169898 12/30/11 DUSTIN MITCHEM 10.00 PARKING TICKET REFUND 169911 12/30/11 ANDY PAMPERIN 10.00 PARKING TICKET REFUND 169926 12/30/11 THOMAS SALZER 3.00 PARKING TICKET REFUND 169934 12/30/11 KLYE SCHROEDER 2.00 PARKING TICKET REFUND 169944 12/30/11 MATTHEW SPANBAUER 2.00 PARKING TICKET REFUND 169992 12/30/11 MELINDA SUE ZEITLER 10.00 PARKING TICKET REFUND Subtotal - Payables $ 2,364.67 ASSOCIATED PAYROLL ACCOUNT PAYROLL ACCOU OUTS TANDING CHECKS, FOR 2011, AS OF DECEMBER 2012 Check # Issue Date Payable to Amount Department 128257 03/29/11 SUSANNE ZINTH $ 98.59 HEALTH 128633 05/10/11 KATHY KUBSATA 28.88 POLL WORKER 128707 05/10/11 ADAM VAN DAALWYK 1,435.72 FIRE 128729 05/10/11 BERKLEE MARKOFSKI 7.31 PARKS 130661 09/27/11 TODD MATTES 15.57 GOLF 130684 09/27/11 REBECCA PRATT 68.68 LIBRARY 130790 10/11/11 JOSEPH TROUT 20.05 GOLF Subtotal - Payroll $1,674.80 2012 Check Cancellations $ 4,039.47 2011 Accounts Receivable to be written off as of December 31, 2012 - B Invoice Invoice Balance Date to Number Date Name Description Department Due Coll Agency Comments 19644 01/06/11 R C Rucker Jr Repair Fire Hydrant 1810 296.80 1012412011 No activity 20000 03/17/11 Sirf Team -ITS Ambulance records 0240 16.47 N1A No response 20041 03/25/11 Mauro Martinez Repair Sign 0810 146.75 7/20/2011 No activity 20038 03/25/11 Justin Watson Repair Sign 810 801.28 7/20/2011 No activity 20112 04/11/11 Sandra & William Zwicky Water Testing 0310 20.00 NIA No proof of payment 20747 06/28/11 Sabrina Litscher Dolan Repair Traffic Signal 0801 561.67 2/6/2012 No activity 20750 06/28/11 Jesse Martinez Repair Traffic Signal 0801 796.33 2/6/2012 No activity 21127 08/11/11 Denise Golder Repair Fire Hydrant 1810 155.98 2/6/2012 No activity 21527 09/27/11 Country Water Works Water Testing 0310 60.00 6/18/2012 No activity 4P Z,t;55.ZU AR WRITEOFF 2012 3/25/2013 Water Delinquent Accounts to be Written off as of December 31, 2012 - C Account 1010 - 155000.01 1010- 160000.01 1010 - 160000.02 1010- 165000.01 1010- 540000.00 1014 - 055000.00 Name BOEDER & STEPHAN LLC BOEDER & STEPHAN LLC 1130EDER & STEPHAN LLC BOEDER & STEPHAN LLC FIDDLERS KAYE ALDERSON RENNERT RUBEN BORGARDT JR A ddress Date Amount $410.49 Reason BANKRUPTCY 910 OREGON ST 05/20/11 912 OREGON ST 05/20/11 $ 0.67 BANKRUPTCY BANKRUPTCY 912 OREGON ST 05/20/11 $177.11 912 OREGON ST 05/20/11 $30.25 BANKRUPTCY 1601 OREGON ST 431 W 11TH AVE 1104 MINNESOTA ST 1104 MINNESOTA ST 1104 MINNESOTA ST 923 W 5TH AVE 1225 DEVONSHIRE DR 1 016 S SAWYER ST 1855 GEORGIA ST 1740 DELAWARE ST 1461 PHEASANT CREEK DR E1210 HEIDI HAVEN DR 11003 ADAMS AVE 1009 W BENT AVE 1009 W BENT AVE A _ 2070 MITCHELL ST 05/04/11 11/ 0 05/04/11 05/20/11 $5.76 $26.39 $223.85 $15.26 BANKRUPTCY BANKRUPTCY 1015- 590000.02 BANKRUPTCY 1015- 590000.03 1015 - 590000.04 1019- 605000.01 1023-940000.01 1024 - 74 5000.01 1033 - 705000 00 1034- 495000.01 1119- 632450.00 - 1121- 036400.01 2043-470000.03 2047 - 210000.01 2047_210000.02 2 052-651200 .02 RUBEN B J BANKRUPTCY RUBEN BORGARD JR 07/2 $84.78 BANKRUPTCY ANN ROBERTS KATIE HASSLER M ARTIN/JUDITH HARTMAN 05/04/11 $2 01.52 BANKRUPTCY 05/04/11 03/18/11 $191.04 $61.41 BANKRUPTCY BANKRUPTCY MICHAEL D SOHM (PAUL W ZIMDARS (JACK SCHUMACHER DAVID KASPER CARRIE SCRAY SHERYL A ROSSOW SHERYL A ROSSOW _ f ROY SCH [JEREMY LOFTON IREBECCATYSON (LISA BURDICK CHAD KO 10/17/11 12/06/11 05/20/11 04105/111 1 10/17/11 06/06/11 I 06/06/111 I 05120/111 06/14/11 06/08/10 03/01/11 __12 1 0/17/ 11 $70.67 BANKRUPTCY $9_5. - $22 .52 $59.17 BANKRUPTCY BANKRUPTCY BANKRUPTCY I - $381.18 $5 $8.21 $45.09 $295.19 $4.78 BANKRUPTCY BANKRUPTCY BANKRUPTCY BANKRUPTCY JBANKR 2059-6 2064- 140000.02 3072- 8 3077-035000.04 627 FREDERICK ST 110 HOB BS AVE 613 OTTER AVE 831 WINNEBAGO AVE 217 MERRITT AVE BANKRUPTCY $152.65 $52. $1013 BANKRUPTCY BANKRUPTCY 3078-530000.01 CHRIST MACK BANKRUPTCY 3079- 960000.01 _:..- _:_... 3081- 405000.00 3087.280000.00 3087- 720000.00 3090 - 620000.02 3092- 735000.00 3097- 380000.00 2055- 725000.02 2051- 550000.02 1001- 245000. IMINDY NASI .- .:.-- _.�: ._.. IDARREL- KORTBEIN MARK WHITTY JR TANA VANDENBERG (HEATHER KANGAS RALPH ALFONSO KEVIN OTTO ROBERT SPANBAUER KEVIN GOG_O_L TERRANCE PAFFENROTH ID -- - - I RO B-- N SON 1 041 JEF FERSON ST _.._..... _._ 1023 HURON AVE 447 BOWEN ST 817 BOWEN ST 233 DALE AVE 1220 MONROE ST 1412 LAWNDALE ST 1626 ONTARIO ST 1919 P LYMOUTH ST_ _ 1403 S MAIN ST _ . 323 W 8TH AVE 05/04/11 09/02/11 01/05/11 09/ 02/11 $29.44 -- s- $51.69 $507.77 BANKRUPTCY BANKRUPTCY BANKRUPTCY $60.55 BANKRUPTCY $387.01 BANKRUPTCY 01/05/11 12/2 0/11 12/08/11 $5.49 BANKRUPTCY $11.21 BANKRUPTCY $39.42 BANKRUPTCY 0 4/04/11 $285.65 BANKRUPTCY 08/16/10 10/20/11 $45.59 $232.24 BANKRUPTCY 1012 - 780000.02 1 DAV BANKRUPTCY $4,432.7 Sewer Delinquent Accounts to be Written off as of December 31, 2012 •- D Account Name Address Date Amo Reason 1010- 155000.01 1010- 160000.01 1010- 160000.02 1010- 165000.01 1010 - 540000.00 1014 - 055000.00 1015- 590000.02 1015- 59000 1015- 590000. BOEDER & STEP LLC 910 OREGON ST 05/20/11 05/20/11 05120/111 05/20/111 05/04/11 11 /09/11 $327.23 $0.58 $149.48 $22.98 _ $ 6.49 $20.56 $124.50 $4.54 $59.55 $150.33 $_2_54.84 $48.72 $54.92 $_73.95 $19.59 $46.79 I _ $4 34.90 I $49.61 BANKRUPTCY BOEDER & STEPHAN LLC 912 OREGON ST BANKRUPTCY BOEDER & S TEPHA N LLC 912 OREGON ST BANKRUPTCY BOEDER & STEPHAN LLC [FIDDLERS _ W _ IKAYE ALD R ENNERT I RUBEN BORGARDT JR RUBEN BORGARDT JR RUBEN BORG JR ANN ROBERTS KATIE HAS_SLER MARTIN /JUDITH H ARTMAN 912 OREGON ST BANKRUPTCY 1601 OREGON ST BANKRUPTCY 431 W 11TH AVE BANKRUPTCY 1104 MINNESOTA ST _ 05/04/11 05/20/11 07/25/11 05/04/11 05/04 BANKRUPTCY 1104 MINNESOTA ST BANKRUPTCY 1104 MINNESOTA ST BANKRUPTCY 1019 - 605000.01 1023 94 1024 745000.01 1033- 705000.00 1034 - 495000.01 1119-632450.00 1121-036400.01 2043- 470000 2 047- 210 000.01 2047- 2 2052- 651200.02 205 670000.04 923 W 5TH AVE BANKRUPTCY 1225_ DEV ONSHIRE DR 1016 S SAWYER ST BANKRUPTCY 03/18/11 BANKRUPTCY MICH D SOHM PAUL W ZIMDARS JACK SCHUMACHER DAVID KASPER CARRIE SCRAY SHERYL A ROSSOW SHERYL A ROSSOW ROY SCHROEDER JEREMY LOFTON REBECCA TYSON LISA BURDICK C HA D KOLODZIK CHRISTOPHER MACK MILADY NASI DARREL KORTBEIN MARK WHITTY JR TANA VANDENBERG - HEAT KANGAS RALPH ALF T ERRANCE PAFFENROTH [1855 GEORGIA ST 11740 DELAWARE ST 10/17/11 BANKRUPTCY 12/06/11 BANKRUPTCY [1_4 PHEASANT CREE 05/ 20/11 04/05111 10/17/11 06/06/11 06/06/11 05/20/11 06/14/11 06/08110 03/01/11 12 BANKRUPTCY 1210 HEID1 HAVEN DR BANKRU 11003 ADAMS AVE _ BANKRUPTCY 1009 W BENT AVE B 1009 W BENT AVE A $32.98 BANKRUP 2070 MITCHELL ST $36.23 BANKRUPTCY 627 FREDERICK ST $235.82 BANKRUPTCY 2064- 14 0000.02 3072- 865000.00 3077 - 035000.04 3078 - 53 0000.0 1 3 079- 9 60000.01 3081 - 405000.00 308 308 720000.00 3090- 620000.02 3092- 735000.00 1001.245000.01 _ 3097 - 380000.00 2055- 725000.02 2051- 550000.02 1012- 780000.02 1105 HOBBS AVE 613 OTTER AVE $3.77 BANKRUPTCY $138.81 BANKRUPTCY 831 WINNEBAGO AVE $37.72 BANKRUPTCY 217 MERRITT AVE _ _ 10/17/11 05/04/11 06/14/11 0_9102111 01/05/11 09/02/ $78.58 B ANKRUPTCY B KRUPT_C_Y 1041 JEFFERSON ST $23.41 1023 HURON AVE $42.08 BANK 447 BOWEN S 817 BOWEN ST $429.41 $47.85 BANKRUPTCY BA _ 2 33 DALE AVE $368.62 BANKRUPTCY 11220 MONROE ST 0110 08/16/10 12/20/11 12/08/11 04/04/11 10/20/11 $4.30 B A NKR U P TCY 11403 S MAIN ST 1412 LAWNDALE ST _ $34.07 $8.69 $28.54 $233.25 $163.471 BANKRUPTCY KEVI OTTO BANKRUPTCY ROBERT SPA NBAUER 1626 ONTARIO ST 1 PLYMOUTH ST BANKRUPTCY [KEVIN GOGOLEWSKI BANKRUPTCY DAVIS ROBINSON 3 23 W 8TH AVE BANKRUPTCY $3,797.16 Storm Water Delinquent Accounts to be Written off as of December 31, 2012 - E Account Name BOEDER & STEPHAN LLC FIDDLERS Address 1010 - 155000.01 1010 - 54000_0 1014 - 055000.00 1015- 590000.02 101 5- 59 0000.03 1015- 590 000.04 1019 - 60 5000.01 1023- 94000 1 024- 745000 1033- 705000.00 1034 - 495000.01 1119 - 632450.00 1121- 0364 1500 - 003310.00 2043- 47000 2047- 210000.01 204 - 210000. 2052-651200.02 2059-6 70000.04 2064 - 1 4_0000.02 3072 865000.00 3077 - 035000.04 3078 - 530006.01 _ 910 OREGON ST 1601 OR EGON ST _ _ KAYE ALDERSON REN NERT 431 W 11TH AVE 1104 MINNESOTA ST 1104 MINNESOT ST RUBEN BORGARDT JR R UBEN BORGARDT JR RU BORGARDT JR 1104 MINNESOTA ST 923 W 5TH AVE 1225 DEVONSHIR DF JANN ROBERTS (KATIE HASSLER MARTINIJUDITH HARTMAN 1016 S SAWYER ST 1855 GEORGIA ST 1 740 DELAWARE S MIC HAEL D SOHM PAUL W ZIMDARS JACK SCHUMA DAVID KASPER PRAST PROPERTIES LLC CARRIE SCRAY SHERYL A ROSSOW S HERYL A ROSSOW / ROY SCHRO JER EMY LOFTON REB ECCA TYSON 1461 PHEASANT CREI 1210 HEIDI HAVEN DR 922 OREGON ST 1 003 ADAMS AVE 1009 W BENT AVE 1 009 W BENT AVE A 2070 MITCHELL ST 627 FRED ST 1105 H OBBS AVE 1613 O TTER AVE LISA BURDICK CHAD KOL ODZIK 1831 CHRISTOP MACK /2 MINDY NASI DA RREL KORTBEIN W INNEBAGO AVE MERRITT AVE 3079- 9 60000.01 1041 JEFFERSON ST 3 081- 40500 3 087.28000 0.00 30 87 - 720000. 1023 H URON AVE BOW ST �- MA RK WHITTY JR /447 TANA_ VANDENBERG 817 BOWE ST 233 DALE AVE 1220 MO NROE ST 1412 LAWN ST _ 3 - 6200 _00.02 3 092- 735000 3097 - 380000.0 HEAT KANGAS RAL ALFONSO 4 KEVIN OTTO 2055 72500 0.02 ROBERT SPANBAUER 1626 ONTARIO ST 2051- 55 0000.02 K EVIN GOGOLEWSK 1919 P LYMOUTH ST - I- - -- L_.. __ 1012 - 780000.02 DAVID ROBINSON 323 W 8TH AVE 0_9/_02111 $77.98 BA N K RUPTCY _ 01 $17.63 BANKR 09/02/11 $77.43 BAN KRUPTCY _ 01/05111 $1.56 BAN KRUPTCY 12 /20/11 $3.70 BAN KR U PTCY 12/08/11 $26.2 BANKRUP 0 4 / 04/11 $21.62 _BA NKRUPTCY 10/20/11 $24.83 BANKRUPTCY $985 .55 Date 05/20/11 05/04/11 Amount `Reason $67.96 $1.89 BANKRUPTCY BANKRUPTC 11/09/11 0 05/20/11 $5 .76 $ 51.97 $1.59 $15.11 $64.58 $9_8.26 $! 184 BANKRUPTC BANKRU BANKRUPT 07/25/11 BANKRUPTCY 05/04 05/0411 BANKRUP BANKRUPTCY 03/18/11 BANKRUPTCY 10/17/11 12/06/11 05/20/11 $16.50 $ B BAN KRUPTCY .K _ $4.77 $11.44 Y $ 18.64 BANKRUPTCY 04/05/11 _ 01/21/11 BA NKRUPTCY BANKRUPTCY 10/17/11 06/06/11 06/06/11 05/20/11 06/14/11 06/08 $67.53 $_41.30 � $9.82 $17.9 $53.7 $0.69 BA NKRUPTCY _BA NKRUPTCY BA NKRUPTCY BA NKRUPTCY BANKR BANK RUPTCY - Y 03/01/11 12/06/11 1 0117/11 05/04/11 06/14/11 $65.81_ BA NKRUPTCY - $35.30 $25.451 $6.85 BANKRUPTCY BA NKRUPTCY BA NKRUPTCY $16.271 BANKRUPTCY 0_9/_02111 $77.98 BA N K RUPTCY _ 01 $17.63 BANKR 09/02/11 $77.43 BAN KRUPTCY _ 01/05111 $1.56 BAN KRUPTCY 12 /20/11 $3.70 BAN KR U PTCY 12/08/11 $26.2 BANKRUP 0 4 / 04/11 $21.62 _BA NKRUPTCY 10/20/11 $24.83 BANKRUPTCY $985 .55 City of Oshkosh Finance Department 215 Church Ave., PO Box 1130 Oshkosh, WI 01HKOlH (920) 236-5006 54903-1130 36- 006 (920) 236 -5039 FAX ON IHE WATER MEMORANDUM TO: Honorable Mayor and Members of the Common Council FROM: Peggy Steeno, Finance Director DATE: April 23, 2013 RE: Cancel Outstanding Checks 1 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 2013 is to cancel checks that were issued in 2011, o Adjust our accounting records to reflect the likelihood that we may not collect past due receivables (various purposes, with the main one being ambulance billing), 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 $4,039.47 of combined accounts payable and payroll checks. Please note that it is very possible 1 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, I will attempt to make contact with those payees with outstanding check amounts greater than $100, as these are the ones that likely would not have gotten held up in the federal banking system. Also, if, at any time in the future, any of the checks are presented for payment, the City will certainly honor them. Ambulance Billing Write -Offs — This recommendation includes $392,721.05 of receivables from 2009. It is the City's policy to adjust our accounting records to reflect the likelihood that the 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. Please note that a detailed listing is not included due to HIPAA regulations. Delinquent Invoice Write -O 's - This recommendation includes $2,855.28 of receivables from 2011. 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. Bankruptcy Write -O, ff's - This recommendation includes $9,215.50 receivables from 2011. 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 legally collectible; therefore need to be written off. FISCAL IMPACT The `Cancel Outstanding Checks' item increases the City's cash position, while the `Bankruptcy Write - Offs' item reduces the cash position of each of the respective utilities. However, the `Ambulance Billing Write -Offs' item and the `Delinquent Invoice Write -Offs' item do not change operations. Rather, these two items 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, 1 'qqy- Y Peggy Steeno Finance Director i Z d: ��- Mark Rohloff City Manager