FAC Explorer

Audit 352642

FY End
2024-09-30
Total Expended
$1.52M
Findings
16
Programs
5
Organization: Neighborworks Housing Services of Pueblo, Inc. (CO)
Year: 2024 Accepted: 2025-04-03
Auditor: Biggskofford

Organization Exclusion Status:

Findings

ID Ref Severity Repeat Requirement
554029 2024-001 Material Weakness - P
554030 2024-002 Material Weakness - P
554031 2024-003 Material Weakness - P
554032 2024-004 Material Weakness - P
554033 2024-005 Material Weakness - P
554034 2024-006 Material Weakness - P
554035 2024-007 Material Weakness - P
554036 2024-008 Material Weakness - P
1130471 2024-001 Material Weakness - P
1130472 2024-002 Material Weakness - P
1130473 2024-003 Material Weakness - P
1130474 2024-004 Material Weakness - P
1130475 2024-005 Material Weakness - P
1130476 2024-006 Material Weakness - P
1130477 2024-007 Material Weakness - P
1130478 2024-008 Material Weakness - P

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $666,624 Yes 8
14.247 Self-Help Homeownership Opportunity Program $403,800 - 0
93.093 Health Profession Opportunity Grants $382,000 - 0
21.025 Small Dollar Loan Program $37,738 - 0
14.169 Housing Counseling Assistance Program $31,944 - 0

Contacts

Name Title Type
C3H2LY7KZ6L3 Emily Garbiso Auditee
7194236110 Tyler Atkins Auditor
No contacts on file

Notes to SEFA

Title: BASIS OF PRESENTATION Accounting Policies: Expenditures reported on the SEFA 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 to reimbursement. De Minimis Rate Used: Y Rate Explanation: Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants. The accompanying schedule of expenditures of federal awards ("SEFA") includes the federal award activity of Neighborhood Housing Services of Pueblo, Inc. and Affiliate ("Organization"), 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 Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards ("Uniform Guidance"). Because the SEFA presents only a selected portion of the operations of the Organization, it is not intended to, and does not, present the financial position, changes in net assets, or cash flows of the Organization. If the Organization is required to match certain federal assistance, as defined by the grant agreements, no such matching has been included as expenditures in the schedule.
Title: SUMMARY OF SIGNIFICANT ACCOUNTING POLICIES Accounting Policies: Expenditures reported on the SEFA 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 to reimbursement. De Minimis Rate Used: Y Rate Explanation: Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants. Expenditures reported on the SEFA 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 to reimbursement.
Title: INDIRECT COSTS Accounting Policies: Expenditures reported on the SEFA 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 to reimbursement. De Minimis Rate Used: Y Rate Explanation: Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants. Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants.
Title: RELATIONSHIP TO THE FINANCIAL STATEMENTS Accounting Policies: Expenditures reported on the SEFA 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 to reimbursement. De Minimis Rate Used: Y Rate Explanation: Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants. The amount of total expenditures of federal awards reconciles to the revenue in the statement of activities as follows: Total expenditures of federal awards $1,522,106 Add: Non-federal contributions and awards 2,492,788 Contributions and grants per statement of activities 4,014,894
Title: OTHER ITEMS Accounting Policies: Expenditures reported on the SEFA 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 to reimbursement. De Minimis Rate Used: Y Rate Explanation: Unless an indirect rate was specified in the grant agreement, the Organization elected to use the 10% de minimis indirect cost rate to recover allowable indirect costs for federal grants. Pass-through entity identifying numbers have been included where available.

Finding Details

Finding 2024-001
Monthly Reconciliation and Closing Procedures Material Weakness Condition: Our audit procedures revealed that there is currently no process to ensure that monthly account reconciliation procedures take place. As a result, we proposed over 50 adjustments to the original trial balances. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Opportunity for misappropriation of assets and that a misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend that a detailed monthly checklist be developed to outline all necessary month-end closing procedures needed, including the individuals responsible for preparing and reviewing the items. As part of this checklist, each statement of financial position account should be accompanied by an account reconciliation which agrees to the general ledger. This will help improve internal controls over financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-002
Lack of a Formal Process to Identify and Evaluate Loan Impairment Material Weakness Condition: The Organization does not have a regular process in place to identify and evaluate loans for impairment. As a result, an audit adjustment of $2 million was required to increase the allowance for uncollectible loans. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: The absence of a regular review process increases the risk of misstated financial statements and inadequate loan loss reserves. Recommendation: Recommendation: We recommend implementing a structured loan review process, including periodic assessments, documentation of impairment evaluations, and board oversight. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-003
Real Estate Held for Sale and Development Tracking Material Weakness Condition: Condition: The Organization does not reconcile its real estate held for sale to the general ledger. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend that the Organization review detailed real estate listings and the supporting documentation from third parties on at least a quarterly basis and reconcile the listing to the general ledger, with any large discrepancies investigated. Additionally, we recommend that purchases and sales of real estate be tracked on an individual item basis to include the date of the purchase and/or sale. This will help ensure that real estate held for sale or development is accurately recorded in the financial statements. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-004
Separate Trial Balances Material Weakness Condition: During the course of the audit, it was noted that the Organization currently utilizes a single trial balance for both NeighborWorks and Southern Colorado Community Lending, which resulted in several adjustments to the general ledger in order to reconcile certain balances between entities. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend separate trial balances for both parent and subsidiary and regular reconciliation of intercompany balances during month end procedures to improve internal controls over financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-005
Lack of Separate Cash Accounts for Southern Colorado Community Lending Material Weakness Condition: The inability to automate intercompany transactions and the lack of monthly reconciliations of intercompany balances make it difficult to determine the correct year-end cash balance. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend further separation of cash balances in SCCL, monthly reconciliations of intercompany balances, and timely settlement of intercompany balances. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-006
Due To/Due From Accounts Not Reconciled Timely Material Weakness Condition: Due to/due from accounts have not been reconciled or trued up for an extended period, making it difficult to determine the accuracy of the year-end balances. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend implementing a formal reconciliation process, ensuring that due to/due from accounts are reviewed and adjusted at least on a quarterly basis. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-007
Restricted Grants and Contributions Material Weakness Condition: There is a lack of internal controls related to tracking of donor restrictions. Specifically, there was no formal process to track and manage restricted contributions with donor-imposed restrictions. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Risk of non-compliance with accounting standards and the potential of misuse of donor funds. Recommendation: We recommend the Organization establish an internal process to accurately track, monitor and report donor restrictions to ensure compliance with accounting principles and transparency in financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-008
Year-end Bank Reconciliations Material Weakness Condition: At the time of our audit test work, the year end bank reconciliations, prepared by the Director of Finance, included several large reconciling items and were not reviewed independent of preparation. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Opportunity for misappropriation of assets, and possibility that a misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend all bank reconciliations be reviewed and approved as part of month-end procedures to improve internal controls of accuracy and transparency of financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-001
Monthly Reconciliation and Closing Procedures Material Weakness Condition: Our audit procedures revealed that there is currently no process to ensure that monthly account reconciliation procedures take place. As a result, we proposed over 50 adjustments to the original trial balances. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Opportunity for misappropriation of assets and that a misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend that a detailed monthly checklist be developed to outline all necessary month-end closing procedures needed, including the individuals responsible for preparing and reviewing the items. As part of this checklist, each statement of financial position account should be accompanied by an account reconciliation which agrees to the general ledger. This will help improve internal controls over financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-002
Lack of a Formal Process to Identify and Evaluate Loan Impairment Material Weakness Condition: The Organization does not have a regular process in place to identify and evaluate loans for impairment. As a result, an audit adjustment of $2 million was required to increase the allowance for uncollectible loans. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: The absence of a regular review process increases the risk of misstated financial statements and inadequate loan loss reserves. Recommendation: Recommendation: We recommend implementing a structured loan review process, including periodic assessments, documentation of impairment evaluations, and board oversight. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-003
Real Estate Held for Sale and Development Tracking Material Weakness Condition: Condition: The Organization does not reconcile its real estate held for sale to the general ledger. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend that the Organization review detailed real estate listings and the supporting documentation from third parties on at least a quarterly basis and reconcile the listing to the general ledger, with any large discrepancies investigated. Additionally, we recommend that purchases and sales of real estate be tracked on an individual item basis to include the date of the purchase and/or sale. This will help ensure that real estate held for sale or development is accurately recorded in the financial statements. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-004
Separate Trial Balances Material Weakness Condition: During the course of the audit, it was noted that the Organization currently utilizes a single trial balance for both NeighborWorks and Southern Colorado Community Lending, which resulted in several adjustments to the general ledger in order to reconcile certain balances between entities. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend separate trial balances for both parent and subsidiary and regular reconciliation of intercompany balances during month end procedures to improve internal controls over financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-005
Lack of Separate Cash Accounts for Southern Colorado Community Lending Material Weakness Condition: The inability to automate intercompany transactions and the lack of monthly reconciliations of intercompany balances make it difficult to determine the correct year-end cash balance. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend further separation of cash balances in SCCL, monthly reconciliations of intercompany balances, and timely settlement of intercompany balances. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-006
Due To/Due From Accounts Not Reconciled Timely Material Weakness Condition: Due to/due from accounts have not been reconciled or trued up for an extended period, making it difficult to determine the accuracy of the year-end balances. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Inaccurate financial reporting that compromise the accuracy and transparency of financial reporting between the entities. Recommendation: We recommend implementing a formal reconciliation process, ensuring that due to/due from accounts are reviewed and adjusted at least on a quarterly basis. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-007
Restricted Grants and Contributions Material Weakness Condition: There is a lack of internal controls related to tracking of donor restrictions. Specifically, there was no formal process to track and manage restricted contributions with donor-imposed restrictions. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Risk of non-compliance with accounting standards and the potential of misuse of donor funds. Recommendation: We recommend the Organization establish an internal process to accurately track, monitor and report donor restrictions to ensure compliance with accounting principles and transparency in financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.
Finding 2024-008
Year-end Bank Reconciliations Material Weakness Condition: At the time of our audit test work, the year end bank reconciliations, prepared by the Director of Finance, included several large reconciling items and were not reviewed independent of preparation. Criteria: Adequate internal control functions over the financial reporting process. Cause: Oversight by management. Effect: Opportunity for misappropriation of assets, and possibility that a misstatement of the Organization's financial statements will not be prevented, or detected and corrected, on a timely basis. Recommendation: We recommend all bank reconciliations be reviewed and approved as part of month-end procedures to improve internal controls of accuracy and transparency of financial reporting. View of Responsible Official and Planned Corrective Action: Management agrees with the finding. See corrective action plan.