Audit 39083

FY End
2022-12-31
Total Expended
$5.09M
Findings
2
Programs
33
Organization: Clark County (IN)
Year: 2022 Accepted: 2023-09-27
Auditor: Crowe LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
44176 2022-004 Significant Deficiency - L
620618 2022-004 Significant Deficiency - L

Programs

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

Contacts

Name Title Type
MLR1BL88QZ55 Danny Yost Auditee
8122856211 Scott Nickerson Auditor
No contacts on file

Notes to SEFA

Accounting Policies: NOTE 1 - BASIS OF PRESENTATIONThe accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal awardactivity of Clark County (the County) under programs of the federal government for the year endedDecember 31, 2022. The information in this Schedule is presented in accordance with the requirements ofTitle 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 aselected portion of the operations of the County, it is not intended to and does not present the financialposition basis of the County.Expenditures reported on the Schedule are reported on the cash basis of accounting. Such expendituresare recognized following, as applicable, either Cost Principles for State and Local Governments or the costprinciples contained in the Uniform Guidance, wherein certain types of expenditures are not allowable orare limited as to reimbursement. When federal grants are received on a reimbursement basis, the federalawards are considered expended when the reimbursement is received. De Minimis Rate Used: N Rate Explanation: NOTE 2 - INDIRECT COST RATEThe County has elected not to use the 10-percent de minimis indirect cost rate as allowed under the UniformGuidance.

Finding Details

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.
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.