Finding 37637 (2022-005)

Significant Deficiency
Requirement
B
Questioned Costs
$1
Year
2022
Accepted
2023-03-28
Audit: 31838
Organization: City of South Gate (CA)
Auditor: Davis Farr LLP

AI Summary

  • Core Issue: The City improperly charged payroll expenses to the CDBG program based on estimated allocations instead of actual hours worked, leading to questioned costs of $23,270.
  • Impacted Requirements: Compliance with 2 CFR 200.430(i) is necessary, which mandates that salary charges must reflect actual work performed and not just budget estimates.
  • Recommended Follow-Up: The City should ensure payroll charges align with actual hours worked, and provide training to staff on accurate time reporting to meet grant requirements.

Finding Text

2022-005: Federal Awards ? Allowable Costs Federal Agency: U.S. Department of Treasury CFDA No.: 14.218 Federal Program: Community Development Block Grants/Entitlement Grants Federal Award Year: 2022 Control Category: Allowable Costs Questioned Costs: $23,270 Condition The City charged CDBG payroll expenses to the program based a timesheet allocation and did not adjust the charges to reconcile to actual time incurred per employee timesheets. Criteria 2 CFR 200.430(i), Standards for Documentation of Personnel Expenses, states, in part: ?Charges to Federal awards for salaries and wages must be based on records that accurately reflect the work performed?? Charges must ?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;?? And ?budget estimates (i.e., estimates determined before the services are performed) alone do not qualify as support for charges to Federal awards.? Cause The City's payroll system charges time for employees each pay period based on an allocation rather than actual hours documented on the employee?s timesheet. Effect Payroll costs charged to the program were greater than amounts supported by the documentation. Questioned Costs There were questioned costs in the amount of $23,270. Recommendation We recommend that the City charge time to the program based on actual hours worked per the employees' timesheets. Management?s Response Regarding Corrective Action Taken or Planned Management acknowledges the importance of ensuring that payroll costs charged to the program are consistent between the payroll system and the employee?s timesheet. The Finance Department plans to provide training to program staff on how to properly report their time worked on the grant to ensure that hours worked are both reported correctly on the timesheets and are following the funding allocations that are approved by the grant.

Corrective Action Plan

Management acknowledges the importance of ensuring that payroll costs charged to the program are consistent between the payroll system and the employee?s timesheet. The Finance Department plans to provide training to program staff on how to properly report their time worked on the grant to ensure that hours worked are both reported correctly on the timesheets and are following the funding allocations that are approved by the grant.

Categories

Questioned Costs Allowable Costs / Cost Principles

Other Findings in this Audit

  • 37638 2022-006
    - Repeat
  • 614079 2022-005
    Significant Deficiency
  • 614080 2022-006
    - Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 Coronavirus State and Local Fiscal Recovery Funds $9.93M
14.871 Section 8 Housing Choice Vouchers $5.25M
14.218 Community Development Block Grants/entitlement Grants $1.65M
16.922 Equitable Sharing Program $1.14M
20.205 Highway Planning and Construction $713,067
16.034 Coronavirus Emergency Supplemental Funding Program $81,464
14.239 Home Investment Partnerships Program $43,130
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $40,835
20.616 National Priority Safety Programs $24,800
97.067 Homeland Security Grant Program $18,527
16.738 Edward Byrne Memorial Justice Assistance Grant Program $1,680