Audit 338490

FY End
2024-06-30
Total Expended
$3.44M
Findings
2
Programs
25
Organization: Dubuque County (IA)
Year: 2024 Accepted: 2025-01-16
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
519507 2024-001 Material Weakness - M
1095949 2024-001 Material Weakness - M

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.07M Yes 1
20.205 Highway Planning and Construction $358,512 - 0
20.933 National Infrastructure Investments $290,778 - 0
10.904 Watershed Protection and Flood Prevention $143,780 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $70,000 - 0
93.778 Medical Assistance Program $69,740 - 0
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $55,905 - 0
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $44,821 - 0
16.922 Equitable Sharing Program $39,238 - 0
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $31,192 - 0
93.069 Public Health Emergency Preparedness $22,046 - 0
93.667 Social Services Block Grant $12,184 - 0
16.588 Violence Against Women Formula Grants $10,633 - 0
20.600 State and Community Highway Safety $8,885 - 0
93.658 Foster Care Title IV-E $8,567 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $7,797 - 0
93.268 Immunization Cooperative Agreements $6,135 - 0
93.659 Adoption Assistance $5,931 - 0
16.607 Bulletproof Vest Partnership Program $4,461 - 0
16.710 Public Safety Partnership and Community Policing Grants $3,025 - 0
93.472 Title IV-E Prevention Program $1,577 - 0
93.767 Children's Health Insurance Program $1,363 - 0
93.436 Well-Integrated Screening and Evaluation for Women Across the Nation (wisewoman) $500 - 0
16.575 Crime Victim Assistance $400 - 0
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $284 - 0

Contacts

Name Title Type
J6LXFF4ZKYJ3 Megan Bonert Auditee
5635894490 Brian Unsen Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported in the schedule are reported on the modified accrual basis of accounting, except for subrecipient expenditures, which are recorded on the cash basis. 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. De Minimis Rate Used: N Rate Explanation: The County has not elected to use the 10% de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Dubuque County, Iowa, under programs of the federal government for the year ended June 30, 2024. The information 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 the County, it is not intended to and does not present the financial position, changes in net position or fund balance, or cash flows of the County.

Finding Details

Department of the Treasury FFAL #21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Applicable Federal Award Number and Year – SLFRP0515 for 2021 Subrecipient Monitoring Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The subrecipient agreement requires the submission of quarterly performance reports by the subrecipient within fifteen days of quarter end. However, no quarterly performance reports were submitted by the subrecipient for the year ended June 30, 2024, as of August 1, 2024. Cause: The County did not have an internal control process in place to ensure the quarterly performance reports were received by the subrecipient timely. Effect: Without the timely submission of the quarterly performance reports by the subrecipient and review of those reports by the County, there is a greater possibility of ineligible expenditures. Questioned Costs: None reported. Context: No sampling was used. There was only one subrecipient during the year ended June 30, 2024 and it was selected for testing. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which ensures quarterly performance reports are received by the subrecipient timely and that those reports are reviewed and approved by County personnel. Views of Responsible Officials: Dubuque County acknowledges the comment and has implemented a process to receive and review quarterly performance reports from the subrecipient.
Department of the Treasury FFAL #21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Applicable Federal Award Number and Year – SLFRP0515 for 2021 Subrecipient Monitoring Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The subrecipient agreement requires the submission of quarterly performance reports by the subrecipient within fifteen days of quarter end. However, no quarterly performance reports were submitted by the subrecipient for the year ended June 30, 2024, as of August 1, 2024. Cause: The County did not have an internal control process in place to ensure the quarterly performance reports were received by the subrecipient timely. Effect: Without the timely submission of the quarterly performance reports by the subrecipient and review of those reports by the County, there is a greater possibility of ineligible expenditures. Questioned Costs: None reported. Context: No sampling was used. There was only one subrecipient during the year ended June 30, 2024 and it was selected for testing. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which ensures quarterly performance reports are received by the subrecipient timely and that those reports are reviewed and approved by County personnel. Views of Responsible Officials: Dubuque County acknowledges the comment and has implemented a process to receive and review quarterly performance reports from the subrecipient.