Finding 1221501 (2025-002)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2025
Accepted
2026-06-30
Audit: 405801
Organization: Hips (DC)

AI Summary

  • Core Issue: Payroll allocations prior to December 2024 did not accurately reflect time worked, indicating a need for better oversight.
  • Impacted Requirements: Compliance with Title 2 CFR Part 200, which mandates accurate records and internal controls for salary charges to Federal awards.
  • Recommended Follow-Up: Finance should enhance the review process for monthly payroll allocations to ensure accuracy and prevent future errors.

Finding Text

Finding 2025-002: Time Allocations 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 prior to December 2024 to programs which did not accurately represent the time worked. 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. Cause: The review of the payroll allocation entry and process was not sufficient to catch errors or differences from the timesheets completed by staff. 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 six exceptions suggest a need for improved controls over time and effort reporting to prevent isolated errors from becoming more systemic issues. We did note that new procedures implemented by management after December 2024 resulted in no payroll allocation variances after that period. Identification as a Repeat Finding, if Applicable: Yes (2024-004) 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.

Corrective Action Plan

Views of Responsible Officials: As noted in your findings, those instances occurred only prior to December 2024 and no misallocations were noted after that. HIPS implemented a second level of review and approval by the program managers during FY25. HIPS's current payroll and time tracking systems do not have the capacity to implement time tracking at this level of complexity. In FY 26, Supervisors will review and document review of proposed time allocations on the payroll allocations spreadsheets prior to month start to ensure that the allocation correctly matches the proposed schedule, and at month end to assess any changes needed based on actual time worked on various grant activities. We will also search for new software options to improve approval and entry process.

Categories

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

Other Findings in this Audit

  • 1221495 2025-002
    Material Weakness Repeat
  • 1221496 2025-003
    Material Weakness Repeat
  • 1221497 2025-002
    Material Weakness Repeat
  • 1221498 2025-003
    Material Weakness Repeat
  • 1221499 2025-002
    Material Weakness Repeat
  • 1221500 2025-003
    Material Weakness Repeat
  • 1221502 2025-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
93.788 OPIOID STR $853,616
93.136 INJURY PREVENTION AND CONTROL RESEARCH AND STATE AND COMMUNITY BASED PROGRAMS $331,787
93.940 HIV PREVENTION AND SURVEILLANCE ACTIVITIES-HEALTH DEPARTMENT BASED $119,099
93.944 HUMAN IMMUNODEFICIENCY VIRUS (HIV)/ACQUIRED IMMUNODEFICIENCY VIRUS SYNDROME (AIDS) SURVEILLANCE $74,432