Finding 366484 (2021-005)

Material Weakness Repeat Finding
Requirement
L
Questioned Costs
-
Year
2021
Accepted
2024-02-07

AI Summary

  • Core Issue: UHU is not maintaining adequate timesheets, leading to potential misallocation of payroll costs across programs.
  • Impacted Requirements: Compliance with Title 2 U.S. CFR Part 200, which mandates accurate record-keeping for salary charges to Federal awards.
  • Recommended Follow-Up: Enforce timesheet completion for all employees and establish a reconciliation process between timesheets and the general ledger.

Finding Text

Finding 2021-005: Timesheets Information on Federal Program: Assistance Listing Numbers 93.914 and 93.917 Criteria or Specific Requirement: Title 2 U.S. Code of Federal Regulations (CFR) Part 200, paragraph 430 “Compensation – personal services” requires that charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed, and that these records must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Additionally, these records must comply with established accounting policies and practices of the non-Federal entity. Condition: Payroll is allocated based on budget. We noted that payroll transactions lacked a timesheet showing programs worked on during the period or other evidence of proper record-keeping to support the program allocations of salaries and related expenses in the general ledger. Context: UHU failed to keep adequate time records to support the amounts charged to the general ledger. Allocation was based on award budget and UHU did not track time using timesheets to reallocate time each month. Our audit work in this area consisted of internal control testwork over a random sample of expenditures. The issue is considered systemic in nature. Cause: UHU’s current policies do not require employees to complete timesheets for each pay period. Payroll is allocated based on budget. Effect or Potential Effect: UHU could inadvertently mischarge salaries and wages to its various programs. Questioned Costs: Undetermined Identification as a Repeat Finding: 2020-007 Recommendation: We recommend that management enforce its current payroll policies, ensure each employee completes a timesheet that pertains to each payroll period and which documents the allocation of time worked on departments, projects and affiliates (per the policy). Furthermore, the finance department should prepare and maintain a reconciliation between the program allocations (as documented in the approved timesheets) and the general ledger in order to ensure a full and accurate audit trail of payroll expenditures.

Categories

Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 366445 2021-001
    Material Weakness Repeat
  • 366446 2021-002
    Material Weakness Repeat
  • 366447 2021-003
    Material Weakness Repeat
  • 366448 2021-004
    Material Weakness Repeat
  • 366449 2021-005
    Material Weakness Repeat
  • 366450 2021-006
    Material Weakness Repeat
  • 366451 2021-007
    Material Weakness Repeat
  • 366452 2021-001
    Material Weakness Repeat
  • 366453 2021-002
    Material Weakness Repeat
  • 366454 2021-003
    Material Weakness Repeat
  • 366455 2021-004
    Material Weakness Repeat
  • 366456 2021-005
    Material Weakness Repeat
  • 366457 2021-006
    Material Weakness Repeat
  • 366458 2021-007
    Material Weakness Repeat
  • 366459 2021-001
    Material Weakness Repeat
  • 366460 2021-002
    Material Weakness Repeat
  • 366461 2021-003
    Material Weakness Repeat
  • 366462 2021-004
    Material Weakness Repeat
  • 366463 2021-005
    Material Weakness Repeat
  • 366464 2021-006
    Material Weakness Repeat
  • 366465 2021-007
    Material Weakness Repeat
  • 366466 2021-001
    Material Weakness Repeat
  • 366467 2021-002
    Material Weakness Repeat
  • 366468 2021-003
    Material Weakness Repeat
  • 366469 2021-004
    Material Weakness Repeat
  • 366470 2021-005
    Material Weakness Repeat
  • 366471 2021-006
    Material Weakness Repeat
  • 366472 2021-007
    Material Weakness Repeat
  • 366473 2021-001
    Material Weakness Repeat
  • 366474 2021-002
    Material Weakness Repeat
  • 366475 2021-003
    Material Weakness Repeat
  • 366476 2021-004
    Material Weakness Repeat
  • 366477 2021-005
    Material Weakness Repeat
  • 366478 2021-006
    Material Weakness Repeat
  • 366479 2021-007
    Material Weakness Repeat
  • 366480 2021-001
    Material Weakness Repeat
  • 366481 2021-002
    Material Weakness Repeat
  • 366482 2021-003
    Material Weakness Repeat
  • 366483 2021-004
    Material Weakness Repeat
  • 366485 2021-006
    Material Weakness Repeat
  • 366486 2021-007
    Material Weakness Repeat
  • 942887 2021-001
    Material Weakness Repeat
  • 942888 2021-002
    Material Weakness Repeat
  • 942889 2021-003
    Material Weakness Repeat
  • 942890 2021-004
    Material Weakness Repeat
  • 942891 2021-005
    Material Weakness Repeat
  • 942892 2021-006
    Material Weakness Repeat
  • 942893 2021-007
    Material Weakness Repeat
  • 942894 2021-001
    Material Weakness Repeat
  • 942895 2021-002
    Material Weakness Repeat
  • 942896 2021-003
    Material Weakness Repeat
  • 942897 2021-004
    Material Weakness Repeat
  • 942898 2021-005
    Material Weakness Repeat
  • 942899 2021-006
    Material Weakness Repeat
  • 942900 2021-007
    Material Weakness Repeat
  • 942901 2021-001
    Material Weakness Repeat
  • 942902 2021-002
    Material Weakness Repeat
  • 942903 2021-003
    Material Weakness Repeat
  • 942904 2021-004
    Material Weakness Repeat
  • 942905 2021-005
    Material Weakness Repeat
  • 942906 2021-006
    Material Weakness Repeat
  • 942907 2021-007
    Material Weakness Repeat
  • 942908 2021-001
    Material Weakness Repeat
  • 942909 2021-002
    Material Weakness Repeat
  • 942910 2021-003
    Material Weakness Repeat
  • 942911 2021-004
    Material Weakness Repeat
  • 942912 2021-005
    Material Weakness Repeat
  • 942913 2021-006
    Material Weakness Repeat
  • 942914 2021-007
    Material Weakness Repeat
  • 942915 2021-001
    Material Weakness Repeat
  • 942916 2021-002
    Material Weakness Repeat
  • 942917 2021-003
    Material Weakness Repeat
  • 942918 2021-004
    Material Weakness Repeat
  • 942919 2021-005
    Material Weakness Repeat
  • 942920 2021-006
    Material Weakness Repeat
  • 942921 2021-007
    Material Weakness Repeat
  • 942922 2021-001
    Material Weakness Repeat
  • 942923 2021-002
    Material Weakness Repeat
  • 942924 2021-003
    Material Weakness Repeat
  • 942925 2021-004
    Material Weakness Repeat
  • 942926 2021-005
    Material Weakness Repeat
  • 942927 2021-006
    Material Weakness Repeat
  • 942928 2021-007
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.939 Hiv Prevention Activities_non-Governmental Organization Based $309,237
93.136 Injury Prevention and Control Research and State and Community Based Programs $207,309
93.917 Hiv Care Formula Grants $199,583
19.029 The U.s. President's Emergency Plan for Aids Relief Programs $150,000
93.940 Hiv Prevention Activities_health Department Based $59,756
93.279 Drug Abuse and Addiction Research Programs $38,859
93.914 Hiv Emergency Relief Project Grants $500