Finding 608612 (2022-003)

Significant Deficiency Repeat Finding
Requirement
L
Questioned Costs
-
Year
2022
Accepted
2023-09-04

AI Summary

  • Core Issue: The District used an internal spreadsheet for drawdown calculations instead of the General Ledger, leading to potential inaccuracies in financial reporting.
  • Impacted Requirements: This finding violates 2 CFR Part 200.302(b)(1) and (b)(2), which require accurate tracking and reporting of federal awards.
  • Recommended Follow-Up: Establish clear policies to ensure all drawdowns are reconciled with proper documentation before reimbursement requests are made.

Finding Text

Finding 2022-03 - Source Documentation (Significant Deficiency) CFDA Title and Number: 20.513 (5310) Enhanced Mobility of Seniors and Individuals with Disabili-ties. Grant Agreement 33573 (City of Reedsport). Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Manage-ment CFDA Title and Number: 20.509 (5311) CARES 5311 Operating Assistance. Formula Grants for Rural Areas and Tribal Transit Program. Grant Agreement 34196. Name of Federal Agency: Transit Services Program Cluster Internal Control over Compliance: Cash Management Criteria: 2 CFR Part 200.302(b)(1) The financial management system of each non-federal entity must provide for the following: Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. 200.302(b)(2) Accurate, current, and complete dis-closure of the financial results of each Federal award or program in accordance with the reporting require-ments set forth in 200.328 and 200.329. Condition: The District prepared drawdown calculations according to an internal reconciliation spread-sheet tool outside of the General Ledger rather than utilizing proper General Ledger expenditure and sup-porting backup information. Cause: General ledger reconciling procedures were not enforced or completed. Effect or Potential Effect: Activities or costs that are allowed or allowable could potentially be overpaid or underpaid. Questioned Cost: No Context: During our testing of expenditures, we found no Federal drawdown reimbursement requests se-lected for testing that did not reconcile to their corresponding expenditures. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-8 Recommendation: The District should establish policies and procedures to ensure that each drawdown is reconciled with supporting expenditure documents and general ledger postings prior to reimbursement be-ing requested. District's Response: The District had relied on inadequately skilled or trained individuals for recording activity in the general ledger. General ledger activity was not available timely, or in sufficient quality such that the General Manager could rely upon the general ledger to gather information for reporting to grantors. Consequently, the General Manager developed and relied upon their own spreadsheet records for grant re-imbursement requests. Corrective Action Plan: The District has hired a Finance Manager to oversee the day-to-day financial operations of the District. The Finance Manager has made improvements in the general ledger recording and reporting for federal award requirements, but had not yet been able to eliminate the reliance upon the General Manager?s spreadsheet tool for grant management. The Finance Manager will continue to develop the general ledger procedures such that all necessary federal and state grant reporting requirements will be met within the general ledger. This will allow the activities of the district to be recorded and managed on a timely basis. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District

Categories

Cash Management

Other Findings in this Audit

  • 30657 2022-001
    Significant Deficiency Repeat
  • 30658 2022-002
    Material Weakness Repeat
  • 30659 2022-003
    Significant Deficiency Repeat
  • 30660 2022-004
    Material Weakness Repeat
  • 30661 2022-001
    Significant Deficiency Repeat
  • 30662 2022-002
    Material Weakness Repeat
  • 30663 2022-003
    Significant Deficiency Repeat
  • 30664 2022-004
    Material Weakness Repeat
  • 30665 2022-001
    Significant Deficiency Repeat
  • 30666 2022-002
    Material Weakness Repeat
  • 30667 2022-003
    Significant Deficiency Repeat
  • 30668 2022-004
    Material Weakness Repeat
  • 32168 2022-001
    Significant Deficiency Repeat
  • 32169 2022-002
    Material Weakness Repeat
  • 32170 2022-003
    Significant Deficiency Repeat
  • 32171 2022-004
    Material Weakness Repeat
  • 32172 2022-001
    Significant Deficiency Repeat
  • 32173 2022-002
    Material Weakness Repeat
  • 32174 2022-003
    Significant Deficiency Repeat
  • 32175 2022-004
    Material Weakness Repeat
  • 32176 2022-001
    Significant Deficiency Repeat
  • 32177 2022-002
    Material Weakness Repeat
  • 32178 2022-003
    Significant Deficiency Repeat
  • 32179 2022-004
    Material Weakness Repeat
  • 32180 2022-001
    Significant Deficiency Repeat
  • 32181 2022-002
    Material Weakness Repeat
  • 32182 2022-003
    Significant Deficiency Repeat
  • 32183 2022-004
    Material Weakness Repeat
  • 32184 2022-001
    Significant Deficiency Repeat
  • 32185 2022-002
    Material Weakness Repeat
  • 32186 2022-003
    Significant Deficiency Repeat
  • 32187 2022-004
    Material Weakness Repeat
  • 32188 2022-001
    Significant Deficiency Repeat
  • 32189 2022-002
    Material Weakness Repeat
  • 32190 2022-003
    Significant Deficiency Repeat
  • 32191 2022-004
    Material Weakness Repeat
  • 607099 2022-001
    Significant Deficiency Repeat
  • 607100 2022-002
    Material Weakness Repeat
  • 607101 2022-003
    Significant Deficiency Repeat
  • 607102 2022-004
    Material Weakness Repeat
  • 607103 2022-001
    Significant Deficiency Repeat
  • 607104 2022-002
    Material Weakness Repeat
  • 607105 2022-003
    Significant Deficiency Repeat
  • 607106 2022-004
    Material Weakness Repeat
  • 607107 2022-001
    Significant Deficiency Repeat
  • 607108 2022-002
    Material Weakness Repeat
  • 607109 2022-003
    Significant Deficiency Repeat
  • 607110 2022-004
    Material Weakness Repeat
  • 608610 2022-001
    Significant Deficiency Repeat
  • 608611 2022-002
    Material Weakness Repeat
  • 608613 2022-004
    Material Weakness Repeat
  • 608614 2022-001
    Significant Deficiency Repeat
  • 608615 2022-002
    Material Weakness Repeat
  • 608616 2022-003
    Significant Deficiency Repeat
  • 608617 2022-004
    Material Weakness Repeat
  • 608618 2022-001
    Significant Deficiency Repeat
  • 608619 2022-002
    Material Weakness Repeat
  • 608620 2022-003
    Significant Deficiency Repeat
  • 608621 2022-004
    Material Weakness Repeat
  • 608622 2022-001
    Significant Deficiency Repeat
  • 608623 2022-002
    Material Weakness Repeat
  • 608624 2022-003
    Significant Deficiency Repeat
  • 608625 2022-004
    Material Weakness Repeat
  • 608626 2022-001
    Significant Deficiency Repeat
  • 608627 2022-002
    Material Weakness Repeat
  • 608628 2022-003
    Significant Deficiency Repeat
  • 608629 2022-004
    Material Weakness Repeat
  • 608630 2022-001
    Significant Deficiency Repeat
  • 608631 2022-002
    Material Weakness Repeat
  • 608632 2022-003
    Significant Deficiency Repeat
  • 608633 2022-004
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $11,086
20.509 Formula Grants for Rural Areas and Tribal Transit Program $7,975