Audit 293716

FY End
2022-12-31
Total Expended
$2.26M
Findings
4
Programs
5
Organization: Rimrock Foundation (MT)
Year: 2022 Accepted: 2024-03-06
Auditor: Eide Bailly LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
372639 2022-004 Material Weakness Yes ABHL
372640 2022-005 Material Weakness Yes I
949081 2022-004 Material Weakness Yes ABHL
949082 2022-005 Material Weakness Yes I

Contacts

Name Title Type
YQUPKGTL7HV7 Shirley Ehlang Auditee
4062483175 John Hauck Auditor
No contacts on file

Notes to SEFA

Title: Note 1 - Basis of Presentation Accounting Policies: Note 2 - Significant Accounting Policies Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, 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 assistance has been provided to a subrecipient. De Minimis Rate Used: Y Rate Explanation: Rimrock Foundation has elected to use the 10% de minimis cost rate. The accompanying schedule of expenditures of federal awards (the schedule) includes the federal award activity of Rimrock Foundation under programs of the federal government for the year ended December 31, 2022. The information 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 Rimrock Foundation, it is not intended to and does not present the financial position, changes in net assets, or cash flows of Rimrock Foundation.
Title: Note 2 - Significant Accounting Policies Accounting Policies: Note 2 - Significant Accounting Policies Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, 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 assistance has been provided to a subrecipient. De Minimis Rate Used: Y Rate Explanation: Rimrock Foundation has elected to use the 10% de minimis cost rate. Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, 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 assistance has been provided to a subrecipient.
Title: Note 3 - Indirect Cost Rate Accounting Policies: Note 2 - Significant Accounting Policies Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, 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 assistance has been provided to a subrecipient. De Minimis Rate Used: Y Rate Explanation: Rimrock Foundation has elected to use the 10% de minimis cost rate. Rimrock Foundation has elected to use the 10% de minimis cost rate.
Title: Note 4 - Provider Relief Funds Accounting Policies: Note 2 - Significant Accounting Policies Expenditures reported in the schedule are reported on the accrual basis of accounting. When applicable, 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 assistance has been provided to a subrecipient. De Minimis Rate Used: Y Rate Explanation: Rimrock Foundation has elected to use the 10% de minimis cost rate. Rimrock Foundation received $1,076,372 from the U.S. Department of Health and Human Services (HHS) through the Provider Relief Fund and American Rescue Plan (PRF) program (Federal Financial Assistance Listing #93.498) during the years ended December 31, 2021 and 2020. The PRF expenditures were not recognized on the schedule until the expenditures were included in the reporting to HHS for the funds received prior to June 30, 2020 for Period 1, prior to December 31, 2020 for Period 2, and prior to December 31, 2022 for Period 4, as required under the PRF program. Therefore, $606,492 was included in the 2021 schedule and $469,880 was included in the 2022 schedule. The following summarizes the Provider Relief Funds and the timing of when the amounts were recognized in the financial statements. See the Notes to the SEFA for chart/table. The amount of PRF expenditures included on the schedule requires management to make estimates and assumptions that affect the reported amounts. Accordingly, such expenditures are considered a significant estimate. Estimates and assumptions may include reducing actual expenses by amounts that have been reimbursed or are obligated to be reimbursed by other sources, estimating marginal increases in expenses related to coronavirus and the calculation of lost revenue. Actual results could differ from those estimates.

Finding Details

2022-004 – Department of Health and Human Services CFDA #93.829 Section 223 Demonstration Programs to Improve Community Health Services (CCBHC) Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance, and Reporting Material Weakness 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 – Rimrock Foundation’s final expenditures identified as eligible and claimed under the federal program were reviewed and approved by separate individuals outside of the preparer. However, the expense submissions for reimbursement had no evidence of review and approval by a separate individual outside of the preparer. Rimrock Foundation’s statistical reports submitted under the federal program had no evidence of review and approval by a separate individual outside of the preparer. Cause – Rimrock Foundation has multiple individuals identifying and compiling eligible costs and statistics, however, Rimrock Foundation did not have an internal control process in place to ensure evidence of a secondary review and approval of eligible expenditures and statistical data that were summarized from the underlying supporting spreadsheets to the final expenditure listing and the final statistical reports. The final expenditure listing was used to claim allowable costs under the federal program. The review and approval of the final expenditure listing and the statistical reports submitted to the Substance Abuse and Mental Health Services Administration was not performed by someone other than the preparer of the report. Effect – Without a secondary review and approval, there is a possibility that ineligible expenditures may be claimed under the program and the reports of statistical data may not be accurately completed. Questioned Costs – None reported. Context/Sampling – A nonstatistical sample of 60 expenditures was selected, from reports submitted to the Substance Abuse and Mental Health Services Administration, for testing of payroll, supplies, and equipment for activities allowed and unallowed and allowable costs/cost principles. The 20 statistical reports and forms submitted to the Substance Abuse and Mental Health Services Administration were all tested for internal controls and compliance. Repeat Finding from Prior Year – Yes. Recommendation – While we recognize that this condition is not unusual for an organization with limited staffing, it is important that Rimrock Foundation is aware of this condition for financial reporting purposes. Management and the board of directors should continually be aware of the financial accounting and reporting of Rimrock Foundation and any changes in the accounting and reporting requirements. We recommend a review and approval process which is documented in writing, by someone other than the preparer, of any reimbursement requests or any statistical reports submitted to the Substance Abuse and Mental Health Services Administration. Views of Responsible Officials – Management agrees with the finding.
2022-005 – Department of Health and Human Services CFDA #93.829 Section 223 Demonstration Programs to Improve Community Health Services (CCBHC) Procurement, Suspension and Debarment Material Weakness in Internal Control over Compliance Criteria – CFR 200.303 establishes that the entity must establish and maintain effective internal control over federal awards that provides reasonable assurance that the entity is managing the federal award in compliance with federal statutes, regulations and terms and conditions of the federal award. In addition, 2 CFR 200.302(b)(6) establishes that the financial management system of the entity must provide written procedures to implement the requirements of 2 CFR 200.305 regarding procurement. The entity should also maintain effective internal controls to determine that payments of federal awards are not made to vendors who are suspended or debarred from federal contracts. Condition – Rimrock Foundation does not have formally documented written internal control procedures over compliance with federal award programs to meet the requirements noted above regarding compliance with federal regulations for procurement, suspension and debarment. Cause – Rimrock Foundation was not aware of certain requirements under 2 CFR 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements regarding procurement for federal awards and did not implement controls to review vendors for suspension or debarment. Effect – Inadequate documentation of controls over these compliance areas may result in a reasonable possibility that Rimrock Foundation may not be able to detect and correct noncompliance with federal regulations regarding the use of federal funds in a timely manner and could contract with a vendor who has been suspended and debarred from federal contracts. Questioned Costs – None reported Context/Sampling – A nonstatistical sample of 3 contracts was selected, from expenditures in the reports submitted to the Substance Abuse and Mental Health Services Administration, for testing of controls over procurement of contracts which use federal funds. None of the contracts were reviewed for compliance with federal regulations and none of the vendors were reviewed for suspension and debarment prior to submission. Repeat Finding from Prior Year – Yes. Recommendation –Rimrock Foundation should establish and maintain effective internal control over federal awards that provides reasonable assurance that it is managing all federal awards in compliance with federal statutes, regulations and terms and conditions of the federal award. In addition, 2 CFR 200.302(b)(6) establishes that the financial management system must provide written procedures to implement the requirements of 2 CFR 200.305 regarding procurement. As part of those controls, Rimrock Foundation should also determine that payments of federal awards are not made to vendors who are suspended or debarred from federal contracts. Views of Responsible Officials – Management agrees with the finding.
2022-004 – Department of Health and Human Services CFDA #93.829 Section 223 Demonstration Programs to Improve Community Health Services (CCBHC) Activities Allowed or Unallowed, Allowable Costs/Cost Principles, Period of Performance, and Reporting Material Weakness 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 – Rimrock Foundation’s final expenditures identified as eligible and claimed under the federal program were reviewed and approved by separate individuals outside of the preparer. However, the expense submissions for reimbursement had no evidence of review and approval by a separate individual outside of the preparer. Rimrock Foundation’s statistical reports submitted under the federal program had no evidence of review and approval by a separate individual outside of the preparer. Cause – Rimrock Foundation has multiple individuals identifying and compiling eligible costs and statistics, however, Rimrock Foundation did not have an internal control process in place to ensure evidence of a secondary review and approval of eligible expenditures and statistical data that were summarized from the underlying supporting spreadsheets to the final expenditure listing and the final statistical reports. The final expenditure listing was used to claim allowable costs under the federal program. The review and approval of the final expenditure listing and the statistical reports submitted to the Substance Abuse and Mental Health Services Administration was not performed by someone other than the preparer of the report. Effect – Without a secondary review and approval, there is a possibility that ineligible expenditures may be claimed under the program and the reports of statistical data may not be accurately completed. Questioned Costs – None reported. Context/Sampling – A nonstatistical sample of 60 expenditures was selected, from reports submitted to the Substance Abuse and Mental Health Services Administration, for testing of payroll, supplies, and equipment for activities allowed and unallowed and allowable costs/cost principles. The 20 statistical reports and forms submitted to the Substance Abuse and Mental Health Services Administration were all tested for internal controls and compliance. Repeat Finding from Prior Year – Yes. Recommendation – While we recognize that this condition is not unusual for an organization with limited staffing, it is important that Rimrock Foundation is aware of this condition for financial reporting purposes. Management and the board of directors should continually be aware of the financial accounting and reporting of Rimrock Foundation and any changes in the accounting and reporting requirements. We recommend a review and approval process which is documented in writing, by someone other than the preparer, of any reimbursement requests or any statistical reports submitted to the Substance Abuse and Mental Health Services Administration. Views of Responsible Officials – Management agrees with the finding.
2022-005 – Department of Health and Human Services CFDA #93.829 Section 223 Demonstration Programs to Improve Community Health Services (CCBHC) Procurement, Suspension and Debarment Material Weakness in Internal Control over Compliance Criteria – CFR 200.303 establishes that the entity must establish and maintain effective internal control over federal awards that provides reasonable assurance that the entity is managing the federal award in compliance with federal statutes, regulations and terms and conditions of the federal award. In addition, 2 CFR 200.302(b)(6) establishes that the financial management system of the entity must provide written procedures to implement the requirements of 2 CFR 200.305 regarding procurement. The entity should also maintain effective internal controls to determine that payments of federal awards are not made to vendors who are suspended or debarred from federal contracts. Condition – Rimrock Foundation does not have formally documented written internal control procedures over compliance with federal award programs to meet the requirements noted above regarding compliance with federal regulations for procurement, suspension and debarment. Cause – Rimrock Foundation was not aware of certain requirements under 2 CFR 200 Uniform Administrative Requirements, Cost Principles, and Audit Requirements regarding procurement for federal awards and did not implement controls to review vendors for suspension or debarment. Effect – Inadequate documentation of controls over these compliance areas may result in a reasonable possibility that Rimrock Foundation may not be able to detect and correct noncompliance with federal regulations regarding the use of federal funds in a timely manner and could contract with a vendor who has been suspended and debarred from federal contracts. Questioned Costs – None reported Context/Sampling – A nonstatistical sample of 3 contracts was selected, from expenditures in the reports submitted to the Substance Abuse and Mental Health Services Administration, for testing of controls over procurement of contracts which use federal funds. None of the contracts were reviewed for compliance with federal regulations and none of the vendors were reviewed for suspension and debarment prior to submission. Repeat Finding from Prior Year – Yes. Recommendation –Rimrock Foundation should establish and maintain effective internal control over federal awards that provides reasonable assurance that it is managing all federal awards in compliance with federal statutes, regulations and terms and conditions of the federal award. In addition, 2 CFR 200.302(b)(6) establishes that the financial management system must provide written procedures to implement the requirements of 2 CFR 200.305 regarding procurement. As part of those controls, Rimrock Foundation should also determine that payments of federal awards are not made to vendors who are suspended or debarred from federal contracts. Views of Responsible Officials – Management agrees with the finding.