Finding 30664 (2022-004)

Material Weakness Repeat Finding
Requirement
B
Questioned Costs
-
Year
2022
Accepted
2023-09-04

AI Summary

  • Core Issue: Umpqua Public Transportation District's financial management system is inadequate, failing to fully separate Federal, State, and Local expenditures and revenues for the entire fiscal year.
  • Impacted Requirements: The district is not meeting CFR Part 200.302.b, which mandates accurate tracking and reporting of Federal awards and programs.
  • Recommended Follow-Up: Implement a robust general ledger structure, establish clear policies for reporting, and provide training for staff on managing Federal grants.

Finding Text

Finding 2022-04 ? Fiscal Management System (Material Weakness) Criteria: CFR Part 200.302.b Auditee Responsibilities includes the requirement that the financial manage-ment system of each non-Federal entity provide the following. Identification, in its accounts, of all Federal awards received and expended and the Federal programs under which they were received. Accurate, cur-rent, and complete disclosure of the financial results of each Federal award or program. Condition: During the audit of Umpqua Public Transportation District for Fiscal Year 2021-2022, the dis-trict provided auditor with Separate and Identifiable General Ledger reports that showed a clear division be-tween Federal, State and Local expenditures and revenues. However, the separation was done retroactivity and was not been completed for the entire fiscal year or life of grants. This deficiency was instrumental in causing the general ledger to be inadequate for financial and Federal Award Reporting. Cause: The District had originally relied on unskilled individuals for structuring and recording activities in their general ledger. District management did not have sufficient staff or monitoring policies to recognize and correct the deficiency. While trained staff have been hired at Umpqua Public Transportation District, and improvements made to the general ledger and recording of Federal grants, improvements are still nec-essary to meet the full requirements of CFR Part 200.302.b Auditee Responsibilities. Effect or Potential Effect: Potential for incorrect financial reporting, and untimely results, with the inabil-ity to rely on the general ledger for correct and timely information. Questioned Cost: No Context: While federal grant revenues and expenditures are now tracked using the general ledger ?jobs? indicators, additional recording is needed to track the matching portions of the costs and revenues of those federal grants. The lack of completed effort at separating revenues or expenditures by grant may lead to er-rors in reporting expenditures for Federal Awards. Repeat of a Prior-Year Finding: Yes, Findings and Questioned Costs 2021-11 Recommendation: We recommend that Umpqua Public Transportation District improve their general ledg-er structure to meet the requirement for separate accounts for Federal awards for program revenues and program expenditures. We also recommend that the district establish policies and procedures to ensure that all program revenues and expenditures are reported in the correct fiscal year. In addition, we recommend that the district establish a training program and policies and procedures for staff and management to re-ceive appropriate training for administering and recording Federal Grant revenues and expenditures. District's Response: The District concurs with the recommendation. General ledger accounts separating Federal, State, and Local revenues and related expenditures will be designed and implemented. 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 developed an accounting system for separating Feder-al, State, and Local revenues and related expenditures. This will allow the activities of the district to be rec-orded in a manner that allows for reporting in compliance with federal requirements. Planned Implementation Date: July 1, 2022 Responsible Person: General Manager, Umpqua Public Transit District

Categories

Reporting Matching / Level of Effort / Earmarking Subrecipient Monitoring Material Weakness

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
  • 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
  • 608612 2022-003
    Significant Deficiency 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