Finding 627848 (2022-004)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2023-07-16
Audit: 51214
Organization: Ramsey County (MN)

AI Summary

  • Core Issue: The County failed to obtain necessary itemized documentation for six out of 40 disbursements, totaling $507,553, which raises concerns about compliance with federal requirements.
  • Impacted Requirements: This finding violates Title 2 U.S. Code of Federal Regulations § 200.303 and the Joint Powers Agreement with the City of Saint Paul, jeopardizing assurance over fund management.
  • Recommended Follow-Up: The County should implement a process to collect itemized documentation for all subrecipient reimbursement requests to ensure compliance and proper fund usage.

Finding Text

2022-004 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: N/A Repeat Finding Since: N/A Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Housing and Urban Development Program: 14.231 Emergency Solutions Grant Program Award Number and Year: E-20-MW-27-0007, E-20-MC-27-0007, 2020; E-21-MC-27-0007, 2021 Pass-Through Agency: City of Saint Paul, Minnesota 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 awards. In addition, per the Joint Powers Agreement between the County and the City of Saint Paul, the County is to submit supporting evidence for each Draw Request prepared by the County for reimbursement. Condition: The County did not obtain itemized documentation from its subrecipients for six out of 40 disbursements tested. The amount of disbursements that did not have supporting documentation totaled $507,553. Itemized documentation would include reports derived from payroll systems or subrecipient general ledgers and original receipts. Questioned Costs: Could not be determined. Context: The County expended a total of $5,500,646 of Emergency Solutions Grant Program funds in 2022. Of this amount, $5,466,366 was passed through to subrecipients of the County. The sample size was based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Effect: By not obtaining itemized documentation, the County cannot be assured that its subrecipients were expending funds on allowable activities and met the requirements of allowable costs. In addition, the County is not meeting the requirements outlined in its agreement with the City of Saint Paul. Cause: The County considered its subrecipient monitoring procedures sufficient in lieu of obtaining itemized documentation. Recommendation: We recommend the County obtain itemized documentation related to expenditures, including payroll or general ledger reports and itemized receipts, as applicable, for subrecipient reimbursement requests. View of Responsible Official: Acknowledge

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Cash Management Material Weakness

Other Findings in this Audit

  • 51405 2022-004
    Material Weakness
  • 51406 2022-004
    Material Weakness
  • 51407 2022-004
    Material Weakness
  • 51408 2022-005
    Material Weakness
  • 51409 2022-006
    Material Weakness
  • 627847 2022-004
    Material Weakness
  • 627849 2022-004
    Material Weakness
  • 627850 2022-005
    Material Weakness
  • 627851 2022-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.023 Covid-19 - Emergency Rental Assistance Program $6.47M
93.658 Foster Care_title IV-E $4.78M
14.231 Emergency Solutions Grant Program $4.73M
93.667 Social Services Block Grant $3.57M
20.205 Highway Planning and Construction $2.65M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $1.67M
93.870 Maternal, Infant and Early Childhood Home Visiting Grant $1.49M
93.268 Covid-19 - Immunization Cooperative Agreements $1.35M
93.575 Child Care and Development Block Grant $1.22M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $1.08M
93.217 Family Planning_services $1.05M
93.558 Temporary Assistance for Needy Families $994,732
93.563 Child Support Enforcement $958,599
93.959 Block Grants for Prevention and Treatment of Substance Abuse $926,156
93.994 Maternal and Child Health Services Block Grant to the States $626,734
14.239 Home Investment Partnerships Program $610,479
17.259 Wia Youth Activities $488,098
16.575 Crime Victim Assistance $398,621
95.001 High Intensity Drug Trafficking Areas Program $347,057
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $346,647
97.042 Emergency Management Performance Grants $300,575
93.788 Opioid Str $289,466
93.435 Innovative State and Local Public Health Strategies to Prevent and Manage Diabetes and Heart Disease and Stroke- $269,737
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $267,905
93.659 Adoption Assistance $263,388
93.590 Community-Based Child Abuse Prevention Grants $257,696
14.267 Continuum of Care Program $251,681
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $195,522
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $192,375
93.268 Immunization Cooperative Agreements $186,921
20.500 Federal Transit_capital Investment Grants $172,056
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $171,610
93.556 Promoting Safe and Stable Families $169,996
93.069 Public Health Emergency Preparedness $168,304
90.404 Covid-19 - 2018 Hava Election Security Grants $146,876
93.940 Hiv Prevention Activities_health Department Based $134,761
93.674 Covid-19 - John H. Chafee Foster Care Program for Successful Transition to Adulthood $131,129
93.767 Children's Health Insurance Program $129,104
93.917 Hiv Care Formula Grants $103,950
93.669 Child Abuse and Neglect State Grants $93,399
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $78,363
17.277 Covid-19 - Workforce Investment Act (wia) National Emergency Grants $69,566
93.645 Stephanie Tubbs Jones Child Welfare Services Program $68,266
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $64,800
16.034 Coronavirus Emergency Supplemental Funding Program $58,008
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $57,384
21.032 Local Assistance and Tribal Consistency Fund $50,000
16.738 Edward Byrne Memorial Justice Assistance Grant Program $46,736
16.606 State Criminal Alien Assistance Program $46,622
97.067 Homeland Security Grant Program $44,733
17.258 Wia Adult Program $44,576
10.555 National School Lunch Program $43,690
17.278 Wia Dislocated Worker Formula Grants $41,390
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $40,856
93.090 Guardianship Assistance $37,217
93.251 Early Hearing Detection and Intervention $36,735
97.012 Boating Safety Financial Assistance $36,519
14.218 Community Development Block Grants/entitlement Grants $33,062
93.439 State Physical Activity and Nutrition (span $26,019
16.588 Violence Against Women Formula Grants $24,367
10.553 School Breakfast Program $21,839
93.778 Medical Assistance Program $19,659
93.566 Refugee and Entrant Assistance_state Administered Programs $18,760
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $18,448
93.136 Injury Prevention and Control Research and State and Community Based Programs $15,039
10.572 Wic Farmers' Market Nutrition Program (fmnp) $13,473
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $11,000
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $10,000
20.616 National Priority Safety Programs $9,963
20.600 State and Community Highway Safety $6,076
10.555 Covid-19 - National School Lunch Program $5,351
16.525 Grants to Reduce Domestic Violence, Dating Violence, Sexual Assault, and Stalking on Campus $3,340
16.831 Children of Incarcerated Parents $3,000
93.314 Early Hearing Detection and Intervention Information System (ehdi-Is) Surveillance Program $2,411