Finding 1164611 (2024-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-12-12
Audit: 374218
Organization: Town of Cohasset (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The Town's reports to the U.S. Treasury had discrepancies, with current and cumulative expenditures not matching the general ledger by $99,207 and $102,022.
  • Impacted Requirements: Compliance with OMB’s Uniform Administrative Requirements for accurate and timely reporting is not being met, leading to significant deficiencies in internal controls.
  • Recommended Follow-Up: The Town should establish better internal controls to verify report accuracy and ensure timely submission of reports to avoid future discrepancies.

Finding Text

2024-001 Improve Internal Controls Over Reporting Federal Agency: U.S. Department of the Treasury Award Name: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds AL Number(s): 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance - Significant Deficiency Criteria or Specific Requirement OMB’s Uniform Administrative Requirement, Cost Principles, and Audit Requirements for Federal Awards (UG) requires that grant recipients design internal controls to ensure that reports submitted to the State/Federal government are complete and accurate. Management is also responsible for establishing and maintaining effective internal controls over compliance with federal requirements that have a direct and material effect on a federal program. A deficiency in internal control over compliance exists when the design or operation of a control over compliance does not allow management or employees, in the normal course of performing their assigned functions, to prevent, or detect and correct, noncompliance with a type of compliance requirement of a federal program on a timely basis. Condition and Context Key line items, specifically current period expenditures and total cumulative expenditures, included on the submitted annual project and expenditure report to the U.S. Treasury did not agree to the general ledger. The amounts reported as current period and cumulative expenditures on the project and expenditure report did not reconcile to the Town’s underlying accounting records by $99,207 and $102,022, respectively. In addition, the Town did not submit the project and expenditure report by the April 30, 2024 due date. The project and expenditure report was submitted on March 17, 2025. Cause The Town did not have a control implemented to verify the accuracy of the reports prior to submission. Effect or Potential Effect Due to the weaknesses in internal control noted above, key line items on reports submitted may not be complete, accurate or timely. No questioned costs are reported as it is not quantifiable. Recommendation The Town should design and implement improved internal controls to ensure that reports are reviewed in detail and agreed back to the general ledger prior to submission to ensure completeness and accuracy. The Town should also implement processes to ensure timely submission of the project and expenditure report. Views of Responsible Officials Management agrees with the finding.

Corrective Action Plan

Planned Corrective Action: All future ARPA reporting will be derived from trial balances generated from the accounting department staff. The trial balances will then be reviewed and entered into the reporting portal by the Town Manager by the reporting due date. Any variances or adjustments that are necessary from the trial balance will be clearly documented for reconciliation and confirmed by the Town Accountant as accurate. Upon confirmation, the Town Manager will submit the portal. Planned Implementation Date of Corrective Action: March 2026 P&E Report (due by April 30, 2026) Person Responsible for Corrective Action: Town Accountant Town Manager

Categories

Allowable Costs / Cost Principles Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1164609 2024-001
    Material Weakness Repeat
  • 1164610 2024-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $322,827
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $271,969
93.276 DRUG-FREE COMMUNITIES SUPPORT PROGRAM GRANTS $133,640
10.555 NATIONAL SCHOOL LUNCH PROGRAM $95,744
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $73,271
10.555 COVID-19 NATIONAL SCHOOL LUNCH PROGRAM $47,698
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $38,916
84.425 COVID-19 EDUCATION STABILIZATION FUND $26,900
10.553 SCHOOL BREAKFAST PROGRAM $25,988
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $17,414
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $10,559
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $8,175
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $5,107
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $3,327
84.027 SPECIAL EDUCATION GRANTS TO STATES $2,361
15.616 CLEAN VESSEL ACT $1,114
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $85