Audit 365342

FY End
2024-11-30
Total Expended
$22.44M
Findings
30
Programs
34
Organization: Sangamon County, Illinois (IL)
Year: 2024 Accepted: 2025-09-02

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
575298 2024-003 Significant Deficiency Yes H
575299 2024-003 Significant Deficiency Yes H
575300 2024-003 Significant Deficiency Yes H
575301 2024-003 Significant Deficiency Yes H
575302 2024-003 Significant Deficiency Yes H
575303 2024-004 Material Weakness Yes C
575304 2024-004 Material Weakness Yes C
575305 2024-004 Material Weakness Yes C
575306 2024-004 Material Weakness Yes C
575307 2024-004 Material Weakness Yes C
575308 2024-005 Material Weakness Yes L
575309 2024-005 Material Weakness Yes L
575310 2024-005 Material Weakness Yes L
575311 2024-005 Material Weakness Yes L
575312 2024-005 Material Weakness Yes L
1151740 2024-003 Significant Deficiency Yes H
1151741 2024-003 Significant Deficiency Yes H
1151742 2024-003 Significant Deficiency Yes H
1151743 2024-003 Significant Deficiency Yes H
1151744 2024-003 Significant Deficiency Yes H
1151745 2024-004 Material Weakness Yes C
1151746 2024-004 Material Weakness Yes C
1151747 2024-004 Material Weakness Yes C
1151748 2024-004 Material Weakness Yes C
1151749 2024-004 Material Weakness Yes C
1151750 2024-005 Material Weakness Yes L
1151751 2024-005 Material Weakness Yes L
1151752 2024-005 Material Weakness Yes L
1151753 2024-005 Material Weakness Yes L
1151754 2024-005 Material Weakness Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.38M Yes 0
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $272,385 - 0
93.788 Opioid Str $253,162 - 0
16.575 Crime Victim Assistance $244,552 - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $228,684 - 0
20.205 Highway Planning and Construction $204,500 - 0
17.258 Wioa Adult Program $172,969 - 0
17.259 Wioa Youth Activities $149,753 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $127,737 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $124,282 - 0
93.568 Low-Income Home Energy Assistance $102,903 Yes 3
17.278 Wioa Dislocated Worker Formula Grants $94,895 - 0
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $94,401 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $93,061 - 0
81.042 Weatherization Assistance for Low-Income Persons $85,169 - 0
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $55,343 - 0
93.069 Public Health Emergency Preparedness $49,944 - 0
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $49,744 - 0
16.922 Equitable Sharing Program $31,277 - 0
93.667 Social Services Block Grant $24,885 - 0
90.404 Hava Election Security Grants $23,373 - 0
93.569 Community Services Block Grant $23,333 - 0
93.994 Maternal and Child Health Services Block Grant to the States $13,150 - 0
20.616 National Priority Safety Programs $11,809 - 0
97.042 Emergency Management Performance Grants $10,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $9,711 - 0
93.008 Medical Reserve Corps Small Grant Program $6,444 - 0
93.563 Child Support Services $6,431 - 0
93.103 Food and Drug Administration Research $5,000 - 0
93.268 Immunization Cooperative Agreements $2,500 - 0
93.586 State Court Improvement Program $1,941 - 0
10.572 Wic Farmers' Market Nutrition Program (fmnp) $1,000 - 0
93.940 Hiv Prevention Activities Health Department Based $932 - 0
66.605 Performance Partnership Grants $647 - 0

Contacts

Name Title Type
RJFZHS8UCLJ6 Eric Black Auditee
2177536654 Brian Mateas Auditor
No contacts on file

Notes to SEFA

Title: Loans Outstanding Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Sangamon County, Illinois (the County) under programs of the federal government for the year ended November 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). The County financial reporting entity, as defined in Note 1 to the basic financial statements, consists of the activities of the County and its’ discretely presented component units. The Springfield-Sangamon County Regional Planning Commission, the Emergency Telephone System Board, and the Land of Lincoln Workforce Alliance are discretely presented component units of the County, and their federal expenditures are included in the Schedule. All federal awards received directly from federal agencies, as well as federal awards passed through from other governmental agencies, are included on the Schedule. Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position or changes in financial position of the County. Expenditures reported on the Schedule are reported using the modified accrual basis of accounting for governmental funds and the accrual basis of accounting for the discretely presented component units, which are described in Note 1 to the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected to use the approved indirect cost rate proposals as allowed under the Uniform Guidance. The rates used in the fiscal period ended November 30, 2024 were 19.40% for the Regional Planning Commission, 8.01% for the Land of Lincoln Workforce Alliance, 14.20% for Community Resources, 8.60% for the Department of Public Health, and 19.80% for other County departments. The County had no outstanding loans at November 30, 2024.
Title: Nonmonetary Assistance Accounting Policies: The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Sangamon County, Illinois (the County) under programs of the federal government for the year ended November 30, 2024. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). The County financial reporting entity, as defined in Note 1 to the basic financial statements, consists of the activities of the County and its’ discretely presented component units. The Springfield-Sangamon County Regional Planning Commission, the Emergency Telephone System Board, and the Land of Lincoln Workforce Alliance are discretely presented component units of the County, and their federal expenditures are included in the Schedule. All federal awards received directly from federal agencies, as well as federal awards passed through from other governmental agencies, are included on the Schedule. Because the Schedule presents only a selected portion of the operations of the County, it is not intended to and does not present the financial position or changes in financial position of the County. Expenditures reported on the Schedule are reported using the modified accrual basis of accounting for governmental funds and the accrual basis of accounting for the discretely presented component units, which are described in Note 1 to the basic financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. De Minimis Rate Used: N Rate Explanation: The County has elected to use the approved indirect cost rate proposals as allowed under the Uniform Guidance. The rates used in the fiscal period ended November 30, 2024 were 19.40% for the Regional Planning Commission, 8.01% for the Land of Lincoln Workforce Alliance, 14.20% for Community Resources, 8.60% for the Department of Public Health, and 19.80% for other County departments. Nonmonetary assistance is reported in the Schedule at the fair market value of the nonmonetary assistance received and disbursed. The County received nonmonetary assistance under Assistance Listing Number 10.572 as noted in the accompanying schedule of expenditures of federal awards. In addition, during the year ended November 30, 2024, Sangamon County did not receive federal insurance coverage or federal loan guarantees.

Finding Details

2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 003 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: G-2402LLIEA 6/1/2024; 2302ILLIEI 3/1/2023; G 2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038 Award Period: June 1, 2024 through September 30, 2025; March 1, 2023 through August 31, 2024; October 1, 2022 through August 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.308, 200.309, and 200.403(h)) requires that only allowable costs incurred during the approved budget period of a federal award’s period of performance be charged to the award. Effective internal controls should include procedures that involve costs charged to federal awards being reviewed and approved for proper period of performance. Condition: The County charged costs to the federal award after the end of the period of performance. Furthermore, although payroll transactions charged to the federal award were reviewed and approved, documentation of such review was not retained. Questioned Costs: $706 Context: 4 of 97 transactions tested were incurred after the period of performance end date. All 18 payroll transactions tested lacked documentation of review and approval. Cause: Costs were inadvertently claimed outside the period of performance. Documentation of review and approval for payroll transactions was also not retained. Effect: Charging costs outside the period of performance can result in unallowable costs being charged to federal awards, which could lead to noncompliance with federal requirements and potential repayment obligations. Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-005. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 003 Period of Performance (Continued) Recommendation: We recommend that the County review and strengthen its internal controls to ensure that only costs incurred within the period of performance are charged. Costs charged to federal awards should be reviewed and approved for proper period of performance, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 004 Cash Management 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-274038; 23-224038; 24-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.305(b)) requires non-federal entities to minimize the time between drawing and disbursing of federal funds; interest should also be calculated on amounts of unearned revenue. Effective internal controls should include procedures that involve reimbursement requests being reviewed and approved prior to submission. Condition: There were instances in which reimbursement requests did not agree to the County’s accounting records or to the amounts reported on the SEFA. The time between receiving and disbursing federal funds was not minimized, and interest on unearned revenue was not calculated. Furthermore, reimbursement requests were not reviewed and approved prior to submission, and documentation of such review was not retained. Questioned Costs: $132,322 Context: 2 of 8 reimbursement requests tested did not have supporting documentation for the exact amount received. All 8 reimbursement requests tested lacked documentation of review and approval prior to submission. Cause: Supporting documentation for reimbursement requests was not complete; specifically, adjustments made to the project accounting records after the reimbursement requests were submitted caused the County to receive more funds than expenditures incurred on specific grants. Documentation of review and approval for reimbursement requests was also not retained. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 004 Cash Management (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-006. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to reimbursement requests and that supporting documentation is retained. Reconciliations should be reviewed and approved by an individual other than the preparer prior to submission, and documentation of such review should be retained. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.
2024 – 005 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-2302ILLIEA 6/1/2023; G-2302ILLIEA 10/1/2022 Pass-Through Agency: Illinois Department of Commerce and Economic Opportunity Pass-Through Numbers: 23-221038; 23-224038 Award Period: June 1, 2023 through September 30, 2024; October 1, 2022 through August 31, 2024 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.328 and 2 CFR 200.329)) requires non-federal entities to submit performance and financial reports as required by the pass-through entity award and to ensure that the data accumulated and summarized is in accordance with the required criteria and methodology. Effective internal controls should ensure grant closeout reports are supported by documentation of expenditures that have been incurred. Additionally, grant agreements requiring grant closeout reports should be reconciled to the accounting records. Condition: The County did not retain supporting documentation for closeout performance reports. Accounting records supporting the SEFA did not reconcile to the certified cost reported in the closeout financial reports. There were also instances where federal reimbursements did not align with project accounting code records. Questioned Costs: None Context: 2 of 3 closeout performance reports tested lacked supporting documentation. 2 of 3 closeout financial reports tested did not reconcile to the accounting records supporting the SEFA or to the project accounting code records. Cause: Supporting documentation for closeout performance reports was not retained. Additionally, adjustments made to the project accounting records after submission of the closeout financial reports and reconciliations resulted in discrepancies between reported and actual cost. Effect: Lack of proper documentation and reconciliation can result in over- or under-reimbursement of federal grant funds, potentially leading to noncompliance with federal requirements and potential repayment obligations. Section III – Findings and Questioned Costs – Major Federal Programs (Continued) 2024 – 005 Reporting (Continued) Repeat Finding: The finding is a repeat of a finding in the prior year. The prior year finding number was 2023-007. Recommendation: We recommend that the County design and implement internal controls to ensure accounting records reconcile to grant closeout reports and that supporting documentation is retained. A detailed, documented review of all reports should be conducted by someone other than the preparer to ensure completeness and accuracy. No financial activity should be recorded to the project accounting records after grant closeout reports are completed. Views of Responsible Officials: There is no disagreement with the audit finding.