Finding 499304 (2023-001)

Material Weakness
Requirement
ABHI
Questioned Costs
$1
Year
2023
Accepted
2024-09-30
Audit: 322145
Organization: Allen County (IN)

AI Summary

  • Core Issue: The County Department of Health failed to establish effective internal controls for managing the Health Issues and Challenges grant, leading to inadequate tracking of expenditures.
  • Impacted Requirements: Compliance with federal regulations regarding allowable activities, costs, and financial management was not met, resulting in questioned costs totaling $130,479.
  • Recommended Follow-Up: Implement a robust internal control system to ensure proper tracking and reporting of federal funds, and conduct training for staff on compliance requirements.

Finding Text

FINDING 2023-001 Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance, and Procurement and Suspension and Debarment 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 Requirements: Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance, Procurement and Suspension and Debarment Audit Findings: Material Weakness, Other Matters 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 for the purpose of funding programs that focus on the improvement of chronic disease, specifically, elevated blood lead level reduction. The Health Issues and Challenges grant is a reimbursable grant, whereby the County received reimbursement on a per-case basis at a stated rate for Case Management and Environmental Investigation activities performed. The County Department of Health received federal receipts related to the grant in the amount of $130,479 during 2023. 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. Receipts of the program were adequately identified through the use of an account number within the County Health Fund (285) in the County's ledger (ledger) which was unique to the Health Issues and Challenges grant receipts. However, the ledger did not adequately identify the expenditures of the grant program within the County Health Fund. Through inquiry with the County Department of Health employees and review of unit-prepared support of grant expenditures, we determined expenditures were made with grant funds during the audit period; however, we were unable to distinguish between the expenditures of the Health Issues and Challenges grant and all other activities of the County Department of Health in the County Health fund. Due to the lack of separate identification of expenditures in the financial records, we were not able to establish a population from which to audit the Health Issues and Challenges grant for compliance with the following compliance requirements of the program:  Activities Allowed or Unallowed  Allowable Costs/Cost Principles  Period of Performance  Procurement and Suspension and Debarment As such, the full award amount of $130,479, as reported on the Schedule of Expenditures of Federal Awards, was determined to be questioned costs. The lack of internal controls and noncompliance were systemic issues 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.300(b) states in part: "The non-Federal entity is responsible for complying with all requirements of the Federal award. . . ." 2 CFR 200.302 states in part: "(a) Each state must expend and account for the Federal award in accordance with state laws and procedures for expending and accounting for the state's own funds. In addition, the state's and the other non-Federal entity's financial management systems, including records documenting compliance with Federal statutes, regulations, and the terms and conditions of the Federal award, must be sufficient to permit the preparation of reports required by general and program-specific terms and conditions; and the tracing of funds to a level of expenditures adequate to establish that such funds have been used according to the Federal statutes, regulations, and the terms and conditions of the Federal award. . . . (b) The financial management system of each non-Federal entity must provide for the following . . . (1) Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Federal program and Federal award identification must include, as applicable, the Assistance Listings title and number, Federal award identification number and year, name of the Federal agency, and name of the pass-through entity, if any. (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 and 200.329. . . . (3) Records that identify adequately the source and application of funds for federallyfunded activities. These records must contain information pertaining to Federal awards, authorizations, financial obligations, unobligated balances, assets, expenditures, income and interest and be supported by source documentation. (4) Effective control over, and accountability for, all funds, property, and other assets. . . ." Cause The County Department of Health was unable to differentiate expenditures made from federal and non-federal funds within its ledger for the Heath Issues and Challenges grant. Effect Without the proper implementation of an effectively designed system of internal controls, a population of expenditures associated with the Health Issues and Challenges grant could not be determined. As such, the County Department of Health cannot ensure nor can we determine that expenditures of the grant were not unallowable, within the proper period, and adhered to established practices and policies. Questioned Costs We identified $130,479 in known questioned costs as noted in the Condition and Context. Recommendation We recommended that management of the County Department of Health establish a system of internal controls to ensure that grant award funds are adequately accounted for and tracked in such a manner as to determine the activity, receipts, and disbursements associated with the grant. 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-001 Finding Subject: COVID-19 - Coronavirus State and Local Fiscal Recovery Funds - Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance, and Procurement and Suspension and Debarment 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 purpose of funding programs that focus on the improvement of chronic disease, specifically, elevated blood lead level reduction. The Health Issues and Challenges grant is a reimbursable grant, whereby the County received reimbursement on a percase basis at a stated rate for Case Management and Environmental Investigation activities performed. The Department of Health received federal receipts related to the grant in the amount of $130,479 during 2023. 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. Receipts of the program were adequately identified through the use of an account number within the County Health Fund (285) in the Allen County's ledger (ledger) which was unique to the Health Issues and Challenges grant receipts. However, the ledger did not adequately identify the expenditures of the grant program within the County Health Fund. Through inquiry with the Department of Health employees and review of unitprepared support of grant expenditures, we determined expenditures were made with grant funds during the audit period, however, we were unable to distinguish between the expenditures of the Health Issues and Challenges grant and all other activities of the Department of Health in the County Health Fund. Due to the lack of separate identification of expenditures in the financial records, we were not able to establish a population from which to audit the Health Issues and Challenges grant for compliance with the following compliance requirements of the program: 􀁸 Activities Allowed or Unallowed 􀁸 Allowable Costs/Cost Principles 􀁸 Period of Performance 􀁸 Procurement and Suspension and Debarment As such, the full award amount of $130,479, as reported on the Schedule of Expenditures of Federal Awards, was determined to be questioned costs. The lack of internal controls and noncompliance were systemic issues throughout the audit period. Recommendation: We recommend that management of the Health Department establish a system of internal controls to ensure that grant award funds are adequately accounted for and tracked in such a manner as to determine the activity, receipts and disbursement, associated with the grant. ………………………… 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: When we were informed of the outcomes of the SBOA audit and the subsequent needs for a corrective action plan (CAP) relative to their findings, we moved quickly to begin the development of the CAP. We feel this finding/issue could be easily remedied by following our normal procedure for grants, whereby we develop a new fund, craft a Fund Ordinance for approval by the Allen County Commissioners to establish said new fund, and then subsequently track all expenditures and reimbursements in the separate fund vs. utilizing a line item for deposits in the main Health Fund as was done with this grant (which lacked the ability to denote exact salary expenditures and such next to each payment as it was all done within the larger fund for all staff and expenses. We were not aware of this need. 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 separate fund will be created through development and approval of a local fund ordinance. All expenditures allowed by said grant and all reimbursements received by the grant funder will be tracked solely and only within the separate grant fund that is tied to the signed contract from the funder. If there are staff payments for salaries or benefits being reimbursed by a grant, we will ensure that: (1) the hours/minutes per staff member per pay period for all work associated with these grant duties are tracked appropriately so as to ensure we are invoicing the grant funder for the exact and accurate work hours (regardless of whether or not the grant contract specifies this be tracked or reimbursed per minute/hour, as most do not require this); and (2) these amounts will be noted alongside the expenditures in the grant fund for clarity upon invoicing or auditing. Anticipated Completion Date: We will follow this practice for any new grants accepted by the Allen County Department of Health effective 9/17/2024. This is the standard practice for most grants we have accepted, and therefore, we will not vary from this practice in the future even if given permission to do so.

Categories

Questioned Costs Procurement, Suspension & Debarment Allowable Costs / Cost Principles Reporting

Other Findings in this Audit

  • 499305 2023-002
    Material Weakness
  • 499306 2023-003
    Material Weakness
  • 499307 2023-004
    Material Weakness
  • 1075746 2023-001
    Material Weakness
  • 1075747 2023-002
    Material Weakness
  • 1075748 2023-003
    Material Weakness
  • 1075749 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