Finding 529225 (2022-001)

Material Weakness
Requirement
AB
Questioned Costs
-
Year
2022
Accepted
2025-03-21
Audit: 347220
Auditor: Wipfli LLP

AI Summary

  • Core Issue: NIBC failed to reconcile most asset and liability accounts for the year ended June 30, 2022, leading to inaccurate financial information.
  • Impacted Requirements: Timely and accurate reconciliations are essential for reliable management reporting and compliance with Uniform Guidance.
  • Recommended Follow-Up: NIBC should establish procedures to ensure timely and accurate account reconciliations to prevent future discrepancies.

Finding Text

Internal Control Over Financial Reporting - Account Reconciliations Criteria or Specific Requirement: An accounting system and respective internal controls should provide timely and accurate information for management. The reconciliation of account balances is an integral internal control activity to determine that stated account balances are accurate and fairly reported. Management and accounting personnel should reconcile general ledger accounts to subsidiary ledgers and other supporting documents in a timely and effective manner. Condition: Beyond cash, Neighborhoods, Inc. of Battle Creek (NIBC) did not reconcile most all asset and liability accounts on the general ledger for the year ended June 30, 2022. Reconciliation of the accounts required auditor assistance and required extensive research and data gathering by NIBC to accurately reflect account balances. Effect: Without performing adequate account reconciliations, information provided to management is inaccurate. Also, the probability that fraud or material errors will occur and go undetected generally increases. Additionally, the June 30, 2022 audit was not submitted within nine months after the fiscal year end as required by Uniform Guidance. Cause: Turnover in fiscal and management positions resulted in individuals not being aware of the nature of account balances and how to reconcile them. Additionally there were changes in systems and bank accounts which created further difficulties in locating historical information. Auditor's Recommendation: We recommend NIBC implement procedures to ensure accounts are reconciled timely and accurately.

Corrective Action Plan

In 2021, senior management contracted with a CPA firm to handle all accounting functions. Processes and procedures that were expected to be completed by contractor were not. As of 7/1/23, management brought accounting functions in house to gain control of books, provide more oversight and ensure accuracy. Contact Person Responsible for Corrective Action: Lisa Ripper Anticipated Completion Date: 7/1/2023

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 529226 2022-002
    Material Weakness
  • 1105667 2022-001
    Material Weakness
  • 1105668 2022-002
    Material Weakness

Programs in Audit

ALN Program Name Expenditures
21.023 Covid-19 Emergency Rental Assistance Program $6.14M
14.231 Emergency Solutions Grant Program $735,183
14.905 Lead Hazard Reduction Demonstration Grant Program $88,986
14.218 Community Development Block Grants/entitlement Grants $59,495
14.239 Home Investment Partnerships Program $50,381
14.871 Lead Hazard Reduction Demonstration Grant Program $40,945