Finding 1554 (2022-004)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-11-09
Audit: 2802
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: The County failed to accurately report project details and expenditures in federal award reports, leading to significant deficiencies in internal controls.
  • Impacted Requirements: Compliance with Uniform Grant Guidance (2 CFR 200.303) was not met, as internal controls were insufficient to ensure accurate reporting.
  • Recommended Follow-Up: Strengthen review procedures for reports and ensure documentation of the review process, including all relevant project expenditure details.

Finding Text

2022 – 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. Effective internal controls should include ensuring the reported projects and expenditures accurately reflect what is reported in the expenditure detail. Condition: While the correct expenditures were reported on the schedule of expenditures of federal awards, the expenditure report filed during the year did not accurately report project details, including amounts expended and subrecipient entity types as contractors, beneficiaries, or subrecipients. In addition, there is no formal documentation of the review being completed by the County Administrator in accordance with the County’s internal control procedures. Questioned costs: None Context: The County incorrectly reported current projects and expenditures in 3 of 3 reports tested. Cause: Subaward and subrecipient types were not clearly distinguished. Revenue replacement reported was based on the full $10,000,000 lost revenue election, and not amounts of the revenue replacement used for expenses incurred through the reporting date. These details were inaccurately reported due to unclear instructions. There was no documentation of review and approval by a County Administrator. Effect: Noncompliance with reporting requirements. Repeat Finding: No Recommendation: We recommend the County strengthen its review procedures over reports and ensure the review is documented. The reports should include project expenditures incurred during the period and all applicable data elements. Views of responsible officials: There is no disagreement with the audit finding.

Corrective Action Plan

Action taken in response to finding: All required reporting of the Coronavirus State & Local Fiscal Recovery Fund will be sent to the County Administrator for review and approval in a timely manner of the reports being submitted to the Federal reviewing agency. Documentation of review and approval will be kept along with other supporting documentation for the program. Name(s) of the contact person(s) responsible for corrective action: Eric Black, Chief Deputy Auditor Planned completion date for corrective action plan: November 1, 2023

Categories

Subrecipient Monitoring Reporting Significant Deficiency

Other Findings in this Audit

  • 1553 2022-003
    Significant Deficiency Repeat
  • 1555 2022-005
    Material Weakness
  • 1556 2022-006
    Material Weakness
  • 1557 2022-007
    Material Weakness
  • 1558 2022-008
    Significant Deficiency
  • 1559 2022-005
    Material Weakness
  • 1560 2022-006
    Material Weakness
  • 1561 2022-007
    Material Weakness
  • 1562 2022-008
    Significant Deficiency
  • 1563 2022-005
    Material Weakness
  • 1564 2022-006
    Material Weakness
  • 1565 2022-007
    Material Weakness
  • 1566 2022-008
    Significant Deficiency
  • 577995 2022-003
    Significant Deficiency Repeat
  • 577996 2022-004
    Significant Deficiency
  • 577997 2022-005
    Material Weakness
  • 577998 2022-006
    Material Weakness
  • 577999 2022-007
    Material Weakness
  • 578000 2022-008
    Significant Deficiency
  • 578001 2022-005
    Material Weakness
  • 578002 2022-006
    Material Weakness
  • 578003 2022-007
    Material Weakness
  • 578004 2022-008
    Significant Deficiency
  • 578005 2022-005
    Material Weakness
  • 578006 2022-006
    Material Weakness
  • 578007 2022-007
    Material Weakness
  • 578008 2022-008
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.04M
93.568 Low-Income Home Energy Assistance $1.09M
17.278 Wia Dislocated Worker Formula Grants $433,514
93.788 Opioid Str $325,361
20.509 Formula Grants for Rural Areas and Tribal Transit Program $319,011
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $304,959
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $269,893
17.258 Wia Adult Program $256,434
93.563 Child Support Enforcement $173,669
20.205 Highway Planning and Construction $125,585
81.042 Weatherization Assistance for Low-Income Persons $120,472
93.268 Immunization Cooperative Agreements $117,717
93.569 Community Services Block Grant $97,094
16.922 Equitable Sharing Program $93,959
17.259 Wia Youth Activities $79,946
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $75,493
93.069 Public Health Emergency Preparedness $49,178
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $38,057
16.575 Crime Victim Assistance $35,943
93.667 Social Services Block Grant $34,559
97.039 Hazard Mitigation Grant $31,782
20.616 National Priority Safety Programs $19,980
93.586 State Court Improvement Program $16,754
97.042 Emergency Management Performance Grants $7,411
17.277 Workforce Investment Act (wia) National Emergency Grants $6,617
90.404 2018 Hava Election Security Grants $6,338
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $5,630
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,246
10.555 National School Lunch Program $1,768
66.605 Performance Partnership Grants $1,508
93.994 Maternal and Child Health Services Block Grant to the States $1,103
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000
10.553 School Breakfast Program $598
17.245 Trade Adjustment Assistance $65