Finding 1149762 (2022-002)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2025-08-12
Audit: 364126
Organization: City of Wapakoneta (OH)

AI Summary

  • Core Issue: The City omitted a federally funded program from its Schedule of Expenditures of Federal Awards (SEFA), leading to a material misstatement of $1,484,064.
  • Impacted Requirements: Compliance with 2 CFR §200.510(b) regarding accurate reporting of federal awards, including proper identification of programs and expenditures.
  • Recommended Follow-Up: The City should enhance its process for identifying federal awards to prevent future reporting errors.

Finding Text

Material Weakness/Noncompliance – Other 2 CFR §200.510(b) states, in part, that the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended. At a minimum, the schedule must: a. List individual federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the Federal agency. b. For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. c. Provide total Federal awards expended for each individual Federal program and the Assistance Listing Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. d. Include the total amount provided to subrecipients from each Federal program. e. For loan or loan guarantee programs described in §200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. f. Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in §200.414. Subsequent to the original issuance of the 2022 audit report dated November 17, 2023, with the assistance of the pass-through entity, it was determined that the City omitted a federally funded program under the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205). The related expenditures of $1,484,064, were excluded from the City’s originally provided SEFA. The City failed to properly identify/communicate the federal designation of the project. Inaccurate completion of the SEFA could lead to inaccurate reporting of federal expenditures by the City and could jeopardize future federal funding. The City’s originally provided SEFA for 2022 was materially misstated by the exclusion of the Highway Planning and Construction Cluster (Highway Planning and Construction - AUG CR 25A 3.29 - ALN 20.205), in the amount of $1,484,064. We recommend that the City review the process for identifying federal awards to minimize the likelihood of errors in the reporting process. Officials Response: See Corrective Action Plan

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 573320 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
66.468 Capitalization Grants for Drinking Water State Revolving Funds $15.06M
20.205 Highway Planning and Construction - Aug Cr 25a 3.29 $1.48M
21.019 Covid-19 - Coronavirus Relief Fund $104,548