Finding 1206239 (2024-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-04-09
Audit: 398206
Organization: Ramsey County (MN)

AI Summary

  • Core Issue: The County failed to obtain itemized documentation for five out of 44 disbursements, leading to questioned costs of $181,377.
  • Impacted Requirements: The County did not comply with federal regulations requiring effective internal controls and adequate documentation for allowable costs.
  • Recommended Follow-Up: The County should gather supporting documentation for all expenditures, including payroll reports and receipts, to ensure compliance with allowable activity requirements.

Finding Text

2024-002 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: N/A Year of Finding Origination: 2024 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Significant Deficiency and Other Matter Federal Agency: U.S. Department of the Treasury Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Award Number and Year: Direct, Not Provided Pass-Through Agency: Direct and City of Saint Paul 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. Title 2 U.S. Code of Federal Regulations §§ 200.403(a) and 200.403(g) require costs to be necessary and reasonable, and be adequately documented. Condition: The County did not obtain itemized documentation for five out of 44 disbursements tested. Questioned Costs: $181,377; known questioned costs were determined based on individual expenditures with exceptions identified. Context: The County treated one vendor as a subrecipient and approved a budget for this vendor by type of expenditure. The County monitored the vendor's actual expenditures against approved budgeted expenditures. Total expenditures reported on the Schedule of Expenditures of Federal Awards is $50,901,938 for this program. The sample tested included approximately $2,570,500. The sample size was based on guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Additionally, four individually important items were selected for testing. Effect: The County has insufficient documentation to demonstrate expenditures were for allowable activities and met the requirements of allowable costs. Cause: The County felt its procedures over monitoring actual expenditures to budgeted expenditures were sufficient in lieu of reviewing itemized supporting documentation. Recommendation: We recommend the County obtain supporting documentation related to expenditures, including payroll reports and supporting receipts for purchases, sufficient to determine expenditures were for allowable activities. View of Responsible Official: Concur.

Corrective Action Plan

Finding Number: 2024-002 Finding Title: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: 21.027 COVID-19 – Coronavirus State and Local Fiscal Recovery Funds Name of Contact Person Responsible for Corrective Action: Daniel Rahkola, Division Director Finance Corrective Action Planned: The County will review program-related costs to ensure compliance with applicable grant requirements and to confirm that all costs are allowable, allocable, and properly supported. Supporting documentation must sufficiently demonstrate the allowability of each cost. This review will include the following: • Submitted payroll reports that detail individual hours worked, descriptions of work performed, and a clear link between the work performed and allowable grant program activities. • General ledger reports that support each cost and clearly document the relationship between the expenditure and allowable grant program expenses. Anticipated Completion Date: June 30, 2026

Categories

Subrecipient Monitoring Allowable Costs / Cost Principles Procurement, Suspension & Debarment Reporting Significant Deficiency

Other Findings in this Audit

  • 1206238 2024-002
    Material Weakness Repeat
  • 1206240 2024-003
    Material Weakness Repeat
  • 1206241 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $7.77M
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $4.94M
93.658 FOSTER CARE TITLE IV-E $4.82M
21.027 COVID-19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $4.17M
93.667 SOCIAL SERVICES BLOCK GRANT $3.58M
20.205 HIGHWAY PLANNING AND CONSTRUCTION $2.19M
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOME VISITING GRANT $1.81M
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $1.58M
21.023 COVID-19 - EMERGENCY RENTAL ASSISTANCE PROGRAM $1.19M
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $1.10M
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $1.03M
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $949,674
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $782,011
93.563 CHILD SUPPORT SERVICES $678,290
93.217 FAMILY PLANNING SERVICES $590,803
17.258 WIOA ADULT PROGRAM $563,436
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $528,878
17.259 WIOA YOUTH ACTIVITIES $501,947
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $501,627
97.067 HOMELAND SECURITY GRANT PROGRAM $381,483
14.267 CONTINUUM OF CARE PROGRAM $359,767
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $343,972
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $306,665
93.977 SEXUALLY TRANSMITTED DISEASES (STD) PREVENTION AND CONTROL GRANTS $294,540
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $291,217
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $281,437
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $272,695
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $260,885
16.606 STATE CRIMINAL ALIEN ASSISTANCE PROGRAM $250,938
20.500 FEDERAL TRANSIT CAPITAL INVESTMENT GRANTS $234,792
16.753 CONGRESSIONALLY RECOMMENDED AWARDS $212,190
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $170,790
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $169,757
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $167,140
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $156,432
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $149,948
16.575 CRIME VICTIM ASSISTANCE $137,325
93.603 ADOPTION AND LEGAL GUARDIANSHIP INCENTIVE PAYMENTS PROGRAM $128,355
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $126,901
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $121,379
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $121,153
93.354 PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $99,828
93.659 ADOPTION ASSISTANCE $97,401
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $85,000
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $84,252
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $44,755
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $40,304
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $38,069
10.555 NATIONAL SCHOOL LUNCH PROGRAM $37,068
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $27,012
93.669 CHILD ABUSE AND NEGLECT STATE GRANTS $23,241
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $20,753
10.553 SCHOOL BREAKFAST PROGRAM $19,124
93.090 GUARDIANSHIP ASSISTANCE $17,801
93.778 MEDICAL ASSISTANCE PROGRAM $16,711
10.572 WIC FARMERS' MARKET NUTRITION PROGRAM (FMNP) $14,997
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $11,520
93.251 EARLY HEARING DETECTION AND INTERVENTION $8,638
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $5,077
93.314 EARLY HEARING DETECTION AND INTERVENTION INFORMATION SYSTEM (EHDI-IS) SURVEILLANCE PROGRAM $2,336
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $932
93.898 CANCER PREVENTION AND CONTROL PROGRAMS FOR STATE, TERRITORIAL AND TRIBAL ORGANIZATIONS $795