Finding 1204907 (2025-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-03-30

AI Summary

  • Core Issue: The Town failed to reconcile expenditures with the general ledger for COVID-19 grant reporting.
  • Impacted Requirements: Key reporting items required by the federal awarding agency were not accurately reported, risking overstated expenditures.
  • Recommended Follow-Up: The Town should establish procedures to ensure all federal reporting aligns with the general ledger.

Finding Text

2025-001 U.S. Department of the Treasury Direct Award and Passed through Bristol County, Massachusetts COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Significant Deficiency in Internal Controls over Compliance and Compliance Finding Criteria: The compliance supplement identifies four Key Line Items required to be reported to the federal awarding agency which include (1) current period obligation, (2) cumulative obligation, (3) current period expenditure and (4) cumulative expenditure. Per 2 CFR 200.1, an obligation is an order placed for property and services, contracts and subawards made, and similar transactions that require payment. Condition: Expenditures were not reconciled to the general ledger for reporting submitted to the U.S. Department of the Treasury and Bristol County, Massachusetts. Cause: The Town did not have procedures in place to perform reconciliations of required grant reporting. Effect: The Town potentially overstated expenditures by approximately $528,000 and $127,000 in reporting submitted to the U.S. Department of the Treasury and Bristol County, Massachusetts, respectively. Questioned Costs: None Repeat Finding from Prior Year: No Recommendation: The Town should implement procedures to reconcile all federal reporting to the general ledger. Views of Responsible Official: Management agrees with the finding.

Corrective Action Plan

Finding 2025-001 Condition: Expenditures were not reconciled to the general ledger for reporting submitted to the U.S. Department of the Treasury and Bristol County, Massachusetts. Corrective Action Planned: To ensure the accuracy of ARPA reporting, and all Federal Grants, a reconciliation process will be implemented and followed by all involved. Anticipated Completion Date: April 30, 2026 Contact: Nicole Pearsall, Town Accountant

Categories

Subrecipient Monitoring Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1204906 2025-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $741,841
10.555 NATIONAL SCHOOL LUNCH PROGRAM $97,423
10.553 SCHOOL BREAKFAST PROGRAM $46,469
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $33,191
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $31,949
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $11,613
84.027 SPECIAL EDUCATION GRANTS TO STATES $10,600
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $10,218
15.616 CLEAN VESSEL ACT $9,940
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $6,728
97.067 HOMELAND SECURITY GRANT PROGRAM $5,000
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $4,600
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $3,828
10.185 LOCAL FOOD FOR SCHOOLS COOPERATIVE AGREEMENT PROGRAM $2,226
84.425 EDUCATION STABILIZATION FUND $2,100
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $1,306
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $109