Audit 388912

FY End
2023-06-30
Total Expended
$21.71M
Findings
4
Programs
3
Year: 2023 Accepted: 2026-02-24
Auditor: EIDE BAILLY LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1175217 2023-004 Material Weakness Yes P
1175218 2023-004 Material Weakness Yes P
1175219 2023-004 Material Weakness Yes P
1175220 2023-005 Material Weakness Yes N

Programs

ALN Program Spent Major Findings
10.766 COMMUNITY FACILITIES LOANS AND GRANTS $21.44M Yes 2
93.301 SMALL RURAL HOSPITAL IMPROVEMENT GRANT PROGRAM $172,594 Yes 1
93.697 COVID-19 TESTING AND MITIGATION FOR RURAL HEALTH CLINICS $100,000 Yes 1

Contacts

Name Title Type
F3AWQ6E1VE55 Judy Monson Auditee
7017861723 Renee M. Gravalin Auditor
No contacts on file

Notes to SEFA

The Consolidated Schedule of Expenditures and Federal awards includes the federal grant activity of Cooperstown Medical Center d/b/a Dakota Regional Medical Center, and its subsidiary, the Cooperstown Medical Center Foundation (collectively, the Medical Center) which received federal financial assistance. Significant intercompany balances and transactions have been eliminated in the Consolidated Schedule of Expenditures of Federal Awards.
Expenditures reported on this Schedule consist of two loans including a Direct Loan and a 90% Guaranteed Loan. Total expenditures as reported on the Schedule under the Community Facilities Loans and Grants represents the Guaranteed and Direct Loan beginning of the year advances plus current loan advances incurred during the year ended June 30, 2023. The beginning of the year Guaranteed Loan balance was $2,000,000, of which 90% is guaranteed, and totals $1,800,000. The beginning of the year Direct Loan balance was $11,021,487. The Direct Loan had expenditures of $8,615,116 in fiscal year 2023. The expenditures include amounts recognized as construction payables at June 30, 2023, which totaled $128,478. The total of the Guaranteed Loan and the Direct Loan reported on the Schedule is $21,436,603. The balance outstanding on the Direct Loan and Guaranteed Loan at June 30, 2023 was $22,911,503, which include the 10% not guaranteed under the Community Facilities Loan Program.

Finding Details

Department of Agriculture Federal Financial Assistance Listing #10.766 Community Facilities Loans and Grants Cluster Department of Health and Human Services Federal Financial Assistance Listing #93.697 COVID-19 Testing and Mitigation for Rural Health Clinics Department of Health and Human Services Federal Financial Assistance Listing #93.301 COVID-19 Small Rural Hospital Improvement Grants 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 Medical Center 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 Medical Center meets a specified threshold of federal expenditures. Effect There is a reasonable possibility that the Medical Center would not be able to draft a Schedule that is correct without assistance of the auditors. Questioned Costs None reported. Context Sampling was not used. Repeat Finding from Prior Years Yes 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 Medical Center’s Consolidated Schedule of Expenditures of Federal Awards and internal controls that impact financial reporting. Views of Responsible Officials Management agrees with the finding.
Department of Agriculture Federal Financial Assistance Listing #10.766 Community Facilities Loans and Grants Cluster Lack of Timely Reconciliations of the General Cash, Construction, and Required Reserve Accounts Material Weakness in Internal Control Over Compliance – Special Tests and Provisions Criteria The Medical Center is required to establish accounts into which borrower funds, loan proceeds, the revenue of the facility financed, and any other income shall be deposited in accordance with loan resolutions authorizing the incurrence of indebtedness related to the loan proceeds. These accounts shall be maintained in accordance with the loan resolutions as long as the authorized indebtedness is outstanding. These accounts include the general account (i.e., operating checking account), construction account, debt service account, and reserve account (USDA Accounts). Condition The Medical Center does not have an internal control system designed to ensure that the USDA Accounts noted above are reconciled on a timely basis. The lack of timely reconciliations required several adjustments to be made during the audit. Cause The Medical Center had turnover in the Chief Financial Officer position along with a construction project that utilized significant finance department time and resources. Effect There is a reasonable possibility that errors related to the USDA Accounts and other accounts impacted by the USDA Accounts, including construction in progress, are not properly stated in the consolidated financial statements. In addition, there could be amounts expended from the USDA Accounts that do not meet the requirements and those expenditures would not be identified in a timely manner. Questioned Costs None reported. Context Sampling was not used. There are four USDA Accounts currently in use and all USDA Accounts were reviewed. Repeat Finding from Prior Years No Recommendation We recommend that a formalized process be established to ensure timely reconciliation of the USDA Accounts as well as a review process of those reconciliations each month. Views of Responsible Officials Management agrees with the finding.