Finding 5598 (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.

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
  • 5594 2022-004
    Significant Deficiency
  • 5595 2022-004
    Significant Deficiency
  • 5596 2022-004
    Significant Deficiency
  • 5597 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