Audit 363792

FY End
2023-12-31
Total Expended
$15.65M
Findings
2
Programs
24
Organization: Elkhart County (IN)
Year: 2023 Accepted: 2025-08-06

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
572964 2023-002 Significant Deficiency Yes L
1149406 2023-002 Significant Deficiency Yes L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $8.56M Yes 0
93.563 Child Support Services $2.24M - 0
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $1.29M Yes 0
20.205 Highway Planning and Construction $1.19M - 0
93.104 Comprehensive Community Mental Health Services for Children with Serious Emotional Disturbances (sed) $908,689 Yes 0
93.268 Immunization Cooperative Agreements $274,397 - 0
15.916 Outdoor Recreation Acquisition, Development and Planning $250,000 - 0
16.922 Equitable Sharing Program $200,733 - 0
16.575 Crime Victim Assistance $166,968 - 0
97.042 Emergency Management Performance Grants $95,000 - 0
16.738 Edward Byrne Memorial Justice Assistance Grant Program $75,159 - 0
97.067 Homeland Security Grant Program $60,000 - 0
93.788 Opioid Str $46,588 - 0
20.703 Interagency Hazardous Materials Public Sector Training and Planning Grants $40,550 - 0
93.959 Block Grants for Prevention and Treatment of Substance Abuse $32,401 - 0
20.600 State and Community Highway Safety $27,067 - 0
16.588 Violence Against Women Formula Grants $23,134 - 0
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $21,934 - 0
10.555 National School Lunch Program $21,219 - 0
93.391 Activities to Support State, Tribal, Local and Territorial (stlt) Health Department Response to Public Health Or Healthcare Crises $20,253 - 0
93.658 Foster Care Title IV-E $17,689 - 0
93.069 Public Health Emergency Preparedness $14,529 - 0
10.553 School Breakfast Program $12,482 - 0
20.616 National Priority Safety Programs $48 - 0

Contacts

Name Title Type
LTC8CT3KF1Z3 Patricia Pickens Auditee
5745356719 Beth Kelley, Cpa, Cfe Auditor
No contacts on file

Notes to SEFA

Accounting Policies: Note 1. Summary of Significant Accounting Policies A. Basis of Presentation The accompanying Schedule of Expenditures of Federal Awards (SEFA) includes the federal grant activity of the County under programs of the federal government for the year ended December 31, 2023. The information in the SEFA 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 SEFA presents only a select portion of the operations of the County, it is not intended to and does not present the financial position of the County. B. Other Significant Accounting Policies Expenditures reported on the SEFA are reported on the cash basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowed 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: Note 2. Indirect Cost Rate The County has elected not to use the 10 percent de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): 400ARPHLTHISSCH Pass-Through Entity: Indiana Department of Health Compliance Requirement: Reporting Audit Findings: Significant Deficiency, Other Matters Repeat Finding This is a similar finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context The County Health Department (Health Department) was awarded the Health Issues and Challenges Grant through the Indiana Department of Health (IDOH), financed through the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds. The grant was funded through the American Rescue Plan Act that focused on the improvement of chronic disease and, more specifically, elevated blood lead level reduction. INDIANA STATE BOARD OF ACCOUNTS 17 ELKHART COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Reimbursement Submissions The Health Department was required to submit data through the online portal, the National Electronic Disease Surveillance System (NEDSS) Base System (NBS), each month. The submitted data included program specific metrics related to patient case management of certified Elevated Blood Lead Levels (EBLLs). A Case Manager managed all aspects of an individual patient's care. A home visit and two assessments were completed by the Case Manager and input into the NBS. Once these steps were marked as complete in the NBS, the Clinical Manager reviewed each case and compiled data along with the cost reimbursement amount into a spreadsheet. The Clinical Manager provided the spreadsheet to the Manager of Administration who then completed and submitted the reimbursement invoice to the IDOH. The reimbursement invoice was submitted without a documented oversight, review, or approval process to ensure the accuracy of the data prior to submission. Data and Health Equity Report Beginning in October 2022, the Health Department was required to submit program specific metrics and work plan data through the RedCap software on a quarterly basis. The Case Manager was responsible for tracking and compiling the necessary information for the quarterly reports. Of the four reports tested, two reports were submitted late. In addition, the quarterly reports were submitted by the Case Manager via the RedCap software without a documented oversight, review, or approval process to ensure timely submission. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.329(c)(1) states in part: "The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period . . ." INDIANA STATE BOARD OF ACCOUNTS 18 ELKHART COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The issues with the reimbursement submissions and Data and Health Equity reporting processes stem from the lack of a formal oversight and review procedure to ensure accuracy and timeliness. Without a structured verification process before submission, potential errors and inconsistencies could go undetected, thus increasing the likelihood of inaccurate data reporting. Additionally, the reliance on individual staff members to compile and submit reports without secondary review created inefficiencies and contributed to delays, as evidenced by the late submission of two quarterly reports. Effect The lack of oversight and review of the reimbursement submissions and Data and Health Equity reporting process could result in increased risk of inaccurate data being reported to the IDOH, which could compromise the integrity of the program's performance metrics. The absence of a structed verification process can also lead to inefficiencies, as error or inconsistencies may have required corrections after submission, resulting in inefficient use of time and resources. Additionally, the late submission of two quarterly reports indicated a failure to meet reporting deadlines, which could negatively impact compliance with grant requirements and potentially jeopardize future funding opportunities. Questioned Costs There were no questioned costs identified. Recommendation We recommended the Health Department implement a formal oversight and review process for all data submissions to ensure accuracy and completeness before they are submitted to the IDOH. This would involve a secondary review by a designated individual or team to verify the data. Additionally, improving workflow coordination through clearly defined roles and responsibilities for each team member would help streamline the process and prevent delays. To further improve timeliness, the Health Department should implement a tracking and reminder system for report due dates and reimbursement deadlines to ensure timely submissions. Providing staff with thorough training on reporting protocols and maintaining detailed documentation will help ensure consistent adherence to procedures. Finally, establishing accountability measures through clear roles, deadlines, and regular audits would enhance the efficiency and effectiveness of the reporting process. These steps will help ensure the Health Department meets grant requirements, maintains data accuracy, and avoids potential delays or issues in future submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.
FINDING 2023-002 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Federal Program: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Assistance Listings Number: 21.027 Federal Award Number and Year (or Other Identifying Number): 400ARPHLTHISSCH Pass-Through Entity: Indiana Department of Health Compliance Requirement: Reporting Audit Findings: Significant Deficiency, Other Matters Repeat Finding This is a similar finding from the immediately prior audit report. The prior audit finding number was 2022-004. Condition and Context The County Health Department (Health Department) was awarded the Health Issues and Challenges Grant through the Indiana Department of Health (IDOH), financed through the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds. The grant was funded through the American Rescue Plan Act that focused on the improvement of chronic disease and, more specifically, elevated blood lead level reduction. INDIANA STATE BOARD OF ACCOUNTS 17 ELKHART COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Monthly Reimbursement Submissions The Health Department was required to submit data through the online portal, the National Electronic Disease Surveillance System (NEDSS) Base System (NBS), each month. The submitted data included program specific metrics related to patient case management of certified Elevated Blood Lead Levels (EBLLs). A Case Manager managed all aspects of an individual patient's care. A home visit and two assessments were completed by the Case Manager and input into the NBS. Once these steps were marked as complete in the NBS, the Clinical Manager reviewed each case and compiled data along with the cost reimbursement amount into a spreadsheet. The Clinical Manager provided the spreadsheet to the Manager of Administration who then completed and submitted the reimbursement invoice to the IDOH. The reimbursement invoice was submitted without a documented oversight, review, or approval process to ensure the accuracy of the data prior to submission. Data and Health Equity Report Beginning in October 2022, the Health Department was required to submit program specific metrics and work plan data through the RedCap software on a quarterly basis. The Case Manager was responsible for tracking and compiling the necessary information for the quarterly reports. Of the four reports tested, two reports were submitted late. In addition, the quarterly reports were submitted by the Case Manager via the RedCap software without a documented oversight, review, or approval process to ensure timely submission. The lack of internal controls was a systemic issue throughout the audit period. Criteria 2 CFR 200.303 states in part: "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). . . ." 2 CFR 200.329(c)(1) states in part: "The non-Federal entity must submit performance reports at the interval required by the Federal awarding agency or pass-through entity to best inform improvements in program outcomes and productivity. Intervals must be no less frequent than annually nor more frequent than quarterly except in unusual circumstances, for example where more frequent reporting is necessary for the effective monitoring of the Federal award or could significantly affect program outcomes. Reports submitted annually by the non-Federal entity and/or pass-through entity must be due no later than 90 calendar days after the reporting period. Reports submitted quarterly or semiannually must be due no later than 30 calendar days after the reporting period . . ." INDIANA STATE BOARD OF ACCOUNTS 18 ELKHART COUNTY SCHEDULE OF FINDINGS AND QUESTIONED COSTS (Continued) Cause The issues with the reimbursement submissions and Data and Health Equity reporting processes stem from the lack of a formal oversight and review procedure to ensure accuracy and timeliness. Without a structured verification process before submission, potential errors and inconsistencies could go undetected, thus increasing the likelihood of inaccurate data reporting. Additionally, the reliance on individual staff members to compile and submit reports without secondary review created inefficiencies and contributed to delays, as evidenced by the late submission of two quarterly reports. Effect The lack of oversight and review of the reimbursement submissions and Data and Health Equity reporting process could result in increased risk of inaccurate data being reported to the IDOH, which could compromise the integrity of the program's performance metrics. The absence of a structed verification process can also lead to inefficiencies, as error or inconsistencies may have required corrections after submission, resulting in inefficient use of time and resources. Additionally, the late submission of two quarterly reports indicated a failure to meet reporting deadlines, which could negatively impact compliance with grant requirements and potentially jeopardize future funding opportunities. Questioned Costs There were no questioned costs identified. Recommendation We recommended the Health Department implement a formal oversight and review process for all data submissions to ensure accuracy and completeness before they are submitted to the IDOH. This would involve a secondary review by a designated individual or team to verify the data. Additionally, improving workflow coordination through clearly defined roles and responsibilities for each team member would help streamline the process and prevent delays. To further improve timeliness, the Health Department should implement a tracking and reminder system for report due dates and reimbursement deadlines to ensure timely submissions. Providing staff with thorough training on reporting protocols and maintaining detailed documentation will help ensure consistent adherence to procedures. Finally, establishing accountability measures through clear roles, deadlines, and regular audits would enhance the efficiency and effectiveness of the reporting process. These steps will help ensure the Health Department meets grant requirements, maintains data accuracy, and avoids potential delays or issues in future submissions. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.