Audit 410296

FY End
2025-12-31
Total Expended
$9.63M
Findings
6
Programs
37
Organization: Beltrami County (MN)
Year: 2025 Accepted: 2026-09-02

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1228651 2025-003 Material Weakness Yes A
1228652 2025-003 Material Weakness Yes A
1228653 2025-003 Material Weakness Yes A
1228654 2025-003 Material Weakness Yes A
1228655 2025-004 Material Weakness Yes E
1228656 2025-004 Material Weakness Yes E

Programs

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

Contacts

Name Title Type
UKEKLT33SPHB Jodee Treat Auditee
2183334175 Douglas P Host Auditor
No contacts on file

Notes to SEFA

The Schedule of Expenditures of Federal Awards presents the activity of federal award programs expended by Beltrami County (the County). The County's reporting entity is defined in Note 1 to the financial statements
The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Beltrami County under programs of the federal government for the year ended December 31, 2025. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) from the Office of Management and Budget (OMB). Because the schedule presents only a selected portion of the operations of Beltrami County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Beltrami County.
Reconciliation to the Schedule of Intergovernmental Revenue Federal Grant Revenue per Schedule of Intergovernmental Revenue $ 9,563,107 Expenditures in the Schedule of Expenditures of Federal Awards, not included as revenues reported in the Schedule of Intergovernmental Revenue 1 54,405 Revenues included on the Schedule of Intergovernmental Revenue that are not considered Federal Grant Expenditures ( 89,998) Expenditures per Schedule of Expenditures of Federal Awards $ 9,627,514

Finding Details

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.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Temporary Assistance for Needy Families (TANF) Assistance Listing Number: 93.558 Pass-Through Agency: Minnesota Department of Human Services and Minnesota Department of Health Federal Award Identification and Pass-Through Numbers: 2501MNTANF Award Period: Year Ended December 31, 2025 Compliance Requirement: Eligibility Type of Finding: Significant Deficiency in Internal Control over Compliance Criteria or Specific Requirement: Federal guidelines require grant recipients to implement internal controls for each direct and material compliance requirement applicable to the federal grant to ensure compliance with said requirements. Condition and Context: During testing of controls over Eligibility (i.e., casefile reviews), it was noted that there was no formal documentation on file to indicate that internal reviews were performed over public health casefiles. 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 standard documentation procedures over internal reviews. Effect: The County may be incorrectly concluding that an applicant is eligible for the federal programs they are applying for. Repeat Finding: Yes – 2024-005. Recommendation: We recommend the County perform internal casefile reviews. In addition, the County should implement standard documentation that will formalize the performed reviews. Views of responsible officials: There is no disagreement with the audit finding. Additional documentation and specific casefile reviews will be implemented.