Finding 974633 (2022-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2024-05-22
Audit: 306898
Organization: Miami University (OH)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: The University failed to include $3,035,255 in federal expenditures for Disaster Grants in its Schedule of Expenditures for Federal Awards.
  • Impacted Requirements: This oversight violates 2 CFR 200.200.510(b), which mandates accurate reporting of federal awards.
  • Recommended Follow-Up: Improve internal controls and processes to ensure timely and accurate preparation of the Schedule to prevent future errors.

Finding Text

Criteria: In accordance with 2 CFR 200.200.510(b), the auditee must prepare a Schedule of Expenditures of Federal Awards (Schedule) for the period covered by the auditee's financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The University’s Schedule of Expenditures for Federal Awards for the year ended June 30, 2022, was restated to include federal expenditures totaling $3,035,255 for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, resulting in total expenditures of $3,030,346. Cause: The federal program activity for the Disaster Grants - Public Assistance (Presidentially Declared Disasters), Assistance Listing Number 97.036, was omitted from the Schedule of Expenditures for Federal Awards due to an oversight in the preparation of the Schedule. Effect: Improper reporting of federal expenditures can result in material errors on the Schedule leading to inaccurate major program determination by the auditors. In this instance, an error did result in the identification of an additional major program. Questioned Cost: None. Context: The University improperly excluded grant expenditures for the Disaster Grants - Public Assistance (Presidentially Declared Disasters) program on the original Schedule for the year ended June 30, 2022 in the amount of $3,035,255 resulting in total expenditures of $3,030,346 for the program and, therefore, the single audit report was reissued for the correction of the error. Recommendation: We recommend the University enhance the process and internal controls around the timely identification of federal awards and preparation of the Schedule to ensure accuracy and completeness of the Schedule. Views of responsible officials: We agree with the compliance finding. See the Corrective Action Plan at pages 71-72.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $71.51M
84.425 Education Stabilization Fund -Covid-19 $18.42M
84.063 Federal Pell Grant Program $14.51M
84.038 Federal Perkins Loan Program $3.54M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $3.03M
84.379 Teacher Education Assistance for College and Higher Education Grants (teach Grants) $1.01M
84.007 Federal Supplemental Educational Opportunity Grants $981,483
84.033 Federal Work-Study Program $528,390
84.047 Trio_upward Bound $316,239
84.042 Trio_student Support Services $234,872
15.615 Cooperative Endangered Species Conservation Fund $231,481
93.867 Vision Research $156,652
84.365 English Language Acquisition State Grants $143,007
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $142,867
84.425 Education Stabilization Fund-Covid-19 $135,691
12.U01 Distinguised Visiting Professor of Geosciences $130,691
93.273 Alcohol Research Programs $125,588
12.431 Basic Scientific Research $115,213
93.433 Acl National Institute on Disability, Independent Living, and Rehabilitation Research $115,077
93.859 Biomedical Research and Research Training $114,507
12.RD5 Neural Signatures of Cognitive States $99,865
81.049 Office of Science Financial Assistance Program $95,794
93.778 Medical Assistance Program $93,500
93.243 Substance Abuse and Mental Health Services_projects of Regional and National Significance $92,567
84.305 Education Research, Development and Dissemination $84,256
19.004 Public Diplomacy Programs $77,647
93.262 Occupational Safety and Health Program $72,231
84.184 Safe and Drug-Free Schools and Communities_national Programs $72,070
21.019 Coronavirus Relief Fund-Covid-19 $70,723
93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research $67,411
93.RD8 Suicide Simulation $67,208
93.048 Special Programs for the Aging_title Iv_and Title Ii_discretionary Projects $66,155
93.RD3 Administration for Community Living $62,706
12.RD3 Electronically Dimmable Eyewear Protection $55,816
84.335 Child Care Access Means Parents in School $55,094
93.RD2 Beta-Lactamase Mediated Resistance $52,348
84.411 Investing in Innovation (i3) Fund $51,093
12.910 Research and Technology Development $50,701
59.037 Small Business Development Centers-Covid-19 $49,856
19.040 Public Diplomacy Programs $47,788
16.525 Grants to Reduce Domestic Violence, Dating Violence, Sexual Assault, and Stalking on Campus $45,124
93.855 Allergy, Immunology and Transplantation Research $43,318
47.078 Polar Programs $42,595
93.470 Alzheimer's Disease Program Initiative (adpi) $42,576
47.050 Geosciences $39,595
10.326 Capacity Building for Non-Land Grant Colleges of Agriculture (nlgca) $39,133
93.242 Mental Health Research Grants $35,000
15.807 Earthquake Hazards Research Grants $34,206
93.RD1 Occupational Safety and Health Program $31,999
93.083 Prevention of Disease, Disability, and Death Through Immunization and Control of Respiratory and Related Diseases $29,134
93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders $27,924
12.RD6 Ofr High Risk Prevention Audit $27,569
84.377 School Improvement Grants $26,876
10.310 Agriculture and Food Research Initiative (afri) $26,824
84.425 Education Stabilization Fund-Covid-19 $26,711
12.420 Military Medical Research and Development $26,710
12.RD4 270 V Robust Power Supply $25,829
59.037 Small Business Development Centers $24,950
12.RD2 Poly and Perfluoralkyl Substances $24,711
93.837 Cardiovascular Diseases Research $24,687
45.162 Promotion of the Humanities_teaching and Learning Resources and Curriculum Development $24,061
93.173 Research Related to Deafness and Communication Disorders $23,818
45.169 Promotion of the Humanities_office of Digital Humanities $23,284
15.664 Fish and Wildlife Coordination and Assistance Programs $22,932
93.865 Child Health and Human Development Extramural Research $21,962
16.838 Comprehensive Opioid Abuse Site-Based Program $21,429
15.808 U.s. Geological Survey_ Research and Data Collection $21,065
20.106 Airport Improvement Program-Covid-19 $20,000
15.805 Assistance to State Water Resources Research Institutes $18,607
12.630 Basic, Applied, and Advanced Research in Science and Engineering $18,024
15.630 Coastal Program $16,775
47.076 Education and Human Resources $15,346
47.077 Computer and Information Science and Engineering $13,462
16.582 Crime Victim Assistance/discretionary Grants $12,842
93.RD9 Occupational Safety and Health Program $12,649
47.049 Mathematical and Physical Sciences $10,011
93.110 Maternal and Child Health Federal Consolidated Programs $9,917
15.810 National Cooperative Geologic Mapping Program $9,607
12.800 Air Force Defense Research Sciences Program $9,203
43.001 Science $8,874
66.RD7 Air Pollution Control Program Support $7,894
45.149 Promotion of the Humanities_division of Preservation and Access $7,640
45.161 Promotion of the Humanities_research $7,142
45.129 Promotion of the Humanities_federal/state Partnership $6,355
39.U01 Office of Evaluation Sciences Fellowship $5,664
12.RD1 Ew Enviornment Prediction $4,430
94.006 Americorps $4,350
21.027 Coronavirus State and Local Fiscal Recovery Funds-Covid-19 $3,633
15.657 Endangered Species Conservation Ð Recovery Implementation Funds $2,917
93.307 Minority Health and Health Disparities Research $2,622
43.008 Education $2,500
20.U03 Ovi Countywide Task Force $2,141
66.516 P3 Award: National Student Design Competition for Sustainability $2,018
19.009 Academic Exchange Programs - Undergraduate Programs $1,471
47.074 Biological Sciences $1,411
93.866 Aging Research $1,121
47.041 Engineering $501
84.027 Special Education_grants to States $70