Finding 5505 (2022-006)

Significant Deficiency
Requirement
P
Questioned Costs
-
Year
2022
Accepted
2023-12-18
Audit: 7270

AI Summary

  • Core Issue: The Housing Trust submitted the Data Collection Form late, violating federal compliance requirements.
  • Impacted Requirements: Timely submission of audit-related documents as per 2 CFR 200.512(a) is essential for compliance.
  • Recommended Follow-Up: Implement controls to ensure timely completion of future data collection forms and monitor progress through the Business Operations Manager.

Finding Text

2023-006—LATE DATA COLLECTION FORM Funding Agency: All Title: All AL #: All Award #: All Award Period: All periods Estimated Questioned Costs: None Type of Finding • (E) Significant Deficiency in Internal Control Over Compliance of Federal Awards • (F) Instance of Non-Compliance Related to Federal Awards Statement of Condition the Housing Trust Data Collection Form for the year ended December 31, 2022 was submitted after the required due date. Criteria The audit shall be completed and the data collection form and reporting package shall be electronically transmitted within the earlier of 30 days after receipt of the auditor's reports, or nine months after the end of the audit period. If the due date falls on a Saturday, Sunday, or Federal holiday, the reporting package is due the next business day (2 CFR 200.512(a)). Cause The expected deliverables requested to complete the audit were not received by the aforementioned deadline, which resulted in a late submission. Effect the Housing Trust is not in compliance with Federal Award data collection form requirements as required under Uniform Guidance regulations. Recommendation the Housing Trust should implement controls to ensure that all future data collection forms are completed in a timely manner. View of Responsible Official The contractors hired to do the accounting and payroll functions are no longer under contract with the Housing Trust. All financial functions are now being taken care of in-house. The financials are already in the process of being adjusted and all numbers being accounted for with documentation. This will continue through 2023 and in 2024, the chart of accounts will be changed to reflect the current practices for a nonprofit organization. As the Executive Director prepares the 2024 budget, a reorganization of the business operations department has started. Staff changes will also need the Business Operations manager to provide a thorough monthly review. The current administrative assistant will take on the role of accounting technician to handle the day-to-day QuickBooks-related processes. Work has already started to develop checks and balances. Corrective Action Plan Timeline: Immediately Designated Employee Responsible for Corrective Action: Business Operations Manager

Corrective Action Plan

The contractors hired to do the accounting and payroll functions are no longer under contract with the Housing Trust. All financial functions are now being taken care of in-house. The financials are already in the process of being adjusted and all numbers being accounted for with documentation. This will continue through 2023 and in 2024, the chart of accounts will be changed to reflect the current practices for a nonprofit organization. As the Executive Director prepares the 2024 budget, a reorganization of the business operations department has started. Staff changes will also need the Business Operations manager to provide a thorough monthly review. The current administrative assistant will take on the role of accounting technician to handle the day-to-day QuickBooks-related processes. Work has already started to develop checks and balances. Corrective Action Plan Timeline: Immediately Designated Employee Responsible for Corrective Action: Business Operations Manager

Categories

Reporting Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 5501 2022-002
    Material Weakness
  • 5502 2022-003
    Significant Deficiency
  • 5503 2022-001
    Significant Deficiency
  • 5504 2022-005
    Material Weakness
  • 5506 2022-002
    Material Weakness
  • 5507 2022-003
    Significant Deficiency
  • 5508 2022-001
    Significant Deficiency
  • 5509 2022-005
    Material Weakness
  • 5510 2022-006
    Significant Deficiency
  • 581943 2022-002
    Material Weakness
  • 581944 2022-003
    Significant Deficiency
  • 581945 2022-001
    Significant Deficiency
  • 581946 2022-005
    Material Weakness
  • 581947 2022-006
    Significant Deficiency
  • 581948 2022-002
    Material Weakness
  • 581949 2022-003
    Significant Deficiency
  • 581950 2022-001
    Significant Deficiency
  • 581951 2022-005
    Material Weakness
  • 581952 2022-006
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
21.024 Covid 19 - Cdfi-Rapid Response Program $596,535
14.241 Homebuyer (hopwa) $553,455
14.241 Covid 19 - Hopwa-Cares Act $90,196
14.267 Coc Program -Tbra 1/22-6/22 $43,836
14.267 Coc Program -Tbra 7/22-12/22 $43,313
14.267 Coc Program-Pbra $28,796