Finding 578005 (2022-005)

Material Weakness
Requirement
H
Questioned Costs
$1
Year
2022
Accepted
2023-11-09
Audit: 2802
Organization: Sangamon County, Illinois (IL)

AI Summary

  • Core Issue: The County improperly allocated costs to federal awards after the end of the performance period, leading to potential unallowable costs.
  • Impacted Requirements: Compliance with Uniform Grant Guidance (2 CFR 200.303) was not met, as internal controls were insufficient to ensure costs were recorded within the grant period.
  • Recommended Follow-Up: The County should revise its cost allocation procedures and maintain documentation for manual journal entries to ensure compliance with grant requirements.

Finding Text

2022 – 005 Period of Performance Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Low-Income Home Energy Assistance Program (LIHEAP) Assistance Listing Number: 93.568 Federal Award Identification Number and Year: 2102ILLIEA 10/1/2020; 2102ILE5C6 03/22/2021 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 21-221038; 21-274038 Award Period: June 1, 2021 through September 30, 2022 and July 1, 2021 through September 30, 2022 Type of Finding: • Material Weakness in Internal Control over Compliance • Material Noncompliance (Modified Opinion) 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 procedures to ensure transactions for costs recorded for the end of the period of performance were not incurred after the period of performance for Federal awards. Additionally, manual journal entries should be supported by documentation for transactions that occurred during the period of performance. Condition: The County allocated costs to federal awards after the end of the period of performance. Documentation for manual adjusting journal entries was not maintained to ascertain transactions occurred during the period of performance. Questioned costs: $519,076 Context: 4 of 20 transactions tested were incurred after the period of performance end date. All 36 manual journal entries recorded to the programs did not have supporting documentation available. Cause: Costs were inadvertently claimed that fell outside the period of performance. Support for the accounting records could not be provided for the manual adjusting entries. Effect: May result in unallowable costs being charged to the Federal program. Repeat Finding: No Recommendation: We recommend the County review its procedures relative to allocating costs to Federal programs, and ensure only cost within the grant period are included. Supporting accounting records for manual adjusting journal entries should be maintained to support transactions incurred, with a documented approval process. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Questioned Costs Allowable Costs / Cost Principles Period of Performance

Other Findings in this Audit

  • 1553 2022-003
    Significant Deficiency Repeat
  • 1554 2022-004
    Significant Deficiency
  • 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
  • 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