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.
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-054) Title: Internal control over DOT subrecipient and contractor determinations needs improvement Prior Year Findings: None State Department: Transportation State Bureau: Finance and Administration Planning Federal Agency: U.S. Department of Transportation Assistance Listing Title: Formula Grants for Rural Areas and Tribal Transit Program (COVID-19) Assistance Listing Number: 20.509 Federal Award Identification Number: See E-93 to E-94 Compliance Area: Reporting Subrecipient monitoring Type of Finding: Significant deficiency Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.331; 2 CFR 200.510 The Department must establish and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must make case-by-case determinations whether each agreement it makes for the disbursement of Federal program funds casts the party receiving the funds in the role of a subrecipient or a contractor. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (ALN) and include the total amount provided to subrecipients from each Federal program. Condition: The Department must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Office of the State Auditor reviewed SEFA amounts reported to OSC by the Department and identified $3,064,233 of Federal expenditures incorrectly reported as amounts provided to subrecipients that should have been reported as direct expenditures. The Department did not properly document the role of the parties receiving the funds as vendors and contractors or subrecipients. As a result, vendor and contractor payments were incorrectly included in the initial amount reported on the SEFA as amounts provided to subrecipients. Context: The Department erroneously reported amounts provided to subrecipients totaling $16.3 million and direct expenditures totaling $5.6 million. The correct amounts provided to subrecipients totaled $13.3 million and direct expenditures totaled $8.7 million for fiscal year 2023. Cause: • Lack of adequate procedures • Lack of supervisory oversight Effect: • Inaccurate classifications of subrecipients versus vendors could lead to monitoring the activities of vendors, thus utilizing resources that could be allocated to other program needs. • Incomplete or inaccurate reporting of expenditures on the SEFA, which is submitted to the Federal government, may result in incorrect information used for programmatic, policy or statistical purposes. Recommendation: We recommend that the Department enhance procedures to: • document the subrecipient determination process to properly classify vendors and contractors versus subrecipients; and • improve preparation, review, and submission of SEFA information to OSC. Corrective Action Plan: See F-25 Management’s Response: The Department agrees with this finding. The Department will update procedures to ensure the classification of subrecipients versus contractors is documented and to improve the SEFA information that is submitted. Contact: Kathleen Malcolm, Financial Processing Director, MDOT, 207-624-3292 (State Number: 23-1402-01)
(2023-054) Title: Internal control over DOT subrecipient and contractor determinations needs improvement Prior Year Findings: None State Department: Transportation State Bureau: Finance and Administration Planning Federal Agency: U.S. Department of Transportation Assistance Listing Title: Formula Grants for Rural Areas and Tribal Transit Program (COVID-19) Assistance Listing Number: 20.509 Federal Award Identification Number: See E-93 to E-94 Compliance Area: Reporting Subrecipient monitoring Type of Finding: Significant deficiency Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.331; 2 CFR 200.510 The Department must establish and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must make case-by-case determinations whether each agreement it makes for the disbursement of Federal program funds casts the party receiving the funds in the role of a subrecipient or a contractor. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (ALN) and include the total amount provided to subrecipients from each Federal program. Condition: The Department must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. OSC is responsible for compiling this information on behalf of the State. The Office of the State Auditor reviewed SEFA amounts reported to OSC by the Department and identified $3,064,233 of Federal expenditures incorrectly reported as amounts provided to subrecipients that should have been reported as direct expenditures. The Department did not properly document the role of the parties receiving the funds as vendors and contractors or subrecipients. As a result, vendor and contractor payments were incorrectly included in the initial amount reported on the SEFA as amounts provided to subrecipients. Context: The Department erroneously reported amounts provided to subrecipients totaling $16.3 million and direct expenditures totaling $5.6 million. The correct amounts provided to subrecipients totaled $13.3 million and direct expenditures totaled $8.7 million for fiscal year 2023. Cause: • Lack of adequate procedures • Lack of supervisory oversight Effect: • Inaccurate classifications of subrecipients versus vendors could lead to monitoring the activities of vendors, thus utilizing resources that could be allocated to other program needs. • Incomplete or inaccurate reporting of expenditures on the SEFA, which is submitted to the Federal government, may result in incorrect information used for programmatic, policy or statistical purposes. Recommendation: We recommend that the Department enhance procedures to: • document the subrecipient determination process to properly classify vendors and contractors versus subrecipients; and • improve preparation, review, and submission of SEFA information to OSC. Corrective Action Plan: See F-25 Management’s Response: The Department agrees with this finding. The Department will update procedures to ensure the classification of subrecipients versus contractors is documented and to improve the SEFA information that is submitted. Contact: Kathleen Malcolm, Financial Processing Director, MDOT, 207-624-3292 (State Number: 23-1402-01)
(2023-057) Title: Internal control over the submission of HAF Program Schedule of Expenditures of Federal Awards reporting needs improvement Prior Year Findings: None State Department: Administrative and Financial Services State Bureau: Security and Employment Service Center Federal Agency: U.S. Department of the Treasury Assistance Listing Title: Homeowner Assistance Fund Program (COVID-19) Assistance Listing Number: 21.026 Federal Award Identification Number: See E-93 to E-94 Compliance Area: Reporting Type of Finding: Material weakness Material noncompliance Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.510 The Department must establish and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must include the total amount provided to subrecipients from each Federal program. Condition: The Department must complete and submit exhibits and related schedules to the Office of the State Controller (OSC) at the close of each fiscal year to report Federal award information for inclusion on the State’s SEFA. Federal program expenditures reported on the SEFA must be segregated between direct award expenditures and amounts provided to subrecipients. OSC is responsible for compiling this information on behalf of the State. In fiscal year 2023, the Department of Professional and Financial Regulation received Federal funding and incurred related expenditures under ALN 21.026, the Homeowner Assistance Fund (HAF) Program. The Security and Employment Service Center (SESC), which is responsible for submitting the summary of HAF expenditures to OSC, did not segregate the amounts provided to subrecipients in the exhibits and related schedules provided to OSC. OSC utilized this information to compile and prepare the SEFA. As a result, all HAF expenditures were inaccurately reported as direct expenditures on the State’s fiscal year 2023 SEFA when provided to the Office of the State Auditor for audit purposes. Context: In fiscal year 2023, HAF expenditures totaled $12.3 million. Of that amount, $4.3 million was direct expenditures and $8.0 million was paid to subrecipients. Cause: Lack of adequate internal control relating to Department SEFA submissions to OSC Effect: Inaccurate reporting of expenditure amounts on the SEFA, which is submitted to the Federal government, may result in incorrect information used for programmatic, policy, or statistical purposes. Recommendation: We recommend that SESC implement additional procedures to improve preparation and submission of SEFA information to OSC. These control procedures will ensure that expenditures are reported accurately on the SEFA. Corrective Action Plan: See F-26 Management’s Response: The Department agrees with this finding. The expenditure data was not correctly classified as sub-recipient expenditures. Contact: Marilyn Leimbach, Director, Security and Employment Service Center, DFPS, DAFS, 207-248-2556 (State Number: 23-1000-01)
(2023-061) Title: Internal control over CSLFRF reporting needs improvement Prior Year Findings: None State Department: Administrative and Financial Services State Bureau: Security and Employment Service Center Federal Agency: U.S. Department of the Treasury Assistance Listing Title: Coronavirus State and Local Fiscal Recovery Funds (COVID-19) Assistance Listing Number: 21.027 Federal Award Identification Number: See E-93 to E-94 Compliance Area: Reporting Type of Finding: Significant deficiency Questioned Costs: None Criteria: 2 CFR 200.303; 2 CFR 200.332(b); 2 CFR 200.510 The Department must establish and maintain effective internal control over Federal awards that provides reasonable assurance that the Department is managing awards in compliance with Federal statutes, regulations, and the terms and conditions of awards. The Department must maintain accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with reporting requirements. The Department must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by the State’s financial statements which must include the total Federal awards expended. At a minimum, the SEFA must provide total Federal awards expended for each individual Federal program and the Assistance Listing Number (ALN) and include the total amount provided to subrecipients from each Federal program. Condition: The Department of Administrative and Financial Services’ Security and Employment Service Center (SESC) is responsible for accurately recording information needed to report on the Coronavirus State and Local Fiscal Recovery Funds (CSLFRF) Quarterly Project and Expenditure Reports. Information from these CSLFRF reports is used by the Office of the State Controller for SEFA preparation. The Office of the State Auditor reviewed amounts reported on the SEFA and identified $24.1 million of Federal expenditures incorrectly reported as amounts provided to subrecipients that should have been reported as direct expenditures. SESC inaccurately identified vendors as subrecipients. As a result, vendor payments were incorrectly classified as subrecipient payments on the CSLFRF Quarterly Project and Expenditure Reports and were incorrectly included in the initial amount reported on the SEFA as amounts provided to subrecipients. Context: Payments to the providers totaled $24.1 million of the $207.8 million in CSLFRF expenditures. Cause: • Lack of adequate policies and procedures • Lack of supervisory oversight Effect: • Incomplete or inaccurate reporting of expenditures on the CSLFRF reports and SEFA, which are submitted to the Federal government, may result in incorrect information used for programmatic, policy or statistical purposes. • Noncompliance with Federal regulations Recommendation: We recommend that the Department implement policies and procedures to ensure contractors and subrecipients are appropriately classified and reported on the CSLFRF Quarterly Project and Expenditure Reports and SEFA. Corrective Action Plan: See F-27 Management’s Response: The Department agrees with this finding. The Security and Employment Service Center will continue to work with our partner agencies to help ensure the sub-recipient/vendor classification is appropriately determined when the initial contracts are written. Contact: Marilyn Leimbach, Director, Security and Employment Service Center, DFPS, DAFS, 207-248-2556 (State Number: 23-1699-03)
Reference Number: 2023-001 Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Assistance Listing Number: 93.323 Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: N/A Federal Award Number and Year: 6 NU50CK000498-02-04; Fiscal Year 2021-22 Name of Department: Department of Public Health Category of Finding: Schedule of Expenditure of Federal Awards Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.510 the non-Federal entity must prepare the schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee non-Federal entity's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.502 states: The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. Condition During our audit of the Department of Public Health’s (DPH) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program, we noted that DPH under reported expenditures in the SEFA for fiscal year ended June 30, 2022 by $27.5 million. The County disclosed the prior year expenditures not previously reported in note 9 to the SEFA. Cause The program misinterpreted guidance provided by the Office of the Auditor-Controller on identifying expenditures to include in the SEFA, and did not include accruals recorded in the accounting system for services incurred but not paid as of June 30, 2022. Effect Failure to accurately identify and report Federal expenditures in the SEFA could affect the major program determination and the programs selected for audit. Questioned Costs Questioned costs were not identified. Context The FY 2021-22 SEFA underreported $27.5 million of expenditures, constituting 4.5 percent of the ELC program’s reported total expenditures of $607.4 million, or 4.3 percent of the ELC program’s actual total expenditures of $634.9 million. The County disclosed the prior year expenditures not previously reported in note 9 of the notes to the SEFA. The under reporting of expenditures in the SEFA did not affect the prior year’s major program determination and programs selected for audit. Recommendation We recommend that the DPH strengthen its processes for identifying and reporting Federal expenditures in the SEFA to ensure all services incurred but not paid during the applicable fiscal year are appropriately included in the SEFA.
Reference Number: 2023-001 Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Assistance Listing Number: 93.323 Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: N/A Federal Award Number and Year: 6 NU50CK000498-02-04; Fiscal Year 2021-22 Name of Department: Department of Public Health Category of Finding: Schedule of Expenditure of Federal Awards Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.510 the non-Federal entity must prepare the schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee non-Federal entity's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.502 states: The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. Condition During our audit of the Department of Public Health’s (DPH) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program, we noted that DPH under reported expenditures in the SEFA for fiscal year ended June 30, 2022 by $27.5 million. The County disclosed the prior year expenditures not previously reported in note 9 to the SEFA. Cause The program misinterpreted guidance provided by the Office of the Auditor-Controller on identifying expenditures to include in the SEFA, and did not include accruals recorded in the accounting system for services incurred but not paid as of June 30, 2022. Effect Failure to accurately identify and report Federal expenditures in the SEFA could affect the major program determination and the programs selected for audit. Questioned Costs Questioned costs were not identified. Context The FY 2021-22 SEFA underreported $27.5 million of expenditures, constituting 4.5 percent of the ELC program’s reported total expenditures of $607.4 million, or 4.3 percent of the ELC program’s actual total expenditures of $634.9 million. The County disclosed the prior year expenditures not previously reported in note 9 of the notes to the SEFA. The under reporting of expenditures in the SEFA did not affect the prior year’s major program determination and programs selected for audit. Recommendation We recommend that the DPH strengthen its processes for identifying and reporting Federal expenditures in the SEFA to ensure all services incurred but not paid during the applicable fiscal year are appropriately included in the SEFA.
Reference Number: 2023-002 Federal Program Title: Maternal and Child Health Services Block Grant to the States Federal Assistance Listing Number: 93.994 Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: California Department of Health Care Services/Public Health Institute Federal Award Number and Year: 202219; Fiscal Year 2022-23 Name of Department: Department of Public Health Category of Finding: Schedule of Expenditure of Federal Awards Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.510 the non-Federal entity must prepare the schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee non-Federal entity's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. At a minimum, the schedule must provide total Federal awards expended for each individual Federal program and the Assistance Listings Number (ALN). Condition During our audit of the DPH’s Maternal and Child Health Services Block Grant to the States (MCH) program, we noted that DPH incorrectly reported expenditures for the MCH Program in the SEFA. $2,163,020 in expenditures for ALN 93.778 Medicaid Assistance Program, were reported as MCH Program expenditures under ALN 93.994. The SEFA was corrected to properly report the expenditures under both ALNs. Cause DPH used funds from ALN 93.778 Medicaid Assistance Program, as matching funds for the MCH Program, as allowed by the MCH Program. While DPH tracked the expenditures for the two ALNs separately, it reported all of the expenditures in the SEFA under the MCH Program. Effect Failure to accurately identify and report Federal expenditures in the SEFA could affect the major program determination and the programs selected for audit and the timely completion of the Single Audit. The MCH program was selected as a Type B program and audited for FY 2022-23. Upon correcting the error identified, an additional Type B program was required to be selected for audit, as MCH fell below the Type B program threshold for FY 2022-23 and did not need to be considered in the County’s risk assessment. Questioned Costs Questioned costs were not identified. Context The MCH Program originally reported total expenditures of $3,361,264 in FY 2022-23 for two different federal programs: ALN 93.994 for $1,198,244 and ALN 93.778 for $2,163,020. DPH reported the expenditures as $3,361,264 for ALN 93.994 and $0 for ALN 93.778. The SEFA was corrected to appropriately report the expenditures in ALN 93.994 and ALN 93.778. Recommendation We recommend that the DPH strengthen its processes for identifying and reporting Federal expenditures in the SEFA to ensure expenditures are reported under the correct federal program ALN.
Reference Number: 2023-001 Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Assistance Listing Number: 93.323 Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: N/A Federal Award Number and Year: 6 NU50CK000498-02-04; Fiscal Year 2021-22 Name of Department: Department of Public Health Category of Finding: Schedule of Expenditure of Federal Awards Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.510 the non-Federal entity must prepare the schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee non-Federal entity's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.502 states: The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. Condition During our audit of the Department of Public Health’s (DPH) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program, we noted that DPH under reported expenditures in the SEFA for fiscal year ended June 30, 2022 by $27.5 million. The County disclosed the prior year expenditures not previously reported in note 9 to the SEFA. Cause The program misinterpreted guidance provided by the Office of the Auditor-Controller on identifying expenditures to include in the SEFA, and did not include accruals recorded in the accounting system for services incurred but not paid as of June 30, 2022. Effect Failure to accurately identify and report Federal expenditures in the SEFA could affect the major program determination and the programs selected for audit. Questioned Costs Questioned costs were not identified. Context The FY 2021-22 SEFA underreported $27.5 million of expenditures, constituting 4.5 percent of the ELC program’s reported total expenditures of $607.4 million, or 4.3 percent of the ELC program’s actual total expenditures of $634.9 million. The County disclosed the prior year expenditures not previously reported in note 9 of the notes to the SEFA. The under reporting of expenditures in the SEFA did not affect the prior year’s major program determination and programs selected for audit. Recommendation We recommend that the DPH strengthen its processes for identifying and reporting Federal expenditures in the SEFA to ensure all services incurred but not paid during the applicable fiscal year are appropriately included in the SEFA.
Reference Number: 2023-001 Federal Program Title: Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) Federal Assistance Listing Number: 93.323 Federal Agency: U.S. Department of Health and Human Services Pass-Through Entity: N/A Federal Award Number and Year: 6 NU50CK000498-02-04; Fiscal Year 2021-22 Name of Department: Department of Public Health Category of Finding: Schedule of Expenditure of Federal Awards Type of Finding: Significant Deficiency in Internal Control Over Financial Reporting Criteria In accordance with Title 2 U.S. Code of Federal Regulations (CFR) § 200.510 the non-Federal entity must prepare the schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee non-Federal entity's financial statements which must include the total Federal awards expended as determined in accordance with § 200.502. 2 CFR § 200.502 states: The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs. Generally, the activity pertains to events that require the non-Federal entity to comply with Federal statutes, regulations, and the terms and conditions of Federal awards, such as: expenditure/expense transactions associated with awards including grants, cost-reimbursement contracts under the FAR, compacts with Indian Tribes, cooperative agreements, and direct appropriations; the disbursement of funds to subrecipients; the use of loan proceeds under loan and loan guarantee programs; the receipt of property; the receipt of surplus property; the receipt or use of program income; the distribution or use of food commodities; the disbursement of amounts entitling the non-Federal entity to an interest subsidy; and the period when insurance is in force. Condition During our audit of the Department of Public Health’s (DPH) Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) program, we noted that DPH under reported expenditures in the SEFA for fiscal year ended June 30, 2022 by $27.5 million. The County disclosed the prior year expenditures not previously reported in note 9 to the SEFA. Cause The program misinterpreted guidance provided by the Office of the Auditor-Controller on identifying expenditures to include in the SEFA, and did not include accruals recorded in the accounting system for services incurred but not paid as of June 30, 2022. Effect Failure to accurately identify and report Federal expenditures in the SEFA could affect the major program determination and the programs selected for audit. Questioned Costs Questioned costs were not identified. Context The FY 2021-22 SEFA underreported $27.5 million of expenditures, constituting 4.5 percent of the ELC program’s reported total expenditures of $607.4 million, or 4.3 percent of the ELC program’s actual total expenditures of $634.9 million. The County disclosed the prior year expenditures not previously reported in note 9 of the notes to the SEFA. The under reporting of expenditures in the SEFA did not affect the prior year’s major program determination and programs selected for audit. Recommendation We recommend that the DPH strengthen its processes for identifying and reporting Federal expenditures in the SEFA to ensure all services incurred but not paid during the applicable fiscal year are appropriately included in the SEFA.