Finding 1228654 (2025-003)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
-
Year
2025
Accepted
2026-09-02
Audit: 410296
Organization: Beltrami County (MN)

AI Summary

  • Core Issue: There are discrepancies in payroll records for participants in Medicaid and TANF programs, with some salaries not properly coded.
  • Impacted Requirements: Compliance with Uniform Guidance is lacking, specifically in accurately reflecting work performed and reconciling payroll account coding.
  • Recommended Follow-Up: Implement a quarterly review and reconciliation process to ensure accurate reporting of participating workers and their wages.

Finding Text

Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Grants to States for Medicaid (Medicaid Cluster) and Temporary Assistance for Needy Families (TANF) Assistance Listing Number: 93.778 and 93.558 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Health Federal Award Identification and Pass-Through Numbers: 2505MN5ADM, 2505MN5MAP, and 2501MNTANF Award Period: Year Ended December 31, 2025 Compliance Requirement: Activities Allowed/Allowable Costs Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Criteria or Specific Requirement: Uniform Guidance requires the County to charge salaries and wages based on records that accurately reflect the work performed by participating workers related to income maintenance, social services, and local collaborative public health activities on the RMS listings. The Uniform Guidance further requires the County to reconcile payroll account coding so that only the wages of participants are charged. Condition and Context: During our testing of the income maintenance RMS listings,1 of 2 quarterly reports had 2 participants who were reported on the listing but whose salaries and wages were not included in the appropriate payroll account codes. During testing of the social services RMS listings, 2 of 2 quarterly reports had 1 participant who was reported on the listing but whose salaries and wages were not included in the appropriate payroll account codes. During testing of the local collaborative public health RMS listings, 1 of 2 quarterly reports had 1 participant who was reported on the listing but who should not have been. The sample sizes were based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. Questioned Costs: None noted. Cause: Lack of management oversight. Effect: There is minimal effect on the programs. Due to the funding structure, the random moment studies are only used to determine the allocation percentages to the various federal programs and not to determine the total amount of reimbursement. Repeat Finding: No. Recommendation: We recommend the County implement a quarterly review and reconciliation procedure to ensure that the population of participating workers included in each RMS listing agrees to the population of participating workers whose salaries and wages were recorded to the corresponding payroll account codes. Views of responsible officials: There is no disagreement with the audit finding. Quarterly review procedures will be implemented.

Corrective Action Plan

RANDOM MOMENT STUDY (RMS) EMPLOYEE LISTING Federal Agency: U.S. Department of Health and Human Services Federal Program Title: Grants to States for Medicaid (Medicaid Cluster) and Temporary Assistance for Needy Families (TANF) Assistance Listing Number: 93.778 and 93.558 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Health Pass-Through Numbers: 2505MN5ADM, 2505MN5MAP, and 2501MNTANF Award Period: Year-Ended December 31, 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance and Other Matter Recommendation: It is recommended the County implement a quarterly review and reconciliation procedure to ensure that the population of participating workers included in each RMS listing agrees to the population of participating workers whose salaries and wages were recorded to the corresponding payroll accounts. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Action taken in response to finding: The County will strive to implement quarterly review and reconciliation procedures over the RMS listing and corresponding payroll accounts. Name of the contact person responsible for corrective action plan: Anne Lindseth, Health and Human Services Director Planned completion date for corrective action plan: December 31, 2026

Categories

Allowable Costs / Cost Principles Internal Control / Segregation of Duties Cash Management Significant Deficiency

Other Findings in this Audit

  • 1228651 2025-003
    Material Weakness Repeat
  • 1228652 2025-003
    Material Weakness Repeat
  • 1228653 2025-003
    Material Weakness Repeat
  • 1228655 2025-004
    Material Weakness Repeat
  • 1228656 2025-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.205 HIGHWAY PLANNING AND CONSTRUCTION $1.10M
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $836,978
93.658 FOSTER CARE TITLE IV-E $507,184
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $273,576
15.226 PAYMENTS IN LIEU OF TAXES $143,861
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $95,000
93.912 RURAL HEALTHCARE SERVICES PROGRAMS $84,353
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $60,987
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $57,622
93.667 SOCIAL SERVICES BLOCK GRANT $51,630
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $45,189
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $38,335
16.609 PROJECT SAFE NEIGHBORHOODS $29,309
16.575 CRIME VICTIM ASSISTANCE $23,452
93.563 CHILD SUPPORT SERVICES $22,655
20.219 RECREATIONAL TRAILS PROGRAM $22,604
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $21,872
93.472 TITLE IV-E PREVENTION PROGRAM $19,882
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $15,121
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $12,719
93.778 GRANTS TO STATES FOR MEDICAID $9,897
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $9,083
10.665 SCHOOLS AND ROADS - GRANTS TO STATES $7,964
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $5,400
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $4,333
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $3,392
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $2,885
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $2,794
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $2,662
16.922 EQUITABLE SHARING PROGRAM $2,241
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,999
20.609 SAFETY BELT PERFORMANCE GRANTS $1,614
10.578 WIC GRANTS TO STATES (WGS) $1,309
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $1,223
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $700
93.251 EARLY HEARING DETECTION AND INTERVENTION $600
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $442