Finding 5594 (2022-004)

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

AI Summary

  • Core Issue: Rainbow Health Minnesota struggles to accurately report total federal expenditures on the SEFA due to inadequate internal controls.
  • Impacted Requirements: This affects compliance with 2 CFR 200.510(b), risking incomplete reporting of federal awards.
  • Recommended Follow-Up: Enhance procedures for identifying federal funds and improve communication with pass-through funders to ensure all federal expenditures are captured.

Finding Text

Criteria: Per 2 CFR 200.510(b) Schedule of expenditures of Federal awards, “the auditee must prepare a schedule of expenditures of Federal awards for the period covered by the auditee's financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR 200.502, Basis for determining Federal awards expended. Condition: Due to the nature of Rainbow Health Minnesota’s federal funding, management has been unable to accurately identify total federal expenditures for reporting on the SEFA. Cause: Internal controls are not in place to identify all contract and grant agreements that are federally funded. Additionally, Rainbow Health Minnesota does not always receive notification from its pass-through funders that specifies the federally funded portion of each payment received. Effect: By not having proper controls over SEFA preparation, there is a risk that the SEFA will not reflect all the federal awards subject to the Uniform Guidance. Questioned Costs: $0 Identification of Repeat Finding: Not a repeat finding. Recommendation: We recommend that Rainbow Health Minnesota review procedures to ensure timely identification of federal funds, including increasing communication with pass-through funders to identify all expenditures that are federal in nature. Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and identifies federal funding based on contract language. The contracts do not include a percentage of funding that is not federal. To ensure proper spending of federal funds, Rainbow Health Minnesota treats all funds as federal funds.

Corrective Action Plan

Views of Responsible Officials and Corrective Action Plan: Management agrees with this finding and identifies federal funding based on contract language. The contracts do not include a percentage of funding that is not federal. To ensure proper spending of federal funds, Rainbow Health Minnesota treats all funds as federal funds.

Categories

Reporting

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
  • 5586 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
  • 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