Finding 5586 (2022-003)

Significant Deficiency Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-12-19
Audit: 7441
Organization: Rainbow Health (MN)

AI Summary

  • Core Issue: Rainbow Health Minnesota missed deadlines for submitting its single audit reporting package to the Federal Audit Clearinghouse.
  • Impacted Requirements: Non-compliance with 2 CFR 200.328 and 2 CFR 200.512(a) regarding timely financial reporting.
  • Recommended Follow-Up: Enhance internal controls and procedures to ensure timely readiness of financial data for audits.

Finding Text

Condition: Rainbow Health Minnesota did not submit its single audit reporting package to the Federal Audit Clearinghouse within the required time frame. Criteria: 2 CFR 200.328 establishes requirements for financial grant reporting by a non-federal entity. The Organization must report financial information as required by the terms and conditions of the federal award. 2 CFR 200.512(a) requires the audit reporting package and data collection form to be submitted to the Federal Audit Clearinghouse the earlier of 30 days after the reports are received from the auditors or nine months after the end of the audit period. Cause: Employee turnover in the finance department resulted in financial and program data not being ready for the financial and single audits on a timely basis. Effect: The Organization is not in compliance with timely reporting requirements. Questioned Costs: $0 Context: Rainbow Health Minnesota did not submit its year ended December 31, 2020 audit reporting package to the Federal Audit Clearinghouse until November 4, 2021, its year ended December 31, 2021 audit reporting package until February 10, 2023 and did not meet the nine month reporting requirement for the year ended December 31, 2022. Recommendation: We recommend Rainbow Health Minnesota continue efforts to develop internal control policies and procedures over financial activities to ensure that its financial and program data is ready for the financial and single audits on a timely basis. Views of Responsible Officials and Planned Corrective Actions: We agree with this finding and have implemented the following internal control policies and procedures concerning the timeliness of financial activities: Rainbow Health Minnesota is reimplementing monthly board meetings that will include a financial review of income and expense reports and balance sheets. The lateness for the 2022 audit was partially due to staff turnover of the CFO and the subsequent review by the new Finance Director. Responsibility for administering this process resides with the Finance Director.

Categories

Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 5582 2022-003
    Significant Deficiency Repeat
  • 5583 2022-003
    Significant Deficiency Repeat
  • 5584 2022-003
    Significant Deficiency Repeat
  • 5585 2022-003
    Significant Deficiency Repeat
  • 5587 2022-003
    Significant Deficiency Repeat
  • 5588 2022-003
    Significant Deficiency Repeat
  • 5589 2022-003
    Significant Deficiency Repeat
  • 5590 2022-003
    Significant Deficiency Repeat
  • 5591 2022-003
    Significant Deficiency Repeat
  • 5592 2022-003
    Significant Deficiency Repeat
  • 5593 2022-003
    Significant Deficiency Repeat
  • 5594 2022-004
    Significant Deficiency
  • 5595 2022-004
    Significant Deficiency
  • 5596 2022-004
    Significant Deficiency
  • 5597 2022-004
    Significant Deficiency
  • 5598 2022-004
    Significant Deficiency
  • 5599 2022-004
    Significant Deficiency
  • 5600 2022-004
    Significant Deficiency
  • 5601 2022-004
    Significant Deficiency
  • 5602 2022-004
    Significant Deficiency
  • 5603 2022-004
    Significant Deficiency
  • 5604 2022-004
    Significant Deficiency
  • 5605 2022-004
    Significant Deficiency
  • 582024 2022-003
    Significant Deficiency Repeat
  • 582025 2022-003
    Significant Deficiency Repeat
  • 582026 2022-003
    Significant Deficiency Repeat
  • 582027 2022-003
    Significant Deficiency Repeat
  • 582028 2022-003
    Significant Deficiency Repeat
  • 582029 2022-003
    Significant Deficiency Repeat
  • 582030 2022-003
    Significant Deficiency Repeat
  • 582031 2022-003
    Significant Deficiency Repeat
  • 582032 2022-003
    Significant Deficiency Repeat
  • 582033 2022-003
    Significant Deficiency Repeat
  • 582034 2022-003
    Significant Deficiency Repeat
  • 582035 2022-003
    Significant Deficiency Repeat
  • 582036 2022-004
    Significant Deficiency
  • 582037 2022-004
    Significant Deficiency
  • 582038 2022-004
    Significant Deficiency
  • 582039 2022-004
    Significant Deficiency
  • 582040 2022-004
    Significant Deficiency
  • 582041 2022-004
    Significant Deficiency
  • 582042 2022-004
    Significant Deficiency
  • 582043 2022-004
    Significant Deficiency
  • 582044 2022-004
    Significant Deficiency
  • 582045 2022-004
    Significant Deficiency
  • 582046 2022-004
    Significant Deficiency
  • 582047 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.917 Hiv Care Formula Grants $892,428
14.241 Housing Opportunities for Persons with Aids $789,247
93.914 Hiv Emergency Relief Project Grants $547,496
93.940 Hiv Prevention Activities_health Department Based $115,187
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $70,973
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $39,855
93.268 Immunization Cooperative Agreements $38,882
93.959 Block Grants for Prevention and Treatment of Substance Abuse $26,791
93.136 Injury Prevention and Control Research and State and Community Based Programs $19,250
93.958 Block Grants for Community Mental Health Services $13,269