Finding 972629 (2021-002)

Significant Deficiency Repeat Finding
Requirement
B
Questioned Costs
$1
Year
2021
Accepted
2024-05-08
Audit: 305817
Organization: City of Manteca (CA)

AI Summary

  • Core Issue: Payroll costs for one employee were charged based on a flat rate of 25%, not actual hours worked, leading to questioned costs of $8,997.
  • Impacted Requirements: The City is not complying with 2 CFR Part 200.430(i), which mandates accurate payroll documentation and internal controls.
  • Recommended Follow-Up: Establish procedures to ensure payroll costs are documented correctly for all federal grant programs, addressing this repeat finding since 2019.

Finding Text

Finding #SA2021-002: Support for Payroll Costs Charged to Grant Assistance Listing Number: 20.507 Assistance Listing Title: Federal Transit – Formula Grants (Urbanized Area Formula Program) Name of Federal Agency: Department of Transportation - Federal Transportation Administration Federal Award Identification Number: CA-2021-009-01, CA-2020-005-01, CA-2020-005-02 Criteria: 2 CFR Part 200.430(i), “Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards” requires that grantees adhere to the following, “Payroll systems must be based on records that accurately reflect the work performed” and “be supported by a system of internal controls that provides reasonable assurances that charges are accurate, allowable, and properly allocated...” The payroll records must be a part of the official record, reflect the employee’s total activity and show if the specific activity of the person is being paid by more than one federal award. Section 200.430(i)(viii) indicates that 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 system for establishing the estimates produces reasonable approximations of the activity actually performed, among other requirements. Condition: We noted that the payroll costs for one employee were charged to the program based on a flat rate of 25% of the payroll costs, rather than based on the actual hours worked. Payroll costs, including salary and benefits, charged to the program during fiscal year 2021 totaled $8,997. Questioned Costs: We question costs of $8,997, which consists of the payroll and fringe benefits charged to the grant for the employee based on the flat percentage of pay and benefits for the full fiscal year. Effect: The City is not in compliance with the payroll documentation requirements set forth in 2 CFR Part 200.430(i). Cause: We understand that grant program staff were not aware of the payroll documentation requirement and due to staff turnover, Finance staff cannot determine whether any such documentation exists. Identification as a repeat finding: Yes, since 2019 Recommendation: The City should establish procedures to ensure that payroll costs charged to the program are documented in accordance with 2 CFR Part 200.430 for the Federal Transit-Formula Grants program and all federal grant programs. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Categories

Questioned Costs Allowable Costs / Cost Principles Internal Control / Segregation of Duties

Other Findings in this Audit

  • 396187 2021-002
    Significant Deficiency Repeat
  • 396188 2021-003
    Material Weakness
  • 396189 2021-004
    Significant Deficiency
  • 396190 2021-005
    Material Weakness
  • 396191 2021-004
    Significant Deficiency
  • 396192 2021-005
    Material Weakness
  • 972630 2021-003
    Material Weakness
  • 972631 2021-004
    Significant Deficiency
  • 972632 2021-005
    Material Weakness
  • 972633 2021-004
    Significant Deficiency
  • 972634 2021-005
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.019 Coronavirus Relief Fund $1.05M
20.507 Federal Transit_formula Grants $988,218
14.218 Community Development Block Grants/entitlement Grants $378,077
97.083 Staffing for Adequate Fire and Emergency Response (safer) $266,170
20.205 Highway Planning and Construction $35,429
20.600 State and Community Highway Safety $34,079
20.608 Minimum Penalties for Repeat Offenders for Driving While Intoxicated $29,189
16.034 Coronavirus Emergency Supplemental Funding Program $3,798
16.738 Edward Byrne Memorial Justice Assistance Grant Program $2,207