Finding 505380 (2023-006)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2023
Accepted
2024-11-12
Audit: 328062
Organization: Chippewa County (MN)

AI Summary

  • Core Issue: The County reported ineligible expenditures and made errors in payroll allocations, leading to a material weakness in internal controls over compliance.
  • Impacted Requirements: Compliance with federal regulations (2 CFR § 200.303) for managing federal awards and accurate reporting of allowable costs.
  • Recommended Follow-Up: Implement stronger controls for identifying allowable activities and costs, and correct and resubmit any inaccurate reports to DHS.

Finding Text

2023-006 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Prior Year Finding Number: N/A 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: 2305MN5ADM, 2023 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 controls 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: • Two claims were included in the DHS-2550 reports as eligible expenditures but were not eligible for federal reimbursement. • For three timesheets tested, the payroll costs were allocated on an incorrect full-time equivalent (FTE) split on the DHS-2550 and DHS-2556 reports as the FTE split was updated during 2023 for non-payroll costs but not for payroll costs. • Two timesheets were 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. • One timesheet was included in the DHS-2556 report as an eligible payroll expense but was not eligible for federal reimbursement. • One claim was included in the DHS-2556 report as an eligible expenditure but was not eligible for federal reimbursement. Questioned Costs: $343,656. 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/costs and provide detailed information necessary for maintaining proper oversight over federal programs. DHS determines the rate of reimbursement for costs reported; the amount of questioned costs represents actual costs and does not reflect the amount reimbursed to the County for this grant. 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 the ability of DHS 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, preparation of the quarterly reports, and maintenance of payroll allocations in the accounting system were not sufficient to identify these errors. 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: 2023-006 Finding Title: Activities Allowed or Unallowed and Allowable Costs/Cost Principles Program: 93.778 Medicaid Cluster Name of Contact Person Responsible for Corrective Action: Jennifer Bakkelund, Fiscal Supervisor Corrective Action Planned: 2556 reports are being corrected to reflect the required corrections. Worked with DHS to correct the expenditure not eligible for federal reimbursement. (corrected 9/26/2024). Auditors’ office has been making corrections of payroll to move the 3 supervisors out of SSTS RMS to non SSTS RMS codes. I will then go back and correct the 2023 2556 reports. Any that are past the year cut off, I will work with DHS directly to make the corrections. Salary splits for Passport time and Director salary for supervision of Circle program will be adjusted and corrected on the 2556 as well. In the future these activities may be removed from the Family Services area. Anticipated Completion Date: December 31, 2024

Categories

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

Other Findings in this Audit

  • 505381 2023-007
    Material Weakness
  • 1081822 2023-006
    Material Weakness
  • 1081823 2023-007
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $960,432
93.563 Child Support Enforcement $253,662
93.658 Foster Care_title IV-E $135,536
93.667 Social Services Block Grant $110,298
16.575 Crime Victim Assistance $51,700
20.600 State and Community Highway Safety $14,130
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $11,254
93.645 Stephanie Tubbs Jones Child Welfare Services Program $9,502
20.616 National Priority Safety Programs $7,411
93.767 Children's Health Insurance Program $5,293
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $5,270
93.778 Medical Assistance Program $4,586
90.404 2018 Hava Election Security Grants $4,287
93.590 Community-Based Child Abuse Prevention Grants $3,035
93.575 Child Care and Development Block Grant $3,012
93.556 Promoting Safe and Stable Families $2,303
93.566 Refugee and Entrant Assistance_state Administered Programs $753
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $453