Finding 620126 (2022-005)

Material Weakness
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-01-04

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 for preparing a complete and accurate Schedule of Expenditures of Federal Awards (SEFA) is not met.
  • Recommended Follow-Up: DTC should enhance internal controls for reconciling grant records with the general ledger and ensure timely updates to the SEFA preparation process.

Finding Text

Program Name ? ALL CFDA 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. ? The grants department performed a grants reconciliation which resulted in paybacks and drawdowns of federal funds under various projects. Questioned Costs ? None Cause/Effect ? The SEFA was not accurately stated as a result of not identifying certain federal award expenditures. Identification of a Repeat Finding ? This is not a repeat finding from the immediate previous audit. Recommendation ? Although an improvement was noted in the grants reconciliation process from the previous years, we recommend that DTC?s internal controls should be adequately designed to ensure that the general ledger and the grant records are reconciled and discrepancies if any are brought to attention in a timely manner. Additionally, DTC should strive to implement controls over the preparation of the SEFA to ensure that amounts are properly recorded on SEFA. View of Responsible Official and Corrective Action Plan ? DTC had multiple key leadership changes shortly prior to and during the financial audit. DTC will perform periodic reconciliations throughout the fiscal year between grants records and the general ledger. DTC will ensure related policies and procedures are updated, staff trained, and documented evidence is maintained.

Categories

Reporting

Other Findings in this Audit

  • 43668 2022-005
    Material Weakness
  • 43669 2022-006
    Significant Deficiency
  • 43670 2022-005
    Material Weakness
  • 43671 2022-006
    Significant Deficiency
  • 43672 2022-005
    Material Weakness
  • 43673 2022-006
    Significant Deficiency
  • 43674 2022-005
    Material Weakness
  • 43675 2022-006
    Significant Deficiency
  • 43676 2022-005
    Material Weakness
  • 43677 2022-006
    Significant Deficiency
  • 43678 2022-005
    Material Weakness
  • 43679 2022-006
    Significant Deficiency
  • 43680 2022-005
    Material Weakness
  • 43681 2022-006
    Significant Deficiency
  • 43682 2022-005
    Material Weakness
  • 43683 2022-006
    Significant Deficiency
  • 43684 2022-005
    Material Weakness
  • 43685 2022-006
    Significant Deficiency
  • 620110 2022-005
    Material Weakness
  • 620111 2022-006
    Significant Deficiency
  • 620112 2022-005
    Material Weakness
  • 620113 2022-006
    Significant Deficiency
  • 620114 2022-005
    Material Weakness
  • 620115 2022-006
    Significant Deficiency
  • 620116 2022-005
    Material Weakness
  • 620117 2022-006
    Significant Deficiency
  • 620118 2022-005
    Material Weakness
  • 620119 2022-006
    Significant Deficiency
  • 620120 2022-005
    Material Weakness
  • 620121 2022-006
    Significant Deficiency
  • 620122 2022-005
    Material Weakness
  • 620123 2022-006
    Significant Deficiency
  • 620124 2022-005
    Material Weakness
  • 620125 2022-006
    Significant Deficiency
  • 620127 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
20.507 Federal Transit_formula Grants $278,594
20.525 State of Good Repair Grants Program $106,181
20.205 Highway Planning and Construction $76,120