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