Finance, Taxes and Insurance

1 VILLAGE OF WATERFORD FINANCE COMMITTEE Monday March 8th, 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: 11.09.20 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: 3/3/2021; 4:00 PM  2 1 Village of Waterford 2 Finance Committee Meeting Minutes 3 November 9th, 2020 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, Troy McReynolds 8 9 Also present: Zeke Jackson, Colleen Schauer, Michelle Vandehey 10 11 Minutes: Houston motioned to approve the 10-22-2020 minutes. Second by McReynolds. Motion 12 carried. 13 14 Financials: Administrator Jackson gave an overview of the 2021 Budget, including the Village Levy and 15 2020 tax rates. Discussion was had on Library Operations, Capital, Water and Sewer and rates. 16 Motion by Houston to recommend on to the Village Board the proposed Sewer rates. Second by 17 McReynolds. All aye. Motion carried. 18 19 Closed session: Motion by Lauer to adjourn into closed session at 5:49 pm. Second by Jaskie. Roll call 20 vote: Jaskie – aye; Ewert – aye; Lauer – aye, Houston – aye, McReynolds - aye. Motion carried. 21 22 Motion by Jaskie to reconvene into open session at 6:20 pm. Second by Lauer. All aye. Motion carried. 23 24 Motion by Lauer to recommend onto the board the items discussed in closed session regarding 25 personnel. Second by Jaskie. All aye. Motion carried. 26 27 Motion by Lauer to adjourn at 6:24 pm. Second by Jaskie. All aye. Motion carried. 28 29 Respectfully submitted by 30 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 March 3, 2021 Treasurer’s Report Currently working on: Reconciliation of 2020 & 2021 items Included in the packet: YTD reports by Fund Utilities Aging Summary & A/R detail Jan Ambulance Billing – LifeQuest Revenue Reports (not available yet) Jan American Deposit Funds Statement Feb Associated Bank Investment Funds Statement Feb Associated Bank Collateral Statement (not available yet) Expenses by Vendor Summary for February 2021 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 Village Of Waterford Income and Expenditures January 2021 All Phases Charges Billing Collection Total Billing Charges / Collection Placements $35,759.40 $0.00 $35,759.40 Other + $0.00 $0.00 $0.00 Subtotal of Charges $35,759.40 $0.00 $35,759.40 Account Transfers $0.00 $0.00 $0.00 Credit Summary Total Credits $49,490.42 $0.00 $49,490.42 Less Adjustments - $29,544.36 $0.00 $29,544.36 Less Delinquent Closed Accounts Reconciliation - $0.00 $0.00 $0.00 Less Overpayments - $(219.64) $0.00 $(219.64) Gross Payments Received $20,165.70 $0.00 $20,165.70 Plus Overpayment Returns + $(219.64) $0.00 $(219.64) Net Payments Received $19,946.06 $0.00 $19,946.06 Less Payments Kept By Service - $133.44 $0.00 $133.44 Total Deposits Reconciliation $19,812.62 $0.00 $19,812.62 Summary of Disbursement Total Deposits & Payments Kept By $19,946.06 $0.00 $19,946.06 Plus Overpayment Refunds + $0.00 $0.00 $0.00 Gross Revenue $19,946.06 $0.00 $19,946.06 LifeQuest Fee $1,595.68 $0.00 $1,595.68 Plus Probate Fees + $0.00 $0.00 $0.00 Other / Fees - - $0.00 Total Due LifeQuest Check # EFT $1,595.68 $0.00 $1,595.68 Service Revenue $18,350.38 $0.00 $18,350.38 Less Payments Kept By Service - $133.44 $0.00 $133.44 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,216.94 $0.00 $18,216.94 Messages: Total Deposits EOM differ from bank statement by $42.37 due to 12/30 $76.34 Molina now posted and 1/25 $118.71 Aetna not posted eli 2.1.2021 This Report May Contain Confidential Information or Protected Health Information. 2/1/2021 Please Handle Accordingly. Page 1 of 2 (888) 777-4911 275.1.2021.M001  12 Village Of Waterford Billing Summary January 2021 Phase 1 Charges Billing Charges $35,759.40 Other + $0.00 Subtotal of Charges $35,759.40 Account Transfers Billing to Collections Transfer Total $0 Credit Summary Total Credits $49,490.42 Less Adjustments - $29,544.36 Less Overpayments - $(219.64) Gross Payments Received $20,165.70 Plus Overpayment Returns - $(219.64) Net Payments Received $19,946.06 Less Payments Kept By Service - $133.44 Total Deposits Reconciliation $19,812.62 Summary of Disbursement Total Deposits & Payments Kept By $19,946.06 Plus Overpayment Refunds + $0.00 Gross Revenue $19,946.06 LifeQuest Fee $1,595.68 Plus Probate Fees + $0.00 Total Due LifeQuest Check # EFT $1,595.68 Service Revenue $18,350.38 Less Payment Kept By Service - $133.44 Less Service Payable - $0.00 Less Probate Fees - $0.00 Other / Fees - $0.00 Total Due Service Check # EFT $18,216.94 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. 2/1/2021 Please Handle Accordingly. Page 2 of 2 (888) 777-4911 275.1.2021.M001  13                                                                                                                                         14                                                                                    Village of Waterford Aging Report 15 R001 Filters: Aging Profile: Standard Aging, Billing Group: All Accounts, Aging Date: 02/28/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 55,673.89 63,354.70 0.00 -4,877.18 114,151.41 -610.35 3,075.46 68,034.95 -1,360.89 45,012.24 Suspended 201.35 -199.08 0.00 0.00 2.27 0.00 2.21 277.08 0.00 -277.02 Inactive 1,477.87 1,561.81 0.00 -243.02 2,796.66 295.32 -85.27 931.27 184.69 1,470.65 Pending 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 0.00 Total 57,353.11 64,717.43 0.00 -5,120.20 116,950.34 -315.03 2,992.40 69,243.30 -1,176.20 46,205.87 Printed 03/03/2021 08:58:34 am 1/1 Powered by TCPDF (www.tcpdf.org) 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