Finding 1012 (2021-008)

Material Weakness Repeat Finding
Requirement
P
Questioned Costs
-
Year
2021
Accepted
2023-10-31

AI Summary

  • Core Issue: The City experienced a significant breakdown in internal controls, making them ineffective for most of the fiscal year.
  • Impacted Requirements: Compliance with A-102 Common Rule and 2 CFR section 200.303 was compromised due to inadequate oversight and unfamiliarity with the new accounting system.
  • Recommended Follow-Up: The City should develop a detailed program to document operational and accounting processes related to Federal grants, ensuring compliance and effective internal controls.

Finding Text

Criteria The A-102 Common Rule, OMB Circular A-110 and 2 CFR section 200.303 require that non-Federal entities receiving Federal awards establish and maintain internal control designed to reasonably ensure compliance with Federal statutes, regulations, and the terms and conditions of the Federal award. 2 CFR section 200.514 requires auditors to obtain an understanding of the non-Federal entity’s internal control over Federal programs sufficient to plan the audit to support a low assessed level of control risk of noncompliance for major programs, and, unless internal control is likely to be ineffective, plan the testing of internal control over major programs to support a low assessed level of control risk for the assertions relevant to the compliance requirements for each major program and perform testing of internal control as planned. Condition As noted in finding 2021-004, the City informed the auditors of a significant break down of internal controls resulting in them to be ineffective through most of the fiscal year. Cause Due to personnel turnover and the recent implementation of a new accounting system, the City did not have adequate controls and oversight in place to ensure accounting transactions were being processed accurately and timely. Unfamiliarity with the financial accounting system lead to inconsistencies in how transactions were being recorded Effect The City lacked internal controls to support a low assessed level of control risk for the assertions relevant to compliance requirements for the major program tested. Recommendation We recommend that the City institute a program to methodically identify and document its significant operational and accounting processes as they relate to Federal grants and compliance. Documenting a process involves identifying and gaining an understanding of the required compliance requirements, the automated or manual procedures used in performing the required processes, the person(s) or position(s) responsible for performing the procedures, the source documents used or generated, the procedures for approval and review and correction of any errors detected, and the financial or operational entries or reports summarizing the result of the process. View of Responsible Officials Management informed the auditors of this condition and agrees with the comment. Management also acknowledges that this occurred due to the staff turnover and subsequent difficulties in hiring mentioned in comments 2021-001, 002, and 003. In 2021-2022 the foundational processes have been stabilized (accounts payable, payroll, deposits) allowing staff to focus on reconciliations, procedures, and audit. As processes are brought current or accounts are reconciled, staff will document procedures and ensure that internal controls are incorporated into the procedures.

Corrective Action Plan

1) Identify high risk areas 2) Reconcile accounts 3) Document process 4) Maintain once current 5) Work through list until all accounts are bring reconciled on a schedule 6) Develop month end check lists 7) Use checklists to close 8) Enhance checklists throughout the year . Responsible Party: Amy Cunningham, Carla Carvalho-Degraff. Target Completion Date: 06/30/2024

Categories

Internal Control / Segregation of Duties Matching / Level of Effort / Earmarking

Other Findings in this Audit

  • 1013 2021-009
    - Repeat
  • 1014 2021-010
    - Repeat
  • 1015 2021-008
    Material Weakness Repeat
  • 1016 2021-009
    - Repeat
  • 1017 2021-010
    - Repeat
  • 577454 2021-008
    Material Weakness Repeat
  • 577455 2021-009
    - Repeat
  • 577456 2021-010
    - Repeat
  • 577457 2021-008
    Material Weakness Repeat
  • 577458 2021-009
    - Repeat
  • 577459 2021-010
    - Repeat

Programs in Audit

ALN Program Name Expenditures
20.205 Highway Planning and Construction $1.10M
21.019 Coronavirus Relief Fund $663,066
16.738 Edward Byrne Memorial Justice Assistance Grant Program $168,359
20.600 State and Community Highway Safety $64,810