Finding 525053 (2020-002)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2020
Accepted
2025-02-28

AI Summary

  • Core Issue: CUAHSI submitted inaccurate SEFA reports, affecting the identification of federal grant expenditures.
  • Impacted Requirements: Non-compliance with Uniform Guidance led to delays in financial audits and reporting deadlines.
  • Recommended Follow-Up: Develop and document procedures for tracking federal awards and disbursements to improve SEFA accuracy.

Finding Text

Federal agency name: U.S. National Science Foundation and U.S. Department of Agriculture Federal program title: Geosciences, Computer and Information Science and Engineering, Office of Cyber Infrastructure, Integrative Activities & Forestry Research AL No.: 47.050, 47.070, 47.079, 47.080, 47.083 & 10.652 Federal Award Identification No. & Award Period: EAR-1849458 (06/01/2019-05/31/2024), EAR-2012893 (10/01/2020 – 08/31/2025), EAR-2028793 (05/15/2020 – 04/30/2021), OAC-1931278 (10/1/2019 – 09/30/2022), OAC-1829744 (09/01/2018 – 08/31/2023), OAC-1835592 (01/01/2009 – 12/31/2022), OAC-1835818 (10/01/2018 – 09/30/2022), OISE-1855654 (05/15/2019 – 12/31/2023), OAC-1664061 (10/01/17 – 09/30/2022), OIA-1937099 (09/01/2020 – 08/31/2021) & 19-DG11330140-083 (09/26/2019 – 09/30/2021) Pass Through Entity: Utah State University & University of Cincinnati MW2020-002 ACCURACY AND COMPLETENESS OF SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS (“SEFA”) Criteria CUAHSI is required to prepare a SEFA in accordance with the prescribed guidelines of the Uniform Guidance (“UG”). In addition, 2 CFR Section 200.512(a) of the Uniform Guidance requires the reporting package and Data Collection Form (“DCF”) to be submitted to the Federal Audit Clearinghouse the earlier of 30 calendar days after the reports are received from the auditor or nine months after CUAHSI’s year end. Condition CUAHSI provided two different versions of the SEFA to the auditor during the audit process. The auditor noted CUAHSI incorrectly identified the qualified expenditures related to the federal grant programs. Additionally, due to the delay in financial close of CUAHSI’s books and records, a federal single audit for the year ended December 31, 2020 was not performed in a timely manner and the DCF was not submitted by its due date of March 31, 2022. The inaccurate reporting of grants and related activity in the SEFA can lead to improper identification of major programs causing inadequate testing by the auditor as required by UG. As a result of the audit procedures performed and proposed adjustments to CUAHSI’s preliminary SEFA by the audit, management was able to make the required changes. Cause & Context Due personnel and staffing issues, CUAHSI was not able to complete the financial close process in a timely manner which led to the changes in qualified expenditures and delay in the financial statement and the federal single audit being completed. Effect Failure to comply with federal regulations and reporting requirements exposes CUAHSI to potential legal and regulatory consequences, including the risk of future funding loss and financial penalties. Questioned Costs None Prior Year Audit Finding Yes - previously reported as MW2019-006. Recommendation To address the identified deficiencies and improve controls over the preparation of the SEFA, the auditor recommends the development and documentation of procedures for tracking federal awards and related disbursements to subrecipients. View of Responsible Official and Planned Corrective Action See accompanying Corrective Action Plan.

Categories

Reporting

Other Findings in this Audit

  • 525039 2020-002
    Material Weakness Repeat
  • 525040 2020-004
    Material Weakness Repeat
  • 525041 2020-005
    Material Weakness Repeat
  • 525042 2020-006
    Material Weakness Repeat
  • 525043 2020-007
    Material Weakness Repeat
  • 525044 2020-008
    Material Weakness Repeat
  • 525045 2020-009
    Material Weakness Repeat
  • 525046 2020-002
    Material Weakness Repeat
  • 525047 2020-004
    Material Weakness Repeat
  • 525048 2020-005
    Material Weakness Repeat
  • 525049 2020-006
    Material Weakness Repeat
  • 525050 2020-007
    Material Weakness Repeat
  • 525051 2020-008
    Material Weakness Repeat
  • 525052 2020-009
    Material Weakness Repeat
  • 525054 2020-004
    Material Weakness Repeat
  • 525055 2020-005
    Material Weakness Repeat
  • 525056 2020-006
    Material Weakness Repeat
  • 525057 2020-007
    Material Weakness Repeat
  • 525058 2020-008
    Material Weakness Repeat
  • 525059 2020-009
    Material Weakness Repeat
  • 525060 2020-002
    Material Weakness Repeat
  • 525061 2020-004
    Material Weakness Repeat
  • 525062 2020-005
    Material Weakness Repeat
  • 525063 2020-006
    Material Weakness Repeat
  • 525064 2020-007
    Material Weakness Repeat
  • 525065 2020-008
    Material Weakness Repeat
  • 525066 2020-009
    Material Weakness Repeat
  • 525067 2020-002
    Material Weakness Repeat
  • 525068 2020-004
    Material Weakness Repeat
  • 525069 2020-005
    Material Weakness Repeat
  • 525070 2020-006
    Material Weakness Repeat
  • 525071 2020-007
    Material Weakness Repeat
  • 525072 2020-008
    Material Weakness Repeat
  • 525073 2020-009
    Material Weakness Repeat
  • 525074 2020-002
    Material Weakness Repeat
  • 525075 2020-004
    Material Weakness Repeat
  • 1101481 2020-002
    Material Weakness Repeat
  • 1101482 2020-004
    Material Weakness Repeat
  • 1101483 2020-005
    Material Weakness Repeat
  • 1101484 2020-006
    Material Weakness Repeat
  • 1101485 2020-007
    Material Weakness Repeat
  • 1101486 2020-008
    Material Weakness Repeat
  • 1101487 2020-009
    Material Weakness Repeat
  • 1101488 2020-002
    Material Weakness Repeat
  • 1101489 2020-004
    Material Weakness Repeat
  • 1101490 2020-005
    Material Weakness Repeat
  • 1101491 2020-006
    Material Weakness Repeat
  • 1101492 2020-007
    Material Weakness Repeat
  • 1101493 2020-008
    Material Weakness Repeat
  • 1101494 2020-009
    Material Weakness Repeat
  • 1101495 2020-002
    Material Weakness Repeat
  • 1101496 2020-004
    Material Weakness Repeat
  • 1101497 2020-005
    Material Weakness Repeat
  • 1101498 2020-006
    Material Weakness Repeat
  • 1101499 2020-007
    Material Weakness Repeat
  • 1101500 2020-008
    Material Weakness Repeat
  • 1101501 2020-009
    Material Weakness Repeat
  • 1101502 2020-002
    Material Weakness Repeat
  • 1101503 2020-004
    Material Weakness Repeat
  • 1101504 2020-005
    Material Weakness Repeat
  • 1101505 2020-006
    Material Weakness Repeat
  • 1101506 2020-007
    Material Weakness Repeat
  • 1101507 2020-008
    Material Weakness Repeat
  • 1101508 2020-009
    Material Weakness Repeat
  • 1101509 2020-002
    Material Weakness Repeat
  • 1101510 2020-004
    Material Weakness Repeat
  • 1101511 2020-005
    Material Weakness Repeat
  • 1101512 2020-006
    Material Weakness Repeat
  • 1101513 2020-007
    Material Weakness Repeat
  • 1101514 2020-008
    Material Weakness Repeat
  • 1101515 2020-009
    Material Weakness Repeat
  • 1101516 2020-002
    Material Weakness Repeat
  • 1101517 2020-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
47.050 Geosciences $2.31M
47.080 Office of Cyberinfrastructure $127,911
47.070 Computer and Information Science and Engineering $70,695
47.083 Integrative Activities $14,635
47.079 Office of International Science and Engineering $3,306
10.652 Forestry Research $2,401