Finding 1229422 (2023-001)

Material Weakness Repeat Finding
Requirement
AB
Questioned Costs
-
Year
2023
Accepted
2026-09-11
Audit: 410819
Auditor: WIPFLI LLP

AI Summary

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

Finding Text

2023-001 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: 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, 2023. For cash, no reconciliations could be provided at June 30, 2023 which required us to manually create a reconciliation based on the July 2023 bank statements. Reconciliation of these accounts required auditor assistance and required extensive research and data gathering by NIBC to adjust account balances. Despite these efforts, a disclaimer of opinion was issued on the audited financial statements due to an inability to adequately reconcile grant revenue which has potential effects on grants receivable, refundable advances and net assets. 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 increases. Additionally, the June 30, 2023 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 which created further difficulties in locating historical information. Auditor's Recommendation: We recommend NIBC implement procedures to ensure accounts are reconciled timely and accurately. Questioned Costs: None View of Responsible Officials: Management agrees with the findings and has written a corrective action plan. Federal Program Information: Funding agency: Department of the Treasury, passed through the Battle Creek Community Foundation Title: Emergency Rental Assistance Program AL number: 21.023

Corrective Action Plan

Finding 2023-001: Internal Control Over Financial Reporting – Account Reconciliations Management’s Response 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: Whitney Wardell Anticipated Completion Date: 7/1/2024

Categories

Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1229423 2023-002
    Material Weakness Repeat
  • 1229424 2023-003
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
21.023 COVID-19 EMERGENCY RENTAL ASSISTANCE PROGRAM $1.60M
14.239 HOME INVESTMENT PARTNERSHIPS PROGRAM $524,631
14.218 COMMUNITY DEVELOPMENT BLOCK GRANTS/ENTITLEMENT GRANTS $181,157
14.231 EMERGENCY SOLUTIONS GRANT PROGRAM $125,933
14.905 LEAD HAZARD REDUCTION DEMONSTRATION GRANT PROGRAM $70,035
14.871 SECTION 8 HOUSING CHOICE VOUCHERS $18,920