Finding 607787 (2022-003)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-06-26
Audit: 33794
Organization: Dekalb County (IL)

AI Summary

  • Core Issue: Quarterly reports to the Department of Treasury lack independent review, risking inaccuracies.
  • Impacted Requirements: Compliance with CFR section 200.303 on internal controls for managing Federal awards is not met.
  • Recommended Follow-up: Establish a formal review process for grant reports, ensuring documentation and independent verification before submission.

Finding Text

Finding 2022-003: ARPA reporting review Assistance listing number: 21.027 Program title: Coronavirus State and Local Fiscal Recovery Funds Federal award identification number / year: N/A / 2022 Pass-through entity: N/A Criteria: Per CFR section 200.303, "The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in ?Standards for Internal Control in the Federal Government? issued by the Comptroller General of the United States or the ?Internal Control Integrated Framework?, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO)." Condition: Quarterly reports submitted to the Department of Treasury are not being reviewed by someone other than the preparer. Cause: The County has not established a formal process around reviews of grant reporting. Effect: Revenue loss and expenditure information included in the Project and Expenditure reports required to be submitted to the Department of Treasury may be incorrectly stated. Questioned Costs: None noted Context: This represents a systemic matter as a formalized review process for grant reporting does not exist. Recommendation: We recommend the County implement a formal review process for all grant reports wherein a documented review conducted by someone other than the preparer is completed prior to submission. Management response: Currently, the County has a review process in place, but it was not being documented properly. Going forward, the County will implement a review process that will include a signature of the reviewer.

Categories

Subrecipient Monitoring Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 31345 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $6.52M
20.509 Formula Grants for Rural Areas and Tribal Transit Program $977,410
16.838 Comprehensive Opioid Abuse Site-Based Program $429,754
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $367,592
93.332 Cooperative Agreement to Support Navigators in Federally-Facilitated and State Partnership Marketplaces $218,829
16.828 Innovative Responses to Behavior in the Community: Swift, Certain, and Fair Supervision Program $168,581
10.557 Special Supplemental Nutrition Program for Women, Infants, and Children $167,569
20.205 Highway Planning and Construction $112,444
93.917 Hiv Care Formula Grants $107,481
90.404 2018 Hava Election Security Grants $105,175
21.019 Coronavirus Relief Fund $85,080
93.268 Immunization Cooperative Agreements $80,984
93.387 National and State Tobacco Control Program (b) $71,000
93.217 Family Planning_services $68,562
93.667 Social Services Block Grant $55,086
20.600 State and Community Highway Safety $47,605
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $39,817
93.069 Public Health Emergency Preparedness $28,133
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $10,833
97.042 Emergency Management Performance Grants $9,256
66.605 Performance Partnership Grants $1,338