Finding 7621 (2022-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2024-01-06

AI Summary

  • Core Issue: $6.7 million in FEMA Public Assistance funds were not recorded in the 2022 SEFA due to insufficient review of reporting requirements.
  • Impacted Requirements: Expenditures must be recorded when FEMA approves project worksheets and eligible costs are incurred, which was not followed.
  • Recommended Follow-Up: Improve controls to ensure accurate reporting of expenditures for program 97.036 in the correct fiscal period.

Finding Text

Grantor: Federal Emergency Management Agency (FEMA) Award Name: FEMA Public Assistance Award Year: FY2022 Assistance Listing Number: 97.036 Condition During the 2023 Uniform Guidance audit, Management identified $6.7 million of funds from this program that were not appropriately recorded in the 2022 SEFA. On the 2022 SEFA, management did not record reimbursement requests approved by FEMA that were for expenditures incurred prior to during fiscal years 2020 and 2021. Criteria Per the Federal Emergency Management Agency’s (“FEMA”) Public Assistance Program, nonfederal entities must record expenditures on the Schedule of Expenditures of Federal Awards (SEFA) when (1) FEMA has approved the nonfederal entity’s project worksheet, and (2) the nonfederal entity has incurred the eligible expenditures. Cause The cause of this finding was due to insufficient review of the reporting requirements related to this program. Effect Federal funds related to program 97.036 of $6.7 million were incorrectly excluded from the 2022 SEFA. Had this been recorded correctly, this program would have been tested as a major program in 2022. As such, the 2022 SEFA was required to be revised, testing was performed over this program for 2022, and a material weakness over compliance was identified and included in the 2022 Report of Independent Auditors on Compliance for Each Major Program and on Internal Control Over Compliance Required by Uniform Guidance and the reporting package was re-submitted to the Federal Audit Clearinghouse. Questioned Costs There are no questioned costs associated with this finding. Recommendation Management should enhance the control in place to review reporting requirements related to program 97.036 to ensure expenditures are reported on the SEFA in the appropriate period. Management’s Views and Corrective Action Plan Management’s response is included in “Management’s Views and Corrective Action Plan” included at the end of this report after the summary schedule of status of prior audit findings.

Corrective Action Plan

The University agrees with this finding. To mitigate future risk all FEMA funds received in FY24 or later will be recorded by our Sponsored Program Accounting team, consistent with all other federal awards. Additionally, beginning in FY24 management will implement a formal reconciliation process for all income recorded as “Other Income” and work directly with the University Office of Sponsored Programs to evaluate all uncommon income receipts.

Categories

Reporting

Other Findings in this Audit

  • 584063 2022-001
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $27.11M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $6.67M
84.038 Perkins Starting Balance $4.71M
84.063 Federal Pell Grant Program $2.71M
84.411 Investing in Innovation (i3) Fund $1.49M
93.310 Trans-Nih Research Support $573,873
84.007 Federal Supplemental Educational Opportunity Grants $558,671
12.910 Research and Technology Development $467,793
84.033 Federal Work-Study Program $435,142
47.074 Biological Sciences $378,940
12.RD Department of Defense - Program Unknown $294,493
12.431 Basic Scientific Research $265,782
10.950 Agricultural Statistics Reports $218,976
16.560 National Institute of Justice Research, Evaluation, and Development Project Grants $173,059
81.086 Conservation Research and Development $159,687
43.007 Space Operations $150,934
66.511 Office of Research and Development Consolidated Research/training/fellowships $144,684
93.855 Allergy, Immunology and Transplantation Research $139,705
93.213 Research and Training in Complementary and Integrative Health $138,093
12.225 Commercial Technologies for Maintenance Activities Program $137,701
12.300 Basic and Applied Scientific Research $137,202
12.630 Basic, Applied, and Advanced Research in Science and Engineering $129,887
93.242 Mental Health Research Grants $129,774
11.307 Economic Adjustment Assistance $123,684
77.008 U.s. Nuclear Regulatory Commission Scholarship and Fellowship Program $118,881
93.837 Cardiovascular Diseases Research $113,773
84.016 Undergraduate International Studies and Foreign Language Programs $102,975
43.001 Science $101,896
84.305 Education Research, Development and Dissemination $92,377
12.902 Information Security Grants $86,829
84.200 Graduate Assistance in Areas of National Need $84,834
66.509 Science to Achieve Results (star) Research Program $84,605
93.394 Cancer Detection and Diagnosis Research $83,559
81.089 Fossil Energy Research and Development $80,253
47.079 Office of International Science and Engineering $79,391
81.121 Nuclear Energy Research, Development and Demonstration $76,125
43.012 Space Technology $70,104
93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders $61,746
43.RD NASA - Program Unknown $59,151
93.866 Aging Research $58,523
93.173 Research Related to Deafness and Communication Disorders $57,809
10.310 Agriculture and Food Research Initiative (afri) $56,100
47.070 Computer and Information Science and Engineering $53,585
12.800 Air Force Defense Research Sciences Program $49,710
47.049 Mathematical and Physical Sciences $48,306
84.153 Business and International Education Projects $43,383
47.041 Engineering $38,467
12.000 Department of Defense - Program Unknown $37,848
93.859 Biomedical Research and Research Training $37,764
81.RD Department of Energy - Program Unknown $36,657
47.076 Education and Human Resources $31,769
10.912 Environmental Quality Incentives Program $26,380
11.619 Arrangements for Interdisciplinary Research Infrastructure $25,842
47.075 Social, Behavioral, and Economic Sciences $23,463
98.007 Food for Peace Development Assistance Program (dap) $20,921
47.050 Geosciences $20,663
47.084 Nsf Technology, Innovation and Partnerships $17,441
81.087 Renewable Energy Research and Development $15,453
93.865 Child Health and Human Development Extramural Research $13,163
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $6,405
19.900 Aeeca/esf Pd Programs $3,132
93.879 Medical Library Assistance $2,000
12.420 Military Medical Research and Development $949