Finding 1206076 (2025-001)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2025
Accepted
2026-04-07
Audit: 397998
Organization: City of Webster (TX)
Auditor: CROWE LLP

AI Summary

  • Core Issue: The City failed to submit reimbursement requests for federal expenditures, leading to an incomplete Schedule of Expenditures of Federal Awards (SEFA) and missing the threshold for a Single Audit.
  • Impacted Requirements: Non-compliance with 2 CFR §200.303, §200.501, and §200.510(b) due to insufficient internal controls and decentralized grant administration.
  • Recommended Follow-Up: Centralize grant oversight, implement monitoring procedures, conduct periodic reconciliations, and provide training on Uniform Guidance to ensure compliance and accuracy in future SEFAs.

Finding Text

Finding: 2025-001. Insufficient Controls Over Monitoring Federal Expenditures and SEFA Preparation Federal Agency: Federal Highway Administration Pass-through Agency: Texas Department of Transportation Assistance Listing Number: 20.205 Federal Program Name: Highway Planning and Construction Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR §200.303 requires entities to establish and maintain effective internal control over Federal awards that provides reasonable assurance the entity is managing the awards in compliance with Federal statutes, regulations, and the terms and conditions of the awards. 2 CFR §200.501 requires a Single Audit when a non-Federal entity expends $1,000,000 or more in Federal awards during the current fiscal year (or $750,000 during the prior year). 2 CFR §200.510(b) requires the preparation of a complete and accurate Schedule of Expenditures of Federal Awards (SEFA). Applicable GAAP requires recognition of grant revenue and related receivables when allowable expenditures are incurred. Condition: The City incurred reimbursable federal expenditures in the prior year but did not submit reimbursement requests or record the related receivable and revenue. As a result, certain federal expenditures were omitted from the SEFA, and total federal expenditures were understated below the $750,000 threshold for a Single Audit in the prior year. Cause: Grant administration is decentralized across multiple departments, and formal controls were not in place to reconcile grant expenditures to reimbursement requests or to monitor total federal expenditures and review the SEFA for completeness. Effect: Grant revenue and related receivables were understated, and the prior year SEFA was incomplete. As a result, the City did not include this grant award in the Single Audit in the prior year as required by Uniform Guidance. Questioned costs: N/A Context: N/A Repeat finding reference: N/A Recommendation: The City should strengthen oversight of federal grant activity by implementing procedures to monitor federal expenditures and ensure the SEFA is complete and accurate. This may include centralizing grant oversight within the finance function or designating a responsible grant administrator. Procedures should include periodic reconciliations of grant expenditures to reimbursement requests and a formal year-end review of total federal expenditures and the SEFA, with coordination between the finance function and departments administering federal programs. Personnel involved in grant administration should receive training on Uniform Guidance requirements. View of Responsible Officials Management’s response and corrective action plan are included in the accompanying corrective action plan.

Corrective Action Plan

2025-001: Insufficient Controls Over Monitoring Federal Expenditures and SEFA Preparation (Significant Deficiency) The City concurs with the finding and will strengthen controls over monitoring federal expenditures and preparation of the Schedule of Expenditures of Federal Awards (SEFA). The Finance Department will implement centralized oversight of federal grant activity and maintain a grant tracking schedule to monitor cumulative federal expenditures by program, including reimbursements and receivables. Departments administering federal programs will be required to report grant expenditures to Finance, and periodic reconciliations will be performed between departmental records, reimbursement requests submitted to the pass-through agency, and amounts recorded in the general ledger. At year-end, the Finance Department will prepare the SEFA and perform a formal management review to ensure all federal expenditures are complete and accurately reported and evaluated against the Single Audit threshold in accordance with Uniform Guidance. Personnel involved in grant administration will receive training on applicable Uniform Guidance requirements to support compliance with federal reporting and monitoring requirements. Anticipated Completion Date: June 2026

Categories

Reporting Internal Control / Segregation of Duties Subrecipient Monitoring Cash Management Significant Deficiency Matching / Level of Effort / Earmarking

Programs in Audit

ALN Program Name Expenditures
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.35M
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $242,764
97.039 HAZARD MITIGATION GRANT $152,400
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $90,527
97.067 HOMELAND SECURITY GRANT PROGRAM $79,061