Finding 561272 (2024-001)

Significant Deficiency
Requirement
C
Questioned Costs
-
Year
2024
Accepted
2025-05-22
Audit: 356899
Organization: Emory University (GA)
Auditor: Kpmg LLP

AI Summary

  • Core Issue: Monthly reconciliations between the Department of Education's records and the school's financial records were prepared on time, but differences were not accounted for, and there was no documented review process.
  • Impacted Requirements: Compliance with 2 CFR 200.303 and 34 CFR 685.300(b)(50) was not met due to lack of effective internal controls and segregation of duties.
  • Recommended Follow-Up: Strengthen management review processes by ensuring segregation of duties and documenting any discrepancies in reconciliations to enhance accountability and compliance.

Finding Text

Finding 2024-001: Cash Management Federal Agency: U.S. Department of Education Federal Program: Federal Direct Student Loans (ALN 84.268) Award Year: September 1, 2023 to August 31, 2024Criteria or Specific Requirement Per 2 CFR 200.303, a non-Federal entity must 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. Per 34 CFR 685.300(b)(50), schools participating in the Direct Loan program are required to perform monthly Direct Loan reconciliations. Electronic Announcements DL-22-07 and GENERAL-22-86 explain that a school must reconcile the funds it received from G5 with actual disbursement records the school submitted to Common Origination and Disbursement (COD). Each month, COD sends the school a School Account Statement, which is the Department of Education’s (ED’s) official record of the school’s cash and disbursement records and identifies the difference between the net draws from G5 and the actual disbursement information reported to COD by the school. The school is required to account for any differences by reconciling ED’s records (School Account Statements) with the school’s financial and business records. Condition Found The reconciliation between ED’s records (School Account Statements) and the school’s financial and business records were prepared timely throughout the year; however, the differences identified in the reconciliation were not accounted for and no review or segregation of duties was documented as part of that process. Cause and Possible Asserted Effect The control to ensure that the reconciliation between the ED’s records and the school’s financial and business records was performed and reviewed by an individual separate than that who prepared it and that any differences identified were investigated was not operating effectively. As a result and based on the documentation provided, the monthly reconciliations were not reviewed by an individual separate than that who prepared them and any differences identified during the reconciliation process were not investigated. Questioned Costs None. Whether the Sample Was a Statistically Valid Sample The sample was not intended to be, and was not, a statistically valid sample. Identification of Whether the Audit Finding Was a Repeat Finding in the Immediately Prior Audit Not at repeat finding. Recommendation We recommend that the University strengthen controls over the management review process over the monthly reconciliations between the ED’s records and the school’s financial and business records to ensure there is a segregation of duties in the review and approval process, and any differences within management’s prescribed level of precision are investigated and documented.View of Responsible Officials The finding was primarily caused by an unforeseen staff shortage. This led to one person being the preparer and reviewer with no segregation of duties. Although the differences were identified, they were not documented on the reconciliation form. To resolve this finding, the Office of Financial Aid (OFA) has hired new employees and implemented a new process. The Financial Operations Team is now fully staffed with two senior accountants and one senior director. As part of our ongoing efforts to strengthen internal controls and ensure the integrity of our processes, we have implemented a segregation of duties framework. This approach will help us clearly define roles and responsibilities, ensuring that critical tasks are divided among different individuals. By doing so, we will meet compliance requirements, reduce errors, and promote accountability within our office. One senior accountant will prepare the monthly reconciliation by the 10th of the following month. The senior director will review the monthly reconciliation by the 15th of the following month. In the absence of the initial preparer/reviewer, the executive director of OFA will take on the reviewer role. We understand that proper documentation is crucial for clarity, tracking, and future troubleshooting. The differences/discrepancies that are identified in the reconciliation process will be accounted for through proper documentation on the reconciliation form, which will be reviewed/investigated by a second reviewer. The Financial Operations Team within the OFA will continue to create timely and accurate monthly Federal Direct Student Loan reconciliations that compare OPUS (Emory), General Ledger (Emory), Student Account Statement-SAS (U.S. Department of Education), and GS (U.S. Department of Education).

Categories

Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties Student Financial Aid Cash Management

Other Findings in this Audit

  • 561271 2024-001
    Significant Deficiency
  • 1137713 2024-001
    Significant Deficiency
  • 1137714 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $90.97M
93.939 Hiv Prevention Activities Non-Governmental Organization Based $16.61M
84.063 Federal Pell Grant Program $9.27M
93.384 Advanced Research Projects Agency for Health (arpa-H) $6.53M
93.317 Emerging Infections Programs $5.42M
21.027 Coronavirus State and Local Fiscal Recovery Funds $3.00M
93.945 Assistance Programs for Chronic Disease Prevention and Control $2.91M
10.937 Partnerships for Climate-Smart Commodities $2.88M
93.135 Centers for Research and Demonstration for Health Promotion and Disease Prevention $2.57M
84.038 Federal Perkins Loan Program_federal Capital Contributions $1.97M
84.033 Federal Work-Study Program $1.83M
93.318 Protecting and Improving Health Globally: Building and Strengthening Public Health Impact, Systems, Capacity and Security $1.82M
93.823 Public Health Response, Forecasting, and Analytic Capacities Related to Disease Outbreaks, Epidemics, and Pandemics $1.82M
93.914 Hiv Emergency Relief Project Grants $1.69M
93.U02 Contract $1.30M
93.516 Public Health Training Centers Program $1.25M
84.007 Federal Supplemental Educational Opportunity Grants $1.05M
93.364 Nursing Student Loans $857,948
93.264 Nurse Faculty Loan Program (nflp) $795,593
93.068 Chronic Diseases: Research, Control, and Prevention $686,879
93.918 Grants to Provide Outpatient Early Intervention Services with Respect to Hiv Disease $637,593
93.822 Health Careers Opportunity Program (hcop) $624,640
64.U05 Contract $616,290
47.083 Integrative Activities $612,640
93.912 Rural Health Care Services Outreach, Rural Health Network Development and Small Health Care Provider Quality Improvement $596,836
93.342 Health Professions Student Loans, Including Primary Care Loans and Loans for Disadvantaged Students $533,745
64.U03 Contract $475,570
98.001 Usaid Foreign Assistance for Programs Overseas $471,554
93.817 Hospital Preparedness Program (hpp) Ebola Preparedness and Response Activities $426,629
93.247 Advanced Nursing Education Workforce Grant Program $423,030
93.778 Medical Assistance Program $360,997
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $348,447
12.RD Contract $335,751
93.273 Alcohol Research Programs $328,609
93.359 Nurse Education, Practice Quality and Retention Grants $324,669
93.835 Planning Grant for Healthcare and Public Health Sector Cybersecurity Information Sharing $316,937
93.825 National Ebola Training and Education Center (netec) $302,536
93.U04 Contract $287,569
81.049 Office of Science Financial Assistance Program $279,554
93.136 Injury Prevention and Control Research and State and Community Based Programs $267,908
93.856 Microbiology and Infectious Diseases Research $255,950
93.850 Improving Epilepsy Programs, Services, and Outcomes Through National Partnerships $245,275
20.616 National Priority Safety Programs $239,126
84.324 Research in Special Education $238,093
12.630 Basic, Applied, and Advanced Research in Science and Engineering $236,249
66.RD Contract $228,913
93.670 Child Abuse and Neglect Discretionary Activities $217,225
12.800 Uniformed Services University Medical Research Projects $215,741
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $214,962
93.398 Cancer Research Manpower $185,868
93.889 National Bioterrorism Hospital Preparedness Program $184,113
64.U01 Contract $180,471
93.732 Mental and Behavioral Health Education and Training Grants $174,656
93.225 National Research Service Awards Health Services Research Training $172,550
64.U02 Contract $169,128
93.493 Congressional Directives $168,221
93.632 University Centers for Excellence in Developmental Disabilities Education, Research, and Service $166,748
93.083 Prevention of Disease, Disability, and Death Through Immunization and Control of Respiratory and Related Diseases $159,670
93.988 Cooperative Agreements for Diabetes Control Programs $157,730
93.368 21st Century Cures Act - Precision Medicine Initiative $154,100
93.352 Construction Support $151,682
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $151,416
47.074 Biological Sciences $150,941
93.399 Cancer Control $150,874
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $147,685
93.353 22nd Century Cures Act - Beau Biden Cancer Moonshot $143,563
93.310 Trans-Nih Research Support $136,370
93.084 Prevention of Disease, Disability, and Death by Infectious Diseases $134,807
93.121 Oral Diseases and Disorders Research $129,859
93.161 Health Program for Toxic Substances and Disease Registry $126,329
93.361 Nursing Research $124,146
16.045 Community-Based Violence Intervention and Prevention Initiative $122,048
93.353 21st Century Cures Act - Beau Biden Cancer Moonshot $119,663
93.590 Community-Based Child Abuse Prevention Grants $118,908
43.001 Science $113,835
97.061 Centers for Homeland Security $112,607
47.050 Geosciences $109,811
93.879 Medical Library Assistance $102,956
93.211 Telehealth Programs $101,187
93.172 Human Genome Research $100,554
93.360 Biomedical Advanced Research and Development Authority (barda), Biodefense Medical Countermeasure Development $98,395
93.143 Niehs Superfund Hazardous Substances_basic Research and Education $98,159
84.116 Fund for the Improvement of Postsecondary Education $91,334
10.215 Sustainable Agriculture Research and Education $89,731
93.365 Sickle Cell Treatment Demonstration Program $88,523
10.310 Agriculture and Food Research Initiative (afri) $85,524
93.389 National Center for Research Resources $81,027
93.426 The National Cardiovascular Health Program $78,774
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $76,802
93.353 23rd Century Cures Act - Beau Biden Cancer Moonshot $74,059
93.387 National and State Tobacco Control Program $70,617
64.056 Legal Services for Veterans Grants $67,562
19.010 Academic Exchange Programs - Hubert H. Humphrey Fellowship Program $63,883
93.959 Block Grants for Prevention and Treatment of Substance Abuse $62,687
93.943 Epidemiologic Research Studies of Acquired Immunodeficiency Syndrome (aids) and Human Immunodeficiency Virus (hiv) Infection in Selected Population Groups $62,674
19.900 Aeeca/esf Pd Programs $62,244
93.837 Cardiovascular Diseases Research $61,718
12.900 Language Grant Program $61,547
93.994 Maternal and Child Health Services Block Grant to the States $59,998
93.137 Community Programs to Improve Minority Health $58,119
93.124 Nurse Anesthetist Traineeship $56,382
66.951 Environmental Education Grants Program $53,891
93.351 Research Infrastructure Programs $52,977
15.662 Great Lakes Restoration $52,885
93.326 Strengthening Public Health Through Surveillance, Epidemiologic Research, Disease Detection and Prevention $52,000
66.511 Office of Research and Development Consolidated Research/training/fellowships $51,769
11.020 Cluster Grants $51,570
93.U05 Contract $51,467
93.397 Cancer Centers Support Grants $51,389
93.978 Sexually Transmitted Diseases (std) Provider Education Grants $50,831
93.255 Children's Hospitals Graduate Medical Education Payment Program $49,660
93.350 National Center for Advancing Translational Sciences $45,615
93.353 24th Century Cures Act - Beau Biden Cancer Moonshot $44,495
43.002 Aeronautics $41,389
93.431 Networking2save”: Cdc’s National Network Approach to Preventing and Controlling Tobacco-Related Cancers in Special Populations $40,422
47.070 Computer and Information Science and Engineering $40,251
93.110 Maternal and Child Health Federal Consolidated Programs $38,043
93.838 Lung Diseases Research $37,278
93.393 Cancer Cause and Prevention Research $34,019
93.456 Cdc Undergraduate Public Health Scholars Program (cups): A Public Health Experience to Expose Undergraduates Interested in Minority Health to Public Health and the Public Health Professions $33,729
12.300 Basic and Applied Scientific Research $33,283
93.088 Advancing System Improvements for Key Issues in Women's Health $32,318
12.750 Uniformed Services University Medical Research Projects $32,297
10.164 Wholesale Farmers and Alternative Market Development $32,114
47.041 Engineering $29,000
43.003 Exploration $26,229
47.078 Polar Programs $24,797
16.560 National Institute of Justice Research, Evaluation, and Development Project Grants $23,812
93.396 Cancer Biology Research $22,992
66.808 Solid Waste Management Assistance Grants $22,170
93.213 Research and Training in Complementary and Integrative Health $21,914
93.262 Occupational Safety and Health Program $20,805
93.435 The Innovative Cardiovascular Health Program $20,550
10.001 Agricultural Research Basic and Applied Research $20,378
93.307 Minority Health and Health Disparities Research $19,095
93.052 National Family Caregiver Support, Title Iii, Part E $18,756
47.076 Stem Education (formerly Education and Human Resources) $18,401
93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research $17,293
84.022 Overseas Programs - Doctoral Dissertation Research Abroad $17,154
93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders $16,432
47.075 Social, Behavioral, and Economic Sciences $16,153
93.846 Arthritis, Musculoskeletal and Skin Diseases Research $13,234
45.024 Promotion of the Arts Grants to Organizations and Individuals $13,234
45.161 Promotion of the Humanities Research $11,137
93.261 Scaling the National Diabetes Prevention Program to Priority Populations $10,816
93.989 International Research and Research Training $10,171
93.788 Opioid Str $10,057
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $9,972
93.077 Birth Defects and Developmental Disabilities - Prevention and Surveillance $9,276
47.084 Nsf Technology, Innovation, and Partnerships $8,999
93.738 Pphf: Racial and Ethnic Approaches to Community Health Program Financed Solely by Public Prevention and Health Funds $8,899
93.113 Environmental Health $8,227
93.840 Translation and Implementation Science Research for Heart, Lung, Blood Diseases, and Sleep Disorders $8,114
93.226 Research on Healthcare Costs, Quality and Outcomes $7,997
93.334 The Healthy Brain Initiative: Technical Assistance to Implement Public Health Actions Related to Cognitive Health, Cognitive Impairment, and Caregiving at the State and Local Levels $7,641
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $6,560
64.U04 Contract $6,224
93.941 Hiv Demonstration, Research, Public and Professional Education Projects $6,025
93.283 Centers for Disease Control and Prevention Investigations and Technical Assistance $6,000
93.860 Emerging Infections Sentinel Networks $5,826
93.073 Birth Defects and Developmental Disabilities - Prevention and Surveillance $4,605
93.394 Cancer Detection and Diagnosis Research $4,352
93.080 Blood Disorder Program: Prevention, Surveillance, and Research $3,711
81.RD Contract $3,014
20.RD Contract $2,806
93.103 Food and Drug Administration Research $2,595
10.RD Contract $2,339
93.643 Children's Justice Grants to States $1,543
45.163 Promotion of the Humanities Professional Development $1,375
93.U01 Contract $1,321
93.U03 Contract $1,317
93.145 Hiv-Related Training and Technical Assistance $1,272
45.149 Promotion of the Humanities Division of Preservation and Access $925
47.079 Office of International Science and Engineering $296
93.969 Pphf Geriatric Education Centers $130
12.910 Research and Technology Development $75
93.233 National Center on Sleep Disorders Research $54
93.395 Cancer Treatment Research $-16
12.351 Scientific Research - Combating Weapons of Mass Destruction $-71
93.898 Cancer Prevention and Control Programs for State, Territorial and Tribal Organizations $-302
93.865 Child Health and Human Development Extramural Research $-677
93.859 Biomedical Research and Research Training $-1,331
93.185 Immunization Research, Demonstration, Public Information and Education Training and Clinical Skills Improvement Projects $-1,570
47.049 Mathematical and Physical Sciences $-1,913
93.866 Aging Research $-1,959
93.127 Emergency Medical Services for Children $-2,278
93.242 Mental Health Research Grants $-2,745
93.867 Vision Research $-2,990
12.431 Basic Scientific Research $-3,296
93.RD Contract $-4,612
93.839 Blood Diseases and Resources Research $-8,439
66.509 Science to Achieve Results (star) Research Program $-13,899
98.002 Cooperative Development Program (cdp) $-15,099
12.420 Military Medical Research and Development $-15,453
93.855 Allergy and Infectious Diseases Research $-17,515
93.173 Research Related to Deafness and Communication Disorders $-25,355
93.279 Drug Use and Addiction Research Programs $-149,559