Finding 975141 (2023-004)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-05-29

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) contained significant errors, affecting financial reporting accuracy.
  • Impacted Requirements: Compliance with 2 CFR 200.510 and 2 CFR 200.502 was not met due to inadequate internal controls.
  • Recommended Follow-Up: Improve internal controls to ensure SEFA completeness and accuracy to prevent future discrepancies.

Finding Text

Finding 2023-004: Inadequate Review of the Schedule of Expenditures of Federal Awards U.S. Department of Health and Human Services Federal Programs: Advanced Nursing Education Workforce Grant Program (ALN number 93.247) (Federal Award Year 2023), Family Planning Services (ALN number 93.217) (Federal Award Year 2023), and Epidemiology and Laboratory Capacity for Infectious Diseases (ELC) (ALN number 93.323) (Federal Award Year 2023) Repeat Finding: No Criteria: In accordance with 2 CFR 200.510, 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 2 CFR 200.502. Condition: During our testing, we identified errors in the Organization’s SEFA for the year ended June 30, 2023. The errors were as follows: • Total federal expenditures for Assistance Listing Number (ALN) 93.247, Advanced Nursing Education Workforce Grant Program, were understated by $516,141. • Total federal expenditures for ALN 93.217, Family Planning Services, were overstated by $125,252. • The federal grantor for amounts passed through the Illinois Department of Public Health for ALN 93.323, Epidemiology and Laboratory Capacity for Infectious Disease (ELC), was incorrectly reported as the U.S. Department of the Treasury and should have been reported as the U.S. Department of Health and Human Services. Cause: The Organization did not have adequate internal controls in place over the review of the SEFA to ensure the SEFA was complete and accurate. . Effect: The errors contained in the SEFA led to inaccurate major program determination. After correcting the errors, an additional major program was identified. The data collection form and reporting package were not received by the Federal Audit Clearinghouse by the prescribed due date. Recommendation: We recommend the Organization enhance its internal controls over the review of the completeness and accuracy of the SEFA. View of responsible officials of the auditee: Management agrees with the finding and recommendation.

Categories

Reporting

Other Findings in this Audit

  • 398693 2023-005
    Significant Deficiency
  • 398694 2023-005
    Significant Deficiency
  • 398695 2023-005
    Significant Deficiency
  • 398696 2023-005
    Significant Deficiency
  • 398697 2023-003
    Material Weakness
  • 398698 2023-005
    Significant Deficiency
  • 398699 2023-004
    Material Weakness
  • 398700 2023-004
    Material Weakness
  • 398701 2023-004
    Material Weakness
  • 398702 2023-002
    Material Weakness
  • 398703 2023-002
    Material Weakness
  • 398704 2023-002
    Material Weakness
  • 398705 2023-002
    Material Weakness
  • 398706 2023-002
    Material Weakness
  • 975135 2023-005
    Significant Deficiency
  • 975136 2023-005
    Significant Deficiency
  • 975137 2023-005
    Significant Deficiency
  • 975138 2023-005
    Significant Deficiency
  • 975139 2023-003
    Material Weakness
  • 975140 2023-005
    Significant Deficiency
  • 975142 2023-004
    Material Weakness
  • 975143 2023-004
    Material Weakness
  • 975144 2023-002
    Material Weakness
  • 975145 2023-002
    Material Weakness
  • 975146 2023-002
    Material Weakness
  • 975147 2023-002
    Material Weakness
  • 975148 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $4.77M
93.224 Covid-19 - Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $2.49M
93.527 Covid-19 - Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $1.16M
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $581,743
93.788 Opioid Str $383,798
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $308,830
93.526 Affordable Care Act (aca) Grants for Capital Development in Health Centers $288,337
93.566 Refugee and Entrant Assistance_state Administered Programs $170,000
93.994 Maternal and Child Health Services Block Grant to the States $153,840
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $128,294
93.323 Covid-19 - Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $61,089
93.247 Advanced Nursing Education Grant Program $59,275
93.217 Family Planning_services $53,680
93.110 Maternal and Child Health Federal Consolidated Programs $17,500