Audit 20670

FY End
2022-06-30
Total Expended
$1.20M
Findings
2
Programs
2
Year: 2022 Accepted: 2022-10-13

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
22386 2022-001 Significant Deficiency - N
598828 2022-001 Significant Deficiency - N

Programs

ALN Program Spent Major Findings
14.181 Supportive Housing for Persons with Disabilities $1.14M Yes 1
14.182 Project Rental Assistance Contract New Construction $60,782 - 0

Contacts

Name Title Type
QJ95XUJJTXM3 Rhonda M. Kay Auditee
3183570553 Carol Brasher Auditor
No contacts on file

Notes to SEFA

Title: NOTE 3 RELATIONSHIP TO BASIC FINANCIAL STATEMENTS Accounting Policies: NOTE 1 BASIS OF PRESENTATION---The accompanying schedule of expenditures of federal awards includes the federal grant activity of Magnolia Housing Corporation of Natchitoches, Inc., HUD Project No. 064-HD044-WAH-NP-L8, 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 the Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------NOTE 2 SUMMARY OF SIGNIFICANT 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. The Corporation has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Federal award revenues earned under the Project Rental Assistance Contract are reported in the Corporations Statement of Activities. The mortgage payable of $1,137,700 is reported in the Corporations Statement of Financial Position in long-term liabilities.
Title: NOTE 4 RELATIONSHIP TO FEDERAL FINANCIAL REPORTS Accounting Policies: NOTE 1 BASIS OF PRESENTATION---The accompanying schedule of expenditures of federal awards includes the federal grant activity of Magnolia Housing Corporation of Natchitoches, Inc., HUD Project No. 064-HD044-WAH-NP-L8, 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 the Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------NOTE 2 SUMMARY OF SIGNIFICANT 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. The Corporation has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. Amounts reported above agree with the amounts reported in the related federal financial reports except for changes made to reflect amounts in accordance with accounting principles generally accepted in the United States of America.
Title: NOTE 5 EXPENDITURES OF FEDERAL AWARDS TO SUBRECIPIENTS Accounting Policies: NOTE 1 BASIS OF PRESENTATION---The accompanying schedule of expenditures of federal awards includes the federal grant activity of Magnolia Housing Corporation of Natchitoches, Inc., HUD Project No. 064-HD044-WAH-NP-L8, 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 the Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements.-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------NOTE 2 SUMMARY OF SIGNIFICANT 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. The Corporation has elected not to use the 10-percent de minimis indirect cost rate as allowed under the Uniform Guidance. De Minimis Rate Used: N Rate Explanation: The auditee did not use the de minimis cost rate. The Corporation did not have expenditures of federal awards to subrecipients.

Finding Details

SECTION II ? FINANCIAL STATEMENT FINDINGS Finding 2022-1 Lack of Internal Controls Over Monthly Replacement Reserve Funding Finding Resolution Status: Resolved Information on Universal Population Size: Two Instances Sample Size: 12 Identification of Repeat Finding and Finding Reference Number: N/A Questioned Costs: $0 Criteria: Monthly deposits to the Replacement Reserve account must be made monthly in accordance with HUD required amounts. Condition: In accordance with the HUD requirements, the Project was required to make monthly deposits to the Replacement Reserve account in the total amount of $16,128 for the year ended June 30, 2022. The Project made monthly deposits to the Replacement Reserve account in the total amount of $13,440 for the year ended June 30, 2022, which created a deficiency of $2,688 in the Replacement Reserve account at June 30, 2022. Two monthly deposits were not made during the year ended June 30, 2022. There were no internal controls in place to detect or prevent missed deposits to the Replacement Reserve account. Cause: Unknown Effect: Replacement Reserve account is underfunded and the Project is not in compliance with HUD?s regulations. If a significant replacement need were to arise, there may not be adequate funds in Replacement Reserve to cover the cost. Auditors? Recommendation: Management should implement internal controls suitable to detect and prevent missed replacement reserve deposits and to ensure that the Management makes all required monthly deposits to the Replacement Reserve account. Also, Management should make the necessary deposit to restore the funding shortfall as of June 30, 2022. In addition, Management should establish internal control procedures to reconcile, on a monthly basis, the Replacement Reserve account balance and the Replacement Reserve general ledger to the total amount of the Replacement Reserve required by HUD. Auditor Non-Compliance Code: N ? Reserve for Replacement Requirements FHA/Contract Number: 064- HD044 Auditor?s Summary of the Auditee?s Comments on the Findings and Recommendations: The Auditee has resolved this finding as of September 15, 2022, by depositing the two missed deposits in the amount of $2,688. The Auditee has also taken steps to prevent this finding in the future by implementing new controls of automatic monthly transfer of deposit to the Replacement Reserve. Reporting Views of Responsible Officials: We agree with the auditor?s finding and recommendations. Magnolia Manor has taken steps to assure that the Replacement Reserve account will not be underfunded again by making the transfer an automatic transfer from the Operating account to the Replacement Reserve account. The amount that the account was underfunded was deposited on September 15, 2022. Response Indicator: Agree Completion Date: September 15, 2022 Response: Magnolia Manor has taken steps to assure that the Replacement Reserve account will not be underfunded again by making the transfer an automatic transfer from the Operating account to the Replacement Reserve account. The amount that the account was underfunded was deposited on September 15, 2022. Contact Person: Rhonda M. Kay SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Supportive Housing for Persons with Disabilities CFDA # 14.181 See Finding 2022-1 under Section II ? Financial Statement Findings.
SECTION II ? FINANCIAL STATEMENT FINDINGS Finding 2022-1 Lack of Internal Controls Over Monthly Replacement Reserve Funding Finding Resolution Status: Resolved Information on Universal Population Size: Two Instances Sample Size: 12 Identification of Repeat Finding and Finding Reference Number: N/A Questioned Costs: $0 Criteria: Monthly deposits to the Replacement Reserve account must be made monthly in accordance with HUD required amounts. Condition: In accordance with the HUD requirements, the Project was required to make monthly deposits to the Replacement Reserve account in the total amount of $16,128 for the year ended June 30, 2022. The Project made monthly deposits to the Replacement Reserve account in the total amount of $13,440 for the year ended June 30, 2022, which created a deficiency of $2,688 in the Replacement Reserve account at June 30, 2022. Two monthly deposits were not made during the year ended June 30, 2022. There were no internal controls in place to detect or prevent missed deposits to the Replacement Reserve account. Cause: Unknown Effect: Replacement Reserve account is underfunded and the Project is not in compliance with HUD?s regulations. If a significant replacement need were to arise, there may not be adequate funds in Replacement Reserve to cover the cost. Auditors? Recommendation: Management should implement internal controls suitable to detect and prevent missed replacement reserve deposits and to ensure that the Management makes all required monthly deposits to the Replacement Reserve account. Also, Management should make the necessary deposit to restore the funding shortfall as of June 30, 2022. In addition, Management should establish internal control procedures to reconcile, on a monthly basis, the Replacement Reserve account balance and the Replacement Reserve general ledger to the total amount of the Replacement Reserve required by HUD. Auditor Non-Compliance Code: N ? Reserve for Replacement Requirements FHA/Contract Number: 064- HD044 Auditor?s Summary of the Auditee?s Comments on the Findings and Recommendations: The Auditee has resolved this finding as of September 15, 2022, by depositing the two missed deposits in the amount of $2,688. The Auditee has also taken steps to prevent this finding in the future by implementing new controls of automatic monthly transfer of deposit to the Replacement Reserve. Reporting Views of Responsible Officials: We agree with the auditor?s finding and recommendations. Magnolia Manor has taken steps to assure that the Replacement Reserve account will not be underfunded again by making the transfer an automatic transfer from the Operating account to the Replacement Reserve account. The amount that the account was underfunded was deposited on September 15, 2022. Response Indicator: Agree Completion Date: September 15, 2022 Response: Magnolia Manor has taken steps to assure that the Replacement Reserve account will not be underfunded again by making the transfer an automatic transfer from the Operating account to the Replacement Reserve account. The amount that the account was underfunded was deposited on September 15, 2022. Contact Person: Rhonda M. Kay SECTION III ? FEDERAL AWARD FINDINGS AND QUESTIONED COSTS Supportive Housing for Persons with Disabilities CFDA # 14.181 See Finding 2022-1 under Section II ? Financial Statement Findings.