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-005: Improve Controls and Documentation Over Allowability of Costs 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 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 payroll expenditures were tested in order to determine if costs were allowable and adequately approved. As a result of our testing, it was determined that one payroll transaction had no timesheet approval, and one payroll transaction was self-approved. Payroll expenditures charged to the programs are required to be supported with documentation substantiating that the employees are eligible to be charged to the grant and that the payroll charged relates to time spent accomplishing grant objectives. This supporting documentation should be standardized and should include all required elements in accordance with applicable cost principles. Cause: The City did not have adequate controls in place to provide sufficient documentation to demonstrate compliance with federal and state time and effort reporting requirements. 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.287, 84.287C Twenty-First Century Community Learning Centers $5,450 Recommendation: Management should enhance procedures and controls in place over the time and effort reporting and documentation requirements that department heads must adhere with to ensure compliance with federal and state time and effort reporting requirements. 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.