Finding 513083 (2023-002)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-12-05
Audit: 331014
Organization: Allen County (IN)

AI Summary

  • Core Issue: The County Department of Health failed to establish effective internal controls for managing federal COVID-19 funds, leading to a material weakness in compliance.
  • Impacted Requirements: Compliance with 2 CFR 200.303, which mandates effective internal controls to ensure accurate reporting and management of federal awards.
  • Recommended Follow-Up: Management should design and implement a robust internal control system, including clear policies and procedures for segregation of duties and oversight to ensure accurate reporting.

Finding Text

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): PO 20011717 Pass-Through Entity: Indiana State Department of Health Compliance Requirement: Reporting Audit Finding: Material Weakness Condition and Context The County Department of Health, a department within the County, was awarded the Health Issues and Challenges grant through the Indiana State Department of Health financed through the American Rescue Plan Act (ARPA) for the purposes of funding programs that focus on the improvement of chronic disease, specifically, elevated blood lead level reduction. As part of sound management of the federal award, the County Department of Health was responsible for implementing a system of internal controls that would ensure compliance with the applicable requirements. The County Department of Health did not properly design or implement such a system. The County Department of Health was required to submit data through the online portal, National Electronic Disease Surveillance System (NEDSS) Base System (NBS), monthly beginning in October 2022. The submitted data included program specific metrics relating to patient case management of certified Elevated Blood Lead Levels (EBLLs). The County Department of Health was also required to ensure environmental investigation activities completed, including risk assessments and environmental inspections, were documented in the Indiana I-LEAD database monthly by a licensed Lead Risk Assessor. Environmental investigation activities performed by the County Department of Health were documented in the Indiana I-LEAD database by a licensed Lead Risk Assessor who was an employee of the County Department of Health. Similarly, case management activities performed were documented in the NEDSS Base System (NBS). Once activities were documented in the Indiana I-LEAD database and NBS systems, the activities were further documented in a spreadsheet by the Lead Risk Assessor (for I-LEAD activities) and the Case Management Coordinator (for NBS activities). The spreadsheet was reviewed by the Director of the Environmental Services Division and the Finance Director monthly. The Finance Director then used the spreadsheet to prepare the monthly reimbursement requests and sent the monthly reimbursement requests to the Indiana State Department of Health. We determined through inquiry with the Director of the Environmental Services Division and the Finance Director that while there was a review of the monthly spreadsheet, there was not a second review of the spreadsheet back to the activities reported in the Indiana I-LEAD database and NBS for accuracy. Additionally, the Finance Director prepared and submitted the reimbursement requests to the State without a second review or oversight process in place to prevent, or detect and correct, errors prior to 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). . . ." Cause A proper system of internal controls, which would include segregation of key functions, was not designed by management of the County Department of Health to ensure the state was provided with complete and accurate information related to the COVID-19 - Coronavirus State and Local Fiscal Recovery Funds award. Embedded within a properly designed and implemented internal control system should be internal controls consisting of policies and procedures. Policies reflect management's statements of what should be done to effect internal controls, and procedures should consist of actions that would implement these policies. Effect Without the proper design or implementation of the components of a system of internal controls, including policies and procedures that provide segregation of duties and additional oversight as needed, the internal control system cannot be capable of effectively preventing, or detecting and correcting, material noncompliance. Questioned Costs There were no questioned costs identified. Recommendation We recommended that management of the County Department of Health design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place to ensure reports are complete and accurate. Views of Responsible Officials For the views of responsible officials, refer to the Corrective Action Plan that is part of this report.

Corrective Action Plan

FINDING 2023-002 Finding Subject: Coronavirus State and Local Fiscal Recovery Funds - Reporting Federal Agency: Department of the Treasury Summary of Finding: (copied from SBOA Findings document provided) The Allen County Department of Health (Department of Health), a department within Allen County, was awarded the Health Issues and Challenges grant through the Indiana Department of Health financed through the American Rescue Plan Act (ARPA) for the purposes of funding programs that focus on the improvement of chronic disease, specifically, elevated blood lead level reduction. As part of sound management of the Federal award, the Department of Health was responsible for implementing a system of internal control that would ensure compliance with the applicable requirements. The Department of Health did not properly design or implement such a system. The Department of Health was required to submit data through the online portal, National Electronic Disease Surveillance System (NEDSS) Base System (NBS), monthly beginning in October 2022. The submitted data included program specific metrics relating to patient case management of certified Elevated Blood Lead Levels (EBLLs). The Department of Health was also required to ensure environmental investigation activities completed, including risk assessments and environmental inspections, were documented in the Indiana I-LEAD database monthly by a licensed Lead Risk Assessor. Environmental investigation activities performed by the Department of Health were documented in the Indiana I-LEAD database by a licensed Lead Risk Assessor who was an employee of the Department of Health. Similarly, case management activities performed were documented in the NEDSS Base System (NBS). Once activities were documented in the I-LEAD and NBS systems, the activities were further documented in a spreadsheet by the Lead Risk Assessor (for I-LEAD activities) and the Case Management Coordinator (for NBS activities). The spreadsheet was reviewed by the Director of the Environmental Services Division and the Finance Director monthly. The Finance Director then used the spreadsheet to prepare the monthly reimbursement requests and sent the monthly reimbursement requests to the Indiana Department of Health. We determined through inquiry with the Director of the Environmental Services Division and the Finance Director that while there was a review of the monthly spreadsheet, there was not a second review of the spreadsheet back to the activities reported in I-LEAD and NBS for accuracy. Additionally, the Finance Director prepared and submitted the reimbursement requests to the State without a second review or oversight process in place to prevent, or detect and correct, errors prior to submission. The lack of internal controls was a systemic issue throughout the audit period. Recommendation We recommend that management of the Health Department design and implement a proper system of internal controls, including policies and procedures that would provide segregation of duties to ensure appropriate reviews, approvals, and oversight are taking place to ensure reports are complete and accurate. ………………………… Contact Person Responsible for Corrective Action: JENNIFER MILLER (Finance Director) Contact Phone Number and Email Address: 260-449-7358 (Jennifer.miller@allencounty.us) Views of Responsible Officials: We concur with the finding Explanation and Reasons for Disagreement: N/A Description of Corrective Action Plan: We were unaware of a requirement for a secondary review of each document/spreadsheet/database input/task that was conducted prior to submission to the Finance Director (defining the completed cases for which to invoice the State), and a requirement for a secondary review of the invoice/billing documents prior to submission to the State. We were informed that the State review process (as was described to SBOA staff) was the check and balance needed which ensured we had appropriately entered the data into the required database(s) and that we had then subsequently billed for those very same appropriately completed and entered cases. However, when we were informed of the outcomes of the SBOA audit and the subsequent need for a corrective action plan (CAP) relative to their findings, we moved quickly to begin the development of the CAP -- as we do now understand that despite the inaccurate instructions we were given, we did not appropriately do what the law requires locally relative to ensuring accurate completion of duties under grant contracts before submission for reimbursement. THE PLAN (which will be added as a new “Grants” section in our existing Finance Internal Controls policies): For all grants (reimbursable or deliverables-based), once a contract is near completion or upon execution, a primary and secondary staff member will be identified for each step of the database entry (as an example, and this will follow whatever the duties are defined by the grant and a primary responsible staff member will be defined per grant duty needs) as well as for the invoicing/billing documentation process. The primary staff member(s) will be responsible for doing what is defined in the grant contract (a duty, task, data entry, invoice creation, etc.) and the secondary staff member will be responsible for verifying the work of the primary staff member(s). (In some cases, when there are diverse duties and more than one primary staff member is needed to do the duties of the grant, there may be several primary staff members assigned to various duties as needed) If disparities are encountered (such as errors or omissions) in any step related to the above duties, they will first be reported the primary staff member for likely easy correction or resolution. If a pattern exists or repetitive errors are identified through the review and verification process, the secondary reviewer will report the issue(s) to the Department Administrator to make a determination as to whether the primary staff member’s duties are transferred to another staff member, or if the person is simply re-educated. The goal will be to ensure there is an appropriate check and balance step (as well as remediation/correction step if warranted) in place for all tasks and documentation completion as it relates to grant-funded duties and invoicing. Anticipated Completion Date: We will follow this practice for any new grants accepted by the Allen County Department of Health effective 9/17/2024.

Categories

Internal Control / Segregation of Duties Subrecipient Monitoring Cash Management Material Weakness Reporting Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 513082 2023-001
    Material Weakness
  • 513084 2023-003
    Material Weakness
  • 513085 2023-004
    Material Weakness
  • 1089524 2023-001
    Material Weakness
  • 1089525 2023-002
    Material Weakness
  • 1089526 2023-003
    Material Weakness
  • 1089527 2023-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.563 Child Support Services $2.69M
20.205 Highway Planning and Construction $2.41M
16.575 Crime Victim Assistance $338,719
93.268 Immunization Cooperative Agreements $169,873
15.916 Outdoor Recreation Acquisition, Development and Planning $149,588
21.027 Coronavirus State and Local Fiscal Recovery Funds $130,479
16.540 Juvenile Justice and Delinquency Prevention $122,489
10.555 National School Lunch Program $102,868
97.042 Emergency Management Performance Grants $89,828
16.588 Violence Against Women Formula Grants $77,453
93.539 Pphf Capacity Building Assistance to Strengthen Public Health Immunization Infrastructure and Performance $69,221
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $57,330
93.940 Hiv Prevention Activities Health Department Based $55,801
10.553 School Breakfast Program $48,188
93.658 Foster Care Title IV-E $41,812
16.606 State Criminal Alien Assistance Program $39,547
93.566 Refugee and Entrant Assistance State/replacement Designee Administered Programs $39,227
93.586 State Court Improvement Program $20,976
20.616 National Priority Safety Programs $20,645
20.600 State and Community Highway Safety $18,981
16.738 Edward Byrne Memorial Justice Assistance Grant Program $18,786
16.922 Equitable Sharing Program $8,152
97.047 Bric: Building Resilient Infrastructure and Communities $1,457
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $1,000
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $799