Finding 1094344 (2023-005)

Significant Deficiency
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2025-01-07
Audit: 336157
Organization: Hips (DC)

AI Summary

  • Core Issue: Payroll allocations do not accurately reflect employee time worked or salary rates, leading to potential mischarges.
  • Impacted Requirements: Compliance with Title 2 U.S. CFR Part 200, which mandates accurate records for federal awards.
  • Recommended Follow-Up: Finance should enhance review processes for payroll allocations and maintain documentation for salary changes for all employees.

Finding Text

Finding 2003-005: 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: Undetermined Context: The misallocations identified represent 12.5% of the sampled payroll transactions (5 out of 40). 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: Not applicable 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

  • 517900 2023-004
    Significant Deficiency
  • 517901 2023-004
    Significant Deficiency
  • 517902 2023-005
    Significant Deficiency
  • 517903 2023-006
    Significant Deficiency
  • 517904 2023-004
    Significant Deficiency
  • 517905 2023-005
    Significant Deficiency
  • 517906 2023-006
    Significant Deficiency
  • 517907 2023-004
    Significant Deficiency
  • 517908 2023-005
    Significant Deficiency
  • 517909 2023-006
    Significant Deficiency
  • 517910 2023-004
    Significant Deficiency
  • 517911 2023-004
    Significant Deficiency
  • 517912 2023-004
    Significant Deficiency
  • 517913 2023-004
    Significant Deficiency
  • 1094342 2023-004
    Significant Deficiency
  • 1094343 2023-004
    Significant Deficiency
  • 1094345 2023-006
    Significant Deficiency
  • 1094346 2023-004
    Significant Deficiency
  • 1094347 2023-005
    Significant Deficiency
  • 1094348 2023-006
    Significant Deficiency
  • 1094349 2023-004
    Significant Deficiency
  • 1094350 2023-005
    Significant Deficiency
  • 1094351 2023-006
    Significant Deficiency
  • 1094352 2023-004
    Significant Deficiency
  • 1094353 2023-004
    Significant Deficiency
  • 1094354 2023-004
    Significant Deficiency
  • 1094355 2023-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.788 Opioid Str $691,569
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $367,952
93.136 Injury Prevention and Control Research and State and Community Based Programs $316,551
93.421 Strengthening Public Health Systems and Services Through National Partnerships to Improve and Protect the Nation�s Health $107,962
93.940 Hiv Prevention Activities Health Department Based $99,930
93.944 Human Immunodeficiency Virus (hiv)/acquired Immunodeficiency Virus Syndrome (aids) Surveillance $88,204