Finding 1213590 (2023-001)

Material Weakness Repeat Finding
Requirement
M
Questioned Costs
-
Year
2023
Accepted
2026-05-04
Audit: 400500
Organization: City of Davis (CA)

AI Summary

  • Core Issue: The City did not collect all necessary documentation for Unitrans' reimbursement requests, violating subgrant agreement terms.
  • Impacted Requirements: Missing payroll documentation, vendor invoices, and payment records hinder compliance with federal grant requirements.
  • Recommended Follow-Up: Establish procedures to ensure complete documentation is obtained and retained for all future reimbursement requests from Unitrans.

Finding Text

Finding Reference Number: SA2023-001 Subrecipient Reimbursement Request Documentation AL Number: 20.507, 20.526 Assistance Listing Title: Federal Transit Cluster, Federal Transit - Formula Grants (Urbanized Area Formula Program) Federal Agency: Department of Transportation Federal Award Identification Number: CA-2020-214-01, CA-2023-225-00 Criteria: The City’s subgrant agreements with the Regents of the University of California on behalf of the Unitrans public transportation system include a provision that “All invoices must include the full supporting documentation required by FTA for reimbursement, including payroll documentation tracking hours worked on the Grant project, vendor/contractor invoicing, and documentation of vendor/contractor payment, such as accounts payable check copies.” Condition: We tested two reimbursement requests from Unitrans to the City: $1,700,000 for grant CA-2020-214-01 and $450,000 for grant CA-2023-225-00. Although the reimbursement requests were supported by schedules with totals by expenditure type in the “Analysis of Direct Operating Expenses” worksheet and summarized general ledger data, the full supporting documentation required by the subgrant agreements was not included. In addition, although we did note that the City monitors the activity of Unitrans on a quarterly basis and Unitrans is subject to a single audit, Unitrans is behind on completing its single audit, so a current report was not available. Effect: The City did not ensure its subrecipient complied with the provisions of the subgrant agreement and requested reimbursement from the grantor without having that detailed supporting documentation on file. Cause: We understand the University’s financial system at the time could not generate appropriate reports and City staff did not require the submission of the detailed information noted in the subgrant agreement. Recommendation: The City should develop procedures to ensure that the required documentation is obtained from Unitrans with each reimbursement request as required by the City’s subgrant agreement with the University, and the documentation should be retained in the City’s grant files. View of Responsible Officials and Planned Corrective Actions: Please see Corrective Action Plan separately prepared by the City.

Corrective Action Plan

Finding Reference Number: SA2023-001 Subrecipient Reimbursement Request Documentation AL Number: 20.507, 20.526 Assistance Listing Title: Federal Transit Cluster, Federal Transit - Formula Grants (Urbanized Area Formula Program) Federal Agency: Department of Transportation Federal Award Identification Number: CA-2020-214-01, CA-2023-225-00 • Fiscal Year of Initial Finding: 2023 • Name(s) of the contact person: Ryan Chapman, Director of Public Works Engineering & Transportation • Corrective Action Plan: Staff has developed a procedure to improve monitoring of its subrecipients to include a review of required documentation for reimbursement requests. This procedure has been created specifically for the Unitrans grant award but will be expanded to encompass all grant subawards and subrecipients. • Anticipated Completion Date: May 2026

Categories

Subrecipient Monitoring Cash Management Special Tests & Provisions

Other Findings in this Audit

  • 1213588 2023-001
    Material Weakness Repeat
  • 1213589 2023-001
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.027 CORONAVIRUS STATE AND LOCAL FISCAL RECOVERY FUNDS $4.81M
20.507 FEDERAL TRANSIT FORMULA GRANTS $2.00M
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $635,645
97.036 DISASTER GRANTS - PUBLIC ASSISTANCE (PRESIDENTIALLY DECLARED DISASTERS) $248,438
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $113,337
59.075 SHUTTERED VENUE OPERATORS GRANT PROGRAM $79,250
97.029 FLOOD MITIGATION ASSISTANCE $29,291
14.267 CONTINUUM OF CARE PROGRAM $23,323
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $19,903