Finding 1187257 (2024-004)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-03-26
Audit: 394853
Organization: Town of Brookline (MA)
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: The Town has significant weaknesses in internal controls over reporting for federal funds, leading to discrepancies in financial reports.
  • Impacted Requirements: Compliance with the American Rescue Plan Act requires accurate quarterly reports and adequate support for revenue loss calculations.
  • Recommended Follow-Up: Implement formal procedures for report reconciliation, independent reviews, and maintain all supporting documentation for accuracy and compliance.

Finding Text

Finding 2024-004: Improve Internal Controls Over Reporting Federal Program(s) Information Federal Agency: Department of the Treasury Award Name: COVID-19 - 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 – Material Weakness Criteria or Specific Requirement Under the American Rescue Plan Act (ARPA) State and Local Fiscal Recovery Funds (SLFRF), the Town is required to submit accurate and complete quarterly performance and evaluation reports in accordance with program requirements. Amounts reported, including current period and cumulative expenditures, must be supported by the entity’s general ledger and any variances be explained. When electing to calculate revenue loss rather than applying the standard $10 million allowance, the recipient must maintain adequate support for the calculation and ensure the amounts reported are accurate and supported. Recipients are also required to maintain effective internal controls, including documented review of reports prior to submission. Condition and Context During our audit, we sampled two quarterly performance and evaluation reports submitted for the ARPA program and identified discrepancies in both current period and cumulative expenditures reported as compared to the amounts recorded in the general ledger detail. Further, there was no evidence of a documented, independent review of the reports prior to their submission to the agency. Additionally, the Town elected to calculate revenue loss using the Treasury’s revenue loss formula rather than taking the standard one-time $10 million allowance. The underlying documentation provided to support the Town’s revenue loss calculation did not agree to the amounts reported on the quarterly performance and evaluation reports. The discrepancies resulted from issues in the original report query used to build the calculation and from the Town not maintaining reports used to build the calculation. Cause The Town did not maintain effective internal controls over the reporting process to ensure reported expenditures and revenue loss amounts are accurate and supported by underlying accounting records. There were no formal procedures in place for independent review of the reports prior to submission and supporting records for the revenue loss calculation were not properly maintained. Effect or Potential Effect Inaccurate reporting and lack of sufficient documentation could lead to misstatements in federally required reports and increase the risk of administrative noncompliance. No questioned costs are reported as the Town did not overclaim lost revenue amounts and the requirement is administrative in nature. Recommendation The Town should establish and implement formal procedures to ensure quarterly reports submitted to the federal agency are reconciled to the general ledger, subject to a documented independent review, and supported by retained source documentation. In addition, we recommend the Town maintain all underlying records used in the calculation of revenue loss for audit and reporting purposes and adjust performance and evaluation reports on a prospective basis to reflect appropriate amounts. Views of Responsible Official See corrective action plan included herein.

Corrective Action Plan

Audit Finding Reference: 2024-004 Improve Internal Controls Over Reporting Planned Corrective Action: The Town will establish and implement formal procedures to ensure quarterly reports submitted to the federal agency are reconciled to the general ledger, subject to a documented independent review, and support by retained source documentation. Planned Implementation Date of Corrective Action: The revenue loss calculation was corrected on April 23, 2025, effective with the Quarter 1, 2025 (January–March) reporting period. The independent review process will begin on January 30, 2026.

Categories

Reporting Material Weakness

Other Findings in this Audit

  • 1187242 2024-005
    Material Weakness Repeat
  • 1187243 2024-005
    Material Weakness Repeat
  • 1187244 2024-005
    Material Weakness Repeat
  • 1187245 2024-005
    Material Weakness Repeat
  • 1187246 2024-005
    Material Weakness Repeat
  • 1187247 2024-005
    Material Weakness Repeat
  • 1187248 2024-006
    Material Weakness Repeat
  • 1187249 2024-006
    Material Weakness Repeat
  • 1187250 2024-006
    Material Weakness Repeat
  • 1187251 2024-006
    Material Weakness Repeat
  • 1187252 2024-006
    Material Weakness Repeat
  • 1187253 2024-006
    Material Weakness Repeat
  • 1187254 2024-003
    Material Weakness Repeat
  • 1187255 2024-003
    Material Weakness Repeat
  • 1187256 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 COVID-19 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $1.21M
10.555 NATIONAL SCHOOL LUNCH PROGRAM $786,838
84.425 EDUCATION STABILIZATION FUND - ESSER II $295,682
97.067 HOMELAND SECURITY GRANT PROGRAM $270,936
10.555 COVID-19 NATIONAL SCHOOL LUNCH PROGRAM $200,177
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $182,106
97.036 COVID-19 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $156,987
84.027 SPECIAL EDUCATION GRANTS TO STATES $149,793
10.553 SCHOOL BREAKFAST PROGRAM $98,513
84.027 COVID-19 SPECIAL EDUCATION GRANTS TO STATES $70,853
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $65,619
84.425 EDUCATION STABILIZATION FUND - ESSER III $60,562
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $44,307
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $40,608
84.425 EDUCATION STABILIZATION FUND - SUMMER LEARNING GRANT $40,490
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $26,433
97.044 ASSISTANCE TO FIREFIGHTERS GRANT $26,008
84.425 EDUCATION STABILIZATION FUND - SEL & MENTAL HEALTH GRANT $20,800
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $20,499
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $12,383
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $11,930
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $10,683
84.425 EDUCATION STABILIZATION FUND - CHRONIC ABSENTEEISM FUNDS $9,042
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $8,945
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $7,631
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $4,702
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $2,139
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $1,333
84.173 COVID-19 SPECIAL EDUCATION PRESCHOOL GRANTS $943
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $725
84.126 REHABILITATION SERVICES VOCATIONAL REHABILITATION GRANTS TO STATES $110