Finding 1166166 (2022-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2025-12-22
Audit: 377065
Organization: City of Watertown (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The City failed to provide necessary payroll documentation for 16 employees and lacked evidence for stipend cost transfers, indicating weak internal controls.
  • Impacted Requirements: Compliance with 2 CFR § 200.430 regarding documentation for payroll costs and allowable expenses under the COVID-19 Education Stabilization Fund.
  • Recommended Follow-Up: Implement policies to ensure retention of payroll documentation and proper approval for all cost allocations to federal grants.

Finding Text

2022-002 Improve Controls and Documentation Over Payroll Federal Agency: U.S. Department of Education Award Name: COVID-19 – Education Stabilization Fund 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. Additionally, for transfers or allocations of payroll costs, documentation of the transfer or allocation to the federal grant must be maintained. Condition and Context During our testing of 22 payroll transactions charged to the ESSER grant, pay rate documentation supporting the amounts charged to the grant was not provided for 16 employees. Further, for 10 employees receiving summer enrichment stipends, the City was unable to provide evidence of the balance transfer of stipend costs to the ESSER grant. Cause The City did not maintain or was unable to provide the required payroll documentation, such as pay rates, and did not retain evidence of payroll balance transfers or allocations to the ESSER grant for summer enrichment stipends. 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. Failure to document transfers or allocations to the grant could result in improper charging of costs, questioned costs, or noncompliance with federal regulations. 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 $31,493 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. The City should also ensure that all transfers and allocations of payroll costs to federal grants are properly documented, reviewed, and approved. 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

Re: Corrective Action Plan - Audit Finding 2022-02 - Improve Controls and Documentation over Payroll Planned Corrective Action: The District will enhance payroll documentation controls by standardizing processes for verifying pay rates, retaining payroll support documents, and documenting/approving transfers and allocations. Cross-department procedures between Payroll, HR, and Business Office will be formalized. Staff involved in payroll and federal grants will receive training. Planned Implementation Date of Corrective Action: Already following corrective action Person Responsible for Corrective Action: Lisa Gibbons; Director of Finance & Operations ___Lisa Gibbons__________________________ Signature Ms. Emilys Peña Assistant Superintendent Dr. Deanne Galdston Superintendent of Schools Ms. Lisa Gibbons Director of Finance and Operations Dr. Ceronne Daly Director of Diversity, Equity, Inclusion, and Belonging Dr. Kathleen Desmarais Director of Student Services Ms. Amanda Owens Director of Human Resources

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1166151 2022-001
    Material Weakness Repeat
  • 1166152 2022-001
    Material Weakness Repeat
  • 1166153 2022-001
    Material Weakness Repeat
  • 1166154 2022-001
    Material Weakness Repeat
  • 1166155 2022-003
    Material Weakness Repeat
  • 1166156 2022-003
    Material Weakness Repeat
  • 1166157 2022-003
    Material Weakness Repeat
  • 1166158 2022-003
    Material Weakness Repeat
  • 1166159 2022-004
    Material Weakness Repeat
  • 1166160 2022-004
    Material Weakness Repeat
  • 1166161 2022-004
    Material Weakness Repeat
  • 1166162 2022-004
    Material Weakness Repeat
  • 1166163 2022-001
    Material Weakness Repeat
  • 1166164 2022-001
    Material Weakness Repeat
  • 1166165 2022-002
    Material Weakness Repeat
  • 1166167 2022-003
    Material Weakness Repeat
  • 1166168 2022-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.019 CORONAVIRUS RELIEF FUND $709,989
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $321,512
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $199,990
10.553 SCHOOL BREAKFAST PROGRAM $173,227
84.425 EDUCATION STABILIZATION FUND $144,576
10.555 NATIONAL SCHOOL LUNCH PROGRAM $66,781
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $45,147
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $38,168
84.027 SPECIAL EDUCATION GRANTS TO STATES $36,850
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $13,216
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $7,261
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $4,500
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $3,250