REVISED 9-11-2024 Board of Finance Regular Meeting Agenda & Backup Documents
agenda center agenda
| Board/Commission | Board of Finance |
|---|---|
| Meeting Date | September 11, 2024 |
| Pages | 81 |
| File Size | 4.2 MB |
| OCR Status | Searchable (OCR processed) |
| Source URL | Original |
Document Preview
Full Text (OCR Extracted)
1 | P a g e FIFTEEN ROPE FERRY ROAD WATERFORD, CT 06385-2886 BOARD OF FINANCE 2025-2026 BUDGET REQUEST GUIDELINES DATE: September, 2024 BUDGET REQUESTS NOT ADEQUATELY PRESENTED OR JUSTIFIED MAY BE RETURNED, REDUCED, OR SIMPLY NOT APPROVED. SECTION A: GENERAL INSTRUCTIONS All Town departments, boards, commissions and agencies are directed to use the following guidelines, attachments, and forms in the preparation of your Fiscal Year 2025-2026 budget. 1. Every budget line item should be justified and explained to the maximum extent possible. The amount requested should not be a percentage increase from the previous year’s expenditure. This includes detailed lists of all expenditures using, as a minimum, the previous 24 months’ values. For certain measurable items such as electricity, heat and gasoline, a minimum of 24 months of history should be disclosed to justify the volume of units used in calculating the need for FY2026. Please include the number of units being used to calculate your 2026 budget request. If anomalies exist causing the 24-month historical use to be inaccurate, do not use it; however, please include an explanation on how the proposed budgeted amount was calculated. When applicable and measurable, please report metrics which reflect the level of service being provided annually by your department, examples as per below. • Number of Personal Contacts (Rec & Park, Youth & Family, Seniors, Library) • Number and Type of Responses (Fire and Police) • Measures of Foot Traffic (Town Hall Offices) These are types of indicators which will help justify requested budgets and changes from year- to year. 2. Comparisons to prior year budgets should be based on what was appropriated by the RTM, (i.e. do not include mid-year appropriations). Be sure to identify any new cost items that have not appeared in earlier budgets. 3. To ensure purchase quality, provide consistency and to determine appropriate costs for each item, all budget requests for the purchase of any equipment or supplies MUST be reviewed by 2 | P a g e the Director of Finance or the Purchasing Agent in the Finance Director’s absence. When possible, similar equipment will be purchased for all departments to save costs for maintenance and supplies. All equipment must be budgeted under the equipment line and not under other lines (i.e. other supplies or maintenance of vehicles, etc.). 4. Provide a detailed breakdown of all service contracts and maintenance & repair costs. These shall be reviewed with the Director of Finance or Purchasing Agent to ascertain if cost savings can be achieved by servicing similar equipment from many departments under one bill with prorated costs. In addition, all such budget requests MUST be reviewed by either of these individuals to ensure all costs are consistent and appropriate. Maintenance and Service contracts related to IT and Software & Hardware will be budgeted within the Information Technology Budget. Please ensure your requests are forwarded the IT Manager to ensure they are included in the IT Budget Proposal. 5. Personnel budgets for each department are established based on the number and classification of employees disclosed at the budget hearings. Department heads must provide explanation for variance(s) between the annual personnel survey report provided by the Human Resources Director and the budgeted personnel count. Transfer of funds from one 51000 series line item to another for the purpose of creating additional positions or change of classification requires prior approval by the Personnel Review Board. Departments Heads must disclose the assignment of any costs associated with re-assignment of personnel outside of their normal work function. Please attach a detailed listing of positions under each category (i.e. administration). Finance will provide Department Heads with information for your personnel budgets (i.e. salary, fringe benefits, etc.); however, finance staff will work with Department Heads to calculate overtime and other hours for specific departments. As detailed in #9, if a position is to be funded through a grant, the budget request must include the name of the grant, amount of grant funds requested and the total cost of the position if the grant award is not received. 6. Provide a detailed listing of specific dues, conferences and other educational expenses and a rationale for this need. These costs must be disclosed within this classification and not included under Training. The Training Line Item must be restricted to mandated or required training only. • Provide a five-year history of mandatory training • Describe the changes year-to-year as the schedule requires 7. Accounts with a $1 budgeted will be zeroed out and removed. If funds are needed in a zeroed out account, a transfer request can be submitted with justification. 8. A certified audit report of all funds appropriated during the last completed fiscal year should be supplied by public health nurses, Ledge Light Health District, seCTer, library and social service agencies. Requests should also include a reporting of total Waterford residents serviced. 3 | P a g e 9. Any organization that receives funds from source(s) other than the Town or anticipates receiving funds from source(s) other than the Town is requested to disclose the source(s), amount received/anticipated and how those funds are or will be used. Any organization that receives funding from outside sources and does not disclose those sources is required to provide an explanation. For each source of funding please provide the amount received in the previous fiscal year, the amount received or expected in the current fiscal year and any amount expected in the next fiscal year, including grants. In addition, for grant funds, include the line item from which the funds were expended, as well as a projection of anticipated grant funds for the next fiscal year. • The Utility Commission must provide a copy of its Sewer Enterprise Fun’s current fiscal year operating budget and its projected operating budget for Fiscal Year 2025-2026. 10. Director of Fire Services is requested to provide a summary by line item for each company. Individual fire company allocations should be detailed in each fire services account line. A summary by account number for each fire company should be included at the end of the budget request. 11. The Youth and Family Services Bureau, Recreation and Park Department and the Senior Citizens Commission are expected to provide a summary of the past, current and projected size of each program and any revenue vs. cost information associated with fee based programs. Provide a 3-year history of all programs offered but were subsequently cancelled and provide the reason for the cancellation. 12. The Youth and Family Services Bureau, Recreation and Park Department and the Senior Citizens Commission shall provide a full accounting report for any grants, donations or special revenue received from sources other than the Town of Waterford for Fiscal Year 2023-2024 and current data on Fiscal Year 2024-2025. Said reports MUST be attached to the department Fiscal Year 2026 budget request. 4 | P a g e SECTION B - FINANCE DEPARTMENT INSTRUCTIONS 1. Review your schedule of fees charged, providing the rationale for those amounts. Please report your revenues on the Schedule of Revenue. This form should be used to report General Fund revenue only. 2. Personnel costs for general government employees covered by expired or expiring union contracts will be calculated at the rate in effect at the expiration of the current contract. For budget purposes, finance will use 261 workdays/52.2 weeks (Monday-Friday) for calculating payroll figures for fiscal year 2025-2026. 3. Calculate mileage reimbursement at 67.0 cents per mile (2024 IRS standard mileage rate). 4. Calculate unleaded gasoline as follows. *Rates will be distributed as soon as available. Currently negotiating FY26 pricing. Please use current rates of $2.7648 per gallon. 5. Calculate heating oil and diesel as follows: Ultra Low Sulfur Diesel Fuel; TBD per gallon (summer blend) Ultra Low Sulfur Diesel Fuel: TBD per gallon (winter blend) #2 Heating Oil TBD per gallon *Rates will be distributed as soon as available. Currently negotiating FY26 pricing. Please use current rates of $2.7648/gallon (heating oil) and $2.7392/gallon (diesel). 6. The Finance Office will provide all standard office supplies. (Only those supplies that are unique to your department needs and not available through the Finance Office should be reflected in your budget request.) A list of standard office supplies provided by the Finance Office can be found on the “T” Drive in the Purchasing Folder for your reference. Office furniture and equipment are not consumables and must be budgeted in department budgets. 7. The Finance Office will provide black and white printing unless your requirement is unusual. Check with the Purchasing Agent before budgeting for any printing. All color printing must be budgeted within your department’s operating budget at a rate of $.05 per page. 8. Include a brief functional statement of the duties and responsibilities of your agency and submit the budget summary worksheet for your department. This summary should include a list of any Connecticut statutes relating to the individual department. A budget format template (MsWord) and budget worksheet template (Excel) can be found on the “G” Drive/Budget 2025-2026. There are tabs along the bottom of the workbook for each department. All budgets and supporting documentation must be submitted on 8 ½ x 11 paper only. If that drive is not available to your office, please contact the Finance Office as soon as possible. Only these forms will be accepted. Please do not submit PDF files or forms. 5 | P a g e 9. Any amounts proposed to be expended for gifts associated with illness, retirement, special personnel events or achievements, etc. must be submitted to the First Selectman with justification for inclusion in the Board of Selectmen’s budget. Traditional employee performance awards and citations are permissible through departmental budgets but must be described in your budget justification. 10. Any department with employees covered under the GGA Contract or Non-Union Management Professionals whose sick time will exceed the maximum accrual allowed by the GGA Contract, must budget the value of the estimated overage under Fringe Benefits by individual calculated as follows: Current hourly rate of pay - (employee’s annual salary on their anniversary date divided by 2080 hours) times 50% of the numbers of hours over the maximum (175 days) if hired prior to July 1, 2006. This amount will be deposited into the employee’s HRA. 6 | P a g e SECTION C – ADDITIONAL BUDGET INSTRUCTIONS It is recognized that much work goes into the preparation of your budgets and your efforts and cooperation are acknowledged and appreciated. Budget request pages should be numbered and all graphs should be submitted in color. Please email your budget documents to Kim Allen, kallen@waterfordct.org no later than the close of business on December 13, 2024. Budgets should be emailed in their original format. PDF files will not be accepted. Budgets that require commission approval should include a copy of the meeting minutes that show the commission’s vote to approve the FY25 budget request. If you are unable to email your budget, please send two copies of your final budget to the Finance Office no later than close of business on December 14, 2024. Your budget must be single-sided, indexed, paginated and submitted without staples. You must be in attendance for your budget review session in accordance with the attached schedule. Glenn Patterson, Chairman Board of Finance Attachments: • Schedule of Revenues (general and special fund) • Budget Workbook – Department • Uniform Budget Forms • Personnel-Fringe Benefit Template (These documents are also available on the ‘G’ Drive/Budget 2025-2026) CLA (CliftonLarsonAllen LLP) is an independent network member of CLA Global. See CLAglobal.com/disclaimer. Investment advisory services are offered through CliftonLarsonAllen Wealth Advisors, LLC, an SEC‐registered investment advisor. CliftonLarsonAllen LLP 29 South Main Street, 4th Floor West Hartford, CT 06107 phone 860‐561‐4000 fax 860‐521‐9241 claconnect.com August 12, 2024 To the Board of Finance Town of Waterford, Connecticut We are engaged to audit the financial statements of the governmental activities, the business‐type activities each major fund, and the aggregate remaining fund information of the Town of Waterford, Connecticut as of and for the year ended June 30, 2024. Professional standards require that we communicate to you the following information related to our audit. We will contact you to schedule a meeting to discuss this information since a two‐way dialogue can provide valuable information for the audit process. Our responsibility under Auditing Standards Generally Accepted in the United States of America, Government Auditing Standards, and Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards and the Connecticut State Single Audit Act Financial statements, internal control, and compliance We will conduct our audit in accordance with auditing standards generally accepted in the United States of America (U.S. GAAS); the standards for financial audits contained in Government Auditing Standards, issued by the Comptroller General of the United States; audit requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance); and the Connecticut State Single Audit Act (State Single Audit). Those standards require us to be independent of the entity and to meet our other ethical responsibilities, in accordance with the relevant ethical requirements relating to our audit. Those standards also require that we exercise professional judgment and maintain professional skepticism throughout the planning and performance of the audit. As part of our audit, we will: Identify and assess the risks of material misstatement of the financial statements and material noncompliance, whether due to fraud or error, design and perform audit procedures responsive to those risks, and obtain audit evidence that is sufficient and appropriate to provide a basis for our opinions. The risk of not detecting a material misstatement or a material noncompliance resulting from fraud is higher than for one resulting from error, as fraud may involve collusion, forgery, intentional omissions, misrepresentations, or the override of internal control. Obtain an understanding of internal control relevant to the audit in order to design audit procedures that are appropriate in the circumstances, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal control. However, we will communicate to you in writing any significant deficiencies or material weaknesses in internal control relevant to the audit of the financial statements that we identify during the audit that are required to be communicated under U.S. GAAS and Government Auditing Standards. August 12, 2024 Town of Waterford, Connecticut Page 2 Evaluate the appropriateness of accounting policies used and the reasonableness of significant accounting estimates made by management, as well as evaluate the overall presentation of the financial statements, including the amounts and disclosures, and whether the financial statements represent the underlying transactions and events in a manner that achieves fair presentation. Conclude, based on the audit evidence obtained, whether there are conditions or events, considered in the aggregate, that raise substantial doubt about the entity’s ability to continue as a going concern for a reasonable period of time. Form and express opinions about whether the financial statements prepared by management with your oversight are fairly presented, in all material respects, in conformity with accounting principles generally accepted in the United States of America. Plan and perform the audit to obtain reasonable assurance about whether the financial statements as a whole are free from material misstatement. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an audit conducted in accordance with U.S. GAAS and the standards for financial audits contained in Government Auditing Standards will always detect a material misstatement when it exists. Misstatements, including omissions, can arise from fraud or error and are considered material if there is a substantial likelihood that, individually or in the aggregate, they would influence the judgment made by a reasonable user based on the financial statements. Perform, as part of obtaining reasonable assurance about whether the financial statements as a whole are free from material misstatement, tests of the entity’s compliance with provisions of laws, regulations, contracts, and grant agreements that have a material effect on the financial statements. However, the objective of our tests is not to provide an opinion on compliance with such provisions and we will not express such an opinion in our report on compliance issued pursuant to Government Auditing Standards. Provide a report (which does not include an opinion) on internal control over financial reporting and on compliance with the provisions of laws, regulations, contracts, and grant agreements, noncompliance with which could have a material effect on the financial statements, as required by Government Auditing Standards. Obtain an understanding of internal control over compliance relevant to the audit in order to design audit procedures that are appropriate in the circumstances and to test and report on internal control over compliance, but not for the purpose of expressing an opinion on the effectiveness of the entity's internal control over compliance. However, we will communicate to you in writing any significant deficiencies or material weaknesses in internal control over compliance that we identify during the audit that are required to be communicated. Plan and perform the audit to obtain reasonable assurance about whether material noncompliance with the applicable compliance requirements occurred. Reasonable assurance is a high level of assurance but is not absolute assurance and therefore is not a guarantee that an August 12, 2024 Town of Waterford, Connecticut Page 3 audit conducted in accordance with U.S. GAAS, Government Auditing Standards, the Uniform Guidance and the State Single Audit Act will always detect material noncompliance when it exists. Material noncompliance can arise from fraud or error and is considered material if there is a substantial likelihood that, individually or in the aggregate, it would influence the judgment made by a reasonable user of the report. Perform tests of controls over compliance to evaluate the effectiveness of the design and operation of controls that we consider relevant to preventing or detecting material noncompliance with the direct and material compliance requirements applicable to each major federal or state award program. However, our tests will be less in scope than would be necessary to render an opinion on those controls and, accordingly, no opinion will be expressed in our report on internal control issued pursuant to the Uniform Guidance and the State Single Audit. Consider internal control over compliance with requirements that could have a direct and material effect on a major federal or state program in order to determine our auditing procedures for the purpose of expressing our opinion on compliance and to test and report on internal control over compliance in accordance with the Uniform Guidance and the State Single Audit. Perform tests of transactions and other applicable procedures described in the “OMB Compliance Supplement” and the “Compliance Supplement to the State Single Audit” for the types of compliance requirements that could have a direct and material effect on each of the entity’s major programs. The purpose of these procedures will be to express an opinion on the entity’s compliance with requirements applicable to each of its major programs in our report on compliance issued pursuant to the Uniform Guidance and the State Single Audit. While our audit will provide a reasonable basis for our opinion, it will not provide a legal determination on the entity’s compliance with those requirements. Provide a report on internal control over compliance related to major programs and express an opinion (or disclaimer of opinion) on compliance with federal and state statutes, regulations, and the terms and conditions of federal or state awards that could have a direct and material effect on each major program in accordance with the Uniform Guidance and the State Single Audit. Communicate significant matters related to the financial statement audit that are, in our professional judgment, relevant to your responsibilities in overseeing the financial reporting process. However, we are not required to design procedures specifically to identify such matters. Communicate circumstances that affect the form and content of the auditors’ report. Our audit of the financial statements does not relieve you or management of your responsibilities. August 12, 2024 Town of Waterford, Connecticut Page 4 Supplementary information in relation to the financial statements as a whole Our responsibility for the schedule of expenditures of federal awards (SEFA) and the Schedule of Expenditures of State Financial Assistance (SESFA) accompanying the financial statements, as described by professional standards, is to evaluate the presentation of the SEFA and the SESFA in relation to the financial statements as a whole and to report on whether the SEFA and the SESFA are fairly stated, in all material respects, in relation to the financial statements as a whole. We will make certain inquiries of management and evaluate the form, content, and methods of preparing the SEFA and the SESFA to determine whether the SEFA and the SESFA complies with the requirements of the Uniform Guidance and the State Single Audit, respectively, the method of preparing the schedules has not changed from the prior period, and the SEFA and the SESFA is appropriate and complete in relation to our audit of the financial statements. We will compare and reconcile the SEFA and the SESFA to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. Because we were engaged to report on the supplementary information accompanying the financial statements, our responsibility for other supplementary information accompanying the financial statements, as described by professional standards, is to evaluate the presentation of the supplementary information in relation to the financial statements as a whole and to report on whether the supplementary information is fairly stated, in all material respects, in relation to the financial statements as a whole. We will make certain inquiries of management and evaluate the form, content, and methods of preparing the information to determine whether the information complies with accounting principles generally accepted in the United States of America, the method of preparing it has not changed from the prior period, and the information is appropriate and complete in relation to our audit of the financial statements. We will compare and reconcile the supplementary information to the underlying accounting records used to prepare the financial statements or to the financial statements themselves. Required supplementary information With respect to the required supplementary information (RSI) accompanying the financial statements, we will make certain inquiries of management about the methods of preparing the RSI, including whether the RSI has been measured and presented in accordance with prescribed guidelines, whether the methods of measurement and preparation have been changed from the prior period and the reasons for any such changes, and whether there were any significant assumptions or interpretations underlying the measurement or presentation of the RSI. We will compare the RSI for consistency with management’s responses to the foregoing inquiries, the basic financial statements, and other knowledge obtained during the audit of the basic financial statements. Because these limited procedures do not provide sufficient evidence, we will not express an opinion or provide any assurance on the RSI. Use of financial statements Our auditors’ opinions, the audited financial statements, and the notes to financial statements should only be used in their entirety. Inclusion of the audited financial statements in a document you prepare, such as an annual report, should be done only with our prior approval and review of the document. You are responsible to provide us the opportunity to review such documents before issuance. August 12, 2024 Town of Waterford, Connecticut Page 5 Other information included in annual reports It is our understanding that our auditors’ report will be included in your annual report which is comprised of the Annual Comprehensive Financial Report and that your annual report will be issued by December 31, 2024. Management is responsible for the preparation of other information included in your annual report and for providing such information to us in a timely manner, and if possible, prior to the date of our auditors’ report. Our responsibility for other information included in your annual report does not extend beyond the financial information identified in our opinions on the financial statements. We have no responsibility for determining whether such other information is properly stated and do not have an obligation to perform any procedures to corroborate other information contained in your annual report. We are required by professional standards to read the other information and consider whether a material inconsistency exists between the other information and the financial statements because the credibility of the financial statements and our auditors’ report thereon may be undermined by material inconsistencies between the audited financial statements and other information. If management refuses to correct a material misstatement of the other information, professional standards require us to communicate the matter to you. If, based on the work performed, we conclude that an uncorrected material misstatement of the other information exits, we are required to describe it in our report. Planned scope and timing of the audit An audit includes examining, on a test basis, evidence supporting the amounts and disclosures in the financial statements; therefore, our audit will involve judgment about the number of transactions to be examined and the areas to be tested. Our audit of the financial statements will include obtaining an understanding of the entity and its environment, including internal control, sufficient to assess the risks of material misstatement of the financial statements and to design the nature, timing, and extent of further audit procedures. Material misstatements may result from (1) errors, (2) fraudulent financial reporting, (3) misappropriation of assets, or (4) violations of laws or governmental regulations that are attributable to the entity or to acts by management or employees acting on behalf of the entity. We will generally communicate our significant findings at the conclusion of the audit. However, some matters may be communicated sooner, particularly if significant difficulties are encountered during the audit where assistance is needed to overcome the difficulties or if the difficulties may lead to a modified opinion. We will also communicate any internal control related matters that are required to be communicated under professional standards. Although our audit planning has not been concluded and modifications may be made, we have identified the following significant risk(s) of material misstatement as part of our audit planning: Management override of controls As a result of unexpected events, changes in conditions, or the audit evidence obtained from the results of audit procedures performed, we may need to modify the overall audit strategy and audit plan and, thereby, the resulting planned nature, timing, and extent of further audit procedures, based on the revised consideration of assessed risks. August 12, 2024 Town of Waterford, Connecticut Page 6 We expect to begin our audit on approximately June 26th, 2024 and issue our report on approximately December 31st 2024. Other planning matters Recognizing the importance of two‐way communication, we encourage you to provide us with information you consider relevant to the audit. This may include, but is not limited to, the following items: Your views about the following matters: o The appropriate person(s) in the entity's governance structure with whom we should communicate. o The allocation of responsibilities between those charged with governance and management. o The entity's objectives and strategies and the related business risks that may result in material misstatements. o Matters you believe warrant particular attention during the audit and any areas for which you request additional procedures to be undertaken. o Significant communications between the entity and regulators. o Other matters you believe are relevant to the audit of the financial statements. The attitudes, awareness, and actions of those charged with governance concerning (a) the entity's internal control and its importance in the entity, including how those charged with governance oversee the effectiveness of internal control, and (b) the detection or the possibility of fraud. The actions of those charged with governance in response to developments in law, accounting standards, corporate governance practices, and other related matters, and the effects of such developments on, for example, the overall presentation, structure, and content of the financial statements, including the following: o The relevance, reliability, comparability, and understandability of the information presented in the financial statements. o Whether all required information has been included in the financial statements, and whether such information has been appropriately classified, aggregated or disaggregated, and presented. The actions of those charged with governance in response to previous communications with the auditor. August 12, 2024 Town of Waterford, Connecticut Page 7 Your understanding of the risks of fraud and the controls in place to prevent and detect fraud, including your views on the following matters: o The “tone at the top” conveyed by management. o How and how often you review the entity’s policies on fraud prevention and detection. o If a fraud hotline is in place, how it is monitored and how you are notified of allegations or concerns. o How you exercise oversight of management’s processes for identifying and responding to the risks of fraud and the programs and controls management has established to mitigate those risks. o The risks of fraud at the entity, including any specific fraud risks the entity has identified or account balances, classes of transactions, or disclosures for which a risk of fraud may be likely to exist. o Examples of fraud‐related discussions management has had with you. o Any actual or suspected fraud affecting the entity or its federal or state award programs that you are aware of, including measures taken to address the fraud. o Any allegations of fraud or suspected fraud (e.g., received in communications from employees, former employees, grantors, regulators, or others) that you are aware of. o Any knowledge of possible or actual policy violations or abuses of broad programs and controls occurring during the period being audited or the subsequent period. o Any accounting policies or procedures applied to smooth earnings, meet debt covenants, minimize taxes, or achieve budget, bonus, or other financial targets that you are aware of; and whether you are aware of any accounting policies that you consider aggressive. How you oversee the entity’s (1) compliance with laws, regulations, and provisions of contracts and grant agreements, (2) policies relative to the prevention of noncompliance and illegal acts, and (3) use of directives (for example, a code of ethics) and periodic representations obtained from management‐level employees about compliance with laws, regulations, and provisions of contracts and grant agreements. Whether you are aware of any noncompliance with laws, regulations, contracts, and grant agreements, including measures taken to address the noncompliance. If the entity uses a service organization, your knowledge of any fraud, noncompliance, or uncorrected misstatements affecting the entity’s financial statements or federal or state award programs reported by the service organization or otherwise known to you. August 12, 2024 Town of Waterford, Connecticut Page 8 * * * This communication is intended solely for the information and use of the Board of Finance and management of Town of Waterford, Connecticut and is not intended to be, and should not be, used by anyone other than these specified parties. Sincerely, CliftonLarsonAllen LLP Vanessa E. Rossitto, CPA Vanessa E. Rossitto, CPA Principal 860‐561‐6824 Vanessa.Rossitto@CLAconnect.com Contributed Gifts Fund July 31, 2024 R&P R&P R&P R&P FINANCE POLICE POLICE POLICE POLICE POLICE POLICE R&P MEMORIAL FRANCES X. CIVIC DEIDRICK HELMET R&P TREES & SWEENEY R&P R&P TRIANGLE R&P FIELD PRESS R&P DEPT. DEPT. DEPT. DEPT. DEPT. PUBLIC RODEO GENERAL BENCHES MEMORIAL DOG PARK PLAYGROUND MEMORIAL TOY BOX BOX CEMETERY AUDITORIUM AUSTISM VEHICLE K-9 GENERAL PATCHES SAFETY FISCAL YEAR 2025 DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS DONATIONS A/V UPGRADE TRAINING CHALLENGE PROGRAM DONATIONS FUNDRAISER DOCK TOTAL REVENUES REC & PARKS PLAYGROUND DONATIONS $10,000.00 POLICE DEPT. GENERAL DONATIONS $651.59 TOTAL REVENUES $0.00 $0.00 $0.00 $0.00 $0.00 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $651.59 $0.00 $0.00 $10,651.59 EXPENDITURES 07/30/24 PO # 250235 LETS CORP $4,995.00 TOTAL EXPENDITURES $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $4,995.00 $0.00 $0.00 $4,995.00 NET CURRENT YEAR ACTIVITY $0.00 $0.00 $0.00 $0.00 $0.00 $10,000.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 ($4,343.41) $0.00 $0.00 $5,656.59 PRIOR YEAR BALANCE $594.72 $129.60 ($1,053.61) $65.00 $760.97 $60,486.32 $1,140.00 $220.00 $8,310.00 $100.00 $151.00 $1,700.00 $780.11 $4,424.54 $13,239.38 $0.00 $7.04 $91,055.07 CURRENT YEAR BALANCE $594.72 $129.60 ($1,053.61) $65.00 $760.97 $70,486.32 $1,140.00 $220.00 $8,310.00 $100.00 $151.00 $1,700.00 $780.11 $4,424.54 $8,895.97 $0.00 $7.04 $96,711.66 Page 1 of 1 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2024-2025, THROUGH JULY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 FISCAL YEAR 2025 FISCAL YEAR 2025 VARIANCE FISCAL YEAR FISCAL YEAR 2025 FISCAL YEAR 2025 PERCENT FAVORABLE 2023-2024 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL GENERAL GOVERNMENT Board of Selectmen $206,405 $12,214 5.92% 194,191 $11,882 Registrar of Voters $96,525 $7,763 8.04% 88,762 $5,070 Board of Finance $80,713 $77,037 95.45% 3,676 $65,089 Assessor $287,213 $17,745 6.18% 269,468 $16,460 Board of Assessment Appeals $1,742 $2 0.11% 1,740 $12 Tax Collector $232,331 $40,771 17.55% 191,560 $34,264 Finance Department $767,856 $153,695 20.02% 614,161 $150,743 Legal Department $295,000 ($454) -0.15% 295,454 ($735) Town Clerk $264,849 $39,426 14.89% 225,423 $12,703 Planning and Zoning $686,543 $43,394 6.32% 643,149 $42,213 Building Maintenance $895,824 $319,450 35.66% 576,374 $250,762 Insurance $4,962,182 $1,763,093 35.53% 3,199,089 $1,334,227 Economic Development Commission $25,267 $9,428 37.31% 15,839 $9,419 Conservation Commission $18,250 $1,219 6.68% 17,031 $1,203 Zoning Board of Appeals $4,310 2,960 68.68% 1,350 2,968 Retirement Commission $7,760,257 $1,989,602 25.64% 5,770,655 $1,996,015 R.T.M. $18,903 $12,852 67.99% 6,051 $12,852 Building Department $326,532 $19,394 5.94% 307,138 $18,649 Youth Service Bureau $294,579 $17,677 6.00% 276,902 $13,915 Social Service Grants/Miscellaneous $98,960 $89,759 90.70% 9,201 $125,214 Contingency Fund $265,000 0 0.00% 265,000 0 Emergency Management $1,196,762 $81,421 6.80% 1,115,341 $53,179 Fire Services $3,632,425 $1,103,401 30.38% 2,529,024 $966,598 Police Department $7,015,644 $469,522 6.69% 6,546,122 $417,174 Public Works Department $5,086,238 $1,648,954 32.42% 3,437,284 $1,249,724 Conservation of Health $148,407 0 0.00% 148,407 0 Public Health Nursing $26,297 26,297 100.00% 0 0 Senior Citizens Commission $481,248 27,166 5.64% 454,082 28,547 Waterford Public Library $1,006,837 $65,409 6.50% 941,428 $102,626 Page 1 of 2 GENERAL FUND STATEMENT OF EXPENDITURES COMPARED TO BUDGET FOR FISCAL YEAR 2024-2025, THROUGH JULY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 FISCAL YEAR 2025 FISCAL YEAR 2025 VARIANCE FISCAL YEAR FISCAL YEAR 2025 FISCAL YEAR 2025 PERCENT FAVORABLE 2023-2024 APPROPRIATED ACTUAL EXPENDED (UNFAVORABLE) ACTUAL Recreation and Parks $1,480,330 $187,797 12.69% 1,292,533 $179,637 Flood and Erosion Control Bd. $1,109 0 0.00% 1,109 0 Ethics Commission $900 65 7.27% 835 47 Human Resources $264,204 $95,664 36.21% 168,540 $88,228 Information Technology $1,231,423 $300,534 24.41% 930,889 $499,919 Transfer to Waterford Special Activity Fund $4,750 $4,750 100.00% 0 $4,750 Transfer to Waterford Shellfish Fund $1,290 $1,290 100.00% 0 $4,134 Transfer to Capital Improvement Fund $1,312,527 $1,312,527 100.00% 0 $2,402,902 Transfer to Capital & Non-Recurring Fund $938,399 $938,399 100.00% 0 $281,250 Transfer to Dog Fund $100,000 $100,000 100.00% 0 $100,000 Debt Service $8,109,746 $2,328,200 28.71% 5,781,546 $2,176,825 Total General Government $49,627,777 $13,308,424 26.82% $36,319,353 $12,658,466 Board of Education $57,611,181 $3,412,560 5.92% 54,198,621 $1,501,707 Total General Fund $107,238,958 $16,720,983 15.59% $90,517,975 $14,160,174 Page 2 of 2 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2024-2025, THROUGH JULY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2024-2025 YEAR YEAR 2024-2025 2024-2025 PERCENT 2024-2025 2023-2024 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL STATE OF CONNECTICUT EDUCATION EQUALIZED COST SHARING $326,444 $0 0.00% (326,444) $0 HEALTH & WELFARE $6,359 $0 0.00% (6,359) $0 SUB TOTAL 332,803 0 0.00% (332,803) 0 GENERAL GOVERNMENT PILOT-DISABLED 1,200 0 0.00% (1,200) $0 TIERED PILOT 347,575 0 0.00% (347,575) $0 TAX RELIEF-VETERANS 5,000 0 0.00% (5,000) $0 CIVIL PREPAREDNESS 23,000 0 0.00% (23,000) $0 TELECOMMUNICATIONS PROPERTY TAX 58,071 0 0.00% (58,071) $0 TOWN AID ROADS-IMPROVED 321,360 160,680 50.00% (160,680) $160,680 LOCAL CAPITAL IMPROVEMENT (LOCIP) 177,479 0 0.00% (177,479) $0 SDE STATE GRANT 14,000 0 0.00% (14,000) $0 ENHANCEMENT 911 22,500 5,649 25.11% (16,851) $5,646 MUNICIPAL REVENUE SHARE GRANT 315,978 0 0.00% (315,978) $0 GRANTS FOR MUNICIPAL PROJECTS 34,255 0 0.00% (34,255) $0 TOTAL GENERAL GOVERNMENT 1,320,418 166,329 12.60% (1,154,089) 166,326 TOTAL STATE OF CONNECTICUT 1,653,221 166,329 10.06% (1,486,892) 166,326 OTHER SOURCES EDUCATION RENT & MISCELLANEOUS 1,500 0 0.00% (1,500) 0 SUB TOTAL 1,500 0 0.00% (1,500) 0 GENERAL GOVERNMENT INTEREST & LIENS 381,744 29,515 7.73% (352,229) 13,776 INTEREST ON INVESTMENTS 2,000,000 177,910 8.90% (1,822,090) 150,567 RECREATION & PARKS 202,001 74,059 36.66% (127,942) 123,250 FIRE SERVICES INSPECTIONS & PLAN FEES 7,320 3,620 49.45% (3,700) 0 BUILDING INSPECTOR 530,591 55,618 10.48% (474,973) 40,321 LICENSE, FEE, PERMIT, FINE 18,320 1,508 8.23% (16,813) 1,654 LIBRARY 0 135 #DIV/0! 135 175 TOWN OF WATERFORD STATEMENT OF REVENUES COMPARED TO ANTICIPATED FOR FISCAL YEAR 2024-2025, THROUGH JULY 31, 2024 WITH COMPARATIVE ACTUAL AMOUNTS FOR FISCAL YEAR 2023-2024, THROUGH JULY 31, 2023 FAVORABLE FISCAL (UNFAVORABLE) FISCAL FISCAL YEAR FISCAL FISCAL YEAR YEAR 2024-2025 YEAR YEAR 2024-2025 2024-2025 PERCENT 2024-2025 2023-2024 BUDGET ACTUAL RECEIVED VARIANCE ACTUAL SALE OF EQUIPMENT 1,000 0 0.00% (1,000) 0 BULKY WASTE FEES 112,000 12,264 10.95% (99,736) 10,541 MISCELLANEOUS 50,000 1,972 3.94% (48,028) 1,849 CONVEYANCE TAX 200,000 37,764 18.88% (162,236) 27,964 EMS-REG COMM CTR FEES 6,000 0 0.00% (6,000) 0 PLANNING& ZONING, ZBA, CONSRV COMM 55,980 3,376 6.03% (52,604) 1,701 TOWN CLERK FEES 175,000 13,647 7.80% (161,354) 12,247 TIPPING FEES 275,000 0 0.00% (275,000) 0 RECYCLING 50,000 0 0.00% (50,000) 0 EUGENE O'NEILL GATE/LEASE REVENUE 10,000 0 0.00% (10,000) 0 AMBULANCE OPERATING SUBSIDY 6,000 0 0.00% (6,000) 0 YSB BOE CLERICAL STIPEND 5,000 0 0.00% (5,000) 0 RENTAL OF BUILDINGS 50,000 9,779 19.56% (40,221) 9,096 SENIOR SERVICES 10,198 4,563 44.74% (5,635) 3,457 VERSA KART/BLUE BOXES 8,000 750 9.38% (7,250) 900 PUBLIC WORKS BOE CUSTODIAL SUBSIDY 75,927 75,927 100.00% 0 73,218 SUB TOTAL 4,230,081 502,406 11.88% (3,727,675) 470,716 TOTAL OTHER SOURCES 4,231,581 502,406 11.87% (3,729,175) 470,716 PROPERTY TAXATION CURRENT PROPERTY TAX 99,867,307 65,461,654 65.55% (34,405,653) 64,536,461 PRIOR YEAR TAXES 486,849 12,856 2.64% (473,993) 17,668 TOTAL PROPERTY TAXATION 100,354,156 65,474,509 65.24% (34,879,647) 64,554,129 FUND BALANCE APPLIED 1,000,000 0 0.00% (1,000,000) 0 TOTAL REVENUES 107,238,958 66,143,244 61.68% (40,095,714) 65,191,171 TOWN OF WATERFORD CAPITAL PROJECTS FUNDS JULY 31, 2024 REMAINING BALANCE FUND DESCRIPTION APPROPRIATION EXPENDED BALANCE PCT EXP RETURNED 424 DISTRICT MAGNET SCHOOL/EARLY CHLDHD LRN CT 21,248,892.00 21,248,807.19 84.81 100.00% 432 WATERFORD HIGH SCHOOL BUILDING PROJECT 68,362,787.00 67,786,416.66 576,370.34 99.16% TOTALS 89,611,679.00 89,035,223.85 576,455.15 99.36% 0.00 PRIOR YEAR EXPENDITURES 89,035,223.85 CURRENT YEAR EXPENDITURES 0.00 TOWN OF WATERFORD STATEMENT OF REVENUES, EXPENDITURES, AND CHANGES IN FUND BALANCE FLEET MANAGEMENT FUND AS OF JULY 31, 2024 Revenues: Investment Income 19,628 Vehicle Rentals 3,700 Total Revenues 23,328 Expenditures: Equipment Replacement 171,490 Vehicle Replacement 1,983,376 Total Expenditures 2,154,866 Excess (Deficiency) of Revenues Over Expenditures (2,131,538) Other Financing Sources (Uses): Transfers from other funds 1,000,000 Total Other Financing Sources (Uses) 1,000,000 Net Change in Fund Balances (1,131,538) Fund Balances - Beginning 3,501,938 Fund Balances - Ending 2,370,400 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JULY 31, 2024 EXPENDED/ PERCENT TRANSFERS ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE EXPENDED OUT 30125-55738 BOS FY25 FLEET MANAGEMENT PLAN 1,000,000.00 1,000,000.00 0.00 100.0% 1,000,000.00 TO FLEET MANAGEMENT FUND 31117-55803 BLDG MAINT FY17 PARKING LOT -YOUTH SERVICES 300,000.00 39,200.00 260,800.00 13.1% 31118-55803 BLDG MAINT FY18 PARKING LOT -YSB/POLICE 195,320.00 57,000.00 138,320.00 29.2% 31120-55851 BLDG MAINT FY20 ADA IMPROVEMENTS YSB/PD 87,000.00 38,000.00 49,000.00 43.7% 31120-55852 BLDG MAINT FY20 TOWN HALL BATHROOMS 87,500.00 87,811.29 (311.29) 100.4% 31121-55851 BLDG MAINT FY21 ADA IMPROVEMENTS YSB/PD 80,700.00 15,139.00 65,561.00 18.8% 31122-55819 BLDG MAINT FY22 UST REPLACEMENT 250,000.00 250,010.00 (10.00) 100.0% 31122-55893 BLDG MAINT FY22 EUGENE O'NEILL ROOF REPLACE 60,767.64 60,767.64 0.00 100.0% 31123-55904 BLDG MAINT FY23 UST REPLACEMENT EUGENE O'NEILL 260,000.00 147,940.91 112,059.09 56.9% 31123-55905 BLDG MAINT FY23 UST REPLACEMENT LIBRARY&PUBLIC SAFETY 420,000.00 411,409.24 8,590.76 98.0% 31123-57857 BLDG MAINT FY23 CIVIC TRIANGLE UPGRADES 1,285,818.00 1,262,429.72 23,388.28 98.2% 31124-55912 BLDG MAINT FY24 TOWN DOCK REPLACEMENT 40,000.00 0.00 40,000.00 0.0% 31124-55913 BLDG MAINT FY24 JORDAN PARKHOUSE REPAIRS 25,000.00 12,750.00 12,250.00 51.0% 31124-55915 BLDG MAINT FY24 SEPTIC REPLMT (EUGENE O'NEILL) 43,500.00 35,154.00 8,346.00 80.8% 31125-55904 BLDG MAINT FY25 UST REPLACEMENT EUGENE O'NEILL 153,000.00 153,000.00 0.0% 32224-55908 EMERGENCY MANAGEMENT FY24 APCO INTELLICOM GUIDECARD SYST 40,000.00 40,000.00 0.00 100.0% 32224-55909 EMERGENCY MANAGEMENT FY24 EVENTIDE NEXLOGDX RECORDER 88,701.00 0.00 88,701.00 0.0% 32323-55900 FIRE SERVICES FY23 COHANZIE EMERGENCY GENERATOR 57,000.00 57,000.00 0.00 100.0% 32323-55907 FIRE SERVICES FY23 PAGERS UPGRADE/REPLACEMENT 25,000.00 24,862.95 137.05 99.5% 32325-55916 FIRE SERVICES FY25 COHANZIE SKYLIGHT REPLACEMENT 30,000.00 30,000.00 0.0% 32925-55918 POLICE DEPT FY25 CELL BLOCK/KITCHEN UPDATE 25,575.00 23,250.00 2,325.00 90.9% 32925-55919 POLICE DEPT FY25 FIREARMS/LASER SITE TRANSITION 53,289.00 53,289.00 0.0% 33020-55850 PUBLIC WORKS FY20 CROSS ROAD 2,754,000.00 2,014,851.37 739,148.63 73.2% 33020-59300 PUBLIC WORKS FY20 FUNDING OFFSET-CROSS ROAD (2,754,000.00) (2,754,000.00) 0.00 100.0% 33022-55882 PUBLIC WORKS FY22 NORMAN/CONCRETE PANELS 80,100.00 128,203.68 (48,103.68) 160.1% 33022-55883 PUBLIC WORKS FY22 WILLIAM ST CONCRETE SIDEWALK 42,300.00 31,331.47 10,968.53 74.1% 33022-55884 PUBLIC WORKS FY22 SUMMER STREET/CONCRETE SW 33,420.00 11,787.17 21,632.83 35.3% 33022-55885 PUBLIC WORKS FY22 DAVID STREET/CONCRETE SW 43,680.00 32,290.09 11,389.91 73.9% 33023-55890 PUBLIC WORKS FY23 ROAD RESURFACING EVERSOURCE AF 315,951.00 (449,026.83) 764,977.83 -142.1% Page 1 of 2 TOWN OF WATERFORD CAPITAL IMPROVEMENT FUND JULY 31, 2024 EXPENDED/ PERCENT TRANSFERS ACCOUNT DEPT/YEAR DESCRIPTION APPROPRIATED ENCUMBERED BALANCE EXPENDED OUT 33023-55901 PUBLIC WORKS FY23 CURB REPLACEMENT SANDY HOLLW 319,300.00 229,119.68 90,180.32 71.8% 33024-55911 PUBLIC WORKS FY24 BLOOMINGDALE/HUNTS BRK CULVERT 15,000.00 15,000.00 0.00 100.0% 33024-55914 PUBLIC WORKS FY24 ROTARY LIFT REPLACEMENTS 75,000.00 74,972.00 28.00 100.0% 33025-55920 PUBLIC WORKS FY25 NIANTIC RIVER ROAD SIDEWALK RE 25,000.00 0.00 25,000.00 0.0% 33122-55894 UTILITY COMM FY22 CONTROL PANEL RETRO-FIT (GORMA 30,000.00 29,362.54 637.46 97.9% 33123-55019 UTILITY COMM FY23 CONTRACT #1 SEWER INTERCEPTOR EASEMENT ACCESS 250,000.00 75,200.00 174,800.00 30.1% 33123-55895 UTILITY COMM FY23 ROOF & SIDING REPLACEMENT 50,000.00 34,587.16 15,412.84 69.2% 33720-55854 REC & PARKS FY20 LEARY BASKETBALL COURT REBUILD 91,000.00 0.00 91,000.00 0.0% 33720-55855 REC & PARKS FY20 TOWN HALL BASKETBALL COURT REP 41,000.00 0.00 41,000.00 0.0% 33722-55896 REC & PARKS FY22 EQUIPMENT STORAGE PLAN 21,000.00 16,750.00 4,250.00 79.8% 33723-55838 REC & PARKS FY23 CHILDREN'S PLAYGROUND 40,000.00 0.00 40,000.00 0.0% 33725-55838 REC & PARKS FY25 STENGER PARK BATHROOM & WALKWAY 10,500.00 10,500.00 0.0% 34723-55021 INFORMATION TECHNOLOGY FY23 AUDITORIUM MEETING ROOM UPDATES 272,000.00 87,402.94 184,597.06 32.1% 34724-55910 INFORMATION TECHNOLOGY FY24 NEXGEN TRANSITION 309,520.00 302,783.90 6,736.10 97.8% 34725-55917 INFORMATION TECHNOLOGY FY24 CONTENT FILTER UPGRADE/REPLACE 15,163.00 11,122.73 4,040.27 73.4% TOTALS 6,688,104.64 3,454,462.65 3,233,641.99 51.7% 1,000,000.00 PRIOR YEAR EXPENDITURES 1,759,957.21 CURRENT YEAR EXPENDITURES 1,694,505.44 Page 2 of 2 TOWN OF WATERFORD CAPITAL AND NON-RECURRING EXPENDITURE FUND FUND BALANCE DESIGNATION AND APPROPRIATION JULY 1,2024 TO JUNE 30,2025 AS OF JULY 31,2024 BEGINNING FY25 RTM AVAILABLE BALANCE XFER IN FISCAL YEAR 2024-2025 ENCUMBERED/ INTEREST TO DATE APPROPRIATIONS DESIGNATED UNDESIGNATED DESIGNATED APPROPRIATED DESIGNATED UNDESIGNATED EXPENDED INC APPROPRIATED DESIGNATED UNDESIGNATED 20501-57018 PURCHASE 8 GOSHEN ROAD $6,314.00 $0.00 $0.00 $6,314.00 $0.00 $0.00 20501-57639 REVALUATION $0.00 $407,700.00 $0.00 $125,000.00 $0.00 $532,700.00 $0.00 20511-57740 COHANZIE SCHOOL REMEDIATION & $0.00 $0.00 $0.00 $40,000.00 $0.00 $40,000.00 $0.00 20511-57767 NEVINS COTTAGE STRUCTURAL REPAIRS $20,715.00 $100,000.00 $0.00 $20,715.00 $100,000.00 $0.00 20511-57840 PLAN OF CONSERVATION DEVELOPMENT $10,914.86 $0.00 $0.00 $10,914.86 $0.00 $0.00 $0.00 20511-57870 MAGO POINT IMPROVEMENTS $0.00 $374,500.00 $0.00 $0.00 $374,500.00 $0.00 20511-57871 PUBLIC SAFETY BLDG HVAC $0.00 $62,045.00 $0.00 $0.00 $62,045.00 $0.00 20511-57872 ROOF & HVAC REPLACEMENT PUBLIC SAFETY BUILDING $61,169.20 $0.00 $0.00 $49,500.00 $11,669.20 $0.00 $0.00 20511-57874 RECONDITION ELEVATORS -TOWN HALL/YOUTH SERVICES BLDG $268,133.85 $0.00 $0.00 $239,565.00 $28,568.85 $0.00 $0.00 20511-57876 SW SCHOOL UNDER