Finding 574079 (2024-001)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2025-08-21
Audit: 364657
Organization: Chippewa County (MN)

AI Summary

  • Core Issue: The County failed to accurately report eligible expenditures and payroll costs, leading to material weaknesses in compliance with federal requirements.
  • Impacted Requirements: Internal controls over federal awards must ensure compliance with Title 2 U.S. Code of Federal Regulations § 200.303, which mandates effective management of federal funds.
  • Recommended Follow-Up: Implement stronger controls for identifying allowable costs and resubmit corrected reports to DHS to align with federal guidance.

Finding Text

2024-001 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: 2023-006 Year of Finding Origination: 2023 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 Medical Assistance Program Award Number and Year: 2405MN5ADM; 2024 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 Medical Assistance Program are submitted to the Minnesota Department of Human Services (DHS) through the DHS Income Maintenance (DHS-2550) report and the Social Service Fund (DHS-2556) report on a quarterly basis. DHS provides reporting instructions including information regarding eligible and ineligible costs. Condition: The following exceptions were noted in the sample of 40 expenditures tested for activities allowed or unallowed and allowable costs/cost principles: • One claim was included in a DHS-2550 report as eligible expenditures but was not eligible for federal reimbursement. • One claim included in a DHS-2556 report was reported as a reduction of Intergovernmental Federal Revenue rather than a Services and Charges expenditure. • For eight timesheets tested, the payroll costs were allocated on an incorrect full-time equivalent (FTE) split on the DHS-2550 and DHS-2556 reports. • One timesheet was included in the DHS-2556 reports for Social Service Time Study Random Moment Time Study (SSTS RMS) Participants Payroll Expense rather than Non SSTS RMS Participants Payroll Expense. Questioned Costs: Questioned costs identified were less than $25,000. 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. Total expenditures reported on the SEFA is $715,942, consisting of 1,419 transactions. The sample of 40 transactions totaled $88,180. 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. Cause: The County’s controls over the identification of allowable activities and costs, preparation of the quarterly reports, and maintenance of payroll allocations in the accounting system were not sufficient to identify these errors. The County indicated the FTE split was updated during 2024 for non-payroll costs but not for the payroll costs. Recommendation: We recommend the County implement controls to ensure activities allowed and 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: 2024-001 Finding Title: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: 93.778 Medical Assistance Program Name of Contact Person Responsible for Corrective Action: Jennifer Bakkelund, Fiscal & Support Services Supervisor Corrective Action Planned: Due to overlap of when we found the errors from 2023 and the corrections of those in 2024, this triggered other areas we knew would have to change in 2024. This included more movement in personnel expenses for programs not considered under federal financial participation. These programs were all removed from the Family Services budget by January 1, 2025. The corrections to our internal systems were corrected in 2025. Chippewa County staff will connect with DHS to review the corrections made in our system as it pertains to the quarterly reports and will adjust as they instruct. For the Administrative split being used each year, we will use the A87 Report to determine the rate. It will be shared with the Payroll department, the County Auditor/Treasurer’s department and Family Services accounting staff prior to the start of the year or prior to any mid-year change. More oversight will be given to placement of “Other” charges that are paid in County systems and to make sure placement of those are correct in the quarterly reports. Anticipated Completion Date: December 2025

Categories

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

Other Findings in this Audit

  • 574080 2024-002
    Significant Deficiency
  • 1150521 2024-001
    Material Weakness Repeat
  • 1150522 2024-002
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $2.19M
93.558 Temporary Assistance for Needy Families $1.09M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $179,394
93.658 Foster Care Title IV-E $156,829
93.667 Social Services Block Grant $109,832
93.563 Child Support Services $74,798
97.042 Emergency Management Performance Grants $22,075
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $12,725
20.600 State and Community Highway Safety $12,056
93.645 Stephanie Tubbs Jones Child Welfare Services Program $6,326
21.032 Covid-19 - Local Assistance and Tribal Consistency Fund $6,000
93.778 Medical Assistance Program $4,203
97.012 Boating Safety Financial Assistance $3,975
93.556 Marylee Allen Promoting Safe and Stable Families Program $3,579
93.575 Child Care and Development Block Grant $2,993
16.607 Bulletproof Vest Partnership Program $2,169
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $1,562
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $887
93.590 Community-Based Child Abuse Prevention Grants $402
93.767 Children's Health Insurance Program $364