Finance, Taxes and Insurance

1 VILLAGE OF WATERFORD FINANCE COMMITTEE Monday September 15th, 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: 07.12.21 New Business 1. Review and discussion of the YTD financials and investment statements. 2. Review of Sections of the 2022 Draft Budget: Special Funds, Special Fund Detail, Pavement Management Plan, Debt Service (with subordinate amortization schedules), Curb Appeal, Conservation and Development, Hotel Room Tax, Flex Plan, Riverside Docks. Consider a motion to recommend approval to the Village Board as a part of the 2022 Budget Adoption Process. 3. Review of the 2020 Audited Financial 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: 9/10/2021; 11:30 PM  2 1 Village of Waterford 2 Finance Committee Meeting Minutes 3 April 12th, 2021 4 Held via Teleconference and at Village Hall 5 6 Houston called the meeting to order at 5:05 pm. 7 Present Andrew Ewert, Don Houston, Troy McReynolds, Adam Jaskie 8 Absent: Brian Lauer 9 10 Also present: Michelle Vandehey, Colleen Schauer, Zeke Jackson, Heather Kinkade, Danielle Brown 11 12 Minutes: Ewert motioned to approve the 4-12-2021 minutes. Second by Houston. Motion carried. 13 14 Rate Study: Discussion was had on the Sewer Rate Study done by Johnson Block. Ewert motion to table 15 discussion on the sewer rates until the next Finance Committee meeting. Second by McReynolds. 16 Houston - nay. Motion carried. 17 18 Financials: Administrator Jackson gave an over view of the financial status of the Village as a whole and 19 reviewed YTD Financials. 20 21 Motion by McReynolds to adjourn at 5:42 pm. Second by Ewert. All aye. Motion carried. 22 23 Respectfully submitted by 24 Colleen Schauer, PIO Village of Waterford | 123 North River Street | Waterford WI 53185 | 262.534.3980  3 VILLAGE OF WATERFORD TREASURER’S REPORT For additional information, visit www.waterfordwi.org September 9, 2021 Treasurer’s Report The 2020 audit is final and attached. The software conversion to Caselle has changed and will now take place in February 2022. Currently working on: Team Care Audit 2022 Budget Included in the packet: 2020 Audit YTD reports by Fund Utilities Aging Summary August Ambulance Billing – LifeQuest Revenue Reports & Number of Runs August Associated Bank Investment Funds Statement August Associated Bank Collateral Statement July American Deposit Management Statement August Expenses by Vendor Summary Budget Sheets: Fund 400 Debt Service Debt Master Schedule and corresponding amortization schedules and Pavement Management Plan Fund 100 – Conservation and Development Fund 205 Special Funds – Capital and Special Funds Capital Detail Fund 223 Hotel Room Tax Fund 229 Curb Appeal Fund 224 Flex Plan Fund 233 Riverside Docks Set up future meeting dates for budget review. Humbly Submitted, Michelle Vandehey Village Treasurer Village of Waterford | 123 North River Street | Waterford WI 53185 | 262.534.3980 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 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 12:52 PM Village of Waterford 89 09/07/21 Expenses by Vendor Summary Accrual Basis August 2021 Aug 21 ABACUS ARCHITECTS, INC. 10,750.00 AFFORDABLE LIBRARY PRODUCTS 750.00 Airbnb.com -82.53 ALL-PRO MECHANICAL 3,723.75 ALLESEE DEVELOPMENT 1,500.00 AMERICAN POWER EQUIPMENT 34.95 ASPHALT CONTRACTORS, INC. 3,804.00 AURORA HEALTH CARE 382.00 BAKER & TAYLOR 45.54 BATTERIES PLUS LLC 191.07 BAXTER & WOODMAN 83,076.68 BONNIES DRESSER 72.00 BRODART CO 4,053.45 BURLINGTON WATER/WASTEWATER 120.00 CANON FINANCIAL SERVICES 515.42 CAVENDISH SQUARE 674.54 CDW GOVERNMENT, INC 5,218.96 CENTRAL RACINE CTY HEALTH DEPT 21,789.00 CENTRAL STATES FUNDS 62,108.86 CHICO'S, LLC 187.12 CINTAS CORPORATION 967.28 CINTAS CORPORATION #447 135.81 CIVIC SYSTEMS LLC 750.00 COMPLETE OFFICE OF WI 103.97 CONNIE LELIVELT 40.00 CORE & MAIN 20,995.86 DANIEL ACE 268.77 DAVY LABORATORIES 387.00 DESIGN BUILD FIRE PROTECTION 48,445.00 DIVERSIFIED BENEFIT SERVICES 97.55 ELAN- CORPORATE PAYMENT 18,793.87 EMERGENCY MEDICAL PRODUCTS 2,196.88 ems customer 373.01 EXPLORE WATERFORD 570.00 FAIRYTALE BIRTHDAY COMPANY LLC 115.00 FICK, JULIE 45.02 FISH WINDOW CLEANING 300.00 FOXWOOD ISLE HOMEOWNERS ASSN 32.40 GALE/CENGAGE LEARNING 271.12 GATEWAY TECHNICAL COLLEGE 400.00 GEE FUNNY FARM 400.00 GUITARS FOR VETS 300.00 HARBOR HEIGHTS -14,987.59 HAWKINS, INC. 1,325.32 HOT LINE GUIDES 45.00 HUMPHREY SERVICE PARTS, INC 455.79 HYDRO CORP 693.00 JACKSON, MATTHEW (v) 6.00 JEFFERSON FIRE & SAFETY 331.98 Jennifer Pankowski 177.60 JOHNS DISPOSAL SERVICE, INC 27,611.30 JOHNSON BLOCK AND COMPANY, INC 17,850.00 Johnson Controls Fire Protection LP 358.35 KETTERHAGEN MEMORIALS 225.00 KRAUS ENTERPRISES 80.00 LAKELAND BIOLOGISTS 1,993.52 LAKESHORES LIBRARY SYSTEM 150.65 LAUX, KATIE (v) 25.00 LEAH GILBERT 150.00 LINK COMPUTER CORPORATION 1,640.00 MAU & ASSOCIATES 9,200.00 MAXIMUM SECURITY SYSTEMS LLC 89.95 MEAD & HUNT 30,527.53 MENARDS 449.60 MICHELAU TREE SERVICE LLC 1,600.00 MIKE SPONHOLTZ 1,364.24 MILWAUKEE AREA TECHNICAL COLLEGE 894.50 MINUTEMAN PRESS 546.59 MUELLER, AMY 255.00 Page 1 12:52 PM Village of Waterford 90 09/07/21 Expenses by Vendor Summary Accrual Basis August 2021 Aug 21 MUNICIPAL LAW & LITIGATION GROUP, S.C. 10,107.50 NATIONAL HOSE TESTING SPECIALT 2,601.00 PATS SERVICES, INC 1,822.84 PENDELTON TURF SUPPLY INC 328.44 PITNEY BOWES GLOBAL FINANCIAL 150.00 POMP'S TIRE SERVICE, INC. 1,197.08 PRINCIPAL FINANCIAL GROUP 270.95 PRO ELECTRIC 9,930.00 PURE ARCHITECTURE STUDIO LLC 68,512.00 RACHEL JUERGENS 75.00 RACINE COUNTY ECONOMIC DEVELOPMENT CORP 5,150.00 RACINE COUNTY INFORMATION SYS 483.15 RACINE COUNTY SHERIFFS OFFICE 3,952.33 RACINE COUNTY TREASURER 401.52 RESERVOIR VIDEO 1,138.00 ROBERT E. LEE & ASSOCIATES, INC. 3,000.00 ROCHESTER AUTOMOTIVE REPAIR 16.09 RUEKERT/MIELKE 3,038.00 SAFEBUILT, LLC 16,154.84 SAFEWAY PEST MANAGEMENT 112.00 SOUTHERN LAKES NEWSPAPER - DPW 114.58 SOUTHERN LAKES NEWSPAPERS, LLC 151.06 STATE OF WISCONSIN DSPS -1,412.33 SUNBELT RENTALS, INC. 189.75 SYNCB/AMAZON 4,606.43 TDS TELECOM 4,477.25 TERRY & NUDO LLC 3,199.50 THE EXPEDITORS, INC. 3,000.00 TRADEMARK CLEANING LLC 1,100.00 TRILOGY CONSULTING, LLC 5,995.00 UNION GROVE AUTO PARTS 612.92 UNITED LABORATORIES 5,078.64 Vandehey, Michelle 33.38 VERIZON WIRELESS 564.00 VILLAGE OF WATERFORD 2,400.00 VILLAGE OF WATERFORD WATER/SEWER 1,080.12 W.S. DARLEY & CO. 504.43 WATER WELL SOLUTIONS 3,900.00 WATERFORD GRADED SCHOOL 4,683.12 WATERFORD OIL COMPANY 435.17 WATERFORD POLICE DEPARTMENT 0.00 WATERFORD UNION HIGH SCHOOL 2,531.29 Waukesha County Collections -2,250.65 WAUKESHA COUNTY TECH COLLEGE 2,012.25 WE ENERGIES 20,984.39 WELDERS SUPPLY CO 364.47 WESTERN RACINE COUNTY SEWERAG 128,530.50 WEX BANK 5,383.64 WILLKOMM EXCAVATING & GRADING INC 186,710.39 WIND LAKE AUTO PARTS 777.98 WISC-DOT TVRP UNIT -1,729.78 WISC DEPT OF TRANSPORTATION 92.72 WISCONSIN SUPREME COURT 40.00 woodfield condo Association -75.00 TOTAL 890,487.64 Page 2 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130  Village of Waterford Aging Report 131 R001 Filters: Aging Profile: Standard Aging, Billing Group: All Accounts, Aging Date: 08/31/2021 11:59 PM, Include: All Balances, Group By: Account Status, Sort By: Account Number, Customer Info (CSV Only): Owner, Report Type: Summary Aging Summary Account Status Water Sewer Other Overpayment Total Current 30 days 60 days 90 Days 120 days Active 81,272.15 113,163.27 40.00 -4,167.84 190,307.58 -386.59 5,028.65 86,354.52 0.00 99,311.00 Suspended 208.46 -199.08 0.00 0.00 9.38 0.00 4.83 317.51 0.00 -312.96 Inactive 3,390.65 4,283.92 0.00 -303.70 7,370.87 1,803.59 812.62 1,286.09 0.00 3,468.57 Pending 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 84,871.26 117,248.11 40.00 -4,471.54 197,687.83 1,417.00 5,846.10 87,958.12 0.00 102,466.61 Printed 09/07/2021 12:54:41 pm 1/1 Powered by TCPDF (www.tcpdf.org) 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166