Audit 382642

FY End
2024-12-31
Total Expended
$93.76M
Findings
4
Programs
53
Organization: Dakota County (MN)
Year: 2024 Accepted: 2026-01-20

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1169642 2024-001 Material Weakness Yes N
1169643 2024-004 Material Weakness Yes I
1169644 2024-002 Material Weakness Yes B
1169645 2024-003 Material Weakness Yes N

Programs

ALN Program Spent Major Findings
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $34.46M Yes 0
93.778 MEDICAL ASSISTANCE PROGRAM $15.49M Yes 2
93.563 CHILD SUPPORT SERVICES $6.10M Yes 0
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $3.50M Yes 2
93.558 TEMPORARY ASSISTANCE FOR NEEDY FAMILIES $2.88M Yes 0
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $2.69M Yes 0
10.557 WIC SPECIAL SUPPLEMENTAL NUTRITION PROGRAM FOR WOMEN, INFANTS, AND CHILDREN $1.72M Yes 0
93.667 SOCIAL SERVICES BLOCK GRANT $1.52M Yes 0
97.067 HOMELAND SECURITY GRANT PROGRAM $1.42M Yes 0
93.870 MATERNAL, INFANT AND EARLY CHILDHOOD HOME VISITING GRANT $1.32M Yes 0
93.658 FOSTER CARE TITLE IV-E $1.17M Yes 0
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $1.02M Yes 0
15.941 MISSISSIPPI NATIONAL RIVER AND RECREATION AREA STATE AND LOCAL ASSISTANCE $900,000 Yes 0
93.575 CHILD CARE AND DEVELOPMENT BLOCK GRANT $869,966 Yes 0
14.267 CONTINUUM OF CARE PROGRAM $659,986 Yes 0
10.572 WIC FARMERS' MARKET NUTRITION PROGRAM (FMNP) $523,950 Yes 0
20.205 HIGHWAY PLANNING AND CONSTRUCTION $436,965 Yes 0
17.259 WIOA YOUTH ACTIVITIES $329,566 Yes 0
93.069 PUBLIC HEALTH EMERGENCY PREPAREDNESS $314,982 Yes 0
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $279,366 Yes 0
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $276,088 Yes 0
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $255,407 Yes 0
17.278 WIOA DISLOCATED WORKER FORMULA GRANTS $233,454 Yes 0
93.967 CENTERS FOR DISEASE CONTROL AND PREVENTION COLLABORATION WITH ACADEMIA TO STRENGTHEN PUBLIC HEALTH $201,224 Yes 0
17.258 WIOA ADULT PROGRAM $196,746 Yes 0
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $193,811 Yes 0
21.023 EMERGENCY RENTAL ASSISTANCE PROGRAM $186,743 Yes 0
16.575 CRIME VICTIM ASSISTANCE $180,802 Yes 0
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $160,469 Yes 0
95.001 HIGH INTENSITY DRUG TRAFFICKING AREAS PROGRAM $105,623 Yes 0
93.590 COMMUNITY-BASED CHILD ABUSE PREVENTION GRANTS $100,245 Yes 0
16.585 TREATMENT COURT DISCRETIONARY GRANT PROGRAM $98,933 Yes 0
97.042 EMERGENCY MANAGEMENT PERFORMANCE GRANTS $98,879 Yes 0
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $89,490 Yes 0
16.579 EDWARD BYRNE MEMORIAL FORMULA GRANT PROGRAM $84,699 Yes 0
93.659 ADOPTION ASSISTANCE $82,652 Yes 0
93.674 JOHN H. CHAFEE FOSTER CARE PROGRAM FOR SUCCESSFUL TRANSITION TO ADULTHOOD $68,017 Yes 0
16.922 EQUITABLE SHARING PROGRAM $59,097 Yes 0
93.958 BLOCK GRANTS FOR COMMUNITY MENTAL HEALTH SERVICES $57,224 Yes 0
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $53,558 Yes 0
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $44,792 Yes 0
10.555 NATIONAL SCHOOL LUNCH PROGRAM $25,812 Yes 0
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $24,509 Yes 0
20.608 MINIMUM PENALTIES FOR REPEAT OFFENDERS FOR DRIVING WHILE INTOXICATED $19,666 Yes 0
97.012 BOATING SAFETY FINANCIAL ASSISTANCE $18,916 Yes 0
93.070 ENVIRONMENTAL PUBLIC HEALTH AND EMERGENCY RESPONSE $17,069 Yes 0
10.553 SCHOOL BREAKFAST PROGRAM $14,280 Yes 0
93.008 MEDICAL RESERVE CORPS SMALL GRANT PROGRAM $13,875 Yes 0
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $8,601 Yes 0
93.251 EARLY HEARING DETECTION AND INTERVENTION $4,350 Yes 0
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $4,252 Yes 0
84.181 SPECIAL EDUCATION-GRANTS FOR INFANTS AND FAMILIES $2,100 Yes 0
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $1,408 Yes 0

Contacts

Name Title Type
DCNCCMS96EL5 Will Wallo Auditee
6514384585 Christopher Knopik Auditor
No contacts on file

Notes to SEFA

The schedule of expenditures of federal awards (Schedule) presents the activities of federal award programs expended by Dakota County. Dakota County’s financial statements include the operations of the Dakota County Community Development Agency (CDA) component unit, which expended $44,733,783 in federal awards during the year ended Dakota County, which are not included in the schedule of expenditures of federal awards. The Dakota County CDA has its own single audit. The County’s reporting entity is defined in Note 1 to the financial statements.
The accompanying Schedule includes the federal grant activity of Dakota County under programs of the federal government for the year ended December 31, 2024. 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). Because the Schedule presents only a selected portion of the operations of Dakota County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Dakota County.

Finding Details

Federal Agency: U.S. Department of Agriculture Federal Program Name: Supplemental Nutrition Assistance Program Cluster Assistance Listing Number: 10.561 Federal Award Identification Number and Year: 242MN101S2514 – 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Number: H55240010 Compliance Requirement: Special Provisions Award Period: 2024 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Criteria or specific requirement: Agencies are required to automate their SNAP operations and computerize their systems for obtaining, maintaining, utilizing, and transmitting information concerning SNAP (7 CFR sections 272.10 and 277.18). This includes: (1) processing and storing all case file information necessary for eligibility determination and benefit calculation, identifying specific elements that affect eligibility, and notifying the certification unit of cases requiring notices of case disposition, adverse action and mass change, and expiration; (2) providing an automatic cutoff of participation for households that have not been recertified at the end of their certification period by reapplying and being determined eligible for a new period (7 CFR sections 272.10(b)(1)(iii) and 273.10(f) and (g)); and (3) generating data necessary to meet federal issuance and reconciliation reporting requirements. 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. Condition: The Minnesota Department of Human Services (DHS) maintains the computer system, MAXIS, which is used by the County to support the eligibility determination process. The sample size was based on guidance from chapter 11 of the AICPA Audit Guide, Government Auditing Standards and Single Audits. While periodic supervisory case reviews are performed to monitor compliance with grant requirements for eligibility, when performing our case file review for eligibility, we noted: • There was no verification of income on 2 of the 60 casefiles tested. • There was not a proper documented redetermination of eligibility on 1 of the 60 casefiles tested. Questioned costs: None Context: Three of the 60 casefiles tested had the above noted issues. Cause: The County has had significant turnover and new staff over the past few years as well as increases in caseloads. There was also changing guidance as waivers from the pandemic expired. All of this provided more opportunities for errors to occur. Effect: Improper input or updating of information in MAXIS and lack of verification or follow-up of eligibility determining factors increase the risk that a program participant will receive benefits when they are not eligible. Repeat finding: Yes – 2023-007 Recommendation: We recommend the County implement processes and procedures to provide reasonable assurance that all necessary documentation to support eligibility determination exists and is properly input or updated in MAXIS and issues are followed up in a timely manner. Views of responsible officials: There is no disagreement with the finding.
Federal Agency: U.S. Department of Agriculture Federal Program Name: Supplemental Nutrition Assistance Program Cluster Assistance Listing Number: 10.561 Federal Award Identification Number and Year: 232MN101S2514 – 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Numbers: H55240010 Compliance Requirement: Procurement, Suspension, and Debarment Award Period: 2024 Type of Finding: Significant Deficiency in Internal Control Over Compliance Criteria or specific requirement: The County must follow Uniform Guidance Subsection 200.320 Methods of Procurement for all applicable procurements over the County’s micro-purchase threshold. For purchases over the County's micro-purchase threshold of $10,000 but not exceeding the simplified acquisition threshold of $250,000, the County should follow small purchase procedures. If small purchase procedures are used, price or rate quotations must be obtained from an adequate number of qualified sources as determined appropriate by the County. 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. Condition: During our testing, it was noted that for one contract out of four tested the County was unable to provide documentation showing that the county followed the open competition requirement. Questioned costs: None Context: One out of the four contracts tested had no documentation of open competition. Cause: The County purchasing likely followed County purchase policies for nonfederal expenditures. Effect: It would be possible that the County could end up spending more federal dollars than necessary for a product or service, if they are not going through the steps to ensure they are utilizing the best vendor for the county and documenting this process each year. Repeat finding: 2023-010 Recommendation: We recommend the County follow their federal purchasing policy in all their federal programs and retain documentation of that process occurring. As necessary, the County may need to add internal controls that are specific to each program to ensure this properly occurs. Views of responsible officials: There is no disagreement with the finding.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Medical Assistance Assistance Listing Numbers: 93.778 Federal Award Identification Numbers and Years: 2405MN5ADM - 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Numbers: H55245048 Compliance Requirement: Allowable Activities Award Period: 2024 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Criteria or specific requirement: The Minnesota Department of Human Services (DHS) requires a listing of employees working on social services programs to be submitted quarterly, known as a random moment study listing (RMS listing). DHS then determines the amount applicable to the applicable income maintenance programs through random moment studies. Each quarter the County’s coordinator reviews their RMS listing to ensure the employees listed are accurate for the people working and being coded in the general ledger. 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. Condition: One individual was included in the 2nd quarter Social Services RMS listing sent to the State that was not supposed to be included in the listing, one individual was noted to have the same issue on the 2nd quarter of the public health local collaborative time study participant listing. Questioned costs: None Context: In our testing of two of the eight quarterly RMS listings, one individual was included in the 2nd quarter Social Services RMS listing sent to the State that was not supposed to be included in the listings, one individual was noted to have the same issue on the 2nd quarter public health local collaborative time study participant listing. There were 335 County staff listed in the 2nd quarter’s RMS listing and 52 participants listed in the 2nd quarter public health LCTS RMS listing. Cause: The County's RMS controls and procedures were not robust enough to note that the RMS listings should have excluded the noted individuals. Increased turnover and growth of the programs also created an increase in the number changes that were needed to be made to the listings. Effect: Lack of proper controls could affect allocation of fundings due to the staff not being in MAXIS or actually assigned to social services or public health LCTS case files to properly respond to the random moment requests that are sent by the State as part of the random moment study. Repeat Finding: Yes 2023-009 Recommendation: We recommend that the County review its procedures and control to ensure all RMS listings sent to the State properly exclude those necessary individuals no longer working in the programs. Views of responsible officials: There is no disagreement with the audit finding.
Federal Agency: U.S. Department of Health and Human Services Federal Program Name: Medical Assistance Assistance Listing Numbers: 93.778 Federal Award Identification Numbers and Years: 2405MN5ADM - 2024 Passed Through Entity: Minnesota Department of Human Services Pass Through Numbers: H55245048 Compliance Requirement: Special Provisions Award Period: 2024 Type of Finding: Material Weakness in Internal Control Over Compliance, Other Matters Criteria or specific requirement: 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. The County and the Minnesota Department of Human Services (DHS) have a contract surrounding the federal funds. This contract has several obligations and reporting requirements the County must follow including the requirement the county must work with its collaborative partners to ensure that the LCTS coordinators and staff sampled by the LCTS have completed training approved by the State in the LCTS. Condition: The County was unable to provide a documented formal review process to ensure that LCTS fiscal site contacts were trained on completing cost schedules. Questioned costs: None Context: The County did not provide the documentation of the review over the noted requirement. Cause: The County did not maintain a record of their review process. Also, there has been fewer resources provided in recent years from the Minnesota Department of Human Services to help meet the specific training requirements of LCTS fiscal site contacts completing cost schedule reports. Effect: There is no way to verify the review process was completed and completed timely. Repeat finding: 2023-013 Recommendation: We recommend that the County reviews its polices and controls to ensure there is a formally documented control that ensures all required training of LCTS fiscal site contacts is completed and the documentation of the completions of the training is retained. Views of responsible officials: There is no disagreement with the finding.