Audit 342535

FY End
2023-12-31
Total Expended
$10.78M
Findings
2
Programs
31
Year: 2023 Accepted: 2025-02-14

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
523284 2023-006 Significant Deficiency - L
1099726 2023-006 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
93.210 Tribal Self-Governance Program: Ihs Compacts/funding Agreements $2.93M - 0
21.027 Coronavirus State and Local Fiscal Recovery Funds $2.88M Yes 1
15.022 Tribal Self-Governance $2.36M Yes 0
20.205 Highway Planning and Construction $502,640 - 0
66.605 Performance Partnership Grants $235,278 - 0
15.141 Indian Housing Assistance $150,811 - 0
93.445 Indian Health Service Sanitation Facilities Construction Program $127,800 - 0
21.026 Homeowner Assistance Fund $91,674 - 0
16.587 Violence Against Women Discretionary Grants for Indian Tribal Governments $82,959 - 0
66.038 Training, Investigations, and Special Purpose Activities of Federally-Recognized Indian Tribes Consistent with the Clean Air Act (caa), Tribal Sovereignty and the Protection and Management of Air Quality $59,950 - 0
14.867 Indian Housing Block Grants $45,721 - 0
93.047 Special Programs for the Aging, Title Vi, Part A, Grants to Indian Tribes, Part B, Grants to Native Hawaiians $42,957 - 0
21.032 Local Assistance and Tribal Consistency Fund $38,211 - 0
66.034 Surveys, Studies, Research, Investigations, Demonstrations, and Special Purpose Activities Relating to the Clean Air Act $33,500 - 0
15.148 Tribal Energy Development Capacity Grants $33,140 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $32,364 - 0
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $31,855 - 0
16.575 Crime Victim Assistance $27,116 - 0
10.567 Food Distribution Program on Indian Reservations $21,600 - 0
93.958 Block Grants for Community Mental Health Services $19,125 - 0
93.445 Marylee Allen Promoting Safe and Stable Families Program $12,007 - 0
10.914 Wildlife Habitat Incentive Program $7,918 - 0
10.594 Food Distribution Program on Indian Reservations Nutrition Education Grants $7,039 - 0
93.053 Nutrition Services Incentive Program $5,105 - 0
93.499 Low Income Household Water Assistance Program $5,000 - 0
16.025 Special Domestic Violence Criminal Jurisdiction Implementation $4,547 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $4,457 - 0
93.568 Low-Income Home Energy Assistance $2,869 - 0
93.556 Marylee Allen Promoting Safe and Stable Families Program $1,172 - 0
93.600 Head Start $1,162 - 0
93.441 Indian Self-Determination $-35,612 - 0

Contacts

Name Title Type
K8EFN11DHKH3 Angela Rabb Auditee
2313956868 Doug Deeter Auditor
No contacts on file

Notes to SEFA

Title: MISSING PASS-THROUGH ENTITY INFORMATION Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of the Little River Band of Ottawa Indians (the “Tribe"), under programs of the federal government for the year ended December 31, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Tribe, it is not intended to and does not present the financial position, changes in net position or cash flows of the Tribe. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the Tribe's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the Tribe has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. Some pass-through agencies did not provide pass-through grantor identifications numbers these are identified on the schedule as "-n/a-".
Title: RECONCILIATION OF THE SCHEDULE OF EXPENDITURES OF FEDERAL AWARDS Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of the Little River Band of Ottawa Indians (the “Tribe"), under programs of the federal government for the year ended December 31, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Tribe, it is not intended to and does not present the financial position, changes in net position or cash flows of the Tribe. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the Tribe's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the Tribe has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. Intergovernmental revenue reported in the statement of revenues, expenditures and changes in fund balance consist of the following: Federal revenues as reported in the financial statements $10,784,629 less use of Contracts and Grants fund balance $625,038, equaling Total intergovernmental revenue $10,159,591
Title: PASS THROUGH AGENCIES Accounting Policies: The accompanying schedule of expenditures of federal awards (the "Schedule") includes the federal grant activity of the Little River Band of Ottawa Indians (the “Tribe"), under programs of the federal government for the year ended December 31, 2023. The information in this Schedule is presented in accordance with the requirements of Title 2 U.S. Code of Federal Regulations Part 200, Uniform Administrative Requirements, Cost Principles, and Audit Requirements for Federal Awards (Uniform Guidance). Because the Schedule presents only a selected portion of the operations of the Tribe, it is not intended to and does not present the financial position, changes in net position or cash flows of the Tribe. Expenditures reported on the Schedule are reported on the accrual basis of accounting, which is described in Note 1 to the Tribe's financial statements. Such expenditures are recognized following the cost principles contained in the Uniform Guidance or other applicable 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. Pass-through entity identifying numbers are presented where available. De Minimis Rate Used: N Rate Explanation: For purposes of charging indirect costs to federal awards, the Tribe has not elected to use the 10 percent de minimis cost rate as permitted by §200.414 of the Uniform Guidance. The Tribe receives certain federal grants as subawards from non-federal entities. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: "See the Notes to SEFA for chart/table"

Finding Details

2023-006 – Variance in Quarterly Reporting Finding Type. Immaterial Noncompliance (Reporting)/Significant Deficiency in Internal Control over Compliance. Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027. Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported on certain quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2023. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the Tribe did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the Tribe reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. View of Responsible Officials. Management concurs with this finding. The identified variances have been corrected in subsequent reporting periods during both 2023 and 2024.
2023-006 – Variance in Quarterly Reporting Finding Type. Immaterial Noncompliance (Reporting)/Significant Deficiency in Internal Control over Compliance. Program. Coronavirus State and Local Fiscal Recovery Funds (CSLFRF); U.S. Department of Treasury; ALN 21.027. Criteria. CSLFRF grant recipients are required to file quarterly Project and Expenditure ("P&E") reports that include period-to-date and cumulative expenditures. Condition. During our audit, we noted a variance between amounts reported on certain quarterly P&E reports and amounts recorded in the general ledger and presented on the schedule of expenditures of federal awards (SEFA) for fiscal year 2023. Cause. This condition was caused by management not appropriately tracking project expenditures in sufficient detail on the general ledger to allow for reconciliation to the underlying accounting records and each quarterly P&E report. Effect. As a result of this condition, the Tribe did not fully comply with the requirements of the grant award or the Uniform Guidance. Questioned Costs. No costs have been questioned as a result of this finding, inasmuch as the reporting was deemed to be inaccurate, not the financial records. Recommendation. We recommend that the Tribe reconcile quarterly P&E reporting with amounts in the general ledger to ensure that all expenditures reported are classified in the correct project category on the P&E reporting and in the correct reporting period. View of Responsible Officials. Management concurs with this finding. The identified variances have been corrected in subsequent reporting periods during both 2023 and 2024.