Finding 945685 (2023-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-02-15
Audit: 290531
Organization: Dubuque County (IA)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: The County lacks a secondary review process for Project and Expenditure Reports, risking inaccuracies in reporting.
  • Impacted Requirements: This finding violates 2 CFR 200.303(a), which mandates effective internal controls over federal awards.
  • Recommended Follow-up: Implement a control process for secondary review and approval of reports, with the Finance Director overseeing this step.

Finding Text

2023‐001 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 Reporting 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 County’s quarterly Project and Expenditure Reports were not reviewed and approved by a separate individual outside of the preparer. The reports submitted in fiscal year 2023 did not contain obligation and expenditure information for $10,000,000 in revenue replacement expenditures allocated to fiscal year 2023 eligible employee wages. Cause: The County did not have an internal control process in place to ensure a secondary review and approval of the Project and Expenditure Reports. Effect: Without a secondary review and approval, there is a greater possibility that the reports may not be accurately completed. Questioned Costs: None reported. Context: A nonstatistical sample of two out of the four quarterly Project and Expenditure Reports were tested. Repeat Finding from Prior Years: No Recommendation: We recommend the County implement a control process which includes a secondary review and approval of the Project and Expenditure Reports. Views of Responsible Officials: Moving forward, the Finance Director will review and approve the reports prior to being submitted.

Categories

Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 369243 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.58M
20.933 National Infrastructure Investments $489,873
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $233,459
10.904 Watershed Protection and Flood Prevention $157,650
93.563 Child Support Enforcement $149,955
93.498 Provider Relief Fund $95,836
16.738 Edward Byrne Memorial Justice Assistance Grant Program $66,465
93.778 Medical Assistance Program $58,830
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $51,074
16.588 Violence Against Women Formula Grants $35,367
93.069 Public Health Emergency Preparedness $24,843
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $23,104
93.268 Immunization Cooperative Agreements $18,895
16.922 Equitable Sharing Program $15,000
93.667 Social Services Block Grant $13,510
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $11,675
93.658 Foster Care_title IV-E $10,709
66.460 Nonpoint Source Implementation Grants $10,000
20.600 State and Community Highway Safety $8,117
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $6,908
93.659 Adoption Assistance $5,978
16.607 Bulletproof Vest Partnership Program $4,577
20.616 National Priority Safety Programs $3,560
16.710 Public Safety Partnership and Community Policing Grants $3,528
93.472 Title IV-E Prevention and Family Services and Programs (a) $1,519
93.436 Well-Integrated Screening and Evaluation for Women Across the Nation (wisewoman) $1,075
90.404 2018 Hava Election Security Grants $1,000
93.767 Children's Health Insurance Program $890
16.575 Crime Victim Assistance $373
93.566 Refugee and Entrant Assistance_state Administered Programs $139