Audit 318771

FY End
2023-12-31
Total Expended
$87.30M
Findings
2
Programs
60
Year: 2023 Accepted: 2024-09-09

Organization Exclusion Status:

Checking exclusion status...

Findings

ID Ref Severity Repeat Requirement
486132 2023-002 Significant Deficiency - L
1062574 2023-002 Significant Deficiency - L

Programs

ALN Program Spent Major Findings
21.027 Coronavirus State and Local Fiscal Recovery Funds $26.58M Yes 1
15.042 Indian School Equalization Program $720,209 - 0
15.047 Indian Education Facilities, Operations, and Maintenance $467,529 - 0
93.788 Opioid Str $363,943 - 0
84.010 Title I Grants to Local Educational Agencies $317,326 - 0
15.046 Administrative Cost Grants for Indian Schools $274,859 - 0
93.210 Tribal Self-Governance Program: Ihs Compacts/funding Agreements $229,663 Yes 0
66.605 Performance Partnership Grants $229,252 - 0
16.710 Public Safety Partnership and Community Policing Grants $212,147 - 0
93.441 Indian Self-Determination $210,589 - 0
84.425 Education Stabilization Fund $189,775 - 0
15.062 Replacement and Repair of Indian Schools $189,612 - 0
93.237 Special Diabetes Program for Indians_diabetes Prevention and Treatment Projects $173,432 - 0
21.029 Coronavirus Capital Projects Fund Program $161,686 - 0
15.044 Indian Schools_student Transportation $132,351 - 0
16.575 Crime Victim Assistance $123,053 - 0
93.665 Emergency Grants to Address Mental and Substance Use Disorders During Covid-19 $111,550 - 0
10.558 Child and Adult Care Food Program $108,331 - 0
93.762 A Comprehensive Approach to Good Health and Wellness in Indian County Ð Financed Solely by Prevention and Public Health $94,084 - 0
15.022 Tribal Self-Governance $85,643 Yes 0
16.587 Violence Against Women Discretionary Grants for Indian Tribal Governments $84,710 - 0
16.841 Voca Tribal Victim Services Set-Aside Program $82,096 - 0
93.594 Tribal Work Grants $81,205 - 0
16.608 Tribal Court Assistance Program $76,723 - 0
93.575 Child Care and Development Block Grant $75,592 Yes 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 $68,079 - 0
93.596 Child Care Mandatory and Matching Funds of the Child Care and Development Fund $66,878 Yes 0
93.558 Temporary Assistance for Needy Families $56,969 - 0
84.336 Teacher Quality Partnership Grants $51,669 - 0
93.047 Special Programs for the Aging_title Vi, Part A, Grants to Indian Tribes_part B, Grants to Native Hawaiians $48,639 - 0
11.307 Economic Adjustment Assistance $46,574 - 0
15.151 Education Program Enhancements $44,151 - 0
97.067 Homeland Security Grant Program $43,626 - 0
93.645 Stephanie Tubbs Jones Child Welfare Services Program $43,611 - 0
93.568 Low-Income Home Energy Assistance $40,888 - 0
20.509 Formula Grants for Rural Areas and Tribal Transit Program $37,702 - 0
84.424 Student Support and Academic Enrichment Program $27,763 - 0
93.069 Public Health Emergency Preparedness $27,625 - 0
10.567 Food Distribution Program on Indian Reservations $25,315 - 0
10.912 Environmental Quality Incentives Program $23,228 - 0
15.662 Great Lakes Restoration $22,994 - 0
45.308 Native American/native Hawaiian Museum Services Program $22,973 - 0
93.600 Head Start $21,702 - 0
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $21,017 - 0
93.587 Promote the Survival and Continuing Vitality of Native American Languages $20,631 - 0
93.053 Nutrition Services Incentive Program $20,524 - 0
17.265 Native American Employment and Training $19,899 - 0
93.556 Promoting Safe and Stable Families $17,390 - 0
14.231 Emergency Solutions Grant Program $17,205 - 0
16.750 Support for Adam Walsh Act Implementation Grant Program $17,139 - 0
16.583 Children's Justice Act Partnerships for Indian Communities $13,695 - 0
84.181 Special Education-Grants for Infants and Families $12,502 - 0
84.027 Special Education_grants to States $10,342 - 0
66.419 Water Pollution Control State, Interstate, and Tribal Program Support $5,382 - 0
45.311 Native American and Native Hawaiian Library Services $4,378 - 0
93.044 Special Programs for the Aging_title Iii, Part B_grants for Supportive Services and Senior Centers $3,393 - 0
93.569 Community Services Block Grant $3,268 - 0
11.804 Mbda Business Center - American Indian and Alaska Native $2,210 - 0
93.497 Family Violence Prevention and Services/ Sexual Assault/rape Crisis Services and Supports $2,054 - 0
93.581 Improving the Capability of Indian Tribal Governments to Regulate Environmental Quality $1 - 0

Contacts

Name Title Type
PMNWBLLRNMM3 Robert Schulte Auditee
9066356050 Trina Ochs Auditor
No contacts on file

Notes to SEFA

Accounting Policies: NOTE A - BASIS OF PRESENTATION The accompanying Schedule of Expenditures of Federal Awards includes the Federal grant activity of the Sault Ste. Marie Tribe of Chippewa Indians, and is presented on the modified accrual basis of accounting. 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"). Therefore, some amounts presented in this schedule may differ from amounts presented in, or used in the preparation of, the basic financial statements. NOTE B - COST REPORTS Management has reported that expenditures in the Schedule of Expenditures of Federal Awards are equal to or derived from amounts reported in the annual or final cost reports. Unallowed differences, if any, have been disclosed to the auditor. NOTE C - FINANCIAL REPORTS The financial reports including claims for advances and reimbursements and amounts claimed or used for matching, are timely, complete, accurate and contain information that is supported by the books and records from which the basic financial statements have been prepared. NOTE D - PASS-THROUGH SUBAWARDS The Tribe receives certain federal grants as subawards from non-federal entities. The Pass-through Number represents the facility's provider I.D. number. Some of these numbers were either not available or not provided by state or local administering agencies for the program reported in the accompanying schedule. Pass-through entities, where applicable, have been identified in the Schedule with an abbreviation, defined as follows: Pass-through Agency Abbreviation Pass-through Agency Name MDE Michigan Department of Education MDHHS Michigan Department of Health and Human Services MSP Michigan State Police SOM State of Michigan UPAAA Upper Peninsula Area Agency on Aging NOTE E - INDIAN HEALTH SERVICE ("IHS") BUYBACKS FOR PURCHASED SERVICES Purchased services are reported in the schedule at the fair value of the services rendered. The estimated value of purchased services for the year ended December 31, 2023, totaled $558,472 for the IHS programs. NOTE F - FOOD DISTRIBUTION Non-monetary assistance is reported in the schedule at fair market value of the commodities received and disbursed. NOTE G - RELATED PARTIES Throughout the normal course of operations, various funds of the Tribe interact with fund transfers, sales, expenses and taxes. These transactions are approved as a part of the system of internal control. Specifically, the Tribe contracts a significant portion of its construction projects provided by Federal funds to Sault Tribe Construction, an internal service fund of the Tribe, and purchases of fixed assets from Gitchi Auto, Home and Recreation. Northern Travel, an internal service fund of the Tribe, controls travel accommodations, airfare, etc. for some programs. The Self Insurance Fund provides significant coverages recorded as Federal grant expenditures. The Tribal Centers, Building and Equipment Fund leases space to programs. NOTE H - DE-MINIMIS INDIRECT COST RATE The Tribe did not use the 10% de-minimis indirect cost rate under the Uniform Administrative Requirements. De Minimis Rate Used: N Rate Explanation: The Tribe did not use the 10% de-minimis indirect cost rate under the Uniform Administrative Requirements.

Finding Details

Finding Number 2023-002 Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Reporting Immaterial Noncompliance Criteria: In accordance with 2 CFR 200.328 and 31 CFR section 35.4(c) Reporting and requests for other information, grantees are required to file quarterly Project and Expenditure Reports listing significant projects, significant payments to subrecipients, subawards, and expenditure awards greater than $50,000. Condition: The Tribe incorrectly listed some project vendors as a subrecipients on the Project and Expenditure reports. Cause: Treasury guidance for reporting subrecipients versus contractors was in transition during the reporting periods for the year. Effect: The Tribe reported subrecipients on the Project and Expenditures Reports, but did not have any subrecipients of Coronavirus State and Local Fiscal Recovery Funds (SLFRF). Recommendation: Update reporting to ensure payments are reported as project vendors rather than subrecipients. Management's Response: Management recognizes that the error exists and has not been able to correct the report due to US Treasury’s portal not accepting prior period revisions. Treasury has changed its guidance on SLFRF multiple times over the past several years which has created an increased risk in filing errors for all reporting for these funds..
Finding Number 2023-002 Assistance Listing #21.027 Coronavirus State and Local Fiscal Recovery Funds (SLFRF) Reporting Immaterial Noncompliance Criteria: In accordance with 2 CFR 200.328 and 31 CFR section 35.4(c) Reporting and requests for other information, grantees are required to file quarterly Project and Expenditure Reports listing significant projects, significant payments to subrecipients, subawards, and expenditure awards greater than $50,000. Condition: The Tribe incorrectly listed some project vendors as a subrecipients on the Project and Expenditure reports. Cause: Treasury guidance for reporting subrecipients versus contractors was in transition during the reporting periods for the year. Effect: The Tribe reported subrecipients on the Project and Expenditures Reports, but did not have any subrecipients of Coronavirus State and Local Fiscal Recovery Funds (SLFRF). Recommendation: Update reporting to ensure payments are reported as project vendors rather than subrecipients. Management's Response: Management recognizes that the error exists and has not been able to correct the report due to US Treasury’s portal not accepting prior period revisions. Treasury has changed its guidance on SLFRF multiple times over the past several years which has created an increased risk in filing errors for all reporting for these funds..