Finding 1170261 (2024-007)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2026-01-22

AI Summary

  • Core Issue: The Town failed to reconcile its Project and Expenditure report with the general ledger, leading to a $29,900 discrepancy in reported expenditures.
  • Impacted Requirements: Compliance with 2 CFR section 200.328, which mandates accurate reporting of program outlays and income.
  • Recommended Follow-Up: Establish procedures to ensure reconciliation of financial reports with the general ledger prior to submission.

Finding Text

2024-007 U.S. Department of Treasury COVID-19 – Coronavirus State and Local Fiscal Recovery Funds – ALN 21.027 Significant Deficiency in Internal Controls over Compliance and Compliance Finding Criteria: Per 2 CFR section 200.328 of the Uniform Guidance, each recipient must report program outlays and program income on a cash or accrual basis, as prescribed by the federal agency. The compliance supplement identified 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. Condition: As of the March 31, 2024 reporting date, the Town’s Project and Expenditure report had reported cumulative expenditures that were approximately $29,900 less than what was recorded in the grant fund on the general ledger. Cause: The Town did not reconcile the Project and Expenditure report with the Town’s general ledger before submitting. Effect: The Town did not properly report grant expenditures in the Project and Expenditure reporting. Questioned Costs: None Repeat Finding from Prior Year: Yes; Finding 2023-008 Recommendation: The Town should implement procedures to reconcile the financial information in the Project and Expenditure reports to the Town’s general ledger before submission. Views of Responsible Official: Management agrees with the finding.

Corrective Action Plan

Significant Deficiency in Internal Controls over Compliance Condition: As of the March 31, 2024 reporting date, the Town’s Project and Expenditure report had reported cumulative expenditures that were approximately $29,900 less than what was recorded in the grant fund on the general ledger Corrective Action Planned: FY2026 Grant activity is being reconciled to the General Leger with the help of the outside consultant. This process will be completed by the end of January, 2026. In FY26 reconciliation will be performed quarterly, and will be up to date no later than end of March 2026. Anticipated Completion Date: March 2026 Contact: Anna Noyes, Town Accountant

Categories

Reporting Significant Deficiency Program Income Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1170245 2024-004
    Material Weakness Repeat
  • 1170246 2024-004
    Material Weakness Repeat
  • 1170247 2024-004
    Material Weakness Repeat
  • 1170248 2024-004
    Material Weakness Repeat
  • 1170249 2024-004
    Material Weakness Repeat
  • 1170250 2024-004
    Material Weakness Repeat
  • 1170251 2024-004
    Material Weakness Repeat
  • 1170252 2024-004
    Material Weakness Repeat
  • 1170253 2024-005
    Material Weakness Repeat
  • 1170254 2024-005
    Material Weakness Repeat
  • 1170255 2024-005
    Material Weakness Repeat
  • 1170256 2024-005
    Material Weakness Repeat
  • 1170257 2024-006
    Material Weakness Repeat
  • 1170258 2024-006
    Material Weakness Repeat
  • 1170259 2024-006
    Material Weakness Repeat
  • 1170260 2024-006
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.425 EDUCATION STABILIZATION FUND $555,247
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $546,348
10.553 SCHOOL BREAKFAST PROGRAM $243,801
10.555 NATIONAL SCHOOL LUNCH PROGRAM $72,180
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $47,423
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $14,965
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $3,390
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $2,579
84.027 SPECIAL EDUCATION GRANTS TO STATES $628
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $39