Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
Condition During our audit, we identified several key accounts that had not been reviewed as of June 30, 2023. These accounts included: accounts receivable, revenue and long-term debt. As a result, the financial statements as of and for the year ended June 30, 2023, required additional time and analysis before the financial statements could be finalized and available for issuance. This also required audit adjustments that had a negative impact on net assets of $1,407,187. Criteria Per the Uniform Guidance, the School must maintain an adequate system of internal control over financial reporting in order to initiate, authorize, record, process and report financial data reliably in accordance with generally accepted accounting principles. Additionally, § 200.510 requires the auditee to prepare financial statements that reflect its financial position, results of operations or changes in net assets, and, where appropriate, cash flows for the fiscal year audited. Cause The School does not have adequate internal controls over financial reporting in place to ensure supervisory review and analysis for certain key accounts on a timely basis. Effect The delay in completing account analysis for the financial statement accounts could allow for misstatements, errors and irregularities to go undetected. Recommendation We recommend the School continue to reinforce its processes and procedures to ensure reconciliations and account analysis are completed and reviewed by appropriate supervisory personnel. The School should ensure accurate interim and year-end financial statements. Questioned Costs None. Managements Response Management agrees with the finding. See Schedule of Correction Action Plans. Auditor’s Conclusion: Finding remains as stated.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
2023-006 – Completeness and accuracy of certain programs on the Prior Year Schedules of Expenditures of Federal Awards (SEFA) - (Significant Deficiency) Cluster: Not applicable Sponsoring Agency: Department of Health and Human Services (DHHS) - Health Resources and Services Administration (HRSA), Department of Education (ED) and Federal Emergency Management Agency (FEMA) Award Names: COVID-19 Provider Relief Fund and ARP (ARP) Rural Distribution (PRF), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Portion, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters) and Maternal and Child Health Federal Consolidated Programs Award Numbers: Various Assistance Listing Titles: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution, COVID-19 Disaster Grants – Public Assistance (Presidentially Declared Disasters), COVID-19 Higher Education Emergency Relief Fund (HEERF) Student Aid Portion, COVID-19 HEERF Institutional Aid Portion, COVID-19 HEERF Minority Serving Institutions and Maternal and Child Health Federal Consolidated Programs Assistance Listing Number: 93.498, 97.036, 84.425E, 84.425F, 84.425L, 93.110 Award Year: 2020-2021, 2021-2022, 2019-2020, 2021-2023 Pass-through entity: Not applicable Criteria 2 CFR 200.510 Financial statements requires auditees to 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. The information presented should be consistent with the accounting records and other federal guidance. Condition The following errors were identified related to COVID-19 funding that was improperly excluded from prior year SEFAs and is being included in the FY2023 SEFA along with two issues related to current year activity that has been adjusted in the FY2023 SEFA: • FEMA o One campus and two medical centers had FEMA funding obligated and expended in FY2021 totaling $7.0 million, which was incorrectly excluded from the FY2021 SEFA. Management has included this amount on the FY2023 SEFA, and onethis of these medical centerscampus was selected for audit testing in FY2023. o Three campuses and one medical center had FEMA funding obligated and expended in FY2022 totaling $1.3 million, which was incorrectly excluded from the FY2022 SEFA. o One campus duplicated a project of $6.2 million in the SEFA during the preparation process and subsequently removed it to properly state the FY2023 SEFA. • PRF - Management at the University Office of the President brought to our attention that in the prior year, the PRF Period Two expenditures for a faculty practice group that is part of one campus, were not included on the FY2022 SEFA. This error totaled $13.4 million and represented 4% of total Period Two PRF expenditures included on the FY2022 SEFA and 0.2% of the total FY2022 SEFA. Management has included this amount on the 2023 SEFA and the campus was selected for audit testing in FY2023. • HEERF – One campus understated its HEERF funding by $286 thousand in 2020, two campuses understated their HEERF funding by $767 thousand in 2021 and four campuses understated their HEERF funding by $3.4 million in FY 2022. As such, the University recorded an adjustment of $4.4 million related to prior periods that increased the expenditures in the FY2023 SEFA for these previous omissions. These were identified by management through final HEERF reconciliations. In addition to the COVID-19 errors above, we identified that assistance listing 93.110 at one campus included $29 million of spending against accumulated program income in the FY2023 SEFA, which should have been excluded. This amount has been appropriately removed but was not identified by management through the SEFA review process. These errors did not impact the major program determination in 2021, 2022 or 2023 when considering programs across the University as a whole but has been determined to be a significant deficiency and is considered a repeat finding of 2022-008. Cause The COVID-19 pandemic resulted in the receipt and expenditure of federal funds across certain University medical centers where there has previously been limited to no federal funding and also resulted in a different nature of funding at certain of the campuses. The preparation of the SEFA requires information from each campus be provided to the University Office of the President for compilation, and the aggregation of the COVID-19 PRF and FEMA funding was manual. In addition, there was limited knowledge of the federal funding at the medical centers and thus a reliance on the part of management that each campus was reporting complete and accurate information. A final reconciliation of all portal submissions compared to the amounts on the SEFA also failed to detect the omitted PRF and FEMA expenditures in 2021 and 2022. Additionally, regarding the omitted HEERF amounts, the campuses did not discover the errors until reconciling FY2023 amounts to the GL and total award spending. Lastly, the campus used a federal general ledger code to track spending on accumulated program income and did not identify this as a code that should be excluded by the University Office of the President when accumulating the SEFA. Effect A SEFA that is not complete and accurate could impact the scoping of an entity’s major programs and result in incomplete information being provided to the federal government. Questioned Costs None noted. Recommendation We recommend updates on nonrecurring federal programs (e.g., FEMA, HEERF and PRF) at each campus (including the medical centers) be periodically provided to the team at the University Office of the President that is responsible for the compilation of the SEFA. This will allow for a more comprehensive understanding of the campus grant activity for these programs and the ability to better review and assess the completeness and accuracy reported for these programs on the University’s year-end SEFA, inclusive of these programs. One means by which this might be accomplished is to develop a checklist of anticipated awards by campus in advance of the year and also complete an interim SEFA to identify inconsistencies earlier in the fiscal year. We recommend the campuses review the interim SEFA for completeness and accuracy and provide a formal sign-off/approval to the University Office of the President. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.
Finding # 2023-002 Program: Various, including AL 20.509 – Formula Grants for Rural Areas and Tribal Transit Program – Reporting Grant Number & Year: Various Federal Grantor Agency: Various, including U.S. Department of Transportation Pass-Through Entity: Various, including Nebraska Department of Transportation Criteria: Title 2 of the U.S. Code of Federal Regulations (CFR) § 200.510(b) (January 1, 2023) states, in part, the following: The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. . . . (2) For Federal awards received as a subrecipient, the name of the passthrough entity and identifying number assigned by the pass-through entity must be included. . . . Title 2 CFR § 200.302(b) (January 1, 2023) states, in relevant part, the following: The financial management system of each non-Federal entity must provide for the following . . . (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. Title 2 CFR § 200.303 (January 1, 2023) states the following, in relevant part: The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ‘‘Standards for Internal Control in the Federal Government’’ issued by the Comptroller General of the United States or the ‘‘Internal Control Integrated Framework’’, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO). Title 2 CFR § 200.511(a) (January 1, 2023) requires the auditee to prepare a summary schedule of prior audit findings. Per subsection (b)(2) of that same regulation, “When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding’s recurrence and planned corrective action, and any partial corrective action taken.” The U.S. Department of Transportation adopted the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards in Title 2 CFR § 1201.10 (January 1, 2023). A good internal control plan requires adequate procedures to ensure the Schedule of Expenditures Federal Awards (SEFA) is properly presented and includes all Federal expenditures made by the County during the fiscal year. Condition: Kimball County does not have adequate procedures in place to ensure the SEFA is prepared accurately and includes all Federal expenditures of the County. Consequently, there were numerous errors in the SEFA that were identified by the auditors. A similar finding was noted during the fiscal year 2022 audit. The Summary Schedule of Prior Audit Findings lists the status of this finding as complete. Repeat Finding: Finding # 2022-002 Questioned Costs: None Statistical Sample: No Context: Specifically, we noted the following errors during our audit: • Fiscal year 2023 Federal expenditures of $276,566 were improperly omitted from the SEFA for Assistance Listing 20.509. • Fiscal year 2022 Federal expenditures of $92,389 were improperly included as fiscal year 2023 expenditures for Assistance Listing 20.509. • Non-Federal expenditures of $253,869 were improperly included as Federal Expenditures for Assistance Listing 20.509. These expenditures were paid with State funds and, therefore, should not have been included on the SEFA. • The SEFA provided by Kimball County did not include the assistance listing number to which the expenditures were related, nor did it identify the name of the pass-through entity or the identifying number assigned by the pass-through entity. Corrections were made for these errors after they were identified by the auditors to ensure the SEFA was properly presented. Cause: Kimball County continues to lack personnel with adequate knowledge of Federal reporting and compliance requirements to prepare an accurate SEFA. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or failure to audit programs that should be audited. Recommendation: We recommend the County work with their pass-through entities to obtain training necessary to understand fully Federal reporting and compliance requirements, including how to prepare the SEFA accurately. View of Officials: The information provided to the auditors regarding the SEFA did contain additional information such as the Federal and State reimbursements for the months before and after the fiscal year. While it is our responsibility to provide just the information required, the information was trackable and accurate per month.
2023-003 Internal Control Over Financial Reporting Title and Assistance Listing Number of the Federal Program: 84.425D COVID-19 - Elementary and Secondary School Emergency Relief Fund; 84.425U COVID-19 - American Rescue plan - Elementary and Secondary School Emergency Relief Fiscal Year Finding Originated: 2023 Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Name of Federal Agency: Department of Education Pass-through Agency: Louisiana Department of Education / East Baton Rouge Parish School Board Questioned Costs: No questioned costs reported. Condition: Significant audit adjustments were required to fairly present the consolidated financial statements and related Schedule of Expenditures of Federal Awards (SEFA). Criteria: According to 2 CFR 200.508 “Auditee Responsibilities” the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 “Financial statements”). Title 2 CFR 200.510 “Financial statements” requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 “Financial management”, the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. When federal expenditures are incurred over $750,000, a Single Audit is required to be performed under Uniform Guidance. Failure to properly record federal expenditures could cause the Academies to not have a Single Audit performed, or have it performed improperly, which would be considered noncompliant with Uniform Guidance. Cause: The impacts of the financial statement audit adjustments are as follows: • Accounts receivable and revenue related to Employee Retention Tax Credits were overstated by $600,000. • Revenues and expenditures related to reimbursement-based federal grants included in testing as a major program were understated $426,863. The Academies did not record certain grant revenues and expenditures for expenditures paid directly by the granting agency on behalf of the Academies. This adjustment impacted the SEFA and financial statements. • Revenue related to Child Nutrition Program funds were overstated $19,150. This adjustment impacted the SEFA and financial statements. • Adjustments to property and equipment resulting in a net increase to net assets of $29,583. • Adjustments to accumulated depreciation resulting in a net decrease in net assets of $54,906. • Adjustments to inter-school payable amounts resulting in a net increase in net assets of $23,015. • Adjustments to accounts payable resulting in a net increase in net assets of $60,179. • Adjustments to due to management company resulting in a net increase in net assets of $45,903. • Adjustments to compensated absences resulting in a net decrease in net assets of $24,391. Effect: The consolidated financial statements and related SEFA required material adjustments in order to be presented fairly. A lack of accounting practices can cause potential misstatements to remain unidentified and cause the financial statements and related schedules to be misleading. Noncompliance with Uniform Guidance may result in a temporary suspension of federal awards. Recommendation: We recommend the Academies implement monthly financial statement closing procedures which capture all relevant information necessary to reconcile accounts to supporting documentation on a timely basis. These procedures should include implementing internal controls over recording and monitoring revenues related to federal awards to ensure accuracy of funds recorded. Views of responsible officials: See views of responsible officials on page 36.
2023-003 Internal Control Over Financial Reporting Title and Assistance Listing Number of the Federal Program: 84.425D COVID-19 - Elementary and Secondary School Emergency Relief Fund; 84.425U COVID-19 - American Rescue plan - Elementary and Secondary School Emergency Relief Fiscal Year Finding Originated: 2023 Compliance Requirement: Activities Allowed or Unallowed, Allowable Costs/Cost Principles Name of Federal Agency: Department of Education Pass-through Agency: Louisiana Department of Education / East Baton Rouge Parish School Board Questioned Costs: No questioned costs reported. Condition: Significant audit adjustments were required to fairly present the consolidated financial statements and related Schedule of Expenditures of Federal Awards (SEFA). Criteria: According to 2 CFR 200.508 “Auditee Responsibilities” the auditee must prepare appropriate financial statements, including the SEFA (as specifically defined under 2 CFR 200.510 “Financial statements”). Title 2 CFR 200.510 “Financial statements” requires recipients of Federal funds to prepare a SEFA for the period covered by the auditee’s financial statements, which must include the total Federal awards expended. In addition, as noted in 2 CFR 200.302 “Financial management”, the financial management system of each non-Federal entity must provide for identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received, and records that identify adequately the source and application of funds for federally-funded activities including expenditures. When federal expenditures are incurred over $750,000, a Single Audit is required to be performed under Uniform Guidance. Failure to properly record federal expenditures could cause the Academies to not have a Single Audit performed, or have it performed improperly, which would be considered noncompliant with Uniform Guidance. Cause: The impacts of the financial statement audit adjustments are as follows: • Accounts receivable and revenue related to Employee Retention Tax Credits were overstated by $600,000. • Revenues and expenditures related to reimbursement-based federal grants included in testing as a major program were understated $426,863. The Academies did not record certain grant revenues and expenditures for expenditures paid directly by the granting agency on behalf of the Academies. This adjustment impacted the SEFA and financial statements. • Revenue related to Child Nutrition Program funds were overstated $19,150. This adjustment impacted the SEFA and financial statements. • Adjustments to property and equipment resulting in a net increase to net assets of $29,583. • Adjustments to accumulated depreciation resulting in a net decrease in net assets of $54,906. • Adjustments to inter-school payable amounts resulting in a net increase in net assets of $23,015. • Adjustments to accounts payable resulting in a net increase in net assets of $60,179. • Adjustments to due to management company resulting in a net increase in net assets of $45,903. • Adjustments to compensated absences resulting in a net decrease in net assets of $24,391. Effect: The consolidated financial statements and related SEFA required material adjustments in order to be presented fairly. A lack of accounting practices can cause potential misstatements to remain unidentified and cause the financial statements and related schedules to be misleading. Noncompliance with Uniform Guidance may result in a temporary suspension of federal awards. Recommendation: We recommend the Academies implement monthly financial statement closing procedures which capture all relevant information necessary to reconcile accounts to supporting documentation on a timely basis. These procedures should include implementing internal controls over recording and monitoring revenues related to federal awards to ensure accuracy of funds recorded. Views of responsible officials: See views of responsible officials on page 36.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Information of the federal program: Federal Grantor: United States Department of Housing and Urban Development Assistance Listing No.: 14.241, Housing Opportunities for Persons with AIDS Ascension Ministry Market: Illinois Pass-Through Grantor: AIDS Foundation of Chicago Federal Grantor: United States Department of Justice Assistance Listing No.: 16.560, National Institute of Justice Research, Evaluation, and Development Project Grants Ascension Ministry Market: Texas Federal Grantor: United States Department of Justice Assistance Listing No.: 16.710, Public Safety Partnership and Community Policing Grants Ascension Ministry Market: Illinois Pass-Through Grantor: The Village of Arlington Heights Police Department Federal Grantor: United States Department of the Treasury Assistance Listing No.: 21.027, COVID-19 Coronavirus State and Local Fiscal Recovery Funds Ascension Ministry Market: Maryland Pass-Through Grantor: Mayor and City Council of Baltimore, through MONSE Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.650, Accountable Health Communities Ascension Ministry Market: Illinois Federal Grantor: United States Department of Health and Human Services Assistance Listing No.: 93.958, Block Grants for Community Mental Health Services Ascension Ministry Market: Illinois Pass-Through Grantor: The State of Illinois Department of Human Services Federal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.036, Disaster Grants – Public Assistance (Presidentially Declared Disasters) Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency ManagementFederal Grantor: United States Department of Homeland Security Assistance Listing No.: 97.039, Hazard Mitigation Grant Ascension Ministry Market: Florida Pass-Through Grantor: Florida Division of Emergency Management Criteria or specific requirement (including statutory, regulatory, or other citation): 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).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. 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 §200.502 Basis for determining Federal awards expended.” Condition: A grant with expenditures of $55,702 under Assistance Listing No. 14.241 was not included on the preliminary schedule of expenditures of federal awards (the Schedule) provided by management; the final Schedule was corrected. (Alexian Brothers-Bonaventure House, Illinois) A grant with expenditures of $204,574 under Assistance Listing No. 16.560 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (Ascension Seton, Texas) Expenditures in the amount of $89,084 under Assistance Listing No. 16.710 were improperly classified as Assistance Listing No. 93.958; the final Schedule was corrected. (Presence Behavioral Health, Illinois) A grant with expenditures of $230,108 under Assistance Listing No. 21.027 was included on the preliminary Schedule and was subsequently excluded when it was identified as a beneficiary award and not a subrecipient award; the final Schedule was corrected (Ascension Via Christi Hospitals Wichita, Inc., Kansas). A grant with expenditures of $164,195 under Assistance Listing No. 21.027 was not included on the preliminary Schedule provided by management; the final Schedule was corrected. (St. Agnes Healthcare, Inc., Maryland) Expenditures under Assistance Listing No. 93.650 were reported twice on the preliminary Schedule, resulting in overstatement of $314,551; the final Schedule was corrected. (Alexian Brothers Hospital Network, Illinois) A grant with expenditures of $232,713 under Assistance Listing No. 97.039 was misclassified as Assistance Listing No. 97.036; the final Schedule was corrected. (St. Vincent’s Health System, Florida) Cause: Ascension’s (the System) internal controls in place over the preparation of the Schedule were not sufficient to properly accumulate and accurately report all expenditures of federal awards. Effect or Potential Effect: Inaccurate or improper reporting of expenditures results in a misstated Schedule and can also potentially result in insufficient testing of the major programs or improper identification of major programs for audit purposes. Questioned costs: None. Context:The table below shows the preliminary and adjusted assistance listing on the Schedule. See table/chart in the finding. Identification as a repeat finding, if applicable: The finding is not a repeat finding from the prior year. Recommendation: Management should implement more robust internal controls to ensure the assistance listing numbers are appropriately listed on the Schedule and all federal expenditures are appropriately identified and reported on the Schedule. Views of responsible officials: The System will enhance grant management award processes by revising its onboarding procedures and add additional controls to monitor for accuracy of the core data. Management will reinforce the importance of timeliness and accuracy of the SEFA reporting totals to facilitate accurate reporting. Award amounts were changed on the SEFA reporting schedules after management’s review was executed. Management will implement preventive controls to lock down market SEFA templates after management final review.
Program: Various, including AL 93.575, 93.596 – CCDF Cluster; AL 93.558 – Temporary Assistance for Needy Families –– Reporting Grant Number & Year: Various, including 2301NECCDF, FFY 2023; 2101NETANF, FFY 2021 Federal Grantor Agency: Various, including U.S. Department of Health and Human Services Criteria: A good internal control plan requires: 1) adequate procedures to ensure the Schedule of Expenditures of Federal Awards (SEFA) is properly presented; and 2) the auditee to reconcile the SEFA to the financial statements to ensure the schedule is complete and accurate. Title 45 CFR § 75.510(b) (October 1, 2022) and Title 2 CFR § 200.510(b) (January 1, 2023) state 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 . . . . At a minimum, the schedule must: * * * * (3) Provide total Federal awards expended for each individual Federal program . . . (4) Include the total amount provided to subrecipients from each Federal program. Neb. Rev. Stat. § 81-1111(1) (Reissue 2014) states, in part, the following: Subject to the supervision of the Director of Administrative Services, the Accounting Administrator shall have the authority to prescribe the system of accounts and accounting to be maintained by the state and its departments and agencies, develop necessary accounting policies and procedures, coordinate and approve all proposed financial systems, and manage all accounting matters of the state's central system. EnterpriseOne is the official accounting system of the State. Title 45 CFR § 75.511(a) (October 1, 2022) and 2 CFR § 200.511 (January 1, 2023) require the auditee to prepare a summary schedule of prior audit findings. Subsection (b)(2) of both regulations provides the following, as is relevant: When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding’s recurrence and planned corrective action, and any partial corrective action taken. Condition: Several programs did not have expenditures or the amount provided to subrecipients accurately reported on the SEFA. We notified Administrative Services of the errors, and the SEFA was subsequently adjusted. The Summary Schedule of Prior Audit Findings lists the status as “completed.” A similar finding was noted in the prior audit. Repeat Finding: 2022-018 Questioned Costs: None Statistical Sample: No Context: Administrative Services is responsible for managing the accounting matters of the State and certifies the data collection form for the Statewide Single Audit. Administrative Services compiles the SEFA from information provided by the individual agencies and submits it to the auditor. During our review, we noted the following: The Department of Health and Human Services (DHHS) did not accurately report expenditures for several programs, including underreporting AL 93.575 by $3,909,201, underreporting AL 93.596 by $7,416,246, and overreporting AL 93.558 by $11,325,447. The Department of Military underreported AL 21.027 by $920,874. The Department of Labor underreported AL 17.225 by $3,696,585. Twenty-three programs for various State agencies needed correction. The total expenditures and amounts provided to subrecipients originally reported and per the final SEFA were as follows: See Schedule of Findings and Questioned Costs for chart/table. Cause: Administrative Services did not have adequate procedures to ensure the accuracy of amounts not pulled directly from the accounting system. Administrative Services established a specific account code for aid to subrecipients, but not all agencies utilized this account code. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or programs not audited that should be. Recommendation: We recommend Administrative Services improve procedures to ensure the SEFA is complete and accurate. Management Response: We will continue to work with State teammates to ensure the SEFA is accurate and complete. The original total SEFA expenditures were 99.98% accurate. APA Response: We agree that SEFA adjustments were not significant in total. However, errors amounting to millions of dollars for individual programs are unquestionably significant to those programs. Such errors could result, moreover, in a program not being audited as a major program when it should be.
Program: Various, including AL 93.575, 93.596 – CCDF Cluster; AL 93.558 – Temporary Assistance for Needy Families –– Reporting Grant Number & Year: Various, including 2301NECCDF, FFY 2023; 2101NETANF, FFY 2021 Federal Grantor Agency: Various, including U.S. Department of Health and Human Services Criteria: A good internal control plan requires: 1) adequate procedures to ensure the Schedule of Expenditures of Federal Awards (SEFA) is properly presented; and 2) the auditee to reconcile the SEFA to the financial statements to ensure the schedule is complete and accurate. Title 45 CFR § 75.510(b) (October 1, 2022) and Title 2 CFR § 200.510(b) (January 1, 2023) state 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 . . . . At a minimum, the schedule must: * * * * (3) Provide total Federal awards expended for each individual Federal program . . . (4) Include the total amount provided to subrecipients from each Federal program. Neb. Rev. Stat. § 81-1111(1) (Reissue 2014) states, in part, the following: Subject to the supervision of the Director of Administrative Services, the Accounting Administrator shall have the authority to prescribe the system of accounts and accounting to be maintained by the state and its departments and agencies, develop necessary accounting policies and procedures, coordinate and approve all proposed financial systems, and manage all accounting matters of the state's central system. EnterpriseOne is the official accounting system of the State. Title 45 CFR § 75.511(a) (October 1, 2022) and 2 CFR § 200.511 (January 1, 2023) require the auditee to prepare a summary schedule of prior audit findings. Subsection (b)(2) of both regulations provides the following, as is relevant: When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding’s recurrence and planned corrective action, and any partial corrective action taken. Condition: Several programs did not have expenditures or the amount provided to subrecipients accurately reported on the SEFA. We notified Administrative Services of the errors, and the SEFA was subsequently adjusted. The Summary Schedule of Prior Audit Findings lists the status as “completed.” A similar finding was noted in the prior audit. Repeat Finding: 2022-018 Questioned Costs: None Statistical Sample: No Context: Administrative Services is responsible for managing the accounting matters of the State and certifies the data collection form for the Statewide Single Audit. Administrative Services compiles the SEFA from information provided by the individual agencies and submits it to the auditor. During our review, we noted the following: The Department of Health and Human Services (DHHS) did not accurately report expenditures for several programs, including underreporting AL 93.575 by $3,909,201, underreporting AL 93.596 by $7,416,246, and overreporting AL 93.558 by $11,325,447. The Department of Military underreported AL 21.027 by $920,874. The Department of Labor underreported AL 17.225 by $3,696,585. Twenty-three programs for various State agencies needed correction. The total expenditures and amounts provided to subrecipients originally reported and per the final SEFA were as follows: See Schedule of Findings and Questioned Costs for chart/table. Cause: Administrative Services did not have adequate procedures to ensure the accuracy of amounts not pulled directly from the accounting system. Administrative Services established a specific account code for aid to subrecipients, but not all agencies utilized this account code. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or programs not audited that should be. Recommendation: We recommend Administrative Services improve procedures to ensure the SEFA is complete and accurate. Management Response: We will continue to work with State teammates to ensure the SEFA is accurate and complete. The original total SEFA expenditures were 99.98% accurate. APA Response: We agree that SEFA adjustments were not significant in total. However, errors amounting to millions of dollars for individual programs are unquestionably significant to those programs. Such errors could result, moreover, in a program not being audited as a major program when it should be.
Program: Various, including AL 93.575, 93.596 – CCDF Cluster; AL 93.558 – Temporary Assistance for Needy Families –– Reporting Grant Number & Year: Various, including 2301NECCDF, FFY 2023; 2101NETANF, FFY 2021 Federal Grantor Agency: Various, including U.S. Department of Health and Human Services Criteria: A good internal control plan requires: 1) adequate procedures to ensure the Schedule of Expenditures of Federal Awards (SEFA) is properly presented; and 2) the auditee to reconcile the SEFA to the financial statements to ensure the schedule is complete and accurate. Title 45 CFR § 75.510(b) (October 1, 2022) and Title 2 CFR § 200.510(b) (January 1, 2023) state 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 . . . . At a minimum, the schedule must: * * * * (3) Provide total Federal awards expended for each individual Federal program . . . (4) Include the total amount provided to subrecipients from each Federal program. Neb. Rev. Stat. § 81-1111(1) (Reissue 2014) states, in part, the following: Subject to the supervision of the Director of Administrative Services, the Accounting Administrator shall have the authority to prescribe the system of accounts and accounting to be maintained by the state and its departments and agencies, develop necessary accounting policies and procedures, coordinate and approve all proposed financial systems, and manage all accounting matters of the state's central system. EnterpriseOne is the official accounting system of the State. Title 45 CFR § 75.511(a) (October 1, 2022) and 2 CFR § 200.511 (January 1, 2023) require the auditee to prepare a summary schedule of prior audit findings. Subsection (b)(2) of both regulations provides the following, as is relevant: When audit findings were not corrected or were only partially corrected, the summary schedule must describe the reasons for the finding’s recurrence and planned corrective action, and any partial corrective action taken. Condition: Several programs did not have expenditures or the amount provided to subrecipients accurately reported on the SEFA. We notified Administrative Services of the errors, and the SEFA was subsequently adjusted. The Summary Schedule of Prior Audit Findings lists the status as “completed.” A similar finding was noted in the prior audit. Repeat Finding: 2022-018 Questioned Costs: None Statistical Sample: No Context: Administrative Services is responsible for managing the accounting matters of the State and certifies the data collection form for the Statewide Single Audit. Administrative Services compiles the SEFA from information provided by the individual agencies and submits it to the auditor. During our review, we noted the following: The Department of Health and Human Services (DHHS) did not accurately report expenditures for several programs, including underreporting AL 93.575 by $3,909,201, underreporting AL 93.596 by $7,416,246, and overreporting AL 93.558 by $11,325,447. The Department of Military underreported AL 21.027 by $920,874. The Department of Labor underreported AL 17.225 by $3,696,585. Twenty-three programs for various State agencies needed correction. The total expenditures and amounts provided to subrecipients originally reported and per the final SEFA were as follows: See Schedule of Findings and Questioned Costs for chart/table. Cause: Administrative Services did not have adequate procedures to ensure the accuracy of amounts not pulled directly from the accounting system. Administrative Services established a specific account code for aid to subrecipients, but not all agencies utilized this account code. Effect: Increased risk for the SEFA to be inaccurate, which could lead to Federal sanctions or programs not audited that should be. Recommendation: We recommend Administrative Services improve procedures to ensure the SEFA is complete and accurate. Management Response: We will continue to work with State teammates to ensure the SEFA is accurate and complete. The original total SEFA expenditures were 99.98% accurate. APA Response: We agree that SEFA adjustments were not significant in total. However, errors amounting to millions of dollars for individual programs are unquestionably significant to those programs. Such errors could result, moreover, in a program not being audited as a major program when it should be.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-001: SEFA Reporting – R&D Classification Federal Agency: Department of Health and Human Services Federal Program Title: Medical Student Education Program, Prevention of Disease, Disability, and Death by Infection Diseases, and Postdoctoral Training in General Dentistry Assistance Listing Number: 93.680, 93.084, 93.059 Award Number and Year: T99HP39200 (July 1, 2020 – June 30, 2024), NU2GGH002319 (September 30, 2020 – September 29, 2024), D88HP375559200 (July 1, 2020 – June 30, 2024) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by UMMC incorrectly reported $4,558,549 in the Research & Development Cluster that should have been classified as expenditures for the Medical Student Education program (Assistance Listing 93.680). • Amounts provided by UMMC incorrectly reported $622,758 in the Research & Development Cluster that should have been classified as expenditures for the Prevention of Disease, Disability, and Death by Infection Diseases Program (Assistance Listing 93.084). • Amounts provided by UMMC incorrectly reported $383,695 in the Research & Development Cluster that should have been classified as expenditures for the Postdoctoral Training in General Dentistry Program (Assistance Listing 93.059). Cause: Awards were incorrectly coded as Research & Development during the award set-up process. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-002: SEFA Reporting- Incorrect Assistance Listing Numbers, Non-Federal Amounts on SEFA Federal Agency: Department of Education Federal Program Title: Title I, Special Education Grants to States, Career and Technical Education Assistance Listing Number: 84.010, 84.027, 84.048 Award Number and Year: VS010A0180024 (July 1, 2020 – June 30, 2023), H027A190108 (July 1, 2020 – June 30, 2023), V048A190024 (July 1, 2020 – June 30, 2023) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Applicable Institution: Mississippi State University (MSU) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: The Schedule of Expenditures of Federal Awards (SEFA) contained errors and incorrect information which affected the major program determination. Questioned Costs: None noted as the reporting requirement does not affect the allowability of costs and/or activities. Context: The following SEFA errors were noted: • Amounts provided by MSU incorrectly reported $371,067 in the Title I Program (Assistance Listing 84.010) that should have been reported in Special Education Grants to States (Assistance Listing Number 84.027). • Amounts provided by MSU incorrectly reported $902,101 in the Title I Program (Assistance Listing 84.010) that should have been reported in Career and Technical Education (Assistance Listing Number 84.048). • Amounts provided by MSU incorrectly reported $2,011,409 in the Title I Program (Assistance Listing 84.010) that were State Grants and not reportable on the SEFA. Cause: Mississippi State University did not have a process in place for awards that includes multiple ALNs and sources of funding. Effect: The SEFA was not prepared in accordance with OMB requirements which affects the major program risk assessment. Repeat Finding: 2022-002 Recommendation: We recommend the institution review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified and classified. Views of Responsible Officials: There is no disagreement with the audit finding.
2023-003: SEFA Reporting –Expenditures Recorded in the Incorrect Period Federal Agency: Department of Health and Human Services Federal Program Title: Telehealth Center of Excellence Assistance Listing Number: 93.211 Award Number and Year: U6631459 (September 1, 2021 – September 29, 2026) Award Period: July 1, 2022 – June 30, 2023 Type of Finding: Significant Deficiency in Internal Control Over Compliance, Other Matters Applicable Institution: University of Mississippi Medical Center (UMMC) Criteria or Specific Requirement: Internal Control – Per 2 CFR section 200.303(a), a non-Federal entity must: 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). Compliance – 2 CFR, Part 200 – Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, Subpart F, §200.510(b) requires that auditees prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with §200.502. Condition: Schedule of Expenditures of Federal Awards (SEFA) contained salary expenses of $1,175 that were not allowable and should have been removed from the SEFA. Questioned Costs: None. Context: For 1 out of 60 payroll expenditures selected for testing, the amount was not allowable and should not have been charged to the grant. Cause: Transfer of project expenditures occurred late and resulted in effort not being certified for salary amount in question. As a result, the salary was not reported to the sponsor via an invoice or financial report. However, the department did not remove the salary expenditure from the project in a timely manner. Effect: The SEFA does not reflect the accurate amount of federal expenditures for the year. Repeat Finding: 2022-002 Recommendation: We recommend the institutions review and revise its current reporting procedures and review requirements to ensure that federal expenditures are properly identified, recorded, and classified in the accurate year. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Program Information: Transition Program for Students with Intellectual Disabilities into Higher Education Grant (ALN: 84.407A). Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): The auditee 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 § 200.502. At a minimum, the schedule must: (1) List individual Federal programs by Federal agency. For a cluster of programs, provide the cluster name, list individual Federal programs within the cluster of programs, and provide the applicable Federal agency name. For R&D, total Federal awards expended must be shown either by individual Federal award or by Federal agency and major subdivision within the 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 Assistance Listings Number or other identifying number when the Assistance Listings information is not available. For a cluster of programs also provide the total for the cluster. (4) Include the total amount provided to subrecipients from each Federal program. (5) For loan or loan guarantee programs described in § 200.502(b), identify in the notes to the schedule the balances outstanding at the end of the audit period. This is in addition to including the total Federal awards expended for loan or loan guarantee programs in the schedule. (6) Include notes that describe that significant accounting policies used in preparing the schedule, and note whether or not the auditee elected to use the 10% de minimis cost rate as covered in § 200.414 (2 CFR section 200.510(b)). Condition: For certain Federal grant programs presented on the SEFA, the total amount provided to subrecipients during the year was not included. Cause: Administrative oversight with respect to SEFA preparation. Effect or Potential Effect: The University was not in compliance with SEFA presentation and disclosure requirements. Questioned Costs: None. Context: The University did not properly present and disclose approximately $162,000 of funds passed to subrecipients under the Transition Programs for Students with Intellectual Disabilities into Higher Education grant (ALN 84.407A) on the SEFA for the year ended June 30, 2023. Identification as a Repeat Finding: No similar findings noted in the prior year. Recommendation: We recommend the University enhance its policies and procedures to ensure that the SEFA has been prepared in accordance with the required guidelines and that it contains all minimum required elements that must be presented and disclosed, in accordance with federal regulations. Views of Responsible Officials and Planned Corrective Actions: The University Finance department has updated their policies and procedures to ensure that the SEFA is being prepared in accordance with required guidelines. We will work closely with our grants department to ensure all required elements are properly identified and disclosed.
Condition – The Corporation did not report $2,000,000 of CSLFRF grant expenditures received by Saint Agnes Medical Center Fresno (“Fresno”) in the consolidated SEFA for the year ended June 30, 2022. This resulted in an understatement of CSLFRF expenditures on the Corporation’s SEFA for the year ended June 30, 2022. This issue was discussed with the County of Fresno, the pass-through granting agency for this program, who requested the omitted CSLFRF expenditures be tested and included in the Corporation’s SEFA for the year ended June 30, 2023. Criteria – According to § 200.510(b) of the Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, “The auditee must also prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502.” Cause – The Fresno accounting department reported the CSLFRF grant to the Trinity Health Financial Reporting team incorrectly which resulted in the Fresno CSLFRF grant not being included in ALN 21.027, which was a major program for the year ended June 30, 2022. Effect – The Corporation’s SEFA for the year ended June 30, 2022 was understated by $2,000,000. Consequences for failure to comply with grant conditions may include a reduction of overall award and/or a restriction or reduction in future awards. Questioned costs – None Context – The Corporation did not report $2,000,000 of CSLFRF funds on its prior year SEFA. Repeat Finding from Prior Year – No Recommendation – The Corporation should institute additional policies and procedures to ensure grant expenditures reported by all locations are appropriately and completely included in the consolidated SEFA.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.
2023-001 Program: CDBG - Entitlement Grants Cluster / Highway Planning and Construction / Nationally Significant Freight and Highway Project Funds Federal Financial Assistance Listing No.: 14.218 / 20.205 / 20.934 Federal Agency: U.S. Department of Housing and Urban Development / U.S. Department of Transportation Direct Award: U.S. Department of Housing and Urban Development Pass-through: California Department of Transportation in relation to the Highway Planning and Construction and Nationally Significant Freight and Highway Project Funds Award Year: Multiple Grant Award Number: Multiple Compliance Requirements: Other - Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) - Schedule of expenditures of Federal awards Type of Finding: Material Weakness in Internal Control over Compliance Criteria: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) §200.510(b) states that the auditee (the City) 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 §200.502. In addition, §200.303 of the Uniform Guidance states that the City must establish and maintain effective internal control over the federal awards, including controls over the accuracy of program information and expenditure amounts. Condition: During our audit procedures performed over the SEFA and expenditures reported for the CDBG - Entitlement Grants Cluster, Highway Planning and Construction, and Nationally Significant Freight and Highway Project Funds, we noted the following: 1. The City did not properly identify the amount expended for the CDBG - Entitlement Grants Cluster, AL No. 14.218. The expenditures reported by the City were understated by $154,071. 2. The City did not properly identify the amount expended for the Highway Planning and Construction, AL No. 20.205. The expenditures reported by the City were overstated by $5,098,179. 3. The City did not properly classify the amount expended for the Nationally Significant Freight and Highway Project Funds, AL No. 20.934. The expenditures reported by the City were understated by $2,769,610. Cause: As a result, the City lacks adequate internal controls to ensure the SEFA is completely and accurately stated. Specifically, the City’s processes for recording and tracking expenditures of federal awards are not designed so that expenditures are identified when incurred and assigned to the correct program name or cluster in a complete and timely manner. Effect: The SEFA, as originally presented, was overstated by $2,174,498. Questioned Costs: No questioned costs were identified as a result of our procedures. Context/Sampling: No sampling was used. Program expenditures on the SEFA were reconciled to supporting records. Repeat Finding from the Prior Year(s): No. Recommendation: The City should establish policies and implement internal controls to ensure all federal expenditures are accurately tracked and reported on the SEFA. Personnel knowledgeable of federal expenditures should review amounts coded to federal programs for completeness and accuracy. The SEFA should be prepared and reviewed in a timely manner and reconciled to underlying records as well as the basic financial statements. View of Responsible Official and Planned Corrective Actions See separate corrective action plan.