Finding 1101529 (2024-002)

Material Weakness
Requirement
AB
Questioned Costs
$1
Year
2024
Accepted
2025-02-28

AI Summary

  • Core Issue: Employee salary charges to federal awards were based on budget estimates instead of actual time worked, leading to potential inaccuracies.
  • Impacted Requirements: Documentation for personnel expenses must accurately reflect work performed, supported by internal controls, and not exceed 100% of compensated activities.
  • Recommended Follow-Up: Implement timekeeping policies to ensure accurate documentation of employee work hours and salary allocations to federal awards.

Finding Text

Finding 2024-002: Allowable Costs/Cost Principles (Material Weakness and Noncompliance) Federal Agency: U.S. Department of Housing and Urban Development Assistance Listing Number and Title: 14.218 – CDBG Entitlement Grants Cluster Funding Year: 2024 Criteria: Per the Uniform Guidance 200.430(i) – Compensation – personal services, Standards for Documentation of Personnel Expenses, charges to federal awards for salaries and wages must be based on records that accurately reflect the work performed. Among other requirements, these records must: • Be supported by a system of internal controls which provides reasonable assurance that the charges are accurate, allowable, and properly allocated; • Reasonably reflect the total activity for which the employee is compensated by the non-federal entity, not exceeding 100% of compensated activities; • Encompass both federally assisted and all other activities compensated by the non-federal entity on an integrated basis; and • Support the distribution of the employee’s salary or wages among specific activities or cost objectives if the employee works on more than one federal award; a federal award and non-federal award; an indirect cost activity and a direct cost activity; two or more indirect activities which are allocated using different allocation bases; or an unallowable activity and a direct or indirect cost activity. Budget estimates (i.e. estimates determined before the services are performed) alone do not qualify as support for charges to federal awards, but may be used for interim accounting purposes, provided that the award recipient’s system of internal controls includes processes to review after-the-fact interim charges made to a federal awards based on budget estimates, and that all necessary adjustments be made such that the final amount charged to the federal award is accurate, allowable, and properly allocated. Condition: For individuals charged to this program who also have time charged to other programs there were no timesheets or other evidence to support the allocation to the program was based on actual time incurred to the program but was instead based on the budgeted amounts for those individuals. Questioned Costs: $3,703 which includes employee salaries of $2,874 and benefits of $829. Context: Of the 40 payroll selections tested, four were related to individuals who were allocated to different programs and the allocation was based on the budgeted allocation rather than time records supporting that level of effort related to the federal award charged. The total payroll costs associated with these four individuals was $2,874, which represented 7.19% of the total sample tested of $45,298. Total payroll and fringe benefit costs associated with ALN 14.218 was $1,998,128. Cause: Current policies and procedures do not require documented timekeeping by employees working on the grant program, which is appropriately reviewed, approved and used as a basis for charges to the grant program. Effect: Personnel costs charged to federal awards without appropriate documentation may be subject to disallowance. Repeat Finding: No. Recommendation: Policies and procedures should be implemented to ensure that employee timekeeping and the salary and wage allocations to the federal award are appropriately documented and accurately reflect the level of effort of work performed. Views of Responsible Officials: Management agrees with the details of this finding and will implement the procedures outlined in our Corrective Action Plan.

Categories

Questioned Costs Allowable Costs / Cost Principles Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 525081 2024-002
    Material Weakness
  • 525082 2024-002
    Material Weakness
  • 525083 2024-002
    Material Weakness
  • 525084 2024-002
    Material Weakness
  • 525085 2024-002
    Material Weakness
  • 525086 2024-002
    Material Weakness
  • 525087 2024-002
    Material Weakness
  • 525088 2024-002
    Material Weakness
  • 1101523 2024-002
    Material Weakness
  • 1101524 2024-002
    Material Weakness
  • 1101525 2024-002
    Material Weakness
  • 1101526 2024-002
    Material Weakness
  • 1101527 2024-002
    Material Weakness
  • 1101528 2024-002
    Material Weakness
  • 1101530 2024-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
93.959 Block Grants for Prevention and Treatment of Substance Abuse $1.14M
93.600 Head Start $623,255
14.231 Emergency Solutions Grant Program $348,510
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $253,973
16.320 Services for Trafficking Victims $217,972
93.052 National Family Caregiver Support, Title Iii, Part E $178,539
14.218 Community Development Block Grants/entitlement Grants $129,584
21.027 Coronavirus State and Local Fiscal Recovery Funds $63,526
10.558 Child and Adult Care Food Program $62,784
10.569 Emergency Food Assistance Program (food Commodities) $53,024
93.569 Community Services Block Grant $46,246
97.024 Emergency Food and Shelter National Board Program $18,825
93.558 Temporary Assistance for Needy Families $1,513
93.667 Social Services Block Grant $1,352