Finding 1206556 (2024-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-04-14
Audit: 398631
Organization: Town of Natick, Massachusetts (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The Town inaccurately reported expenditures in quarterly performance reports, leading to discrepancies with the general ledger.
  • Impacted Requirements: Compliance with the American Rescue Plan Act and Uniform Guidance mandates accurate financial reporting of actual expenditures.
  • Recommended Follow-Up: Implement procedures to ensure reported expenditures align with actual amounts recorded in the general ledger for the reporting period.

Finding Text

2024-005 Improve Internal Controls Over Reporting Federal Agency: Department of the Treasury Award Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding Compliance Internal Control over Compliance – Significant Deficiency Criteria: Under the requirements of the American Rescue Plan Act (ARPA) State and Local Fiscal Recovery Funds program, the Town must submit quarterly performance and evaluation reports reflecting accurate and complete financial information, including current period and cumulative expenditures, in accordance with program requirements and the Uniform Guidance. Reported expenditures should correspond to actual amounts expended in the entity’s general ledger for the reporting period. Condition: During testing of two quarterly performance and evaluation (P&E) reports, filed during fiscal year 2024, variances were identified in both current period and cumulative expenditures as compared to the general ledger detail. These variances were primarily due to timing differences. Specifically, the Town reported revenue replacement funds as current period expenditures upon appropriation and approval from the Town meeting in the P&E report, even though the corresponding actual expenditures in the general ledger occurred in a subsequent period. Cause: The Town did not have sufficient controls in place to ensure that expenditures reported on the P&E reports were aligned with the actual amounts expended and recorded in the general ledger for the reporting period. Effect: Reporting expenditures in the P&E report before they are actually incurred and recorded in the general ledger can result in inaccurate financial reporting to the federal awarding agency, reducing the reliability and transparency of the Town’s compliance reporting. Recommendation: The Town should develop and implement procedures to ensure that expenditures reported on quarterly performance and evaluation reports are based on actual amounts expended and recorded in the general ledger during the reporting period, rather than amounts approved or planned for future expenditure. Views of Responsible Official: Management’s corrective action plan is included at the end of this report after the Schedule of Prior Year Findings.

Corrective Action Plan

2024-005 Improve Internal Controls Over Reporting Federal Agency: Department of the Treasury Award Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Award Year: 2024 Compliance Requirement: Reporting Type of Finding: Compliance Internal Control over Compliance – Significant Deficiency Criteria: Under the requirements of the American Rescue Plan Act (ARPA) State and Local Fiscal Recovery Funds program, the Town must submit quarterly performance and evaluation reports reflecting accurate and complete financial information, including current period and cumulative expenditures, in accordance with program requirements and the Uniform Guidance. Reported expenditures should correspond to actual amounts expended in the entity’s general ledger for the reporting period. Condition: During testing of two quarterly performance and evaluation (P&E) reports, filed during fiscal year 2024, variances were identified in both current period and cumulative expenditures as compared to the general ledger detail. These variances were primarily due to timing differences. Specifically, the Town reported revenue replacement funds as current period expenditures upon appropriation and approval from the Town meeting in the P&E report, even though the corresponding actual expenditures in the general ledger occurred in a subsequent period. Cause: The Town did not have sufficient controls in place to ensure that expenditures reported on the P&E reports were aligned with the actual amounts expended and recorded in the general ledger for the reporting period. Effect: Reporting expenditures in the P&E report before they are actually incurred and recorded in the general ledger can result in inaccurate financial reporting to the federal awarding agency, reducing the reliability and transparency of the Town’s compliance reporting. Recommendation: The Town should develop and implement procedures to ensure that expenditures reported on quarterly performance and evaluation reports are based on actual amounts expended and recorded in the general ledger during the reporting period, rather than amounts approved or planned for future expenditure. Views of Responsible Official: The Town implemented a Grants Management Policy related to federal awards required under the Uniform Guidance. The adopted policy addresses the concerns identified in 2024-005.

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1206539 2024-003
    Material Weakness Repeat
  • 1206540 2024-003
    Material Weakness Repeat
  • 1206541 2024-003
    Material Weakness Repeat
  • 1206542 2024-003
    Material Weakness Repeat
  • 1206543 2024-003
    Material Weakness Repeat
  • 1206544 2024-003
    Material Weakness Repeat
  • 1206545 2024-003
    Material Weakness Repeat
  • 1206546 2024-003
    Material Weakness Repeat
  • 1206547 2024-003
    Material Weakness Repeat
  • 1206548 2024-003
    Material Weakness Repeat
  • 1206549 2024-003
    Material Weakness Repeat
  • 1206550 2024-003
    Material Weakness Repeat
  • 1206551 2024-003
    Material Weakness Repeat
  • 1206552 2024-003
    Material Weakness Repeat
  • 1206553 2024-003
    Material Weakness Repeat
  • 1206554 2024-003
    Material Weakness Repeat
  • 1206555 2024-004
    Material Weakness Repeat
  • 1206557 2024-003
    Material Weakness Repeat
  • 1206558 2024-003
    Material Weakness Repeat
  • 1206559 2024-003
    Material Weakness Repeat
  • 1206560 2024-003
    Material Weakness Repeat
  • 1206561 2024-003
    Material Weakness Repeat
  • 1206562 2024-003
    Material Weakness Repeat
  • 1206563 2024-003
    Material Weakness Repeat
  • 1206564 2024-003
    Material Weakness Repeat
  • 1206565 2024-003
    Material Weakness Repeat
  • 1206566 2024-003
    Material Weakness Repeat
  • 1206567 2024-003
    Material Weakness Repeat
  • 1206568 2024-003
    Material Weakness Repeat
  • 1206569 2024-003
    Material Weakness Repeat
  • 1206570 2024-003
    Material Weakness Repeat
  • 1206571 2024-003
    Material Weakness Repeat
  • 1206572 2024-003
    Material Weakness Repeat
  • 1206573 2024-003
    Material Weakness Repeat
  • 1206574 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $3.50M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $640,218
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $220,042
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $148,183
10.553 SCHOOL BREAKFAST PROGRAM $144,140
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $111,836
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $99,035
84.027 SPECIAL EDUCATION GRANTS TO STATES $37,096
16.922 EQUITABLE SHARING PROGRAM $24,964
16.004 LAW ENFORCEMENT ASSISTANCE NARCOTICS AND DANGEROUS DRUGS TRAINING $21,337
93.421 STRENGTHENING PUBLIC HEALTH SYSTEMS AND SERVICES THROUGH NATIONAL PARTNERSHIPS TO IMPROVE AND PROTECT THE NATION’S HEALTH $15,665
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $14,772
84.425 COVID-19 EDUCATION STABILIZATION FUND $11,217
81.086 CONSERVATION RESEARCH AND DEVELOPMENT $10,880
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $9,260
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $5,459
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $5,450
93.103 FOOD AND DRUG ADMINISTRATION RESEARCH $4,058
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $2,280
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $2,222
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $637