Audit 320943

FY End
2023-12-31
Total Expended
$17.66M
Findings
14
Programs
3
Year: 2023 Accepted: 2024-09-25

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
498188 2023-001 - Yes N
498189 2023-002 - Yes N
498190 2023-003 - - N
498191 2023-004 - - B
498192 2023-007 - - N
498193 2023-005 - Yes N
498194 2023-006 - - N
1074630 2023-001 - Yes N
1074631 2023-002 - Yes N
1074632 2023-003 - - N
1074633 2023-004 - - B
1074634 2023-007 - - N
1074635 2023-005 - Yes N
1074636 2023-006 - - N

Contacts

Name Title Type
J5ZXT2W8K7S7 Les Russo Auditee
8474245601 Brian Baker Auditor
No contacts on file

Notes to SEFA

Title: NOTE A – 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. De Minimis Rate Used: N Rate Explanation: Over the Rainbow Association and Subsidiaries has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. The accompanying schedule of expenditures of federal awards includes the federal award activity of Over the Rainbow Association and Subsidiaries and is presented on the accrual basis of accounting. The information in this schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of Over the Rainbow Association and Subsidiaries, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Over the Rainbow Association and Subsidiaries.
Title: NOTE B – 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. De Minimis Rate Used: N Rate Explanation: Over the Rainbow Association and Subsidiaries has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. 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. Over the Rainbow Association and Subsidiaries has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance.
Title: NOTE C - U.S. DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT LOAN PROGRAM 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. De Minimis Rate Used: N Rate Explanation: Over the Rainbow Association and Subsidiaries has elected not to use the 10-percent de minimis indirect cost rate allowed under the Uniform Guidance. Arboretum West Apartments received a U.S. Department of Housing and Urban Development Insured Mortgage under Section 223(f) of the National Housing Act of 1990 (Assistance Listing Number 14.155). The loan balance outstanding at the beginning of the year is included in the federal expenditures presented in the Schedule. Arboretum West Apartments received no additional loans during the year ended December 31, 2023. The balance of the loan outstanding at December 31, 2023 was $859,512.

Finding Details

DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility FINDING 2023-001: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project did not deposit surplus cash at December 31, 2021 into a residual receipts account. The amount that should have been deposited was $14,079. Criteria: The Project should have deposited surplus cash at December 31, 2021 into a residual receipts account. Effect: The residual receipts account balance was $14,079 less than it should be at December 31, 2023. Context: Activity in the residual receipts account for the year ended December 31, 2023 was tested. No sample was tested. Questioned Costs - $14,079, Cause: The Project did not make the necessary deposit of surplus cash into a residual receipts account. Recommendation: The Project should deposit surplus cash as of December 31, 2021 into a residual receipt account as soon as possible. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. Management will deposit $14,079 into a residual receipts account as soon as possible. Total - Department of Housing and Urban Development - $14,079, Non-compliance code - B
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-002: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project repaid a portion of the sponsor loan payable (Due to Related Party) without obtaining HUD approval. The total amount of the unauthorized sponsor loan payment was $130,019. Criteria: HUD approval should be obtained prior to making a sponsor loan repayment. Effect: The Project's cash balance is $130,019 less than it should be. Context: The Sponsor loan payable at December 31, 2023 was tested. The test determined that a portion of the sponsor loan was repaid without obtaining HUD approval. Questioned Costs - $130,019, Cause: The Project repaid a portion of the sponsor loan without obtaining HUD approval. Recommendation: The Sponsor should work with HUD to determine if the $130,019 needs to be paid back to the Project. Views of Responsible Officials and Planned Corrective Actions: The Sponsor will work with HUD to detemine if the $130,019 needs to be paid back to the Project. Total - Department of Housing and Urban Development - $130,019, Non-compliance code - R
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-003: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: One of the tenant files tested did not have evidence of verification of disability and/or handicapped status that would make the tenant eligible for the program. Criteria: Tenant files should contain documentation of disability/handicapped status. Effect: The Project received HUD subsidy that it may not be entitled to. Context: A sample of tenant files was selected for testing for evidence of verification of disability and/or handicapped status. The test found one file not in compliance. The non-compliance did not have a financial effect. The details and results of the sample are as follows: Population - 29, $ - N/A; Sample - 3, $ - N/A; Not in Compliance - 1, $ - N/A; Questioned Costs - None; Cause: The Project manager overlooked the requirement for verification of disability/handicapped status. Recommendation: The Project manager should attempt to obtain proper verification of disability/handicapped status on this tenant. If verification cannot be obtained, the Project should reimburse HUD for all rent subsidy on this tenant. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The project managers were reminded to obtain documentation to verify disability/handicapped status. Total - Department of Housing and Urban Development - Questioned Costs = None; Non-compliance code - R
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-004: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project overpaid management fees to the management company. Criteria: The management company should calculate management fees using the correct formula. Effect: The Project's management fee expense is overstated. Context: The management fee for the year was tested for accuracy. Through testing, it was determined that the total cash receipts number used to calculate management fee was overstated. The details and results of the sample are as follows: Population - $31,166; Sample - $31,166; Not in Compliance - $31,166; Questioned Costs - $653; Cause: The management company did not compute the management fee correctly. Recommendation: The management company should repay the $653 to the Project. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The management company will repay the management fee overpayment as soon as possible. Total - Department of Housing and Urban Development - $653; Non-compliance code - J
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT - For the OTR - Arboretum West Apartments Facility - FINDING 2023-007: SECTION 223(f), ASSISTANCE LISTING NUMBER 14.155; Condition: The Project's replacement reserve cash balance was underfunded at December 31, 2023. Criteria: The Project should have made the required monthly deposits. Effect: The replacement reserve cash balance was $488 less than it should be at December 31, 2023. Context: All activity in the replacement reserve account for the year ended December 31, 2023 was tested. No sample was selected. Questioned Costs - $488; Cause: The Project neglected to make one of the required monthly deposits. Recommendation: The Project should deposit the correct amount monthly to the reserve. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. Management will be reminded to deposit the correct amount monthly to the reserve. The Project will also deposit $488 into the reserve as soon as possible. Questioned Costs - Department of Housing and Urban Development - $488; Non-compliance code - N
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Rockford Supportive Housing Facility - FINDING 2023-005: SECTION 811, ASSISTANCE LISTING NUMBER 14.181 Condition: The Project took a HUD subsidy loan from replacement reserves of $15,000 and failed to repay the loan based upon the terms of the agreement with HUD. Criteria: The Project should have repaid the required amount to replacement reserves. Effect: The replacement reserve balance was underfunded by $15,000 at December 31, 2023. Context: All elements of the replacement reserve account were tested at December 31, 2023. No sample was selected. Questioned costs - $15,000; Cause: The Project neglected to repay the HUD subsidy loan based upon the terms of the agreement. Recommendation: The Project should repay the HUD subsidy loan as soon as funds are available. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. A $15,000 transfer will be made once funds are available. Management will be reminded to carefully review HUD correspondence to make sure HUD subsidy loan terms are being followed. Questioned Costs - Department of Housing and Urban Development - $15,000; Non-compliance code - N
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT - For the Waukegan Supportive Housing Facility - FINDING 2023-006: SECTION 811, ASSISTANCE LISTING NUMBER 14.181, Condition: One of the tenant files tested did not have evidence of verification of disability and/or handicapped status that would make the tenant eligible for the program. Criteria: Tenant files should contain documentation of disability/handicapped status. Effect: The Project received HUD subsidy that it may not be entitled to. Context: A sample of tenant files was selected for testing for evidence of verification of disability and/or handicapped status. The test found one file not in compliance. The non-compliance did not have a financial effect. The details and results of the sample are as follows: Population - 23, $ - N/A; Sample - 3, $ - N/A; Not in Compliance - 1, $ - N/A; Questioned Costs - None; Cause: The Project manager overlooked the requirement for verification of disability/handicapped status. Recommendation: The Project manager should attempt to obtain proper verification of disability/handicapped status on this tenant. If verification cannot be obtained, the Project should reimburse HUD for all rent subsidy on this tenant. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The project managers were reminded to obtain documentation to verify disability/handicapped status. Questioned Costs - Department of Housing and Urban Development - None; Non-compliance code - R
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility FINDING 2023-001: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project did not deposit surplus cash at December 31, 2021 into a residual receipts account. The amount that should have been deposited was $14,079. Criteria: The Project should have deposited surplus cash at December 31, 2021 into a residual receipts account. Effect: The residual receipts account balance was $14,079 less than it should be at December 31, 2023. Context: Activity in the residual receipts account for the year ended December 31, 2023 was tested. No sample was tested. Questioned Costs - $14,079, Cause: The Project did not make the necessary deposit of surplus cash into a residual receipts account. Recommendation: The Project should deposit surplus cash as of December 31, 2021 into a residual receipt account as soon as possible. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. Management will deposit $14,079 into a residual receipts account as soon as possible. Total - Department of Housing and Urban Development - $14,079, Non-compliance code - B
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-002: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project repaid a portion of the sponsor loan payable (Due to Related Party) without obtaining HUD approval. The total amount of the unauthorized sponsor loan payment was $130,019. Criteria: HUD approval should be obtained prior to making a sponsor loan repayment. Effect: The Project's cash balance is $130,019 less than it should be. Context: The Sponsor loan payable at December 31, 2023 was tested. The test determined that a portion of the sponsor loan was repaid without obtaining HUD approval. Questioned Costs - $130,019, Cause: The Project repaid a portion of the sponsor loan without obtaining HUD approval. Recommendation: The Sponsor should work with HUD to determine if the $130,019 needs to be paid back to the Project. Views of Responsible Officials and Planned Corrective Actions: The Sponsor will work with HUD to detemine if the $130,019 needs to be paid back to the Project. Total - Department of Housing and Urban Development - $130,019, Non-compliance code - R
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-003: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: One of the tenant files tested did not have evidence of verification of disability and/or handicapped status that would make the tenant eligible for the program. Criteria: Tenant files should contain documentation of disability/handicapped status. Effect: The Project received HUD subsidy that it may not be entitled to. Context: A sample of tenant files was selected for testing for evidence of verification of disability and/or handicapped status. The test found one file not in compliance. The non-compliance did not have a financial effect. The details and results of the sample are as follows: Population - 29, $ - N/A; Sample - 3, $ - N/A; Not in Compliance - 1, $ - N/A; Questioned Costs - None; Cause: The Project manager overlooked the requirement for verification of disability/handicapped status. Recommendation: The Project manager should attempt to obtain proper verification of disability/handicapped status on this tenant. If verification cannot be obtained, the Project should reimburse HUD for all rent subsidy on this tenant. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The project managers were reminded to obtain documentation to verify disability/handicapped status. Total - Department of Housing and Urban Development - Questioned Costs = None; Non-compliance code - R
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Hill Housing Facility - FINDING 2023-004: SECTION 8, ASSISTANCE LISTING NUMBER 14.195 Condition: The Project overpaid management fees to the management company. Criteria: The management company should calculate management fees using the correct formula. Effect: The Project's management fee expense is overstated. Context: The management fee for the year was tested for accuracy. Through testing, it was determined that the total cash receipts number used to calculate management fee was overstated. The details and results of the sample are as follows: Population - $31,166; Sample - $31,166; Not in Compliance - $31,166; Questioned Costs - $653; Cause: The management company did not compute the management fee correctly. Recommendation: The management company should repay the $653 to the Project. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The management company will repay the management fee overpayment as soon as possible. Total - Department of Housing and Urban Development - $653; Non-compliance code - J
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT - For the OTR - Arboretum West Apartments Facility - FINDING 2023-007: SECTION 223(f), ASSISTANCE LISTING NUMBER 14.155; Condition: The Project's replacement reserve cash balance was underfunded at December 31, 2023. Criteria: The Project should have made the required monthly deposits. Effect: The replacement reserve cash balance was $488 less than it should be at December 31, 2023. Context: All activity in the replacement reserve account for the year ended December 31, 2023 was tested. No sample was selected. Questioned Costs - $488; Cause: The Project neglected to make one of the required monthly deposits. Recommendation: The Project should deposit the correct amount monthly to the reserve. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. Management will be reminded to deposit the correct amount monthly to the reserve. The Project will also deposit $488 into the reserve as soon as possible. Questioned Costs - Department of Housing and Urban Development - $488; Non-compliance code - N
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT For the Rockford Supportive Housing Facility - FINDING 2023-005: SECTION 811, ASSISTANCE LISTING NUMBER 14.181 Condition: The Project took a HUD subsidy loan from replacement reserves of $15,000 and failed to repay the loan based upon the terms of the agreement with HUD. Criteria: The Project should have repaid the required amount to replacement reserves. Effect: The replacement reserve balance was underfunded by $15,000 at December 31, 2023. Context: All elements of the replacement reserve account were tested at December 31, 2023. No sample was selected. Questioned costs - $15,000; Cause: The Project neglected to repay the HUD subsidy loan based upon the terms of the agreement. Recommendation: The Project should repay the HUD subsidy loan as soon as funds are available. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. A $15,000 transfer will be made once funds are available. Management will be reminded to carefully review HUD correspondence to make sure HUD subsidy loan terms are being followed. Questioned Costs - Department of Housing and Urban Development - $15,000; Non-compliance code - N
DEPARTMENT OF HOUSING AND URBAN DEVELOPMENT - For the Waukegan Supportive Housing Facility - FINDING 2023-006: SECTION 811, ASSISTANCE LISTING NUMBER 14.181, Condition: One of the tenant files tested did not have evidence of verification of disability and/or handicapped status that would make the tenant eligible for the program. Criteria: Tenant files should contain documentation of disability/handicapped status. Effect: The Project received HUD subsidy that it may not be entitled to. Context: A sample of tenant files was selected for testing for evidence of verification of disability and/or handicapped status. The test found one file not in compliance. The non-compliance did not have a financial effect. The details and results of the sample are as follows: Population - 23, $ - N/A; Sample - 3, $ - N/A; Not in Compliance - 1, $ - N/A; Questioned Costs - None; Cause: The Project manager overlooked the requirement for verification of disability/handicapped status. Recommendation: The Project manager should attempt to obtain proper verification of disability/handicapped status on this tenant. If verification cannot be obtained, the Project should reimburse HUD for all rent subsidy on this tenant. Views of Responsible Officials and Planned Corrective Actions: The Project agrees with the finding. The project managers were reminded to obtain documentation to verify disability/handicapped status. Questioned Costs - Department of Housing and Urban Development - None; Non-compliance code - R