Finding 374582 (2023-006)

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

AI Summary

  • Core Issue: The City is not regularly reconciling asset and liability accounts, leading to potential misstatements in financial records.
  • Impacted Requirements: This lack of reconciliation affects the accuracy of financial information used for decision-making and budgeting.
  • Recommended Follow-Up: Implement monthly reconciliations of all asset and liability balances, with management reviews to ensure accuracy and timeliness.

Finding Text

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, Lens Martial, 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.

Categories

Matching / Level of Effort / Earmarking

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
  • 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
  • 374593 2023-008
    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