Finding 979428 (2023-004)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2024-06-26
Audit: 310163
Organization: Mayo Clinic (MN)

AI Summary

  • Core Issue: Internal controls for effort reporting and salary cap adjustments were ineffective from April to December 2023, leading to potential mismanagement of payroll costs.
  • Impacted Requirements: Compliance with federal and state internal control standards under Sections 200.303 and 215.97 was not met, risking unallowable costs being charged to federal and state projects.
  • Recommended Follow-Up: Ensure monthly effort report certifications are completed and review the payroll salary cap application to confirm accurate calculations moving forward.

Finding Text

Activities Allowed or Unallowed and Allowable Costs/Cost Principles Identification of the federal program: Federal Agencies: U.S. Department of Health and Human Services and U.S. Department of Defense Pass-Through Entities: Boston University, Georgia Institute of Technology, Massachusetts General Hospital, NYU Grossman School of Medicine, Stanford University, The University of Texas, University of Buffalo, University of Chicago, and Washington University Federal Cluster: Research and Development (R&D) Assistance Listing Nos.: 12.300, 12.420, 93.233, 93.273, 93.279, 93.310, 93.350, 93.393, 93.395, 93.396, 93.397, 93.837, 93.838, 93.846, 93.847, 93.853, 93.855, 93.859, 93.865, and 93.866 Award Numbers: Various Award Periods: Various Identification of the state projects: State Grantor: State of Florida Department of Health (DOH) Catalog of State Financial Assistance (CSFA) No.: 64.130, Endowed Chair for Cancer Research Award Number: MOG07 Award Period: July 1, 2014 – until expended State Grantor: State of Florida Department of Health (DOH) Catalog of State Financial Assistance (CSFA) No.: 64.135, Ed and Ethel Moore Alzheimer’s Disease Research Program Award Numbers: 20A10, 22A04, 22A05, 22A06, 22A07, 22A08, 22A09, 22K01, 23A03, 23A04, and 23K09 Award Periods: Various Criteria or specific requirement (including statutory, regulatory or other citation): Section 200.303 of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance) states the following regarding internal control: “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).” Section 215.97, Florida Single Audit Act, part (2)(j) states, “Internal control over state projects means a process, effected by a nonstate entity’s management and other personnel, designed to provide reasonable assurance regarding the achievement of objectives in the following categories: 1. Effectiveness and efficiency of operations. 2. Reliability of financial operations. 3. Compliance with applicable laws and regulations.” Condition: Internal controls over effort reporting were not operating effectively from April 1, 2023 through May 31, 2023 and, therefore, could not be relied upon. Internal controls over salary cap were not operating effectively from April 1, 2023 through December 31, 2023 and therefore, could not be relied upon. Cause: The Clinic implemented a new general ledger system effective April 1, 2023. The general ledger implementation necessitated a rewrite of the effort certification system which delayed certification for the months of April and May. Therefore, for the period April 1, 2023 through May 31, 2023, effort certifications were not performed monthly. The information technology application used to calculate salary cap adjustments to salary expenses resulting from the effort certification process was not functioning as designed from April 1, 2023 through December 31, 2023. Effect or potential effect: Salary cap adjustments to payroll costs charged to the federal program may not be recorded timely. Unallowable payroll costs may be charged to the federal program or state project. Questioned costs: None. Context: Payroll and fringe benefit expenditures are $163,912,932, representing 36.8% of total Federal expenditures for the R&D Cluster of $445,961,340 for the year ended December 31, 2023. Payroll and fringe benefit expenditures are $289,963, representing 30.8% of total state expenditures for CSFA 64.130 of $940,679 for the year ended December 31, 2023. Payroll and fringe benefit expenditures are $551,321, representing 67.5% of total state expenditures for CSFA 64.135 of $816,958 for the year ended December 31, 2023. Identification as a repeat finding, if applicable: This finding is not a repeat finding from the prior year. Recommendation: Management should ensure effort report certifications and approvals are performed monthly. In addition, management should review the design of the payroll salary cap application to ensure it is appropriately calculating salary expenses during the effort certification process. Views of responsible officials: Effort certification was delayed for the months of April and May 2023. No certification periods in 2023 were missed and the effort certification system is operating as designed as of July 17, 2023. Manual reconciliations of the salary cap application were performed on every award for fiscal year 2023 to ensure salaries were correctly charged. The salary cap application is working effectively as of January 1, 2024.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 402904 2023-002
    Material Weakness Repeat
  • 402905 2023-003
    Material Weakness
  • 402906 2023-004
    Material Weakness
  • 402907 2023-004
    Material Weakness
  • 402908 2023-005
    Significant Deficiency
  • 402909 2023-002
    Material Weakness Repeat
  • 402910 2023-004
    Material Weakness
  • 402911 2023-002
    Material Weakness Repeat
  • 402912 2023-004
    Material Weakness
  • 402913 2023-002
    Material Weakness Repeat
  • 402914 2023-004
    Material Weakness
  • 402915 2023-003
    Material Weakness
  • 402916 2023-004
    Material Weakness
  • 402917 2023-002
    Material Weakness Repeat
  • 402918 2023-004
    Material Weakness
  • 402919 2023-005
    Significant Deficiency
  • 402920 2023-002
    Material Weakness Repeat
  • 402921 2023-004
    Material Weakness
  • 402922 2023-002
    Material Weakness Repeat
  • 402923 2023-004
    Material Weakness
  • 402924 2023-002
    Material Weakness Repeat
  • 402925 2023-004
    Material Weakness
  • 402926 2023-002
    Material Weakness Repeat
  • 402927 2023-004
    Material Weakness
  • 402928 2023-005
    Significant Deficiency
  • 402929 2023-002
    Material Weakness Repeat
  • 402930 2023-003
    Material Weakness
  • 402931 2023-004
    Material Weakness
  • 402932 2023-005
    Significant Deficiency
  • 402933 2023-002
    Material Weakness Repeat
  • 402934 2023-004
    Material Weakness
  • 402935 2023-002
    Material Weakness Repeat
  • 402936 2023-004
    Material Weakness
  • 402937 2023-002
    Material Weakness Repeat
  • 402938 2023-004
    Material Weakness
  • 402939 2023-004
    Material Weakness
  • 402940 2023-002
    Material Weakness Repeat
  • 402941 2023-004
    Material Weakness
  • 402942 2023-003
    Material Weakness
  • 402943 2023-002
    Material Weakness Repeat
  • 402944 2023-004
    Material Weakness
  • 402945 2023-002
    Material Weakness Repeat
  • 402946 2023-004
    Material Weakness
  • 402947 2023-004
    Material Weakness
  • 402948 2023-004
    Material Weakness
  • 402949 2023-002
    Material Weakness Repeat
  • 402950 2023-004
    Material Weakness
  • 402951 2023-004
    Material Weakness
  • 402952 2023-002
    Material Weakness Repeat
  • 402953 2023-004
    Material Weakness
  • 402954 2023-003
    Material Weakness
  • 402955 2023-002
    Material Weakness Repeat
  • 402956 2023-004
    Material Weakness
  • 402957 2023-002
    Material Weakness Repeat
  • 402958 2023-004
    Material Weakness
  • 402959 2023-002
    Material Weakness Repeat
  • 402960 2023-004
    Material Weakness
  • 402961 2023-002
    Material Weakness Repeat
  • 402962 2023-004
    Material Weakness
  • 402963 2023-002
    Material Weakness Repeat
  • 402964 2023-004
    Material Weakness
  • 402965 2023-004
    Material Weakness
  • 402966 2023-003
    Material Weakness
  • 402967 2023-005
    Significant Deficiency
  • 402968 2023-002
    Material Weakness Repeat
  • 402969 2023-004
    Material Weakness
  • 402970 2023-002
    Material Weakness Repeat
  • 402971 2023-004
    Material Weakness
  • 402972 2023-002
    Material Weakness Repeat
  • 402973 2023-003
    Material Weakness
  • 402974 2023-004
    Material Weakness
  • 402975 2023-002
    Material Weakness Repeat
  • 402976 2023-004
    Material Weakness
  • 402977 2023-002
    Material Weakness Repeat
  • 402978 2023-004
    Material Weakness
  • 402979 2023-002
    Material Weakness Repeat
  • 402980 2023-004
    Material Weakness
  • 402981 2023-003
    Material Weakness
  • 402982 2023-004
    Material Weakness
  • 402983 2023-002
    Material Weakness Repeat
  • 402984 2023-004
    Material Weakness
  • 402985 2023-002
    Material Weakness Repeat
  • 402986 2023-004
    Material Weakness
  • 402987 2023-002
    Material Weakness Repeat
  • 402988 2023-004
    Material Weakness
  • 402989 2023-002
    Material Weakness Repeat
  • 402990 2023-004
    Material Weakness
  • 402991 2023-002
    Material Weakness Repeat
  • 402992 2023-004
    Material Weakness
  • 402993 2023-002
    Material Weakness Repeat
  • 402994 2023-004
    Material Weakness
  • 402995 2023-002
    Material Weakness Repeat
  • 402996 2023-004
    Material Weakness
  • 402997 2023-004
    Material Weakness
  • 402998 2023-002
    Material Weakness Repeat
  • 402999 2023-004
    Material Weakness
  • 403000 2023-002
    Material Weakness Repeat
  • 403001 2023-004
    Material Weakness
  • 403002 2023-004
    Material Weakness
  • 403003 2023-002
    Material Weakness Repeat
  • 403004 2023-004
    Material Weakness
  • 403005 2023-002
    Material Weakness Repeat
  • 403006 2023-004
    Material Weakness
  • 403007 2023-002
    Material Weakness Repeat
  • 403008 2023-004
    Material Weakness
  • 403009 2023-004
    Material Weakness
  • 403010 2023-002
    Material Weakness Repeat
  • 403011 2023-004
    Material Weakness
  • 403012 2023-004
    Material Weakness
  • 403013 2023-005
    Significant Deficiency
  • 403014 2023-004
    Material Weakness
  • 403015 2023-004
    Material Weakness
  • 403016 2023-002
    Material Weakness Repeat
  • 403017 2023-004
    Material Weakness
  • 403018 2023-002
    Material Weakness Repeat
  • 403019 2023-004
    Material Weakness
  • 403020 2023-001
    Significant Deficiency
  • 979346 2023-002
    Material Weakness Repeat
  • 979347 2023-003
    Material Weakness
  • 979348 2023-004
    Material Weakness
  • 979349 2023-004
    Material Weakness
  • 979350 2023-005
    Significant Deficiency
  • 979351 2023-002
    Material Weakness Repeat
  • 979352 2023-004
    Material Weakness
  • 979353 2023-002
    Material Weakness Repeat
  • 979354 2023-004
    Material Weakness
  • 979355 2023-002
    Material Weakness Repeat
  • 979356 2023-004
    Material Weakness
  • 979357 2023-003
    Material Weakness
  • 979358 2023-004
    Material Weakness
  • 979359 2023-002
    Material Weakness Repeat
  • 979360 2023-004
    Material Weakness
  • 979361 2023-005
    Significant Deficiency
  • 979362 2023-002
    Material Weakness Repeat
  • 979363 2023-004
    Material Weakness
  • 979364 2023-002
    Material Weakness Repeat
  • 979365 2023-004
    Material Weakness
  • 979366 2023-002
    Material Weakness Repeat
  • 979367 2023-004
    Material Weakness
  • 979368 2023-002
    Material Weakness Repeat
  • 979369 2023-004
    Material Weakness
  • 979370 2023-005
    Significant Deficiency
  • 979371 2023-002
    Material Weakness Repeat
  • 979372 2023-003
    Material Weakness
  • 979373 2023-004
    Material Weakness
  • 979374 2023-005
    Significant Deficiency
  • 979375 2023-002
    Material Weakness Repeat
  • 979376 2023-004
    Material Weakness
  • 979377 2023-002
    Material Weakness Repeat
  • 979378 2023-004
    Material Weakness
  • 979379 2023-002
    Material Weakness Repeat
  • 979380 2023-004
    Material Weakness
  • 979381 2023-004
    Material Weakness
  • 979382 2023-002
    Material Weakness Repeat
  • 979383 2023-004
    Material Weakness
  • 979384 2023-003
    Material Weakness
  • 979385 2023-002
    Material Weakness Repeat
  • 979386 2023-004
    Material Weakness
  • 979387 2023-002
    Material Weakness Repeat
  • 979388 2023-004
    Material Weakness
  • 979389 2023-004
    Material Weakness
  • 979390 2023-004
    Material Weakness
  • 979391 2023-002
    Material Weakness Repeat
  • 979392 2023-004
    Material Weakness
  • 979393 2023-004
    Material Weakness
  • 979394 2023-002
    Material Weakness Repeat
  • 979395 2023-004
    Material Weakness
  • 979396 2023-003
    Material Weakness
  • 979397 2023-002
    Material Weakness Repeat
  • 979398 2023-004
    Material Weakness
  • 979399 2023-002
    Material Weakness Repeat
  • 979400 2023-004
    Material Weakness
  • 979401 2023-002
    Material Weakness Repeat
  • 979402 2023-004
    Material Weakness
  • 979403 2023-002
    Material Weakness Repeat
  • 979404 2023-004
    Material Weakness
  • 979405 2023-002
    Material Weakness Repeat
  • 979406 2023-004
    Material Weakness
  • 979407 2023-004
    Material Weakness
  • 979408 2023-003
    Material Weakness
  • 979409 2023-005
    Significant Deficiency
  • 979410 2023-002
    Material Weakness Repeat
  • 979411 2023-004
    Material Weakness
  • 979412 2023-002
    Material Weakness Repeat
  • 979413 2023-004
    Material Weakness
  • 979414 2023-002
    Material Weakness Repeat
  • 979415 2023-003
    Material Weakness
  • 979416 2023-004
    Material Weakness
  • 979417 2023-002
    Material Weakness Repeat
  • 979418 2023-004
    Material Weakness
  • 979419 2023-002
    Material Weakness Repeat
  • 979420 2023-004
    Material Weakness
  • 979421 2023-002
    Material Weakness Repeat
  • 979422 2023-004
    Material Weakness
  • 979423 2023-003
    Material Weakness
  • 979424 2023-004
    Material Weakness
  • 979425 2023-002
    Material Weakness Repeat
  • 979426 2023-004
    Material Weakness
  • 979427 2023-002
    Material Weakness Repeat
  • 979429 2023-002
    Material Weakness Repeat
  • 979430 2023-004
    Material Weakness
  • 979431 2023-002
    Material Weakness Repeat
  • 979432 2023-004
    Material Weakness
  • 979433 2023-002
    Material Weakness Repeat
  • 979434 2023-004
    Material Weakness
  • 979435 2023-002
    Material Weakness Repeat
  • 979436 2023-004
    Material Weakness
  • 979437 2023-002
    Material Weakness Repeat
  • 979438 2023-004
    Material Weakness
  • 979439 2023-004
    Material Weakness
  • 979440 2023-002
    Material Weakness Repeat
  • 979441 2023-004
    Material Weakness
  • 979442 2023-002
    Material Weakness Repeat
  • 979443 2023-004
    Material Weakness
  • 979444 2023-004
    Material Weakness
  • 979445 2023-002
    Material Weakness Repeat
  • 979446 2023-004
    Material Weakness
  • 979447 2023-002
    Material Weakness Repeat
  • 979448 2023-004
    Material Weakness
  • 979449 2023-002
    Material Weakness Repeat
  • 979450 2023-004
    Material Weakness
  • 979451 2023-004
    Material Weakness
  • 979452 2023-002
    Material Weakness Repeat
  • 979453 2023-004
    Material Weakness
  • 979454 2023-004
    Material Weakness
  • 979455 2023-005
    Significant Deficiency
  • 979456 2023-004
    Material Weakness
  • 979457 2023-004
    Material Weakness
  • 979458 2023-002
    Material Weakness Repeat
  • 979459 2023-004
    Material Weakness
  • 979460 2023-002
    Material Weakness Repeat
  • 979461 2023-004
    Material Weakness
  • 979462 2023-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $18.06M
93.350 National Center for Advancing Translational Sciences $833,697
93.068 Chronic Diseases: Research, Control, and Prevention $752,871
93.947 Tuberculosis Demonstration, Research, Public and Professional Education $673,001
21.027 Covid-19 Coronavirus State and Local Fiscal Recovery Funds $630,889
93.840 Translation and Implementation Science Research for Heart, Lung, Blood Diseases, and Sleep Disorders $596,879
93.397 Cancer Centers Support Grants $372,428
14.157 Supportive Housing for the Elderly $302,998
93.273 Alcohol Research Programs $280,983
93.RD Contract $266,975
93.839 Blood Diseases and Resources Research $257,935
93.361 Nursing Research $234,881
93.U01 Military Health Professions Scholarships $219,135
93.351 Research Infrastructure Programs $210,619
47.070 Computer and Information Science and Engineering $198,119
93.917 Hiv Care Formula Grants $181,596
12.750 Uniformed Services University Medical Research Projects $176,257
93.242 Mental Health Research Grants $161,880
93.847 Diabetes, Digestive, and Kidney Diseases Extramural Research $156,484
12.RD Contract $133,212
93.837 Cardiovascular Diseases Research $126,119
93.268 Immunization Cooperative Agreements $114,649
93.433 Acl National Institute on Disability, Independent Living, and Rehabilitation Research $108,398
93.889 National Bioterrorism Hospital Preparedness Program $102,051
12.910 Research and Technology Development $97,769
93.083 Prevention of Disease, Disability, and Death Through Immunization and Control of Respiratory and Related Diseases $97,084
16.575 Crime Victim Assistance $93,603
14.871 Section 8 Housing Choice Vouchers $81,532
93.172 Human Genome Research $80,488
93.859 Biomedical Research and Research Training $72,531
93.113 Environmental Health $64,479
93.121 Oral Diseases and Disorders Research $63,259
16.560 National Institute of Justice Research, Evaluation, and Development Project Grants $61,857
93.310 Trans-Nih Research Support $57,772
93.103 Food and Drug Administration_research $56,936
47.074 Biological Sciences $54,543
93.318 Protecting and Improving Health Globally: Building and Strengthening Public Health Impact, Systems, Capacity and Security $52,355
93.394 Cancer Detection and Diagnosis Research $52,086
93.879 Medical Library Assistance $43,007
93.307 Minority Health and Health Disparities Research $40,269
93.399 Cancer Control $38,218
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $37,947
93.855 Allergy and Infectious Diseases Research $34,361
93.233 National Center on Sleep Disorders Research $32,079
93.279 Drug Abuse and Addiction Research Programs $29,869
93.838 Lung Diseases Research $29,642
93.110 Maternal and Child Health Federal Consolidated Programs $28,219
93.084 Prevention of Disease, Disability, and Death by Infectious Diseases $26,058
93.866 Aging Research $25,443
84.063 Federal Pell Grant Program $21,084
93.134 Grants to Increase Organ Donations $20,030
93.080 Blood Disorder Program: Prevention, Surveillance, and Research $19,590
93.393 Cancer Cause and Prevention Research $18,827
64.RD Contract $18,387
93.853 Extramural Research Programs in the Neurosciences and Neurological Disorders $15,989
93.226 Research on Healthcare Costs, Quality and Outcomes $15,212
93.173 Research Related to Deafness and Communication Disorders $14,198
47.049 Mathematical and Physical Sciences $13,338
93.396 Cancer Biology Research $11,790
93.354 Public Health Emergency Response: Cooperative Agreement for Emergency Response: Public Health Crisis Response $11,769
93.398 Cancer Research Manpower $9,540
12.300 Basic and Applied Scientific Research $7,262
93.865 Child Health and Human Development Extramural Research $6,277
93.213 Research and Training in Complementary and Integrative Health $5,592
93.989 International Research and Research Training $4,316
47.076 Stem Education (formerly Education and Human Resources) $4,287
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $4,164
93.846 Arthritis, Musculoskeletal and Skin Diseases Research $3,379
47.041 Engineering $888
93.867 Vision Research $314
12.420 Military Medical Research and Development $239
93.353 21st Century Cures Act - Beau Biden Cancer Moonshot $174
93.395 Cancer Treatment Research $81
43.001 Science $27