Finding 1218097 (2025-001)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2025
Accepted
2026-06-22
Audit: 404277
Organization: City of Wentzville, Missouri (MO)
Auditor: UHY LLP

AI Summary

  • Core Issue: The City’s controls failed to ensure accurate Project and Expenditure (P&E) reports, leading to significant under-reporting of expenditures.
  • Impacted Requirements: Reports were not prepared for the correct period, violating guidelines for grant expense documentation and accuracy.
  • Recommended Follow-Up: Management should enhance procedures for preparing and reviewing reports, including verifying reporting periods and reconciling data with the general ledger.

Finding Text

Reporting NONCOMPLIANCE Condition: Controls in place did not provide for the accuracy of the Project and Expenditure (P&E) reports submitted annually. Annual reports are not being prepared using the defined reporting period, in addition to other errors in the information reported. As a result, expenditure amounts reported were not accurate per Department’s Annual Project and Expenditure Report Timeline. Criteria: Effective controls over grants ensures allowable grant expenses are accurately captured and documented to support reporting requirements. Internal worksheets and other documents prepared for annual reporting should be reviewed for accuracy, prior to preparation and submission. Cause: The City lacked adequate procedures over the preparation and review of the P&E reports. Effect: The City prepared and submitted the annual P&E reports for 2025 for the calendar year ending December 31, 2024, versus the required 12 months ending March 31st. This resulted in inaccurate totals for the reporting period. For the 12 months ended March 31, 2025, the P&E report’s current expenditures were under-reported by $933,692 and should have been $6,725,932 for the period April 1, 2024 to March 31, 2025. As a result, the current expenditures for the reporting period March 31, 2026 were over-reported. Recommendation: Management should continue to evaluate procedures for preparing and reviewing grant reports prior to submission to Department of Treasury. Procedures should include verifying grant period reporting requirements, reconciling report information to general ledger activity, and additional oversight and monitoring over submission of reports. Grantee’s Response: Management concurs. Due to the fact that all remaining grant funds were expended during the current grant reporting period, all previously unreported balances were included in the current year annual year for reporting year ending March 31, 2026.

Corrective Action Plan

Management will continue to evaluate its controls concerning current federal awards and requirements to ensure that accurate information is captured and reported. Anticipated completion date: Already implemented and all final grant expenditures included in final annual report for reporting period ending March 31, 2026.

Categories

Subrecipient Monitoring Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1218098 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $2.00M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $48,608
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $20,835
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $8,430
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $6,804
20.607 ALCOHOL OPEN CONTAINER REQUIREMENTS $5,909
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,753