Finding 584488 (2021-002)

Significant Deficiency Repeat Finding
Requirement
P
Questioned Costs
-
Year
2021
Accepted
2024-01-09

AI Summary

  • Core Issue: The County's schedule of expenditures of federal awards (SEFA) for 2021 and 2022 contained errors, failing to accurately report federal expenditures.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) is lacking, as the County did not ensure completeness and accuracy in SEFA preparation.
  • Recommended Follow-Up: Implement internal controls, including reconciliations and independent reviews, to ensure accurate reporting of federal award expenditures annually.

Finding Text

Federal Grantor: U.S. Department of Agriculture, U.S. Department of Justice U.S. Department of Transportation, U.S. Department of the Treasury, Election Assistance Commission, U.S. Department of Health and Human Services, and U.S. Department of Homeland Security Pass-Through Grantor: Missouri Department of Transportation, and Missouri Department of Public Safety, Missouri State Treasurer’s Office, Missouri Secretary of State, Missouri Department of Social Services Federal Assistance Listing Number: 10.904, 16.575, 16.607, 20.205, 21.019, 21.027, 90.401, 93.563, 97.036 and 97.042 Program Title: Watershed Protection and Flood Prevention; Crime Victim Assistance; Bulletproof Vest Partnership Program; Highway Planning and Construction; COVID-19 - Coronavirus Relief Fund; COVID-19 -Coronavirus State and Local Fiscal Recovery Funds; Help America Vote Act Requirements Payments; Child Support Enforcement; Disaster Grants – Public Assistance Grants (Presidentially Declared Disasters); Emergency Management Performance Grants Pass-through Entity Identifying Number: 69-6424-13-001, NR206424XXXXC080, ER130200072, 2020BUBX2002120, 2021BUBX21027755, BRO-B013(40), ER10220C010, 4451-DR-MO, 4490-DR-MO, EMK-2019-EP-00001-0SL04, EMK-2020-EP-00004-18, EMK-2021-EP-00006-018 Award Year: 2020 and 2021 Questioned Costs: None Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards which must report total federal awards expended during the audit period. At a minimum, the schedule must include: expenditures by individual federal program, name of the pass-through entity and identifying number for awards not received directly from the federal government, and the total amount provided to subrecipients from each federal program. The County has not implemented proper internal controls to ensure the completeness and accuracy of the SEFA. This finding was noted in the prior audit for the years ended December 31, 2019 and 2018 as item 2019-005. Condition: The schedules of expenditures of federal awards (SEFA) reported by the County in the 2021 and 2022 annual budget documents contained errors in amounts of federal expenditures reported. Cause: The County has not implemented a proper system of internal control over SEFA preparation, such as a reconciliation to underlying accounting records or having a separate individual review the SEFA for clerical accuracy after it has been prepared. Effect: The SEFA presented for audit did not accurately reflect the County’s actual expenditures of federal awards for both the years ended December 31, 2021 and 2020. Recommendation: We recommend that the County implement internal controls to ensure that the SEFA completely and accurately states the expenditures of federal awards of the County each year.

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 8038 2021-002
    Significant Deficiency Repeat
  • 8039 2021-002
    Significant Deficiency Repeat
  • 8040 2021-002
    Significant Deficiency Repeat
  • 8041 2021-002
    Significant Deficiency Repeat
  • 8042 2021-002
    Significant Deficiency Repeat
  • 8043 2021-002
    Significant Deficiency Repeat
  • 8044 2021-002
    Significant Deficiency Repeat
  • 8045 2021-002
    Significant Deficiency Repeat
  • 8046 2021-002
    Significant Deficiency Repeat
  • 8047 2021-002
    Significant Deficiency Repeat
  • 8048 2021-002
    Significant Deficiency Repeat
  • 8049 2021-002
    Significant Deficiency Repeat
  • 8050 2021-002
    Significant Deficiency Repeat
  • 8051 2021-002
    Significant Deficiency Repeat
  • 584480 2021-002
    Significant Deficiency Repeat
  • 584481 2021-002
    Significant Deficiency Repeat
  • 584482 2021-002
    Significant Deficiency Repeat
  • 584483 2021-002
    Significant Deficiency Repeat
  • 584484 2021-002
    Significant Deficiency Repeat
  • 584485 2021-002
    Significant Deficiency Repeat
  • 584486 2021-002
    Significant Deficiency Repeat
  • 584487 2021-002
    Significant Deficiency Repeat
  • 584489 2021-002
    Significant Deficiency Repeat
  • 584490 2021-002
    Significant Deficiency Repeat
  • 584491 2021-002
    Significant Deficiency Repeat
  • 584492 2021-002
    Significant Deficiency Repeat
  • 584493 2021-002
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
10.904 Watershed Protection and Flood Prevention $1.29M
21.019 Coronavirus Relief Fund $1.09M
93.563 Child Support Enforcement $237,390
21.027 Coronavirus State and Local Fiscal Recovery Funds $134,354
20.205 Highway Planning and Construction $102,340
16.575 Crime Victim Assistance $91,328
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $60,962
90.401 Help America Vote Act Requirements Payments $22,541
97.042 Emergency Management Performance Grants $12,110
16.607 Bulletproof Vest Partnership Program $6,932