Finding 1179409 (2025-002)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2025
Accepted
2026-03-13
Audit: 391810
Organization: City of Red Bluff (CA)

AI Summary

  • Core Issue: The City failed to maintain proper timesheets for an employee charged to the FAA grant, violating federal documentation standards.
  • Impacted Requirements: Non-compliance with 2CFR 200.430, which mandates accurate records for salaries and wages related to federal awards.
  • Recommended Follow-up: Implement a system for detailed, signed timesheets for employees funded by federal grants, ensuring supervisor review and approval.

Finding Text

Name: Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and COVID-19 Airport Programs; ASL#: 20.106; Federal Grantor: U.S. Department of Transportation; Pass Through Entity: State Department of Transportation; Award No.: 3-06-0193-017, 3-06-0193-019, 3-06-0193-020, 3-06-0193-021; Year: 2024/2025; Compliance Requirement: Allowable Costs/Cosst Principles; Criteria: According to 2CFR 200.430(i)(1) (Standards for Documentation of Personal Expenses), charges to Federal Awards for salaries and wages must be based on records that accurately reflect the work performed. For employees that work on multiple activities or cost objectives (e.g., FAA grant and non-grant activities), documentation must support the distribution of their time.; Condition: During testing of payroll expenditures, we reviewed the one employee’s time that was charged to the FAA grant (ALN 20.106). We noted that the City did not maintain itemized, signed timesheet detailing the specific hours worked on FAA project tasks versus other projects or administrative duties.; Cause: The City did not have established control procedures to ensure that employees working on multiple projects maintained detailed, itemized timesheets tracking time to specific grant and non-grant projects.; Effect: The City is not in compliance with 2CFR 200.430. The lack of proper documentation results in questioned costs, as the federal program may have been charged for time spent on non-federal activities.; Questioned Cost: $9,004.46 (Total payroll charged to 20.106 for the sampled employee during the period); Context: Our sample testing included the payroll charged to the grant for the one employee included in the payroll expenditures for the grant.; Repeat Finding: This is not a repeat finding.; Recommendation: We recommend that the City implement a reporting system that requires all employees paid with federal funds to complete itemized, signed timesheets detailing the specific hours worked on each grant or project on a daily or weekly basis. These timesheets must be reviewed and approved by a supervisor with firsthand knowledge of the work performed.; Views of Responsible Officials and Planned Corrective Action Plan: Refer to separate Management’s Corrective Action Plan for views of responsible officials and management’s responses.

Corrective Action Plan

Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and COVID-19 Airport Programs; We recommend that the City implement a reporting system that requires all employees paid with federal funds to complete itemized, signed timesheets detailing the specific hours worked on each grant or project on a daily or weekly basis. These timesheets must be reviewed and approved by a supervisor with firsthand knowledge of the work performed.; Management's Response: The City of Red Bluff has used a log of time spent on the grant including date, description of activity, and time worked on the grant. The logs failed to account for non-grant related time as required by 2 CFR 200.430(g)(1)(iv).; Responsible Individual: Leanna Pearson, Assistant Finance Director; Corrective Action Plan: The City will set up separate tracking within the job category in the City’s payroll timekeeping software for grants. The employee will split the time in the timekeeping software and add notes describing the activities and grants worked on.; Anticipated Completion Date: 3-4-2026.

Categories

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

Other Findings in this Audit

  • 1179404 2025-001
    Material Weakness Repeat
  • 1179405 2025-001
    Material Weakness Repeat
  • 1179406 2025-002
    Material Weakness Repeat
  • 1179407 2025-002
    Material Weakness Repeat
  • 1179408 2025-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.106 AIRPORT IMPROVEMENT PROGRAM, INFRASTRUCTURE INVESTMENT AND JOBS ACT PROGRAMS, AND COVID-19 AIRPORTS PROGRAMS $345,110
16.607 BULLETPROOF VEST PARTNERSHIP PROGRAM $463