Finding 374564 (2023-001)

Material Weakness
Requirement
L
Questioned Costs
-
Year
2023
Accepted
2024-03-08

AI Summary

  • Core Issue: The schedule of expenditures of federal awards (SEFA) for FY22-23 was inaccurately prepared, overstating federal expenditures by $2,591,504 due to cash disbursements not being made by the reporting date.
  • Impacted Requirements: Compliance with 2 CFR 200.508(b) and 2 CFR 200.510(b) was not met, as the SEFA was not aligned with cash basis accounting principles.
  • Recommended Follow-Up: The Authority should enhance internal controls and review processes to ensure accurate reporting of expenditures on the SEFA, including implementing a reconciliation schedule for future fiscal years.

Finding Text

Assistance Listing, Federal Agency, and Program Name - 20.507, 20.525, 20.526, U.S. Department of Transportation, Federal Transit Cluster Federal Award Identification Number and Year - All Pass-through Entity - N/A Finding Type - Material weakness and material noncompliance Repeat Finding - No Criteria - Per 2 CFR 200.508(b), an auditee must properly prepare the schedule of expenditures of federal awards (SEFA). Per 2 CFR 200.510(b), the SEFA for the period covered by the auditee's financial statements must include the total federal awards expended as determined in accordance with 2 CFR 200.502, which describes the basis for determining federal awards expenses. Per 2 CFR 200.71(2), for a SEFA prepared on a cash basis, expenditures are the sum of (i) cash disbursements for direct charges for property and services; (ii) the amount of indirect expense charged; (iii) the value of third-party in-kind contributions applied; and (iv) the amount of cash advance payments and payments made to subrecipients. Condition - The SEFA for the year ended June 30, 2023 was not accurately prepared in accordance with the Authority’s accounting policy for a cash basis SEFA, as it originally included expenditures that were direct charges for property and services, but cash disbursement had not been made as of June 30, 2023. Questioned Costs - None Identification of How Questioned Costs Were Computed - N/A Context - Required revisions were identified during the audit to ensure that the schedule of expenditures of federal awards was accurately stated on a cash basis. These revisions related to $2,591,504 of federal expenditures where goods and services had been received as of June 30, 2023 that were originally on the SEFA, but cash disbursement had not been made for these direct charges as of June 30, 2023 and therefore should not have been included in the cash basis SEFA. Cause and Effect - Internal control procedures relative to the identification of federal expenditures to be reported on the SEFA did not operate effectively to ensure proper presentation of the SEFA under a cash basis model. This resulted in the Authority's schedule of expenditures of federal awards to be overstated prior to auditor identified revisions. Recommendation - The Authority should expand procedures and review processes to ensure the proper expenditures are reported on the schedule of expenditures of federal awards in the proper period. Views of Responsible Officials and Corrective Action Plan - The SEFA was originally prepared on an accrual basis as has been done in prior years. Due to the ability to use Covid-19 funding for operating expenses, the reporting basis was changed from accrual to cash in FY21-22 without changing internal procedures for creation of the SEFA. This caused the FY22-23 SEFA to be completed on an accrual basis and need to be revised and resubmitted to the auditors. The corrective action has been implemented to revise internal procedures to prepare the SEFA on a cash basis for future fiscal years. This includes the creation of a reconciliation schedule to the financial statements which are prepared on an accrual basis.

Categories

Reporting Subrecipient Monitoring

Other Findings in this Audit

  • 374544 2023-001
    Material Weakness
  • 374545 2023-001
    Material Weakness
  • 374546 2023-001
    Material Weakness
  • 374547 2023-001
    Material Weakness
  • 374548 2023-001
    Material Weakness
  • 374549 2023-001
    Material Weakness
  • 374550 2023-001
    Material Weakness
  • 374551 2023-001
    Material Weakness
  • 374552 2023-001
    Material Weakness
  • 374553 2023-001
    Material Weakness
  • 374554 2023-001
    Material Weakness
  • 374555 2023-001
    Material Weakness
  • 374556 2023-001
    Material Weakness
  • 374557 2023-001
    Material Weakness
  • 374558 2023-001
    Material Weakness
  • 374559 2023-001
    Material Weakness
  • 374560 2023-001
    Material Weakness
  • 374561 2023-001
    Material Weakness
  • 374562 2023-001
    Material Weakness
  • 374563 2023-001
    Material Weakness
  • 374565 2023-001
    Material Weakness
  • 374566 2023-001
    Material Weakness
  • 374567 2023-001
    Material Weakness
  • 374568 2023-001
    Material Weakness
  • 374569 2023-001
    Material Weakness
  • 374570 2023-002
    Material Weakness
  • 950986 2023-001
    Material Weakness
  • 950987 2023-001
    Material Weakness
  • 950988 2023-001
    Material Weakness
  • 950989 2023-001
    Material Weakness
  • 950990 2023-001
    Material Weakness
  • 950991 2023-001
    Material Weakness
  • 950992 2023-001
    Material Weakness
  • 950993 2023-001
    Material Weakness
  • 950994 2023-001
    Material Weakness
  • 950995 2023-001
    Material Weakness
  • 950996 2023-001
    Material Weakness
  • 950997 2023-001
    Material Weakness
  • 950998 2023-001
    Material Weakness
  • 950999 2023-001
    Material Weakness
  • 951000 2023-001
    Material Weakness
  • 951001 2023-001
    Material Weakness
  • 951002 2023-001
    Material Weakness
  • 951003 2023-001
    Material Weakness
  • 951004 2023-001
    Material Weakness
  • 951005 2023-001
    Material Weakness
  • 951006 2023-001
    Material Weakness
  • 951007 2023-001
    Material Weakness
  • 951008 2023-001
    Material Weakness
  • 951009 2023-001
    Material Weakness
  • 951010 2023-001
    Material Weakness
  • 951011 2023-001
    Material Weakness
  • 951012 2023-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.507 Covid-19 - Federal Transit_formula Grants $5.75M
20.205 Highway Planning and Construction $4.00M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $1.47M
20.321 Railroad Safety Technology Grants $633,461
20.507 Federal Transit_formula Grants $470,652
20.525 State of Good Repair Grants Program $30,000
20.530 Public Transportation Innovation $10,589