Finding 478311 (2021-008)

Significant Deficiency
Requirement
B
Questioned Costs
-
Year
2021
Accepted
2024-07-11
Audit: 314981
Organization: City of Compton (CA)

AI Summary

  • Core Issue: Incorrect pay rates and hours worked were found in payroll records for federal funding.
  • Impacted Requirements: Compliance with federal guidelines on compensation documentation and internal controls was not met.
  • Recommended Follow-Up: Enhance payroll procedures to ensure accuracy and completeness, with updates to policies by June 30, 2024.

Finding Text

2021-008- Incorrect Payrate and Hours Worked (SD) Federal Program Title: Federal Catalog Number: Federal Agency: Pass-Through Entity: Federal Award Number and Year: Category of Finding: Community Development Block GranUEntitlement Grants 14.218 U.S. Department of Housing and Urban Development No applicable B-19-MC-06-0515 - 2019 Allowable CosUCost Principles Criteria: Title 2, Subtitle A, Chapter II, Part 200, General Provisions for Selected Items of Cost, Section 200.430, Compensation - Personal Services requires that costs of compensation are allowable to the extent that they satisfy specific requirements which in include that the total compensation of individual employees is determined and supported as provided in the Standards for Documentation of Personnel Expenses. The said standards require charges to Federal awards for salaries and wages must be based on records that must be supported by a system of internal control which provides reasonable assurance that the charges are accurate, allowable, and properly allocated. Condition: During our audit, we found one instance where the employee's timecard did not reflect the number of hours worked for CDBG and another instance where the employee's payrate did not agree to the payrate stated on the personnel action form (PA 101 ). Cause: For the exception related to timecard: The City was unable to provide the timecard that showed the hours worked by the employee by program/fund. For the exception related to payrate: The City approved retroactive pay increases for employees and the pay increases were processed as lump sum adjustments. The payroll records prior to the approval of the retroactive pay were not adjusted to reflect the change. The program costs were not adjusted either. Effect or Potential Effect: Over or understatement of costs charged to the program. Questioned Cost: None Context: One exception related to timecard and another exception related to payrate were found, out of 20 items selected. Statistical Sampling Validity: Samples are haphazardly selected. Repeat of a Prior-Year Finding: No Recommendation: We recommend the City improve procedures to ensure completeness and accuracy of payroll costs charged to federal programs. Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation. Corrective Action Plan: The general accounting policy will be updated for the accountant to check the payroll register to accrue retroactive pay changes to the correct period. The payroll policy will also be updated to require that timecards be updated with supervisor signature if changes are made to change allocation to another fund. Planned Implementation Date: June 30, 2024 Responsible Person(s): City Controller

Corrective Action Plan

Management Response and Corrective Action Plan City's Response: The City concurs with the recommendation. Corrective Action Plan: The general accounting policy will be updated for the accountant to check the payroll register to accrue retroactive pay changes to the correct period. The payroll policy will also be updated to require that timecards be updated with supervisor signature if changes are made to change allocation to another fund. Planned Implementation Date: June 30, 2024 Responsible Person(s): City Controller

Categories

Allowable Costs / Cost Principles Subrecipient Monitoring HUD Housing Programs

Other Findings in this Audit

  • 478306 2021-002
    Material Weakness Repeat
  • 478307 2021-003
    Significant Deficiency
  • 478308 2021-004
    -
  • 478309 2021-005
    -
  • 478310 2021-007
    Significant Deficiency Repeat
  • 478312 2021-006
    Significant Deficiency
  • 1054748 2021-002
    Material Weakness Repeat
  • 1054749 2021-003
    Significant Deficiency
  • 1054750 2021-004
    -
  • 1054751 2021-005
    -
  • 1054752 2021-007
    Significant Deficiency Repeat
  • 1054753 2021-008
    Significant Deficiency
  • 1054754 2021-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $8.70M
14.218 Community Development Block Grants/entitlement Grants $1.38M
21.019 Coronavirus Relief Fund (crf) $1.21M
14.248 Section 108 Loans Receivable - Balance at Beginning of Year $522,691
14.248 Section 108 Note Payable - Current Expenditures $506,125
14.871 Cares Act - Supplemental Housing Assistance Payment (hap) $300,953
16.034 Coronavirus Emergency Supplemental Funding Program $149,719
14.239 Home Investment Partnership Program $148,848
14.871 Cares Act -Supplemental Administative Fee Funding $67,493
14.218 Community Development Block Grants/disaster Recovery Grants (drgr) $4,420
14.218 Covid-19-Cdbg - Cv, Cares Act $4,068