Audit 10880

FY End
2021-12-31
Total Expended
$20.84M
Findings
6
Programs
29
Organization: Round Valley Indian Tribes (CA)
Year: 2021 Accepted: 2024-01-10
Auditor: Moss Adams LLP

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
8246 2021-005 Material Weakness Yes B
8247 2021-006 Material Weakness - L
8248 2021-007 Material Weakness - B
584688 2021-005 Material Weakness Yes B
584689 2021-006 Material Weakness - L
584690 2021-007 Material Weakness - B

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $12.80M Yes 1
21.019 Coronavirus Relief Fund $2.35M Yes 2
20.205 Highway Planning and Construction $1.06M - 0
15.035 Forestry on Indian Lands $788,908 - 0
93.210 Tribal Self-Governance Program: Ihs Compacts/funding Agreements $386,505 - 0
93.558 Temporary Assistance for Needy Families $339,753 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $286,027 - 0
93.600 Head Start $264,130 - 0
16.731 Tribal Youth Program $215,167 - 0
15.029 Tribal Courts $185,687 - 0
16.841 Voca Tribal Victim Services Set-Aside Program $158,315 - 0
15.144 Indian Child Welfare Act_title II Grants $136,468 - 0
16.583 Children's Justice Act Partnerships for Indian Communities $132,435 - 0
15.514 Reclamation States Emergency Drought Relief $97,989 - 0
93.575 Child Care and Development Block Grant $86,188 - 0
15.040 Real Estate Programs_indian Lands $79,368 - 0
15.904 Historic Preservation Fund Grants-in-Aid $75,153 - 0
15.021 Consolidated Tribal Government Program $59,508 - 0
10.558 Child and Adult Care Food Program $33,377 - 0
93.568 Low-Income Home Energy Assistance $28,375 - 0
66.419 Water Pollution Control State, Interstate, and Tribal Program Support $25,450 - 0
93.047 Special Programs for the Aging_title Vi, Part A, Grants to Indian Tribes_part B, Grants to Native Hawaiians $23,302 - 0
66.460 Nonpoint Source Implementation Grants $20,390 - 0
93.445 Indian Health Service Sanitation Facilities Construction Program $10,611 - 0
15.156 Cooperative Landscape Conservation $9,592 - 0
66.926 Indian Environmental General Assistance Program (gap) $5,633 - 0
16.587 Violence Against Women Discretionary Grants for Indian Tribal Governments $5,000 - 0
16.710 Public Safety Partnership and Community Policing Grants $4,570 - 0
15.160 Bia Wildland Urban Interface Community Fire Assistance $3,612 - 0

Contacts

Name Title Type
EB5GFFG3MVC5 James Russ Auditee
7073540322 Ryan Luetkemeyer Auditor
No contacts on file

Notes to SEFA

Title: Basis of Presentation Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years, when applicable. Pass-through entity identifying numbers are presented where available. The Tribes have elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Additionally, the Tribes did not have an approved indirect cost rate and charged indirect costs to programs that were allowed to be charged during the year-ended December 31, 2021. The Tribes did not provide any funds to sub-recipients during the year ended December 31, 2021. De Minimis Rate Used: N Rate Explanation: N/A The accompanying schedule of expenditures of federal awards and non-federal awards (the “Schedule”) includes the grant activity of the Grants Fund Department of the Round Valley Indian Tribes (the “Tribes”) under programs of the government for the year ended December 31, 2021. The information in this Schedule is presented in accordance with Title 2 Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Tribes, it is not intended to and does not present the financial position, changes in net position, or cash flows of the Tribes.
Title: Summary of Significant Accounting Policies Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years, when applicable. Pass-through entity identifying numbers are presented where available. The Tribes have elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Additionally, the Tribes did not have an approved indirect cost rate and charged indirect costs to programs that were allowed to be charged during the year-ended December 31, 2021. The Tribes did not provide any funds to sub-recipients during the year ended December 31, 2021. De Minimis Rate Used: N Rate Explanation: N/A Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years, when applicable. Pass-through entity identifying numbers are presented where available. The Tribes have elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Additionally, the Tribes did not have an approved indirect cost rate and charged indirect costs to programs that were allowed to be charged during the year-ended December 31, 2021. The Tribes did not provide any funds to sub-recipients during the year ended December 31, 2021.
Title: Reconciliation to the Financial Statements Accounting Policies: Expenditures reported on the Schedule are reported on the modified accrual basis of accounting. Such expenditures are recognized following the cost principles contained in the Uniform Guidance, wherein certain types of expenditures are not allowable or are limited as to reimbursement. Negative amounts shown on the Schedule represent adjustments or credits made in the normal course of business to amounts reported as expenditures in prior years, when applicable. Pass-through entity identifying numbers are presented where available. The Tribes have elected not to use the 10% de minimis indirect cost rate allowed under the Uniform Guidance. Additionally, the Tribes did not have an approved indirect cost rate and charged indirect costs to programs that were allowed to be charged during the year-ended December 31, 2021. The Tribes did not provide any funds to sub-recipients during the year ended December 31, 2021. De Minimis Rate Used: N Rate Explanation: N/A The following is a reconciliation of the expenditures reported on the Schedule to the expenditures reported in the financial statements for the grants fund. Expenditures from the schedule of expenditures of federal awards and non-federal awards $ 22,155,753 Expenditures funded by other sources, including program income 124,705 Expenditures funded through future non-federal sources 251,557 Total expenditures reported in the Grants Fund $ 22,532,015

Finding Details

Criteria: Coronavirus Aid, Relief, and Economic Security (CARES) Act, Pub. L. No. 116-36m Division A, Title V (2020) requires that the Coronavirus Relief Fund (CRF) monies must be used to cover costs that are: 1. Necessary expenditures incurred due to the public health emergency with respect to COVID-19; 2. Not accounted for in the governments' most recently approved budget as of March 27, 2020; and 3. Incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. Additionally, 2 CFR 200.303 requires the recipient of federal funds establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition/Context: We selected a statistically valid random sample of transactions charged to the program of 40 emergency assistance transactions and 12 general disbursement transactions to test controls of disbursement costs charged to the major program and found the following: - One general disbursement transaction was not supported with appropriate documentation. - Emergency Assistance transactions were for checks written in 2020 but inappropriately recorded in 2021. Cause: The primary factor that contributed to the deficiencies was the lack of sufficient controls implemented to appropriately review and monitor disbursement activity and ensure amounts were properly recorded in the general ledger. Effect: Disbursement transactions were being processed incorrectly. We were unable to obtain sufficient assurance over compliance, and the major program received a qualified opinion. Questioned Costs: Known and likely questioned costs did not exceed $25,000. Repeat finding: This finding is a repeat of finding 2020-005 from the prior year. Recommendation: In order to ensure disbursement transactions are properly reviewed, approved, and supporting documentation is maintained, we recommend the Tribes ensure controls over disbursement procedures are designed and operating effectively. Views of responsible officials and planned corrective action: The Tribes commit to a comprehensive corrective action plan, including a thorough review of document processes, implementing additional controls for disbursements transactions, ensuring proper documentation review in the future, enhancing controls over the timing of expenditure recognition, and providing additional training, to personnel involved in disbursement process.
Criteria: Per 2 CFR 200.303, the Tribes must "Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal Statutes, regulations, and the terms and conditions of the Federal Award." Condition/Context: We randomly selected four performance and special reports for testing and found that one of four performance and special reports were not prepared and filed with funding agency. Cause: The Tribes do not have a process in place to ensure reports are prepared and submitted to the funding agency. Effect: Required performance and special reports were not submitted. Questioned costs: There were no reportable instances of questioned costs. Repeat finding: This is not a repeated finding from the prior year. Recommendation: The Tribe should review the terms and conditions of all grant awards to ensure they have an understanding of all reporting requirements necessary under each grant. Additionally, the Tribe should implement policies and procedures to monitor reporting deadlines to ensure that reports are prepared and submitted as applicable. Views of responsible officials and planned corrective action: The Tribes will ensure compliance with future reporting requirements, such as review and enhancement of reporting procedures, personnel training, and monitoring and oversight by management.
Criteria: American Rescue Plan Act of 2021, Pub. L. No. 117-2, requires that the Coronavirus State and Local Fiscal Recovery Fund monies must be used to cover costs that are: 1. Support public health expenditures, by funding COVID-19 mitigation efforts, medical expenses, behavioral healthcare, and certain public health and safety staff; 2. Address negative economic impacts caused by the public health emergency, including economic harms to works, households, small business, impacted industries, and the public sector; 3. Replace lost public sector revenue to provide government services; recipients may use this funding to provide government services to the extent of the reduction in revenue experienced due to the pandemic; 4. Provide premium pay for essential works, offering additional support to those who have borne and will bear the greatest health risks because of their service in critical infrastructure sectors; and 5. Invest in water, sewer, and broadband infrastructure, making necessary investments to improve access to clean drinking water, support vital wastewater and stormwater infrastructure, and to expand access to broadband internet. Additionally, 2 CFR 200.303 requires the recipient of federal funds establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition/Context: We selected a statistically valid random sample of transactions charged to the program of 40 emergency assistance transactions to test controls of disbursement costs charged to the major program and found the following: - One emergency assistance disbursement transaction was not supported with appropriate documentation. - There were expenses in the amount of $3,717,000 recognized for the program as of December 31, 2021 related to checks for emergency assistance payments to individuals that did not complete an application indicating eligibility. An entry was recorded by the Tribes to appropriately adjust these expenses from as of December 31, 2021. Cause: The primary factor that contributed to the deficiencies was the lack of sufficient controls implemented to appropriately review and monitor disbursement activity and ensure amounts were properly recorded in the general ledger. Effect: Emergency assistance transactions were being processed incorrectly. We were unable to obtain sufficient assurance over compliance, and the major program received a qualified opinion. Questioned costs: We tested $120,000 emergency assistance transactions out of federal expenditures of $12,768,000. Known and likely questioned costs totaled $322,200. Repeat finding: This is not a repeat finding from the prior year. Recommendation: In order to ensure disbursement transactions are properly reviewed, approved, and supporting documentation, maintained, we recommend the Tribes ensure controls over disbursement procedures are designed and operating effectively. Views of responsible officials and planned corrective action: The Tribes will ensure compliance with future program allowable costs and allowable activities requirements, such as documentation review and enhanced controls to ensure accurate recognition of expenditures.
Criteria: Coronavirus Aid, Relief, and Economic Security (CARES) Act, Pub. L. No. 116-36m Division A, Title V (2020) requires that the Coronavirus Relief Fund (CRF) monies must be used to cover costs that are: 1. Necessary expenditures incurred due to the public health emergency with respect to COVID-19; 2. Not accounted for in the governments' most recently approved budget as of March 27, 2020; and 3. Incurred during the period that begins on March 1, 2020 and ends on December 31, 2021. Additionally, 2 CFR 200.303 requires the recipient of federal funds establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition/Context: We selected a statistically valid random sample of transactions charged to the program of 40 emergency assistance transactions and 12 general disbursement transactions to test controls of disbursement costs charged to the major program and found the following: - One general disbursement transaction was not supported with appropriate documentation. - Emergency Assistance transactions were for checks written in 2020 but inappropriately recorded in 2021. Cause: The primary factor that contributed to the deficiencies was the lack of sufficient controls implemented to appropriately review and monitor disbursement activity and ensure amounts were properly recorded in the general ledger. Effect: Disbursement transactions were being processed incorrectly. We were unable to obtain sufficient assurance over compliance, and the major program received a qualified opinion. Questioned Costs: Known and likely questioned costs did not exceed $25,000. Repeat finding: This finding is a repeat of finding 2020-005 from the prior year. Recommendation: In order to ensure disbursement transactions are properly reviewed, approved, and supporting documentation is maintained, we recommend the Tribes ensure controls over disbursement procedures are designed and operating effectively. Views of responsible officials and planned corrective action: The Tribes commit to a comprehensive corrective action plan, including a thorough review of document processes, implementing additional controls for disbursements transactions, ensuring proper documentation review in the future, enhancing controls over the timing of expenditure recognition, and providing additional training, to personnel involved in disbursement process.
Criteria: Per 2 CFR 200.303, the Tribes must "Establish and maintain effective internal control over the Federal award that provides reasonable assurance that the non-Federal entity is managing the Federal award in compliance with Federal Statutes, regulations, and the terms and conditions of the Federal Award." Condition/Context: We randomly selected four performance and special reports for testing and found that one of four performance and special reports were not prepared and filed with funding agency. Cause: The Tribes do not have a process in place to ensure reports are prepared and submitted to the funding agency. Effect: Required performance and special reports were not submitted. Questioned costs: There were no reportable instances of questioned costs. Repeat finding: This is not a repeated finding from the prior year. Recommendation: The Tribe should review the terms and conditions of all grant awards to ensure they have an understanding of all reporting requirements necessary under each grant. Additionally, the Tribe should implement policies and procedures to monitor reporting deadlines to ensure that reports are prepared and submitted as applicable. Views of responsible officials and planned corrective action: The Tribes will ensure compliance with future reporting requirements, such as review and enhancement of reporting procedures, personnel training, and monitoring and oversight by management.
Criteria: American Rescue Plan Act of 2021, Pub. L. No. 117-2, requires that the Coronavirus State and Local Fiscal Recovery Fund monies must be used to cover costs that are: 1. Support public health expenditures, by funding COVID-19 mitigation efforts, medical expenses, behavioral healthcare, and certain public health and safety staff; 2. Address negative economic impacts caused by the public health emergency, including economic harms to works, households, small business, impacted industries, and the public sector; 3. Replace lost public sector revenue to provide government services; recipients may use this funding to provide government services to the extent of the reduction in revenue experienced due to the pandemic; 4. Provide premium pay for essential works, offering additional support to those who have borne and will bear the greatest health risks because of their service in critical infrastructure sectors; and 5. Invest in water, sewer, and broadband infrastructure, making necessary investments to improve access to clean drinking water, support vital wastewater and stormwater infrastructure, and to expand access to broadband internet. Additionally, 2 CFR 200.303 requires the recipient of federal funds establish and maintain effective internal control over the federal award that provides reasonable assurance that the non-federal entity is managing the federal award in compliance with federal statutes, regulations, and the terms and conditions of the federal award. Condition/Context: We selected a statistically valid random sample of transactions charged to the program of 40 emergency assistance transactions to test controls of disbursement costs charged to the major program and found the following: - One emergency assistance disbursement transaction was not supported with appropriate documentation. - There were expenses in the amount of $3,717,000 recognized for the program as of December 31, 2021 related to checks for emergency assistance payments to individuals that did not complete an application indicating eligibility. An entry was recorded by the Tribes to appropriately adjust these expenses from as of December 31, 2021. Cause: The primary factor that contributed to the deficiencies was the lack of sufficient controls implemented to appropriately review and monitor disbursement activity and ensure amounts were properly recorded in the general ledger. Effect: Emergency assistance transactions were being processed incorrectly. We were unable to obtain sufficient assurance over compliance, and the major program received a qualified opinion. Questioned costs: We tested $120,000 emergency assistance transactions out of federal expenditures of $12,768,000. Known and likely questioned costs totaled $322,200. Repeat finding: This is not a repeat finding from the prior year. Recommendation: In order to ensure disbursement transactions are properly reviewed, approved, and supporting documentation, maintained, we recommend the Tribes ensure controls over disbursement procedures are designed and operating effectively. Views of responsible officials and planned corrective action: The Tribes will ensure compliance with future program allowable costs and allowable activities requirements, such as documentation review and enhanced controls to ensure accurate recognition of expenditures.