2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
2022-001: Schedule of Expenditures of Federal Awards Federal Agency: All Federal Program: All Assistance Listing Number: All Federal Award Number: All Federal Award Year: Fiscal year 2021 Pass-through Entity: All Criteria OMB Uniform Guidance 2 CFR 200.510(b) requires that an auditee 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. Further, it requires that the auditee provide the Federal awards expended for each individual Federal Program. Condition The 2021 schedule of expenditures of Federal awards (the ?Schedule?) prepared by management improperly included the expenditures of State awards of $16,195,894 and $2,648,682 for the Children?s Health Insurance Program passed through from the Pennsylvania Department of Human Services and New York State Department of Health, respectively. Cause Management performs a reconciliation between the Schedule and the consolidated financial statements, however, the reconciliation performed did not effectively ensure that the Schedule was accurate inclusive only Federal awards. Effect The 2021 Schedule was overstated by $18,844,576, which represents the expenditures of State awards improperly included in the Schedule. There was no impact on our 2021 audit scoping for the improper inclusion of these amounts Recommendation Management of Highmark Health should update its controls over the preparation and review of the Schedule with sufficient precision to ensure all Federal awards are reported on the Schedule accurately. Management?s Views and Corrective Action Plan Refer to Management?s Views and Corrective Action Plan at the end of the report.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
Finding 2022-001 Identification of the Federal Program: Federal Agency: U.S. Department of Health and Human Services, United States Department of Defense Assistance Listing: Various ? Research & Development (R&D) Cluster Pass-Through Grantor: Various Pass-Through Award Number: Various Pass-Through Award Period: Various Federal Agency: Department of Homeland Security Assistance Listing: 97.036 ? COVID-19 Disaster Grants ? Public Assistance (Presidentially Declared Disasters) (FEMA) Pass-Through Grantor: Michigan State Police Emergency Management and Homeland Security Division Pass-Through Award Number: 4494-DR-MI Pass-Through Award Period: 1/20/2020-7/1/2022 Federal Agency: U.S. Department of Health and Human Services (HHS), Health Resources and Services Administration (HRSA) Assistance Listing: 93.498 COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Pass-Through Award Period: 1/1/2020-12/31/2022 (Periods 3 and 4) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): 2 CFR Section 200.303 of the Uniform Guidance States the Following Regarding Internal Control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards (the Schedule) prepared by the Corewell Health and Subsidiaries (the System) did not appropriately reflect the federal expenses incurred. The final Schedule was corrected for the differences identified. Cause: Management did not design internal controls to ensure appropriate accumulation of the data necessary to complete the Schedule. Effect or Potential Effect: Federal expenditures were inappropriately included or excluded from the Schedule. Questioned Costs: None Context: Total federal expenses included on the Schedule were $102,235,937 for the year ended December 31, 2022. Total expenses included on the final Schedule were $101,562,371 for the year ended December 31, 2022. The federal expenditures were misstated as follows: See Schedule of Findings and Questioned Costs. Identification as a Repeat Finding: Partial Repeat Finding of Corewell Health East 2021-001. Recommendation: Management should assess its internal controls over the identification of federal expenditures to ensure the Schedule is complete. Views of Responsible Officials: The enhanced Schedule process and controls implemented by Corewell Health East in 2023 will be reviewed. The misstated amounts of the R&D Cluster occurred as a result of the timing of posted expenses during the first month of the merger of Spectrum Health and Beaumont Health in February 2022. This was a one-time occurrence and we do not anticipate that this will be an issue in future years. In addition, the successful implementation and transition to Workday, a new Corporate financial management system, has improved award setup functionality that enables improved differentiation of awards, identifying which need to be included on the annual Schedule of Expenditures of Federal Awards and those that should be excluded. The understatement related to FEMA was a one-time occurrence related to the clarification of guidelines on the inclusion of a new Category Z FEMA obligation in 2022 on the SEFA. This has been corrected in 2023. The overstatement related to PRF was due to an improper inclusion of Corewell Health East funding on the Schedule and an adjustment related to the submitted amount of Corewell Health West funding on the Schedule. On the 2023 SEFA we will implement a management review and sign-off of the inputs prior to submission.
2022-002 Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards) Information on the Federal Program: United States Department of State Assistance Listing Number: 19.706 Assistance Listing Name: Partnership for Regional East Africa Counterterrorism Award Numbers: Direct Award Numbers Award Period SLMAQM20CA2264 September 28, 2020 through March 29, 2024 SLMAQM20GR2364 September 28, 2020 through September 30, 2024 Criteria: CFR Section ?200.510(b) states in part: ?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 CFR Section ?200.502 Basis for determining Federal awards expended.? The schedule must provide total Federal awards expended for each individual Federal program. In accordance with ?200.302 Financial Management, a non-federal entity?s financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. 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. (2) Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in ?200.327 Financial Reporting and ?200.328 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally-funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. During our testing of management?s preparation of the SEFA, BDO identified two awards whose assistance listing number was changed by the federal entity in award amendments issued prior to December 31, 2022. Management failed to update the assistance listing number for the awards within the SEFA to address the award modifications. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. The Organization did not adequately review award modifications for changes to existing awards. Effect: The SEFA initially provided to BDO resulted in incorrect major program selection as prescribed under the Unform Guidance. During the review of the award agreements, BDO identified the assistance listing numbers for the two awards had been modified. This issue resulted in a different major program selection once the SEFA was updated to reflect the correct assistance listing numbers. Repeat Finding: This finding is not a repeat finding from prior year. Recommendation: We recommend management to continue to focus on training for both preparer and reviewers of the SEFA to ensure the documented policies and procedures can be performed as prescribed to comply with Section ?200.510(b). This will ensure that the SEFA provides all relevant information as proscribed.
2022-002 Internal Control over Compliance and Compliance with Reporting (Preparation of the Schedule of Expenditures of Federal Awards) Information on the Federal Program: United States Department of State Assistance Listing Number: 19.706 Assistance Listing Name: Partnership for Regional East Africa Counterterrorism Award Numbers: Direct Award Numbers Award Period SLMAQM20CA2264 September 28, 2020 through March 29, 2024 SLMAQM20GR2364 September 28, 2020 through September 30, 2024 Criteria: CFR Section ?200.510(b) states in part: ?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 CFR Section ?200.502 Basis for determining Federal awards expended.? The schedule must provide total Federal awards expended for each individual Federal program. In accordance with ?200.302 Financial Management, a non-federal entity?s financial management systems, including records documenting compliance with federal statutes, regulations, and the terms and conditions of the federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the federal statutes, regulations, and the terms and conditions of the federal award. 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. (2) Accurate, current, and complete disclosure of the financial results of each federal award or program in accordance with the reporting requirements set forth in ?200.327 Financial Reporting and ?200.328 Monitoring and Reporting Program Performance. (3) Records that identify adequately the source and application of funds for federally-funded activities. (4) Effective control over, and accountability for, all funds, property, and other assets. Condition: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not operate as designed. During our testing of management?s preparation of the SEFA, BDO identified two awards whose assistance listing number was changed by the federal entity in award amendments issued prior to December 31, 2022. Management failed to update the assistance listing number for the awards within the SEFA to address the award modifications. Questioned Costs: None. Context: The nature of these findings is detailed in the condition section above. Cause: The internal controls established for the review and approval of the SEFA to ensure its completeness and accuracy did not fully operate as designed. The Organization did not adequately review award modifications for changes to existing awards. Effect: The SEFA initially provided to BDO resulted in incorrect major program selection as prescribed under the Unform Guidance. During the review of the award agreements, BDO identified the assistance listing numbers for the two awards had been modified. This issue resulted in a different major program selection once the SEFA was updated to reflect the correct assistance listing numbers. Repeat Finding: This finding is not a repeat finding from prior year. Recommendation: We recommend management to continue to focus on training for both preparer and reviewers of the SEFA to ensure the documented policies and procedures can be performed as prescribed to comply with Section ?200.510(b). This will ensure that the SEFA provides all relevant information as proscribed.
Item 2022-001 ?Schedule of Expenditures of Federal Awards (SEFA) Reporting Awarding Agency: U.S. Department of Housing and Urban Development Federal Program: 14.228 ? COVID-19 Community Development Block Grants/State?s Program and Non-Entitlement Grants in Hawaii Federal Award Identification Number: MSC221029-CV Grant Period: June 2022 to July 2023 Criteria: 2 CFR 200.510(b) requires the auditee to prepare a SEFA that must contain all federal awards expended during the period. Additionally, 2 CFR 200.514(a) states audits must cover the entire operations of the auditee based on the audits prepared and filed with the government, and that the financial statements and schedule of expenditures of Federal awards must be for the same audit period. Condition: We determined a federal award under SEMI Foundation with current period expenditures of $240,245 was improperly excluded from the auditee prepared SEFA. Cause: The financial statements of the Group are consolidated and include SEMI Foundation. As a result, the SEFA should also include SEMI Foundation?s federal expenditures. The Group maintains a system of controls designed to flag federal awards, but the award was mistakenly excluded from the SEFA because management did not initially believe the federal award was subject to audit in the current period on a stand-alone basis for SEMI Foundation. Current period federal expenditures for SEMI Foundation were below the audit threshold, but the SEFA should have included federal expenditures of both SEMI and SEMI Foundation. Effect: The SEFA was incomplete and impacted federal audit applicability determinations as well as the auditors? major program determination. Questioned Cost: None Context: The improperly excluded expenditures were only applicable to 1 out of 4 federal awards reported on the SEFA, and represented approximately 2 percent of total reported federal expenditures for the year ended December 31, 2022. Repeat Finding: No Recommendation: We recommend for management to implement processes to ensure the SEFA includes all federal expenditures for entities covered in its consolidated financial statements, which is currently SEMI and SEMI Foundation. Views of Responsible Official: SEMI concurs with this finding and will evaluate current period expenditures of federal awards on a consolidated basis going forward.
Section III ? Federal Award Findings and Questioned Costs 2022-001 Internal Control over Compliance and Compliance with Reporting - Preparation of the Schedule of Expenditures of Federal Awards Information on the Major Federal Program ? General Services Administration Assistance Listing Number: 39.RD Assistance Listing Name: Advisory & Assistance Services Criteria - The Uniform Guidance in 2 CFR ?200.510 (b) states in part: ?The auditee must also prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee?s financial statements which must include the total Federal awards expended as determined in accordance with CFR ?200.502 Basis for determining Federal awards expended.? Condition - Certain contract expenditures related to the Advisory & Assistance Services award with General Services Administration (GSA) were incorrectly reported in the initial SEFA. The total federal expenditures initially reported in the SEFA for this award totaled $3,719,891. However, based on testing by the auditors, contract expenditures totaling $3,119,210 were determined to not qualify for SEFA presentation based on CFR Section ?200.502 due to a certain task within the award being firm fixed price. Cause ? One task of the Advisory & Assistance Services award was incorrectly labeled as cost-reimbursable with the Organization?s accounting system. This error resulted in the Organization not following its policies and procedures in place to ensure compliance with the requirements regarding the preparation of the SEFA. Effect or Potential Effect - Failure to comply with the reporting requirements of the Uniform Guidance related to the preparation of the SEFA could result in expenses from Federal awards being inaccurately reported. Questioned Costs - None. Context - This is a condition identified based upon our review of the Organization?s compliance with specified requirements required based on CFR ?200.502. The prevalence of these findings is detailed in the condition section above. Repeat finding ? This is not a repeat finding. Recommendation ? We recommend that the Organization implement policies and procedures to ensure that Federal expenditures reported on the SEFA are properly included based on underlying Federal and award requirements. Views of Responsible Officials - Management agrees with the finding. The inclusion of the contract task was an oversight as the project type was mislabeled in the accounting system. Riverside will implement an additional review of projects created in the accounting system to ensure the reliance of the information to identify only the amount of Federal awards that are required to be reported under CFR ?200.502. Additionally, the one task of the Advisory & Assistance Services award that was the cause of the issue has been corrected within the accounting system.
Finding No. 2022-002: Incomplete Schedule of Expenditures of Federal Awards?Material Weakness and Material Noncompliance U.S Department of State (19.518) Overseas Refugee Assistance Programs for Western Hemisphere passed through from Asylum Access Criteria: 2 CFR Part 200.510 (b) requires that the Organization must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR Part 200.502. In a proper system of internal controls, the Organization is required to have procedures in place that correctly identify federal grants which are required to follow the compliance requirements of 2 CFR Part 200. Cause: The Organization did not properly identify a grant under Assistance Listing Number (ALN) 19.518 as being required to follow the requirements of 2 CFR Part 200 and, as a result, the initial SEFA omitted expenditures received under this grant. Condition: During our audit, we identified a grant under ALN 19.518 that is required to comply with the applicable requirements of 2 CFR Part 200 and thus should have been included in the SEFA. Effect: The Organization did not properly identify the applicability of 2 CFR Part 200 and thus a grant was improperly omitted from the initial SEFA. Once this grant was properly included, the Organization exceeded $750,000 in qualifying federal expenditures thus meeting the requirement for a Uniform Guidance audit to be required. Questioned costs: None Context: The Organization did not have a proper set of internal controls in place to appropriately identify the applicability of 2 CFR Part 200 to all federal awards. Repeat Finding?: No Recommendation: We recommend that management implement policies and procedures to evaluate all grants received to identify federal funding. Views of responsible officials: The Organization agrees with the finding. See corrective action plan.
Finding 2022-006: Federal Financial Reporting Requirements (Significant Deficiency) Information on the Federal Program: U.S. Department of State ALN 19.040 Criteria or Specific Requirement: Code of Federal Regulations (CFR) Section 200.303(b) requires non-federal entities to establish and maintain effective internal control over federal awards that provide reasonable assurance that the non-federal entity is managing federal awards in compliance with federal statutes, regulations, and terms and conditions of the federal award. CFR Section 200.502(a) states that the determination of when a federal award is expended should be based on when the activity related to the federal award occurs. CFR Section 200.510 states that the auditee must 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 CFR Section 200.502. Condition: The schedule of expenditures of federal awards for the year ended December 31, 2022, did not originally include indirect costs totaling $43,632. Questioned Costs: None Cause: FCE's management prepared the schedule of expenditures of federal awards using only direct costs. However, FCE had applied the 10-percent de minimis indirect cost rate when submitting its financial reports. Effect or Potential Effect: The exclusion of indirect costs caused inaccurate amounts to be reported in the SEFA at the start of the audit. This could have caused an inaccurate major program determination. Recommendation: FCE should implement a process for preparing the SEFA that includes comparing amounts reported in the SEFA to amounts included in financial reports of expenditures that are submitted to federal agencies.
Finding 2022-002: SEFA Preparation Agency U.S. Department of Treasury pass-through from City of Alexandria ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number 55-547-8853 Criteria In accordance with 2 CFR 200.508(b), the auditee is required to prepare appropriate financial statements, including the schedule of expenditures of Federal awards (SEFA) in accordance with ?200.510. Condition and Context During our audit, we identified a conditional contribution that ACT had recorded as revenue upon receipt of the advanced funds and before the applicable barrier to recognition had been satisfied. In addition, the full amount of advanced funds was presented on the schedule of expenditures of SEFA. As a result, net assets without donor restrictions were overstated in the financial statements and expenditures were overstated on the SEFA. Cause Controls and processes were not effectively designed to ensure conditional contributions are properly recorded within the general ledger and that the SEFA is complete and accurate. Effect Net assets without donor restrictions and expenses on the SEFA were overstated by $44,999 at December 31, 2022. Repeat Finding No Recommendation We recommend management review policies and procedures over contributions received to ensure timely and effective review for any barriers to recognition and over preparation of the SEFA to ensure completeness and accuracy of the SEFA. Views of Responsible Officials of the Auditee Management agrees with the finding. See corrective action plan. Questioned Cost None.
Finding 2022-002: SEFA Preparation Agency U.S. Department of Treasury pass-through from City of Alexandria ALN 21.027 Coronavirus State and Local Fiscal Recovery Funds Federal Award Identification Number 55-547-8853 Criteria In accordance with 2 CFR 200.508(b), the auditee is required to prepare appropriate financial statements, including the schedule of expenditures of Federal awards (SEFA) in accordance with ?200.510. Condition and Context During our audit, we identified a conditional contribution that ACT had recorded as revenue upon receipt of the advanced funds and before the applicable barrier to recognition had been satisfied. In addition, the full amount of advanced funds was presented on the schedule of expenditures of SEFA. As a result, net assets without donor restrictions were overstated in the financial statements and expenditures were overstated on the SEFA. Cause Controls and processes were not effectively designed to ensure conditional contributions are properly recorded within the general ledger and that the SEFA is complete and accurate. Effect Net assets without donor restrictions and expenses on the SEFA were overstated by $44,999 at December 31, 2022. Repeat Finding No Recommendation We recommend management review policies and procedures over contributions received to ensure timely and effective review for any barriers to recognition and over preparation of the SEFA to ensure completeness and accuracy of the SEFA. Views of Responsible Officials of the Auditee Management agrees with the finding. See corrective action plan. Questioned Cost None.
Finding 2022-003: Internal Controls over Compliance and Other Matters Identification of Federal Funds for Purposes of Assembling the Schedule of Expenditures of Federal Awards (SEFA) ? Other U.S. DEPARTMENT OF HEALTH AND HUMAN SERVICES COVID-19 ? Community Services Block Grant? Assistance Listing No. 93.569 Criteria: Per 2 CFR 200.510(b) Schedule of expenditures of Federal awards, ?the auditee must 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 2 CFR 200.502, Basis for determining Federal awards expended. Condition: Federal expenses were not correctly identified on Youthprise?s 2022 SEFA. During our audit, it was determined that a $300,000 grant from Community Action Partnership of Hennepin County under the COVID-19 ? Community Services Block Grant program was not included on the audittee prepared SEFA. Additionally, it was determined that a $3.5 million grant originally included in the SEFA was a contractor payment not a subreceipient award. Cause: Internal controls were not in place to ensure all relevant contract and grant agreement information received by Youthprise staff were passed along to the individual responsible for overseeing the audit, financial statement, and SEFA preparation. Effect: By not having proper controls over SEFA preparation, there is a risk that the SEFA will not reflect all the federal awards subject to the Uniform Guidance. Context: The original agreement from Community Action Partnership of Hennepin County did not specify that Youthprise was considered a subrecipient federal funds. Youthprise originally considered themselves a contractor under the agreement and therefore these funds were excluded from the SEFA. Subsequently, it was verified with the pass-through entity that Youthprise is considered a subrecipient for this program. During the financial audit, it was determined Youthprise was a contractor/fiscal agent related to the $3.5 million program and therefore these funds were removed from the SEFA. Refer to Finding 2022-001 for additional context. Questioned Costs: $0 Identification of Repeat Finding: Not a repeat finding. Recommendation: We recommend that Youthprise review procedures to ensure timely identification of federal funds, including the clear distinction between subrecipient and contractor relationships for all contract and grant agreements involving federal funds. Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and is in the process of developing internal controls to ensure timely and appropriate actions are made on the deficiency noted. Additional details can be found in Youthprise?s Corrective Action Plan.
Finding 2022-002 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. Broomfield 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 SEFA was incomplete and inaccurate, which led to several errors in reporting federal awards. Broomfield incorrectly reported expenditures for six programs in the aggregate amount of $1,343,654. Broomfield also reported several inaccurate assistance listing numbers and program titles. Broomfield also did not report four programs with total expenditures of $621,198. Cause: Broomfield did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. Broomfield experienced turnover in the preparer and reviewer functions for the grant tracking and reporting process during the year, and the new 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: 2021-001 Recommendation: Broomfield 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: Broomfield agrees with the finding and has created a corrective action plan for the finding. See the corrective action plan included in this report.
Finding 2022-002 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. Broomfield 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 SEFA was incomplete and inaccurate, which led to several errors in reporting federal awards. Broomfield incorrectly reported expenditures for six programs in the aggregate amount of $1,343,654. Broomfield also reported several inaccurate assistance listing numbers and program titles. Broomfield also did not report four programs with total expenditures of $621,198. Cause: Broomfield did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. Broomfield experienced turnover in the preparer and reviewer functions for the grant tracking and reporting process during the year, and the new 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: 2021-001 Recommendation: Broomfield 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: Broomfield agrees with the finding and has created a corrective action plan for the finding. See the corrective action plan included in this report.
Finding 2022-002 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. Broomfield 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 SEFA was incomplete and inaccurate, which led to several errors in reporting federal awards. Broomfield incorrectly reported expenditures for six programs in the aggregate amount of $1,343,654. Broomfield also reported several inaccurate assistance listing numbers and program titles. Broomfield also did not report four programs with total expenditures of $621,198. Cause: Broomfield did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. Broomfield experienced turnover in the preparer and reviewer functions for the grant tracking and reporting process during the year, and the new 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: 2021-001 Recommendation: Broomfield 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: Broomfield agrees with the finding and has created a corrective action plan for the finding. See the corrective action plan included in this report.
Finding 2022-002 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. Broomfield 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 SEFA was incomplete and inaccurate, which led to several errors in reporting federal awards. Broomfield incorrectly reported expenditures for six programs in the aggregate amount of $1,343,654. Broomfield also reported several inaccurate assistance listing numbers and program titles. Broomfield also did not report four programs with total expenditures of $621,198. Cause: Broomfield did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. Broomfield experienced turnover in the preparer and reviewer functions for the grant tracking and reporting process during the year, and the new 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: 2021-001 Recommendation: Broomfield 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: Broomfield agrees with the finding and has created a corrective action plan for the finding. See the corrective action plan included in this report.
Finding 2022-002 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. Broomfield 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 SEFA was incomplete and inaccurate, which led to several errors in reporting federal awards. Broomfield incorrectly reported expenditures for six programs in the aggregate amount of $1,343,654. Broomfield also reported several inaccurate assistance listing numbers and program titles. Broomfield also did not report four programs with total expenditures of $621,198. Cause: Broomfield did not have adequate training and oversight in place for accounting staff to ensure its SEFA was prepared in accordance with federal requirements. Broomfield experienced turnover in the preparer and reviewer functions for the grant tracking and reporting process during the year, and the new 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: 2021-001 Recommendation: Broomfield 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: Broomfield agrees with the finding and has created a corrective action plan for the finding. See the corrective action plan included in this report.
Material Weakness Assistance Listing # 84.425C Finding 2022 ? 001 is a finding for the major federal program as the timely and accurate reconciliation and cutoffs are requirements under the Uniform Guidance. Condition: Accurate financial reporting was not performed on a timely basis. Criteria: 2 CFR Section 200.510 requires the auditee must 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 section 200.502. Condition: The schedule of expenditures of federal awards did not include all expenditures occurred during the year. Context: This is a condition identified based on review of Uniform Guidance requirements. Questioned costs: $0. Cause: Accounts were not properly reconciled in a timely manner, and cutoffs on federal grant revenue and expenditures were not properly maintained. Effect: The federal expenditure amount was understated as of year-end. Identification of a Repeat Finding: This is not a repeat finding. Recommendation: Procedures need to be developed for the following: - Management should implement procedures to complete and reconcile all financial information within a reasonable time after year-end. - Management should implement a review procedure to ensure the appropriate cutoff of all accounts.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Assistance Listing Number, Federal Agency, and Program Name - 20.106, Federal Aviation Administration, Airport Improvement Program Federal Award Identification Number and Year - N/A Pass through Entity - N/A Finding Type - Material weakness Repeat Finding - No Criteria Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expended. Condition - The SEFA required adjustments related to expenditures that were both improperly included and excluded, resulting in revisions to correct the SEFA. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - The adjustments made to the schedule of expenditures of federal awards did not impact major program determination. There were certain expenditures that were identified during testing that should have been both included on ($1,815,968) and excluded from ($882,831) the SEFA related to ALN 20.106 (Airport Improvement Program). Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively. This resulted in an inaccurate schedule of expenditures of federal awards provided for audit. Recommendation - Internal control procedures should be evaluated and revised to ensure that the schedule of expenditures of federal awards is complete and accurate. Views of Responsible Officials and Planned Corrective Actions - Proper accrual accounting will be followed with regard to reporting SEFA expenditures, with period recognition more closely monitored.
Finding: 2022-001 Inaccurate SEFA reporting Name of Federal agency: Federal Transit Administration Name of applicable pass-through entity: Not applicable Federal program: Federal Transit Cluster: COVID-19 ? Federal Transit Formula Grants and State of Good Repair Grants; Public Transportation Emergency Relief Program Assistance listing number: 20.507, 20.525 and 20.527 Federal Award Number(s): AK-2022-005-00, AK-2022-002-00, AK-2023-004-00, and AK-2023-003-00 Federal award year: January 1, 2022 ? December 31, 2022 Condition Found: The Corporation did not have adequate controls relating to the reporting of expenditures for the Federal Transit Administration grants in the schedule of expenditures of federal awards. Specifically, the amounts reported in the schedule of expenditures of federal awards for this program that was originally provided to the auditors did not include $9,374,427 of expenditures that had been previously reported and the schedule incorrectly included $3,333,684 of expenditures that should have been included in the subsequent year?s SEFA, based on the award dates of these grants. As a result of these errors, there was no change in the major programs subject to testing. Criteria: 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. 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 information provided for audit purposes is complete and accurate. Cause: In discussing these conditions with the Corporation, they stated that the Corporation consistently followed a policy to report expenditures when expenditures are incurred and the award is granted prior to the SEFA drafting. Management did not have a control in place to review new implementation guides which clarified how the award timing impacted the SEFA reporting timing and update their long-standing policy accordingly.Possible Asserted Effect: Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may result in incorrect major program determination. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the Corporation establish internal controls to ensure Federal Transit Administration expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Views of Responsible Officials: Management agrees with the finding. Management will implement additional controls to ensure the completeness and accuracy of amounts reported for expenditures of the Federal Transit Administration grants in the schedule of federal awards. These additional controls include the annual review of new implementation guides.
Finding: 2022-001 Inaccurate SEFA reporting Name of Federal agency: Federal Transit Administration Name of applicable pass-through entity: Not applicable Federal program: Federal Transit Cluster: COVID-19 ? Federal Transit Formula Grants and State of Good Repair Grants; Public Transportation Emergency Relief Program Assistance listing number: 20.507, 20.525 and 20.527 Federal Award Number(s): AK-2022-005-00, AK-2022-002-00, AK-2023-004-00, and AK-2023-003-00 Federal award year: January 1, 2022 ? December 31, 2022 Condition Found: The Corporation did not have adequate controls relating to the reporting of expenditures for the Federal Transit Administration grants in the schedule of expenditures of federal awards. Specifically, the amounts reported in the schedule of expenditures of federal awards for this program that was originally provided to the auditors did not include $9,374,427 of expenditures that had been previously reported and the schedule incorrectly included $3,333,684 of expenditures that should have been included in the subsequent year?s SEFA, based on the award dates of these grants. As a result of these errors, there was no change in the major programs subject to testing. Criteria: 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. 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 information provided for audit purposes is complete and accurate. Cause: In discussing these conditions with the Corporation, they stated that the Corporation consistently followed a policy to report expenditures when expenditures are incurred and the award is granted prior to the SEFA drafting. Management did not have a control in place to review new implementation guides which clarified how the award timing impacted the SEFA reporting timing and update their long-standing policy accordingly.Possible Asserted Effect: Failure to establish effective internal controls regarding financial reporting for the preparation of the SEFA may result in incorrect major program determination. Repeat Finding: A similar finding was not reported in the prior year audit. Statistical Sampling: The sample was not intended to be, and was not, a statistically valid sample. Recommendation: We recommend the Corporation establish internal controls to ensure Federal Transit Administration expenditures are accurately reported on the SEFA and information provided for audit purposes is complete and accurate. Views of Responsible Officials: Management agrees with the finding. Management will implement additional controls to ensure the completeness and accuracy of amounts reported for expenditures of the Federal Transit Administration grants in the schedule of federal awards. These additional controls include the annual review of new implementation guides.
2 CFR ? 1000 gives regulatory effect to the United States Department of Treasury for 2 CFR ? 200.328 and 329 which states, in part, that unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly. Additionally, program-specific reporting requirements under the Emergency Rental Assistance Program 1 & 2 (ERA) and State and Local Fiscal Recovery Funds (SLFRF), requires all ERA and SLFRF grantees must submit quarterly reports with reporting periods of one calendar quarter and several cumulative fields covering all activity from the date of award through the quarter close. The key line items in the form are: 1. The cumulative amount obligated by the grantee; and 2. The cumulative amount expended by the grantee Additionally, 2 CFR Subpart F ? 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County?s financial statements which must include the total federal awards expended as determined in accordance with ? 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in ? 200.414 Indirect (F&A) costs. Testing over the County's quarterly reporting requirements for the ERA program identified the following: "See Schedule of Findings for table" Furthermore, testing over the County's quarterly reporting requirements for the SLFRF program identified the following: "See Schedule of Findings for table" Furthermore, the lack of effective controls over this compliance requirement resulted in the Schedule being misstated. As a result of the cumulative expenditure amounts being incorrectly reported for the SLFRF program, the County's Schedule of Expenditures of Federal Awards (Schedule) was overstated by $3,091,886. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. County management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the County is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
2 CFR ? 1000 gives regulatory effect to the United States Department of Treasury for 2 CFR ? 200.328 and 329 which states, in part, that unless otherwise approved by OMB, the Federal awarding agency must solicit only the OMB-approved governmentwide data elements for collection of financial information at time of publication the Federal Financial Report or such future, OMB-approved, governmentwide data elements available from the OMB-designated standards lead. This information must be collected with the frequency required by the terms and conditions of the Federal award, but no less frequently than annually nor more frequently than quarterly. Additionally, program-specific reporting requirements under the Emergency Rental Assistance Program 1 & 2 (ERA) and State and Local Fiscal Recovery Funds (SLFRF), requires all ERA and SLFRF grantees must submit quarterly reports with reporting periods of one calendar quarter and several cumulative fields covering all activity from the date of award through the quarter close. The key line items in the form are: 1. The cumulative amount obligated by the grantee; and 2. The cumulative amount expended by the grantee Additionally, 2 CFR Subpart F ? 200.510(b) requires the auditee to prepare a Schedule of Expenditures of Federal Awards (the Schedule) for the period covered by the County?s financial statements which must include the total federal awards expended as determined in accordance with ? 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. (2) For Federal awards received as a subrecipient, the name of the pass-through entity and identifying number assigned by the pass-through entity must be included. (3) Provide total Federal awards expended for each individual Federal program and the AL number or other identifying number when the AL information is not available. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in ? 200.502 Basis for determining Federal awards expended, paragraph (b), identify in the notes to the schedule the balances outstanding at the end of the audit period. (6) Include notes that describe the significant accounting policies used in preparing the schedule, and note whether or not the auditee has elected to use the 10 percent de minimis cost rate as covered in ? 200.414 Indirect (F&A) costs. Testing over the County's quarterly reporting requirements for the ERA program identified the following: "See Schedule of Findings for table" Furthermore, testing over the County's quarterly reporting requirements for the SLFRF program identified the following: "See Schedule of Findings for table" Furthermore, the lack of effective controls over this compliance requirement resulted in the Schedule being misstated. As a result of the cumulative expenditure amounts being incorrectly reported for the SLFRF program, the County's Schedule of Expenditures of Federal Awards (Schedule) was overstated by $3,091,886. Adjustments, to which management have agreed, are reflected in the accompanying Schedule. Noncompliance with grant requirements as well as errors and omissions on the Schedule of Expenditures of Federal Awards could have an adverse effect on future grant awards by the awarding agency in addition to an inaccurate assessment of major federal programs that would be subjected to audit. County management should review all grant and loan award documents in order to execute policies and procedures which help ensure compliance with grant and loan requirements, including Schedule reporting requirements. The County should implement a system to track all federal expenditures and related information separately from other expenditures and report federal expenditures with proper support including, but not limited to, grant agreements, calculation of the expenditures, and any federal reporting requirements. This will help ensure the County is in compliance with grant and loan requirements, the Schedule is complete and accurate, and major federal programs are accurately identified for audit.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.
Finding 2022 ? 003 Identification of the federal program: Federal Agency: Department of Health and Human Services Assistance Listing No, Award Name, Award Number and Pass-through Entity: These federal awards were added to the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 93.127 Emergency Medical Services For Children EIIC University Hospitals Cleveland Medical Center 93.226 Research On Healthcare Costs, Quality and Outcomes 1R01HS029183-01 93.361 Nursing Research FY22.1180.001 University of Colorado Denver 93.575 Child Care and Development Block Grant Ohio Children?s Alliance Ohio Children?s Alliance 93.596 Child Care Mandatory And Matching Funds of the Child Care and Development Fund COVID-19 Ohio Child Care Resource and Referral Association 93.838 Lung Diseases Research 10059528-01-NWC The University of Utah 93.846 Arthritis, Musculoskeletal and Skin Diseases Research GRANT ID: GRT-00001510 Children?s Hospital of Philadelphia 93.855 Allergy and Infectious Diseases Research 034146-014 Arkansas Children?s Hospital Research Institute 93.855 Allergy and Infectious Diseases Research A635027 Emory University 93.855 Allergy and Infectious Diseases Research OS00000060/317962 Cincinnati Children?s Hospital Medical Center 93.865 Child Health and Human Development Extramural Research 9116-NCH Indiana University 93.865 Child Health and Human Development Extramural Research A21-0255-S002 UC Davis Medical Center 93.867 Vision Research CONTRACT ID 1803 JAEB Center For Health Section III?Federal Award Findings and Questioned Costs (continued) These federal awards were removed from the R&D Cluster: Assistance Listing Award Name Award Number Pass-Through Entity 16.575 Crime Victim Assistance 2022-SVAA-134716708 Crime Victims Assistance 16.575 Crime Victim Assistance 2022-VOCA-134716701 Crime Victims Assistance 16.575 Crime Victim Assistance 2022DVF42 Crime Victims Assistance 16.575 Crime Victim Assistance 2023-VOCA-135104760 Crime Victims Assistance 21.019 Coronavirus Relief Fund 2020-CARES-78 Crime Victims Assistance 93.110 Maternal and Child Health Federal Consolidated Programs 1 R40MC37541-01-00 93.110 Maternal and Child Health Federal Consolidated Programs RPPN University Hospitals Cleveland Medical Center 93.110 Maternal and Child Health Federal Consolidated Programs GR124424/SPC-1000005299 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs GR127800 SPC-1000006745 The Ohio State University 93.110 Maternal and Child Health Federal Consolidated Programs MCHB 436 22-23 Hemophilia Foundation of Michigan 93.558 Temporary Assistance for Needy Families 25-21-3536 Franklin County Department of Job And Family Services 93.575 Child Care and Development Block Grant IECMH Ohio Children?s Alliance 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246 Ohio Childrens Trust Fund 93.590 Community-Based Child Abuse Prevention Grants G-2223-22-0246-1 Ohio Childrens Trust Fund 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR125049 The Ohio State University 93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service GR128419 The Ohio State University 93.778 Medical Assistance Program GR124661 The Ohio State University 93.870 Maternal, Infant and Early Childhood Home Visiting Grant 02560511MH0622 Ohio Department of Health 93.959 Block Grants for Prevention and Treatment of Substance Abuse 2200026 Ohio Department of Mental Health Section III?Federal Award Findings and Questioned Costs (continued) Criteria or specific requirement (including statutory, regulatory, or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: ?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).? 2 CFR 200.510 requires that 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 in accordance with Section 200.502.? 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 and the ?Internal Control Integrated Framework? issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Condition: The Schedule of Expenditures of Federal Awards prepared by the Corporation did not appropriately reflect the federal expenses related to the R&D Cluster. The final Schedule was corrected for the differences identified. Cause: The Corporation did not design internal controls over the review and approval of the Schedule to ensure the appropriate federal awards were included in the R&D Cluster. Section III?Federal Award Findings and Questioned Costs (continued) Effect or potential effect: Federal awards were inappropriately included and excluded from the R&D Cluster. Questioned costs: None Context: Total R&D Cluster expenses included on the draft Schedule were $84,223,943 for the year ended December 31, 2022. Total R&D expenses included on the final Schedule were $82,409,498 for the year ended December 31, 2022. Total expenditures on the Schedule did not change. See the federal programs added and removed from the R&D Cluster in the Information on Federal Programs section above. Identification as a repeat finding, if applicable: Not a repeat finding Recommendation: We recommend that management implement more robust management review internal controls to ensure accurate reporting of federal awards on the Schedule.