Finding 43361 (2022-002)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-09-20
Audit: 52088
Auditor: Abdo LLP

AI Summary

  • Core Issue: Errors in federal expenditure calculations on the Schedule of Expenditures of Federal Awards led to an overstatement of $137,301.
  • Impacted Requirements: Compliance with Uniform Guidance for accurate reporting of federal expenditures was not met.
  • Recommended Follow-Up: Implement a review process and reconcile the Schedule with the accounting system; update the federal grant tracking spreadsheet by fiscal year.

Finding Text

Condition: During our audit, we noted errors related to calculations of federal expenditures on the Schedule of Expenditures of Federal Awards. Criteria: Uniform Guidance requires proper reporting of federal expenditures. Cause: Management did not have the information needed to prepare the Schedule of Expenditures of Federal Awards. Effect: As a result, federal expenditures were overstated by $137,301 on the Schedule of Expenditures of Federal Awards. Context: During our audit procedures, we identified one item on the Schedule of Expenditures of Federal Awards that did not include federal expenditures. Recommendation: We recommend that the Organization implement a review process to ensure correct reporting on the Schedule of Expenditures of Federal Awards prior to the audit, including a reconciliation between the Schedule of Expenditures of Federal Awards and the accounting system. We also recommend updating the federal grant tracking spreadsheet to track expenditures by fiscal year. Views of responsible officials: Management agrees with the finding.

Corrective Action Plan

2022-002 Material Weakness in Internal Controls over Compliance Recommendation: We recommend that the Organization implement a review process to ensure correct reporting on the Schedule of Expenditures of Federal Awards prior to the audit, including a reconciliation between the Schedule of Expenditures of Federal Awards and the accounting system. We also recommend updating the federal grant tracking spreadsheet to track expenditures by fiscal year. Planned Action: Community Transit of Watertown-Sisseton, Inc. will correct this deficiency in the 2023 fiscal year by reviewing the schedule of expenditures of Federal awards and the accounting system prior to the audit. CTWSI will update the federal grant tracking spreadsheet as soon as grant agreements become available which will co-inside with the fiscal year awarded.

Categories

Reporting

Other Findings in this Audit

  • 619803 2022-002
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.509 Formula Grants for Rural Areas and Tribal Transit Program $1.43M
20.526 Buses and Bus Facilities Formula, Competitive, and Low Or No Emissions Programs $182,652
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $66,304
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $47,195