Finding 1206117 (2024-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-04-08
Audit: 398086
Organization: City of Agawam (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The City failed to report $618,832 in eligible expenditures in the P&E report for the ARPA grant, leading to compliance deficiencies.
  • Impacted Requirements: Compliance with federal grant reporting under the American Rescue Plan Act is critical for transparency and continued funding eligibility.
  • Recommended Follow-Up: Establish internal controls, including a reconciliation process and a secondary review of reports, to ensure all expenditures are accurately reported.

Finding Text

COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN#21.027 2024-002: Reporting to the Federal Government Compliance Requirement: Reporting Type of Finding: Compliance and Significant Deficiency in Internal Control Over Compliance Criteria or Specific Requirement: Federal grant requirements under the American Rescue Plan Act (“ARPA”) and the U.S. Department of Treasury’s Compliance and Reporting Guidance mandate that all eligible current period expenditures be accurately and completely reported in the Project and Expenditure (“P&E”) reports for federal grants. Complete and timely reporting is essential for compliance, transparency, and continued grant eligibility. Condition: During the review of the City’s ARPA federal grant fund, it was found that not all current period expenditures were included in the P&E report submitted for the reporting period April 1, 2023, through March 31, 2024. Specifically, $618,832 in eligible costs that had been incurred April 1, 2023, through June 30, 2023 were omitted from the required federal reporting of the Current Period Expenditures. The $618,832 was included on the ARPA submission on the “Total Expenditures” and ”Total Cumulative Expenditures” lines of the P&E Report but was inadvertently omitted on the “Current Period Expenditures” line due to the Procurement officer who filed the report used the Town’s fiscal year which begins in July inadvertently instead of the Federal fiscal year which begins in April. Context: The City receives ARPA federal funding to support eligible projects and expenditures related to the COVID-19 response and recovery. The U.S. Treasury requires regular reporting of project expenditures through the P&E Reporting process. For the City, the requirement is to file the P&E report annually. Accurate and comprehensive reporting ensures that grant activity is properly disclosed and meets federal compliance standards. Cause: The omission occurred because the City’s grant accounting and reporting process did not capture and reconcile all eligible expenditures incurred during the reporting period before submitting the P&E report. The City lacked an established system to ensure proper segregation of duties in the report filing process. Specifically, the same individual was responsible for both preparing and submitting the report, without an independent review or oversight by another staff member. This absence of checks and balances increases the risk of errors or omissions and does not align with best practices for internal controls. Effect: As a result of the incomplete reporting, the City’s P&E submission understated current period ARPA expenditures. This can have an impact on the City’s compliance standing with federal grant requirements and potentially jeopardize future grant funding. Questioned Costs: None reported. Recommendation: The City should implement internal control procedures to ensure compliance with all grant requirements including establishing a standardized reconciliation process that reconciles the P&E report submission with the grant fund ledger to ensure all eligible expenditures are included. The City should also implement a secondary review of the P&E report prior to submission. Views of Responsible Officials: See Corrective Action Plan.

Corrective Action Plan

CORRECTIVE ACTION PLAN The City of Agawam, Massachusetts respectfully submits the following corrective action plan for the year ended June 30. 2024. Audit period: July 1, 2023 through June 30, 2024 The finding from the June 30, 2024, schedule of findings and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. Audit Finding Reference: 2024-002 Reporting to the Federal Government – Significant Deficiency Views of responsible officials: The City agrees with the recommendation to implement procedures to ensure that the eligible expenditures reported on the Project and Expenditure (P&E) report include all eligible costs in the reporting period. The City will implement the proper segregation of duties by including an independent review of the P&E report prior to submitting the report. Planned Implementation Date of Corrective Action: The City plans to implement recommendations for the next P&E report filing. Official Responsible for Implementing Corrective Action: Cheryl St. John Town Auditor

Categories

Internal Control / Segregation of Duties Procurement, Suspension & Debarment

Programs in Audit

ALN Program Name Expenditures
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $5.00M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $1.20M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $325,022
10.553 SCHOOL BREAKFAST PROGRAM $264,310
93.575 COVID-19 CHILD CARE AND DEVELOPMENT BLOCK GRANT $260,259
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $49,108
84.425 COVID-19 EDUCATION STABILIZATION FUND $31,475
97.039 HAZARD MITIGATION GRANT $25,152
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $12,005
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $6,044
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $5,427
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $4,909
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $1,364
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,280
84.027 COVID-19 SPECIAL EDUCATION GRANTS TO STATES $1,153
84.027 SPECIAL EDUCATION GRANTS TO STATES $900
12.401 NATIONAL GUARD MILITARY OPERATIONS AND MAINTENANCE (O&M) PROJECTS $457
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $216