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