Finding 517147 (2024-001)

-
Requirement
AB
Questioned Costs
-
Year
2024
Accepted
2024-12-30

AI Summary

  • Core Issue: Payroll charges to the Federal grant were misallocated, not reflecting the actual time spent on the grant.
  • Impacted Requirements: Costs must be specifically incurred for the Federal award as per 2 CFR 200.405.
  • Recommended Follow-Up: Management should fix the payroll software and implement a review process to prevent future misallocations.

Finding Text

Finding - Activities Allowed or Unallowed & Allowable Costs/Cost Principles: Payroll, Assistance Listing Number 93.243; June 30, 2024 award year; U.S. Department of Health and Human Services Criteria or Specific Requirement In accordance with 2 CFR 200.405, A cost is allocable to a Federal award if the cost is assignable to that Federal award with the relative benefits received. These costs must be incurred specifically for the Federal award. Condition Found Of the Seventeen payroll charges selected for testing, the allocation of payroll charged to the Federal grant did not align with the percentage of time incurred specifically for the Federal grant in four instances. Questioned Costs None. Cause The Organization's payroll software did not allocate payroll charges in accordance with the percentage of hours spent working on the Federal grant. Effect Management charged costs to the grant in excess of those costs that were incurred specifically for the grant. Identification as a Repeat Finding This is not a repeat finding. Recommendation Management should understand the cause of the misallocation and correct this within their payroll software. Management should additionally ensure adequate review of payroll costs is in place to correct misallocations. Views of Responsible Officials and Planned Corrective Action See Corrective Action Plan.

Corrective Action Plan

Finding - Activities Allowed or Unallowed & Allowable Costs/Cost Principles: Payroll, Assistance Listing Number 93.243; June 30, 2024, award year; U.S. Department of Health and Human Services Criteria or Specific Requirement In accordance with 2 CFR 200.405, A cost is allocable to a Federal award if the cost is assignable to that Federal award with the relative benefits received. These costs must be incurred specifically for the Federal award. Condition Found Of the Seventeen payroll charges selected for testing, the allocation of payroll charged to the Federal grant did not align with the percentage of time incurred specifically for the Federal grant in four instances. Views of Responsible Officials and Planned Corrective Actions It was determined that the allocation percentage assigned in our payroll system did not match the calculated payroll expensed to the grant. Corrective measures: 1) contacted our payroll administrator and determined the cause to be that an allocation percentage was applied to the employee and the employee was also assigning their time via their time sheet effectively calculating twice, first on the total payroll and again on the allocated amount. The employee was instructed not to enter the allocation since it is already done in the payroll system. 2) A monthly review and calculation will be performed by program management and accounting to verify cost allocations are correct. Responsible Official: Korin Ihloff, CFO Expected Completion Date: The issue was addressed immediately.

Categories

Allowable Costs / Cost Principles

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
16.575 Crime Victim Assistance $409,562
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $404,638
93.550 Transitional Living Program $228,896
14.267 Transitional Housing Program $228,691
93.623 Basic Center Grant $187,934
93.276 Substance Abuse and Mental Health Services $124,414
93.556 Promoting Safe and Stable Families Program $123,147
93.497 Family Violence Prevention & Service Act Ara $54,518
10.555 National School Lunch Program $41,970