Finding 1205062 (2025-007)

Material Weakness Repeat Finding
Requirement
N
Questioned Costs
-
Year
2025
Accepted
2026-03-31

AI Summary

  • Core Issue: Financial Aid Coordinators made manual errors in calculating the number of clock hours students were scheduled to attend, impacting the Return of Title IV (R2T4) process.
  • Impacted Requirements: Compliance with 34 CFR § 668.22, which mandates accurate calculations for determining earned aid and post-withdrawal disbursement eligibility.
  • Recommended Follow-Up: Implement a secondary review process, provide targeted training on compliance requirements, and use standardized calculation tools to minimize manual errors.

Finding Text

Special Tests and Provisions Federal Agency: U.S. Department of Education Federal Program Name: Student Financial Aid Cluster Assistance Listing Number: 84.063 Federal Award Identification Number and Year: N/A Award Period: July 1, 2024 – June 30, 2025 Type of Finding: Significant Deficiency in Internal Control over Compliance; Noncompliance (Other Matters) Criteria or specific requirement: The Code of Federal Regulations, 34 CFR § 668.22, requires institutions administering Title IV funds to calculate Return of Title IV (R2T4) amounts using the correct number of clock hours a student was scheduled to attend as of the withdrawal date. Accurate use of scheduled hours is essential to determining the proper percentage of Title IV aid earned, the amount to be returned, and any post‑withdrawal disbursement eligibility. Condition: Financial Aid Coordinators made manual errors when determining the number of clock hours students were scheduled to complete as of their withdrawal dates. These miscalculations directly affected the accuracy of the R2T4 process, resulting in incorrect determinations of earned aid and improper calculation of post‑withdrawal disbursement amounts. In several cases, these human errors caused students to be either over-awarded or under-awarded Title IV funds. Questioned costs: $396 CLA extrapolated the questioned costs and determined this is not a material weakness that would result in a material misstatement in the F/S. Context: CLA determined that the District miscalculated scheduled clock hours for three students in the R2T4 process. Cause: Financial Aid Coordinators made manual errors when determining the number of clock hours students were scheduled to complete as of their withdrawal dates. Effect: As a result of these manual miscalculations, R2T4 determinations did not accurately reflect the amount of Title IV aid students had earned at the time of withdrawal. This led to improper post‑withdrawal disbursements, with some students receiving more aid than they were entitled to and others receiving less. Repeat Finding: No Recommendation: It is recommended that the District strengthen its internal controls over the R2T4 calculation process by implementing a secondary review or quality‑assurance check of scheduled clock hours prior to finalizing R2T4 calculations. Staff should receive targeted training on the requirements of 34 CFR § 668.22, particularly regarding the use of scheduled hours in determining earned aid and post‑withdrawal disbursement eligibility. Additionally, standardized calculation worksheets or system‑generated hour reports should be utilized to reduce reliance on manual entry and minimize the risk of human error. Views of responsible officials: There is no disagreement with the audit finding.

Corrective Action Plan

Special Tests and Provisions Recommendation: It is recommended that the District strengthen its internal controls over the R2T4 calculation process by implementing a secondary review or quality-assurance check of scheduled clock hours prior to finalizing R2T4 calculations. Staff should receive targeted training on the requirements of 34 CFR § 668.22, particularly regarding the use of scheduled hours in determining earned aid and post-withdrawal disbursement eligibility. Additionally, standardized calculation worksheets or system-generated hour reports should be utilized to reduce reliance on manual entry and minimize the risk of human error. Explanation of disagreement with audit finding: There is no disagreement with the audit finding. Actions planned in response to finding: Financial Aid Coordinators from both technical colleges will collaborate to review and audit each other's RT24 calculations to ensure accuracy, accountability, and compliance with regulatory requirements. Responsible party: Financial Aid Coordinator Planned completion date for corrective action plan: April 1, 2026 Plan to monitor completion of corrective action plan: Monthly meetings with the Workforce Finance Department will be held to review RT24 calculations, address discrepancies, and confirm ongoing compliance.

Categories

Special Tests & Provisions Student Financial Aid Eligibility Material Weakness Significant Deficiency Internal Control / Segregation of Duties

Other Findings in this Audit

  • 1205057 2025-002
    Material Weakness Repeat
  • 1205058 2025-003
    Material Weakness Repeat
  • 1205059 2025-004
    Material Weakness Repeat
  • 1205060 2025-005
    Material Weakness Repeat
  • 1205061 2025-006
    Material Weakness Repeat
  • 1205063 2025-008
    Material Weakness Repeat
  • 1205064 2025-009
    Material Weakness Repeat
  • 1205065 2025-010
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
10.555 NATIONAL SCHOOL LUNCH PROGRAM $56.56M
84.010 TITLE I GRANTS TO LOCAL EDUCATIONAL AGENCIES $54.79M
84.027 SPECIAL EDUCATION GRANTS TO STATES $32.98M
10.553 SCHOOL BREAKFAST PROGRAM $15.30M
93.600 HEAD START $10.53M
84.367 SUPPORTING EFFECTIVE INSTRUCTION STATE GRANTS (FORMERLY IMPROVING TEACHER QUALITY STATE GRANTS) $5.95M
84.424 STUDENT SUPPORT AND ACADEMIC ENRICHMENT PROGRAM $4.40M
84.063 FEDERAL PELL GRANT PROGRAM $3.27M
84.165 MAGNET SCHOOLS ASSISTANCE $2.63M
84.048 CAREER AND TECHNICAL EDUCATION -- BASIC GRANTS TO STATES $2.01M
84.365 ENGLISH LANGUAGE ACQUISITION STATE GRANTS $1.97M
84.002 ADULT EDUCATION - BASIC GRANTS TO STATES $1.69M
84.011 MIGRANT EDUCATION STATE GRANT PROGRAM $1.16M
12.U01 ARMY JUNIOR RESERVE OFFICERS TRAINING CORPS $1.14M
10.558 CHILD AND ADULT CARE FOOD PROGRAM $923,921
10.559 SUMMER FOOD SERVICE PROGRAM FOR CHILDREN $623,396
84.173 SPECIAL EDUCATION PRESCHOOL GRANTS $484,444
17.264 NATIONAL FARMWORKER JOBS PROGRAM $311,815
84.425 EDUCATION STABILIZATION FUND $276,635
84.196 EDUCATION FOR HOMELESS CHILDREN AND YOUTH $213,228
12.U03 AIR FORCE JUNIOR RESERVE OFFICERS TRAINING CORPS $115,714
21.019 CORONAVIRUS RELIEF FUND $85,491
12.U02 MARINE CORPS JUNIOR RESERVE OFFICERS TRAINING CORPS $81,921
84.184 SCHOOL SAFELY NATIONAL ACTIVITIES $74,944
12.U04 NAVY JUNIOR RESERVE OFFICERS TRAINING CORPS $64,147
84.282 CHARTER SCHOOLS $21,752