Finding 1223044 (2023-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2026-07-07
Audit: 406626
Organization: City of Watertown (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: Lack of proper documentation for payroll costs charged to the ESSER grant, affecting compliance with federal requirements.
  • Impacted Requirements: Payroll costs must be supported by approved pay rates and related to allowable activities under 2 CFR § 200.430.
  • Recommended Follow-Up: Implement policies to ensure all payroll documentation is maintained and accessible for grant-funded employees.

Finding Text

2023-002 Improve Controls and Documentation Over Payroll Federal Agency: U.S. Department of Education Award Name: COVID-19 – Education Stabilization Fund (“ESSER Grant”) AL Number(s): 84.425 Award Year: 2022 Compliance Requirement: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Type of Finding Compliance Internal Control over Compliance – Material Weakness Criteria or Specific Requirement In accordance with 2 CFR § 200.430 and program requirements for the Education Stabilization Fund, payroll costs charged to federal awards must be supported by appropriate documentation, such as approved pay rates. Costs must relate to approved activities, be allowable under the grant, and be supported by the City’s payroll records. Condition and Context During our testing of 28 payroll transactions charged to the ESSER grant, pay rate documentation supporting the amounts charged to the grant were not provided for 5 employees. Further, evidence of mid-year rate increases were unable to be provided for an additional 7 employees. Cause The City did not maintain or was unable to provide the required payroll documentation over pay rates and subsequent pay increases. This indicates a lack of effective internal controls over payroll documentation and grant cost allocations. Effect or Potential Effect Without supporting documentation for pay rates, there is an increased risk that amounts charged to the grant may be incorrect or unallowable. Questioned Costs Due to the condition noted, we were unable to determine if the costs charged to the grant were allowable. AL Number(s) Name of Federal Program or Cluster Questioned Costs 84.425 COVID-19 – Education Stabilization Fund $29,411 Identification as a Repeat Finding This is a repeat of finding 2022-002. Recommendation The City should develop and implement policies and procedures to ensure that documentation supporting pay rates and payroll allocations is retained and readily available for all grant-funded employees. Views of Responsible Official and Planned Corrective Action Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.

Corrective Action Plan

Finding 2023-002 – Improve Controls and Documentation Over Payroll Condition: Supporting documentation for certain employee pay rates and mid-year pay increases charged to federal grants was not readily available for audit review. Corrective Action: The City and School Department will strengthen procedures for maintaining payroll documentation supporting grant-funded salaries and wages. Personnel action forms, collective bargaining agreements, salary schedules, and documentation supporting pay rate changes will be centrally retained and made available for audit purposes. Periodic reviews will be performed to verify that payroll charges to federal awards are adequately supported. Planned Implementation Date: June 30, 2027 Responsible Official: School Business Manager, Human Resources Director, and Payroll Department

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1223033 2023-001
    Material Weakness Repeat
  • 1223034 2023-001
    Material Weakness Repeat
  • 1223035 2023-001
    Material Weakness Repeat
  • 1223036 2023-001
    Material Weakness Repeat
  • 1223037 2023-001
    Material Weakness Repeat
  • 1223038 2023-001
    Material Weakness Repeat
  • 1223039 2023-001
    Material Weakness Repeat
  • 1223040 2023-001
    Material Weakness Repeat
  • 1223041 2023-001
    Material Weakness Repeat
  • 1223042 2023-002
    Material Weakness Repeat
  • 1223043 2023-002
    Material Weakness Repeat
  • 1223045 2023-003
    Material Weakness Repeat
  • 1223046 2023-003
    Material Weakness Repeat
  • 1223047 2023-003
    Material Weakness Repeat
  • 1223048 2023-003
    Material Weakness Repeat
  • 1223049 2023-003
    Material Weakness Repeat
  • 1223050 2023-003
    Material Weakness Repeat
  • 1223051 2023-003
    Material Weakness Repeat
  • 1223052 2023-003
    Material Weakness Repeat
  • 1223053 2023-003
    Material Weakness Repeat
  • 1223054 2023-004
    Material Weakness Repeat
  • 1223055 2023-004
    Material Weakness Repeat
  • 1223056 2023-004
    Material Weakness Repeat
  • 1223057 2023-004
    Material Weakness Repeat
  • 1223058 2023-004
    Material Weakness Repeat
  • 1223059 2023-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $394,904
10.553 SCHOOL BREAKFAST PROGRAM $195,060
84.027 SPECIAL EDUCATION GRANTS TO STATES $109,773
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $81,008
93.696 CERTIFIED COMMUNITY BEHAVIORAL HEALTH CLINIC EXPANSION GRANTS $72,177
10.555 NATIONAL SCHOOL LUNCH PROGRAM $65,406
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $40,829
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $36,258
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $24,706
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $19,000
10.675 URBAN AND COMMUNITY FORESTRY PROGRAM $18,232
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $13,399
45.310 GRANTS TO STATES $7,404
84.425 EDUCATION STABILIZATION FUND $5,859
20.703 INTERAGENCY HAZARDOUS MATERIALS PUBLIC SECTOR TRAINING AND PLANNING GRANTS $3,000
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $835