Finding 1236769 (2023-013)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2026-09-25
Audit: 412274
Auditor: CBIZ CPAS PC

AI Summary

  • Core Issue: UHU lacks adequate time records to support payroll costs charged to federal awards, relying on budget estimates instead of actual time worked.
  • Impacted Requirements: This noncompliance with Uniform Guidance increases the risk of unallowable costs and potential questioned costs.
  • Recommended Follow-Up: UHU should implement policies requiring detailed timesheets for employees working on federal awards to ensure accurate payroll allocations and compliance.

Finding Text

CRITERIA Under the Uniform Guidance, non-federal entities are required to maintain records that accurately reflect the work performed, and payroll costs must be supported by timesheets or other approved documentation that records the actual time worked on federal awards. CONDITION AND CONTEXT UHU did not maintain adequate time records to support amounts charged to the general ledger for payroll costs. For ALN 93.914, payroll allocations to federal awards were based on the original award budget, rather than actual time worked, and UHU did not track personnel time using timesheets or other acceptable records to re-allocate effort each month. While timesheets were maintained for clocking in and out, they did not identify the specific grants, projects, or activities employees worked on. Our audit included internal control testing over a random sample of expenditures and found insufficient support for payroll costs charged to federal programs. Additionally, for certain grants within the Research and Development cluster, we were unable to obtain any time records or time certifications attached to support payroll charges. CAUSE UHU’s current policies do not require employees to complete timesheets with details specifying which grants or funding sources they worked on during each pay period. As a result, payroll is allocated based on budget estimates rather than actual time worked on specific grants. EFFECT OR POTENTIAL EFFECT Failure to maintain adequate time and effort documentation increases the risk of unallowable costs being charged to federal programs, potential questioned costs, and noncompliance with federal regulations. RECOMMENDATION We recommend that UHU implement policies and procedures requiring all employees whose salaries are charged to federal awards to complete timesheets or other acceptable records that specify the actual time worked on each grant or funding source during each pay period. This will ensure that payroll allocations are based on actual effort expended, provide adequate support for amounts charged to federal programs, and help maintain compliance with federal regulations.

Corrective Action Plan

o Require employees whose salaries are allocated to multiple funding sources to complete periodic certifications. o Maintain documentation supporting actual work performed. o Review payroll allocations regularly to ensure costs charged to federal awards are accurate. o Require management review and approval of payroll allocations. o Maintain supporting documentation for payroll charges to federal awards. o Provide training regarding time and effort reporting requirements.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1236723 2023-009
    Material Weakness Repeat
  • 1236724 2023-009
    Material Weakness Repeat
  • 1236725 2023-009
    Material Weakness Repeat
  • 1236726 2023-009
    Material Weakness Repeat
  • 1236727 2023-009
    Material Weakness Repeat
  • 1236728 2023-009
    Material Weakness Repeat
  • 1236729 2023-009
    Material Weakness Repeat
  • 1236730 2023-009
    Material Weakness Repeat
  • 1236731 2023-009
    Material Weakness Repeat
  • 1236732 2023-009
    Material Weakness Repeat
  • 1236733 2023-010
    Material Weakness Repeat
  • 1236734 2023-010
    Material Weakness Repeat
  • 1236735 2023-010
    Material Weakness Repeat
  • 1236736 2023-010
    Material Weakness Repeat
  • 1236737 2023-010
    Material Weakness Repeat
  • 1236738 2023-010
    Material Weakness Repeat
  • 1236739 2023-010
    Material Weakness Repeat
  • 1236740 2023-010
    Material Weakness Repeat
  • 1236741 2023-010
    Material Weakness Repeat
  • 1236742 2023-011
    Material Weakness Repeat
  • 1236743 2023-011
    Material Weakness Repeat
  • 1236744 2023-011
    Material Weakness Repeat
  • 1236745 2023-011
    Material Weakness Repeat
  • 1236746 2023-011
    Material Weakness Repeat
  • 1236747 2023-011
    Material Weakness Repeat
  • 1236748 2023-011
    Material Weakness Repeat
  • 1236749 2023-011
    Material Weakness Repeat
  • 1236750 2023-011
    Material Weakness Repeat
  • 1236751 2023-012
    Material Weakness Repeat
  • 1236752 2023-012
    Material Weakness Repeat
  • 1236753 2023-012
    Material Weakness Repeat
  • 1236754 2023-012
    Material Weakness Repeat
  • 1236755 2023-012
    Material Weakness Repeat
  • 1236756 2023-012
    Material Weakness Repeat
  • 1236757 2023-012
    Material Weakness Repeat
  • 1236758 2023-012
    Material Weakness Repeat
  • 1236759 2023-012
    Material Weakness Repeat
  • 1236760 2023-013
    Material Weakness Repeat
  • 1236761 2023-013
    Material Weakness Repeat
  • 1236762 2023-013
    Material Weakness Repeat
  • 1236763 2023-013
    Material Weakness Repeat
  • 1236764 2023-013
    Material Weakness Repeat
  • 1236765 2023-013
    Material Weakness Repeat
  • 1236766 2023-013
    Material Weakness Repeat
  • 1236767 2023-013
    Material Weakness Repeat
  • 1236768 2023-013
    Material Weakness Repeat
  • 1236770 2023-014
    Material Weakness Repeat
  • 1236771 2023-014
    Material Weakness Repeat
  • 1236772 2023-014
    Material Weakness Repeat
  • 1236773 2023-014
    Material Weakness Repeat
  • 1236774 2023-014
    Material Weakness Repeat
  • 1236775 2023-014
    Material Weakness Repeat
  • 1236776 2023-014
    Material Weakness Repeat
  • 1236777 2023-014
    Material Weakness Repeat
  • 1236778 2023-014
    Material Weakness Repeat
  • 1236779 2023-014
    Material Weakness Repeat
  • 1236780 2023-015
    Material Weakness Repeat
  • 1236781 2023-016
    Material Weakness Repeat
  • 1236782 2023-016
    Material Weakness Repeat
  • 1236783 2023-016
    Material Weakness Repeat
  • 1236784 2023-016
    Material Weakness Repeat
  • 1236785 2023-016
    Material Weakness Repeat
  • 1236786 2023-016
    Material Weakness Repeat
  • 1236787 2023-016
    Material Weakness Repeat
  • 1236788 2023-016
    Material Weakness Repeat
  • 1236789 2023-016
    Material Weakness Repeat
  • 1236790 2023-016
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.914 HIV EMERGENCY RELIEF PROJECT GRANTS $827,117
93.243 SUBSTANCE ABUSE AND MENTAL HEALTH SERVICES PROJECTS OF REGIONAL AND NATIONAL SIGNIFICANCE $547,532
93.279 DRUG USE AND ADDICTION RESEARCH PROGRAMS $400,743
93.788 OPIOID STR $275,534
93.136 INJURY PREVENTION AND CONTROL RESEARCH AND STATE AND COMMUNITY BASED PROGRAMS $257,074
93.917 HIV CARE FORMULA GRANTS $58,312
93.242 MENTAL HEALTH RESEARCH GRANTS $41,967
93.855 ALLERGY AND INFECTIOUS DISEASES RESEARCH $25,429
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $4,314