Audit 328814

FY End
2023-12-31
Total Expended
$5.85M
Findings
2
Programs
28
Organization: Douglas County (MN)
Year: 2023 Accepted: 2024-11-18

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
508278 2023-002 Significant Deficiency - E
1084720 2023-002 Significant Deficiency - E

Programs

ALN Program Spent Major Findings
20.205 Highway Planning and Construction $2.00M Yes 0
93.778 Medical Assistance Program $1.16M Yes 1
93.563 Child Support Enforcement $769,186 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $444,909 - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $368,184 Yes 0
93.558 Temporary Assistance for Needy Families $268,236 - 0
93.667 Social Services Block Grant $230,113 - 0
93.658 Foster Care_title IV-E $146,302 - 0
21.032 Local Assistance and Tribal Consistency Fund $100,000 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $69,229 - 0
20.616 National Priority Safety Programs $48,785 - 0
16.735 Prea Program: Demonstration Projects to Establish 'zero Tolerance' Cultures for Sexual Assault in Correctional Facilities $38,538 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $31,766 - 0
20.600 State and Community Highway Safety $30,624 - 0
97.042 Emergency Management Performance Grants $27,466 - 0
20.219 Recreational Trails Program $25,000 - 0
97.012 Boating Safety Financial Assistance $22,453 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $19,857 - 0
93.575 Child Care and Development Block Grant $11,251 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $6,658 - 0
93.590 Community-Based Child Abuse Prevention Grants $5,892 - 0
93.747 Elder Abuse Prevention Interventions Program $5,738 - 0
93.556 Promoting Safe and Stable Families $4,199 - 0
93.958 Block Grants for Community Mental Health Services $3,234 - 0
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $2,828 - 0
16.607 Bulletproof Vest Partnership Program $2,447 - 0
93.767 Children's Health Insurance Program $1,730 - 0
93.566 Refugee and Entrant Assistance_state Administered Programs $1,479 - 0

Contacts

Name Title Type
CKRWYFVWFWL4 Jill Frisell Auditee
3207623880 Miranda Wendlandt Auditor
No contacts on file

Notes to SEFA

Title: Reporting Entity Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The Schedule of Expenditures of Federal Awards presents the activities of federal award programs expended by Douglas County. The County’s reporting entity is defined in Note 1 to the financial statements. The Housing and Redevelopment Authority of Douglas County and Pope/Douglas Solid Waste Management, discretely presented component units, expended $1,581,982 and $0, respectively, in federal awards not included in this schedule because they had separate single audits in accordance with Uniform Guidance, as applicable. The schedule does not include the federal expenditures of the Alomere Health enterprise fund which issues standalone financial statements.
Title: Basis of Presentation Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying Schedule of Expenditures of Federal Awards includes the federal grant activity of Douglas County under programs of the federal government for the year ended December 31, 2023. 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 Douglas County, it is not intended to and does not present the financial position, changes in net position, or cash flows of Douglas County.
Title: Reconciliation to Schedule of Intergovernmental Revenue Accounting Policies: Expenditures reported on the schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Douglas County has elected to not use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Total federal revenue per Schedule of Intergovernmental Revenue: $4,940,049 Grants received more than 60 days after year-end unavailable in 2023: Promoting Safe and Stable Families: $1,050 Temporary Assistance for Needy Families: $44,059 Stephanie Tubbs Jones Child Welfare Services Program: $1,045 Highway Planning and Construction: $866,500 Grants unavailable in 2022, recognized as revenue in 2023: Promoting Safe and Stable Families: $(1,520) Stephanie Tubbs Jones Child Welfare Services Program: $(2,710) Foster Care Title IV-E: $(1,823) Total Federal Awards per Schedule of Expenditures of Federal Awards: $5,846,650

Finding Details

Federal Agency: U.S. Department of Health and Human Services Federal Program: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2305MN5MAP -2023, 2305MN5ADM -2023 Compliance Requirement Affected: Eligibility Award Period: Year Ended December 31, 2023 Type of Finding: Significant Deficiency in Internal Controls over Compliance 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. Condition: The County did not have adequate internal controls over the casefiles. Questioned Costs: None Context: The County did not have anyone internally reviewing the casefiles. Cause: Limited number of personnel. Effect: The County could be reporting inaccurate information effecting the status of eligibility. Repeat Finding: No Recommendation: We recommend the County designate qualified personnel responsible for conducting casefile reviews. The reviews should be performed on predetermined frequencies and documented. Formal procedures should be documented to ensure consistency and effectiveness of the quality review process. Views of Responsible Officials: There is no disagreement with the audit finding.
Federal Agency: U.S. Department of Health and Human Services Federal Program: Medical Assistance Assistance Listing Number: 93.778 Federal Award Identification Number and Year: 2305MN5MAP -2023, 2305MN5ADM -2023 Compliance Requirement Affected: Eligibility Award Period: Year Ended December 31, 2023 Type of Finding: Significant Deficiency in Internal Controls over Compliance 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. Condition: The County did not have adequate internal controls over the casefiles. Questioned Costs: None Context: The County did not have anyone internally reviewing the casefiles. Cause: Limited number of personnel. Effect: The County could be reporting inaccurate information effecting the status of eligibility. Repeat Finding: No Recommendation: We recommend the County designate qualified personnel responsible for conducting casefile reviews. The reviews should be performed on predetermined frequencies and documented. Formal procedures should be documented to ensure consistency and effectiveness of the quality review process. Views of Responsible Officials: There is no disagreement with the audit finding.