Finding 501773 (2023-007)

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

AI Summary

  • Core Issue: There is a material weakness in internal controls over compliance, specifically regarding financial reporting and documentation retention.
  • Impacted Requirements: Failure to meet Uniform Grant Guidance (2 CFR 200.303 and 200.329) for maintaining accurate records and timely submissions.
  • Recommended Follow-Up: Implement controls to ensure accounting records reconcile with reports, retain necessary documentation, and conduct independent reviews of all reports before submission.

Finding Text

2023 – 007 Reporting 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: G-2202ILLIEA 10/1/2021; G-2202ILLIEA 10/1/2021; G-2302ILLIEA 10/1/2022; 2102ILLWCS 5/28/2021 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 22-221038; 22-224038; 23-224038; 21-233038 Award Period: June 1, 2022 through September 30, 2023, October 1, 2021 through June 30, 2023, October 1, 2022 through June 30, 2024, and September 1, 2021 through August 31, 2023 Type of Finding: • Material Weakness 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 financial reports required by the pass through entity 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 periodic financial reporting be supported by documentation of expenditures that have been incurred. In addition, grant agreements requiring grant close-out reports should reconcile to the accounting records. Condition: Supporting documentation for the periodic financial reporting accounting records were not maintained. Additionally, the accounting records supporting the SEFA did not agree to the grant reconciliation submitted with the grant close-out packages tested, and they were not filed by the due date. Questioned costs: None Context: 5 of 5 periodic financial reports tested did not have supporting documentation retained. 3 of 3 financial close out reports did not reconcile to supporting documentation and were late. Cause: Support for the periodic financial reports could not be provided as it was not retained. Adjustments made to the project accounting records after the close-out report package was submitted caused the report to have inaccurate information. Effect: Lack of proper documentation for reported information can lead to an over or under reporting of grant expenditures. Repeat Finding: This is a repeat finding. Prior year finding number was 2022-007. Recommendation: We recommend the County design controls to ensure the accounting records reconcile to the periodic financial reporting and grant close-out reports and documentation be retained. A detailed, documented review of all reports should occur by someone other than the preparer, to ensure the reports are accurate, supported, and filed timely. No financial activity should be recorded to the project accounting records after the grant close out report package is completed. Views of responsible officials: There is no disagreement with the audit finding.

Corrective Action Plan

Low-Income Home Energy Assistance Program (LIHEAP) – Assistance Listing No. 93.568 Recommendation: We recommend the County design controls to ensure the accounting records reconcile to the periodic financial reporting and grant close-out reports and documentation be retained. A detailed, documented review of all reports should occur by someone other than the preparer, to ensure the reports are accurate, supported, and filed timely. No financial activity should be recorded to the project accounting records after the grant close out report package is completed. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: County department personnel changes have been implemented which address this deficiency. New department personnel have been properly trained by County Auditor staff as well as State grantor personnel to ensure proper compliance with all program requirements. Community Resources staff have been trained on keeping proper detailed records of all grant reports. Name(s) of the contact person(s) responsible for corrective action: Dave MacDonna, Director of Community Resources. Planned completion date for corrective action plan: July 1, 2024

Categories

Reporting Material Weakness Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 501770 2023-003
    Significant Deficiency Repeat
  • 501771 2023-004
    Significant Deficiency Repeat
  • 501772 2023-006
    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
  • 1078213 2023-004
    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