Finding 943159 (2023-001)

-
Requirement
B
Questioned Costs
-
Year
2023
Accepted
2024-02-09

AI Summary

  • Core Issue: Payroll expenses are based on budget estimates rather than actual time worked, leading to potential inaccuracies.
  • Impacted Requirements: Compliance with § 200.430, which requires actual time tracking for federal program charges.
  • Recommended Follow-Up: Implement a Semi-Annual Personnel Activity Certification Form and ensure new time tracking software is fully operational.

Finding Text

FINDINGS AND QUESTIONED COSTS-MAJOR FEDERAL AWARD PROGRAM AUDIT Finding 2023-001: Compliance finding - Payroll U.S. Dept. of Health and Human Services Comm. Of MA, Department of Public Health Immunization Coop Agreements (ALN# 93.268) Condition: Payroll expenses charged to certain programs are not supported by actual time spent, but instead are allocated based upon the program budgets. Employees for those programs do not track which programs are being worked on throughout the day. Time is tracked in general and then applied to each program, based on the budget worksheet. Criteria or specific requirement: § 200.430 Compensation-personal services - budget estimates alone do not qualify as support for charges to Federal awards, but may be used for interim accounting purposes, provided that the system for establishing the estimates produces reasonable approximations of the activity actually performed. Cause: Employees are not charged with tracking their time by individual program and allocation of their wages is done by budget estimates. Effect: Payroll expenses charged to programs based upon program budgets and potentially do not accurately reflect the time spent by Organization staff on each program - misstatement of payroll expenses. Recommendation: Use of a Semi-Annual Personnel Activity Certification Form for each employee funded by a federal program. Management Response: Management has engaged a third party vendor for a new time and attendance software that will allow all hours worked and related programs to be tracked accurately. A contract has been signed and the software is actively being implemented.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $503,682
93.268 Immunization Cooperative Agreements $352,113
93.914 Hiv Emergency Relief Project Grants $219,267
93.940 Hiv Prevention Activities_health Department Based $100,000
16.023 Sexual Assault Services Cuturally Specific Program $99,881
16.588 Violence Against Women Formula Grants $12,405
14.218 Community Development Block Grants/entitlement Grants $5,956
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $5,400
93.959 Block Grants for Prevention and Treatment of Substance Abuse $2,537