Finding 1205398 (2024-004)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2026-03-31

AI Summary

  • Core Issue: The Corporation lacked effective internal controls to accurately report federal expenditures on the Schedule of Expenditures of Federal Awards.
  • Impacted Requirements: Compliance with Uniform Guidance sections 200.303 and 200.510 regarding internal controls and accurate reporting of federal awards.
  • Recommended Follow-Up: Update policies and procedures to enhance internal controls for accurate reporting, addressing the repeat finding from the previous year.

Finding Text

Finding Reference: 2024-004 – Other finding – SEFA Preparation Federal Program Information Federal Agencies: Department of Treasury Awards: Assistance Listing 21.027 – COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Award Periods: July 1, 2023 – December 31, 2026 Description: Preparation of Schedule of Expenditures of Federal Awards Criteria The Uniform Guidance 2 CFR section 200.303 states, “The non-Federal entity must: (a) Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. These internal controls should be in compliance with guidance in “Standards for Internal Control in the Federal Government” issued by the Comptroller General of the United States or the “Internal Control Integrated Framework”, issued by the Committee of Sponsoring Organizations of the Treadway Commission (COSO).” The Uniform Guidance 2 CFR section 200.510 states, “(b) Schedule of expenditures of Federal awards. The auditee must also prepare the Schedule for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with §200.502 Basis for determining Federal awards expended.” Condition The Corporation did not have appropriately designed internal controls in place to determine the correct amount of federal expenditures to be included on the Schedule. The Corporation omitted the expenditures related to the Assistance Listing Number 21.027 – COVID-19 - Coronavirus State and Local Fiscal Recovery Funds as well as expenditures related to seven other assistance listing numbers. Cause The Corporation did not design internal controls to completely and accurately report expenditures within the Schedule. Effect or potential effect The Schedule prepared by the Corporation was misstated but was subsequently corrected. A misstated Schedule could result in the improper selection of federal award major programs or an incorrect percentage of coverage being calculated resulting in a restatement of a previously issued Uniform Guidance report. Questioned costs None. Identification of a repeat finding This is a repeat finding of Finding 2023-002. Context Expenditures for Assistance Listing 21.027 of approximately $339,000 were excluded from the Schedule. In addition, expenditures totaling approximately $261,000 for seven other assistance listing numbers were also excluded from the Schedule. Recommendation The Corporation should update its policies and procedures and internal controls to ensure accurate reporting of the Schedule as required by the Uniform Guidance. View of responsible officials There is no disagreement with the audit finding.

Corrective Action Plan

Other finding – SEFA Preparation Preparation of Schedule of Expenditures of Federal Awards Assistance Listing 21.027 – COVID-19 - Coronavirus State and Local Fiscal Recovery Funds Federal Agencies: Department of Treasury Recommendation: The Corporation should update its policies and procedures and internal controls to ensure accurate reporting of the Schedule as required by the Uniform Guidance. Explanation of disagreement with audit finding: There is no disagreement with the finding and recommendation. Action planned/taken in response to finding: The Corporation established a centralized UMMS Office for Research and Sponsored Programs Administration (ORSPA) department in December 2025. The ORSPA department created a standard pre-award approval process for all sponsored proposals prior to submission or award acceptance. The pre-award approval process applies to all federal, state, local, private and commercial funding opportunities across all UMMS entities and covers new, renewal, resubmission and supplemental proposals. The establishment of a central intake process through one department, for all grants across the Corporation, enhances the controls to ensure complete and accurate reporting of the Schedule as required by the Uniform Guidance. Additionally, ORSPA and Corporate Financial Reporting implemented the following controls to ensure all expenditures of federal awards are included on the Schedule. These controls include:  Reconciliation of the grants from the pre-award approval process to the grants tagged in the accounting system;  Use of a specific grant identifier within the accounting system to track expenditures and revenue recognition and tag grants as federal, state or private funded;  Comparison of grant expenditures per the accounting system to the grant agreement;  Comparison of grant expenditures per the accounting system to the financial reporting submissions made to the federal agencies;  Certification from legal entity Finance Executives that the draft Schedule is complete and accurate;  Comparison of the prior year Schedule to the current year Schedule with further investigation around changes in grants and agencies included, and significant changes in the expenditures. Anticipated Completion Date – June 30, 2026 Name(s) of the contact person(s) responsible for corrective action: Jeff Chadwick, Financial Reporting Director, jeff.chadwick@umm.edu

Categories

Reporting

Other Findings in this Audit

  • 1205394 2024-001
    Material Weakness Repeat
  • 1205395 2024-002
    Material Weakness Repeat
  • 1205396 2024-003
    Material Weakness Repeat
  • 1205397 2024-004
    Material Weakness Repeat
  • 1205399 2024-005
    Material Weakness Repeat
  • 1205400 2024-005
    Material Weakness Repeat
  • 1205401 2024-006
    Material Weakness Repeat
  • 1205402 2024-006
    Material Weakness Repeat
  • 1205403 2024-007
    Material Weakness Repeat
  • 1205404 2024-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.959 BLOCK GRANTS FOR PREVENTION AND TREATMENT OF SUBSTANCE ABUSE $352,026
21.027 COVID-19 - CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $204,285
16.575 CRIME VICTIM ASSISTANCE $199,999
16.738 EDWARD BYRNE MEMORIAL JUSTICE ASSISTANCE GRANT PROGRAM $94,247
93.078 STRENGTHENING EMERGENCY CARE DELIVERY IN THE UNITED STATES HEALTHCARE SYSTEM THROUGH HEALTH INFORMATION AND PROMOTION $91,018
16.838 COMPREHENSIVE OPIOID, STIMULANT, AND OTHER SUBSTANCES USE PROGRAM $87,155
16.588 VIOLENCE AGAINST WOMEN FORMULA GRANTS $80,952
16.320 SERVICES FOR TRAFFICKING VICTIMS $60,297
16.017 SEXUAL ASSAULT SERVICES FORMULA PROGRAM $32,750
93.354 COVID-19 - PUBLIC HEALTH EMERGENCY RESPONSE: COOPERATIVE AGREEMENT FOR EMERGENCY RESPONSE: PUBLIC HEALTH CRISIS RESPONSE $30,000
93.325 PARALYSIS RESOURCE CENTER $25,000
93.898 CANCER PREVENTION AND CONTROL PROGRAMS FOR STATE, TERRITORIAL AND TRIBAL ORGANIZATIONS $9,999
93.889 NATIONAL BIOTERRORISM HOSPITAL PREPAREDNESS PROGRAM $2,000