Finding 1228623 (2025-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-09-02
Audit: 410260
Organization: Town of Concord (MA)

AI Summary

  • Core Issue: The Town failed to reconcile expenditures with the general ledger, leading to inaccurate reporting to the U.S. Department of the Treasury.
  • Impacted Requirements: Key reporting items, including current and cumulative obligations and expenditures, were not accurately reported as per compliance guidelines.
  • Recommended Follow-Up: The Town should establish procedures to ensure all federal reporting aligns with the general ledger to prevent future discrepancies.

Finding Text

2025-002 U.S. Department of Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Material Weakness 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. Cause: The Town did not have procedures in place to perform reconciliations of required grant reporting. Effect: It was determined that the Town recorded overstated expenditures by $427,507 in reporting submitted to the U.S. Department of the Treasury. 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

Recommendation: The Town should implement procedures to reconcile all federal reporting to the general ledger. Response: A full reconciliation of the ARPA accounts has been performed and aligned with the previous compliance reporting. A chart of accounts conversion is under way which will segregate federal funds from one fund to six funds for comprehensive oversight in the general ledger.

Categories

Subrecipient Monitoring Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1228622 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $319,073
97.025 NATIONAL URBAN SEARCH AND RESCUE (US&R) RESPONSE SYSTEM $235,195
66.468 DRINKING WATER STATE REVOLVING FUND $88,828
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $70,754
10.553 SCHOOL BREAKFAST PROGRAM $29,734
16.922 EQUITABLE SHARING PROGRAM $21,622
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $21,000
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $20,000
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $20,000
84.425 EDUCATION STABILIZATION FUND $18,073
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $17,698
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $13,483
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $10,000
84.027 SPECIAL EDUCATION GRANTS TO STATES $7,077
66.806 SUPERFUND TECHNICAL ASSISTANCE GRANTS (TAG) FOR COMMUNITY GROUPS AT NATIONAL PRIORITY LIST (NPL) SITES $5,817
10.555 NATIONAL SCHOOL LUNCH PROGRAM $5,479
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $4,600
10.575 FARM TO SCHOOL GRANT PROGRAM $3,344