Finding 1166328 (2024-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-12-23

AI Summary

  • Core Issue: Employee salaries charged to federal programs lack consistent support from timesheets or documentation.
  • Impacted Requirements: Compliance with Cost Principles for Non-Profit Organizations and proper internal controls for salary documentation.
  • Recommended Follow-Up: Revise timesheet reconciliation procedures to ensure monthly or quarterly checks before submitting funding requests.

Finding Text

Condition: Amount of salaries allocated to federal programs are not consistently supported by employee timesheets or other similar documentation. Criteria: Reports reflected the distribution of activity of each employee must be maintained for all staff members whose compensation is charged, in whole or in part, directly to awards, in accordance with Cost Principles for Non-Profit Organizations (2 CFR Part 230.8). Internal controls should be in place that provide reasonable assurance that salaries for employees charged to the federal programs are properly documented and reconciled to ensure that they are accurate, allowable, and properly allocted. Cause: There are limited procedures in place that require reconciliation of actual hours expended to the program. Effect: Since employee salaries were not reconciled to corresponding timesheets, it is possible that employees' time and related costs may be inappropriately allocated amongst functional activities, including cost allocations to federal awards program. This could result in noncompliance with the Uniform Guidance. Context: This condition occurred in 12 out of 60 payroll transactions selected for testing. Total payroll transactions changed to the program were $726,864, of which $106,986 were slected for testing, representing 19 different employees. Recommendation: Existing timesheet reconciliation procedures should be revised. The organization should reconcile employee timesheets to amounts allocated to the grants on, at minimum, a quarterly basis, and ideally, on a monthly basis prior to the submission of vouchers or funding requests. Views of Responsible Officials and Planned Corrective Actions: The Organization will review its procedures and make appropriate changes. The Organization accepts the recommendation.

Corrective Action Plan

The Organization will review its timesheet tracking and reconciliation procedures and make any necessary revisions to ensure that expenditures charged to the grants align with timesheets. Additionally, the Organization witll reconcile timesheets to amounts allocated to grants on at least a quarterly basis.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 1166326 2024-004
    Material Weakness Repeat
  • 1166327 2024-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $211,178
21.019 CORONAVIRUS RELIEF FUND $172,590
93.391 ACTIVITIES TO SUPPORT STATE, TRIBAL, LOCAL AND TERRITORIAL (STLT) HEALTH DEPARTMENT RESPONSE TO PUBLIC HEALTH OR HEALTHCARE CRISES $54,604
93.323 EPIDEMIOLOGY AND LABORATORY CAPACITY FOR INFECTIOUS DISEASES (ELC) $29,012