Finding 1121158 (2024-005)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2025-03-31

AI Summary

  • Core Issue: Management provided inaccurate versions of the Schedule of Expenditures of Federal Awards (SEFA), leading to multiple revisions and highlighting a lack of effective internal controls.
  • Impacted Requirements: Noncompliance with 2 CFR § 200.510(b) due to failure in preparing a complete and accurate SEFA, increasing the risk of material misstatements.
  • Recommended Follow-Up: Implement a formal review process, enhance communication between departments, provide staff training on federal reporting, and ensure a final supervisory review of the SEFA before submission.

Finding Text

Finding Reference 2024-05 Assistance Listing Number 20.205 Highway Planning and Construction (Federal-Aid Highway Program) 21.027 Coronavirus State and Local Fiscal Recovery Funds Name of Federal Agency Department of Transportation / Department of Treasury Type of Finding: Material Weakness on Internal Control and Noncompliance Condition: During the audit, management repeatedly provided inaccurate versions of the Schedule of Expenditures of Federal Awards (SEFA) to the auditors, requiring multiple revisions to correct errors in the total federal awards expended for programs 20.205 Highway Planning and Construction (Federal-Aid Highway Program) and 21.027 Coronavirus State and Local Fiscal Recovery Funds. Criteria: In accordance with 2 CFR § 200.510(b) (Financial Statements and SEFA Requirements), the auditee must: 1) Prepare an accurate SEFA that includes the total federal awards expended for the period under audit. 2) Ensure the SEFA is complete, accurate, and properly classified by fiscal year. 3) Provide sufficient information to allow auditors to test compliance with federal requirements. Cause: The recurring errors in the SEFA preparation indicate a lack of effective internal controls over preparation of the SEFA, particularly in ensuring that expenditures are accurately classified and reported within the correct fiscal year:  A lack of oversight and reconciliation procedures to ensure expenditures are reported in the correct fiscal year.  Inadequate review processes before submission of the SEFA to the auditors. Effect: The errors in the SEFA resulted in the following issues:  Increased Risk of Material Misstatements within the SEFA – The multiple revisions required to correct significant errors in reported expenditures highlight a heightened risk of material misstatements in the SEFA, which could lead to misrepresentation of federal funding received and expended.  Noncompliance with Uniform Guidance Requirements – The failure to prepare an accurate SEFA resulted in noncompliance with 2 CFR § 200.510(b), which requires the auditee to provide a complete and accurate accounting of federal expenditures for the audit. Questioned Costs: No questioned costs were identified, as the issue relates to the misclassification and misstatement of expenditures, rather than the allowability of costs. Recommendation: To ensure compliance with 2 CFR § 200.510(b) and improve internal controls over SEFA preparation, we recommend that the Authority: 1) Implement a formal review and reconciliation process to ensure federal expenditures are accurately reported in the correct fiscal year. 2) Enhance communication between finance and grant administration personnel to improve accuracy in expenditure classification. 3) Provide additional training to staff responsible for SEFA preparation on Uniform Guidance requirements for federal reporting. 4) Require a final, documented supervisory review of the SEFA before submission for audit to prevent reporting inaccuracies. Views of Responsible Officials Refer to Management’s unaudited corrective action plan.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 544712 2024-002
    Significant Deficiency Repeat
  • 544713 2024-003
    Significant Deficiency
  • 544714 2024-005
    Significant Deficiency
  • 544715 2024-004
    Significant Deficiency Repeat
  • 544716 2024-005
    Material Weakness
  • 544717 2024-006
    Material Weakness
  • 1121154 2024-002
    Significant Deficiency Repeat
  • 1121155 2024-003
    Significant Deficiency
  • 1121156 2024-005
    Significant Deficiency
  • 1121157 2024-004
    Significant Deficiency Repeat
  • 1121159 2024-006
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $187.56M
20.507 Federal Transit Formula Grants $12.30M
20.527 Public Transportation Emergency Relief Program $5.84M
20.525 State of Good Repair Grants Program $5.79M
20.500 Federal Transit Capital Investment Grants $5.23M
21.027 Coronavirus State and Local Fiscal Recovery Funds $1.76M
20.505 Metropolitan Transportation Planning and State and Non-Metropolitan Planning and Research $1.06M
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $1.06M
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $244,290
20.509 Formula Grants for Rural Areas and Tribal Transit Program $104,711
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $49,373