Assistance Listing, Federal Agency, and Program Name - 21.027, U.S. Department of the Treasury, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number and Year - 38080710K, 2022 Pass-through Entity - Illinois Department of Public Health (IDPH) Finding Type - Material weakness and material noncompliance with laws and regulations Repeat Finding - No Criteria - Per 2 CFR 200.303, the recipient must establish, document, and maintain effective internal control over the federal award that provides reasonable assurance that the recipient or subrecipient is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. These internal controls should align with the guidance in Standards for Internal Control in the Federal Government, issued by the Comptroller General of the United States, or the Internal Control-Integrated Framework, issued by the Committee of Sponsoring Organizations (COSO). Per 2 CFR 200.403, except where otherwise authorized by statute, in order to be allowable under Federal awards, costs must be determined in accordance with generally accepted accounting principles (GAAP), incurred during the approved budget period, and adequately documented. Per 2 CFR 200.510, the auditee must prepare a schedule of federal expenditures (SEFA) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. Per 2 CFR 200.328, the funding agency establishes the financial reporting basis of accounting. Based on the reimbursement certificate template required by the passthrough funding agency, the recipient should report expenditures from expense activity, as well as cash or in-kind matching contributions where applicable. Condition - Management lacked adequate controls at the transaction level to ensure compliance with activities allowed or unallowed, allowable cost principles, and period of performance, which resulted in the improper inclusion of duplicate costs and costs from a prior fiscal period. Further, a lack of effective controls over financial reporting and over preparation of the SEFA resulted in management reporting activity on a cash basis, inconsistent with the basis of reporting established in Note 1 and with requirements established by the passthrough funding agency. Questioned Costs - $109,149 If Questioned Costs Are Not Determinable, Description of Why Known Questioned Costs Were Undetermined or Otherwise Could Not Be Reported - N/A Identification of How Questioned Costs Were Computed - Questioned costs totaling $49,754 represent a duplicate invoice found as the result of compliance testing. An additional $59,395 of costs were identified during compliance testing from invoices for goods or services received during fiscal year 2022. Context - During a walkthrough of management's processes and controls, we noted management did not have controls in place at the invoice level for 2 of the 3 vendors charged to the program during the fiscal period under audit to ensure compliance with activities allowed or unallowed, allowable cost principles, or period of performance. As the result of compliance testing, we identified 1 invoice in the amount of $49,754 out of 60 samples that was a duplicate transaction of another sample. As the result of compliance testing, we identified 7 out of 60 transactions totaling $59,395 incurred during the fiscal year ended September 30, 2022. Through discussions with management and in an effort to reconcile the SEFA to underlying general ledger expenditure activity incurred during the fiscal period under audit, we noted that the amount on the SEFA reflected cash reimbursed by IDPH and not expenditures incurred during the fiscal period. In addition, for 2 of the 4 quarterly financial reports selected for testing, we noted that amounts requested for reimbursement for those periods were overstated by approximately $217,000 in aggregate, in relation to the underlying expenditure activity incurred at the time of the submission of the financial report to and request for reimbursement from IDPH. Cause and Effect - A lack of effective controls over the preparation of the SEFA could result in material inaccuracies to the SEFA. A lack of effective controls at the transaction level resulted in noncompliance with accounting principles, duplicate charges to the program, and questioned costs. A lack of effective controls over financial reporting resulted in noncompliance with reporting requirements and an inaccurate reflection of activity incurred during the period reported. Recommendation - We recommend management implement effective controls at the transaction level to ensure costs are allowable under the terms and conditions of the grant agreement have not been duplicated within the population of costs charged to the program and are in compliance with cost principles outlined within the Uniform Guidance. In addition, we recommend that management review the Uniform Guidance and grant agreements carefully to understand the required basis of accounting and to implement an effective set of controls to ensure compliance with these requirements. Views of Responsible Officials and Corrective Action Plan - Management has implemented a new review and oversight process related to the process for the grant submissions in question.