Finding 529763 (2024-001)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2024
Accepted
2025-03-24
Audit: 347720
Auditor: Bergankdv LTD

AI Summary

  • Core Issue: Payroll costs for federal grants were based on budgeted estimates instead of actual hours worked, violating federal guidelines.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) is at risk due to inaccurate payroll allocations, which could lead to unallowable costs.
  • Recommended Follow-Up: Implement a time and effort reporting system for accurate payroll tracking and provide training for employees on proper time coding.

Finding Text

Finding 2024-001: Proper Support for Payroll Cost Allocations Federal Program: Block Grants for Prevention and Treatment of Substance Abuse, 93.959 Federal Agency: U.S Department of Health and Human Services Pass-Through Entity: United Community Services, Inc. Criteria: According to 2 CFR 200.430(i), charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. These records must be supported by a system of internal control that provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit, we noted that payroll costs for employees working on the Block Grants for Prevention and Treatment of Substance Abuse grants were not charged based on actual hours worked. Instead, payroll was allocated using budgeted estimates with several subsequent adjustments to those allocations to reflect what they believed to be actual time spent on grant- related activities. Cause: The Organization relied on predetermined salary allocations rather than allocating based on the time and effort reporting system that tracks actual hours worked on federal programs as some employees were not properly coding time worked by grant on their time sheets. Effect: Payroll costs charged to the grant may not accurately reflect the time employees spent on grant- related activities, leading to potential unallowable costs and noncompliance with federal regulations. Questioned Costs: Not determined. Recommendation: We recommend that the Organization utilize the time and effort reporting system that ensures payroll costs are charged to federal awards based on actual hours worked and to train employees to properly code their hours. If actual hours are not used, management should review and adjust salary allocations periodically to align with documented time records.Views of Responsible Officials: Additional and ongoing training on entering time will be done with employees. Additional and ongoing training on reviewing and approving time will be done with supervisors. An additional level of checking will be done each month by someone other than the supervisor. Additional reporting capabilities are being programmed into Employee & Family Resources, Inc.'s time keeping system to help with this.

Corrective Action Plan

CORRECTIVE ACTION PLAN March 19, 2025 U.S. Department of Health an-d Human Services Employee & Family Resources, Inc. respectfully submits the following corrective action plan for the year ended 06/30/24. Name and address of independent public accounting firm: BerganKDV, Ltd.; 220 Park Ave South; St. Cloud, MN 56301 Audit period: July 1, 2023 - June 30, 2024 he finding from the scheduleoflindmgs and questioned costs is discussed below. The finding is numbered consistently with the number assigned in the schedule. Federal Award Finding Significant Deficiency Finding 2024-001: Proper Support for Payroll Cost Allocations Recommendation: We recommend that the Organization utilize the time and effort reporting system that ensures payroll costs are charged to federal awards based on actual hours worked and to train employees to properly code their hours. If actual hours are not used, management should review and adjust salary allocations periodically to align with documented time records. Action Taken: We concur with the recommendation. Information from the time and effort reporting system will support the payroll costs for the year July 1, 2024 - June 30, 2025. Beginning July 1, 2025, payroll costs charged to federal awards will be based on actual hours worked during the calendar month. Additional training has been conducted with staff and supervisors. Questions regarding this plan can be addressed to me at 515.471.2360. Sincerely, Tammy Hoyman CEO

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

  • 529764 2024-001
    Significant Deficiency
  • 1106205 2024-001
    Significant Deficiency
  • 1106206 2024-001
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.959 Block Grants for Prevention and Treatment of Substance Abuse $323,103
93.788 Opioid Str $60,452
93.778 Medical Assistance Program $43,142
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $34,950
93.136 Injury Prevention and Control Research and State and Community Based Programs $914