Finding 963126 (2023-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2023
Accepted
2024-03-28
Audit: 299007
Organization: City of Peabody (MA)

AI Summary

  • Core Issue: The City failed to provide adequate documentation for payroll expenses charged to the Special Education Cluster grant, violating federal and state time and effort reporting requirements.
  • Impacted Requirements: Compliance with allowable costs and cost principles, specifically the need for semi-annual certifications and personnel activity reports to substantiate payroll charges.
  • Recommended Follow-up: Establish clear written policies for time and effort reporting, implement standardized forms, and provide training to ensure compliance moving forward.

Finding Text

U.S. DEPARTMENT OF EDUCATION Passed through Massachusetts Department of Elementary and Secondary Education Special Education Cluster Special Education Grants to States Federal Assistance Listing No. 84.027 Special Education Preschool Grants Federal Assistance Listing No. 84.173 2023-002: 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 Special Education Cluster 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. These forms, however, were not completed for each employee charged out of the grant. 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. Effect: The City has not complied with the federal and state time and effort reporting requirements. 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. Questioned Costs: Total payroll costs charged to the grant in 2023 totaled $1,794,406, which was paid on a bi-weekly basis throughout the year. Three of the pay periods were selected for testing, which totaled $156,211 for 65 employees paid out of the grant during those pay periods. From the pay periods selected for testing, $156,211 could not be substantiated through time and effort reports or any similar internal control process. Repeat Finding: This matter was reported as a finding in the previous year as finding 2022-001. 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 and Planned Corrective Actions: The School District will immediately begin reissuing and recollecting the forms for the special education grant for 2024, as well as into future periods.

Categories

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

Other Findings in this Audit

  • 386679 2023-002
    Material Weakness Repeat
  • 386680 2023-002
    Material Weakness Repeat
  • 386681 2023-002
    Material Weakness Repeat
  • 386682 2023-002
    Material Weakness Repeat
  • 386683 2023-002
    Material Weakness Repeat
  • 386684 2023-002
    Material Weakness Repeat
  • 386685 2023-003
    Material Weakness Repeat
  • 386686 2023-003
    Material Weakness Repeat
  • 386687 2023-003
    Material Weakness Repeat
  • 386688 2023-003
    Material Weakness Repeat
  • 386689 2023-004
    Material Weakness
  • 386690 2023-004
    Material Weakness
  • 386691 2023-004
    Material Weakness
  • 386692 2023-004
    Material Weakness
  • 386693 2023-005
    Material Weakness
  • 386694 2023-005
    Material Weakness
  • 386695 2023-005
    Material Weakness
  • 386696 2023-005
    Material Weakness
  • 386697 2023-006
    Material Weakness Repeat
  • 386698 2023-006
    Material Weakness Repeat
  • 386699 2023-006
    Material Weakness Repeat
  • 386700 2023-006
    Material Weakness Repeat
  • 386701 2023-006
    Material Weakness Repeat
  • 386702 2023-006
    Material Weakness Repeat
  • 386703 2023-006
    Material Weakness Repeat
  • 386704 2023-006
    Material Weakness Repeat
  • 386705 2023-007
    Material Weakness
  • 386706 2023-007
    Material Weakness
  • 386707 2023-007
    Material Weakness
  • 386708 2023-007
    Material Weakness
  • 386709 2023-007
    Material Weakness
  • 386710 2023-007
    Material Weakness
  • 386711 2023-007
    Material Weakness
  • 386712 2023-007
    Material Weakness
  • 386713 2023-008
    Material Weakness
  • 386714 2023-008
    Material Weakness
  • 386715 2023-008
    Material Weakness
  • 386716 2023-008
    Material Weakness
  • 386717 2023-008
    Material Weakness
  • 386718 2023-008
    Material Weakness
  • 386719 2023-008
    Material Weakness
  • 386720 2023-008
    Material Weakness
  • 963121 2023-002
    Material Weakness Repeat
  • 963122 2023-002
    Material Weakness Repeat
  • 963123 2023-002
    Material Weakness Repeat
  • 963124 2023-002
    Material Weakness Repeat
  • 963125 2023-002
    Material Weakness Repeat
  • 963127 2023-003
    Material Weakness Repeat
  • 963128 2023-003
    Material Weakness Repeat
  • 963129 2023-003
    Material Weakness Repeat
  • 963130 2023-003
    Material Weakness Repeat
  • 963131 2023-004
    Material Weakness
  • 963132 2023-004
    Material Weakness
  • 963133 2023-004
    Material Weakness
  • 963134 2023-004
    Material Weakness
  • 963135 2023-005
    Material Weakness
  • 963136 2023-005
    Material Weakness
  • 963137 2023-005
    Material Weakness
  • 963138 2023-005
    Material Weakness
  • 963139 2023-006
    Material Weakness Repeat
  • 963140 2023-006
    Material Weakness Repeat
  • 963141 2023-006
    Material Weakness Repeat
  • 963142 2023-006
    Material Weakness Repeat
  • 963143 2023-006
    Material Weakness Repeat
  • 963144 2023-006
    Material Weakness Repeat
  • 963145 2023-006
    Material Weakness Repeat
  • 963146 2023-006
    Material Weakness Repeat
  • 963147 2023-007
    Material Weakness
  • 963148 2023-007
    Material Weakness
  • 963149 2023-007
    Material Weakness
  • 963150 2023-007
    Material Weakness
  • 963151 2023-007
    Material Weakness
  • 963152 2023-007
    Material Weakness
  • 963153 2023-007
    Material Weakness
  • 963154 2023-007
    Material Weakness
  • 963155 2023-008
    Material Weakness
  • 963156 2023-008
    Material Weakness
  • 963157 2023-008
    Material Weakness
  • 963158 2023-008
    Material Weakness
  • 963159 2023-008
    Material Weakness
  • 963160 2023-008
    Material Weakness
  • 963161 2023-008
    Material Weakness
  • 963162 2023-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $5.34M
14.239 Home Investment Partnerships Program $2.33M
10.555 National School Lunch Program $1.62M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $510,404
10.553 School Breakfast Program $304,229
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $249,639
10.555 Covid-19 National School Lunch Program $168,352
93.959 Block Grants for Prevention and Treatment of Substance Abuse $134,765
93.959 Covid-19 Block Grants for Prevention and Treatment of Substance Abuse $125,000
14.218 Covid-19 Community Development Block Grants/entitlement Grants $123,185
84.027 Covid-19 Special Education_grants to States $110,945
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $89,477
84.173 Special Education_preschool Grants $65,425
97.044 Assistance to Firefighters Grant $49,750
20.600 State and Community Highway Safety $47,173
84.425 Covid-19 Education Stabilization Fund $40,190
97.042 Emergency Management Performance Grants $27,941
84.371 Striving Readers - Comprehensive Literacy Development Grants $27,500
84.173 Covid-19 Special Education_preschool Grants $26,236
84.010 Title I Grants to Local Educational Agencies $21,500
84.048 Career and Technical Education -- Basic Grants to States $19,610
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $16,018
16.738 Edward Byrne Memorial Justice Assistance Grant Program $14,060
84.196 Education for Homeless Children and Youth $10,000
14.218 Community Development Block Grants/entitlement Grants $5,722
16.922 Equitable Sharing Program $5,100
45.310 Grants to States - State Library Program $4,200
84.424 Student Support and Academic Enrichment Program $3,800
84.027 Special Education_grants to States $2,500
10.559 Summer Food Service Program for Children $2,468
16.607 Bulletproof Vest Partnership Program $2,437
84.367 Supporting Effective Instruction State Grants $1,879
93.645 Stephanie Tubbs Jones Child Welfare Services Program $1,873
84.365 English Language Acquisition State Grants $1,350