Finance, Taxes and Insurance

1 VILLAGE OF WATERFORD FINANCE COMMITTEE Monday, August 10th 2020, 5:00 pm Village Hall Park, 123 N River Street, Waterford, WI 53185 1. Call to Order 2. Roll Call 3. Comments and Correspondence 4. Public Appearances 5. Reading and Approval of Min: 07.13.2020 New Business 1. Review of the YTD Financials, Investment Statements, and Treasurer’s report; consider a motion for action. 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 920-421-4457 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-7912, 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: 08/5/20; 4:00 p.m.  2 1 Village of Waterford 2 Finance Committee Meeting Minutes - Approved 3 July 13th, 2020 4 *Held Via Teleconference* 5 6 Chair Ewert called the meeting to order at 5:15 pm. 7 Present: Adam Jaskie, Don Houston, Andrew Ewert 8 Absent: Brain Lauer, Troy McReynolds 9 10 Also present: Zeke Jackson, Colleen Schauer, Heather Kinkade, Chief Rick Mueller, Jim Bergles 11 12 Minutes: Ewert motioned to approve 6-08-2019. Second by Jaskie. Motion carried. 13 14 YTD Financials: Administrator Jackson gave an over view of the YTD Financials and the Treasurer’s 15 report. 16 17 Motion by Ewert to adjourn at 5:40 pm. Second by Jaskie. All aye. Motion carried. 18 19 Respectfully submitted by 20 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 August 10, 2020 Treasurer’s Report Items Completed: Reconciliation of Bank accounts 2020 Treasurer’s Institute Currently working on: Staff is continuing to work on the 2021 Budget Gathering information for the 2019 Audit when requested Continuing the process of the payroll software upgrade, online training, 1st live payroll to be August 26th Included in the packet: Resolution Designating Public Depositories and Signers YTD reports by Fund Utilities Aging Summary & A/R Detail Ambulance Billing – LifeQuest Revenue Reports June American Deposit Funds Statement July Associated Bank Investment Funds Statement (if available) Expenses by Vendor Summary Humbly Submitted, Michelle Vandehey Village Treasurer Village of Waterford | 123 North River Street | Waterford WI 53185 | 262.534.3980 4 5 6 7  8 Village Of Waterford Income and Expenditures June 2020 All Phases Charges Billing Collection Total Billing Charges / Collection Placements $25,279.40 $0.00 $25,279.40 Other + $0.00 $0.00 $0.00 Subtotal of Charges $25,279.40 $0.00 $25,279.40 Account Transfers $0.00 $0.00 $0.00 Credit Summary Total Credits $38,372.35 $0.00 $38,372.35 Less Adjustments - $22,125.71 $0.00 $22,125.71 Less Delinquent Closed Accounts Reconciliation - $0.00 $0.00 $0.00 Less Overpayments - $(677.55) $0.00 $(677.55) Gross Payments Received $16,924.19 $0.00 $16,924.19 Plus Overpayment Returns + $(45.00) $0.00 $(45.00) Net Payments Received $16,879.19 $0.00 $16,879.19 Less Payments Kept By Service - $0.00 $0.00 $0.00 Total Deposits Reconciliation $16,879.19 $0.00 $16,879.19 Summary of Disbursement Total Deposits & Payments Kept By $16,879.19 $0.00 $16,879.19 Plus Overpayment Refunds + $(632.55) $0.00 $(632.55) Gross Revenue $16,246.64 $0.00 $16,246.64 LifeQuest Fee $1,299.73 $0.00 $1,299.73 Plus Probate Fees + $0.00 $0.00 $0.00 Other / Fees - - $0.00 Total Due LifeQuest Check # EFT $1,299.73 $0.00 $1,299.73 Service Revenue $14,946.91 $0.00 $14,946.91 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 $14,946.91 $0.00 $14,946.91 This Report May Contain Confidential Information or Protected Health Information. 7/2/2020 Please Handle Accordingly. Page 1 of 2 (888) 777-4911 275.6.2020.M001  9 Village Of Waterford Billing Summary June 2020 Phase 1 Charges Billing Charges $25,279.40 Other + $0.00 Subtotal of Charges $25,279.40 Account Transfers Billing to Collections Transfer Total $0 Credit Summary Total Credits $38,372.35 Less Adjustments - $22,125.71 Less Overpayments - $(677.55) Gross Payments Received $16,924.19 Plus Overpayment Returns - $(45.00) Net Payments Received $16,879.19 Less Payments Kept By Service - $0.00 Total Deposits Reconciliation $16,879.19 Summary of Disbursement Total Deposits & Payments Kept By $16,879.19 Plus Overpayment Refunds + $(632.55) Gross Revenue $16,246.64 LifeQuest Fee $1,299.73 Plus Probate Fees + $0.00 Total Due LifeQuest Check # EFT $1,299.73 Service Revenue $14,946.91 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 $14,946.91 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. 7/2/2020 Please Handle Accordingly. Page 2 of 2 (888) 777-4911 275.6.2020.M001  10 All Phases Gross Revenue Village of Waterford January 2018 to June 2020 $32,000 $28,000 $24,000 $20,000 $16,000 $12,000 $8,000 $4,000 $0 Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec 2018 2019 2020 2019 2020 January $0 $18,105 February $0 $22,153 March $0 $28,020 April $0 $15,556 May $0 $19,035 June $0 $16,247 October $12,407 $0 November $18,464 $0 December $16,710 $0 Total Gross Revenue $47,580 $119,116 This Report May Contain Confidential Information or Protected Health Information. 7/1/2020 Please Handle Accordingly. Page 1 of 1 (888) 777-4911 275.6.2020.M003 11 12 13 14 15  16 Total Runs Entered Village of Waterford June 2019 to June 2020 These numbers are based on the Date Of Entry at LifeQuest Services of each individual run. 100 90 81 80 64 59 60 Number of Calls 55 44 41 42 40 33 31 20 5 0 Aug Sep Oct Nov Dec Jan Feb Mar Apr May Jun 2019 2019 2019 2019 2019 2020 2020 2020 2020 2020 2020 This Report May Contain Confidential Information or Protected Health Information. 7/1/2020 Please Handle Accordingly. Page 1 of 1 (888) 777-4911 275.6.2020.M105  Village of Waterford Aging Report R001 17 Filters: Aging Profile: Standard Aging, Billing Group: All Accounts, Aging Date: 07/31/2020 11:59 PM, Include: All Balances, Include Groups Older than or Equal To: 120 days, Group By: Account Status, 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 66,118.40 85,321.28 0.00 -205.94 151,233.74 0.00 50,277.25 0.00 0.00 100,956.49 Suspended 81.93 -199.08 0.00 0.00 -117.15 0.00 347.71 0.00 0.00 -464.86 Inactive 2,624.21 3,693.03 0.00 -3.29 6,313.95 0.00 0.00 0.00 154.44 6,159.51 Total 68,824.54 88,815.23 0.00 -209.23 157,430.54 0.00 50,624.96 0.00 154.44 106,651.14 Printed 08/03/2020 04:59:10 pm 1/1 Powered by TCPDF (www.tcpdf.org)  Village of Waterford Customer Statistical Report C017 18 Filters: Billing Group: All Accounts, From Date: 11/01/2019, To Date: 07/31/2020, Municipality: Village of Waterford, Past Due Days: 90 Address Type Reporting Group Total Customers Payments Customers Past Due Residential Overpayment 363 68040.51 70 Sewer 1926 583664.54 475 Water 2017 481673.03 475 Other 3 40.00 1 Commercial Overpayment 43 38501.21 10 Sewer 150 96285.03 32 Water 151 72993.96 32 Other 1 20.00 1 Industrial Overpayment 2 0.00 0 Sewer 13 16737.56 1 Water 13 12670.00 1 Public Overpayment 1 368.80 0 Sewer 20 34398.03 1 Water 20 28011.91 1 Multi Family Overpayment 7 121.14 0 Sewer 38 45223.55 1 Water 38 31235.56 1 Printed 08/04/2020 12:17:43 pm 1/1 Powered by TCPDF (www.tcpdf.org) 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