Finding 51408 (2022-005)

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

AI Summary

  • Core Issue: The County failed to obtain necessary documentation for advance payments and made duplicate expenditures, leading to a material weakness in compliance.
  • Impacted Requirements: Internal controls over federal awards were not effective, violating federal regulations on allowable costs and documentation.
  • Recommended Follow-Up: The County should secure supporting documentation for advances and ensure proper procedures are in place to avoid duplicate payments and confirm allowable expenditures.

Finding Text

2022-005 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 the Treasury Program: 21.023 COVID-19 ? Emergency Rental Assistance Program 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. Per the County?s subrecipient agreements, ?each jurisdiction?s program allocation may only be used to provide Emergency Rental Assistance (ERA) [or Financial Assistance] to eligible households within the geographical boundaries of that jurisdiction.? In addition, Part 3 of the OMB Compliance Supplement states that improper payments include any duplicate payment. Condition: The following exceptions were detected in the audit of COVID-19 ? Emergency Rental Assistance Program: ? In the sample of 15 disbursements tested, five consisted of advance payments to the County?s subrecipients where itemized documentation was not subsequently obtained, and ? In the sample of three journal entries tested, all three included duplicate expenditures. Questioned Costs: $254,296 Context: The County was allocated over $15 million in ERA1 and ERA2 funds between 2021 and 2022, expending $6,470,692 in 2022. Of this amount, $5,741,917 was passed through to subrecipients in 2022. The County completed monitoring procedures over its subrecipients at the beginning of 2022, reviewed spending of the subrecipients against budgets established at the beginning of the program, and viewed data entered by its subrecipients into online portals noting rent and utility assistance provided. 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. Excess funding was to be returned to the U.S. Department of the Treasury for reallocation. Cause: The County considered its subrecipient monitoring procedures and monitoring of spending and online portals sufficient in lieu of obtaining itemized documentation. The County created journal entries to move funding between the ERA1 and ERA2 Programs to close and ?clean up? the ERA1 Program. Recommendation: We recommend the County obtain supporting documentation related to advances, including payroll and general ledger reports, and itemized receipts for purchases prior to disbursing subsequent advances. In addition, we recommend the County implement procedures to ensure that only allowable program expenditures are reimbursed, taking special care with journal entries to ensure expenditures are not duplicated. View of Responsible Official: Acknowledge

Corrective Action Plan

Finding Number: 2022-005 Finding Title: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: 21.023 COVID-19 ? Emergency Rental Assistance Program Name of Contact Person Responsible for Corrective Action: Tara Bach, Director Operational Support Services Corrective Action Planned: ? The County will request supporting documentation, including general ledger report and/or bank statements and client list, to verify that advance payment have been spent before dispersing additional advance payments to subrecipient. ? Make sure extra time is given when moving expenses between grants to ensure that nothing gets moved twice. Anticipated Completion Date: The process used for this change has been implemented effective June 15, 2023.

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring

Other Findings in this Audit

  • 51405 2022-004
    Material Weakness
  • 51406 2022-004
    Material Weakness
  • 51407 2022-004
    Material Weakness
  • 51409 2022-006
    Material Weakness
  • 627847 2022-004
    Material Weakness
  • 627848 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