Audit 400500

FY End
2023-06-30
Total Expended
$9.27M
Findings
3
Programs
9
Organization: City of Davis (CA)
Year: 2023 Accepted: 2026-05-04

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
1213588 2023-001 Material Weakness Yes M
1213589 2023-001 Material Weakness Yes M
1213590 2023-001 Material Weakness Yes M

Contacts

Name Title Type
VKLKHSYNDZ99 Alberto Preciado Auditee
5307475820 Amy Meyer Auditor
No contacts on file

Notes to SEFA

The Schedule of Expenditure of Federal Awards (the Schedule) includes expenditures of federal awards for the City of Davis, California, and its component units as disclosed in the notes to the Basic Financial Statements.
Basis of accounting refers to when revenues and expenditures or expenses are recognized in the accounts and reported in the financial statements, regardless of the measurement focus applied. The governmental fund financial statements are reported using the current financial resources measurement focus and the modified accrual basis of accounting. The proprietary and fiduciary fund financial statements are reported using the economic resources measurement focus and the accrual basis of accounting. Expenditures of Federal Awards reported on the Schedule are recognized when incurred.
The City has elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance.

Finding Details

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.