Finding 573354 (2024-009)

Material Weakness
Requirement
N
Questioned Costs
$1
Year
2024
Accepted
2025-08-12
Audit: 364132
Organization: Leech Lake Tribal College (AZ)
Auditor: Redw

AI Summary

  • Core Issue: The College failed to accurately calculate the amount of Title IV funds earned by students who withdrew, leading to incorrect returns of funds.
  • Impacted Requirements: Compliance with 34 CFR Section 668.22 regarding the calculation of aid earned and timely reporting of student attendance.
  • Recommended Follow-Up: Ensure proper training on fund calculation and timely submission of attendance forms to prevent future discrepancies.

Finding Text

2024-009 — Return of Title IV Funds (Special Test #5)– Material Weakness in Internal Control Over Compliance and Noncompliance Federal program information: Funding agencies: U.S. Department of Education Titles: SFA Cluster-Federal PELL Grant Program ALN Number: 84.063 Award years: Various Criteria: According to 34 CFR Section 668.22(a)(1) through (a)(5), when a recipient of Title IV grant (PELL grants) withdraws from an institution during a payment period or period of enrollment in with the recipient began attendance, the institution must determine the amount of aid earned by the student as of the student’s withdrawal date. If the total amount of assistance earned by the student is less than the amount disbursed to the student, the difference must be returned to the Title IV program as outlined in the requirements. Condition: The College uses credit hours for measurement of the program as such, the amount of aid earned by the student is required to be determined by dividing the total number of calendar days in the enrollment period into the number of days completed in that period as of the student’s withdrawal date. The College was determining the amount of funds earned by the amount of credit hours the student was still enrolled in. Additionally, the timing of the withdrawals was incorrect in the calculations. Cause: The College was unaware of the percentage earned calculation and forms were not being submitted timely to the financial aid office to indicate student attendance. Effect: Return of funds were incorrectly calculated resulting in over and underpayments to students. Questioned Costs: $40,368 Context: The College did not properly calculate and return Title IV funds for students who withdrew. Recommendation: The College should comply with grant requirements for calculation of determining funds earned and those that need to be returned. Management’s Response: The College will return unearned Pell grant funds and properly determine unearned scholarship awards.

Corrective Action Plan

The Department will enforce policies and procedures to ensure that compliance with the requirements. New internal controls are expected to be implemented to address these findings.

Categories

Questioned Costs Student Financial Aid Material Weakness Internal Control / Segregation of Duties

Other Findings in this Audit

  • 573328 2024-002
    Material Weakness Repeat
  • 573329 2024-002
    Material Weakness Repeat
  • 573330 2024-002
    Material Weakness Repeat
  • 573331 2024-002
    Material Weakness Repeat
  • 573332 2024-002
    Material Weakness Repeat
  • 573333 2024-002
    Material Weakness Repeat
  • 573334 2024-003
    Material Weakness Repeat
  • 573335 2024-003
    Material Weakness Repeat
  • 573336 2024-003
    Material Weakness Repeat
  • 573337 2024-003
    Material Weakness Repeat
  • 573338 2024-003
    Material Weakness Repeat
  • 573339 2024-003
    Material Weakness Repeat
  • 573340 2024-004
    Significant Deficiency
  • 573341 2024-004
    Significant Deficiency
  • 573342 2024-005
    Material Weakness Repeat
  • 573343 2024-005
    Material Weakness Repeat
  • 573344 2024-005
    Material Weakness Repeat
  • 573345 2024-005
    Material Weakness Repeat
  • 573346 2024-005
    Material Weakness Repeat
  • 573347 2024-006
    Significant Deficiency Repeat
  • 573348 2024-006
    Significant Deficiency Repeat
  • 573349 2024-006
    Significant Deficiency Repeat
  • 573350 2024-006
    Significant Deficiency Repeat
  • 573351 2024-006
    Significant Deficiency Repeat
  • 573352 2024-007
    Significant Deficiency
  • 573353 2024-008
    Material Weakness
  • 573355 2024-010
    Material Weakness
  • 573356 2024-011
    Material Weakness
  • 573357 2024-012
    Significant Deficiency
  • 573358 2024-012
    Significant Deficiency
  • 573359 2024-012
    Significant Deficiency
  • 573360 2024-012
    Significant Deficiency
  • 1149770 2024-002
    Material Weakness Repeat
  • 1149771 2024-002
    Material Weakness Repeat
  • 1149772 2024-002
    Material Weakness Repeat
  • 1149773 2024-002
    Material Weakness Repeat
  • 1149774 2024-002
    Material Weakness Repeat
  • 1149775 2024-002
    Material Weakness Repeat
  • 1149776 2024-003
    Material Weakness Repeat
  • 1149777 2024-003
    Material Weakness Repeat
  • 1149778 2024-003
    Material Weakness Repeat
  • 1149779 2024-003
    Material Weakness Repeat
  • 1149780 2024-003
    Material Weakness Repeat
  • 1149781 2024-003
    Material Weakness Repeat
  • 1149782 2024-004
    Significant Deficiency
  • 1149783 2024-004
    Significant Deficiency
  • 1149784 2024-005
    Material Weakness Repeat
  • 1149785 2024-005
    Material Weakness Repeat
  • 1149786 2024-005
    Material Weakness Repeat
  • 1149787 2024-005
    Material Weakness Repeat
  • 1149788 2024-005
    Material Weakness Repeat
  • 1149789 2024-006
    Significant Deficiency Repeat
  • 1149790 2024-006
    Significant Deficiency Repeat
  • 1149791 2024-006
    Significant Deficiency Repeat
  • 1149792 2024-006
    Significant Deficiency Repeat
  • 1149793 2024-006
    Significant Deficiency Repeat
  • 1149794 2024-007
    Significant Deficiency
  • 1149795 2024-008
    Material Weakness
  • 1149796 2024-009
    Material Weakness
  • 1149797 2024-010
    Material Weakness
  • 1149798 2024-011
    Material Weakness
  • 1149799 2024-012
    Significant Deficiency
  • 1149800 2024-012
    Significant Deficiency
  • 1149801 2024-012
    Significant Deficiency
  • 1149802 2024-012
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.425 Covid 19-Education Stabilization Fund $2.13M
84.063 Federal Pell Grant Program $864,525
84.031 Higher Education Institutional Aid $687,251
10.237 From Learning to Leading: Cultivating the Next Generation of Diverse Food and Agriculture Professionals $565,030
15.027 Assistance to Tribally Controlled Community Colleges and Universities $354,431
10.222 Tribal Colleges Endowment Program $191,617
10.221 Tribal Colleges Education Equity Grants $178,273
10.500 Cooperative Extension Service $156,521
10.202 Cooperative Forestry Research $116,495
10.766 Community Facilities Loans and Grants $96,941
43.008 Office of Stem Engagement (ostem) $3,829
47.076 Stem Education (formerly Education and Human Resources) $214