CORRECTIVE ACTION PLANS Oversight Agency for Audit: U.S. Department of the Treasury The City of Haverhill, Massachusetts respectfully submits the following corrective action plans for the year ended June 30, 2024. Name and address of the independent public accounting firm: CBIZ CPAs P.C. 9 Executive Park Drive, Suite 100 Merrimack, NH 03054 Audit Period: July 1, 2023, through June 30, 2024 The findings from the June 30, 2024, schedule of findings and responses are discussed below. The findings are numbered consistently with the number assigned in the schedule. Finding 2024-004: Improve Controls and Documentation Over Allowability of Costs Federal Program Information Federal Agency: U.S. Department of Education Award Name(s): Title I Grants to Local Educational Agencies Assistance Listing Number(s): 84.010 Award Year: 2023, 2024 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of Education Award Name(s): COVID-19 – Education Stabilization Fund Assistance Listing Number(s): 84.425 Award Year: 2022 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of Education Award Name(s): Twenty-First Century Community Learning Centers Assistance Listing Number(s): 84.287, 84.287C Award Year: 2023, 2024 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Federal Agency: U.S. Department of Education Award Name(s): Special Education Cluster Assistance Listing Number(s): 84.027, 84.173 Award Year: 2023 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Type of Finding: Compliance Internal Control over Compliance – Significant Deficiency Criteria or Specific Requirement: Grantees must provide reasonable assurance that federal awards are expended only for allowable activities and that the costs of goods and services charged to federal awards are allowable and in accordance with the applicable cost principles. Management of the City is also responsible for establishing and maintaining effective internal control over compliance with federal requirements that have a direct and material effect on a federal program. The Code of Federal Regulations Section 200.403(g) states that for costs to be allowable under Federal awards, they must be adequately documented and there must be sufficient documentation. Condition and Context: A sample of invoices were tested in order to determine if costs were allowable and adequately approved. As a result of our testing, it was determined that invoices were not approved for two transactions in the Title I Grants to Local Educational Agencies program and three invoices in the COVID-19 Education Stabilization Fund program. In addition, invoices were not able to be provided for three invoices in the COVID-19 Education Stabilization Fund program, one invoice in the Twenty-First Century Community Learning Centers program, and one invoice in the Special Education Cluster. Cause: The City did not have adequate controls in place to ensure invoices were properly approved and retained. Effect or Potential Effect: Due to the weakness in internal controls and compliance noted above, there is a risk that amounts charged to federal awards may not be allowable or in accordance with applicable cost principles. Questioned Costs: Due to the condition noted above, we were unable to determine if the costs charged to the applicable grants are allowable. AL Number(s) Name of Federal Program or Cluster Questioned Costs 84.010 Title I Grants to Local Educational Agencies $82,488 84.425 COVID-19 Education Stabilization Fund $136,876 84.287, 84.287C Twenty-First Century Community Learning Centers $1,305 84.027/84.173 Special Education Cluster $1,945 Recommendation: The City should enhance internal controls over the invoice approval and retention process in order to provide reasonable assurance that federal award transactions are allowable and in accordance with the applicable cost principles. Views of Responsible Official: The School Department recognizes the weaknesses identified in grants management, as well as in the approval and allocation of allowable costs. To address these issues, the School Department has recently hired a new Business Manager/Chief Financial Officer (CFO). This individual is responsible for implementing appropriate internal controls that align with Best Practices, particularly in key areas such as invoice approval, payroll approval, grants management, and procurement compliance. To ensure ongoing improvement, training will be provided continuously for all staff members responsible for managing federal grants. This training will include; • Procedures to reconcile internal records with federal and state reports. • Maintain a process to ensure that costs charged to grants are allowable, necessary and reasonable, and properly allocated, and that these determinations are made in a consistent manner. • Determine whether indirect costs will be allocated to grant programs, and if so, maintain an appropriate process to make the allocation. • Maintain a process to track information about local matching funds, including identification of the source of such funds. • Identify and segregate costs as necessary for the grant (e.g., separate allowable and unallowable costs, separate direct costs from indirect costs, and separate administrative costs. • Account for and track grant-funded capital items. • Document grant procedures. • Maintain a comprehensive list of reporting requirements and a reminder system for meeting the reporting deadlines. • Identify who is responsible for the various reporting requirements. • Establish methodologies for the preparation of specialized reports. • Establish processes for obtaining all of the information needed for the Schedule of Expenditures of Federal Awards (SEFA). • Develop and document an understanding of audit requirements specific to grants, including those in Generally Accepted Government Auditing Standards (GAGAS), Generally Accepted Auditing Standards (GAAS), and Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). • Develop and document an understanding of audit requirements for grant close-outs. • Report if any process or internal control issues identified were resolved.