Finding 374593 (2023-008)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2023
Accepted
2024-03-08

AI Summary

  • Core Issue: The City of Olean's bank reconciliations for various funds do not match the general ledger, leading to potential inaccuracies in cash balances.
  • Impacted Requirements: Inaccurate cash balances can result in financial reporting errors that may go undetected if not addressed promptly.
  • Recommended Follow-Up: The City should ensure that general ledger cash balances are regularly compared to bank reconciliations, with any discrepancies investigated and corrected immediately.

Finding Text

Conditions and Criteria: The City of Olean prepares its bank reconciliation electronically utilizing its accounting software. The cash balances per the bank reconciliations for the General, Water, Sewer and Capital did not agree the general ledger. The bank reconciliations also includes transactions that were not correctly recorded during the current year. Effect: At times throughout the year, the City’s cash balances reported within its general ledger are incorrect. The effect of not investigating and correcting bank reconciliation transactions that are improperly posted is that reporting errors in financial reporting can occur and not be detected or resolved in a timely manner. Auditors’ Recommendation: As part of the bank reconciliation preparation and review, the City’s general ledger cash balances should be compared against the bank reconciliation, with any differences being immediately investigated and corrected. City’s Response: The City Auditor, Lens Martial, understands the importance of the bank reconciliation process and will investigate and correct any reconciling differences as they occur. Differences existed related to the timing of payroll transfers made from the general checking account to the payroll account. The City Auditor will put a process in place to verify that these transactions are properly accounted for on the bank reconciliations.

Corrective Action Plan

Auditors’ Recommendation: As part of the bank reconciliation preparation and review, the City’s general ledger cash balances should be compared against the bank reconciliation, with any differences being immediately investigated and corrected. City’s Response: The City Auditor, Lens Martial, understands the importance of the bank reconciliation process and will investigate and correct any reconciling differences as they occur. Differences existed related to the timing of payroll transfers made from the general checking account to the payroll account. The City Auditor will put a process in place to verify that these transactions are properly accounted for on the bank reconciliations during the year ending May 31, 2024.

Categories

Reporting

Other Findings in this Audit

  • 374572 2023-005
    Material Weakness Repeat
  • 374573 2023-005
    Material Weakness Repeat
  • 374574 2023-005
    Material Weakness Repeat
  • 374575 2023-005
    Material Weakness Repeat
  • 374576 2023-005
    Material Weakness Repeat
  • 374577 2023-005
    Material Weakness Repeat
  • 374578 2023-005
    Material Weakness Repeat
  • 374579 2023-006
    Material Weakness Repeat
  • 374580 2023-006
    Material Weakness Repeat
  • 374581 2023-006
    Material Weakness Repeat
  • 374582 2023-006
    Material Weakness Repeat
  • 374583 2023-006
    Material Weakness Repeat
  • 374584 2023-006
    Material Weakness Repeat
  • 374585 2023-006
    Material Weakness Repeat
  • 374586 2023-007
    Material Weakness Repeat
  • 374587 2023-007
    Material Weakness Repeat
  • 374588 2023-007
    Material Weakness Repeat
  • 374589 2023-007
    Material Weakness Repeat
  • 374590 2023-007
    Material Weakness Repeat
  • 374591 2023-007
    Material Weakness Repeat
  • 374592 2023-007
    Material Weakness Repeat
  • 374594 2023-008
    Material Weakness Repeat
  • 374595 2023-008
    Material Weakness Repeat
  • 374596 2023-008
    Material Weakness Repeat
  • 374597 2023-008
    Material Weakness Repeat
  • 374598 2023-008
    Material Weakness Repeat
  • 374599 2023-008
    Material Weakness Repeat
  • 951014 2023-005
    Material Weakness Repeat
  • 951015 2023-005
    Material Weakness Repeat
  • 951016 2023-005
    Material Weakness Repeat
  • 951017 2023-005
    Material Weakness Repeat
  • 951018 2023-005
    Material Weakness Repeat
  • 951019 2023-005
    Material Weakness Repeat
  • 951020 2023-005
    Material Weakness Repeat
  • 951021 2023-006
    Material Weakness Repeat
  • 951022 2023-006
    Material Weakness Repeat
  • 951023 2023-006
    Material Weakness Repeat
  • 951024 2023-006
    Material Weakness Repeat
  • 951025 2023-006
    Material Weakness Repeat
  • 951026 2023-006
    Material Weakness Repeat
  • 951027 2023-006
    Material Weakness Repeat
  • 951028 2023-007
    Material Weakness Repeat
  • 951029 2023-007
    Material Weakness Repeat
  • 951030 2023-007
    Material Weakness Repeat
  • 951031 2023-007
    Material Weakness Repeat
  • 951032 2023-007
    Material Weakness Repeat
  • 951033 2023-007
    Material Weakness Repeat
  • 951034 2023-007
    Material Weakness Repeat
  • 951035 2023-008
    Material Weakness Repeat
  • 951036 2023-008
    Material Weakness Repeat
  • 951037 2023-008
    Material Weakness Repeat
  • 951038 2023-008
    Material Weakness Repeat
  • 951039 2023-008
    Material Weakness Repeat
  • 951040 2023-008
    Material Weakness Repeat
  • 951041 2023-008
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
20.106 Airport Improvement Program - Runway 4-22 Rehabilitation $2.01M
20.509 Covid-19 - Section 5311 Rural Area Cares Act Program $29,708
20.106 Airport Improvement Program - Taxiway A&b Rehabilitation (design) $14,240
16.607 Bulletproof Vest Partnership Program $13,200
20.106 Airport Improvement Program - Taxiway A&b Rehabilitation $2,753
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $2,697