Finding 561616 (2023-006)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-05-27
Audit: 357223
Organization: Ramsey County (MN)

AI Summary

  • Core Issue: The DHS-2556 report inaccurately reported payroll expenses, overstating costs by $552,225 for participants in the social services time study.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations § 200.303, which mandates effective internal controls over federal awards.
  • Recommended Follow-Up: Implement controls for accurate reporting and correct any submitted reports to align with federal program guidance.

Finding Text

2023-006 Reporting – DHS Social Service Fund (DHS-2556) Prior Year Finding Number: N/A Year of Finding Origination: 2023 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Significant Deficiency and Other Matter Federal Agency: U.S. Department of Health and Human Services Program: 93.658 Foster Care – Title IV-E Award Number and Year: 2301MNFOST, 2023 Pass-Through Agency: Minnesota Department of Human Services Criteria: Title 2 U.S. Code of Federal Regulations § 200.303 states that the auditee must establish and maintain effective internal control over the federal award that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Administrative program costs for Foster Care are submitted to the Minnesota Department of Human Services (DHS) through the DHS Social Service Fund (DHS-2556) report on a quarterly basis. DHS provides reporting instructions, including information regarding eligible and ineligible costs. Condition: The DHS-2556 second quarter report overstated payroll expense for individuals required to participate in the social services time study by $552,225 and understated payroll expense for individuals who do not participate in the social services time study. Questioned Costs: None. Context: DHS relies on accurate identification and reporting of program costs to ensure grant funds paid to the County are allowable and provide detailed information necessary for maintaining proper oversight over federal programs. The sample size was based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Effect: Errors in the reporting of costs on the quarterly reports can impair the ability of DHS to provide required oversight over federal programs and result in the County receiving either more or less federal funds than justified based on the actual underlying activity. Cause: The error was due to an incorrect formula in a supporting workbook. Recommendation: We recommend Ramsey County implement controls to ensure accurate reporting to DHS in accordance with federal program guidance and DHS instructions. We also recommend reports submitted incorrectly are corrected and resubmitted. View of Responsible Official: Concur

Corrective Action Plan

Finding Number: 2023-006 Finding Title: Reporting – DHS Social Service Fund (DHS-2556) Program: 93.658 Foster Care – Title IV-E Name of Contact Person Responsible for Corrective Action: Janelle White – Controller for Ramsey County’s Health & Wellness Service Team Enrique Rivera – Fiscal Services Manager for Ramsey County’s Health & Wellness Service Team Corrective Action Planned: Starting in the third quarter of 2024, Ramsey County instituted an additional verification step in the review process to support the determination of accurate cost pool categorization of reimbursable costs for the Random Moment Time Study Reports cost reports. The additional step will be to confirm that on the Summary Tab of the Quarterly Payroll file, the cost codes lines are in sequential order and that the corresponding expense totals match the cost code. The Senior Accountant will do the first review of this step, and the Fiscal Manager will complete the second review. The error on the 2nd quarter 2023 report was remedied and resubmitted in the 2nd quarter of 2024. Anticipated Completion Date: July of 2024 when the 2nd quarter DHS-2556 and DHS 2550 are due to be complete and finalized.

Categories

Internal Control / Segregation of Duties Student Financial Aid Eligibility Reporting Significant Deficiency

Other Findings in this Audit

  • 561612 2023-005
    Significant Deficiency
  • 561613 2023-005
    Significant Deficiency
  • 561614 2023-005
    Significant Deficiency
  • 561615 2023-004
    Material Weakness Repeat
  • 1138054 2023-005
    Significant Deficiency
  • 1138055 2023-005
    Significant Deficiency
  • 1138056 2023-005
    Significant Deficiency
  • 1138057 2023-004
    Material Weakness Repeat
  • 1138058 2023-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.658 Foster Care Title IV-E $5.11M
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $4.24M
93.667 Social Services Block Grant $3.53M
20.205 Highway Planning and Construction $2.94M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $2.55M
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $2.50M
21.023 Covid-19 - Emergency Rental Assistance Program $2.44M
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $1.63M
93.563 Child Support Services $1.42M
93.217 Family Planning Services $1.36M
17.259 Wioa Youth Activities $1.18M
93.323 Covid-19 - Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.14M
93.575 Child Care and Development Block Grant $1.12M
93.558 Temporary Assistance for Needy Families $1.07M
93.994 Maternal and Child Health Services Block Grant to the States $929,847
14.218 Community Development Block Grants/entitlement Grants $921,532
93.959 Block Grants for Prevention and Treatment of Substance Abuse $676,517
14.218 Covid-19 - Community Development Block Grants/entitlement Grants $633,495
17.258 Wioa Adult Program $601,560
14.231 Emergency Solutions Grant Program $579,745
16.753 Congressionally Recommended Awards $468,824
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $381,206
16.606 State Criminal Alien Assistance Program $371,197
93.435 The Innovative Cardiovascular Health Program $343,507
93.268 Immunization Cooperative Agreements $312,671
93.556 Marylee Allen Promoting Safe and Stable Families Program $281,463
93.665 Covid-19 - Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $264,810
16.575 Crime Victim Assistance $252,740
20.500 Federal Transit Capital Investment Grants $251,154
14.239 Home Investment Partnerships Program $242,255
95.001 High Intensity Drug Trafficking Areas Program $213,844
93.590 Community-Based Child Abuse Prevention Grants $211,316
14.267 Continuum of Care Program $203,797
97.042 Emergency Management Performance Grants $203,509
93.069 Public Health Emergency Preparedness $197,922
93.659 Adoption Assistance $190,665
93.788 Opioid Str $140,513
97.012 Boating Safety Financial Assistance $118,784
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $107,682
93.940 Hiv Prevention Activities Health Department Based $98,607
93.645 Stephanie Tubbs Jones Child Welfare Services Program $78,802
20.616 National Priority Safety Programs $69,569
93.439 State Physical Activity and Nutrition (span) $66,293
97.067 Homeland Security Grant Program $59,741
16.588 Violence Against Women Formula Grants $58,077
17.278 Wioa Dislocated Worker Formula Grants $53,314
10.555 National School Lunch Program $53,068
93.767 Children's Health Insurance Program $47,248
20.600 State and Community Highway Safety $41,957
17.277 Wioa National Dislocated Worker Grants / Wia National Emergency Grants $41,410
16.738 Edward Byrne Memorial Justice Assistance Grant Program $36,715
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $36,230
93.603 Adoption and Legal Guardianship Incentive Payments Program $36,067
93.090 Guardianship Assistance $33,527
93.958 Block Grants for Community Mental Health Services $30,212
10.553 School Breakfast Program $27,656
93.778 Medical Assistance Program $22,863
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $22,789
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $22,122
10.572 Wic Farmers' Market Nutrition Program (fmnp) $14,831
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $12,389
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $12,372
93.008 Medical Reserve Corps Small Grant Program $10,000
93.251 Early Hearing Detection and Intervention $9,555
10.578 Wic Grants to States (wgs) $8,065
93.747 Covid-19 - Elder Abuse Prevention Interventions Program $6,116
16.525 Grants to Reduce Domestic Violence, Dating Violence, Sexual Assault, and Stalking on Campus $5,362
16.831 Children of Incarcerated Parents $3,000
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $2,618
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $2,216
93.314 Early Hearing Detection and Intervention Information System (ehdi-Is) Surveillance Program $2,205