Federal Grantor: US Department of Transportation, Federal Transit Administration, Federal Transit Formula Grants, Direct Award, All Award under Assistance List (AL) Number 20.507 Effect: Expenses were misallocated to individual routes and purposes, resulting in an overclaim of Woodland preventative ...
Federal Grantor: US Department of Transportation, Federal Transit Administration, Federal Transit Formula Grants, Direct Award, All Award under Assistance List (AL) Number 20.507 Effect: Expenses were misallocated to individual routes and purposes, resulting in an overclaim of Woodland preventative maintenance expenses of $12,268 under grant CA-2022-204. Auditor Recommendation: We recommend the District develop written procedures for allocating expenses to routes and purposes used to claim expenses under federal grants, including what data should be input into the allocation spreadsheet, the formulas used to allocate each type of expense to routes, which expenses should be allocated to each route and purpose (operating, preventive maintenance, etc.) and which expenses may not be allocated to certain routes and purposes. A summary tab should be added to the spreadsheet to sum amounts for each route computed on separate tabs on the spreadsheet to make it easier to reconcile total operating expenses, preventive maintenance, insurance, communications and other expenses to the general ledger. The District should also contact the FTA to discuss how to address the $12,268 amount overclaimed. YCTD Contact Person Responsible for the Corrective Action: Leo Levenson, Inteirm CFO, Llevenson@yctd.org. Management Response and Corrective Action Plan: YCTD concurs with the finding and recommendation. YCTD has already contacted the FTA regional office and followed their guidance on how to return the $12,268 amount overclaimed. YCTD will formalize new written procedures and summary spreadsheet tabs as recommended by the auditor, with a target date for completion of March 31, 2023.