Finding 1081404 (2024-002)

Material Weakness Repeat Finding
Requirement
N
Questioned Costs
-
Year
2024
Accepted
2024-11-08
Audit: 327718
Organization: Clarkson College (NE)

AI Summary

  • Core Issue: The College lacks formal internal controls over compliance with federal financial aid requirements, leading to a material weakness.
  • Impacted Requirements: Key areas affected include monthly reconciliations, award packaging, R2T4 calculations, and timely reporting to federal entities.
  • Recommended Follow-Up: The College should enhance its procedures and documentation to establish effective controls and address inconsistencies throughout the academic year.

Finding Text

Federal Agency: U.S. Department of Education Federal Program Title: Student Financial Aid Assistance Listing Number: Student Financial Aid Cluster Award Period: July 1, 2023 to June 30, 2024 Type of Finding: Material Weakness in Internal Control Over Compliance Criteria or Specific Requirement: The 2 CFR section 200.303 requires that non-federal entities receiving federal awards establish and maintain internal control over the federal awards that provides reasonable assurance that the non-federal entity is managing the federal awards in compliance with federal statutes, regulations, and the terms and conditions of the federal awards. Condition: During our testing, we noted the College did not have a formal review of their monthly reconciliations related to Direct Loans, Pell, SEOG, FWS. Likewise, the College did not have a formal review of their award packaging during the 2023-24 academic year, R2T4 calculations, direct payment of FSA credit balances to students, return of excess credit refunds after 240 days, reporting of NSLDS enrollment to the clearinghouse, FISAP, and verification documents. Questioned Costs: None Context: The College did not have proper internal controls in place during the 2023-24 academic year to ensure compliance with federal statutes, regulations, and the terms and conditions of the federal award. Cause: The College's processes and controls were not formally documented during the year as they had limited personnel in the financial aid department in order to maintain proper segregation of duties. Effect: The College is not following the compliance with federal statutes, regulations, and the terms and conditions of the federal award. Repeat Finding: Yes, see finding 2023-002. Recommendation: We recommend the College review its procedures to ensure controls are in place to ensure to catch any inconsistencies that occur during the year. Views of responsible officials: There is no disagreement with the audit finding.

Categories

Student Financial Aid Matching / Level of Effort / Earmarking Material Weakness Reporting Internal Control / Segregation of Duties

Other Findings in this Audit

  • 504958 2024-001
    Material Weakness Repeat
  • 504959 2024-001
    Material Weakness Repeat
  • 504960 2024-001
    Material Weakness Repeat
  • 504961 2024-001
    Material Weakness Repeat
  • 504962 2024-002
    Material Weakness Repeat
  • 504963 2024-002
    Material Weakness Repeat
  • 504964 2024-002
    Material Weakness Repeat
  • 504965 2024-002
    Material Weakness Repeat
  • 504966 2024-003
    Significant Deficiency
  • 504967 2024-003
    Significant Deficiency
  • 504968 2024-003
    Significant Deficiency
  • 504969 2024-003
    Significant Deficiency
  • 504970 2024-004
    Significant Deficiency
  • 504971 2024-004
    Significant Deficiency
  • 504972 2024-004
    Significant Deficiency
  • 504973 2024-004
    Significant Deficiency
  • 504974 2024-005
    Significant Deficiency
  • 504975 2024-005
    Significant Deficiency
  • 504976 2024-005
    Significant Deficiency
  • 504977 2024-005
    Significant Deficiency
  • 504978 2024-006
    Significant Deficiency Repeat
  • 504979 2024-006
    Significant Deficiency Repeat
  • 504980 2024-006
    Significant Deficiency Repeat
  • 504981 2024-006
    Significant Deficiency Repeat
  • 504982 2024-007
    Significant Deficiency Repeat
  • 504983 2024-007
    Significant Deficiency Repeat
  • 504984 2024-007
    Significant Deficiency Repeat
  • 504985 2024-007
    Significant Deficiency Repeat
  • 504986 2024-008
    Significant Deficiency
  • 504987 2024-008
    Significant Deficiency
  • 504988 2024-008
    Significant Deficiency
  • 504989 2024-008
    Significant Deficiency
  • 504990 2024-009
    Significant Deficiency
  • 504991 2024-009
    Significant Deficiency
  • 504992 2024-009
    Significant Deficiency
  • 504993 2024-009
    Significant Deficiency
  • 504994 2024-010
    Significant Deficiency
  • 504995 2024-010
    Significant Deficiency
  • 504996 2024-010
    Significant Deficiency
  • 504997 2024-010
    Significant Deficiency
  • 504998 2024-001
    Material Weakness Repeat
  • 504999 2024-001
    Material Weakness Repeat
  • 505000 2024-001
    Material Weakness Repeat
  • 505001 2024-001
    Material Weakness Repeat
  • 505002 2024-002
    Material Weakness Repeat
  • 505003 2024-002
    Material Weakness Repeat
  • 505004 2024-002
    Material Weakness Repeat
  • 505005 2024-002
    Material Weakness Repeat
  • 505006 2024-003
    Significant Deficiency
  • 505007 2024-003
    Significant Deficiency
  • 505008 2024-003
    Significant Deficiency
  • 505009 2024-003
    Significant Deficiency
  • 505010 2024-004
    Significant Deficiency
  • 505011 2024-004
    Significant Deficiency
  • 505012 2024-004
    Significant Deficiency
  • 505013 2024-004
    Significant Deficiency
  • 505014 2024-005
    Significant Deficiency
  • 505015 2024-005
    Significant Deficiency
  • 505016 2024-005
    Significant Deficiency
  • 505017 2024-005
    Significant Deficiency
  • 505018 2024-006
    Significant Deficiency Repeat
  • 505019 2024-006
    Significant Deficiency Repeat
  • 505020 2024-006
    Significant Deficiency Repeat
  • 505021 2024-006
    Significant Deficiency Repeat
  • 505022 2024-007
    Significant Deficiency Repeat
  • 505023 2024-007
    Significant Deficiency Repeat
  • 505024 2024-007
    Significant Deficiency Repeat
  • 505025 2024-007
    Significant Deficiency Repeat
  • 505026 2024-008
    Significant Deficiency
  • 505027 2024-008
    Significant Deficiency
  • 505028 2024-008
    Significant Deficiency
  • 505029 2024-008
    Significant Deficiency
  • 505030 2024-009
    Significant Deficiency
  • 505031 2024-009
    Significant Deficiency
  • 505032 2024-009
    Significant Deficiency
  • 505033 2024-009
    Significant Deficiency
  • 505034 2024-010
    Significant Deficiency
  • 505035 2024-010
    Significant Deficiency
  • 505036 2024-010
    Significant Deficiency
  • 505037 2024-010
    Significant Deficiency
  • 1081400 2024-001
    Material Weakness Repeat
  • 1081401 2024-001
    Material Weakness Repeat
  • 1081402 2024-001
    Material Weakness Repeat
  • 1081403 2024-001
    Material Weakness Repeat
  • 1081405 2024-002
    Material Weakness Repeat
  • 1081406 2024-002
    Material Weakness Repeat
  • 1081407 2024-002
    Material Weakness Repeat
  • 1081408 2024-003
    Significant Deficiency
  • 1081409 2024-003
    Significant Deficiency
  • 1081410 2024-003
    Significant Deficiency
  • 1081411 2024-003
    Significant Deficiency
  • 1081412 2024-004
    Significant Deficiency
  • 1081413 2024-004
    Significant Deficiency
  • 1081414 2024-004
    Significant Deficiency
  • 1081415 2024-004
    Significant Deficiency
  • 1081416 2024-005
    Significant Deficiency
  • 1081417 2024-005
    Significant Deficiency
  • 1081418 2024-005
    Significant Deficiency
  • 1081419 2024-005
    Significant Deficiency
  • 1081420 2024-006
    Significant Deficiency Repeat
  • 1081421 2024-006
    Significant Deficiency Repeat
  • 1081422 2024-006
    Significant Deficiency Repeat
  • 1081423 2024-006
    Significant Deficiency Repeat
  • 1081424 2024-007
    Significant Deficiency Repeat
  • 1081425 2024-007
    Significant Deficiency Repeat
  • 1081426 2024-007
    Significant Deficiency Repeat
  • 1081427 2024-007
    Significant Deficiency Repeat
  • 1081428 2024-008
    Significant Deficiency
  • 1081429 2024-008
    Significant Deficiency
  • 1081430 2024-008
    Significant Deficiency
  • 1081431 2024-008
    Significant Deficiency
  • 1081432 2024-009
    Significant Deficiency
  • 1081433 2024-009
    Significant Deficiency
  • 1081434 2024-009
    Significant Deficiency
  • 1081435 2024-009
    Significant Deficiency
  • 1081436 2024-010
    Significant Deficiency
  • 1081437 2024-010
    Significant Deficiency
  • 1081438 2024-010
    Significant Deficiency
  • 1081439 2024-010
    Significant Deficiency
  • 1081440 2024-001
    Material Weakness Repeat
  • 1081441 2024-001
    Material Weakness Repeat
  • 1081442 2024-001
    Material Weakness Repeat
  • 1081443 2024-001
    Material Weakness Repeat
  • 1081444 2024-002
    Material Weakness Repeat
  • 1081445 2024-002
    Material Weakness Repeat
  • 1081446 2024-002
    Material Weakness Repeat
  • 1081447 2024-002
    Material Weakness Repeat
  • 1081448 2024-003
    Significant Deficiency
  • 1081449 2024-003
    Significant Deficiency
  • 1081450 2024-003
    Significant Deficiency
  • 1081451 2024-003
    Significant Deficiency
  • 1081452 2024-004
    Significant Deficiency
  • 1081453 2024-004
    Significant Deficiency
  • 1081454 2024-004
    Significant Deficiency
  • 1081455 2024-004
    Significant Deficiency
  • 1081456 2024-005
    Significant Deficiency
  • 1081457 2024-005
    Significant Deficiency
  • 1081458 2024-005
    Significant Deficiency
  • 1081459 2024-005
    Significant Deficiency
  • 1081460 2024-006
    Significant Deficiency Repeat
  • 1081461 2024-006
    Significant Deficiency Repeat
  • 1081462 2024-006
    Significant Deficiency Repeat
  • 1081463 2024-006
    Significant Deficiency Repeat
  • 1081464 2024-007
    Significant Deficiency Repeat
  • 1081465 2024-007
    Significant Deficiency Repeat
  • 1081466 2024-007
    Significant Deficiency Repeat
  • 1081467 2024-007
    Significant Deficiency Repeat
  • 1081468 2024-008
    Significant Deficiency
  • 1081469 2024-008
    Significant Deficiency
  • 1081470 2024-008
    Significant Deficiency
  • 1081471 2024-008
    Significant Deficiency
  • 1081472 2024-009
    Significant Deficiency
  • 1081473 2024-009
    Significant Deficiency
  • 1081474 2024-009
    Significant Deficiency
  • 1081475 2024-009
    Significant Deficiency
  • 1081476 2024-010
    Significant Deficiency
  • 1081477 2024-010
    Significant Deficiency
  • 1081478 2024-010
    Significant Deficiency
  • 1081479 2024-010
    Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $9.59M
84.063 Federal Pell Grant Program $897,015
93.264 Nurse Faculty Loan Program (nflp) $735,010
93.364 Nursing Student Loans $584,276
84.007 Federal Supplemental Educational Opportunity Grants $50,642
84.033 Federal Work-Study Program $24,441