Finding 1218997 (2024-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2024
Accepted
2026-06-26

AI Summary

  • Core Issue: The Schedule of Expenditures of Federal Awards (SEFA) was incomplete, missing over $7 million in federal expenditures due to inadequate internal controls.
  • Impacted Requirements: Noncompliance with Uniform Guidance (2 CFR 200.510b) and errors in identifying expenditures as per 2 CFR 200.502 led to an understatement of federal awards.
  • Recommended Follow-Up: CapMetro should improve controls for identifying and reporting federal expenditures to ensure accurate SEFA preparation during year-end close processes.

Finding Text

Finding 2024-002: Preparation of the Schedule of Expenditures of Federal Awards Material weakness/other matter noncompliance Criteria: The Uniform Guidance (2 CFR 200.510b) requires that the auditee (typically a non-federal entity receiving federal funds) must prepare a Schedule of Expenditures of Federal Awards (SEFA) for the period covered by its financial statements which must include the total Federal Awards expended as determined in accordance with 2 CFR 200.502. Condition: The original SEFA provided to the auditors for the year ended September 30, 2024, excluded $7,110,697 in federal expenditures across seven different programs because of inappropriate application of pre-award authority. For a breakdown of the exclusions by program refer to the “Effect” section below. Of the excluded amount, $6,213,216 was for ALN 20.534 Community Project Funding Congressionally Directed Spending (AL #20.534). Cause: The existing internal control procedures for processing year end activity to fully support the SEFA reporting cutoff deadline is deficient. While a process is in place, it does not fully capture all the needed communication, coordinated review, and approval leading to eligible expenditures being omitted. Effect: The Authority failed to appropriately prepare the SEFA in compliance with the Uniform Guidance (2 CFR 200.510b) as a result of errors in identifying expenditures in accordance with 2 CFR.502. The impact on each of the programs on the SEFA is as follows: These errors and corresponding deficiencies could impact future federal award funding programs. Context: As a result of the omission of eligible expenditures, total federal awards for ALN 20.534, Community Project Funding Congressionally Directed Spending, were understated by $6,213,216 due to the exclusion of expenditures. This understatement caused the major program determination to be improperly calculated and resulted in a missed major program. Questioned Costs: None Repeat Finding: No Recommendation: We recommend that CapMetro re-evaluate their controls related to the identification and accrual of federal expenditures as well as the control process for the preparation of the schedule of expenditures of federal awards during their year-end close process to ensure timely and accurate reporting. View of Responsible Officials: Management agrees with this finding and acknowledges the material weakness in internal controls related to the preparation and review of the Schedule of Expenditures of Federal Awards (SEFA). The control deficiency resulted in eligible federal expenditures being omitted from the SEFA, causing federal expenditures to be understated for the reporting period.

Corrective Action Plan

To address the finding, the Authority has implemented corrective actions that include establishing a formal year-end SEFA preparation and review process involving Accounting and Grant Program Mangers; reconciling federal expenditures reported on the SEFA to the general ledger and year end accruals, reviewing active federal awards at fiscal year-end to identify eligible expenditures that may not have been reported; Revising the Grants Management Procedures Manual to formalize year-end cutoff, review, reconciliation, and approval procedures prior to SEFA issuance. These procedures will be incorporated into the FY26 year-end close and reporting process.

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1218985 2024-002
    Material Weakness Repeat
  • 1218986 2024-002
    Material Weakness Repeat
  • 1218987 2024-002
    Material Weakness Repeat
  • 1218988 2024-002
    Material Weakness Repeat
  • 1218989 2024-002
    Material Weakness Repeat
  • 1218990 2024-002
    Material Weakness Repeat
  • 1218991 2024-002
    Material Weakness Repeat
  • 1218992 2024-002
    Material Weakness Repeat
  • 1218993 2024-002
    Material Weakness Repeat
  • 1218994 2024-002
    Material Weakness Repeat
  • 1218995 2024-002
    Material Weakness Repeat
  • 1218996 2024-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 FEDERAL TRANSIT FORMULA GRANTS $21.74M
20.500 FEDERAL TRANSIT CAPITAL INVESTMENT GRANTS $15.14M
20.534 COMMUNITY PROJECT FUNDING CONGRESSIONALLY DIRECTED SPENDING $3.30M
20.526 BUSES AND BUS FACILITIES FORMULA, COMPETITIVE, AND LOW OR NO EMISSIONS PROGRAMS $2.79M
20.325 CONSOLIDATED RAIL INFRASTRUCTURE AND SAFETY IMPROVEMENTS $1.54M
20.513 ENHANCED MOBILITY OF SENIORS AND INDIVIDUALS WITH DISABILITIES $1.05M
20.530 PUBLIC TRANSPORTATION INNOVATION $550,738
20.205 HIGHWAY PLANNING AND CONSTRUCTION $496,741
20.527 PUBLIC TRANSPORTATION EMERGENCY RELIEF PROGRAM $300,931
97.075 RAIL AND TRANSIT SECURITY GRANT PROGRAM $120,000
10.558 CHILD AND ADULT CARE FOOD PROGRAM $12,113