Audit 28806

FY End
2022-12-31
Total Expended
$753,177
Findings
26
Programs
2
Organization: Rs Eden (MN)
Year: 2022 Accepted: 2023-09-27
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
28689 2022-003 Significant Deficiency - P
28690 2022-004 Significant Deficiency - H
28691 2022-003 Significant Deficiency - P
28692 2022-004 Significant Deficiency - H
28693 2022-003 Significant Deficiency - P
28694 2022-004 Significant Deficiency - H
28695 2022-003 Significant Deficiency - P
28696 2022-004 Significant Deficiency - H
28697 2022-003 Significant Deficiency - P
28698 2022-004 Significant Deficiency - H
28699 2022-001 Material Weakness - L
28700 2022-002 Significant Deficiency - AB
28701 2022-003 Significant Deficiency - P
605131 2022-003 Significant Deficiency - P
605132 2022-004 Significant Deficiency - H
605133 2022-003 Significant Deficiency - P
605134 2022-004 Significant Deficiency - H
605135 2022-003 Significant Deficiency - P
605136 2022-004 Significant Deficiency - H
605137 2022-003 Significant Deficiency - P
605138 2022-004 Significant Deficiency - H
605139 2022-003 Significant Deficiency - P
605140 2022-004 Significant Deficiency - H
605141 2022-001 Material Weakness - L
605142 2022-002 Significant Deficiency - AB
605143 2022-003 Significant Deficiency - P

Programs

ALN Program Spent Major Findings
93.498 Provider Relief Fund $226,571 Yes 3
14.267 Continuum of Care Program $27,568 Yes 2

Contacts

Name Title Type
S5VEEG3VNBL9 Paul Puerzer Auditee
6122871618 Hannah Horn Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the consolidated schedule are reported on the accrual basis of accounting. Whenapplicable, 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. No federal financialassistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Organization does not draw for indirect administrative expenses and has not elected to use the 10% de minimus cost rate.. The accompanying consolidated schedule of expenditures of federal awards (the consolidated schedule)includes the federal award activity of RS EDEN and Subsidiaries (the Organization) under programs of the federalgovernment for the year ended December 31, 2022. The information is presented in accordance with therequirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, CostPrinciples, and Audit Requirements for Federal Awards (Uniform Guidance). Because the consolidated schedulepresents only a selected portion of the operations of the Organization, it is not intended to and does not presentthe financial position, changes in net assets, or cash flows of the Organization.
Title: Provider Relief Funds Accounting Policies: Expenditures reported on the consolidated schedule are reported on the accrual basis of accounting. Whenapplicable, 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. No federal financialassistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Organization does not draw for indirect administrative expenses and has not elected to use the 10% de minimus cost rate.. The Organization received amounts from the U.S. Department of Health and Human Services (HHS) through theProvider Relief Fund (PRF) program (Federal Financial Assistance Listing #93.498) during the year endedDecember 31, 2021, totaling $226,571. The Organization incurred eligible expenditures, including lost revenuesand therefore, recognized revenues totaling $226,571 for the year ended December 31, 2021 on theconsolidated financial statements. In accordance with the 2022 Compliance Supplement, the PRF expendituresrecognized on the consolidated schedule are based on the reporting to HHS for Period 4, defined as paymentsreceived during July 1, 2021, to December 31, 2021, of $226,571.The amount of PRF expenditures included on the consolidated schedule requires management to makeestimates and assumptions that affect the reported amounts. Accordingly, such expenditures are considered asignificant estimate. Estimates and assumptions may include reducing actual expenses by amounts that havebeen reimbursed or are obligated to be reimbursed by other sources and estimating marginal increases inexpenses related to coronavirus. Actual amounts could differ from those estimates.
Title: Basis of Consolidation Accounting Policies: Expenditures reported on the consolidated schedule are reported on the accrual basis of accounting. Whenapplicable, 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. No federal financialassistance has been provided to a subrecipient. De Minimis Rate Used: N Rate Explanation: The Organization does not draw for indirect administrative expenses and has not elected to use the 10% de minimus cost rate.. The consolidated financial statements include RS EDEN and the Organizations wholly owned subsidiaries: Ashland Apartments LLC, Dillon Apartments LLC, RS EDEN St. Paul Community Housing LLC, Emanuel Housing GP LLC, RS EDEN Portland Village LLC, RS EDEN Central Apartments LLC, RS EDEN Jackson Street Village LLC, RS EDEN Lindquist Apartments LLC, RS Eden Campus LLC, and RS EDEN Amber Apartments LLC; as well as six limited partnerships: Amber Apartments Limited Partnership, Portland Village Limited Partnership, Central Avenue Limited Partnership, Saint Paul Family Project Limited Partnership, Lindquist Apartments Limited Partnership, and Emanuel Housing Limited Partnership. All material inter-company transactions have been eliminated.

Finding Details

2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-001 Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.33(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statues, regulations, and conditions of the federal award. The Organization is required to submit an accurate report to HHS for each filing period of funds were received. Condition: The Organization erroneously reported $226,571 in expenses on the Period 4 Department of Health and Human Services special report. Cause: The Organization did not have an internal control process in place to ensure the reporting portal input fields for expenses was accurate. Effect: While the calculation error provided a difference between the lost revenues on the HHS special report and the lost revenue calculation, the Organization had excess lost revenues available to be applied. This reporting error also indicated there is a lack of policies governing the review and approval of the HHS special report. Questioned Costs: None reported. The Organization had excess lost revenues available to be applied. Context: Key line items were tested on the Period 4 Department of Health and Human Services special report. The HHS special reports included total expense errors of $226,571. The Organization had excess lost revenues from the Period 4 HHS reports that totaled $2,362,453. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all reports to HHS are reviewed and approved prior to submission to ensure accuracy of the reports and meet the requirements of the federal program . Views of Responsible Officials: Management agrees with the finding.
2022-002 Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization?s calculation of lost revenue claimed under the federal program as an allowable cost was not subjected to formal review or approval by a separate individual outside of the preparer. Cause: The Organization did not have an adequate internal control policy to ensure review and approval of the lost revenue calculation claimed under the federal program was documented in accordance with guidance. Effect: The lack of adequate policies governing review and approval increases the risk that employees participating in the federal award administration may not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. Context: The lost revenue calculation for all applicable quarters was tested. Repeat Finding from Prior Years: No Recommendation: We recommend the Organization implement a control process which includes a secondary review and documented approval of the lost revenue calculation under the federal program. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.
2022-004 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Period of Performance Significant Deficiency in Internal Control over Compliance and Other Noncompliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization claimed a portion of expenses that benefited the period outside of the period of performance, which was November 1, 2021, to October 31, 2023. During our testing, there was no documentation of review and approval of expenses for a portion of the sample selected. Cause: The Organization did not have an internal control process in place to ensure that allowable expenses excluded costs incurred prior to the period of performance. Effect: The Organization incorrectly submitted allowable expenses to the grant outside of the grant period of performance. Questioned Costs: There were no questioned costs in excess of $25,000 required to be reported. A nonstatistical sample of 60 ($21,300) out of 1,240 direct program expenditures were tested for period of performance. Of these 60 items, there was an error in one of the expenditures tested relating to $335 of costs benefiting 2021 and this error was determined to be isolated in nature. Of these 60, 45 did not show evidence of proper review and approval prior to payment. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all allowable expenses submitted under the grant are reviewed and approved prior to payment in order to make sure it is in the correct period of performance. Views of Responsible Officials: Management agrees with the finding.
2022-001 Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Reporting Material Weakness in Internal Control over Compliance and Material Noncompliance Criteria: 2 CFR 200.33(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statues, regulations, and conditions of the federal award. The Organization is required to submit an accurate report to HHS for each filing period of funds were received. Condition: The Organization erroneously reported $226,571 in expenses on the Period 4 Department of Health and Human Services special report. Cause: The Organization did not have an internal control process in place to ensure the reporting portal input fields for expenses was accurate. Effect: While the calculation error provided a difference between the lost revenues on the HHS special report and the lost revenue calculation, the Organization had excess lost revenues available to be applied. This reporting error also indicated there is a lack of policies governing the review and approval of the HHS special report. Questioned Costs: None reported. The Organization had excess lost revenues available to be applied. Context: Key line items were tested on the Period 4 Department of Health and Human Services special report. The HHS special reports included total expense errors of $226,571. The Organization had excess lost revenues from the Period 4 HHS reports that totaled $2,362,453. Repeat Finding from Prior Years: No Recommendation: We recommend that the Organization enhance internal control policies to ensure all reports to HHS are reviewed and approved prior to submission to ensure accuracy of the reports and meet the requirements of the federal program . Views of Responsible Officials: Management agrees with the finding.
2022-002 Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Activities Allowed or Unallowed and Allowable Costs/Cost Principles Significant Deficiency in Internal Control over Compliance Criteria: 2 CFR 200.303(a) establishes that the auditee must establish and maintain effective internal control over the federal award that provides assurance that the entity is managing the federal award in compliance with federal statutes, regulations, and conditions of the federal award. Condition: The Organization?s calculation of lost revenue claimed under the federal program as an allowable cost was not subjected to formal review or approval by a separate individual outside of the preparer. Cause: The Organization did not have an adequate internal control policy to ensure review and approval of the lost revenue calculation claimed under the federal program was documented in accordance with guidance. Effect: The lack of adequate policies governing review and approval increases the risk that employees participating in the federal award administration may not be able to detect and correct noncompliance in a timely manner. Questioned Costs: None reported. Context: The lost revenue calculation for all applicable quarters was tested. Repeat Finding from Prior Years: No Recommendation: We recommend the Organization implement a control process which includes a secondary review and documented approval of the lost revenue calculation under the federal program. Views of Responsible Officials: Management agrees with the finding.
2022-003 Department of Housing and Urban Development Federal Assistance Listing #14.267 Continuum of Care Program Department of Health and Human Services Federal Assistance Listing #93.498 COVID-19 Provider Relief Fund (PRF) and American Rescue Plan (ARP) Rural Distribution Applicable Federal Award Number and Year ? Period 4 TIN #411948604 Preparation of Consolidated Schedule of Expenditures of Federal Awards Significant Deficiency in Internal Control over Compliance Criteria: Proper controls over financial reporting include the ability to prepare the consolidated schedule of expenditures of federal awards (consolidated schedule) and accompanying notes to the consolidated schedule. Condition: The Organization does not have an internal control system designed to provide for a complete and accurate consolidated schedule of expenditures of federal awards being audited. Cause: Auditor assistance with preparation of the consolidated schedule is not unusual as the consolidated schedule is only required when the Organization meets a specified threshold of federal expenditures. Effect: There is a reasonable possibility that the Organization would not be able to draft a consolidated schedule that is correct without the assistance of the auditors. Questioned Costs: None reported. Context: Sampling was not used. Repeat Finding from Prior Years: No Recommendation: We recommend management be aware of the financial reporting requirements relating to the Organization?s consolidated schedule of expenditures of federal awards and the internal controls that impact financial reporting. Views of Responsible Officials: Management agrees with the finding.