Finding 44176 (2022-004)

Significant Deficiency
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-27
Audit: 39083
Organization: Clark County (IN)
Auditor: Crowe LLP

AI Summary

  • Core Issue: The County lacks a review control for quarterly reporting, risking inaccuracies in financial disclosures.
  • Impacted Requirements: Non-compliance with 2 CFR 200.302(b) and 34 CFR 76.722 due to inadequate internal controls.
  • Recommended Follow-Up: Implement a review process where someone other than the preparer checks reports for accuracy before submission.

Finding Text

FINDING 2022-004 ? CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS - REPORTING Federal Program: COVID-19 Coronavirus State and Local Fiscal Recovery Funds (ALN Number: 21.027) Federal Agency: Department of Treasury Federal Award Number (or Other Identifying Number): N/A Pass-Through Entity: State Budget Agency Audit Finding: Significant Deficiency Criteria: 2 CFR 200.302(b) states in part: "The financial management system of each non-Federal entity must provide for the following: (2) Accurate, current, and complete disclosure of the financial results of each Federal award or program in accordance with the reporting requirements set forth in ?? 200.328 Financial reporting . . . ." 34 CFR 76.722 states: "A State may require a subgrantee to submit reports in a manner and format that assists the State in complying with the requirements under 34 CFR 76.720 and in carrying out other responsibilities under the program." Condition: During testing, we noted the County did not have a review control in place to ensure accuracy and completeness of the quarterly reporting requirements. Questioned Cost: None.Context: There was no documented review by someone other than the preparers of the Project and Expenditure Report to ensure the information submitted was accurate and complete. The reports are prepared and submitted by the County Attorney without secondary review. As a result, one of the quarterly reports selected for testing, out of a sample of two reports, was overstated by $247,770 in one period due to improper inclusion of an expenditure made in a subsequent month. This timing error was corrected on the next quarterly support and similar errors were not identified in subsequent quarters. Final reporting of total expenditures was accurate. Effect: The failure to establish an effective internal control system placed the County at risk of noncompliance with the grant agreement and the compliance requirements. A lack of segregation of duties within an internal control system could have allowed noncompliance with the compliance requirements and allowed the misuse and mismanagement of federal funds and assets by not having proper oversight, reviews, and approvals over the activities of the program. Cause: Management had not developed a system of internal control that would have ensured compliance with the grant agreement and the compliance requirements listed above for the full period under audit. Repeat Finding: No. Recommendation: We recommended that the County's management establish a system of internal control to ensure compliance with the grant agreement and the compliance requirements listed above. We recommend an individual other than the County Attorney perform a documented review of the report prior to submission. Views of Responsible Officials: Management concurs with this finding. See the corrective action plan.

Corrective Action Plan

FINDING 2022-004 Contact Person Responsible for Corrective Action: Danny Yost Contact Phone Number: 812-285-6221 We concur with this finding. The Auditor's Office will work with the County Attorney to add an extra layer of control to ensure the accuracy of the reporting. Anticipated Completion Date: Jan. 2024

Categories

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

Other Findings in this Audit

  • 620618 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $1.94M
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $423,469
93.940 Hiv Prevention Activities_health Department Based $140,698
93.268 Immunization Cooperative Agreements $125,838
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $113,842
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $111,539
97.008 Non-Profit Security Program $101,411
93.136 Injury Prevention and Control Research and State and Community Based Programs $89,000
16.575 Crime Victim Assistance $85,051
93.994 Maternal and Child Health Services Block Grant to the States $74,421
20.205 Highway Planning and Construction $61,265
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $58,086
97.067 Homeland Security Grant Program $48,420
93.917 Hiv Care Formula Grants $47,463
93.563 Child Support Enforcement $43,292
97.042 Emergency Management Performance Grants $39,797
10.555 National School Lunch Program $38,460
16.540 Juvenile Justice and Delinquency Prevention_allocation to States $37,265
16.588 Violence Against Women Formula Grants $35,635
16.738 Edward Byrne Memorial Justice Assistance Grant Program $35,406
93.959 Block Grants for Prevention and Treatment of Substance Abuse $32,245
93.788 Opioid Str $27,126
97.056 Port Security Grant Program $25,582
16.585 Drug Court Discretionary Grant Program $21,568
20.609 Safety Belt Performance Grants $20,156
93.977 Preventive Health Services_sexually Transmitted Diseases Control Grants $19,671
20.602 Occupant Protection Incentive Grants $18,946
97.047 Pre-Disaster Mitigation $18,000
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $15,000
20.616 National Priority Safety Programs $12,173
20.600 State and Community Highway Safety $9,377
93.586 State Court Improvement Program $3,599
16.607 Bulletproof Vest Partnership Program $1,676