Finding 1074951 (2023-004)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-09-26
Audit: 321238
Organization: Traverse County (MN)

AI Summary

  • Core Issue: The County failed to accurately report eligible expenditures and payroll costs, leading to potential mismanagement of federal funds.
  • Impacted Requirements: Compliance with Title 2 U.S. Code of Federal Regulations § 200.303 regarding effective internal controls over federal awards.
  • Recommended Follow-Up: Implement stronger controls for identifying allowable costs and ensure accurate reporting to DHS, correcting any errors in submitted reports.

Finding Text

2023-004 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 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: • Three claims were included in the DHS-2550 and DHS-2556 reports as eligible expenditures but were not eligible for federal reimbursement. • For eleven timesheets tested, the payroll costs were allocated on an incorrect full-time equivalent (FTE) split, as the income maintenance and social services splits had been entered into the system inversely. 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 for allowable federal program activities/costs and provide detailed information necessary for maintaining proper oversight over federal programs. 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 reports submitted with unallowable activities or costs, costs allocated incorrectly, or activity reported incorrectly are corrected and resubmitted. View of Responsible Official: Acknowledge

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 498508 2023-003
    Significant Deficiency
  • 498509 2023-004
    Material Weakness
  • 498510 2023-005
    Material Weakness
  • 498511 2023-006
    Significant Deficiency
  • 498512 2023-007
    Significant Deficiency
  • 1074950 2023-003
    Significant Deficiency
  • 1074952 2023-005
    Material Weakness
  • 1074953 2023-006
    Significant Deficiency
  • 1074954 2023-007
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $1.51M
21.032 Covid-19 - Local Assistance and Tribal Consistency Fund $100,000
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $94,334
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $87,225
93.558 Temporary Assistance for Needy Families $68,281
93.667 Social Services Block Grant $49,715
93.658 Foster Care_title IV-E $43,700
97.042 Emergency Management Performance Grants $15,230
93.563 Child Support Enforcement $5,179
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $2,446
93.590 Community-Based Child Abuse Prevention Grants $1,770
93.645 Stephanie Tubbs Jones Child Welfare Services Program $988
93.778 Medical Assistance Program $581
93.556 Promoting Safe and Stable Families $554
93.575 Child Care and Development Block Grant $429
93.767 Children's Health Insurance Program $381
93.566 Refugee and Entrant Assistance_state Administered Programs $317