Finding 598254 (2022-004)

Significant Deficiency
Requirement
N
Questioned Costs
-
Year
2022
Accepted
2022-11-21
Audit: 20218
Organization: Beloit College (WI)
Auditor: Rsm US LLP

AI Summary

  • Core Issue: Eleven students had incorrect program begin dates reported to NSLDS due to software errors.
  • Impacted Requirements: This violates 2 CFR Part 200.303(a) and U.S. Department of Education guidelines, risking federal funding and compliance with academic progress policies.
  • Recommended Follow-Up: Implement regular reviews of program begin dates in the software and NSLDS against internal records to ensure accuracy.

Finding Text

Finding 2022-004: Special Tests and Provisions ? Enrollment Reporting: Program-Level Criteria: Per 2 CFR Part 200.303(a), an Institution must establish and maintain effective internal control over the federal awards that provides reasonable assurance that the auditee is managing the federal award in compliance with federal statues, regulations, and terms and conditions of the federal award. Specific criteria for accurate program begin date enrollment reporting is established by the U.S. Department of Education within the NSLDS Enrollment Reporting Guide Chapter 4. Condition: Eleven students? program begin dates were not properly reported. Cause: Beloit College uses the National Student Clearinghouse?s enrollment roster to report enrollment information which is then shared with the National Student Loan Database System (NSLDS). The College utilizes a certain software system (the system) to aid in recording program and campus level enrollment status changes to be reported to NSLDS. The program begin date within the system automatically changes when any additions are made to major documentation within the software for all majors listed for the student. As such, when the Registrar exported data from the system to report to NSLDS the program begin dates were automatically and improperly changed and the incorrect Program Begin Date was reported to the NSLDS. Effect: Noncompliance with federal regulations could result in the loss of future federal financial aid funding. In addition, not reporting program begin dates properly could cause the improper determination of compliance with the College?s Satisfactory Academic Progress policy. Questioned Costs: None Context: Eleven out of 16 students tested from a population of 121 students with enrollment status changes were not reported with the accurate program begin date. Repeat finding: No Recommendation: We recommend that management consider implementing reviews of program begin dates within the software system and NSLDS and compare to internal major declaration records periodically. Views of Responsible Official: Management agrees with this finding. Please see corrective action plan attached.

Categories

Special Tests & Provisions Student Financial Aid Reporting Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

  • 21801 2022-002
    Significant Deficiency Repeat
  • 21802 2022-003
    Significant Deficiency
  • 21803 2022-004
    Significant Deficiency
  • 21804 2022-002
    Significant Deficiency Repeat
  • 21805 2022-003
    Significant Deficiency
  • 21806 2022-004
    Significant Deficiency
  • 21807 2022-002
    Significant Deficiency Repeat
  • 21808 2022-003
    Significant Deficiency
  • 21809 2022-004
    Significant Deficiency
  • 21810 2022-002
    Significant Deficiency Repeat
  • 21811 2022-003
    Significant Deficiency
  • 21812 2022-004
    Significant Deficiency
  • 598243 2022-002
    Significant Deficiency Repeat
  • 598244 2022-003
    Significant Deficiency
  • 598245 2022-004
    Significant Deficiency
  • 598246 2022-002
    Significant Deficiency Repeat
  • 598247 2022-003
    Significant Deficiency
  • 598248 2022-004
    Significant Deficiency
  • 598249 2022-002
    Significant Deficiency Repeat
  • 598250 2022-003
    Significant Deficiency
  • 598251 2022-004
    Significant Deficiency
  • 598252 2022-002
    Significant Deficiency Repeat
  • 598253 2022-003
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $3.91M
84.063 Federal Pell Grant Program $1.48M
84.425 Education Stabilization Fund $1.36M
84.038 Federal Perkins Loan Program - Loans Outstanding at the Beginning of the Year $1.08M
84.047 Trio_upward Bound $437,973
84.042 Trio_student Support Services $367,881
84.217 Trio_mcnair Post-Baccalaureate Achievement $323,839
84.033 Federal Work-Study Program $208,237
84.007 Federal Supplemental Educational Opportunity Grants $175,810
15.922 Native American Graves Protection and Repatriation Act $76,813
10.500 Cooperative Extension Service $12,791
47.076 Education and Human Resources $7,508
45.301 Museums for America $265
47.050 Geosciences $168