Audit 315058

FY End
2023-12-31
Total Expended
$5.10M
Findings
2
Programs
6
Organization: Commonbond Communities (MN)
Year: 2023 Accepted: 2024-07-12

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
478372 2023-001 Material Weakness - P
1054814 2023-001 Material Weakness - P

Contacts

Name Title Type
ZSF4K8UAXMC3 Angela Riley Auditee
6512911750 Katie McDonnell Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: 1) Expenditures reported on the Schedule are reported on the accrual basis of accounting except for the loan balances as discussed below. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. 2) Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: Common Bond has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal grant activity of CommonBond Communities and affiliates under programs of the federal government for the year ended December 31, 2023. CommonBond Communities’ consolidated financial statements include the operations of various for-profit entities and nonprofit entities (referred to as Housing Communities). Certain of these entities receive federal awards which are excluded from the Schedule for the year ended December 31, 2023. The for-profit Housing Communities were excluded from the Schedule because for-profit entities are not required to follow Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (the Uniform Guidance). Such entities followed the requirements of the Consolidated Audit Guide for Audits of HUD Programs (the “Guide”) when required. The nonprofit Housing Communities were excluded from the Schedule because separate audits of these entities were conducted in accordance with the Uniform Guidance. The information in this Schedule is presented in accordance with the requirements of the Uniform Guidance. Because the Schedule presents only a selected portion of the operations of CommonBond Communities and affiliates, it is not intended to and does not present the financial position, changes in net assets, or cash flows of CommonBond Communities and affiliates.
Title: Summary of Significant Accounting Policies Accounting Policies: 1) Expenditures reported on the Schedule are reported on the accrual basis of accounting except for the loan balances as discussed below. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. 2) Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: Common Bond has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. (1) Expenditures reported on the Schedule are reported on the accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. (2) Pass-through entity identifying numbers are presented where available. (3) CommonBond Communities has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. CommonBond Communities has a federally negotiated indirect cost rate.
Title: Note 3. Community Development Financial Institutions Program Accounting Policies: 1) Expenditures reported on the Schedule are reported on the accrual basis of accounting except for the loan balances as discussed below. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. 2) Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: Common Bond has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. Federal expenditures for the Community Development Financial Institutions program includes the original $4,000,000 pool of funds, plus the balance at the beginning of the year of revolving loan funds. In accordance with terms of the Capital Magnet Funds, loan repayments are added back to the pool of funds for which the grantor imposes continuing compliance requirements. Loan repayments will be used to make additional loans under the program. Repayments totaled $916,289 in 2023. Recycled funds totaling $1,204,975 were used for allowable costs under the grant agreement. The December 31, 2023 outstanding loan balance is $3,216,172.

Finding Details

Criteria – Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition – Certain policies and procedures that were in place to ensure accurate and timely financial reporting information were not being followed, such as timely bank reconciliations, reconciliations of other asset and liability accounts to the general ledger, and detailed supervisory or manager level review of work completed. Cause – The Organization historically has not utilized the complete functionality of its Enterprise Resource Planning (ERP) system, and has utilized manual spreadsheets and other documentation for these functions. There has been significant turnover in the Finance Department of the Organization including a long-term employee that was responsible for many of these procedures. The procedures were not effectively reassigned to new employees, and detailed reviews were not regularly performed when procedures were reassigned timely and accurately information. In some instances, these procedures were reassigned multiple times during the year due to turnover. In addition, the Finance Department has taken on larger roles in operating deficiencies of the Organization, which reduces their time devoted to financial reporting. Effect – During our annual audit, there was an increase in the volume of adjustments made to the Organization’s financial statements that in the aggregate, were material to the financial statements, and the 2022 consolidated financial statements were restated. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. Further, a material misstatement of the financial statement could occur and not be prevented or detected and the Board of Directors and members of management using the Organization’s internal books and records may not have complete and accurate information throughout the year. Recommendation – We recommend management review and/or redesign existing policies in place to have an effective and timely financial statement review and approval process to ensure that necessary adjustments and reconciliations to the general ledger are performed. This process should include reconciling significant statement of financial position line items to supporting schedules each month and at year end, such as bank reconciliations, accounts receivable, accounts payable, debt, depreciation schedules, etc. Auditee's comments and response – Management agrees with the finding. Management is in the process of elevating the level of supervisory personnel across the finance function, more fully implementing its Enterprise Resource Planning system to leverage available technology and system controls, continuing its training and development of team members, and implementing standardized month end procedures and related review processes. Responsible party for corrective action: Angela Riley, Chief Financial Officer. Repeat Finding: No
Criteria – Management is responsible for the preparation and fair presentation of the financial statements in accordance with accounting principles generally accepted in the United States of America, and for the design, implementation, and maintenance of internal control relevant to the preparation and fair presentation of financial statements that are free from material misstatement, whether due to fraud or error. Condition – Certain policies and procedures that were in place to ensure accurate and timely financial reporting information were not being followed, such as timely bank reconciliations, reconciliations of other asset and liability accounts to the general ledger, and detailed supervisory or manager level review of work completed. Cause – The Organization historically has not utilized the complete functionality of its Enterprise Resource Planning (ERP) system, and has utilized manual spreadsheets and other documentation for these functions. There has been significant turnover in the Finance Department of the Organization including a long-term employee that was responsible for many of these procedures. The procedures were not effectively reassigned to new employees, and detailed reviews were not regularly performed when procedures were reassigned timely and accurately information. In some instances, these procedures were reassigned multiple times during the year due to turnover. In addition, the Finance Department has taken on larger roles in operating deficiencies of the Organization, which reduces their time devoted to financial reporting. Effect – During our annual audit, there was an increase in the volume of adjustments made to the Organization’s financial statements that in the aggregate, were material to the financial statements, and the 2022 consolidated financial statements were restated. Management reviewed, approved, and accepted responsibility for the audit adjustments before the financial statements were issued. Further, a material misstatement of the financial statement could occur and not be prevented or detected and the Board of Directors and members of management using the Organization’s internal books and records may not have complete and accurate information throughout the year. Recommendation – We recommend management review and/or redesign existing policies in place to have an effective and timely financial statement review and approval process to ensure that necessary adjustments and reconciliations to the general ledger are performed. This process should include reconciling significant statement of financial position line items to supporting schedules each month and at year end, such as bank reconciliations, accounts receivable, accounts payable, debt, depreciation schedules, etc. Auditee's comments and response – Management agrees with the finding. Management is in the process of elevating the level of supervisory personnel across the finance function, more fully implementing its Enterprise Resource Planning system to leverage available technology and system controls, continuing its training and development of team members, and implementing standardized month end procedures and related review processes. Responsible party for corrective action: Angela Riley, Chief Financial Officer. Repeat Finding: No