Finding 596682 (2022-001)

-
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-14
Audit: 20921
Organization: Fox Run Village, Inc. (MI)

AI Summary

  • Core Issue: Discrepancies were found in the lost revenue calculations for the Provider Relief Fund due to formula errors in management's internal workpapers.
  • Impacted Requirements: Reporting did not align with the approved budget amounts, affecting the accuracy of the lost revenue reported to HRSA.
  • Recommended Follow-Up: Conduct a thorough review of all calculations and formulas in future reporting to ensure accuracy and compliance with the established guidelines.

Finding Text

Finding 2022-001: COVID-19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Reporting Cluster: Not applicable Federal Agency: Department of Health and Human Services (?HHS?) Award Name: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Assistance Listing #: 93.498 Assistance Listing Title: COVID-19 - Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution ? Period 4 Award Year(s): January 1, 2020 ? December 31, 2022 Criteria Step Six of the Steps on Reporting on Use of Funds section of the June 11, 2021 Provider Relief Fund (?PRF?) General and Targeted Distribution Post-Payment Notice of Reporting Requirements requires recipients that apply PRF payments toward lost revenues to use one of the following three options for calculating lost revenues: ? Option (i): difference between actual patient care revenues and actuals for each quarter during the period of availability; ? Option (ii): difference between budgeted (budget approved prior to March 27, 2020) and actual patient care revenues for each quarter during the period of availability; or ? Option (iii): any reasonable method of estimating revenues Condition Through our prior year testing of FRV?s Periods 1 and 2 HRSA reporting portal submission, we identified discrepancies between the budgeted patient care revenue amounts input into the portal and the amounts approved by the Community?s Board of Directors on February 26, 2020, as part of the entity?s 5-year plan, which support FRV?s lost revenue calculation. Management went to correct the prior year lost revenue calculation and did not correctly update some formulas that were still pulling data from prior year inaccurate workpapers. Cause In reporting period 4, to correct the prior year error, management updated the lost revenue calculation that was reported via the HSRA portal for periods 1 and 2 to utilize the appropriate approved budget amounts. However, in management?s corrected calculation a portion of the revised lost revenue calculation was still pulling from the incorrect budgeted amounts due to a formula error within Management?s internal workpapers which was incorrectly pulling from the prior year budget workpaper. Although Management attempted to correct the lost revenue calculation, review over the updated calculation was not performed at a detailed enough level to have caught the formula issue. Effect Inputs into the lost revenue calculation were not complete and accurate and could have impacted the total lost revenue calculated by FRV. The amounts input incorrectly into the approved budgeted line did not have an impact on lost revenue that FRV could claim in the reporting period as FRV maintained sufficient capacity in amounts that qualified for use. The resulting total impact increased the lost revenue of FRV by $52,000. Questioned Costs There are no questioned costs associated with this finding as the exceptions noted relate to an aspect of reporting which would have increased the potential qualifying funds of FRV.

Categories

Reporting

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
93.498 Covid-19 Provider Relief Fund and American Rescue Plan (arp) Rural Distribution $728,203
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $62,800