Audit 414973

FY End
2024-06-30
Total Expended
$24.04M
Findings
1
Programs
33
Organization: Johnson County, Iowa (IA)
Year: 2024 Accepted: 2026-10-15
Auditor: EIDE BAILLY LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1240513 2024-003 Material Weakness Yes M

Programs

ALN Program Spent Major Findings
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $22.07M Yes 1
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $265,178 Yes 0
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $231,617 Yes 0
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $179,667 Yes 0
93.421 STRENGTHENING PUBLIC HEALTH SYSTEMS AND SERVICES THROUGH NATIONAL PARTNERSHIPS TO IMPROVE AND PROTECT THE NATION€™S HEALTH $114,000 Yes 0
12.112 PAYMENTS TO STATES IN LIEU OF REAL ESTATE TAXES $110,099 Yes 0
15.226 PAYMENTS IN LIEU OF TAXES $81,638 Yes 0
93.778 GRANTS TO STATES FOR MEDICAID $75,442 Yes 0
16.575 CRIME VICTIM ASSISTANCE $69,790 Yes 0
20.509 FORMULA GRANTS FOR RURAL AREAS AND TRIBAL TRANSIT PROGRAM $67,409 Yes 0
16.540 JUVENILE JUSTICE AND DELINQUENCY PREVENTION $60,373 Yes 0
10.561 STATE ADMINISTRATIVE MATCHING GRANTS FOR THE SUPPLEMENTAL NUTRITION ASSISTANCE PROGRAM $48,747 Yes 0
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $31,666 Yes 0
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $28,202 Yes 0
16.606 STATE CRIMINAL ALIEN ASSISTANCE PROGRAM $27,229 Yes 0
16.548 DELINQUENCY PREVENTION PROGRAM $23,789 Yes 0
93.556 MARYLEE ALLEN PROMOTING SAFE AND STABLE FAMILIES PROGRAM $15,000 Yes 0
21.009 VOLUNTEER INCOME TAX ASSISTANCE (VITA) MATCHING GRANT PROGRAM $13,250 Yes 0
93.667 SOCIAL SERVICES BLOCK GRANT $13,200 Yes 0
20.616 NATIONAL PRIORITY SAFETY PROGRAMS $11,740 Yes 0
93.116 PROJECT GRANTS AND COOPERATIVE AGREEMENTS FOR TUBERCULOSIS CONTROL PROGRAMS $11,095 Yes 0
16.922 EQUITABLE SHARING PROGRAM $9,955 Yes 0
93.658 FOSTER CARE TITLE IV-E $9,256 Yes 0
93.596 CHILD CARE MANDATORY AND MATCHING FUNDS OF THE CHILD CARE AND DEVELOPMENT FUND $8,483 Yes 0
93.659 ADOPTION ASSISTANCE $6,447 Yes 0
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $4,061 Yes 0
16.710 PUBLIC SAFETY PARTNERSHIP AND COMMUNITY POLICING GRANTS $2,918 Yes 0
21.016 EQUITABLE SHARING $2,767 Yes 0
93.070 ENVIRONMENTAL PUBLIC HEALTH AND EMERGENCY RESPONSE $2,000 Yes 0
93.472 TITLE IV-E PREVENTION PROGRAM $1,707 Yes 0
93.767 CHILDREN'S HEALTH INSURANCE PROGRAM $1,473 Yes 0
93.566 REFUGEE AND ENTRANT ASSISTANCE STATE/REPLACEMENT DESIGNEE ADMINISTERED PROGRAMS $312 Yes 0
93.090 GUARDIANSHIP ASSISTANCE $12 Yes 0

Contacts

Name Title Type
CBYASLYK7CQ5 Dana Aschenbrenner Auditee
3196888095 Brian Unsen Auditor
No contacts on file

Notes to SEFA

The accompanying Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of Johnson County, Iowa under programs of the federal government for the year ended June 30, 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 Johnson County, Iowa, it is not intended to and does not present the financial position, changes in financial position or cash flows of Johnson County, Iowa. The County received federal awards both directly from federal agencies and indirectly through pass-through entities. Federal financial assistance provided to a subrecipient is treated as an expenditure when it is paid to the subrecipient. Federal financial assistance provided to subrecipients as follows: 21.027 CSLFRF - Iowa Legal Aid, Coralville Community Food Pantry, and Friends of Coralville Lake

Finding Details

U.S. Department of Treasury Federal Financial Assistance Listing 21.027 Coronavirus State and Local Fiscal Recovery Funds Subrecipient Monitoring Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria – Per 2 CFR 200.332, Johnson County is responsible for informing subrecipients of the Federal award identifiers including but not limited to award date, period of performance and Federal awarding agency and Assistance Listing Number and title. Johnson County is required to assess the subrecipient’s risk of noncompliance with Federal statutes, regulations and the terms and conditions of the subaward. In addition, the County should also verify that the subrecipient is audited as required by Subpart F - Audit Requirement under the Uniform Guidance. The monitoring policy should include an initial evaluation of the risk of noncompliance to determine the appropriate level of monitoring required related to the subaward as well as appropriate awarding documentation. Condition – During our testing, we evaluated the procedures for evaluating subrecipient’s risk of noncompliance with Federal statutes, regulations and the terms and conditions of the subaward. We noted the following:  For three (3) of three (3) subrecipients selected, the required evaluation of the subrecipient’s risk of noncompliance was not documented.  For one (1) of three (3) subrecipients selected, the County did not provide a formal subrecipient agreement including the required information noted in 2 CFR 200.332. Cause – The County did not adhere to their established policies and procedures relating to risk assessment when a subrecipient contract is awarded. Effect – The County’s policies were not consistently followed, resulting in noncompliance with subrecipient monitoring requirements in 2 CFR 200.332. Additionally, the County’s control policies were not consistently followed. Questioned Costs – None reported. Context/Sampling – The sample of three (3) subrecipients were selected for subrecipient monitoring testing for the direct award from the US Department of Treasury. The total population across the program was thirteen (13) subrecipients. Repeat Finding from Prior Years – No. Recommendation – We recommend that the County adhere to their policies and procedures in accordance with 2 CFR 200.332 to ensure compliance with subrecipient monitoring requirements. View of Responsible Officials – The understanding of current staff is that the risk assessments were completed as appropriate, however, due to staff turnover the documents have been misplaced and no longer seem to be available. Applicable County teams are working to adopt standards for what documentation is necessary to establish the basis for a transaction, as well as standardizing the repository for such documentation.