Finding 387734 (2022-001)

Assistance Listing, Federal Agency, and Program Name - Assistance Listing 66.443, Environmental Protection Agency, Reducing Lead in Drinking Water Federal Award Identification Number and Year - OOE02968, 2021 Pass-through Entity - n/a Finding Type - Material weakness Repeat Finding - No Criteria - 2 CFR 200.508 requires the City to prepare appropriate financial statements, including the schedule of expenditures of federal awards (SEFA) in accordance with 2 CFR 200.510. The SEFA must list individual federal programs as required by 2 CFR 200.501(b)(1). The SEFA is the basis for the auditor determination of major programs as required by 2 CFR 200.518. Condition - The original SEFA prepared for audit purposes did not include all federal expenditures that should have been reported under ALN 66.443. Questioned Costs - None Identification of How Questioned Costs Were Computed - n/a Context - Approximately $864,000 of federal expenditures were not included in the original SEFA prepared for audit purposes under ALN 66.443. Cause and Effect - The City's controls over reconciling the SEFA to federal revenue did not detect the missing expenditures because federal revenue was not appropriately accrued by $864,000. As a result, ALN 66.443 was not originally identified as a major program. Recommendation - The City should review its controls over preparation of the SEFA and reconciling the SEFA to federal expenditures per the general ledger to ensure the appropriate amount of federal expenditures are reported on the SEFA. Views of Responsible Officials and Corrective Action Plan - We agree with the auditor’s recommendation. Changes have been implemented to ensure all programs with both federal and state/local funding will be examined to ensure correct expenditure by funding source is properly recorded.