Finding 1144334 (2024-004)

Significant Deficiency Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2025-06-27
Audit: 360239
Organization: Hips (DC)

AI Summary

  • Core Issue: Payroll allocations do not accurately reflect employee time worked or salary rates, indicating a need for better review processes.
  • Impacted Requirements: Compliance with Title 2 U.S. CFR Part 200, which mandates accurate documentation and internal controls for salary charges to federal awards.
  • Recommended Follow-Up: Finance should enhance monthly reviews of payroll allocations and maintain comprehensive documentation of salary changes for all employees.

Finding Text

Finding 2024-004: Time Allocation and Personnel Documentation Retention Information on the Federal Program: Assistance Listing Number 93.788 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: As part of our audit procedures around payroll, we noted instances of payroll allocations to programs which did not accurately represent the time worked and/or salary rate of the employee. While misallocations were not significant in their amounts, the errors themselves suggest the need for more detailed review of the payroll allocation approval and entry process. In addition, we noted that HIPS does not maintain documentation for cost of living increases awarded to employees subsequent to their annual agreed upon rate of pay, which resulted in multiple instances where the employees current rate of pay noted could not be substantiated. Cause: The review of the payroll allocation entry and process was not sufficient to catch errors or differences from the timesheets completed by staff. HIPS does not maintain adequate documentation of staff changes in salary rate from year to year. Effect or Potential Effect: HIPS could inadvertently mischarge salaries and wages to its various programs. Questioned Costs: None. Context: Although the majority of payroll allocations were supported by appropriate documentation, these two exceptions suggest a need for improved controls over time and effort reporting to prevent isolated errors from becoming more systemic issues. In addition, we noted the majority of the employees reviewed during testwork did not have documentation to support the salary as of the pay period selected for testing. Identification as a Repeat Finding, if Applicable: Yes (2023-005) Recommendation: We recommend that the finance department perform a more detailed review of the monthly program allocations to ensure complete and accurate entry of payroll allocations. We also recommend that documentation for changes in rate of pay for all staff be maintained internally over the course of each employee's respective employment with HIPS.

Categories

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

Other Findings in this Audit

  • 567890 2024-003
    Significant Deficiency Repeat
  • 567891 2024-003
    Significant Deficiency Repeat
  • 567892 2024-004
    Significant Deficiency Repeat
  • 567893 2024-005
    Significant Deficiency Repeat
  • 567894 2024-003
    Significant Deficiency Repeat
  • 567895 2024-004
    Significant Deficiency Repeat
  • 567896 2024-005
    Significant Deficiency Repeat
  • 567897 2024-003
    Significant Deficiency Repeat
  • 567898 2024-003
    Significant Deficiency Repeat
  • 567899 2024-003
    Significant Deficiency Repeat
  • 567900 2024-003
    Significant Deficiency Repeat
  • 567901 2024-003
    Significant Deficiency Repeat
  • 567902 2024-003
    Significant Deficiency Repeat
  • 1144332 2024-003
    Significant Deficiency Repeat
  • 1144333 2024-003
    Significant Deficiency Repeat
  • 1144335 2024-005
    Significant Deficiency Repeat
  • 1144336 2024-003
    Significant Deficiency Repeat
  • 1144337 2024-004
    Significant Deficiency Repeat
  • 1144338 2024-005
    Significant Deficiency Repeat
  • 1144339 2024-003
    Significant Deficiency Repeat
  • 1144340 2024-003
    Significant Deficiency Repeat
  • 1144341 2024-003
    Significant Deficiency Repeat
  • 1144342 2024-003
    Significant Deficiency Repeat
  • 1144343 2024-003
    Significant Deficiency Repeat
  • 1144344 2024-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $860,669
93.136 Injury Prevention and Control Research and State and Community Based Programs $491,878
93.940 Hiv Prevention Activities Health Department Based $108,444
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $105,173
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $72,996
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation’s Health $2,463