Finding 522063 (2024-001)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2024
Accepted
2025-02-05
Audit: 341288
Organization: Linn County (IA)
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: The County's internal controls failed to catch errors in the Project and Expenditure Report, leading to inaccurate reporting of obligations.
  • Impacted Requirements: Compliance with 2 CFR 200.303(a) was not met, as effective internal controls were not maintained over federal award management.
  • Recommended Follow-Up: Implement a stronger control process with a thorough secondary review of reported obligations in future Project and Expenditure Reports.

Finding Text

2024-001 Department of the Treasury FFAL #21.027 COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Applicable Federal Award Number and Year – SLFRP0336 for 2021 Reporting Significant Deficiency in Internal Control Over Compliance 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 Report for the quarter ended September 2023 reported several items as current period obligations that were reported as current period obligations in the previous quarter. Cause: The County’s internal control process included a secondary review and approval of the Project and Expenditure Reports. However, the review did not identify the errors in the amounts reported as current period obligations in the September 2023 report. Effect: Inaccurate information was reported to the federal awarding agency. 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 amounts reported as current period obligations within the Project and Expenditure Reports. Views of Responsible Officials: The Finance Director currently reconciles cumulative expenditures to the reports prepared by the Senior Accountant before signing and dating the report, prior to submission by the Senior Accountant. There will be no additional current obligations in the future due to the December 31, 2024 deadline for obligations.

Corrective Action Plan

Finding 2024-001 Reporting Federal Agency Name: Department of the Treasury Pass‐Through Entity: Not applicable. Direct program. Assistance Listing Number: 21.027 Program Name: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Finding Summary: The County’s quarterly Project and Expenditure Report for the quarter ended September 2023 reported several items as current period obligations that were reported as current period obligations in the previous quarter. Corrective Action Plan: The Finance Director currently reconciles cumulative expenditures to the reports prepared by the Senior Accountant before signing and dating the report, prior to submission by the Senior Accountant. There will be no additional current obligations in the future due to the December 31, 2024 deadline for obligations. Responsible Individual: Dawn Jindrich, Finance Director Anticipated Completion Date: June 30, 2025

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1098505 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $10.98M
21.023 Covid-19 Emergency Rental Assistance Program $2.54M
93.778 Medical Assistance Program $341,911
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $247,191
66.605 Performance Partnership Grants $123,150
93.069 Public Health Emergency Preparedness $117,291
93.136 Injury Prevention and Control Research and State and Community Based Programs $80,419
95.001 High Intensity Drug Trafficking Areas Program $79,746
10.558 Child and Adult Care Food Program $76,504
93.318 Protecting and Improving Health Globally: Building and Strengthening Public Health Impact, Systems, Capacity and Security $60,000
16.540 Juvenile Justice and Delinquency Prevention $53,988
93.539 Pphf Capacity Building Assistance to Strengthen Public Health Immunization Infrastructure and Performance Financed in Part by Prevention and Public Health Funds $46,100
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $41,677
93.667 Social Services Block Grant $41,426
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nations Health $40,000
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $32,780
93.658 Foster Care Title IV-E $29,123
10.555 National School Lunch Program $28,991
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $26,607
16.738 Edward Byrne Memorial Justice Assistance Grant Program $21,200
93.659 Adoption Assistance $20,197
66.468 Drinking Water State Revolving Fund $20,150
20.205 Highway Planning and Construction $20,031
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $18,999
93.268 Immunization Cooperative Agreements $17,610
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $17,500
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $16,200
97.047 Bric: Building Resilient Infrastructure and Communities $15,188
10.553 School Breakfast Program $14,561
93.917 Hiv Care Formula Grants $14,205
20.509 Formula Grants for Rural Areas and Tribal Transit Program $13,079
10.902 Soil and Water Conservation $10,439
15.904 Historic Preservation Fund Grants-in-Aid $9,000
93.556 Marylee Allen Promoting Safe and Stable Families Program $7,515
93.472 Title IV-E Prevention Program $5,348
10.912 Environmental Quality Incentives Program $5,220
10.924 Conservation Stewardship Program $5,220
93.767 Children's Health Insurance Program $4,613
10.559 Summer Food Service Program for Children $4,400
93.116 Project Grants and Cooperative Agreements for Tuberculosis Control Programs $3,850
14.228 Community Development Block Grants/state's Program and Non-Entitlement Grants in Hawaii $2,686
93.566 Marylee Allen Promoting Safe and Stable Families Program $950
93.090 Guardianship Assistance $39