Finding 1162906 (2024-008)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2024
Accepted
2025-11-25
Audit: 372554
Organization: City of Peabody (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The City failed to provide necessary documentation for payroll expenses charged to the Education Stabilization Fund, leading to non-compliance with federal and state reporting requirements.
  • Impacted Requirements: Payroll costs totaling $1,833,922 are questioned due to lack of semi-annual certifications and personnel activity reports, which are essential for verifying allowable costs.
  • Recommended Follow-Up: Establish clear written policies for time and effort reporting, implement standardized forms, and provide training to ensure compliance with federal and state guidelines.

Finding Text

Education Stabilization Fund Education Stabilization Fund Federal Assistance Listing No. 84.425D, 84.425U and 84.425W 2024-008: Controls for Monitoring Payroll Charged to the Grant Compliance Requirement: Allowable Costs/Cost Principles Type of Finding: Compliance and Material Weakness 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 applicable cost principles. Condition: Payroll expenditures charged to the Education Stabilization Fund grant are required to be supported with documentation (i.e., semi-annual certifications and personnel activity reports) substantiating that the employees are eligible to be charged to the grant and that the payroll charged relates to time spent accomplishing grant objectives. The City utilizes semi-annual time and effort certification forms to document the eligibility of the employees paid out of the grant. However, these forms were not completed for each employee whose salary was charged to the grant. A total of 38 payroll expenditures amounting to $250,328, were selected for testing and could not be substantiated through time and effort reports or any similar internal control process. Context: The City did not maintain 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. Cause: 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. Management also has not adopted and implemented standardized forms that include all data as required by federal and state guidelines to demonstrate compliance with these requirements. Effect: The City has not complied with the federal and state time and effort reporting requirements, which could result in improper spending of grant funding. Questioned Costs: Total payroll costs charged to the grant of $1,833,922 are questioned costs. Repeat Finding: This matter was reported as a finding in the previous year as finding 2023-006. Recommendation: The City should establish written policies and procedures outlining the time and effort reporting and documentation requirements that must be adhered with to ensure compliance with federal and state time and effort reporting requirements. Management should adopt and implement standardized forms that include all data required by federal and state guidelines and provide training to ensure that program personnel understand the time and effort reporting requirements. Views of Responsible Officials: See Corrective Action Plan.

Corrective Action Plan

Views of Responsible Officials and Planned Corrective Actions: The School District will immediately begin reissuing and recollecting the forms for the education stabilization grant for 2026, as well as into future periods.

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring Eligibility Material Weakness Reporting

Other Findings in this Audit

  • 1162883 2024-005
    Material Weakness Repeat
  • 1162884 2024-005
    Material Weakness Repeat
  • 1162885 2024-005
    Material Weakness Repeat
  • 1162886 2024-005
    Material Weakness Repeat
  • 1162887 2024-005
    Material Weakness Repeat
  • 1162888 2024-005
    Material Weakness Repeat
  • 1162889 2024-005
    Material Weakness Repeat
  • 1162890 2024-005
    Material Weakness Repeat
  • 1162891 2024-006
    Material Weakness Repeat
  • 1162892 2024-006
    Material Weakness Repeat
  • 1162893 2024-006
    Material Weakness Repeat
  • 1162894 2024-007
    Material Weakness Repeat
  • 1162895 2024-007
    Material Weakness Repeat
  • 1162896 2024-007
    Material Weakness Repeat
  • 1162897 2024-008
    Material Weakness Repeat
  • 1162898 2024-008
    Material Weakness Repeat
  • 1162899 2024-008
    Material Weakness Repeat
  • 1162900 2024-008
    Material Weakness Repeat
  • 1162901 2024-008
    Material Weakness Repeat
  • 1162902 2024-008
    Material Weakness Repeat
  • 1162903 2024-008
    Material Weakness Repeat
  • 1162904 2024-008
    Material Weakness Repeat
  • 1162905 2024-008
    Material Weakness Repeat
  • 1162907 2024-009
    Material Weakness Repeat
  • 1162908 2024-009
    Material Weakness Repeat
  • 1162909 2024-009
    Material Weakness Repeat
  • 1162910 2024-009
    Material Weakness Repeat
  • 1162911 2024-009
    Material Weakness Repeat
  • 1162912 2024-009
    Material Weakness Repeat
  • 1162913 2024-009
    Material Weakness Repeat
  • 1162914 2024-009
    Material Weakness Repeat
  • 1162915 2024-009
    Material Weakness Repeat
  • 1162916 2024-009
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $2.78M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $2.01M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $1.11M
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $393,973
10.553 SCHOOL BREAKFAST PROGRAM $385,499
16.922 EQUITABLE SHARING PROGRAM $163,653
10.555 COVID-19 NATIONAL SCHOOL LUNCH PROGRAM $145,716
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $120,925
16.839 STOP SCHOOL VIOLENCE $58,775
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $47,699
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $27,779
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $27,750
84.371 COMPREHENSIVE LITERACY DEVELOPMENT $27,500
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $23,767
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $20,489
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $19,622
84.027 SPECIAL EDUCATION GRANTS TO STATES $16,888
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $14,869
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $13,570
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $11,129
84.425 COVID-19 EDUCATION STABILIZATION FUND $10,000
93.044 SPECIAL PROGRAMS FOR THE AGING, TITLE III, PART B, GRANTS FOR SUPPORTIVE SERVICES AND SENIOR CENTERS $9,862
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $9,620
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $8,400
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $7,438
84.027 COVID-19 SPECIAL EDUCATION GRANTS TO STATES $2,853
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $2,507
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $1,200
84.173 COVID-19 SPECIAL EDUCATION PRESCHOOL GRANTS $677
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $450