Audit 335234

FY End
2024-09-30
Total Expended
$3.09M
Findings
6
Programs
2
Organization: Columbia Village (MN)
Year: 2024 Accepted: 2024-12-31

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
517233 2024-001 Material Weakness Yes P
517234 2024-002 Significant Deficiency - P
517235 2024-003 Significant Deficiency - N
1093675 2024-001 Material Weakness Yes P
1093676 2024-002 Significant Deficiency - P
1093677 2024-003 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
14.157 Supportive Housing for the Elderly $3.00M Yes 3
14.182 Section 8 New Construction and Substantial Rehabilitation $86,197 - 0

Contacts

Name Title Type
EZC7X5WQK3Y5 Terese Fox Auditee
7637821612 John Melzarek Auditor
No contacts on file

Notes to SEFA

Accounting Policies: The accompanying schedule of expenditures of federal awards includes the federal awards activity of Columbia Village, HUD Project No. 092-EE-046-WAC, under programs of the federal government for the year ended September 30, 2024. The information in this Schedule is presented in accordance with the requirements of 2 CFR Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Columbia Village, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Columbia Village. Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following, as applicable, either the cost principles in OMB Circular A-122, Cost Principles for Non-Profit Organizations, or the cost principles contained in Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Columbia Village has not elected to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance. The section 202 capital advance has an outstanding balance of $3,004,200 at September 30, 2024. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate.

Finding Details

Type of Finding: Material Weakness in Internal Control over Financial Reporting Condition: The Corporation does not have a policy in place to provide reasonable assurance that financial statements are prepared in accordance with accounting principles generally accepted in the United States of America (U.S. GAAP); therefore, the potential exists that a material misstatement of the annual financial statements could occur and not be prevented, or detected and corrected, by the Corporation’s internal controls. Criteria or Specific Requirement: Internal controls should be in place to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Context: While performing audit procedures, it was noted that management does not have internal controls in place to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Effect: The lack of controls in place over the financial reporting function increases the risk of misstatements, fraud, or errors occurring and not being detected and corrected. Cause: The Corporation has not adopted a policy to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP; however, management has reviewed and approved the annual financial statements and related notes, as prepared by the audit firm, and has accepted responsibility for those financial statements. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2023-001. Recommendation: The Corporation should evaluate their financial reporting processes and controls, including the expertise of its internal staff, to determine whether additional controls over the preparation of annual financial statements can be implemented to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Views of Responsible Officials and Planned Corrective Actions: Management will continue to rely on the audit firm to draft the financial statements and the related notes to the financial statements, and will review, approve, and accept responsibility for the annual financial statements prior to their issuance.
Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Condition: Management is responsible for reviewing and retaining all support of journal entries made to the general ledger detail to ensure no fictitious or incorrect entries are made. Criteria or Specific Requirement: Internal controls should be in place to ensure the support for all journal entries are retained to support the amount and purpose of the entries made to the general ledger detail. Context: While performing audit procedures, it was noted that management was unable to provide supporting documentation for one of the journal entries selected during the testing and review of the general ledger. Effect: The lack of supporting documentation for the journal entry selected for testing increases the risk of misstatements, fraud, or errors occurring and not being detected and corrected during the journal entry preparation process. Cause: Management was unable to provide the supporting documentation for the prepaid journal entry selected during the testing process to support the accuracy and purpose of the entry made. Repeat Finding: N/A Recommendation: The Corporation should evaluate their policies and procedures relating to the retainment of supporting documentation during the journal entry preparation and close process to ensure all supporting documentation for any journal entries made are accessible to support both the accuracy and purpose of the entries made. Views of Responsible Officials and Planned Corrective Actions: There is no disagreement with the audit finding. Management will review the policies and procedures currently in place relating to the retainment of journal entry support to ensure that all supporting documentation for entries made to the general ledger are kept validating the accuracy and purpose of journal entries.
Federal agency: U.S. Department of Housing and Urban Development Federal program title: Section 202 Capital Advance Assistance Living Number: 14.157 Type of Finding: Significant Deficiency in Internal Control over Compliance Compliance Criteria or Specific Requirement: Internal controls should be in place to ensure that the HUD required deposits are made in a timely manner into the replacement reserve account. Condition: Management is responsible for reviewing and reconciling the replacement reserve account on a monthly basis ensuring all required deposits are made. Questioned Costs: $937.50 Context: While performing audit procedures, it was noted that the required monthly deposit of $937.50 was not made for all 12 months of the fiscal year. Noted one month of deposits missing. Cause: Management did not make the monthly required deposit into the replacement reserve account for all 12 months of the fiscal year. Effect: The replacement reserve account balance is understated to what it should be as of September 30, 2024 with the necessary deposits. Repeat Finding: N/A Recommendation: The Corporation should review the policy surrounding the procedures regarding the replacement reserve deposits made on a monthly basis. Also, management should make an additional deposit during the fiscal year ending September 30, 2025, in addition to the 12 required deposits, to ensure the replacement reserve account is properly funded. Views of Responsible Officials and Planned Corrective Actions: There is no disagreement with the audit finding and management will make an additional deposit during the fiscal year ended September 30, 2025 to ensure the proper funding of the replacement reserve account.
Type of Finding: Material Weakness in Internal Control over Financial Reporting Condition: The Corporation does not have a policy in place to provide reasonable assurance that financial statements are prepared in accordance with accounting principles generally accepted in the United States of America (U.S. GAAP); therefore, the potential exists that a material misstatement of the annual financial statements could occur and not be prevented, or detected and corrected, by the Corporation’s internal controls. Criteria or Specific Requirement: Internal controls should be in place to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Context: While performing audit procedures, it was noted that management does not have internal controls in place to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Effect: The lack of controls in place over the financial reporting function increases the risk of misstatements, fraud, or errors occurring and not being detected and corrected. Cause: The Corporation has not adopted a policy to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP; however, management has reviewed and approved the annual financial statements and related notes, as prepared by the audit firm, and has accepted responsibility for those financial statements. Repeat Finding: The finding is a repeat of a finding in the immediately prior year. Prior year finding number was 2023-001. Recommendation: The Corporation should evaluate their financial reporting processes and controls, including the expertise of its internal staff, to determine whether additional controls over the preparation of annual financial statements can be implemented to provide reasonable assurance that financial statements are prepared in accordance with U.S. GAAP. Views of Responsible Officials and Planned Corrective Actions: Management will continue to rely on the audit firm to draft the financial statements and the related notes to the financial statements, and will review, approve, and accept responsibility for the annual financial statements prior to their issuance.
Type of Finding: Significant Deficiency in Internal Control over Financial Reporting Condition: Management is responsible for reviewing and retaining all support of journal entries made to the general ledger detail to ensure no fictitious or incorrect entries are made. Criteria or Specific Requirement: Internal controls should be in place to ensure the support for all journal entries are retained to support the amount and purpose of the entries made to the general ledger detail. Context: While performing audit procedures, it was noted that management was unable to provide supporting documentation for one of the journal entries selected during the testing and review of the general ledger. Effect: The lack of supporting documentation for the journal entry selected for testing increases the risk of misstatements, fraud, or errors occurring and not being detected and corrected during the journal entry preparation process. Cause: Management was unable to provide the supporting documentation for the prepaid journal entry selected during the testing process to support the accuracy and purpose of the entry made. Repeat Finding: N/A Recommendation: The Corporation should evaluate their policies and procedures relating to the retainment of supporting documentation during the journal entry preparation and close process to ensure all supporting documentation for any journal entries made are accessible to support both the accuracy and purpose of the entries made. Views of Responsible Officials and Planned Corrective Actions: There is no disagreement with the audit finding. Management will review the policies and procedures currently in place relating to the retainment of journal entry support to ensure that all supporting documentation for entries made to the general ledger are kept validating the accuracy and purpose of journal entries.
Federal agency: U.S. Department of Housing and Urban Development Federal program title: Section 202 Capital Advance Assistance Living Number: 14.157 Type of Finding: Significant Deficiency in Internal Control over Compliance Compliance Criteria or Specific Requirement: Internal controls should be in place to ensure that the HUD required deposits are made in a timely manner into the replacement reserve account. Condition: Management is responsible for reviewing and reconciling the replacement reserve account on a monthly basis ensuring all required deposits are made. Questioned Costs: $937.50 Context: While performing audit procedures, it was noted that the required monthly deposit of $937.50 was not made for all 12 months of the fiscal year. Noted one month of deposits missing. Cause: Management did not make the monthly required deposit into the replacement reserve account for all 12 months of the fiscal year. Effect: The replacement reserve account balance is understated to what it should be as of September 30, 2024 with the necessary deposits. Repeat Finding: N/A Recommendation: The Corporation should review the policy surrounding the procedures regarding the replacement reserve deposits made on a monthly basis. Also, management should make an additional deposit during the fiscal year ending September 30, 2025, in addition to the 12 required deposits, to ensure the replacement reserve account is properly funded. Views of Responsible Officials and Planned Corrective Actions: There is no disagreement with the audit finding and management will make an additional deposit during the fiscal year ended September 30, 2025 to ensure the proper funding of the replacement reserve account.