Audit 8344

FY End
2023-06-30
Total Expended
$3.62M
Findings
12
Programs
4
Year: 2023 Accepted: 2023-12-22
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
6416 2023-003 Material Weakness Yes P
6417 2023-004 Material Weakness Yes N
6418 2023-003 Material Weakness Yes P
6419 2023-004 Material Weakness Yes N
6420 2023-003 Material Weakness Yes P
6421 2023-004 Material Weakness Yes N
582858 2023-003 Material Weakness Yes P
582859 2023-004 Material Weakness Yes N
582860 2023-003 Material Weakness Yes P
582861 2023-004 Material Weakness Yes N
582862 2023-003 Material Weakness Yes P
582863 2023-004 Material Weakness Yes N

Programs

ALN Program Spent Major Findings
10.766 Community Facilities Loans and Grants $806,402 Yes 2
93.498 Covid-19 Provider Relief Fund $446,183 - 0
93.155 Covid-19 Rural Health Research Centers $38,737 - 0
93.301 Small Rural Hospital Improvement Grant Program $13,011 - 0

Contacts

Name Title Type
MNG1KMML14E7 Bryan Slaba Auditee
6053847284 Joy Feige Auditor
No contacts on file

Notes to SEFA

Title: Community Facilities Loans Accounting Policies: The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Wagner Community Memorial Hospital (the Hospital) under programs of the federal government for the year ended June 30, 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 Hospital, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Hospital. Expenditures reported on the schedule are reported on the accrual basis of accounting. When applicable, 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 Hospital does not draw for indirect administrative expenses and has not elected to use the 10% de minimis cost rate. Expenditures reporting in this schedule consist of the beginning of the year outstanding loan balance for the direct loans and 90% of the beginning of the year outstanding loan balance for the guaranteed loan. There were no loan advances during the year ended June 30, 2023. The outstanding balance at June 30, 2023 was $997,537 for the 2008 direct loan, $1,269,978 for the 2010 direct loan, and $860,135 for the guaranteed loan.
Title: Provider Relief Fund and American Rescue Plan (ARP) Rural Distribution Program Accounting Policies: The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Wagner Community Memorial Hospital (the Hospital) under programs of the federal government for the year ended June 30, 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 Hospital, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Hospital. Expenditures reported on the schedule are reported on the accrual basis of accounting. When applicable, 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 Hospital does not draw for indirect administrative expenses and has not elected to use the 10% de minimis cost rate. The Hospital 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) in the amount of $3,923,991. The PRF expenditures are not recognized on the schedule until the expenditures are included in the reporting to HHS as required under the PRF Program. In accordance with the 2023 Compliance Supplement, the PRF expenditures recognized on the schedule are based on the reporting to HHS for Period 4, defined as payments received during July 1, 2021 to December 31, 2021 of $446,183 and Period 5, defined as payments received during January 1, 2022 to June 30, 2022 as required under the PRF program. The Hospital did not receive funding during Period 5. The following summarizes the Provider Relief Funds and the timing of when the amounts were recognized in the financial statements. (See Table in Report)

Finding Details

2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.
2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.
2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.
2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.
2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.
2023-003 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster 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 schedule of expenditures of federal awards (the schedule) and accompanying notes to the schedule. Condition: The Hospital does not have an internal control system designed to provide for the preparation of the schedule and notes to the schedule. As auditors, we were requested to assist with the preparation of the schedule and notes to the schedule. Cause: Auditor assistance with the preparation of the schedule is not unusual as the schedule has unique and specialized requirements and preparation is only required when the Hospital meets a specific threshold of federal expenditures. Effect: There is a reasonable possibility that the Hospital would not be able to draft the schedule and notes to the schedule that are correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-003 Recommendation: While we recognized 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 Hospital’s schedule and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2023-004 Department of Agriculture Federal Financial Assistance Listing #10.766 Communities Facilities Loans and Grants Cluster Special Test and Provisions Material Weakness 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 awards. Section 4 of the loan resolution security agreements dated September 2, 2008 and March 10, 2010 states the Hospital must set aside a reserve amount each month until the specified account balance is reached. Condition: The Hospital’s reserve account is fully funded per the requirements in the loan resolution agreement. However, there is no documented secondary monitoring of the account balance as compared to the required minimum balance. Cause: The Hospital did not have a formal review or approval process in place. The balance is disclosed to the board within the financial information provided to the board members, however, there is no comparison of the reserve fund account balance compared to the required minimum balance. Effect: The lack of formal review or approval increases the risk of employees participating in the federal award administration not detecting and correcting noncompliance in a timely manner. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Year: Yes, prior year finding 2022-004. Recommendation: We recommend that management implement procedures to include monitoring over special test and provisions related to federal expenditures including a secondary review of the reserve bank account which may include a comparison of the required balance to the actual balance or documenting the requirement in the monthly financial information which are provided to the board. Views of Responsible Officials: Management agrees with the finding.