Finding 1075977 (2023-004)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-09-30
Audit: 322389
Organization: Hennepin County Minnesota (MN)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: Significant deficiencies in internal controls led to errors in the Schedule of Expenditures of Federal Awards (SEFA), impacting compliance with federal requirements.
  • Impacted Requirements: Errors included misclassification of $1,284,631 and $30,394 in expenditures, along with missing amounts totaling $688,184, violating 2 CFR 200.303(a) and 2 CFR 200.510(b).
  • Recommended Follow-Up: Strengthen processes and controls for SEFA preparation to ensure accuracy and compliance moving forward.

Finding Text

Schedule of Expenditures of Federal Awards (SEFA) Federal Agency: U.S. Department of Health and Human Services; U.S. Department of Agriculture (USDA) Program: National Bioterrorism Hospital Preparedness Program (ALN 93.889); Immunization Cooperative Agreements (ALN 93. 268); COVID-19 Epidemiology and Laboratory Capacity for Infectious Diseases (ELC)(ALN 93. 323); Child Support Services (ALN 93. 563); State Administrative Matching Grants for the Supplemental Nutrition Assistance Program (ALN 10.561) Pass-through Entity: Minnesota Department of Health; Minnesota Department of Human Services Federal Assistance Identification Number or Pass-Through Number: U90TP000529; 6NH23P0007370502; NH23P922628; NH23IP922628; NU50CK000508; 2001MNCEST; 2101MNCSES; 212MN127Q7503; 212MN101S2520; 212MN101S2514 Federal Award Year: Year ended December 31, 2023 Type of Finding: Significant Deficiency in Internal Control over Compliance; Other Matter Compliance Finding Criteria: 2 CFR 200.303(a) requires that each 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." 2 CFR 200.510(b) requires that “The auditee must prepare a schedule of expenditures of Federal awards awards (the “schedule”) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with ss 200.502... ...At minimum, the schedule must... ...(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…” Condition: While testing the SEFA, we noted that internal controls were not operating effectively over the preparation of the SEFA. In addition, we noted the following errors in the original SEFA we received for the audit: - $1,284,631 of expenditures were improperly included in ALN 93.889 when the amount should have been included in ALN 93.268. - $30,394 of expenditures was improperly included in ALN 93.889 when the amount should have been included in ALN 93.323. - $626,894 of expenditures related to ALN 93.563 was missing from the schedule. - $61,290 of expenditures related to ALN 10.561 was missing from the schedule. Cause: The errors of $1,284,631 and $30,394 related to ALN 93.889 were caused by the county hospital’s system of assigning identifying numbers within the chart of accounts not being applied to awards managed outside of the Hennepin Health Foundation. The errors of $626,894 related to ALN 93.563 and $61,290 related to ALN 10.561 related to the County’s reducing expenditures by a reversal of a prior year receivable transaction when determining the amount of expenditures. Effect: The errors in the preparation of the SEFA indicate noncompliance with the requirements for the Schedule, including ensuring that it is complete and accurate. Context: Approximately $2 million of errors were noted over the SEFA with total expenditures of approximately $360 million. Questioned Costs: None Repeat Finding?: No Recommendation: We recommend that the County strengthen its processes and controls over the preparation of the SEFA. Views of Responsible Officials: Hennepin County has reviewed and agrees with the finding and the recommendation.

Categories

Reporting Matching / Level of Effort / Earmarking Subrecipient Monitoring Significant Deficiency

Other Findings in this Audit

  • 499524 2023-005
    Significant Deficiency Repeat
  • 499525 2023-006
    Significant Deficiency Repeat
  • 499526 2023-007
    Material Weakness Repeat
  • 499527 2023-008
    Significant Deficiency Repeat
  • 499528 2023-009
    Significant Deficiency
  • 499529 2023-010
    Significant Deficiency
  • 499530 2023-011
    Material Weakness
  • 499531 2023-012
    Material Weakness
  • 499532 2023-013
    Material Weakness
  • 499533 2023-004
    Significant Deficiency
  • 499534 2023-004
    Significant Deficiency
  • 499535 2023-004
    Significant Deficiency
  • 499536 2023-004
    Significant Deficiency
  • 499537 2023-004
    Significant Deficiency
  • 1075966 2023-005
    Significant Deficiency Repeat
  • 1075967 2023-006
    Significant Deficiency Repeat
  • 1075968 2023-007
    Material Weakness Repeat
  • 1075969 2023-008
    Significant Deficiency Repeat
  • 1075970 2023-009
    Significant Deficiency
  • 1075971 2023-010
    Significant Deficiency
  • 1075972 2023-011
    Material Weakness
  • 1075973 2023-012
    Material Weakness
  • 1075974 2023-013
    Material Weakness
  • 1075975 2023-004
    Significant Deficiency
  • 1075976 2023-004
    Significant Deficiency
  • 1075978 2023-004
    Significant Deficiency
  • 1075979 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.778 Medical Assistance Program $79.65M
93.563 Child Support Enforcement $21.24M
93.658 Foster Care_title IV-E $19.59M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $15.93M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $8.15M
20.205 Highway Planning and Construction $7.20M
93.667 Social Services Block Grant $6.84M
93.914 Hiv Emergency Relief Project Grants $6.41M
14.239 Home Investment Partnerships Program $4.63M
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $4.14M
93.575 Child Care and Development Block Grant $3.25M
14.905 Lead Hazard Reduction Demonstration Grant Program $2.31M
93.958 Block Grants for Community Mental Health Services $1.76M
14.267 Continuum of Care Program $1.76M
93.224 Consolidated Health Centers (community Health Centers, Migrant Health Centers, Health Care for the Homeless, and Public Housing Primary Care) $1.67M
93.493 Congressional Directives $1.67M
93.268 Immunization Cooperative Agreements $1.50M
93.297 Teenage Pregnancy Prevention Program $1.44M
66.818 Brownfields Assessment and Cleanup Cooperative Agreements $1.43M
17.258 Wia Adult Program $1.28M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.23M
97.042 Emergency Management Performance Grants $1.05M
93.247 Advanced Nursing Education Grant Program $955,271
93.889 National Bioterrorism Hospital Preparedness Program $844,047
97.067 Homeland Security Grant Program $790,426
93.498 Provider Relief Fund $774,769
93.526 Affordable Care Act (aca) Grants for Capital Development in Health Centers $769,329
93.788 Opioid Str $724,378
93.994 Maternal and Child Health Services Block Grant to the States $697,212
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $610,652
93.253 Poison Center Support and Enhancement Grant $608,770
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $596,061
16.833 National Sexual Assault Kit Initiative $549,564
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $525,697
14.913 Healthy Homes Production Program $507,287
17.278 Wia Dislocated Worker Formula Grants $474,134
93.069 Public Health Emergency Preparedness $438,081
16.738 Edward Byrne Memorial Justice Assistance Grant Program $436,972
17.259 Wia Youth Activities $429,367
21.027 Coronavirus State and Local Fiscal Recovery Funds $400,725
14.276 Youth Homelessness Demonstration Program $398,351
93.527 Affordable Care Act (aca) Grants for New and Expanded Services Under the Health Center Program $375,462
93.940 Hiv Prevention Activities_health Department Based $368,567
14.231 Emergency Solutions Grant Program $357,697
93.583 Refugee and Entrant Assistance_wilson/fish Program $348,145
16.575 Crime Victim Assistance $340,992
93.590 Community-Based Child Abuse Prevention Grants $327,518
93.150 Projects for Assistance in Transition From Homelessness (path) $318,574
16.753 Congressionally Recommended Awards $271,650
95.001 High Intensity Drug Trafficking Areas Program $265,969
16.741 Dna Backlog Reduction Program $258,283
93.435 Innovative State and Local Public Health Strategies to Prevent and Manage Diabetes and Heart Disease and Stroke- $234,832
16.582 Crime Victim Assistance/discretionary Grants $226,061
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $178,663
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $178,430
16.922 Equitable Sharing Program $172,687
93.645 Stephanie Tubbs Jones Child Welfare Services Program $169,269
93.800 Organized Approaches to Increase Colorectal Cancer Screening $161,808
93.924 Ryan White Hiv/aids Dental Reimbursement and Community Based Dental Partnership Grants $147,799
93.235 Affordable Care Act (aca) Abstinence Education Program $140,776
14.218 Community Development Block Grants/entitlement Grants $139,939
93.344 Research, Monitoring and Outcomes Definitions for Vaccine Safety $126,207
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $126,020
93.136 Injury Prevention and Control Research and State and Community Based Programs $126,019
93.153 Coordinated Services and Access to Research for Women, Infants, Children, and Youth $114,830
16.838 Comprehensive Opioid Abuse Site-Based Program $101,333
93.556 Promoting Safe and Stable Families $94,926
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $93,670
93.566 Refugee and Entrant Assistance_state Administered Programs $90,983
10.580 Supplemental Nutrition Assistance Program, Process and Technology Improvement Grants $88,023
93.558 Temporary Assistance for Needy Families $82,203
93.270 Adult Viral Hepatitis Prevention and Control $73,776
17.277 Workforce Investment Act (wia) National Emergency Grants $73,622
93.251 Early Hearing Detection and Intervention $67,759
93.092 Affordable Care Act (aca) Personal Responsibility Education Program $65,982
93.959 Block Grants for Prevention and Treatment of Substance Abuse $65,206
93.659 Adoption Assistance $64,143
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $60,819
93.436 Well-Integrated Screening and Evaluation for Women Across the Nation (wisewoman) $57,971
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $55,705
93.917 Hiv Care Formula Grants $54,276
21.023 Emergency Rental Assistance Program $53,093
21.032 Local Assistance and Tribal Consistency Fund $50,000
97.039 Hazard Mitigation Grant $44,137
10.555 National School Lunch Program $41,313
97.012 Boating Safety Financial Assistance $36,071
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $34,576
10.553 School Breakfast Program $29,207
93.008 Medical Reserve Corps Small Grant Program $26,250
93.747 Elder Abuse Prevention Interventions Program $23,509
93.103 Food and Drug Administration_research $21,055
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $19,979
93.767 Children's Health Insurance Program $13,006
90.404 2018 Hava Election Security Grants $11,714
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $8,000
84.002 Adult Education - Basic Grants to States $7,633
93.899 Minority Hiv/aids Fund (mhaf) $5,630
93.945 Assistance Programs for Chronic Disease Prevention and Control $5,241
20.616 National Priority Safety Programs $2,471
84.181 Special Education-Grants for Infants and Families $2,100
93.090 Guardianship Assistance $1,455
20.600 State and Community Highway Safety $1,047