Finding 1228838 (2025-001)

Material Weakness Repeat Finding
Requirement
ABL
Questioned Costs
-
Year
2025
Accepted
2026-09-04

AI Summary

  • Core Issue: Significant errors in reporting payroll and program costs were found, leading to a material weakness in internal controls over compliance.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations § 200.303 is compromised, affecting the accurate management of federal awards.
  • Recommended Follow-Up: Implement stronger controls for identifying and reporting allowable costs, and correct any inaccurate reports submitted to the Minnesota Department of Human Services.

Finding Text

2025-001 Activities Allowed or Unallowed, Allowable Costs/Cost Principles, and Reporting Prior Year Finding Number: N/A Year of Finding Origination: 2025 Type of Finding: Internal Control Over Compliance and Compliance Severity of Deficiency: Material Weakness and Modified Opinion Federal Agency: U.S. Department of Health and Human Services Program: 93.778 Grants to States for Medicaid Award Number and Year: 2505MN5ADM; 2025 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 are submitted to the Minnesota Department of Human Services (DHS) on a quarterly basis through the DHS Income Maintenance report (DHS-2550) and DHS Social Service Fund Report (DHS-2556) for the Grants to States for Medicaid program. DHS provides reporting instructions, including information regarding eligible and ineligible costs. Condition: The following exceptions were noted in expenditures tested: • One timesheet tested included payroll costs that were incorrectly reported as Income Maintenance Random Moments Time Studies participants payroll expense. • One timesheet tested included payroll costs that were incorrectly reported as Social Service Time Studies (SSTS) participants payroll expense. In addition, the following exceptions were noted in the first and third quarter DHS reports tested: • Payroll expenditures of $16,135 were reported twice in the first quarter DHS-2550 report. • SSTS direct federal expenses were overstated by $14,373. Questioned Costs: $37,548. $7,040 known questioned costs were determined based on exceptions related to incorrectly reported payroll costs noted in testing, and $30,508 known questioned costs were determined based on the exceptions noted in the DHS-2550 and DHS-2556 reports tested. Context: DHS relies on accurate identification and reporting of program costs to ensure grant funds paid to the County are for allowable federal program activities and costs and provide detailed information necessary for maintaining proper oversight over federal programs. Total Grants to States for Medicaid expenditures reported on the Schedule of Expenditures of Federal Awards (SEFA) are $1,771,099, consisting of 3,945 transactions. The sample of 40 transactions totaled $176,432. The reporting population consisted of four quarterly DHS-2550 and DHS-2556 reports. The sample was two quarterly DHS-2550 and DHS-2556 reports. The sample sizes were based on the guidance from Chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Effect: Errors in the identification and reporting of costs on the quarterly reports can impair DHS’ ability 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 County’s controls over the identification of allowable activities and costs and preparation and review of quarterly reports were not sufficient to identify these errors. Recommendation: We recommend the County implement controls to ensure activities allowed or allowable costs are appropriately identified and accurately reported to DHS in accordance with federal program guidance and DHS instructions. We also recommend the County correct and resubmit reports submitted with unallowable activities or costs, costs allocated incorrectly, or activity reported incorrectly. View of Responsible Official: Acknowledge

Corrective Action Plan

Finding Number: 2025-001 Finding Title: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, and Reporting Program: 93.778 Grants to States for Medicaid Name of Contact Person Responsible for Corrective Action: Cassandra Sassenberg Corrective Action Planned: At Quarter End, the Fiscal Supervisor and/or Fiscal Coordinator will request specific employee payroll information from payroll staff. Payroll staff will provide a UKG general ledger system report showing account breakouts of the allocation, rather than solely a summary total spreadsheet to allow for review by employee, account code, and time study participation status. For employees included on the participant list, only the portion of salary charged to account 11.420 will remain on Line A1 of the DHS-2550 report. Any portion charged to accounts 11.430 or 11.440 will be removed from Line A1 and reported as an administrative cost on Line E1. If an employee is not included on the participant list, the employee’s full salary, including any amount charged to account 11.420, will be reported as an administrative cost on Line E1. This process will ensure that only eligible participant payroll remains on Line A1 and prevent payroll costs from being removed from Line A1 in excess of the amount required. Anticipated Completion Date: 12/31/2026

Categories

Allowable Costs / Cost Principles Reporting Internal Control / Segregation of Duties

Programs in Audit

ALN Program Name Expenditures
20.205 HIGHWAY PLANNING AND CONSTRUCTION $987,939
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $369,748
93.658 FOSTER CARE TITLE IV-E $257,522
93.563 CHILD SUPPORT SERVICES $219,720
93.276 DRUG-FREE COMMUNITIES SUPPORT PROGRAM GRANTS $138,288
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $134,389
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $125,060
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $92,024
16.575 CRIME VICTIM ASSISTANCE $57,512
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $44,260
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $37,739
93.667 SOCIAL SERVICES BLOCK GRANT $26,051
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $24,580
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $22,075
93.323 COVID-19 - EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $16,989
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $11,145
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $8,999
93.778 GRANTS TO STATES FOR MEDICAID $7,788
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $6,322
93.472 TITLE IV-E PREVENTION PROGRAM $4,482
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $2,227
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $1,717
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $1,286
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $629
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $274