Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
Assistance Listings number and name: 84.010 Title I Grants to Local Educational Agencies Award numbers and years: S010A180003, July 1, 2018 through September 30, 2019; S010A190003, July 1, 2019 through September 30, 2020; S010A200003, July 1, 2020 through September 30, 2021; S010A210003, July 1, 2021 through September 30, 2022 Assistance Listings numbers and names: 84.425C COVID-19 Governor’s Emergency Education Relief (GEER) Fund 84.425D COVID-19 Education Stabilization Fund—Elementary and Secondary School Emergency Relief (ESSER) Fund 84.425R COVID19 Education Stabilization Fund—Emergency Assistance to Non-Public Schools (EANS) 84.425U COVID-19 Education Stabilization Fund—American Rescue Plan—ESSER Fund (ARP ESSER) 84.425V COVID-19 Education Stabilization Fund—American Rescue Plan—Emergency Assistance to Non-Public Schools (ARP EANS) 84.425W COVID-19 Education Stabilization Fund—American Rescue Plan—Elementary and Secondary School Emergency Relief—Homeless Children and Youth Award numbers and years: ISA-ERMT-21-5008, July 1, 2020 through June 30,2021; ISA-GEER-ADE-070121-04, July 1, 2021 through June 30, 2023; ISA-GEER-ADE-070121-02, July 1, 2021 through June 30, 2023; S425D200038, May 11, 2020 through September 30, 2021; S425D210038, March 13, 2020 through September 30, 2023; S425R210003, April 23, 2021 through September 30, 2023; S425U210038, March 13, 2020 through September 30, 2024; S425V210003, February 18, 2022 through September 30, 2024; S425W210003, April 23, 2021 through September 30, 2023 Federal agency: U.S. Department of Education Compliance requirement: Not applicable Questioned costs: Not applicable Condition—Contrary to federal regulation and the State’s accounting manual, the Department of Education’s (Department) initially prepared schedule of expenditures of federal awards (SEFA), which totaled nearly $2.5 billion, contained significant errors that required correction for it to be reliable for determining federal programs to be audited and for inclusion in the State of Arizona’s SEFA. Specifically, the Department: • Understated expenditures for Title I—Grants to States (ALN 84.010) by over $318.3 million. • Overstated expenditures for the Education Stabilization Fund (ALN 84.245) by over $96.2 million. • Misstated total federal award expenditures by nearly $2.6 billion (gross error amount including those described above) for 42 of its 52 programs, which resulted in net overstatement of $37.5 million. • Misstated total expenditures passed through to subrecipients by nearly $3.5 billion (gross error amount) for 37 of its 52 programs, which resulted in a net overstatement of $8 million. • Inaccurately reported program titles for 14 programs and the wrong federal agency for 1 program. Effect—Although the Department corrected the significant misstatements we identified, the Department’s misstatements on its SEFA placed the State’s SEFA at risk of being misstated and potentially wasting public monies because misstated amounts could result in auditors unnecessarily auditing the wrong federal programs. Specifically, the Department’s misstatements on its SEFA could have resulted in it providing inaccurate information to the Arizona Department of Administration (ADOA) for inclusion in the State’s SEFA, which would have resulted in those who rely on the information it contains being misinformed, including ADOA, the Legislature, and federal agencies and pass-through grantors. This finding was not a result of internal control deficiencies of individual federal programs and accordingly, did not have a direct and material effect on the reporting requirements of the federal programs the Department administers. Cause—Although the Department is responsible for preparing a schedule of its federal award expenditures for inclusion in the State’s SEFA for the State’s single audit, it did not follow the requirements in the State’s accounting manual to compile all the federal award information necessary to prepare an accurate and complete SEFA. In addition, the Department’s reviews performed on its initially prepared SEFA were not effective to detect and correct these significant errors because the reviewers lacked training on the SEFA’s required content and how to obtain it. Criteria—Federal Uniform Guidance regulation requires the Department to separately identify in its accounts all federal awards received and expended and prepare an accurate and complete SEFA that reports its federal award expenditures for the year (2 Code of Federal Regulations [CFR] §§200.302 and 200.510). Further, the State’s accounting manual states that in order to reduce the number of deficiencies identified during the State-wide single audit, to better comply with the updated provisions of the federal Single Audit Act, and to increase the efficiency in compiling the State-wide SEFA, the revised formatting guidelines set forth in State’s accounting manual must be adhered to by any agency submitting an agency SEFA to ADOA’s General Accounting Office (State of Arizona Accounting Manual, Topic 70: Grants, Section 15). Finally, federal regulation requires establishing and maintaining effective internal control over federal awards that provides reasonable assurance that federal programs are being managed in compliance with all applicable laws, regulations, and award terms (2 CFR §200.303). Recommendations—To help ensure that it prepares a SEFA that is accurate and complete, the Department should: 1. Follow the State’s accounting manual requirements to compile all the federal award information necessary to prepare its SEFA, including the sources from which the information is to be obtained. 2. Require an effective and independent review of its SEFA to help ensure the SEFA is accurate and complete and complies with federal Uniform Guidance requirements prior to submitting it for audit. 3. Train those responsible for preparing and reviewing the SEFA on the State’s accounting manual requirements. The State’s corrective action plan at the end of this report includes the views and planned corrective action of its responsible officials. We are not required to audit and have not audited these responses and planned corrective actions and therefore provide no assurances as to their accuracy.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
CRITERIA/SPECIFIC REQUIREMENT: The Code of Federal Regulations (Code) (2 CFR §200.510 (b)), establishes criteria and requirements related to the preparation of the schedule of expenditures of federal awards. The Code (2 CFR §200.303 (a)) requires Regional Office of Education No. 39 (ROE) to establish and maintain effective internal control over the federal award to provide reasonable assurance the ROE is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Effective internal controls should include procedures over preparation of the schedule of expenditures of federal awards. CONDITION: The ROE did not have sufficient internal controls over the preparation of the Schedule of Expenditures of Federal Awards (SEFA) to ensure all federal expenditures during the fiscal year were reported and information in the SEFA was accurately reported. CONTEXT: During our review of the SEFA, we noted the following: • Program title descriptions were incorrect, and COVID-19-related grants were not properly identified in the program title. • Assistance listing numbers and pass-through grant numbers were incorrectly listed. • Federal expenditures did not match the expenditures in the general ledger. • Subrecipient expenditures were inappropriately reported on grants that did not actually have subrecipients: • The Education Stabilization Fund was not specifically categorized in the SEFA and the total federal awards expended for the program was not reported. The ROE subsequently revised its SEFA to correct these errors. EFFECT: Failure to report an accurate SEFA affects the required audit coverage to meet federal requirements and can delay an audit beyond the reporting deadline. CAUSE: Management indicated the errors on the SEFA was due to oversight. RECOMMENDATION: The ROE should establish and implement internal controls over preparation of the SEFA to ensure accurate reporting. MANAGEMENT’S RESPONSE: The ROE agrees with this finding.
Identification of federal program: US DEPARTMENT OF EDUCATION passed through the Indiana Department of Education: Charter Schools Program 84.282A. See finding in Section B. Criteria : According to 2 CFR Subpart F Section 200.510b, the auditee must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period that includes all amounts spent on federal programs during the reporting period. Condition : The SEFA under-reported the expenditures for Charter Schools Program (CSP) by $24,206. Cause : The School prepared the SEFA based on the federal revenue recorded, rather than the actual federal expenditures incurred. Effect : An audit adjustment of $24,206 was made to increase the federal expenditures reported on the SEFA for the CSP program. Questioned costs: none. Context: $24,406 out of $635,116 total program expenditures were omitted from the SEFA. Recommendation : We recommend that the School implement procedures whereby the SEFA is prepared based on federal expenditures incurred on a GAAP basis. View of responsible officials : See attached corrective action plan.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Human Services (IDHS) Federal Agency: U.S Department of Agriculture (USDA) U.S. Department of Health and Human Services (USDHHS) Program Name: Supplemental Nutrition Assistance Program Cluster Coronavirus State and Local Fiscal Recovery Funds Temporary Assistance for Needy Families Cluster CCDF Cluster Medicaid Cluster Block Grants for Prevention and Treatment of Substance Abuse ALN and Program Expenditures: 10.551/10.561 ($5,801,570,781) 21.027 ($4,895,262,395) 93.558 ($606,030,110) 93.575/93.596 ($941,280,574) 93.775/93.777/93.778 ($18,817,832,850) 93.959 ($81,408,580) Award Numbers: Various – See schedule of award numbers Federal Award Year: Various – See schedule of award numbers Questioned Costs: Cannot be determined Compliance Requirement: None Finding 2022-010: Inaccurate Reporting of Federal Expenditures Type of Finding: Noncompliance and material weakness Condition Found: IDHS did not accurately report Federal expenditures, including amounts provided to subrecipients, under the Supplemental Nutrition Assistance (SNAP) Cluster, Coronavirus State and Local Fiscal Recovery Funds (SLFRF), Temporary Assistance for Needy Families (TANF) Cluster, Child Care Development Funds (CCC) Cluster, Medicaid Cluster, and Block Grants for Prevention and Treatment of Substance Abuse (SAPT) programs. Federal expenditures, including amounts provided to subrecipients, reported to the Illinois Office of Comptroller (IOC) which were used to prepare the schedule of expenditure of federal awards (SEFA) did not agree to IDHS’ financial records provided for audit. Specifically, we noted the following differences between amounts provided for audit by IDHS and the SEFA amounts reported to the IOC for each program for the year ended June 30, 2022: Additionally, the following differences were identified relative to amounts provided to subrecipients for the following major programs: Additionally, we noted the cash basis expenditures provided by IDHS for our audit procedures included accrued (not paid) expenditures. We also noted these same amounts were reported to the IOC and were used to prepare the SEFA. Specifically, we noted expenditures that were not paid as of June 30, 2022, were erroneously reported as cash basis expenditures for the year ended June 30, 2022: Additionally, we noted in January 2023 IDHS discovered expenditures under its Home and Community Based Services (HCBS) waiver program had not been reported to the Illinois Department of Healthcare and Family Services (DHFS) for claiming under the Medicaid Cluster program since January 1, 2021. As a result, DHFS did not report expenditures totaling $508,822,206 paid by the State during the year ended June 30, 2022 on quarterly financial reports submitted to USDHHS. On July 31, 2023 the State provided a revised SEFA for the year ended June 30, 2022 which included a correction to add the previously unreported $508,822,206 of Medicaid Cluster HCBS expenditures. The addition of these expenditures delayed the completion of the State’s 2022 single audit. Finally, we noted IDHS’ controls over reporting federal expenditures were not designed at a sufficient level of precision to ensure complete and accurate reporting in a timely manner. Criteria or Requirement: According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. Among other things required by 2 CFR 200.510(b), the SEFA must include the total amount provided to subrecipients from each Federal program. Additionally, 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal controls designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure federal expenditures are accurately reported on the SEFA and to other State agencies, where applicable. Cause: In discussing these conditions with IDHS officials, management stated that differences in the amounts of federal expenditures and amounts passed through to subrecipients were due to the Department’s conversion to a new financial accounting system, which included creation of new database queries and reports derived from the new financial system data sources that were used for financial reporting. Possible Asserted Effect: Failure to accurately report federal expenditures prohibits the completion of an audit in accordance with the Uniform Guidance which may result in the suspension of federal funding. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-010) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend IDHS establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC. Views of IDHS Officials: IDHS accepts the recommendation. IDHS will establish procedures to accurately report federal expenditures (including subrecipient expenditures) used to prepare the SEFA to the IOC as required.
State Agency: Illinois Department of Corrections (DOC) Federal Agency: U.S. Treasury Department (TREAS) Program Name: COVID-19 – Coronavirus Relief Fund COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures: 21.019 ($190,168,889) 21.027 ($4,895,262,395) Award Numbers: Various – see table of award numbers Federal Award Year: Various – see table of award numbers Questioned Costs: $219,695 Compliance Requirement: Allowable Costs/Cost Principles and Period of Performance Finding 2022-033: Unallowable Costs Charged to the Coronavirus Relief Fund Program Type of Finding: Material noncompliance and material weakness (CRF) Material weakness (SLFRF) Condition Found: DOC charged subrecipient expenditures to the Coronavirus Relief Fund (CRF) program which were incurred prior to the period of performance. The CRF program was enacted by Congress to provide direct payments to state, territorial, tribal, and certain eligible local governments to cover: (1) necessary expenditures incurred due to the public health emergency with respect to COVID-19; (2) costs that were not accounted for in the governments approved budget as of March 27, 2020; and (3) costs that were incurred during the period from March 1, 2020 through December 31, 2021. During our testing of 19 expenditures (totaling $3,869,083) charged to the CRF program during the year ended June 30, 2022, we noted two expenditures for payments to subrecipients (totaling $219,695) for which the underlying expenditures submitted to the DOC for reimbursement pertained to expenditures incurred by the subrecipient prior to March 1, 2020. As these expenditures were incurred prior to the beginning of the period of performance for the CRF program, they are not allowable costs. Additionally, we noted seven CRF expenditures (totaling $2,007,224) from the 19 tested that were not paid by the State until after June 30, 2022, but were included in the 2022 Schedule of Expenditures of Federal Awards (SEFA). As the State prepares its SEFA using the cash basis of accounting, these expenditures were erroneously reported on the 2022 SEFA. Further, in review of the expenditures claimed under the CRF program by DOC, we noted 69 expenditures (totaling $18,080,783) that were not paid by the State until after June 30, 2022. The State’s 2022 SEFA was not corrected for this error. Further, we noted DOC has not established supervisory review controls over expenditures for the CRF and SLFRF programs at an adequate level of precision to ensure: (1) expenditures reimbursed to subrecipients are within the period of performance or (2) expenditures reported on the SEFA are reported in accordance with the cash basis of accounting. DOC expenditures for the CRF program and SLFRF program totaled $128,426,203 and $304,791,247, respectively, during the year ended June 30, 2022. Criteria or Requirement: The Federal Register Volume 86, Number 10 (dated January 15, 2021) states “the CARES Act provides that payments from the Fund may only be used to cover costs that: 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID-19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021.” According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal control designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure: (1) expenditures are reimbursed by the State are within the period of performance and (2) are reported on the SEFA in accordance with cash basis of accounting. Cause: In discussing these conditions with DOC officials, they stated that when the expenses were selected for reimbursement, the posting date of the transaction was inadvertently reviewed and used. All posting dates fell on or before June 30, 2022. As noted in the finding, the actual warrant date should have been reviewed and used for cash basis. Possible Asserted Effect: Failure to ensure payments to subrecipients are only for expenditures incurred during the period of performance results in noncompliance and unallowable costs. Additionally, failure to report expenditures in accordance with the cash basis of accounting inhibits the auditors ability to properly determine major programs in accordance with the Uniform Guidance. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-033) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend DOC implement procedures to properly review detail expenditures at the appropriate level of precision to ensure federal expenditures: (1) are within the period of performance and (2) are reported on the State’s SEFA in accordance with the cash basis of accounting. Views of DOC Officials: DOC agrees with the recommendation. DOC will ensure appropriate reviews are completed prior to submission of information related to expenditures of Federal Awards.
State Agency: Illinois Department of Corrections (DOC) Federal Agency: U.S. Treasury Department (TREAS) Program Name: COVID-19 – Coronavirus Relief Fund COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures: 21.019 ($190,168,889) 21.027 ($4,895,262,395) Award Numbers: Various – see table of award numbers Federal Award Year: Various – see table of award numbers Questioned Costs: $219,695 Compliance Requirement: Allowable Costs/Cost Principles and Period of Performance Finding 2022-033: Unallowable Costs Charged to the Coronavirus Relief Fund Program Type of Finding: Material noncompliance and material weakness (CRF) Material weakness (SLFRF) Condition Found: DOC charged subrecipient expenditures to the Coronavirus Relief Fund (CRF) program which were incurred prior to the period of performance. The CRF program was enacted by Congress to provide direct payments to state, territorial, tribal, and certain eligible local governments to cover: (1) necessary expenditures incurred due to the public health emergency with respect to COVID-19; (2) costs that were not accounted for in the governments approved budget as of March 27, 2020; and (3) costs that were incurred during the period from March 1, 2020 through December 31, 2021. During our testing of 19 expenditures (totaling $3,869,083) charged to the CRF program during the year ended June 30, 2022, we noted two expenditures for payments to subrecipients (totaling $219,695) for which the underlying expenditures submitted to the DOC for reimbursement pertained to expenditures incurred by the subrecipient prior to March 1, 2020. As these expenditures were incurred prior to the beginning of the period of performance for the CRF program, they are not allowable costs. Additionally, we noted seven CRF expenditures (totaling $2,007,224) from the 19 tested that were not paid by the State until after June 30, 2022, but were included in the 2022 Schedule of Expenditures of Federal Awards (SEFA). As the State prepares its SEFA using the cash basis of accounting, these expenditures were erroneously reported on the 2022 SEFA. Further, in review of the expenditures claimed under the CRF program by DOC, we noted 69 expenditures (totaling $18,080,783) that were not paid by the State until after June 30, 2022. The State’s 2022 SEFA was not corrected for this error. Further, we noted DOC has not established supervisory review controls over expenditures for the CRF and SLFRF programs at an adequate level of precision to ensure: (1) expenditures reimbursed to subrecipients are within the period of performance or (2) expenditures reported on the SEFA are reported in accordance with the cash basis of accounting. DOC expenditures for the CRF program and SLFRF program totaled $128,426,203 and $304,791,247, respectively, during the year ended June 30, 2022. Criteria or Requirement: The Federal Register Volume 86, Number 10 (dated January 15, 2021) states “the CARES Act provides that payments from the Fund may only be used to cover costs that: 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID-19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021.” According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal control designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure: (1) expenditures are reimbursed by the State are within the period of performance and (2) are reported on the SEFA in accordance with cash basis of accounting. Cause: In discussing these conditions with DOC officials, they stated that when the expenses were selected for reimbursement, the posting date of the transaction was inadvertently reviewed and used. All posting dates fell on or before June 30, 2022. As noted in the finding, the actual warrant date should have been reviewed and used for cash basis. Possible Asserted Effect: Failure to ensure payments to subrecipients are only for expenditures incurred during the period of performance results in noncompliance and unallowable costs. Additionally, failure to report expenditures in accordance with the cash basis of accounting inhibits the auditors ability to properly determine major programs in accordance with the Uniform Guidance. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-033) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend DOC implement procedures to properly review detail expenditures at the appropriate level of precision to ensure federal expenditures: (1) are within the period of performance and (2) are reported on the State’s SEFA in accordance with the cash basis of accounting. Views of DOC Officials: DOC agrees with the recommendation. DOC will ensure appropriate reviews are completed prior to submission of information related to expenditures of Federal Awards.
State Agency: Illinois Department of Corrections (DOC) Federal Agency: U.S. Treasury Department (TREAS) Program Name: COVID-19 – Coronavirus Relief Fund COVID-19 – Coronavirus State and Local Fiscal Recovery Funds ALN and Program Expenditures: 21.019 ($190,168,889) 21.027 ($4,895,262,395) Award Numbers: Various – see table of award numbers Federal Award Year: Various – see table of award numbers Questioned Costs: $219,695 Compliance Requirement: Allowable Costs/Cost Principles and Period of Performance Finding 2022-033: Unallowable Costs Charged to the Coronavirus Relief Fund Program Type of Finding: Material noncompliance and material weakness (CRF) Material weakness (SLFRF) Condition Found: DOC charged subrecipient expenditures to the Coronavirus Relief Fund (CRF) program which were incurred prior to the period of performance. The CRF program was enacted by Congress to provide direct payments to state, territorial, tribal, and certain eligible local governments to cover: (1) necessary expenditures incurred due to the public health emergency with respect to COVID-19; (2) costs that were not accounted for in the governments approved budget as of March 27, 2020; and (3) costs that were incurred during the period from March 1, 2020 through December 31, 2021. During our testing of 19 expenditures (totaling $3,869,083) charged to the CRF program during the year ended June 30, 2022, we noted two expenditures for payments to subrecipients (totaling $219,695) for which the underlying expenditures submitted to the DOC for reimbursement pertained to expenditures incurred by the subrecipient prior to March 1, 2020. As these expenditures were incurred prior to the beginning of the period of performance for the CRF program, they are not allowable costs. Additionally, we noted seven CRF expenditures (totaling $2,007,224) from the 19 tested that were not paid by the State until after June 30, 2022, but were included in the 2022 Schedule of Expenditures of Federal Awards (SEFA). As the State prepares its SEFA using the cash basis of accounting, these expenditures were erroneously reported on the 2022 SEFA. Further, in review of the expenditures claimed under the CRF program by DOC, we noted 69 expenditures (totaling $18,080,783) that were not paid by the State until after June 30, 2022. The State’s 2022 SEFA was not corrected for this error. Further, we noted DOC has not established supervisory review controls over expenditures for the CRF and SLFRF programs at an adequate level of precision to ensure: (1) expenditures reimbursed to subrecipients are within the period of performance or (2) expenditures reported on the SEFA are reported in accordance with the cash basis of accounting. DOC expenditures for the CRF program and SLFRF program totaled $128,426,203 and $304,791,247, respectively, during the year ended June 30, 2022. Criteria or Requirement: The Federal Register Volume 86, Number 10 (dated January 15, 2021) states “the CARES Act provides that payments from the Fund may only be used to cover costs that: 1. are necessary expenditures incurred due to the public health emergency with respect to the Coronavirus Disease 2019 (COVID-19); 2. were not accounted for in the budget most recently approved as of March 27, 2020 (the date of enactment of the CARES Act) for the State or government; and 3. were incurred during the period that begins on March 1, 2020 and ends on December 31, 2021.” According to 2 CFR 200.510(b), a recipient of federal awards is required to prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the entity’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502. 2 CFR 200.303 requires non-Federal entities receiving Federal awards to establish and maintain internal control designed to reasonably ensure compliance with Federal laws, regulations, and program compliance requirements. Effective internal controls should include procedures to ensure: (1) expenditures are reimbursed by the State are within the period of performance and (2) are reported on the SEFA in accordance with cash basis of accounting. Cause: In discussing these conditions with DOC officials, they stated that when the expenses were selected for reimbursement, the posting date of the transaction was inadvertently reviewed and used. All posting dates fell on or before June 30, 2022. As noted in the finding, the actual warrant date should have been reviewed and used for cash basis. Possible Asserted Effect: Failure to ensure payments to subrecipients are only for expenditures incurred during the period of performance results in noncompliance and unallowable costs. Additionally, failure to report expenditures in accordance with the cash basis of accounting inhibits the auditors ability to properly determine major programs in accordance with the Uniform Guidance. Repeat Finding: A similar finding was not reported in the prior year audit. (Finding Code 2022-033) Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend DOC implement procedures to properly review detail expenditures at the appropriate level of precision to ensure federal expenditures: (1) are within the period of performance and (2) are reported on the State’s SEFA in accordance with the cash basis of accounting. Views of DOC Officials: DOC agrees with the recommendation. DOC will ensure appropriate reviews are completed prior to submission of information related to expenditures of Federal Awards.
Finding # 2022-002 Program - Various, including AL 20.509 ? Formula Grants for Rural Areas ? Reporting Grant Number & Year - Various Federal Grantor Agency -Various, including U.S. Department of Transportation Pass-Through Entity -Various, including Nebraska Department of Transportation Criteria - Title 2 of the U.S. Code of Federal Regulations (CFR) ? 200.510(b) (January 1, 2022) states, in part, the following: The auditee must also prepare a schedule of expenditures of Federal awards 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. Title 2 CFR ? 200.302(b) (January 1, 2022) states, in relevant part, the following: The financial management system of each non-Federal entity must provide for the following . . . (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. On January 18, 2020, the Office of Management and Budget (OMB) issued Memorandum M-20-26, which included the following requirement to identify separately COVID-19 Emergency Acts expenditures on the Schedule of Expenditures of Federal Awards. Additionally, in order to provide adequate oversight of the COVID-19 Emergency Acts funding and programs, recipients and subrecipients must separately identify COVID-19 Emergency Acts expenditures on the Schedule of Federal Awards and audit report findings. Title 2 CFR ? 200.303 (January 1, 2022) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with 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 of the Treadway Commission (COSO). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is properly presented and includes all Federal expenditures made by the County during the fiscal year, including properly identifying COVID-19 expenditures. Furthermore, such internal control plan should also include procedures to ensure Federal reimbursements are properly recorded using a Federal revenue code in the County?s accounting system. Condition -Kimball County does not have adequate procedures in place to ensure the Schedule of Expenditures of Federal Awards (SEFA) is completed accurately and includes all Federal expenditures paid by the County. Specifically, we noted the following errors during our audit: ?Expenditures of $32,031 for Assistance Listing 20.509 were omitted from the County?s fiscal year ending June 30, 2021, SEFA. This was not considered a material error, and it would not have impacted major program determination for the fiscal year 2021 audit. ?Expenditures for fiscal year 2022, originally reported by Kimball County for Assistance Listing 20.509, did not include expenditures of $5,310 actually incurred during the fiscal year. ?Expenditures originally reported by Kimball County for Assistance Listing 20.509 did not identify $55,464 of COVID-19 expenditures separately. ?Federal reimbursements, totaling $23,719, were not recorded to a Federal revenue code in the County?s accounting system. Instead, this funding was recorded to a miscellaneous revenue code. Repeat Finding -No Questioned Costs - None Statistical Sample -No Cause - Administration of Federal awards is decentralized, with each County office operating independently without any centralized reporting procedures in place to ensure all Federal expenditures of the County are accurately reported on the SEFA. Additionally, there is an overall lack of knowledge by County personnel related to Federal reporting and compliance requirements. Effect -Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or failure to audit programs that should be audited. Recommendation -We recommend the County establish written procedures to ensure the SEFA is complete and accurate. Such procedures may include, among other things, a requirement that all offices in the County responsible for administering Federal grants report their grant expenditures, as well as related information, to a single individual in the County with overall responsibility for Federal reporting requirements. That individual should be knowledgeable of all Federal reporting and compliance requirements, and review expenditures provided by each office to ensure all amounts are accurate and include all Federal expenditures of the County. View of Officials -Moving forward the transit office will implement a policy and get training to ensure compliance.
Material Weakness, Inaccurate Schedule Of Expenditures Of Federal Awards (The SEFA) Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance) provides guidance related to preparation and reporting of a SEFA. 2 CFR Section 200.100 identifies the required elements of the SEFA and 2 CFR Section 200.510 specifically requires that the SEFA include information on each federal award expended during the year. The District is required to prepare a complete and accurate SEFA and to have a system of internal controls, the design and operation of which allows management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, errors on a timely basis. Condition: The initial SEFA was inaccurate, which led to errors in reporting federal awards. The District incorrectly reported expenditures within two programs totaling $220,070 that were in excess of actual expenditures. Cause: The District did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. The District received new sources of federal funding, and the preparer and reviewer were not familiar with federal requirements and the guidance for the SEFA; this resulted in the errors noted above. Effect: As a result of the errors, the SEFA was materially incorrect. Inaccurate identification of federal awards may also result in inaccurate identification of compliance requirements, risk assessments, major program determination, materiality determinations and reporting errors. Questioned Costs: None Context: N/A Identification As A Repeat Finding: N/A Recommendation: The District should strengthen its internal controls by implementing additional training and oversight of personnel to ensure the SEFA accurately reflects federal expenditures for the fiscal year. Views Of Responsible Officials And Planned Corrective Action: The District agrees with the finding and has put together a correction action plan for the finding. See corrective action plan included in this report.
Material Weakness, Inaccurate Schedule Of Expenditures Of Federal Awards (The SEFA) Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance) provides guidance related to preparation and reporting of a SEFA. 2 CFR Section 200.100 identifies the required elements of the SEFA and 2 CFR Section 200.510 specifically requires that the SEFA include information on each federal award expended during the year. The District is required to prepare a complete and accurate SEFA and to have a system of internal controls, the design and operation of which allows management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, errors on a timely basis. Condition: The initial SEFA was inaccurate, which led to errors in reporting federal awards. The District incorrectly reported expenditures within two programs totaling $220,070 that were in excess of actual expenditures. Cause: The District did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. The District received new sources of federal funding, and the preparer and reviewer were not familiar with federal requirements and the guidance for the SEFA; this resulted in the errors noted above. Effect: As a result of the errors, the SEFA was materially incorrect. Inaccurate identification of federal awards may also result in inaccurate identification of compliance requirements, risk assessments, major program determination, materiality determinations and reporting errors. Questioned Costs: None Context: N/A Identification As A Repeat Finding: N/A Recommendation: The District should strengthen its internal controls by implementing additional training and oversight of personnel to ensure the SEFA accurately reflects federal expenditures for the fiscal year. Views Of Responsible Officials And Planned Corrective Action: The District agrees with the finding and has put together a correction action plan for the finding. See corrective action plan included in this report.
Material Weakness, Inaccurate Schedule Of Expenditures Of Federal Awards (The SEFA) Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance) provides guidance related to preparation and reporting of a SEFA. 2 CFR Section 200.100 identifies the required elements of the SEFA and 2 CFR Section 200.510 specifically requires that the SEFA include information on each federal award expended during the year. The District is required to prepare a complete and accurate SEFA and to have a system of internal controls, the design and operation of which allows management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, errors on a timely basis. Condition: The initial SEFA was inaccurate, which led to errors in reporting federal awards. The District incorrectly reported expenditures within two programs totaling $220,070 that were in excess of actual expenditures. Cause: The District did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. The District received new sources of federal funding, and the preparer and reviewer were not familiar with federal requirements and the guidance for the SEFA; this resulted in the errors noted above. Effect: As a result of the errors, the SEFA was materially incorrect. Inaccurate identification of federal awards may also result in inaccurate identification of compliance requirements, risk assessments, major program determination, materiality determinations and reporting errors. Questioned Costs: None Context: N/A Identification As A Repeat Finding: N/A Recommendation: The District should strengthen its internal controls by implementing additional training and oversight of personnel to ensure the SEFA accurately reflects federal expenditures for the fiscal year. Views Of Responsible Officials And Planned Corrective Action: The District agrees with the finding and has put together a correction action plan for the finding. See corrective action plan included in this report.
Material Weakness, Inaccurate Schedule Of Expenditures Of Federal Awards (The SEFA) Criteria: Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance) provides guidance related to preparation and reporting of a SEFA. 2 CFR Section 200.100 identifies the required elements of the SEFA and 2 CFR Section 200.510 specifically requires that the SEFA include information on each federal award expended during the year. The District is required to prepare a complete and accurate SEFA and to have a system of internal controls, the design and operation of which allows management or employees in the normal course of performing their assigned functions to prevent, or detect and correct, errors on a timely basis. Condition: The initial SEFA was inaccurate, which led to errors in reporting federal awards. The District incorrectly reported expenditures within two programs totaling $220,070 that were in excess of actual expenditures. Cause: The District did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. The District received new sources of federal funding, and the preparer and reviewer were not familiar with federal requirements and the guidance for the SEFA; this resulted in the errors noted above. Effect: As a result of the errors, the SEFA was materially incorrect. Inaccurate identification of federal awards may also result in inaccurate identification of compliance requirements, risk assessments, major program determination, materiality determinations and reporting errors. Questioned Costs: None Context: N/A Identification As A Repeat Finding: N/A Recommendation: The District should strengthen its internal controls by implementing additional training and oversight of personnel to ensure the SEFA accurately reflects federal expenditures for the fiscal year. Views Of Responsible Officials And Planned Corrective Action: The District agrees with the finding and has put together a correction action plan for the finding. See corrective action plan included in this report.
Finding 2022-004 Assistance Listing Number, Federal Agency, and Program Name Federal Agency: Department of Education Federal Programs: TRIO Student Support Services, TRIO Talent Search, TRIO Upward Bound, and TRIO McNair Post-Baccalaureate Achievement Assistance Listing Numbers: 84.042, 84.044, 84.047, and 84.217 Finding Type: Significant Deficiency Repeat Finding: No Criteria Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of Federal awards that must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number (ALN) or other identifying number when the Assistance Listings information is not available. For a cluster of programs, schedule of expenditures of Federal awards must also provide the total for the cluster. Condition Purdue did not have adequate controls in place to ensure the SEFA was prepared to include appropriate ALN's for each federal program and federal programs were included in the appropriate cluster. Questioned Costs There were no questioned costs identified. Context During our review of the University's SEFA, we noted 1 TRIO grant with expenditures of $275,851 that was improperly included within the Research and Development Cluster, rather than the TRIO cluster. The University completed an additional review of the SEFA identifying an additional TRIO grant with expenditures of $352,099 that was being presented under a placeholder Department of Education ALN and not properly adjusted to the proper ALN. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. The University conducted a full review of ALNs and as a result, 51 ALNs were adjusted. No additional cluster changes were identified. Cause and Effect Purdue University did not have adequate processes and internal control structure in place to ensure appropriate ALNs were ultimately assigned to all grants and that all grants were included in the appropriate cluster. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. Recommendation We recommend that the Univerisy refine their processes and modify their existing internal control structure in place to ensure appropriate ALNs are assigned to all grants and that all grants are included in the appropriate cluster. Views of Responsible Officials and Corrective Action Plan ? A report has been created to identify all grants assigned a placeholder ALN. ? This ALN report will be reviewed monthly by the Senior Manager of the Award Set-Up Team in Post Award to ensure all placeholder ALNs are appropriately and timely corrected once the proper ALN is known. ? Annually, as the SEFA is prepared, a full review of all grants assigned a placeholder ALN will be conducted by the Assistant Director of Post Award and the Assistant Director of Research Quality Assurance and any mis-assigned ALNs will be appropriately corrected before the SEFA is created.
Finding 2022-004 Assistance Listing Number, Federal Agency, and Program Name Federal Agency: Department of Education Federal Programs: TRIO Student Support Services, TRIO Talent Search, TRIO Upward Bound, and TRIO McNair Post-Baccalaureate Achievement Assistance Listing Numbers: 84.042, 84.044, 84.047, and 84.217 Finding Type: Significant Deficiency Repeat Finding: No Criteria Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of Federal awards that must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number (ALN) or other identifying number when the Assistance Listings information is not available. For a cluster of programs, schedule of expenditures of Federal awards must also provide the total for the cluster. Condition Purdue did not have adequate controls in place to ensure the SEFA was prepared to include appropriate ALN's for each federal program and federal programs were included in the appropriate cluster. Questioned Costs There were no questioned costs identified. Context During our review of the University's SEFA, we noted 1 TRIO grant with expenditures of $275,851 that was improperly included within the Research and Development Cluster, rather than the TRIO cluster. The University completed an additional review of the SEFA identifying an additional TRIO grant with expenditures of $352,099 that was being presented under a placeholder Department of Education ALN and not properly adjusted to the proper ALN. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. The University conducted a full review of ALNs and as a result, 51 ALNs were adjusted. No additional cluster changes were identified. Cause and Effect Purdue University did not have adequate processes and internal control structure in place to ensure appropriate ALNs were ultimately assigned to all grants and that all grants were included in the appropriate cluster. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. Recommendation We recommend that the Univerisy refine their processes and modify their existing internal control structure in place to ensure appropriate ALNs are assigned to all grants and that all grants are included in the appropriate cluster. Views of Responsible Officials and Corrective Action Plan ? A report has been created to identify all grants assigned a placeholder ALN. ? This ALN report will be reviewed monthly by the Senior Manager of the Award Set-Up Team in Post Award to ensure all placeholder ALNs are appropriately and timely corrected once the proper ALN is known. ? Annually, as the SEFA is prepared, a full review of all grants assigned a placeholder ALN will be conducted by the Assistant Director of Post Award and the Assistant Director of Research Quality Assurance and any mis-assigned ALNs will be appropriately corrected before the SEFA is created.
Finding 2022-004 Assistance Listing Number, Federal Agency, and Program Name Federal Agency: Department of Education Federal Programs: TRIO Student Support Services, TRIO Talent Search, TRIO Upward Bound, and TRIO McNair Post-Baccalaureate Achievement Assistance Listing Numbers: 84.042, 84.044, 84.047, and 84.217 Finding Type: Significant Deficiency Repeat Finding: No Criteria Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of Federal awards that must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number (ALN) or other identifying number when the Assistance Listings information is not available. For a cluster of programs, schedule of expenditures of Federal awards must also provide the total for the cluster. Condition Purdue did not have adequate controls in place to ensure the SEFA was prepared to include appropriate ALN's for each federal program and federal programs were included in the appropriate cluster. Questioned Costs There were no questioned costs identified. Context During our review of the University's SEFA, we noted 1 TRIO grant with expenditures of $275,851 that was improperly included within the Research and Development Cluster, rather than the TRIO cluster. The University completed an additional review of the SEFA identifying an additional TRIO grant with expenditures of $352,099 that was being presented under a placeholder Department of Education ALN and not properly adjusted to the proper ALN. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. The University conducted a full review of ALNs and as a result, 51 ALNs were adjusted. No additional cluster changes were identified. Cause and Effect Purdue University did not have adequate processes and internal control structure in place to ensure appropriate ALNs were ultimately assigned to all grants and that all grants were included in the appropriate cluster. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. Recommendation We recommend that the Univerisy refine their processes and modify their existing internal control structure in place to ensure appropriate ALNs are assigned to all grants and that all grants are included in the appropriate cluster. Views of Responsible Officials and Corrective Action Plan ? A report has been created to identify all grants assigned a placeholder ALN. ? This ALN report will be reviewed monthly by the Senior Manager of the Award Set-Up Team in Post Award to ensure all placeholder ALNs are appropriately and timely corrected once the proper ALN is known. ? Annually, as the SEFA is prepared, a full review of all grants assigned a placeholder ALN will be conducted by the Assistant Director of Post Award and the Assistant Director of Research Quality Assurance and any mis-assigned ALNs will be appropriately corrected before the SEFA is created.
Finding 2022-004 Assistance Listing Number, Federal Agency, and Program Name Federal Agency: Department of Education Federal Programs: TRIO Student Support Services, TRIO Talent Search, TRIO Upward Bound, and TRIO McNair Post-Baccalaureate Achievement Assistance Listing Numbers: 84.042, 84.044, 84.047, and 84.217 Finding Type: Significant Deficiency Repeat Finding: No Criteria Uniform Guidance (2 CFR 200.510(b)) requires a schedule of expenditures of Federal awards that must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number (ALN) or other identifying number when the Assistance Listings information is not available. For a cluster of programs, schedule of expenditures of Federal awards must also provide the total for the cluster. Condition Purdue did not have adequate controls in place to ensure the SEFA was prepared to include appropriate ALN's for each federal program and federal programs were included in the appropriate cluster. Questioned Costs There were no questioned costs identified. Context During our review of the University's SEFA, we noted 1 TRIO grant with expenditures of $275,851 that was improperly included within the Research and Development Cluster, rather than the TRIO cluster. The University completed an additional review of the SEFA identifying an additional TRIO grant with expenditures of $352,099 that was being presented under a placeholder Department of Education ALN and not properly adjusted to the proper ALN. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. The University conducted a full review of ALNs and as a result, 51 ALNs were adjusted. No additional cluster changes were identified. Cause and Effect Purdue University did not have adequate processes and internal control structure in place to ensure appropriate ALNs were ultimately assigned to all grants and that all grants were included in the appropriate cluster. As a result, the TRIO cluster on the SEFA was updated to reflect total expenditures of $3,608,222, which surpassed the Type A threshold and was required to be tested as a major program. Recommendation We recommend that the Univerisy refine their processes and modify their existing internal control structure in place to ensure appropriate ALNs are assigned to all grants and that all grants are included in the appropriate cluster. Views of Responsible Officials and Corrective Action Plan ? A report has been created to identify all grants assigned a placeholder ALN. ? This ALN report will be reviewed monthly by the Senior Manager of the Award Set-Up Team in Post Award to ensure all placeholder ALNs are appropriately and timely corrected once the proper ALN is known. ? Annually, as the SEFA is prepared, a full review of all grants assigned a placeholder ALN will be conducted by the Assistant Director of Post Award and the Assistant Director of Research Quality Assurance and any mis-assigned ALNs will be appropriately corrected before the SEFA is created.
Finding 2022-002 Material Weakness: Schedule of Expenditures of Federal Awards ? Control Finding ALN 93.498 ? Provider Relief Fund (PRF) and American Rescue Plan Rural Distribution Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: None, direct awards Criteria or Specific Requirement: 2 CFR section 200.510 states that the auditee must prepare the schedule of expenditures of federal awards (SEFA or ?Schedule?) and the schedule must provide total federal awards expended for each individual ALN and amounts passed through to subrecipients. Condition: During the audit, the following corrections were made to the SEFA: ? PRF amounts totaling $903,155 received during the period of July 1, 2020 through June 30, 2021 were added to the SEFA, in accordance with guidance set forth by the U.S. Department of Health and Human Services. ? Federal expenditures totaling $147,262 were classified under the wrong ALN. The reclassification of these expenditures resulted in a change to the major program determination. ? Federal expenditures were adjusted by $100,152 to accrue reimbursable expenditures related to fiscal year 2022. ? The Schedule provided did not identify amounts passed through to subrecipients. Cause: Management does not have an internal control process in place to ensure an accurate Schedule. Effect: The possibility exists that errors within the Schedule could become material to the financial statements or result in an incorrect major program determination. Questioned Costs: Not applicable. Context: A sufficient review of the Schedule did not occur so errors were not detected. Identification as a Repeat Finding: Not applicable. Recommendation: We recommend that management assign the review of the SEFA to an individual that is knowledgeable about federal grants. In addition, grant agreements should be retained in a central repository to aid in the review of the SEFA. Lastly, the Finance Office should perform a year-over-year comparison of the SEFA by ALN and make inquiries of agencies regarding significant variances. Views of Responsible Officials: Management will implement procedures to assure that all costs charged to the Provider Relief Fund are reviewed by a competent individual, and those reviews will be documented.