Finding 1176192 (2025-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-03-03
Audit: 390015

AI Summary

  • Core Issue: The City reported inaccurate current period obligations and expenditures in the Project and Expenditure Report for COVID-19 funds.
  • Impacted Requirements: Compliance with 2 CFR 200.328 and 31 CFR section 35.4(c) regarding accurate reporting and internal controls.
  • Recommended Follow-Up: Strengthen policies and enhance supervisory reviews to ensure accurate reporting before submission.

Finding Text

Finding: Reporting Federal Program: COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Assistance Listing No.: 21.027 Federal Agency: Department of Treasury Criteria or Specific Requirement: In accordance with 2 CFR 200.328 and 31 CFR section 35.4(c), recipients must adhere to the Treasury’s Recipient Compliance and Reporting Responsibilities, which require accurate completion of the annual Project and Expenditure Report. Required reporting elements include current period obligation, cumulative obligation, current period expenditure, and cumulative expenditure. Management is responsible for establishing and maintaining effective internal control to ensure compliance with these reporting requirements. Condition: The current period obligation and current period expenditures reported in the annual Project and Expenditure Report were inaccurate and did not reflect the underlying supporting documentation. Cause: The City’s internal controls and supervisory review procedures over the preparation of the Project and Expenditure Report were not operating effectively, resulting in incorrect amounts being reported. Effect or Potential Effect: Inaccurate reporting may impair the Department of Treasury’s oversight and monitoring efforts and could result in the City being viewed as noncompliant with federal reporting requirements. Questioned Costs: None reported. Context: During our testing, we recalculated the current period obligation and current period expenditure amounts and identified discrepancies when compared to the amounts submitted in the annual Project and Expenditure Report to the Department of Treasury. Identification as a Repeat Finding: N/A Recommendation: Management should strengthen existing policies and procedures to ensure accurate calculation and reporting of key line items within the Project and Expenditure Report. This should include enhanced supervisory review to verify the accuracy and completeness of the report prior to submission. Views of Responsible Officials: We agree with the finding. See separate report for planned corrective action plan.

Corrective Action Plan

Corrective Action Plan for Finding 2025-001 We are in receipt of the Finding Required to be reported by the Uniform Guidance regarding the Reporting Compliance Requirement. Management agrees with the finding. The discrepancy in current-year reporting resulted from a computational oversight caused by a formula error within the reporting templates. Where possible, we will add automated check figures to the reporting spreadsheets to validate data accuracy and strengthen internal review procedures. Jamie Moore, Accounting Manager, will be responsible for ensuring this is accomplished. The correction action plan will be implemented by September 30, 2026.

Categories

Reporting Internal Control / Segregation of Duties Subrecipient Monitoring

Programs in Audit

ALN Program Name Expenditures
21.027 COVID-19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.33M
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $286,420
87.002 VIRGINIA GRAEME BAKER POOL AND SPA SAFETY $216,921
16.575 CRIME VICTIM ASSISTANCE $171,658
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $121,792
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $74,959
16.922 EQUITABLE SHARING PROGRAM $60,641
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $30,862
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $14,375
21.016 EQUITABLE SHARING $2,688
97.039 HAZARD MITIGATION GRANT $1,371