Audit 304765

FY End
2023-07-31
Total Expended
$13.69M
Findings
10
Programs
2
Year: 2023 Accepted: 2024-04-26
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
394873 2023-003 Material Weakness Yes P
394874 2023-003 Material Weakness Yes P
394875 2023-004 Material Weakness Yes L
394876 2023-005 Material Weakness Yes L
394877 2023-006 Significant Deficiency Yes AB
971315 2023-003 Material Weakness Yes P
971316 2023-003 Material Weakness Yes P
971317 2023-004 Material Weakness Yes L
971318 2023-005 Material Weakness Yes L
971319 2023-006 Significant Deficiency Yes AB

Programs

ALN Program Spent Major Findings
14.128 Mortgage Insurance_hospitals $12.75M Yes 2
93.498 Provider Relief Fund $940,628 Yes 3

Contacts

Name Title Type
SBMQRQ2NBT83 Paul Courtney Auditee
2178543857 Renee Gravalin Auditor
No contacts on file

Notes to SEFA

Title: Section 242 – Mortgage Insurance – Hospitals (Federal Assistance Listing #14.128) Accounting Policies: Basis of Presentation The accompanying consolidated Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of Middle Macoupin Health Care Systems and Affiliates (Organization) under programs of the federal government for the year ended July 31, 2023. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Organization. Significant Accounting Policies Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Organization does not draw for indirect administrative expenses and has not elected to use the 10% de minimis cost rate. The Organization’s mortgage note payable is guaranteed under the Department of Housing and Urban Development’s Section 242 program. The program guarantees 99% of the outstanding mortgage balance. The balance included on the Schedule represents 99% of the loan balance of $12,879,980 as of August 1, 2022, which is $12,879,980. The total loan balance at July 31, 2023 is $12,088,503.
Title: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Accounting Policies: Basis of Presentation The accompanying consolidated Schedule of Expenditures of Federal Awards (Schedule) includes the federal award activity of Middle Macoupin Health Care Systems and Affiliates (Organization) under programs of the federal government for the year ended July 31, 2023. The information is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Organization, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Organization. Significant Accounting Policies Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. No federal financial assistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Organization does not draw for indirect administrative expenses and has not elected to use the 10% de minimis cost rate. The Organization received amounts from the U.S. Department of Health and Human Services (HHS) through the Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution (PRF) program (Federal Financial Assistance Listing #93.498) during the year ended July 31, 2022. The Organization incurred eligible expenses (including lost revenue) and, therefore recognized revenue totaling $939,243 for the year ended July 31, 2022 on the consolidated financial statements. In accordance with the 2023 Compliance Supplement, the PRF expenditures recognized on the Schedule are based on the reporting to HHS for Periods 4 and 5, defined as payments received during July 1, 2021 to June 30, 2022 of $939,243, plus interest earned of $1,385, as required under the PRF program. The amount of PRF expenditures included in the Schedule requires management to make estimates and assumptions that affect the reported amounts. Accordingly, such expenditures are considered a significant estimate. Estimates and assumptions may include reducing actual expenses by amounts that have been reimbursed or are obligated to be reimbursed by other sources and estimating marginal increases in expenses related to coronavirus. Actual amounts could differ from those estimates.

Finding Details

Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance – Hospitals Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Preparation of Schedule of Expenditures of Federal Awards Material Weakness in Internal Control Over Compliance ‐ Other Criteria: Proper controls over financial reporting include the ability to prepare the consolidated Schedule of Expenditures of Federal Awards (Schedule) and accompanying notes to the Schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate schedule of expenditures of federal awards being audited. We were requested to draft the Schedule. Cause: Auditor assistance with preparation of the Schedule is not unusual as the Schedule has unique and specialized requirements and preparation is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft the Schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: Yes, Finding 2022‐003. Recommendation: While we recognize that this condition is not unusual for an organization with limited staffing, we recommend management be aware of the financial reporting requirements relating to the Organization’s Schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance – Hospitals Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Preparation of Schedule of Expenditures of Federal Awards Material Weakness in Internal Control Over Compliance ‐ Other Criteria: Proper controls over financial reporting include the ability to prepare the consolidated Schedule of Expenditures of Federal Awards (Schedule) and accompanying notes to the Schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate schedule of expenditures of federal awards being audited. We were requested to draft the Schedule. Cause: Auditor assistance with preparation of the Schedule is not unusual as the Schedule has unique and specialized requirements and preparation is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft the Schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: Yes, Finding 2022‐003. Recommendation: While we recognize that this condition is not unusual for an organization with limited staffing, we recommend management be aware of the financial reporting requirements relating to the Organization’s Schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance ‐ Hospitals Reporting Material Weakness in Internal Control Over Compliance and Noncompliance Criteria: The OMB Compliance Supplement requires that non‐federal entities receiving federal awards establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program compliance requirements. Condition: The Section 242 – Mortgage Insurance ‐ Hospitals Program requires quarterly reports and certain annual reports. For the year ended July 31, 2023, the Organization failed to file the annual budget prior to the start of the year. Cause: The Organization did not follow their internal control policy to ensure the required report was filed. Effect: The required report was not submitted in accordance with loan requirements. Questioned Costs: None reported. Context: There were a total of eight reports required to be submitted for the year ended July 31, 2023. Three were selected for testing. Of the three selected, one was not submitted as required. Through additional inquiry, there were no other reports identified as not being submitted. Repeat Finding from Prior Years: Yes, Finding 2022‐004. Recommendation: We recommend the Organization enhance internal control policies to ensure required reports are filed timely and accurately. Views of Responsible Officials: Management agrees with the finding.
Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 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 Organization included a lost revenues in the Department of Health and Human Services (HHS) special report for Period 4 that were incorrectly calculated which caused the report to be inaccurate. Cause: The Organization did not have an adequate internal control policy in place to ensure the lost revenue calculation that was reported on the HHS report was complete and accurate. Effect: The lack of adequate policies governing report preparation and submission increases the risk that the report could be filed incorrectly. Questioned Costs: None reported. Had the lost revenue calculation been reported correctly, lost revenue would have decreased by $512,211. However, the Organization did not claim any lost revenue in Period 4, so there would be no funds to return. Context: There was one lost revenue calculation required for the HHS Period 4 special report, and it was selected for testing. Repeat Finding from Prior Years: Yes, Finding 2021‐009. Recommendation: We recommend that the Organization implement procedures to ensure the lost revenue calculation reported on the HHS special report meet the requirements of the federal program. Views of Responsible Officials: Management agrees with the finding.
Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control Over Compliance 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. The Organization claimed expenses based on specifically identified COVID related expenses and general and administrative expenses. Condition: During our testing, there was no documentation of review and approval of the expenditure listing or lost revenue calculation. The Organization also miscalculated the portion of an expense that was reimbursed by another source. Cause: The Organization did not have an adequate internal control policy in place to ensure review and approval of expenditures and lost revenue claimed under the federal programs was documented and that all claimed expenditures were accurately calculated and claimed. Effect: The lack of adequate policies governing review and approval over the expenditure listing and lost revenue calculation increases the risk that employees participating in the federal award administration may not be able to detect and correct noncompliance and miscalculation of reimbursement by other sources in a timely manner. Question Costs: None reported. Context/Sampling: A nonstatistical sample of 65 expenditures were selected for testing, which accounted for $172,298 of $940,628 direct program expenditures. Of these 65, the Medicare reimbursement was miscalculated for one selected item. There was one lost revenue calculation and one expenditure detail and both were tested. Repeat Finding from Prior Year: Yes, Finding 2021‐008. Recommendation: We recommend that the Organization enhance internal control policies to ensure the expenditure listing and lost revenue calculation are reviewed and approved to ensure that all payments are necessary, correct, meet the requirements of the federal program, and are properly recorded in the reports required to be submitted to the federal agency. Views of Responsible Officials: Management agrees with the finding.
Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance – Hospitals Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Preparation of Schedule of Expenditures of Federal Awards Material Weakness in Internal Control Over Compliance ‐ Other Criteria: Proper controls over financial reporting include the ability to prepare the consolidated Schedule of Expenditures of Federal Awards (Schedule) and accompanying notes to the Schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate schedule of expenditures of federal awards being audited. We were requested to draft the Schedule. Cause: Auditor assistance with preparation of the Schedule is not unusual as the Schedule has unique and specialized requirements and preparation is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft the Schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: Yes, Finding 2022‐003. Recommendation: While we recognize that this condition is not unusual for an organization with limited staffing, we recommend management be aware of the financial reporting requirements relating to the Organization’s Schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance – Hospitals Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Preparation of Schedule of Expenditures of Federal Awards Material Weakness in Internal Control Over Compliance ‐ Other Criteria: Proper controls over financial reporting include the ability to prepare the consolidated Schedule of Expenditures of Federal Awards (Schedule) and accompanying notes to the Schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate schedule of expenditures of federal awards being audited. We were requested to draft the Schedule. Cause: Auditor assistance with preparation of the Schedule is not unusual as the Schedule has unique and specialized requirements and preparation is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft the Schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: Yes, Finding 2022‐003. Recommendation: While we recognize that this condition is not unusual for an organization with limited staffing, we recommend management be aware of the financial reporting requirements relating to the Organization’s Schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
Department of Housing and Urban Development Federal Financial Assistance Listing #14.128 Section 242 – Mortgage Insurance ‐ Hospitals Reporting Material Weakness in Internal Control Over Compliance and Noncompliance Criteria: The OMB Compliance Supplement requires that non‐federal entities receiving federal awards establish and maintain internal controls designed to reasonably ensure compliance with federal laws, regulations, and program compliance requirements. Condition: The Section 242 – Mortgage Insurance ‐ Hospitals Program requires quarterly reports and certain annual reports. For the year ended July 31, 2023, the Organization failed to file the annual budget prior to the start of the year. Cause: The Organization did not follow their internal control policy to ensure the required report was filed. Effect: The required report was not submitted in accordance with loan requirements. Questioned Costs: None reported. Context: There were a total of eight reports required to be submitted for the year ended July 31, 2023. Three were selected for testing. Of the three selected, one was not submitted as required. Through additional inquiry, there were no other reports identified as not being submitted. Repeat Finding from Prior Years: Yes, Finding 2022‐004. Recommendation: We recommend the Organization enhance internal control policies to ensure required reports are filed timely and accurately. Views of Responsible Officials: Management agrees with the finding.
Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 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 Organization included a lost revenues in the Department of Health and Human Services (HHS) special report for Period 4 that were incorrectly calculated which caused the report to be inaccurate. Cause: The Organization did not have an adequate internal control policy in place to ensure the lost revenue calculation that was reported on the HHS report was complete and accurate. Effect: The lack of adequate policies governing report preparation and submission increases the risk that the report could be filed incorrectly. Questioned Costs: None reported. Had the lost revenue calculation been reported correctly, lost revenue would have decreased by $512,211. However, the Organization did not claim any lost revenue in Period 4, so there would be no funds to return. Context: There was one lost revenue calculation required for the HHS Period 4 special report, and it was selected for testing. Repeat Finding from Prior Years: Yes, Finding 2021‐009. Recommendation: We recommend that the Organization implement procedures to ensure the lost revenue calculation reported on the HHS special report meet the requirements of the federal program. Views of Responsible Officials: Management agrees with the finding.
Department of Health and Human Services Federal Financial Assistance Listing #93.498 COVID‐19 Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year – Period 4 TIN #370645239 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control Over Compliance 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. The Organization claimed expenses based on specifically identified COVID related expenses and general and administrative expenses. Condition: During our testing, there was no documentation of review and approval of the expenditure listing or lost revenue calculation. The Organization also miscalculated the portion of an expense that was reimbursed by another source. Cause: The Organization did not have an adequate internal control policy in place to ensure review and approval of expenditures and lost revenue claimed under the federal programs was documented and that all claimed expenditures were accurately calculated and claimed. Effect: The lack of adequate policies governing review and approval over the expenditure listing and lost revenue calculation increases the risk that employees participating in the federal award administration may not be able to detect and correct noncompliance and miscalculation of reimbursement by other sources in a timely manner. Question Costs: None reported. Context/Sampling: A nonstatistical sample of 65 expenditures were selected for testing, which accounted for $172,298 of $940,628 direct program expenditures. Of these 65, the Medicare reimbursement was miscalculated for one selected item. There was one lost revenue calculation and one expenditure detail and both were tested. Repeat Finding from Prior Year: Yes, Finding 2021‐008. Recommendation: We recommend that the Organization enhance internal control policies to ensure the expenditure listing and lost revenue calculation are reviewed and approved to ensure that all payments are necessary, correct, meet the requirements of the federal program, and are properly recorded in the reports required to be submitted to the federal agency. Views of Responsible Officials: Management agrees with the finding.