Finding 34336 (2022-001)

Material Weakness
Requirement
ABL
Questioned Costs
-
Year
2022
Accepted
2023-01-18
Audit: 36345
Auditor: Eide Bailly LLP

AI Summary

  • Core Issue: The Agency failed to accurately report patient service revenue by not accounting for bad debts, leading to incorrect lost revenue calculations for federal reporting.
  • Impacted Requirements: This finding highlights a material weakness in internal controls over compliance, violating 2 CFR 200.303(a) regarding effective management of federal awards.
  • Recommended Follow-Up: Enhance internal control processes to ensure accurate lost revenue calculations and correct reporting in future submissions.

Finding Text

Finding No. 2022-001 Federal Program: Federal Assistance Listing #93.498 US Department of Health and Human Services Provider Relief Fund Activities Allowed/Allowable Costs Material Weakness in Internal Control Over Compliance Reporting Material Weakness in Internal Control Over Compliance and Material Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Agency selected option I to calculate lost revenue, which consists of a comparison of actual results during the period of availability to the base calendar year of 2019. For all periods reported in the Agency?s Period 2 submission, the reported patient service revenue amounts were not reduced by bad debts, as required by the terms and conditions of the federal award. Cause: The Agency did not have an effective internal control process in place to ensure review and approval of the lost revenue calculation claimed under the federal program and the report submitted for Period 2 was accurate and in accordance with the terms and conditions of the federal award. Effect: The reporting to HHS for Period 2 was considered incorrect. The Agency did not properly report patient service revenue, as gross patient revenue was not reduced by bad debt expense. The impact of the bad debts would have been to increase lost revenue by $48,639. Questioned Costs: None. Had the Agency properly reduced patient service revenue by bad debts for the periods reported, lost revenue would have been $1,665,089 compared to the $1,616,450 reported. Context: Key line items were tested on the Period 2 HHS report. Recommendation: We recommend the Agency enhance its existing internal control processes to ensure the lost revenue calculation claimed meets the requirements of the federal program and to correct the lost revenue calculation in future required reports. Views of Responsible Officials and Planned Corrective Action: Management agrees with the noted finding. However, had the Agency reported the correct lost revenue figures, the Agency satisfactorily incurred eligible expenses and lost revenue in excess of funding expended. Management will continue to refine processes to more diligently review the lost revenue calculation to ensure such amounts are in accordance with the terms and conditions of the federal award.

Corrective Action Plan

Finding No. 2022-001 Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Agency selected option I to calculate lost revenue, which consists of a comparison of actual results during the period of availability to the base calendar year of 2019. For all periods reported in the Agency?s Period 2 submission, the reported patient service revenue amounts were not reduced by bad debts, as required by the terms and conditions of the federal award. Planned Corrective Action: Management will continue to refine processes to more diligently review the lost revenue calculation to ensure such amounts are in accordance with the terms and conditions of the federal award. However, the Agency incurred and reported eligible expenses and lost revenue that had the errors in the lost revenue calculation been identified and corrected prior to reporting, the Agency would have satisfactorily incurred eligible expenses and lost revenue in excess of the PRF funds received, including interest earned on such funds. Planned Completion Date: Ongoing Person Responsible: Nancy Chase, Chief Financial Officer

Categories

Allowable Costs / Cost Principles Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 610778 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.778 Medical Assistance Program $1.55M
93.498 Provider Relief Fund $760,250
93.045 Special Programs for the Aging_title Iii, Part C_nutrition Services $683,028
94.016 Senior Companion Program $262,578
20.509 Formula Grants for Rural Areas and Tribal Transit Program $231,122
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $214,000
94.011 Foster Grandparent Program $213,795
93.052 National Family Caregiver Support, Title Iii, Part E $151,289
93.053 Nutrition Services Incentive Program $131,758
93.667 Social Services Block Grant $21,152
93.043 Special Programs for the Aging_title Iii, Part D_disease Prevention and Health Promotion Services $20,898
93.042 Special Programs for the Aging_title Vii, Chapter 2_long Term Care Ombudsman Services for Older Individuals $17,000
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $13,663