Finding 6472 (2023-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2023-12-26

AI Summary

  • Core Issue: DTC lacks a system to accurately identify and record federal expenditures, leading to a material weakness in reporting.
  • Impacted Requirements: Compliance with 2CFR Part 200 is compromised due to incomplete and inaccurate Schedule of Expenditures of Federal Awards (SEFA).
  • Recommended Follow-Up: Improve coordination between the grants and fiscal departments to ensure timely FTA drawdowns and regular reconciliations of grant expenses with the general ledger.

Finding Text

Program Name – All Assistance Listing Number – N/A Finding Type – Material Weakness Criteria – 2CFR Part 200 requires an auditee to prepare a complete and accurate Schedule of Expenditures of Federal Awards (SEFA). Condition – During our audit, we noted that DTC did not have a system in place to correctly identify and record the federal expenditures. We noted certain matters that collectively constituted a material weakness in reporting the federal expenditures. The items noted are as follows: • Due to lack of coordination between the grants department and the fiscal department, FTA drawdowns were not performed on a timely basis. Timing differences were noted in reporting the expenses in the financial statements and the federal drawdowns. It was further noted that a reconciliation of the grant-related expenses with the general ledger was not performed on a timely basis. Questioned Costs – None Cause/Effect – The SEFA was not accurately stated as a result of not identifying certain federal award expenditures.

Corrective Action Plan

DTC shall assign one responsible party to complete the Schedule of Expenditures of Federal Awards (SEFA). The SEFA shall be prepared and presented to auditors as required.

Categories

Reporting

Other Findings in this Audit

  • 6473 2023-003
    Significant Deficiency Repeat
  • 6474 2023-002
    Material Weakness Repeat
  • 6475 2023-003
    Significant Deficiency Repeat
  • 6476 2023-002
    Material Weakness Repeat
  • 6477 2023-003
    Significant Deficiency Repeat
  • 6478 2023-002
    Material Weakness Repeat
  • 6479 2023-003
    Significant Deficiency Repeat
  • 6480 2023-002
    Material Weakness Repeat
  • 6481 2023-003
    Significant Deficiency Repeat
  • 6482 2023-002
    Material Weakness Repeat
  • 6483 2023-003
    Significant Deficiency Repeat
  • 582914 2023-002
    Material Weakness Repeat
  • 582915 2023-003
    Significant Deficiency Repeat
  • 582916 2023-002
    Material Weakness Repeat
  • 582917 2023-003
    Significant Deficiency Repeat
  • 582918 2023-002
    Material Weakness Repeat
  • 582919 2023-003
    Significant Deficiency Repeat
  • 582920 2023-002
    Material Weakness Repeat
  • 582921 2023-003
    Significant Deficiency Repeat
  • 582922 2023-002
    Material Weakness Repeat
  • 582923 2023-003
    Significant Deficiency Repeat
  • 582924 2023-002
    Material Weakness Repeat
  • 582925 2023-003
    Significant Deficiency Repeat

Programs in Audit

ALN Program Name Expenditures
20.507 Federal Transit_formula Grants $421,478
20.525 State of Good Repair Grants Program $358,208
20.205 Highway Planning and Construction $76,120