Finance, Taxes and Insurance

1 VILLAGE OF WATERFORD FINANCE COMMITTEE Monday April 12th, 2021 5:00 pm Village Hall, 123 N River Street *or attend via teleconference at https://www.gotomeet.me/VillageofWaterford Or call in at: 1-872-240-3212, access code: 562-426-325 1. Call to Order 2. Roll Call 3. Comments and Correspondence 4. Public Appearances 5. Reading and Approval of Min: 03.08.21 New Business 1. Review and discussion of the YTD financials and investment statements. Adjournment Public Notice Questions regarding the nature of the agenda items or more detail on the agenda items listed above scheduled to be considered by the governmental body listed above can be directed to Zeke Jackson, Village Administrator at 262-806-1750 or at zjackson@waterfordwi.org. It is possible that members of and possibly a quorum of members of other governmental bodies of the municipality may be in attendance at the above-stated meeting to gather information; no action will be taken by any governmental body at the above-stated meeting other than the governmental body specifically referred to above in this notice. Upon reasonable notice, a good faith effort will be made to accommodate the needs of disabled individuals through sign language interpreters or other auxiliary aid at no cost to the individual to participate in public meetings. Due to the difficulty in finding interpreters, requests should be made as far in advance as possible preferably a minimum of 48 hours. For additional information or to request this service, contact the Village Staff at 262-534-1851, or by writing to the Village Administrator at the Village Administration Building, 123 N. River St, Waterford WI, 53185 Copies of reports and other supporting documentation are available for review at the Village Administrator’s Office, Administration Building, 123 N. River St, Waterford WI 53185 during operating hours. (8 a.m. – 5 p.m. weekdays). Posted: 4/7/2021; 5:00 PM  2 1 Village of Waterford 2 Finance Committee Meeting Minutes 3 March 8th, 2021 4 Held via Teleconference and at Village Hall 5 6 Ewert called the meeting to order at 5:00 pm. 7 Present: Adam Jaskie, Andrew Ewert, Brian Lauer, Don Houston 8 Excused: Troy McReynolds 9 10 Also present: Zeke Jackson, Colleen Schauer, Michelle Vandehey, Rick Mueller, Danielle Brown 11 12 Minutes: Houston motioned to approve the 11-9-2020 minutes. Second by Jaskie. Motion carried. 13 14 Financials: Treasurer Vandehey spoke to the current YTD financials, as well as to current software and 15 IT updates. Administrator Jackson gave an over view of the financial status of the Village as a whole. 16 17 Motion by Lauer to adjourn at 5:42 pm. Second by Jaskie. All aye. Motion carried. 18 19 Respectfully submitted by 20 Colleen Schauer, PIO  3 April 7, 2021 Treasurer’s Report Currently working on: Preparation for 2020 Audit Team Care Audit Included in the packet: YTD reports by Fund Utilities Aging Summary & A/R detail March Ambulance Billing – LifeQuest Revenue Reports & Number of Runs March Associated Bank Investment Funds Statement March Associated Bank Collateral Statement February American Deposit Management Statement March Expenses by Vendor Summary Humbly Submitted, Michelle Vandehey Village Treasurer 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42  43 Collateral Confirmation VILLAGE OF WATERFORD ATTN: MICHELLE VANDEHEY 123 N RIVER STREET WATERFORD , WI 53185 Associated Bank N.A. has pledged the following securities as collateral for your accounts as of 03/31/2021. Asset Description Rate (%) Maturity Par Amount Market Value Number 3128LLZK5 FH 2B0746 2.69100 08/01/2042 12,500,000.00 2,532,043.77 38379KN79 GNR 2015-136 AF 2.35000 09/16/2043 440,000.00 208,684.80 3137FXHH4 FHR 5019 DA 2.00000 05/25/2041 5,500,000.00 4,660,814.24 38379KQK7 GNR 2015-71 A 1.75000 08/16/2044 550,000.00 61,370.12 38380CG64 GNR 2017-26 PA 2.50000 02/20/2041 14,000,000.00 946,081.69 Total Amounts: 32,990,000.00 8,408,994.62 Direct inquires to: Associated Bank, N.A. PO Box 19097 Green Bay WI 54307-9097 Telephone: (800) 270-2707 Page: 1  44                                                                                          45 Village Of Waterford Income and Expenditures March 2021 All Phases Charges Billing Collection Total Billing Charges / Collection Placements $49,582.00 $0.00 $49,582.00 Other + $0.00 $0.00 $0.00 Subtotal of Charges $49,582.00 $0.00 $49,582.00 Account Transfers $0.00 $0.00 $0.00 Credit Summary Total Credits $48,097.22 $0.00 $48,097.22 Less Adjustments - $28,042.96 $0.00 $28,042.96 Less Delinquent Closed Accounts Reconciliation - $0.00 $0.00 $0.00 Less Overpayments - $0.00 $0.00 $0.00 Gross Payments Received $20,054.26 $0.00 $20,054.26 Plus Overpayment Returns + $0.00 $0.00 $0.00 Net Payments Received $20,054.26 $0.00 $20,054.26 Less Payments Kept By Service - $0.00 $0.00 $0.00 Total Deposits Reconciliation $20,054.26 $0.00 $20,054.26 Summary of Disbursement Total Deposits & Payments Kept By $20,054.26 $0.00 $20,054.26 Plus Overpayment Refunds + $0.00 $0.00 $0.00 Gross Revenue $20,054.26 $0.00 $20,054.26 LifeQuest Fee $1,604.34 $0.00 $1,604.34 Plus Probate Fees + $0.00 $0.00 $0.00 Other / Fees - - $0.00 Total Due LifeQuest Check # EFT $1,604.34 $0.00 $1,604.34 Service Revenue $18,449.92 $0.00 $18,449.92 Less Payments Kept By Service - $0.00 $0.00 $0.00 Less Service Payable - $0.00 $0.00 $0.00 Less Probate Fees - $0.00 $0.00 $0.00 Other / Fees $0.00 $0.00 $0.00 Total Due Service Check # EFT $18,449.92 $0.00 $18,449.92 Messages: Total Deposits EOM differ from bank statement by $777.42 due to 4/1 $78.68 MAWI posted 3/31 and 3/4 $410.87 Aetna and 3/12 $445.23 NHIC not posted eli 4.2.2021 This Report May Contain Confidential Information or Protected Health Information. 4/2/2021 Please Handle Accordingly. Page 1 of 2 (888) 777-4911 275.3.2021.M001  46 Village Of Waterford Billing Summary March 2021 Phase 1 Charges Billing Charges $49,582.00 Other + $0.00 Subtotal of Charges $49,582.00 Account Transfers Billing to Collections Transfer Total $0 Credit Summary Total Credits $48,097.22 Less Adjustments - $28,042.96 Less Overpayments - $0.00 Gross Payments Received $20,054.26 Plus Overpayment Returns - $0.00 Net Payments Received $20,054.26 Less Payments Kept By Service - $0.00 Total Deposits Reconciliation $20,054.26 Summary of Disbursement Total Deposits & Payments Kept By $20,054.26 Plus Overpayment Refunds + $0.00 Gross Revenue $20,054.26 LifeQuest Fee $1,604.34 Plus Probate Fees + $0.00 Total Due LifeQuest Check # EFT $1,604.34 Service Revenue $18,449.92 Less Payment Kept By Service - $0.00 Less Service Payable - $0.00 Less Probate Fees - $0.00 Other / Fees - $0.00 Total Due Service Check # EFT $18,449.92 Messages: Legend: Charges - Other: Includes insurance interest, transaction fees, probate fees Credit Summary - Less Overpayments: Includes recoupments, refunds, returns, service payables Credit Summary - Plus Overpayment Returns: Includes NSF/bank returned type payments This Report May Contain Confidential Information or Protected Health Information. 4/2/2021 Please Handle Accordingly. Page 2 of 2 (888) 777-4911 275.3.2021.M001 47 48 49 50 51 1:51 PM Village of Waterford 52 04/07/21 Expenses by Vendor Summary Accrual Basis March 2021 Mar 21 ABACUS ARCHITECTS, INC. 14,000.00 ACROSS THE STREET PRODUCTIONS 1,050.00 ALL-PRO MECHANICAL 1,976.75 ALLESEE DEVELOPMENT 1,500.00 ARTISTIC PIANO SERVICE, LLC 377.50 ASSOCIATED BANK -111.27 ASSOCIATED TRUST COMPANY 16,800.00 AURORA HEALTH CARE 90.00 BAKER & TAYLOR 44.18 BAXTER & WOODMAN 22,206.00 BELLE CITY FIRE & SAFETY 75.95 BRODART CO 3,204.90 BURLINGTON WATER/WASTEWATER 80.00 CANON FINANCIAL SERVICES 422.29 CDW GOVERNMENT, INC 10,835.00 CENTRAL STATES FUNDS 54,146.19 CERTIFIED LABORATORIES 484.71 CINTAS CORPORATION 502.80 CINTAS CORPORATION #447 272.41 COMPLETE OFFICE OF WI 29.96 CONNIE LELIVELT 40.00 CONWAY SHIELD 615.56 CORE & MAIN 9,850.00 DIVERSIFIED BENEFIT SERVICES 95.51 DOCUMENT SALES & DISTRIBUTION 665.27 DONERITE JANITORIAL SERVICE 460.00 ELAN- CORPORATE PAYMENT 7,843.50 EMERGENCY MEDICAL PRODUCTS 94.15 FASTENAL COMPANY 216.90 FICK, JULIE 31.19 FISH WINDOW CLEANING 445.00 FOXWOOD ISLE HOMEOWNERS ASSN 32.40 FREEDOM MAILING SERVICES 1,140.36 GALE/CENGAGE LEARNING 3,626.01 GATEWAY TECHNICAL COLLEGE 1,213.55 GESTRA ENGINEERING, INC. 7,000.00 HARBOR HEIGHTS -14,987.59 HAWKINS, INC. 2,061.91 HUENING, RICHARD 73.25 HW WILSON COMPANY 378.00 INK SPOT OF SOUTHEAST WI -1,100.06 ISIMULATE 995.00 JACKSON, MATTHEW (v) 235.84 JEFFERSON FIRE & SAFETY 2,459.14 JOHNS DISPOSAL SERVICE, INC 26,888.52 JOHNSON BLOCK AND COMPANY, INC 4,300.00 Johnson Controls Fire Protection LP 620.00 LAKELAND BIOLOGISTS 670.29 LAKESHORES LIBRARY SYSTEM -195,401.20 LAUX, KATIE (v) 50.87 LINK COMPUTER CORPORATION 1,640.00 MEAD & HUNT 4,671.74 MENARDS 323.13 Mi-Tech -92.00 MILLER MOTOR SALES 255.27 MIT Rental, LLC 3,600.00 MONROE TRUCK EQUIPMENT INC 1,128.62 MUELLER, AMY 50.00 MUNICIPAL LAW & LITIGATION GROUP, S.C. 2,970.00 PATS SERVICES, INC 158.06 Paychex 241.74 PENDELTON TURF SUPPLY INC 867.30 PRINCIPAL FINANCIAL GROUP 257.85 PURE ARCHITECTURE STUDIO LLC 46,980.00 R & R INSURANCE SERVICES, INC 18,959.00 RACINE COUNTY CLERK 819.68 RACINE COUNTY CLERK OF COURTS 270.00 RACINE COUNTY ECONOMIC DEVELOPMENT CORP 5,150.00 RACINE COUNTY INFORMATION SYS 3,475.00 Page 1 1:51 PM Village of Waterford 53 04/07/21 Expenses by Vendor Summary Accrual Basis March 2021 Mar 21 RACINE COUNTY PUBLIC WORKS DEP 4,805.37 RACINE COUNTY SHERIFFS OFFICE 5,194.68 RELIANT FIRE APPARATUS, INC 644.72 SAFEBUILT, LLC 6,765.38 SAFEWAY PEST MANAGEMENT 112.00 Schauer Power Center 890.29 SHERWIN INDUSTRIES 128.70 SOUTHERN LAKES NEWSPAPERS, LLC 143.48 SRS ROOFING & SHEET METAL, INC 673.00 STATE OF WI - COURT FINES AND SURCHARGES 1,014.41 STATE OF WISCONSIN -28,584.94 STRYKER SALES CORP 2,536.80 SWANK MOTION PICTURES, INC. 2,100.00 TDS TELECOM 2,242.21 TERRY & NUDO LLC 3,146.10 THE EXPEDITORS, INC. 1,000.00 TRACTOR SUPPLY CREDIT PLAN 284.93 Ugly Guy Ugly Truck SnowPlowing 280.00 UNITED LABORATORIES 3,818.80 VERIZON WIRELESS 571.55 VILLAGE OF WATERFORD 3,064.12 VILLAGE OF WATERFORD WATER/SEWER 2,480.49 WANASEK CORP 6,846.77 WATERFORD GRADED SCHOOL 4,683.12 WATERFORD OIL COMPANY 142.47 WATERFORD POLICE DEPARTMENT 65,097.52 WATERFORD UNION HIGH SCHOOL 2,531.29 Waukesha County Collections -3,018.55 WCMA 172.50 WE ENERGIES 19,926.92 WELDERS SUPPLY CO 565.22 WEX BANK 2,733.05 WIND LAKE AUTO PARTS 347.48 WISC DEPT OF TRANSPORTATION 120,247.18 WISCONSIN DEPT OF REVENUE 450.00 WISCONSIN RURAL WATER ASSOC 850.69 WORLD BOOK, INC. 499.00 TOTAL 315,712.88 Page 2 54