Finding 1215089 (2023-003)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2026-05-20
Audit: 401792
Organization: CEDAR COUNTY, MISSOURI (MO)

AI Summary

  • Core Issue: The County's Schedule of Expenditures of Federal Awards (SEFA) is inaccurate due to a lack of internal controls.
  • Impacted Requirements: Compliance with 2 CFR 200.510(b) is not met, as the SEFA fails to report total federal awards accurately.
  • Recommended Follow-Up: Implement internal controls, including reconciliations and independent reviews, to ensure SEFA accuracy moving forward.

Finding Text

2023-003: Internal Control Over Schedule of Expenditures of Federal Awards Federal Grantor: U.S. Department of Agriculture (USDA), U.S. Department of the Interior (Interior), U.S. Department of Justice (DOJ), U.S. Department of Transportation (DOT), U.S. Department of the Treasury (Treasury), and U.S. Department of Health and Human Services (HHS) Pass-Through Grantor: Missouri Department of Health and Senior Services, Missouri Department of Public Safety, and Missouri Department of Transportation Federal Assistance Listing Number: 10.557, 10.665, 15.226, 16.738, 20.205, 21.027, 93.069, 93.323, 93.354, 93.767, 93.778, 93.967 and 93.994 Program Title: Special Supplemental Nutrition Program for Women, Infants, and Children; Schools and Roads – Grants to States; Payments in Lieu of Taxes; Edward Byrne Memorial Justice Assistance Grant Program; Highway Planning and Construction; Coronavirus State and Local Fiscal Recovery Funds; Public Health Emergency Preparedness; Epidemiology and Laboratory Capacity for Infectious Diseases; Public Health Emergency Response; Children’s Health Insurance Program; Grants to States for Medicaid; CDC Collaboration with Academia to Strengthen Public Health; Maternal and Child Health Services Block Grant Pass-through Entity Identifying Number: ERS04523109, BRO-B020(18), BRO-B020(19), SLFRP4542-CJMI005, DH220051995, DH2200517449, CK000546-01B, DH230051996, DH220051742, OE00007201A1, DH220051847 Award Year: 2022 and 2023 Questioned Costs: None Criteria: 2 CFR 200.510(b) requires auditees to prepare a schedule of expenditures of federal awards (SEFA) 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. Condition: The SEFA reported by the County in the 2023 and 2024 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 2023 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, 2023 and 2022. 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.

Corrective Action Plan

The County has implemented a process of internal controls where expenditures are tracked in a manner that will coincide with reporting requirements for state expenditures for SEFA reporting.

Categories

Subrecipient Monitoring Reporting

Other Findings in this Audit

  • 1215075 2023-003
    Material Weakness Repeat
  • 1215076 2023-003
    Material Weakness Repeat
  • 1215077 2023-003
    Material Weakness Repeat
  • 1215078 2023-003
    Material Weakness Repeat
  • 1215079 2023-003
    Material Weakness Repeat
  • 1215080 2023-003
    Material Weakness Repeat
  • 1215081 2023-003
    Material Weakness Repeat
  • 1215082 2023-003
    Material Weakness Repeat
  • 1215083 2023-003
    Material Weakness Repeat
  • 1215084 2023-003
    Material Weakness Repeat
  • 1215085 2023-003
    Material Weakness Repeat
  • 1215086 2023-003
    Material Weakness Repeat
  • 1215087 2023-003
    Material Weakness Repeat
  • 1215088 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
15.226 PAYMENTS IN LIEU OF TAXES $163,380
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $162,303
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $138,771
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $96,009
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $90,494
12.112 PAYMENTS TO STATES IN LIEU OF REAL ESTATE TAXES $80,267
16.575 CRIME VICTIM ASSISTANCE $45,857
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $43,756
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $40,624
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $34,125
90.404 HAVA ELECTION SECURITY GRANTS $15,290
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $8,943
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $8,196
20.205 HIGHWAY PLANNING AND CONSTRUCTION $5,180
97.067 HOMELAND SECURITY GRANT PROGRAM $4,998
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $4,589