Finding 1216302 (2024-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2026-06-01

AI Summary

  • Core Issue: The Medical Center lacks formal documentation to verify that actual employee hours worked align with budgeted hours for federal grants.
  • Impacted Requirements: This situation violates 2 CFR §200.430(i), which mandates accurate records for compensation based on actual work performed.
  • Recommended Follow-Up: Update policies to include a formal review process for employee hours, ensuring alignment with budgeted hours and compliance with federal requirements.

Finding Text

Agency: U.S. Department of Health and Human Services, U.S. Department of Defense, and U.S. Department of the Treasury, Federal Assistance Listing Number: Various under Research and Development cluster; 21.027 COVID-19 Coronavirus State and Local Fiscal Recovery Funds Award Year: 2024 Pass-Through Entity: University of Vermont, Boston Children’s Hospital, University of North Carolina, Boston Children’s Hospital, University of Connecticut Health Center, Duke University, Redeemer’s University, Oregon Health & Science University, University of Connecticut - Storrs, University of Connecticut Health Center, Public Health Institute, Baylor College of Medicine, Rutgers University, Cincinnati Children’s Hospital Medical Center, Children’s Hospital of Los Angeles, Seattle Children’s, State of Connecticut Judicial Branch, City of Hartford, State of Connecticut Department of Public Health, State of Connecticut Department of Social Services, State of Connecticut Department of Mental Health and Addiction Services Criteria: In accordance with 2 CFR §200.430(i) of the Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance), compensation for personal services charged to federal awards must be based on records that accurately reflect the work performed. When budget estimates are used for interim accounting purposes, they must: produce reasonable approximations of the activity actually performed, be reconciled to actual effort on a regular basis, and be adjusted in a timely manner to reflect significant changes in work activity. Documentation may include timesheets, effort certifications, payroll distribution reports, and other personnel activity records, and must be reviewed and approved by authorized personnel. Condition and Context: The Medical Center did not maintain formal documentation evidencing a hindsight review of employee working hours to verify alignment between actual hours worked and budgeted hours. While a time and effort reporting was lacking for the items included in our sample, there was evidence of work performed on the grants and the amounts allocated aligned closely to the budget. Questioned Costs: We were unable to quantify an amount of questioned costs. While a time and effort reporting was lacking for the items included in our sample, there was evidence of work performed on the grants and the amounts allocated aligned closely to the budget. Therefore, we were unable to quantify the amount of questioned costs. Cause: The Medical Center changed its procedures for documenting employee time allocations; however, formal processes were not established to document and regularly reconcile actual hours worked to budgeted allocations. As a result, hindsight reviews were not formally maintained to verify that payroll allocations were supported by employees’ actual work performed. Effect: The lack of documentation of hindsight review increases the risk of inaccurate payroll cost allocations and potential noncompliance with federal grant requirements. Recommendation: The Medical Center should update its policies and procedures to require and document a formal hindsight review of employee working hours. This review should verify that actual hours worked align with budgeted hours, particularly in cases where payroll costs are allocated across multiple grants. The updated procedures should include clear guidelines for conducting and retaining evidence of such reviews to support accurate cost allocations and ensure compliance with federal grant requirements.

Corrective Action Plan

Corrective Action Planned: Management acknowledges the finding related to the lack of formal documentation maintained evidencing a hindsight review of employee working hours to verify alignment between actual hours. The Effort Reporting requirement is now met with a revamped process that includes an updated institutional effort reporting policy and development of a newly developed effort reporting workflow that aligned with the relatively recent (April 2024) implementation of new ERP system Oracle. This new process applies to those team members who have effort either charged, in-kind or cost-shared, to a grant funded project. The new Effort Reporting workflow formally went live institution wide on 10/1/25, with a pilot implementation done in September 2025. Effort reporting is conducted monthly and requires a preview of all team members with effort allocated to grants from an automated report. Each report is reviewed for accuracy and then each line item is entered into a Smartsheet format for automated delivery of an individual effort report to each team member. A mid-month report is automated to flag and identify upcoming end dates of grant funding in preparation of the next month effort report. This midmonth review is necessary to adjust for any edits needed in preparation for the next month effort report workflow. In addition, the new process allows for follow up with escalation if individual effort report(s) are not signed by respective team member(s) within the prescribed monthly due date. Name(s) of Contact Person(s) Responsible for Corrective Action: Kimberly Davey, Director Office for Sponsored Programs Anticipated Completion Date: Completion 9/30/2025, active as of 10/01/2025

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1216269 2024-002
    Material Weakness Repeat
  • 1216270 2024-002
    Material Weakness Repeat
  • 1216271 2024-002
    Material Weakness Repeat
  • 1216272 2024-002
    Material Weakness Repeat
  • 1216273 2024-002
    Material Weakness Repeat
  • 1216274 2024-002
    Material Weakness Repeat
  • 1216275 2024-002
    Material Weakness Repeat
  • 1216276 2024-002
    Material Weakness Repeat
  • 1216277 2024-002
    Material Weakness Repeat
  • 1216278 2024-002
    Material Weakness Repeat
  • 1216279 2024-002
    Material Weakness Repeat
  • 1216280 2024-002
    Material Weakness Repeat
  • 1216281 2024-002
    Material Weakness Repeat
  • 1216282 2024-002
    Material Weakness Repeat
  • 1216283 2024-002
    Material Weakness Repeat
  • 1216284 2024-002
    Material Weakness Repeat
  • 1216285 2024-002
    Material Weakness Repeat
  • 1216286 2024-002
    Material Weakness Repeat
  • 1216287 2024-002
    Material Weakness Repeat
  • 1216288 2024-002
    Material Weakness Repeat
  • 1216289 2024-002
    Material Weakness Repeat
  • 1216290 2024-002
    Material Weakness Repeat
  • 1216291 2024-002
    Material Weakness Repeat
  • 1216292 2024-002
    Material Weakness Repeat
  • 1216293 2024-002
    Material Weakness Repeat
  • 1216294 2024-002
    Material Weakness Repeat
  • 1216295 2024-002
    Material Weakness Repeat
  • 1216296 2024-002
    Material Weakness Repeat
  • 1216297 2024-002
    Material Weakness Repeat
  • 1216298 2024-002
    Material Weakness Repeat
  • 1216299 2024-002
    Material Weakness Repeat
  • 1216300 2024-002
    Material Weakness Repeat
  • 1216301 2024-002
    Material Weakness Repeat
  • 1216303 2024-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.215 INNOVATIVE APPROACHES TO LITERACY; PROMISE NEIGHBORHOODS; FULL-SERVICE COMMUNITY SCHOOLS; AND CONGRESSIONALLY DIRECTED SPENDING FOR ELEMENTARY AND SECONDARY EDUCATION COMMUNITY PROJECTS $3.51M
93.847 DIABETES, DIGESTIVE, AND KIDNEY DISEASES EXTRAMURAL RESEARCH $2.04M
14.905 LEAD HAZARD REDUCTION DEMONSTRATION GRANT PROGRAM $1.52M
93.268 IMMUNIZATION COOPERATIVE AGREEMENTS $1.36M
20.600 STATE AND COMMUNITY HIGHWAY SAFETY $1.00M
14.913 HEALTHY HOMES PRODUCTION PROGRAM $825,746
16.575 CRIME VICTIM ASSISTANCE $373,719
93.153 COORDINATED SERVICES AND ACCESS TO RESEARCH FOR WOMEN, INFANTS, CHILDREN, AND YOUTH $347,961
93.838 LUNG DISEASES RESEARCH $300,990
93.645 STEPHANIE TUBBS JONES CHILD WELFARE SERVICES PROGRAM $229,934
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $156,483
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $138,474
93.242 MENTAL HEALTH RESEARCH GRANTS $116,638
93.914 HIV EMERGENCY RELIEF PROJECT GRANTS $107,775
93.398 CANCER RESEARCH MANPOWER $59,490
93.865 CHILD HEALTH AND HUMAN DEVELOPMENT EXTRAMURAL RESEARCH $59,164
93.226 RESEARCH ON HEALTHCARE COSTS, QUALITY AND OUTCOMES $58,047
93.855 ALLERGY AND INFECTIOUS DISEASES RESEARCH $48,558
93.421 STRENGTHENING PUBLIC HEALTH SYSTEMS AND SERVICES THROUGH NATIONAL PARTNERSHIPS TO IMPROVE AND PROTECT THE NATION’S HEALTH $30,891
93.994 MATERNAL AND CHILD HEALTH SERVICES BLOCK GRANT TO THE STATES $30,500
93.110 MATERNAL AND CHILD HEALTH FEDERAL CONSOLIDATED PROGRAMS $29,963
93.361 NURSING RESEARCH $26,893
93.853 EXTRAMURAL RESEARCH PROGRAMS IN THE NEUROSCIENCES AND NEUROLOGICAL DISORDERS $21,212
93.080 BLOOD DISORDER PROGRAM: PREVENTION, SURVEILLANCE, AND RESEARCH $17,928
93.846 ARTHRITIS, MUSCULOSKELETAL AND SKIN DISEASES RESEARCH $15,038
93.310 TRANS-NIH RESEARCH SUPPORT $13,915
93.940 HIV PREVENTION ACTIVITIES HEALTH DEPARTMENT BASED $8,235
93.395 CANCER TREATMENT RESEARCH $8,006
12.420 MILITARY MEDICAL RESEARCH AND DEVELOPMENT $4,933
93.191 GRADUATE PSYCHOLOGY EDUCATION $4,529
93.493 CONGRESSIONAL DIRECTIVES $83