Finding 971365 (2023-003)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-04-26
Audit: 304770
Auditor: Davis Farr LLP

AI Summary

  • Core Issue: A significant error was found in the Schedule of Expenditures of Federal Awards (SEFA) due to the omission of the TIFIA Program, totaling over $537 million.
  • Impacted Requirements: This misstatement affected the assessment of major federal programs and compliance with 2 CFR 200.508 regarding internal controls.
  • Recommended Follow-Up: SANDAG should improve internal controls to ensure all federal awards are identified and accurately reported in the SEFA.

Finding Text

2 CFR 200.508 requires that proper internal controls are in place for the preparation of the Schedule of Expenditures of Federal Awards (SEFA), which must include the total federal awards expended and the Assistance Listing Number for each individual federal program. The auditors are required to determine whether the SEFA is stated fairly in all material respects in relation to the auditee’s financial statements as a whole. The auditors also utilize the SEFA for the determination of the major federal programs that will be audited. Condition During our audit, we became aware of a material misstatement in the SEFA due to an excluded federal program: the Transportation Infrastructure Finance and Innovation Act (TIFIA) Program with federal expenditures of $537,484,439 for the fiscal year ended June 30, 2023. Effect As a result of correcting the error in the SEFA, the TIFIA program was assessed for testing as a major program and met the criteria to require the program to be tested. Additionally, another major program that had already been selected and tested no longer was required to be tested as a major program. Cause The TIFIA program expenditures were new in the fiscal year ended June 30, 2023 and SANDAG’s system of internal controls did not identify the program as federal expenditures subject to the single audit requirements. Recommendation We recommend SANDAG enhance the system of internal controls for identification of federal awards subject to the single audit requirements and the preparation and review of the SEFA for accuracy and completeness.

Categories

Reporting

Other Findings in this Audit

  • 394923 2023-003
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.223 Transportation Infrastructure Finance and Innovation Act (tifia) Program $537.48M
20.500 Federal Transit_capital Investment Grants $174.37M
20.205 Highway Planning and Construction $39.25M
20.507 Federal Transit_formula Grants $24.52M
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $3.18M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $2.12M
20.200 Highway Research and Development Program $1.07M
20.534 Community Project Funding Congressionally Directed Spending $1.00M
20.233 Border Enforcement Grants $678,264
12.003 Community Economic Adjustment Assistance for Responding to Threats to the Resilience of A Military Installation (b) $535,824
16.609 Project Safe Neighborhoods $238,887
84.215 Fund for the Improvement of Education $183,244
16.738 Edward Byrne Memorial Justice Assistance Grant Program $122,866
16.320 Services for Trafficking Victims $39,583