CORRECTIVE ACTION PLAN2025-001 [2023-001]—TRACKING AND VALUATION OF MORTGAGE RECEIVABLES AND AMOUNTS DUE TO GRANTORType of Finding: (A) Material Weakness in Internal Control Over Financial ReportingStatement of ConditionWhile the Housing Trust has begun a complete review of its loan portfolio, the project has not yet been completed. Therefore, we were unable to obtain sufficient audit evidence to support the Housing Trust’s tracking and valuation of its mortgage receivables and amounts that are due to grantor.Per our audit procedures, we noted that management was unable to provide the following:A reasonable methodology for estimating its allowance for loan losses.Funding provided by grantors for the loan programs that should also be classified as amounts that are due to grantor.Not all current year loans were recorded in the general ledger (approximative $512,066) and approx. $481,201 were recorded twice.A net prior year adjustment of $36,460 for mortgages receivable and $35,000 for land leases held was necessary.Reclassification between loans accounts and grant revenue were necessaryContextThe Housing Trust has a portfolio of over six-hundred individual mortgage receivables that include both non-amortizing and amortizing loans, which management has valued at approximately $25,291,075. These loans have been funded by several sources, including federal, state, and local funding. Some of the grantors have established in their agreements that these funds do not belong to the Housing Trust, but actually belong to the grantor. CriteriaThe Housing Trust should ensure it has a board-approved policy for its loan portfolio to ensure that these assets are properly tracked, classified, and maintained with specialized loan management software that can perform the following:Loan Classification and TrackingEach loan is properly identified with its funding source (federal, state, local, etc.) and type of restriction Each loan agreement has the funding source specifiedThe current status of each loan is tracked (current, delinquent, defaulted)Loan funding that has been established as due to the grantor is properly tracked.Compliance and ReportingEnsure the loans comply with the specific guidelines of their respective funding source. Audit trails are available for all transactions and valuations.The receivables and related interest accruals supported by the loan management software should be reconciled to the Housing Trust’s accounting software.Financial TrackingThe valuation of the portfolio should be updated periodically (at least quarterly) for any changes in loan status or market conditions.All new loans should be recorded in the general ledger A loan loss policy was established that includes a loan loss methodology incorporating risk classes based on the borrower’s ability to repay. However, the calculations seem to follow a different methodology established afterwards. The policy should be updated with calculation methodology and with the backup research of historical data. A loan review committee should be responsible for reviewing and approving the classifications of loans and the associated allowance for loan losses which should be supported by high-quality data collection on each borrower’s payment history and any relevant economic indicators. The calculations and methodology should follow the approved policy, or the policy should be improved to include all factors mentioned above.EffectThe auditors were not able to verify the accuracy of the loan records and financial statements related to mortgage loans, the related accrued loan interest, the allowance for loan losses and loan funding that should also be recorded as due to grantor. CauseWhile the Housing Trust has begun a complete review of its loan portfolio, the project has not yet been completed. Therefore, the loan portfolio tracking and valuation have not yet been designed or implemented to support its policies and procedures or provide the loan review committee with a workable system for reviewing, approving and monitoring the organization’s mortgage receivable portfolio. The methodology seems to be changing, and the calculations do not seem to be accurate,RecommendationWe recommend the Housing Trust update policies and procedures for its loan portfolio as identified in the “Context” section of this finding to include methodology, risk assessment, historical loan data research, calculations method with reasoning.View of Responsible OfficialThe Housing Trust acknowledges the finding. Due to turnover in prior years, historical loan records and tracking systems were incomplete or inaccurate. Since then, SFCHT has taken the following steps:A second title company has been contracted to obtain final loan data for the 2026 loan portfolio. A title company will also be engaged annually at year-end to identify and resolve any differences arising during the year.Establish one master loan inventory using Portfol data. This inventory will serve as the master loan control schedule for monthly financial reconciliations. All differences will have a documented resolution, including reconciliation of receivables and related interest between the two systems. Reconciliations will be completed by the 15th business day of the following month.Create a new loan-recording process for every loan closing.Create a Due to Grantor Matrix based on findings from the annual loan review performed by the title company. Supporting documentation, such as grant agreements, correspondence, or other applicable documentation, will be maintained.Review the ASC 326 loan loss methodology to ensure it reflects the actual calculation methodology and is supported by appropriate research. This review will be performed quarterly.Establish a formal loan review committee and process to review loan calculations and the allowance for loan losses. The committee will meet quarterly and review reports from Portfol. Meeting minutes will document updates, decisions, and changes.Corrective Action Plan TimelineFinalize and implement the loan loss methodology: by December 2026Begin monthly Portfol-to-QBO reconciliations: by September 2026Fully hand over all loans to Amerinat by end of 2026; Land Leases will remain “in-house”Continue staff training and Executive-level reviewDesignated Employee Responsible for Corrective Action-Director of Operations-Accounting Specialist2025-002 [2023-002]—FINANCIAL CLOSE AND RESTATEMENTS TO BEGINNING NET ASSETSType of Finding: (A) Material Weakness in Internal Control Over Financial ReportingStatement of ConditionDuring the audit of the financial statements, we noted that material adjustments and restatements were necessary to correct errors in the current and previously reported financial statements. A summary of the areas and the net effect of the changes are as follows: Type Amount, net Accounts Receivable $ (13,490) Grants and Contracts Receivable 830,747 Accrued Interest 5,798 Amortizing Loan Receivable 419,551 Non-Amortizing Loans Receivable (433,722) Land Held in Trust (61,323) Other Assets (145,000) Prepaid Expenses (61,940) Notes Receivable (195,000) Developments Projects (184,559) Real Estate Inventory to Sell (333,079) Fixed Assets (785,081) ROU Accumulated Amortization (7,511) Accounts Payable (807) Due to Grantor 10,000 Grant Advances (97,963) Accrued Expenses (6,249) Other Current Liabilities 52,841 Lease Liabilities 7,845 Notes Payable (9,710) Net Assets 1,154,733 Total $ 146,081 CriteriaAccounting Standards Codification (ASC) 265 “Presentation of Financial Statements—Communicating Internal Control Related Matters Identified in an Audit” requires that deficiencies in internal control over financial reporting be communicated to those charged with governance when the design or operation of a control does not allow management or employees to prevent or detect misstatements on a timely basis.The correction of material misstatements indicates the existence of a material weakness in internal control over the maintenance of the organization’s financial statements.EffectThe material adjustments and restatements resulted in significant changes to the current year balances and beginning balances of the organization’s unrestricted and restricted net assets. These adjustments could potentially undermine the stakeholders' confidence in the financial information presented by the organization and may lead to difficulties in securing future funding or maintaining current donor relationships.CauseThe material misstatements were caused by a weakness in the development and implementation of internal controls and financial reporting processes, as well as significant turnover in the organization’s management.RecommendationWe recommend the Housing Trust strengthens its internal controls and financial reporting processes to prevent future occurrences of such errors. This could involve adding additional staff, training current accounting staff and implementing more robust review procedures to ensure that all financial reporting is in strict accordance with GAAP. View of Responsible OfficialThe Housing Trust acknowledges the finding. In prior years, however, internal controls were insufficient. There was no formal month-end close or review process, and prior audits relied on outdated balances without verification. Under new leadershipA formal monthly close calendar has been established, with the monthly close to be completed within 10-15 business days.Create a supporting schedule for every balance sheet account. These schedules will be used as part of the monthly reconciliation process and will be certified.A grant receivable roll-forward will be prepared for each grant, compared to QuickBooks, and reconciled monthly.Each development project will have its own subledger, which will be reconciled monthly.A detailed fixed asset register will be maintained and reconciled quarterly.6. To help prevent future restatements, establish a formal journal-entry control process that requires appropriate supporting documentation and approvals.7. Establish a policy requiring documentation and approval for any changes made to beginning balances.8. The CEO and Finance Committee will perform monthly analytical reviews using the balance sheet, profit and loss statement, and actual-to-budget comparisons.9. Establish a reconciliation exception and audit adjustment log to track outstanding issues requiring resolution, including a timeline for resolving each item.Corrective Action Plan Timeline The timeline to complete this is prior to December 31, 2026.Designated Employee Responsible for Corrective Action-Director of Operations-Accounting Specialist2025-003 [2024-003] - GRANT TRACKING AND SEFA RECONCILIATIONFederal Agency: U.S. Department of Housing and Urban Development (HUD)Federal Program: Housing Opportunities for Persons With AIDS (HOPWA)Assistance Listing Number: 14.241Award Number and Period: [NMH240051], [November 1, 2024 – October 31, 2027]Type of Compliance Requirements: Internal Controls Type of Finding: (B) Significant Deficiency in Internal Control Over Financial ReportingKnown Questions Cost: NoneStatement of ConditionDuring our audit, we identified initial differences between expenditures reported on the Schedule of Expenditures of Federal Awards (SEFA) and the general ledger. Management subsequently provided additional supporting schedules and completed a reconciliation of the SEFA to the general ledger. However, the reconciliation required manual effort because one federal award included program income amounts that had not been properly reconciled or corrected, another federal award had expenses that did not belong to the award, and recycled funds were tracked separately partially only from new grant funds in the accounting records. Some of expenses did not have appropriate backup documentation, however, the billing to the grant was correct. Expenses from program income for salaries did not match the timesheets. CriteriaPer 2 CFR 200.302 and 200.510(b), recipients of federal awards must maintain accurate, current, and complete records that adequately identify the source and application of funds. Grant expenditures must be traceable to the financial records and properly classified. Program income, including recycled funds, must be used and tracked in accordance with federal requirements and grantee policies. Specifically, all grants should be tracked separately in the general ledger, and the revenue and expenses should match the reimbursement grants. The SEFA reconciliation should be done thoroughly and discrepancies reconciled or resolved, if that is the case. The policies for recycling the funds should be updated with the financial tracking in the general ledger and update with all grantor recommendations. The HOPWA program policy was updated in July 2025.The recycled funds received/spent should be separately tracked and used per policies and grantor recommendations.EffectThe lack of properly tracking expenditures and recycled funds increases the risk of misstating the SEFA, billing non-allowable or duplicate costs to the grantor, and not meeting timeliness or use restrictions related to program income. This may lead to questioned costs or future audit findings.Recycled funds not properly tracked separately may result in noncompliance with the application of loan funding. CauseThe issues stemmed from frequent staff turnover and the complexity of accounting for loans and recycled funds across departments. RecommendationWe recommend the Housing Trust:Revise and implement grant management policy and procedures that ensure each grant has a dedicated general ledger account.Require all reimbursement requests to be supported by general ledger detail.Ensure program income and recycled funds are separately tracked in accordance with federal guidelines (separate classes).Establish regular reconciliations between Finance and Program records to maintain consistency.View of Responsible OfficialThe Housing Trust acknowledges the finding. Corrective Action Plan: 1. A master grant register has been created that includes all active grants and federal awards.2. Each grant will have a unique class/project established in QuickBooks to capture payroll and other grant-related expenses. Reports will be generated monthly.3. Each grant will be reconciled monthly.4. Grant reimbursement requests will be supported by appropriate documentation.5. Payroll review procedures have been established to confirm that payroll costs are properly allocated to grants.6. Program income will be tracked separately for all applicable income and expenditures.7. Monthly SEFA reconciliations will be completed for all grants, including grants that do not meet the definition for inclusion in the SEFA.8. A grant reconciliation exception log will be established to track outstanding issues, responsible parties, and timelines for resolution. Corrective Action Plan Timeline- Finalize and adopt new Grant Management Policies: by September 2026- Implement monthly SEFA reconciliations: by September 2026- Complete staff training on program income and federal grant tracking: by September 2026Designated Employee Responsible for Corrective Action-Director of Operations-Accounting SpecialistCurrent Year Findings 2025-004 - Program Income Federal Agency: U.S. Department of Housing and Urban Development (HUD)Federal Program: Housing Opportunities for Persons With AIDS (HOPWA)Assistance Listing Number: 14.241Federal Award: [NMH240051], [November 1, 2024 – October 31, 2027]Compliance Requirement: Program Income Known Questions Cost: None Type of Finding: (F, G) Significant Deficiency in Internal Control Over Compliance of Federal Awards and Instance of Noncompliance related to Federal Awards Statement of Condition During 2025, the Housing Trust received certain repayments of loans originally funded by HOPWA awards. Of this amount, certain amount may have remained unspent or had not been recorded/reconciled in accordance with HUD requirements as of December 31, 2025. Management did not maintain a documented control to identify HOPWA repayment receipts, determine the applicable award requirements, reconcile receipts and expenditures among IDIS, QuickBooks, and the program-income subsidiary record, and document approval of their disposition. Criteria Under 2 CFR 200.307(c), program income earned after a Federal award’s period of performance is subject to Federal requirements only when required by Federal agency regulations or the terms and conditions of the award, and the Federal agency may establish appropriate disposition requirements through closeout. HUD may require HOPWA-funded loan repayments received after the original award period to be recorded as program income.CauseThe Housing Trust had not designed and assigned ownership of a formal program-income and grant-closeout control addressing repayments generated from HOPWA-funded loans after the originating award’s period of performance. Effect Program income may have been subject to incorrect or untimely reporting/use, increasing the risk of noncompliance and misstatement of federal expenditures. Known questioned costs were unknown. RecommendationHousing Trust should implement a documented monthly program-income reconciliation and grant-closeout control that identifies the originating award, applicable HUD disposition requirement, IDIS receipt, QBO classification, eligible use, remaining balance, reviewer approval, and resolution of differences. Evidence of HUD determinations for post-period receipts should be retained with the reconciliation.Views of Responsible Officials: SFCHT acknowledges the finding and notes that the New Mexico HOPWA program is the only documented HUD grant that funds mortgages.Management has established a formal process to identify and track repayments associated with HOPWA-funded loans. Management will maintain a subsidiary program income register that identifies the originating federal award, receipts, applicable HUD disposition requirements, accounting classification, eligible expenditures, and remaining balance. Program income activity will be reconciled monthly among loan-servicing records, QBO, IDIS, and supporting program records. Written HUD determinations regarding post-period repayments will be retained when applicable.Corrective Action Plan TimelineAn onsite meeting with HUD HOPWA representatives is scheduled for September 10, 2026, at the Santa Fe offices. During this meeting, policies and procedures, including the program income policy, will be reviewed and formalized, and a HUD determination log will be established.The HOPWA Program Income Register will be implemented, and repayment schedules for HOPWA loans will be documented in the master loan inventory. Implementation date: July 2026.HOPWA program income will be expended before additional HOPWA IDIS reimbursement requests are approved.A historical review of HOPWA loans and funding sources will be completed. Target date: August 2026.QBO, Portfol, Amerinat, and IDIS will be reconciled monthly. Beginning: July 2026 and ongoing.Post-period repayments and related HUD determinations will be reviewed. Target date: September 2026.Designated Employee Responsible for Corrective Action Director of Operations, with assistance from the Accounting Specialist and HOPWA HUD program staff, as applicable.Signature Title