Finding 3565 (2022-001)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-12-06
Audit: 5564
Organization: Holt, County of (MO)

AI Summary

  • Core Issue: The County's schedules of expenditures of federal awards (SEFA) for 2021 and 2022 contained errors, failing to accurately reflect actual federal expenditures.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) was not met due to lack of internal controls over SEFA preparation and reconciliation with accounting records.
  • Recommended Follow-Up: Implement robust internal controls for SEFA preparation to ensure accuracy and completeness of federal award expenditures.

Finding Text

Federal Grantor: U.S. Department of Agriculture, U.S. Department of Housing and Urban Development, 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 Health and Senior Services, Missouri Department of Transportation, Missouri Department of Public Safety, and Missouri State Treasurer Federal ALN Number: 10.557, 10.923, 14.228, 16.607, 16.738, 20.205, 21.019, 21.027, 93.069, 93.767, 93.994 and 97.036 Program Title: Special Supplemental Nutrition Program for Women, Infants, and Children; Emergency Watershed Protection Program; Community Development Block Grants; Patrick Leahy Bulletproof Vest Partnership; Edward Byrne Memorial Justice Assistance Grant Program; Highway Planning and Construction; Coronavirus Relief Fund; Coronavirus State and Local Fiscal Recovery Funds; Public Health Emergency Preparedness; Local Public Health Services; Maternal and Child Health Services Block Grant; Disaster Grants – Public Assistance (Presidentially Declared Disasters) Pass-through Entity Identifying Number: ERS04520077, ERS04522105, N2919WEP0010014, BRO-B044(35), BRO-B044(36-38), DH1800040521, DH210048512, DH220050467, AOC19380006, DH220051086, DH190011039, DR-4435, DR-4451, DR-4612 Award Year: 2021 and 2022 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, 2020 and 2019 as item 2020-001. 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. Discrepancies in amounts reported on the 2022 SEFA and amount supported by underlying accounting records are summarized as follows: Discrepancies in amounts reported on the 2021 SEFA and amount supported by underlying accounting records are summarized as follows: 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. Reasons for discrepancies in individual programs varied. 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, 2022 and 2021. 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. County’s Response: Beginning in 2023, the Holt County Clerk has implemented a process to obtain award letters from grant writers and documenting the funding details. The Holt County Clerk is looking into software which is able to track projects year over year to make reporting more manageable. Auditor’s Evaluation: The response is appropriate to correct the concern.

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 3557 2022-001
    Material Weakness Repeat
  • 3558 2022-001
    Material Weakness Repeat
  • 3559 2022-001
    Material Weakness Repeat
  • 3560 2022-001
    Material Weakness Repeat
  • 3561 2022-001
    Material Weakness Repeat
  • 3562 2022-001
    Material Weakness Repeat
  • 3563 2022-001
    Material Weakness Repeat
  • 3564 2022-001
    Material Weakness Repeat
  • 3566 2022-001
    Material Weakness Repeat
  • 3567 2022-001
    Material Weakness Repeat
  • 3568 2022-001
    Material Weakness Repeat
  • 3569 2022-001
    Material Weakness Repeat
  • 3570 2022-001
    Material Weakness Repeat
  • 3571 2022-001
    Material Weakness Repeat
  • 3572 2022-001
    Material Weakness Repeat
  • 3573 2022-001
    Material Weakness Repeat
  • 3574 2022-001
    Material Weakness Repeat
  • 3575 2022-001
    Material Weakness Repeat
  • 579999 2022-001
    Material Weakness Repeat
  • 580000 2022-001
    Material Weakness Repeat
  • 580001 2022-001
    Material Weakness Repeat
  • 580002 2022-001
    Material Weakness Repeat
  • 580003 2022-001
    Material Weakness Repeat
  • 580004 2022-001
    Material Weakness Repeat
  • 580005 2022-001
    Material Weakness Repeat
  • 580006 2022-001
    Material Weakness Repeat
  • 580007 2022-001
    Material Weakness Repeat
  • 580008 2022-001
    Material Weakness Repeat
  • 580009 2022-001
    Material Weakness Repeat
  • 580010 2022-001
    Material Weakness Repeat
  • 580011 2022-001
    Material Weakness Repeat
  • 580012 2022-001
    Material Weakness Repeat
  • 580013 2022-001
    Material Weakness Repeat
  • 580014 2022-001
    Material Weakness Repeat
  • 580015 2022-001
    Material Weakness Repeat
  • 580016 2022-001
    Material Weakness Repeat
  • 580017 2022-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $388,274
10.923 Emergency Watershed Protection Program $246,487
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $157,887
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $31,843
16.738 Edward Byrne Memorial Justice Assistance Grant Program $7,360
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $7,191
93.767 Children's Health Insurance Program $5,128
93.069 Public Health Emergency Preparedness $3,224
93.994 Maternal and Child Health Services Block Grant to the States $3,177
16.607 Bulletproof Vest Partnership Program $2,743
20.205 Highway Planning and Construction $2,000
21.019 Coronavirus Relief Fund $1,805