Finding 566032 (2023-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2025-06-24

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards for 2023 missed $1,224,086 in federal expenditures.
  • Impacted Requirements: Compliance with Uniform Guidance was not met due to incomplete reporting of federal awards.
  • Recommended Follow-Up: Improve internal controls for tracking and identifying federal grants to ensure accurate reporting in future schedules.

Finding Text

Criteria: Under Uniform Guidance, auditees are required to submit a Schedule of Expenditures of Federal Awards that include all federal monies expended during the fiscal year. Condition: The Schedule of Expenditures of Federal Awards for 2023 did not include $1,224,086 of federal award expenditures. Context: After the issuance of the combined financial statements and related schedule of expenditures of federal awards for the year ended December 31, 2023, management discovered that certain expenditures were omitted from the Schedule of Expenditures of Federal Awards. Cause: The Companies’ internal control over review of the Schedule failed to detect the omitted awards. Effect: Reporting of expenditures over federal awards was not complete. Recommendation: The Companies should enhance their internal controls over intake and tracking of grants, including identification as federal awards, to produce a complete and accurate Schedule of Expenditures of Federal Awards. Views of Responsible Official: See management’s Corrective Action Plan on page 35.

Corrective Action Plan

Re: The Horizon Corporations Report on Internal Control over Compliance for Federal Programs Dopkins & Company, LLP completed an updated report on internal control over financial reporting and on compliance and other matters based on an audit of combined financial statements performed in accordance with Government Auditing Standards for federal programs for the operating period January 1, 2023 to December 31, 2023. Upon completion of the audit procedures, one finding was identified. The following is a response to this finding: Finding: The Companies' internal control over review of the Schedule of Expenditures of Federal Awards failed to detect $1,224,086 of federal award expenditures. The Companies should enhance their internal controls over intake and tracking of grants, including identification of federal awards, to produce a complete and accurate Schedule of Expenditures of Federal Awards. Horizon Response: In response to the finding, Horizon updated our procedures regarding completion of the Schedule of Expenditures of Federal Awards to the following: begin with the prior year audited schedule, update continuing awards with current year expenditures, remove concluded awards, and add new program expenditures. New programs will be identified via an internal tracking spreadsheet of all awards that will be updated monthly throughout the year by the Finance Manager and reviewed by the VP of Finance. This tracking spreadsheet will include funding source and, where applicable, CFDA/ ALN designations. At year end, this tracking spreadsheet will be reconciled to the SEFA.

Categories

Reporting

Other Findings in this Audit

  • 566033 2023-001
    Material Weakness
  • 1142474 2023-001
    Material Weakness
  • 1142475 2023-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $992,328
93.959 Block Grants for Prevention and Treatment of Substance Abuse $612,043
93.696 Certified Community Behavioral Health Clinic Expansion Grants $151,095
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $101,206
16.745 Criminal and Juvenile Justice and Mental Health Collaboration Program $71,894
93.498 Provider Relief Fund $64,163
93.958 Block Grant for Community Mental Health Services $55,754