Finding 35410 (2022-006)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-03-23

AI Summary

  • Core Issue: The City does not regularly reconcile asset and liability accounts, leading to potential misstatements in the general ledger.
  • Impacted Requirements: Inaccurate financial information affects management's decision-making and budget establishment.
  • Recommended Follow-Up: Implement monthly reconciliations of all asset and liability accounts, with management reviews for accuracy and timeliness.

Finding Text

Reconciliation of General Ledger and Capital Projects Condition and Criteria: During our audit, we noted that the City does not perform reconciliations of assets and liability accounts during the year on regular or routine basis, including cash, receivables, payables and interfund loan balances. In addition, the City maintained manual records along with its general ledger system for the capital projects fund. Although dual systems were maintained throughout the year, differences that arise in certain balance sheet accounts and revenue and expense accounts were not investigated and corrected until the audit. Effect: Without regular and routine reconciliation of asset and liability accounts balances, a significant misstatement in the general ledger of the City would go undetected for extended periods of time and could result in inaccurate or incomplete information which is ultimately utilized by management in its decision making process throughout the year, including the establishments of annual budgets. Within the current audit, the lack of reconciliation resulted in several audit adjustments. Auditor?s Recommendation: We recommend that asset and liability accounts be reconciled by the City Auditor?s office on a regular and routine basis. Further, reconciliations should be reviewed by management to ensure their accurate and timely completion. City?s Response: The City Auditor?s office will take the necessary steps to remedy this issue. A reconciliation of all asset and liability balances will be performed on a monthly basis. Additionally the City will take the necessary steps to ensure the general ledger packages reconcile and agree to one and other on a regular basis.

Corrective Action Plan

Reconciliation of General Ledger and Capital Projects Auditor?s Recommendation: We recommend that asset and liability accounts be reconciled by the City Auditor?s office on a regular and routine basis. Further, reconciliations should be reviewed by management to ensure their accurate and timely completion. City?s response: The City Auditor, Lens Martial, will take the necessary steps to remedy this issue during the year ending May 31, 2023. A reconciliation of all asset and liability balances will be performed on a monthly basis by the City Auditor. Additionally the City Auditor will take the necessary steps to ensure the general ledger packages reconcile and agree to one and other on a regular basis.

Categories

Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 35409 2022-005
    Material Weakness Repeat
  • 35411 2022-007
    Material Weakness Repeat
  • 35412 2022-008
    Material Weakness
  • 35413 2022-005
    Material Weakness Repeat
  • 35414 2022-006
    Material Weakness Repeat
  • 35415 2022-007
    Material Weakness Repeat
  • 35416 2022-008
    Material Weakness
  • 35417 2022-005
    Material Weakness Repeat
  • 35418 2022-006
    Material Weakness Repeat
  • 35419 2022-007
    Material Weakness Repeat
  • 35420 2022-008
    Material Weakness
  • 35421 2022-005
    Material Weakness Repeat
  • 35422 2022-006
    Material Weakness Repeat
  • 35423 2022-007
    Material Weakness Repeat
  • 35424 2022-008
    Material Weakness
  • 35425 2022-005
    Material Weakness Repeat
  • 35426 2022-006
    Material Weakness Repeat
  • 35427 2022-007
    Material Weakness Repeat
  • 35428 2022-008
    Material Weakness
  • 35429 2022-005
    Material Weakness Repeat
  • 35430 2022-006
    Material Weakness Repeat
  • 35431 2022-007
    Material Weakness Repeat
  • 35432 2022-008
    Material Weakness
  • 35433 2022-005
    Material Weakness Repeat
  • 35434 2022-006
    Material Weakness Repeat
  • 35435 2022-007
    Material Weakness Repeat
  • 35436 2022-008
    Material Weakness
  • 35437 2022-005
    Material Weakness Repeat
  • 35438 2022-006
    Material Weakness Repeat
  • 35439 2022-007
    Material Weakness Repeat
  • 35440 2022-008
    Material Weakness
  • 35441 2022-005
    Material Weakness Repeat
  • 35442 2022-006
    Material Weakness Repeat
  • 35443 2022-007
    Material Weakness Repeat
  • 35444 2022-008
    Material Weakness
  • 611851 2022-005
    Material Weakness Repeat
  • 611852 2022-006
    Material Weakness Repeat
  • 611853 2022-007
    Material Weakness Repeat
  • 611854 2022-008
    Material Weakness
  • 611855 2022-005
    Material Weakness Repeat
  • 611856 2022-006
    Material Weakness Repeat
  • 611857 2022-007
    Material Weakness Repeat
  • 611858 2022-008
    Material Weakness
  • 611859 2022-005
    Material Weakness Repeat
  • 611860 2022-006
    Material Weakness Repeat
  • 611861 2022-007
    Material Weakness Repeat
  • 611862 2022-008
    Material Weakness
  • 611863 2022-005
    Material Weakness Repeat
  • 611864 2022-006
    Material Weakness Repeat
  • 611865 2022-007
    Material Weakness Repeat
  • 611866 2022-008
    Material Weakness
  • 611867 2022-005
    Material Weakness Repeat
  • 611868 2022-006
    Material Weakness Repeat
  • 611869 2022-007
    Material Weakness Repeat
  • 611870 2022-008
    Material Weakness
  • 611871 2022-005
    Material Weakness Repeat
  • 611872 2022-006
    Material Weakness Repeat
  • 611873 2022-007
    Material Weakness Repeat
  • 611874 2022-008
    Material Weakness
  • 611875 2022-005
    Material Weakness Repeat
  • 611876 2022-006
    Material Weakness Repeat
  • 611877 2022-007
    Material Weakness Repeat
  • 611878 2022-008
    Material Weakness
  • 611879 2022-005
    Material Weakness Repeat
  • 611880 2022-006
    Material Weakness Repeat
  • 611881 2022-007
    Material Weakness Repeat
  • 611882 2022-008
    Material Weakness
  • 611883 2022-005
    Material Weakness Repeat
  • 611884 2022-006
    Material Weakness Repeat
  • 611885 2022-007
    Material Weakness Repeat
  • 611886 2022-008
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
20.509 Covid-19 - Section 5311 - Capital $355,908
20.509 Covid-19 - Section 5311 - Cares Act $340,359
20.106 Airport Improvement Program - Sre Building Pavement Rehab (construction) $265,312
21.027 Covid-19 - Coronavirus State and Local Fiscal Recovery Funds $168,679
20.106 Airport Improvement Program - Taxiway A&b Rehabilitation $128,160
20.106 Covid-19 Airport Improvement Program - American Recovery Plan $32,000
20.106 Covid-19 Airport Improvement Program - Coronavirus Response and Relief Supplemental Appropriations Act $13,000
20.106 Airport Improvement Program - Runway 4-22 Rehabilitation $8,341