Audit 334071

FY End
2024-06-30
Total Expended
$422.68M
Findings
18
Programs
9
Year: 2024 Accepted: 2024-12-20
Auditor: Rsm US LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
516257 2024-007 Material Weakness - P
516258 2024-008 Material Weakness - B
516259 2024-007 Material Weakness - P
516260 2024-008 Material Weakness - B
516261 2024-007 Material Weakness - P
516262 2024-007 Material Weakness - P
516263 2024-008 Material Weakness - B
516264 2024-007 Material Weakness - P
516265 2024-008 Material Weakness - B
1092699 2024-007 Material Weakness - P
1092700 2024-008 Material Weakness - B
1092701 2024-007 Material Weakness - P
1092702 2024-008 Material Weakness - B
1092703 2024-007 Material Weakness - P
1092704 2024-007 Material Weakness - P
1092705 2024-008 Material Weakness - B
1092706 2024-007 Material Weakness - P
1092707 2024-008 Material Weakness - B

Contacts

Name Title Type
KGAPBAMK58L3 Helena Siers Auditee
6512960749 Bart Rodberg Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate The accompanying schedule of expenditures of federal awards (the Schedule) includes the federal award activity of Minnesota Housing Finance Agency (the Agency) under programs of the federal government for the year ended June 30, 2024. The information in the 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 Schedule presents only a selected portion of the operations of the Agency, it is not intended to and does not present the financial position, changes in net assets, or cash flows of the Agency.
Title: Summary of Significant Accounting Policies Accounting Policies: 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years.
Title: Indirect Cost Rate Accounting Policies: 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate The Agency has elected not to use the 10% de minimis indirect cost rate as allowed under the Uniform Guidance.
Title: Loans Receivable Accounting Policies: 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate The Agency provides rental rehabilitation and new construction loans to approved properties via funding provided through ALN 14.239 HOME Investment Partnerships Program (the HOME Program). These loans have continuing compliance requirements during the period of affordability, as defined by the HOME Program requirements, which vary depending on the number of HOME Program units at each property. The balance of rental rehabilitation loans outstanding totaled $58,018,478 at June 30, 2024. The Agency provided loans to approved properties via funding provided through ALN 14.241 Housing Opportunities for Persons with AIDS (HOPWA). These capital loans have continuing compliance requirements during the period of affordability, as defined by the HOPWA program requirements. The balance of the capital loans outstanding totaled $209,631 at June 30, 2024. The Agency provided loans to approved properties via funding provided through ALN 14.275 Housing Trust Fund. These capital loans have continuing compliance requirements during the period of affordability, as defined by the program requirements. The balance of the capital loans outstanding totaled $16,779,958 at June 30, 2024.
Title: Reconciliation to the Financial Statements Accounting Policies: 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. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years. De Minimis Rate Used: N Rate Explanation: Auditee did not use the de minimis cost rate The reconciliation of the schedule of expenditures of federal awards to the Agency’s basic financial statements for the year ended June 30, 2024, is as follows: The total federal awards per the schedule of expenditures of federal awards is $ 422,678,239. The beginning balance of loans included in total federal awards is (83,962,670). The Administration fees received, included in fees earned and other income in the general reserve fund is (12,713,563). The expenditure of federal award that was reported as a reduction of subscription liability in the statement of net position is (382,418). Total federal appropriations disbursed per federal appropriated fund of the Agency is $ 325,619,588.

Finding Details

Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-007: Schedule of expenditures of federal awards presentation Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: HOME Investment Partnerships Program (ALN 14.239); Housing Trust Fund (ALN 14.275); COVID-19 - Emergency Rental Assistance (ALN 21.023); Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR section 200.510(b) which requires that the auditee must prepare a schedule of expenditures of Federal awards (SEFA) for the period covered by the auditee’s financial statements which must include the total Federal awards expended as determined in accordance with 2 CFR section 200.502. Further, the Agency is required to comply with 2 CFR 200.512 which requires that the information included in the reporting package is accurate and complete. Condition: We noted the following errors in the original SEFA we received for the audit: Loans provided under the HOME Investment Partnerships Program (ALN 14.239) were understated by $8,641,271 Loans provided under the Housing Trust Fund (ALN 14.275) were understated by $4,466,122 Expenditures under the Emergency Rental Assistance Program (ALN 21.023) were understated by $382,418 Expenditures under the COVID-19—Homeowner Assistance Fund Program (ALN 21.026) are overstated $403,795 Expenditures under the COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) are overstated $99,928 Cause: There was a breakdown in the Agency’s procedures related to preparation and review of the SEFA. The Agency’s procedures for preparing the SEFA did not account for classification of certain loans subject to continuing compliance requirements. The errors of $8,641,271 related to ALN 14.239 and $4,466,122 related to ALN 14.275 were caused by the Agency not properly identifying certain loans required to be included on the SEFA. The error of $382,418 related to ALN 21.023 was caused by the Agency reducing a subscription software disbursement by the portion of the disbursement related to payments on the subscription liability. The errors of $403,795 and $99,928 related to ALN 21.026 and ALN 14.239, respectively, were caused by the Agency charging certain direct and indirect costs from fiscal year 2021, 2022, and 2023 to the programs in fiscal year 2024. Effect: The Agency adjusted its fiscal year 2024 SEFA by $13,489,811 for the errors related to ALN 14.239, 14.275, and 21.023. The expenditures for ALN 21.026 and 14.239 are overstated $403,795 and $99,928, respectively. Questioned Costs: None Context: The Agency’s expenditures of federal awards reported on the SEFA were understated by $13,489,811 which was corrected during the audit. The Agency’s expenditures of federal awards reported on the SEFA for ALN 21.026 and ALN 14.239 are overstated $403,795 and $99,928, respectively, which the Agency did not correct. Total expenditures reported on the SEFA, as adjusted for this matter, are $422,678,239. Repeat Finding?: No Recommendation: We recommend that the Agency review and strengthen its processes and controls over the preparation of the SEFA. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.
Item 2024-008: Allowable Costs Federal Agency: U.S. Department of Housing and Urban Development; U.S. Department of Treasury Program: COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239); COVID-19 - Emergency Rental Assistance (ALN 21.023); COVID-19—Homeowner Assistance Fund Program (ALN 21.026) Pass-through Entity: None Federal Assistance Identification Number or Pass-Through Number: None Federal Award Year: Year ended June 30, 2024 Type of Finding: Compliance Finding and Material Weakness in Internal Control over Compliance Criteria: The Agency is required to comply with 2 CFR 200.502 which states, “The determination of when a Federal award is expended must be based on when the activity related to the Federal award occurs.” The Agency is also required to comply with 2 CFR 200.403 which indicates that allowable costs must be determined in accordance with accounting principles generally accepted in the United States of America (GAAP). Appendix VII to 2 CFR 200—State/Local Government and Indian Tribe-Wide Central Service Cost Allocation Plans 2 states, “Indirect cost rates will be reviewed, negotiated, and approved by the cognizant agency on a timely basis. Once a rate has been agreed upon, it will be accepted and used by all Federal agencies unless prohibited or limited by statute. Where a Federal awarding agency has reason to believe that special operating factors affecting its Federal awards necessitate special indirect cost rates, the funding agency will, prior to the time the rates are negotiated, notify the cognizant agency for indirect costs.” Condition: We noted the Agency charged $119,169 of direct and indirect costs from fiscal year 2021 and 2022, and direct costs from fiscal year 2023 to COVID-19—HOME Investment Partnerships Program, American Rescue Plan (ALN 14.239) in fiscal year 2024. We noted the Agency charged $426,504 of direct costs from fiscal year 2021 through 2023 to COVID-19 - Emergency Rental Assistance (ALN 21.023). We noted the Agency charged $1,153,427 of direct costs from fiscal year 2021 through 2023 to COVID-19—Homeowner Assistance Fund Program (ALN 21.026) in fiscal year 2024. These costs do not meet the allowable cost criteria as they were not determined in accordance with GAAP which requires expenses to be recorded when incurred. The Agency had an approved indirect cost rate which allowed them to charge the indirect costs in those previous fiscal years. Cause: The Agency incorrectly charged direct and indirect costs in fiscal year 2024 that were incurred in previous fiscal years for the programs noted above. Effect: The Agency inappropriately charged the above federal programs for direct and indirect costs in fiscal year 2024. During the audit, the Agency reevaluated its direct and indirect costs incurred in previous years that were charged in fiscal year 2024. The Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program to offset a portion of the errors identified above. This resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. Questioned Costs: ALN 14.239 – $119,169; ALN 21.023 – $426,504; ALN 21.026 – $1,153,427; Total – $1,699,100 Context: The Agency’s expenditures of federal awards charged to ALN 14.239, ALN 21.023 and ALN 21.026 were overstated $119,169, $426,504, and $1,153,427, respectively. During the audit, the Agency identified additional direct and indirect costs incurred in fiscal year 2024 that were eligible to be charged to ALN 14.239, ALN 21.023, and ALN 21.026 which were not previously charged to the program which resulted in the expenditures charged to ALN 14.239, ALN 21.023, and ALN 21.026 being overstated by $99,928, $0, and $403,795, respectively. The total expenditures for ALN 14.239, ALN 21.023, and ALN 21.026 are $81,364,920, $41,673,294, and $14,339,711, respectively. Repeat Finding?: No Recommendation: The Agency should charge direct and indirect costs to federal programs in the year the costs are incurred and using its approved indirect cost rate. Views of responsible officials of the auditee: We agree with the above finding and our response is included in the corrective action plan.