Finding 613010 (2022-002)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-07-25

AI Summary

  • Core Issue: Year-end financial statements showed inconsistencies compared to submissions to the Auditor of State, indicating a lack of effective internal controls.
  • Impacted Requirements: Total assets, liabilities, revenue, and expenses were all understated, leading to potential misstatements in financial reporting.
  • Recommended Follow-Up: The Public Housing Authority should review and improve its financial statement preparation processes and controls to prevent future discrepancies.

Finding Text

Financial Statements Condition: The year-end financial statements generated from the general ledger, that were prepared and presented for the audit contained inconsistencies, in comparison to the financial statements submitted to the Auditor of State, via the Hinkle Submission and the Entity Wide Balance Sheet and Entity Wide Revenue and Expense Summary, submitted via the Financial Assessment Subsystem. Criteria: The internal controls established by management, pertaining to the year-end financial statements should operate in a matter which should prevent or detect errors and inconsistencies. Cause: Lack of financial internal controls. Effect: ? Total assets per the financial statements generated from the general ledger were understated by $123,336. ? Total liabilities and net assets per the financial statements generated from the general ledger were understated by $123,336. ? Total revenue per the financial statements generated from the general ledger were understated by $4,619. ? Total expenses per the financial statements generated from the general ledger were understated by $48,409. Recommendation: I recommend that the Public Housing Authority should assess the adequacy of the design of its policies and procedures related to preparation of financial statements and the design appropriate controls as necessary to rectify inadequacies. Furthermore, the Public Housing Authority should consider where errors could occur that would cause a material misstatement in the financial statements and which policies or procedures would prevent or detect the error on a timely basis. Views of Responsible Officials and Planned Corrective Actions: Contributing to differences between the system generated financial statements and the financial statements prepared by the Authority for distribution include balances in accounts that typically have a balance that would appear on the Liability side of the Statement of Net Position, but in any given year have a balance reported on the Asset side of the Statement of Net Position, an example being the OPEB Net Asset. Balances of grants of short duration that for grant reporting purposes are maintained cumulatively in the general ledger for which only period amounts are reported on the Statement of Revenues, Expenses, and Change in Net Position is also an example of what can cause such differences. It is unknown by current management of Springfield MHA when the mapping for the financial statements generated by the Authority's accounting software was done or last updated. The financial statements generated by the Authority's accounting software are for very limited use by management only. They are not and were not generated for publication and distribution. For audit, Springfield MHA prepares trial balance worksheets that document mapping to the unaudited Financial Data Schedule, and then the totals from the unaudited Financial Data Schedule as adjusted (if applicable) provide the basis for the Financial Statements prepared for financial reporting and distribution. In addition to considering any mapping changes needed to system generated financial statements in the Authority's accounting software, Springfield MHA will consider how to label the financial statements generated by the accounting software as For Management Use Only.

Categories

HUD Housing Programs Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 36567 2022-001
    Significant Deficiency
  • 36568 2022-002
    Significant Deficiency
  • 36569 2022-003
    Significant Deficiency
  • 36570 2022-004
    Significant Deficiency
  • 613009 2022-001
    Significant Deficiency
  • 613011 2022-003
    Significant Deficiency
  • 613012 2022-004
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
14.871 Section 8 Housing Choice Vouchers $4.34M
14.850 Public and Indian Housing $3.04M
14.872 Public Housing Capital Fund $662,750
14.879 Mainstream Vouchers $154,203
14.238 Shelter Plus Care $113,555
14.870 Resident Opportunity and Supportive Services - Service Coordinators $59,864
14.896 Family Self-Sufficiency Program $19,230