Audit 17145

FY End
2022-06-30
Total Expended
$3.43M
Findings
12
Programs
3
Year: 2022 Accepted: 2023-01-18
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
12866 2022-003 Material Weakness Yes P
12867 2022-004 Material Weakness - N
12868 2022-003 Material Weakness Yes P
12869 2022-004 Material Weakness - N
12870 2022-003 Material Weakness Yes P
12871 2022-004 Material Weakness - N
589308 2022-003 Material Weakness Yes P
589309 2022-004 Material Weakness - N
589310 2022-003 Material Weakness Yes P
589311 2022-004 Material Weakness - N
589312 2022-003 Material Weakness Yes P
589313 2022-004 Material Weakness - N

Programs

ALN Program Spent Major Findings
10.766 Community Facilities Loans and Grants $1.32M Yes 2
93.155 Rural Health Research Centers $219,639 - 0
93.301 Small Rural Hospital Improvement Grant Program $12,836 - 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: 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 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, 2022. The outstanding balance at June 30, 2022 was $1,018,236 for the 2008 direct USDA loan, $1,295,983 for the 2010 direct USDA loan, and $896,002 for the USDA guaranteed loan.
Title: Basis of Presentation Accounting Policies: 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 has not elected to use the 10% de minimis cost rate. 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, 2022. 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.

Finding Details

2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans 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 combined 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. As auditors, we were requested to assist with the preparation of 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 that is 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 2021-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.
2022-004 Department of Agriculture Federal Financial Assistance Listing/CFDA #10.766 Communities Facilities and Loans Grants Cluster Special Tests 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 award. 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 which may be established as a bookkeeping account or as a separate bank account. Funds may be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Condition: Management maintained the reserve amount in the pooled investment fund account which was not established as a separate bookkeeping account or as a separate bank account. Although the pooled investment fund includes marketable securities backed by the full faith and credit of the United States, based on the portfolio mix of the investment pool, additional cash balances on hand need to supplement the investment pool to adequately fund the reserve. The Hospital has excess cash available. Cause: The Hospital was unaware the funds were required to be deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Effect: The Hospital could be in violation of the reserve amount requirements if management is not monitoring compliance. Questioned Costs: None reported Context/Sampling: Sampling was not used. Repeat Finding from Prior Year: No Recommendation: We recommend management transfer the required reserve amount to a separate bookkeeping account in the trial balance or establish a separate bank account and ensure the funds are deposited in institutions insured by state and federal government or invested in marketable securities backed by the full faith and credit of the United States. Controls should be established and documented to monitor compliance with the reserve fund provision. Views of Responsible Officials: Management agrees with the finding.