Finding 1160856 (2025-004)

Material Weakness Repeat Finding
Requirement
A
Questioned Costs
$1
Year
2025
Accepted
2025-10-16
Audit: 370942
Organization: Texas Christian University (TX)

AI Summary

  • Core Issue: An employee's vacation time was incorrectly charged to a federal grant due to a system change, leading to questioned costs of $625.
  • Impacted Requirements: Compliance with 2 CFR section 200.430(i) regarding allowable costs and accurate payroll records was not met.
  • Recommended Follow-Up: Implement enhanced controls and automated processes to ensure accurate tracking of benefits charged to grants and regularly review payroll discrepancies.

Finding Text

Federal programs Research and Development Cluster – National Institutes of Health – Drug Abuse and Addiction Research Programs AL #: 93.279 Award Year: 2024/2025 Type of finding Significant Deficiency and Noncompliance Compliance requirement Activities Allowed or Unallowed and Allowable Costs/Cost Principles Criteria Under 2 CFR section 200.430(i), costs of compensation for personal services are allowable to the extent the total compensation for individual employees is reasonable for the services rendered and conforms to the established written policies and practices, follows an appointment made in accordance with non-federal entities rules and written policies, and is determined and supported as provided in 2 CFR section 200.430(i), including that charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Condition We noted one out of forty judgmentally selected payroll transactions included cost for an employee that did not relate to services performed in relation to the grant. Questioned costs $625 Context A portion of an employee’s benefits was improperly charged to the grant. Cause When the University changed their timekeeping platform an academic affairs employees’ compensation was improperly set up in the system which incorrectly allocated their vacation time to this grant. Effect The employee’s vacation time that occurred after the change in the University’s timekeeping platform in March 2025 until the discovery after year end was incorrectly included as compensation and benefits expense within the grant. Repeat finding No Recommendations We recommend that the University ensure controls are in place to adequately review all benefits pay charged to grants to ensure appropriate. View of responsible officials To safeguard from future errors and ensure data accuracy, Human Resources partnered with Enterprise Application Services department to develop an automated process that populates earnings codes and project account codes based on employee, job record and earnings code. This enhancement streamlines data entry by consolidating it into a single interface, reducing the risk of manual entry errors. Additionally, the HR Technology Manager has implemented a new monitoring report to track employees with multiple salary distribution accounts as a part of payroll process. The biweekly report will be automatically generated and sent via email to HR’s HRIS Consultants for review. The HRIS Consultants will analyze the report, resolve any discrepancies and escalate any issues to the HR Technology Manager or Lead Application Consultant as necessary. These processes will be routinely reviewed, with adjustments made as needed.

Corrective Action Plan

To safeguard from future errors and ensure data accuracy, Human Resources partnered with Enterprise Application Services department to develop an automated process that populates earnings codes and project account codes based on employee, job record and earnings code. This enhancement streamlines data entry by consolidating it into a single interface, reducing the risk of manual entry errors. Additionally, the HR Technology Manager has implemented a new monitoring report to track employees with multiple salary distribution accounts as a part of payroll process. The biweekly report will be automatically generated and sent via email to HR’s HRIS Consultants for review. The HRIS Consultants will analyze the report, resolve any discrepancies and escalate any issues to the HR Technology Manager or Lead Application Consultant as necessary. These processes will be routinely reviewed, with adjustments made as needed.

Categories

Questioned Costs Allowable Costs / Cost Principles Subrecipient Monitoring Significant Deficiency Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1160853 2025-001
    Material Weakness Repeat
  • 1160854 2025-002
    Material Weakness Repeat
  • 1160855 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $89.19M
84.063 Federal Pell Grant Program $13.66M
93.264 Nurse Faculty Loan Program (nflp) $4.22M
15.U15 Drug Abuse Programs Evaluation $2.64M
84.007 Federal Supplemental Educational Opportunity Grants $1.22M
84.038 Federal Perkins Loan Program_federal Capital Contributions $990,569
84.325 Special Education - Personnel Development to Improve Services and Results for Children with Disabilities $636,230
84.042 Trio Student Support Services $613,446
93.364 Nursing Student Loans $499,421
84.033 Federal Work-Study Program $396,903
84.217 Trio McNair Post-Baccalaureate Achievement $311,070
84.047 Trio Upward Bound $298,703
84.000 Cac_fafsa_stud Support Strategy $233,219
93.859 Biomedical Research and Research Training $211,875
47.049 Mathematical and Physical Sciences $192,290
15.U15 Anger Management Research $146,869
93.595 Welfare Reform Research, Evaluations and National Studies $120,452
93.286 Discovery and Applied Research for Technological Innovations to Improve Human Health $96,791
81.049 Office of Science Financial Assistance Program $91,242
10.215 Sustainable Agriculture Research and Education $75,762
93.279 Drug Use and Addiction Research Programs $60,609
84.425 Education Stabilization Fund $52,757
93.867 Vision Research $49,184
93.307 Minority Health and Health Disparities Research $36,519
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $27,176
93.865 Child Health and Human Development Extramural Research $22,631
84.379 Teachers Education Assistance for College and Higher Education Grants $18,860
12.RD Sensor Systems-Bioluminescence $12,689
93.969 Pphf Geriatric Education Centers $10,923
47.041 Engineering $10,000
93.855 Allergy and Infectious Diseases Research $8,930
93.173 Research Related to Deafness and Communication Disorders $8,685
10.310 Agriculture and Food Research Initiative (afri) $6,574
12.630 Basic, Applied, and Advanced Research in Science and Engineering $2,156
84.305 Education Research, Development and Dissemination $2,122
47.074 Biological Sciences $1,713
10.212 Small Business Innovation Research (sbir) Program / Small Business Technology Transfer (sttr) Program $1,662
45.129 Promotion of the Humanities Federal/state Partnership $1,555
47.076 Stem Education (formerly Education and Human Resources) $1,494
39.003 Donation of Federal Surplus Personal Property $322
12.900 Language Grant Program $150
43.RD National Aeronautics and Space Administration $140