Finding 1078213 (2023-004)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-10-04
Audit: 323864
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: The County has a significant deficiency in internal controls, leading to inaccurate reporting of project details and expenditures.
  • Impacted Requirements: Compliance with Uniform Grant Guidance (2 CFR 200.303 and 200.329) is not met, as cumulative expenditures and obligations were incorrectly reported.
  • Recommended Follow-Up: Strengthen review procedures to ensure reported amounts reconcile with project accounting records to avoid future noncompliance.

Finding Text

2023 – 004 Reporting Federal Agency: U.S. Department of Treasury Federal Program Name: Coronavirus State and Local Fiscal Recovery Funds Assistance Listing Number: 21.027 Federal Award Identification Number and Year: SLFRP3738 11/30/2021 Award Period: March 3, 2021 through December 31, 2024 Type of Finding: • Significant Deficiency in Internal Control over Compliance • Other Matters Criteria or specific requirement: Uniform Grant Guidance (2 CFR 200.303) requires non-federal entities receiving Federal awards establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Uniform Grant Guidance (2 CFR 200.329) requires non-federal entities submit performance reports required by Federal award and that the data accumulated and summarized is in accordance with the required or stated criteria and methodology. Effective internal controls should include ensuring the reported projects and expenditures accurately reflect what is reported in the expenditure detail and amounts obligated should reflect total procurement amounts awarded. Condition: While the correct expenditures were reported on the schedule of expenditures of federal awards, the expenditure reports filed during the year did not accurately report project details. Cumulative expenditures should report amounts expended through the end of the period and cumulative obligations should report total procurement amounts awarded. Questioned costs: None Context: The County incorrectly reported cumulative expenditures and cumulative obligations in 4 of 4 reports tested. Cause: Total cumulative expenditures were not reconciled to total amounts reported in the ledger. Reported project obligations were based on projects costs that been incurred and not contract sum awarded. Effect: Noncompliance with reporting requirements. Repeat Finding: This finding is a partial repeat of a finding in the prior year. The prior year finding number was 2022-004. Recommendation: We recommend the County strengthen its review procedures over reports. Total cumulative expenditures and total cumulative obligations reported should reconcile to the total amounts reported in the project accounting records used to support the SEFA. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Reporting

Other Findings in this Audit

  • 501770 2023-003
    Significant Deficiency Repeat
  • 501771 2023-004
    Significant Deficiency Repeat
  • 501772 2023-006
    Material Weakness Repeat
  • 501773 2023-007
    Material Weakness Repeat
  • 501774 2023-005
    Material Weakness Repeat
  • 501775 2023-006
    Material Weakness Repeat
  • 501776 2023-007
    Material Weakness Repeat
  • 501777 2023-005
    Material Weakness Repeat
  • 501778 2023-006
    Material Weakness Repeat
  • 501779 2023-007
    Material Weakness Repeat
  • 501780 2023-006
    Material Weakness Repeat
  • 501781 2023-007
    Material Weakness Repeat
  • 1078212 2023-003
    Significant Deficiency Repeat
  • 1078214 2023-006
    Material Weakness Repeat
  • 1078215 2023-007
    Material Weakness Repeat
  • 1078216 2023-005
    Material Weakness Repeat
  • 1078217 2023-006
    Material Weakness Repeat
  • 1078218 2023-007
    Material Weakness Repeat
  • 1078219 2023-005
    Material Weakness Repeat
  • 1078220 2023-006
    Material Weakness Repeat
  • 1078221 2023-007
    Material Weakness Repeat
  • 1078222 2023-006
    Material Weakness Repeat
  • 1078223 2023-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $8.67M
93.568 Low-Income Home Energy Assistance $1.88M
93.569 Community Services Block Grant $561,099
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $275,103
16.575 Crime Victim Assistance $233,299
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $214,084
17.258 Wioa Adult Program $209,362
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $200,707
17.278 Wioa Dislocated Worker Formula Grants $166,793
20.205 Highway Planning and Construction $132,436
93.788 Opioid Str $127,575
20.509 Formula Grants for Rural Areas and Tribal Transit Program $127,026
93.667 Social Services Block Grant $126,494
17.259 Wioa Youth Activities $102,440
21.032 Local Assistance and Tribal Consistency Fund $100,000
93.959 Block Grants for Prevention and Treatment of Substance Abuse $97,263
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $86,487
81.042 Weatherization Assistance for Low-Income Persons $85,023
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $68,972
16.922 Equitable Sharing Program $68,099
93.069 Public Health Emergency Preparedness $43,555
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $29,881
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $16,656
93.994 Maternal and Child Health Services Block Grant to the States $13,885
93.563 Child Support Services $13,672
97.042 Emergency Management Performance Grants $10,003
20.616 National Priority Safety Programs $2,132
10.553 School Breakfast Program $1,003
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000
66.605 Performance Partnership Grants $888
93.268 Immunization Cooperative Agreements $769