Finding 375888 (2023-001)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-03-13
Audit: 294969
Organization: City of Haverhill (MA)

AI Summary

  • Core Issue: Lack of written guidelines for time and effort reporting leads to non-compliance with federal and state requirements.
  • Impacted Requirements: Compliance with allowable costs and cost principles for federal awards is at risk due to inadequate documentation procedures.
  • Recommended Follow-Up: Establish and implement clear guidelines and standardized forms for time and effort reporting to ensure compliance.

Finding Text

U.S. DEPARTMENT OF EDUCATION Title I Grants to Local Educational Agencies Federal Assistance Listing Number 84.010 Special Education Grants to States and Special Education Preschool Grants Federal Assistance Listing Numbers, 84.027 and 84.173. COVID-19 Education Stabilization FederaL Assistance Listing Numbers, 84.425, 84.425C, 84.425D, 84.425U, and 84.425W Twenty-First Century Community Learning Centers Federal Assistance Listing Numbers, 84.287 and 84.287C 2023-001: Controls for Monitoring Payroll Charged to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Significant Deficiency in Internal Control over Compliance 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. Condition: Management has not established written guidelines and procedures outlining 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. Such guidelines and procedures should indicate under what circumstances semi-annual certifications and personnel activity reports (PARS) are required and should indicate due dates for when this information must be provided to the school business office. Management also has not adopted and implemented standardized forms for semi-annual certifications and PARS that include all data required by federal and state guidelines.

Corrective Action Plan

CORRECTIVE ACTION PLAN Oversight Agency for Audit: U.S. Department of Education The City of Haverhill, Massachusetts respectfully submits the following corrective action plan for the year ended June 30, 2023. Name and address of independent public accounting firm: Powers & Sullivan, LLC 100 Quannapowitt Parkway, Suite 101 Wakefield, MA 01880 Audit period: July 1, 2022 through June 30, 2023 The finding from the June 30, 2023, schedule of findings and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. FINDINGS—FEDERAL AWARD PROGRAMS AUDITS U.S. DEPARTMENT OF EDUCATION Passed through the Massachusetts Department of Elementary and Secondary Education Title I Grants to Local Educational Agencies Title I Grants to Local Educational Agencies Federal Assistance Listing No. 84.010 Special Education Cluster Special Education Grants to States and Special Education Preschool Grants Federal Assistance Listing Numbers, 84.027 and 84.173. COVID-19 Education Stabilization COVID-19 Education Stabilization Federal Assistance Listing Numbers, 84.425, 84.425C, 84.425D, 84.425U, and 84.425W Twenty-First Century Community Learning Centers Twenty-First Century Community Learning Centers Federal Assistance Listing Numbers, 84.287 and 84.287C 2023-001: Controls for Monitoring Payroll Charged to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Significant Deficiency in Internal Control over Compliance 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. Condition: Management has not established written guidelines and procedures outlining 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. Such guidelines and procedures should indicate under what circumstances semi-annual certifications and personnel activity reports (PARS) are required and should indicate due dates for when this information must be provided to the school business office. Management also has not adopted and implemented standardized forms for semi-annual certifications and PARS that include all data required by federal and state guidelines. Questioned Costs: None reported. Context: 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 Title 2 U.S. Code of Federal Regulations Part 225 Cost Principals for State, Local, and Indian Tribal Governments. The City did not have an adequate system of internal controls in place to provide sufficient documentation to demonstrate compliance with federal and state time and effort reporting requirements in accordance with the provisions of Title 2 U.S. Code of Federal Regulations Part 225 Cost Principals for State, Local, and Indian Tribal Governments. Effect: The City has not complied with the federal and state time and effort reporting requirements. Cause: Lack of documented policies, procedures and guidelines in place to ensure compliance with time and effort reporting requirements. Repeat Finding: This matter was reported as a finding for the Title I major program and special education cluster grants in the previous year as finding 2022-001. Recommendation: Management should establish written guidelines and procedures outlining 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. Such guidelines and procedures should indicate under what circumstances semi-annual certifications and personnel activity reports (PARS) are required and should indicate due dates for when this information must be provided to the school business office. Management should also adopt and implement standardized forms for semi-annual certifications and PARS that include all data required by federal and state guidelines. Once the written guidelines and procedures have been established, training should be provided to ensure that the program managers fully understand the time and effort reporting requirements. Views of Responsible Officials and Planned Corrective Actions: Management agrees with the finding and will establish written guidelines and procedures outlining 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. Such guidelines and procedures will indicate under what circumstances semi-annual certifications and personnel activity reports (PARS) are required and will indicate due dates for when this information must be provided to the school business office. Management will also adopt and implement standardized forms for semi-annual certifications and PARS that include all data required by federal and state guidelines. Once the written guidelines and procedures have been established, training will be provided to ensure that the program managers fully understand the time and effort reporting requirements. Management intends to implement these procedures in fiscal 2024. If the Oversight Agency has questions regarding this plan, please call Michael Pfifferling, Assistant Superintendent of Finance and Operations at 978-374-3400. Sincerely yours, Michael Pfifferling Assistant Superintendent of Finance and Operations City of Haverhill

Categories

Allowable Costs / Cost Principles Subrecipient Monitoring Reporting Significant Deficiency

Other Findings in this Audit

  • 375889 2023-001
    Significant Deficiency Repeat
  • 375890 2023-001
    Significant Deficiency Repeat
  • 375891 2023-001
    Significant Deficiency Repeat
  • 375892 2023-001
    Significant Deficiency Repeat
  • 375893 2023-001
    Significant Deficiency Repeat
  • 375894 2023-001
    Significant Deficiency Repeat
  • 375895 2023-001
    Significant Deficiency Repeat
  • 375896 2023-001
    Significant Deficiency Repeat
  • 375897 2023-001
    Significant Deficiency Repeat
  • 375898 2023-001
    Significant Deficiency Repeat
  • 375899 2023-001
    Significant Deficiency Repeat
  • 375900 2023-001
    Significant Deficiency Repeat
  • 375901 2023-001
    Significant Deficiency Repeat
  • 375902 2023-001
    Significant Deficiency
  • 375903 2023-001
    Significant Deficiency
  • 375904 2023-001
    Significant Deficiency
  • 375905 2023-001
    Significant Deficiency
  • 375906 2023-001
    Significant Deficiency
  • 375907 2023-001
    Significant Deficiency
  • 375908 2023-001
    Significant Deficiency
  • 375909 2023-001
    Significant Deficiency
  • 375910 2023-001
    Significant Deficiency
  • 375911 2023-001
    Significant Deficiency
  • 375912 2023-001
    Significant Deficiency
  • 375913 2023-001
    Significant Deficiency
  • 375914 2023-001
    Significant Deficiency
  • 375915 2023-001
    Significant Deficiency
  • 375916 2023-002
    -
  • 375917 2023-002
    -
  • 375918 2023-002
    -
  • 375919 2023-003
    -
  • 375920 2023-003
    -
  • 375921 2023-003
    -
  • 375922 2023-003
    -
  • 375923 2023-003
    -
  • 375924 2023-003
    -
  • 375925 2023-003
    -
  • 375926 2023-003
    -
  • 952330 2023-001
    Significant Deficiency Repeat
  • 952331 2023-001
    Significant Deficiency Repeat
  • 952332 2023-001
    Significant Deficiency Repeat
  • 952333 2023-001
    Significant Deficiency Repeat
  • 952334 2023-001
    Significant Deficiency Repeat
  • 952335 2023-001
    Significant Deficiency Repeat
  • 952336 2023-001
    Significant Deficiency Repeat
  • 952337 2023-001
    Significant Deficiency Repeat
  • 952338 2023-001
    Significant Deficiency Repeat
  • 952339 2023-001
    Significant Deficiency Repeat
  • 952340 2023-001
    Significant Deficiency Repeat
  • 952341 2023-001
    Significant Deficiency Repeat
  • 952342 2023-001
    Significant Deficiency Repeat
  • 952343 2023-001
    Significant Deficiency Repeat
  • 952344 2023-001
    Significant Deficiency
  • 952345 2023-001
    Significant Deficiency
  • 952346 2023-001
    Significant Deficiency
  • 952347 2023-001
    Significant Deficiency
  • 952348 2023-001
    Significant Deficiency
  • 952349 2023-001
    Significant Deficiency
  • 952350 2023-001
    Significant Deficiency
  • 952351 2023-001
    Significant Deficiency
  • 952352 2023-001
    Significant Deficiency
  • 952353 2023-001
    Significant Deficiency
  • 952354 2023-001
    Significant Deficiency
  • 952355 2023-001
    Significant Deficiency
  • 952356 2023-001
    Significant Deficiency
  • 952357 2023-001
    Significant Deficiency
  • 952358 2023-002
    -
  • 952359 2023-002
    -
  • 952360 2023-002
    -
  • 952361 2023-003
    -
  • 952362 2023-003
    -
  • 952363 2023-003
    -
  • 952364 2023-003
    -
  • 952365 2023-003
    -
  • 952366 2023-003
    -
  • 952367 2023-003
    -
  • 952368 2023-003
    -

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $4.37M
10.555 National School Lunch Program $3.59M
66.458 Capitalization Grants for Clean Water State Revolving Funds $1.46M
14.218 Community Development Block Grants/entitlement Grants $1.33M
10.553 School Breakfast Program $1.10M
84.287 Twenty-First Century Community Learning Centers $402,957
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $340,689
84.027 Covid-19 Special Education_grants to States $276,677
10.555 Covid-19 National School Lunch Program $209,617
10.559 Summer Food Service Program for Children $167,134
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $130,471
84.365 English Language Acquisition State Grants $128,758
14.218 Covid-19 Community Development Block Grants/entitlement Grants $95,346
16.738 Edward Byrne Memorial Justice Assistance Grant Program $82,372
84.425 Covid-19 Education Stabilization Fund $81,320
84.424 Title Iv, Part A: Student Support and Academic Enrichment Program $68,144
84.048 Career and Technical Education -- Basic Grants to States $60,782
84.173 Special Education_preschool Grants $54,632
84.173 Covid-19 Special Education_preschool Grants $46,579
10.558 Child and Adult Care Food Program $46,527
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $45,530
84.027 Special Education_grants to States $36,972
14.239 Home Investment Partnerships Program $33,843
97.042 Emergency Management Performance Grants $32,958
93.268 Immunization Cooperative Agreements $26,691
16.710 Public Safety Partnership and Community Policing Grants $19,586
20.600 State and Community Highway Safety $15,353
84.367 Supporting Effective Instruction State Grants $12,100
16.203 Promoting Evidence Integration in Sex Offender Management Discretionary Grant Program $9,983
84.196 Education for Homeless Children and Youth $8,187
84.010 Title I Grants to Local Educational Agencies $804
16.922 Equitable Sharing Program $313