Finding 15883 (2022-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
$1
Year
2022
Accepted
2023-06-29
Audit: 19521

AI Summary

  • Core Issue: Management lacked policies to certify 100% of employee effort on federal grants, leading to inaccurate payroll charges.
  • Impacted Requirements: Non-compliance with 2 CFR Section 200.303 and 45 CFR Appendix-IX, which mandate effective internal controls and accurate effort reporting.
  • Recommended Follow-Up: Update policies to ensure 100% effort certification, apply correct effort percentages, and enhance controls over payroll expense reviews.

Finding Text

Finding 2022-002 Identification of the federal program: R&D Cluster Federal Agency: U.S. Department of Health and Human Services Assistance Listing: 93.399 Award numbers: 5UG1CA189830-08, 5UG1CA189830-09 Criteria or specific requirement (including statutory, regulatory or other citation): 2 CFR Section 200.303 of the 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).? 45 CFR Appendix-IX-to-Part-75 I.2 (4) states: ?Preparation of Estimates of Effort: Where required under paragraph (3) above, estimates of effort spent by a member of the professional staff on each research agreement should be prepared by the individual who performed the services or by a responsible individual such as a department head or supervisor having first hand knowledge of the services performed on each research agreement. Estimates must show the allocation of effort between organized research and all other hospital activities in terms of the percentage of total effort devoted to each of the broad functional categories referred to in (2) above. The estimate of effort spent on a research agreement may include a reasonable amount of time spent in activities contributing and intimately related to work under the agreement, such as preparing and delivering special lectures about specific aspects of the ongoing research, writing research reports and articles, participating in appropriate research seminars, consulting with colleagues with respect to related research, and attending appropriate scientific meetings and conferences. The term ?all other hospital activities? would include departmental research, administration, committee work, and public services undertaken on behalf of the hospital.? Condition: Management did not have policies and procedures for the entire fiscal year to certify 100% of employee effort. Management did not consistently record salary expenses to R&D federal grants based on the effort that had been certified to the grant. Cause: Management does not have a sufficient understanding of the effort reporting requirements in 45 CFR Appendix-IX to Part-75 I.2. Management?s policy over effort reporting was not designed sufficiently to require 100% of an employee?s effort to be certified. Management?s review and approval of effort report was not precise enough to identify and correct errors in effort charged to the R&D federal grants. Effect or potential effect: If 100% of effort is not certified, effort charged to a federal grant may be inaccurate. The lack of precision of the review and approval of effort certification resulted in inaccurate payroll being recorded to the R&D federal grants. Questioned costs: $6,064; $4,422 related to payroll expense, $1,460 related to fringe benefits and $182 related to indirect costs. Context: In obtaining an understanding of Management?s process for charging payroll expense, we noted certain selections where the calculation for salary expense did not use the appropriate effort percentage or the base salary was incorrect. We tested 40 payroll transactions ($110,463) and identified seven exceptions. For the following transactions, the employees? salaries and related fringe and indirect costs were charged incorrectly to the grant. See Schedule of Findings and Questioned Costs for table. The total R&D Cluster expenditures reported on the SEFA are $3,578,529 for the year ended September 30, 2022, including payroll costs of $1,134,569, which represents 31.7% of total R&D Cluster expenditures. Identification as a repeat finding, if applicable: Partial repeat of finding 2021-006 Recommendation: Management should update its policies to require effort certifications to include 100% of each employee?s effort. In addition, Management should assess their effort calculations to ensure that the appropriate effort percentages are applied to total payroll expense. Management should design and implement more precise controls over the review of the payroll expense workbook used to determine salary expense. Views of responsible officials: On or before September 30, 2023, Management will review all time & effort reporting covering its fiscal year 2023 and implement updates to its certification reporting to ensure calculations are accurately derived and verified through independent review for 100% of each employee?s time and effort and ensure amounts charged to the grant in fiscal year 2023 are supported by these certified records.

Corrective Action Plan

? Finding 2022-002 ? On or before September 30, 2023, Management will review all time & effort reporting covering its fiscal year 2023 and implement updates to its certification reporting to ensure calculations are accurately derived and verified through independent review for 100% of each employee?s time and effort and ensure amounts charged to the grant in fiscal year 2023 are supported by these certified records. o Responsible Party: Peggy Wisher

Categories

Questioned Costs Reporting Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 15882 2022-001
    Material Weakness Repeat
  • 15884 2022-003
    Significant Deficiency Repeat
  • 15885 2022-001
    Material Weakness Repeat
  • 15886 2022-002
    Material Weakness Repeat
  • 15887 2022-003
    Significant Deficiency Repeat
  • 15888 2022-005
    Material Weakness Repeat
  • 15889 2022-004
    Material Weakness
  • 592324 2022-001
    Material Weakness Repeat
  • 592325 2022-002
    Material Weakness Repeat
  • 592326 2022-003
    Significant Deficiency Repeat
  • 592327 2022-001
    Material Weakness Repeat
  • 592328 2022-002
    Material Weakness Repeat
  • 592329 2022-003
    Significant Deficiency Repeat
  • 592330 2022-005
    Material Weakness Repeat
  • 592331 2022-004
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.498 Covid-19 Provider Relief Fund and American Rescue Plan (arp) Rural Distribution $17.59M
97.036 Covid-19 Disaster Grants - Public Assistance (presidentially Declared Disasters) $5.95M
93.155 Covid-19 Rural Health Research Centers $180,886
93.461 Covid-19 Hrsa Covid-19 Claims Reimbursement for the Uninsured Program and the Covid-19 Coverage Assistance Fund $65,788
10.558 Child and Adult Care Food Program $27,138
93.399 Cancer Control $13,460
93.155 Rural Health Research Centers $5,759
93.426 Prevention and Management of Diabetes and Heart Disease and Stroke Program $1,500