Audit 322568

FY End
2023-12-31
Total Expended
$5.50M
Findings
2
Programs
30
Organization: Clark County (IN)
Year: 2023 Accepted: 2024-09-30
Auditor: Crowe LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
499750 2023-004 Significant Deficiency - M
1076192 2023-004 Significant Deficiency - M

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.23M Yes 1
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $492,765 - 0
97.067 Homeland Security Grant Program $240,712 - 0
93.917 Hiv Care Formula Grants $223,606 - 0
93.268 Immunization Cooperative Agreements $121,717 - 0
93.940 Hiv Prevention Activities Health Department Based $102,770 - 0
16.588 Violence Against Women Formula Grants $92,583 - 0
93.136 Injury Prevention and Control Research and State and Community Based Programs $92,500 - 0
16.585 Treatment Court Discretionary Grant Program $90,499 - 0
93.994 Maternal and Child Health Services Block Grant to the States $74,495 - 0
97.042 Emergency Management Performance Grants $71,232 - 0
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $70,834 - 0
16.575 Crime Victim Assistance $67,399 - 0
93.074 Hospital Preparedness Program (hpp) and Public Health Emergency Preparedness (phep) Aligned Cooperative Agreements $64,000 - 0
93.788 Opioid Str $56,864 - 0
93.563 Child Support Services $49,679 - 0
97.008 Non-Profit Security Program $48,497 - 0
10.555 National School Lunch Program $46,501 - 0
20.609 Safety Belt Performance Grants $31,766 - 0
20.205 Highway Planning and Construction $25,368 - 0
20.602 Occupant Protection Incentive Grants $23,733 - 0
93.586 State Court Improvement Program $23,315 - 0
16.540 Juvenile Justice and Delinquency Prevention $12,531 - 0
20.600 State and Community Highway Safety $10,462 - 0
20.616 National Priority Safety Programs $7,331 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $6,767 - 0
97.056 Port Security Grant Program $6,052 - 0
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $2,000 - 0
16.607 Bulletproof Vest Partnership Program $1,987 - 0
97.047 Bric: Building Resilient Infrastructure and Communities $1,457 - 0

Contacts

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

Notes to SEFA

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

Finding Details

FINDING 2023-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 Subject – Subrecipient Monitoring – Internal Controls Audit Finding: Significant Deficiency Criteria: Federal regulations 2 CFR section 200.332 (b), (d), (f) and (g) requires the County to: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. Condition: An effective internal control system was not in place at the County to ensure compliance with requirements related to the grant agreement and the subrecipient monitoring compliance requirement. Questioned Cost: None. Context: During our subrecipient monitoring testing, we saw no formal, documented review of the 2 subrecipient's audit reports selected for testing. Management asserted they reviewed the reports, but there was no formal documented review of the reports noted. The audit reports sampled for testing contained no findings in the reports that would require the County to follow up on. 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 formally documents their review of the subrecipient audit reports and follow up actions taken on the audit reports as needed. Views of Responsible Officials: Management concurs with this finding. See the corrective action plan.
FINDING 2023-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 Subject – Subrecipient Monitoring – Internal Controls Audit Finding: Significant Deficiency Criteria: Federal regulations 2 CFR section 200.332 (b), (d), (f) and (g) requires the County to: (b) Evaluate each subrecipient's risk of noncompliance with Federal statutes, regulations, and the terms and conditions of the subaward for purposes of determining the appropriate subrecipient monitoring described in paragraphs (d) and (e) of this section, which may include consideration of such factors as: (f) Verify that every subrecipient is audited as required by Subpart F of this part when it is expected that the subrecipient's Federal awards expended during the respective fiscal year equaled or exceeded the threshold set forth in § 200.501. (g) Consider whether the results of the subrecipient's audits, on-site reviews, or other monitoring indicate conditions that necessitate adjustments to the pass-through entity's own records. Condition: An effective internal control system was not in place at the County to ensure compliance with requirements related to the grant agreement and the subrecipient monitoring compliance requirement. Questioned Cost: None. Context: During our subrecipient monitoring testing, we saw no formal, documented review of the 2 subrecipient's audit reports selected for testing. Management asserted they reviewed the reports, but there was no formal documented review of the reports noted. The audit reports sampled for testing contained no findings in the reports that would require the County to follow up on. 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 formally documents their review of the subrecipient audit reports and follow up actions taken on the audit reports as needed. Views of Responsible Officials: Management concurs with this finding. See the corrective action plan.