Finding 945729 (2021-022)

Material Weakness Repeat Finding
Requirement
N
Questioned Costs
-
Year
2021
Accepted
2024-02-15
Audit: 290538
Organization: Saint Augustine's University (NC)
Auditor: Bdo USA PC

AI Summary

  • Core Issue: The University failed to reconcile the School Account Statement (SAS) data files from the Department of Education with its financial records for four consecutive months.
  • Impacted Requirements: This non-compliance with reconciliation requirements jeopardizes adherence to federal regulations for the Federal Direct Student Loan Program.
  • Recommended Follow-Up: Enhance internal controls to ensure monthly reconciliations are performed and documented; the recent implementation of the Ellucian Colleague system is expected to address these issues.

Finding Text

Program Information: Federal Direct Student Loan Program (ALN 84.268) Criteria or Specific Requirement (Including Statutory, Regulatory or Other Citation): N. Special Tests and Provisions – Borrower Data Transmission and Reconciliation - Direct Loans - Each month, the U.S. Department of Education’s Common Origination and Disbursement system (the “COD”) provides institutions with a School Account Statement (“SAS”) data file which consists of a Cash Summary, Cash Detail, and (optional at the request of the school) Loan Detail records. The school is required to reconcile these files to the institution’s financial records. Since up to three Direct Loan program years may be open at any given time, schools may receive three SAS data files each month (34 CFR sections 685.102(b), 685.301, and 303). Condition: Certain instances were identified during the year where the University was unable to support that a reconciliation was performed between the SAS data files provided from the COD and the University’s financial records. Cause: Lack of internal control and administrative oversight. Effect or Potential Effect: The University is not in compliance with requirements related to the reconciliation of Federal Direct Student Loan Program disbursement information. Questioned Costs: Unknown. Context: For 4 of 4 months selected for testing, the University was unable to provide documentation supporting that a reconciliation had been performed between the University’s financial records and the SAS data files received from the COD. Repeat Finding: This is a repeat finding from prior year. This was reported as Finding 2020-014 in the prior year schedule of findings and questioned costs. Recommendation: We recommend the University enhance its internal controls and procedures to ensure that reconciliations between financial records and the COD information are performed at least monthly, and that appropriate documentation is supporting the reconciliation is retained. Views of Responsible Officials and Planned Corrective Actions: With the implementation of Ellucian Colleague this issue has been resolved. The financial aid and business offices are directly involved with the COD processes weekly. This process sends originations and disbursement information for PELL and Federal loans to COD. Funds are transmitted to a student’s account through a two-part process called FATR between the two offices. With the implementation of Colleague, we have resolved those issues. Colleague's Financial Aid module provides the tools necessary to maintain, track, process, and report information associated with financial aid applicants and recipients to Colleague. The Financial Aid module helps manage the processing of financial aid, data, and reporting and will give SAU internal controls over their Title IV Student Financial Aid programs. Using this system, SAU can create and modify Grant records for submission to COD and import and reconcile Grant data. The financial aid office did not have these options in CAMS. The financial aid office no longer builds and or disburses aid manually in COD. Colleague and COD work together. The reconciliation process for Pell and Direct Loans to self-audit, ensuring the accuracy and validity of financial data sent and submitted to COD. The reconciliation process in completed monthly and any discrepancies are resolved prior to the next month.

Categories

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

Other Findings in this Audit

  • 369244 2021-015
    Material Weakness
  • 369245 2021-016
    Material Weakness
  • 369246 2021-017
    Material Weakness Repeat
  • 369247 2021-021
    Material Weakness Repeat
  • 369248 2021-025
    Material Weakness Repeat
  • 369249 2021-015
    Material Weakness
  • 369250 2021-016
    Material Weakness
  • 369251 2021-017
    Material Weakness Repeat
  • 369252 2021-026
    Material Weakness Repeat
  • 369253 2021-027
    Material Weakness Repeat
  • 369254 2021-015
    Material Weakness
  • 369255 2021-016
    Material Weakness
  • 369256 2021-017
    Material Weakness Repeat
  • 369257 2021-018
    Material Weakness Repeat
  • 369258 2021-021
    Material Weakness Repeat
  • 369259 2021-025
    Material Weakness Repeat
  • 369260 2021-015
    Material Weakness
  • 369261 2021-016
    Material Weakness
  • 369262 2021-017
    Material Weakness Repeat
  • 369263 2021-026
    Material Weakness Repeat
  • 369264 2021-015
    Material Weakness
  • 369265 2021-016
    Material Weakness
  • 369266 2021-017
    Material Weakness Repeat
  • 369267 2021-026
    Material Weakness Repeat
  • 369268 2021-015
    Material Weakness
  • 369269 2021-016
    Material Weakness
  • 369270 2021-017
    Material Weakness Repeat
  • 369271 2021-026
    Material Weakness Repeat
  • 369272 2021-015
    Material Weakness
  • 369273 2021-016
    Material Weakness
  • 369274 2021-017
    Material Weakness Repeat
  • 369275 2021-018
    Material Weakness Repeat
  • 369276 2021-019
    Material Weakness Repeat
  • 369277 2021-021
    Material Weakness Repeat
  • 369278 2021-024
    Material Weakness Repeat
  • 369279 2021-025
    Material Weakness Repeat
  • 369280 2021-015
    Material Weakness
  • 369281 2021-016
    Material Weakness
  • 369282 2021-017
    Material Weakness Repeat
  • 369283 2021-018
    Material Weakness Repeat
  • 369284 2021-019
    Material Weakness Repeat
  • 369285 2021-020
    - Repeat
  • 369286 2021-021
    Material Weakness Repeat
  • 369287 2021-022
    Material Weakness Repeat
  • 369288 2021-023
    Material Weakness Repeat
  • 369289 2021-024
    Material Weakness Repeat
  • 369290 2021-025
    - Repeat
  • 369291 2021-015
    Material Weakness
  • 369292 2021-016
    Material Weakness
  • 369293 2021-017
    Material Weakness Repeat
  • 369294 2021-026
    Material Weakness Repeat
  • 369295 2021-015
    Material Weakness
  • 369296 2021-016
    Material Weakness
  • 369297 2021-017
    Material Weakness Repeat
  • 369298 2021-026
    Material Weakness Repeat
  • 369299 2021-015
    Material Weakness
  • 369300 2021-016
    Material Weakness
  • 369301 2021-017
    Material Weakness Repeat
  • 369302 2021-026
    Material Weakness Repeat
  • 369303 2021-015
    Material Weakness
  • 369304 2021-016
    Material Weakness
  • 369305 2021-017
    Material Weakness Repeat
  • 369306 2021-026
    Material Weakness Repeat
  • 945686 2021-015
    Material Weakness
  • 945687 2021-016
    Material Weakness
  • 945688 2021-017
    Material Weakness Repeat
  • 945689 2021-021
    Material Weakness Repeat
  • 945690 2021-025
    Material Weakness Repeat
  • 945691 2021-015
    Material Weakness
  • 945692 2021-016
    Material Weakness
  • 945693 2021-017
    Material Weakness Repeat
  • 945694 2021-026
    Material Weakness Repeat
  • 945695 2021-027
    Material Weakness Repeat
  • 945696 2021-015
    Material Weakness
  • 945697 2021-016
    Material Weakness
  • 945698 2021-017
    Material Weakness Repeat
  • 945699 2021-018
    Material Weakness Repeat
  • 945700 2021-021
    Material Weakness Repeat
  • 945701 2021-025
    Material Weakness Repeat
  • 945702 2021-015
    Material Weakness
  • 945703 2021-016
    Material Weakness
  • 945704 2021-017
    Material Weakness Repeat
  • 945705 2021-026
    Material Weakness Repeat
  • 945706 2021-015
    Material Weakness
  • 945707 2021-016
    Material Weakness
  • 945708 2021-017
    Material Weakness Repeat
  • 945709 2021-026
    Material Weakness Repeat
  • 945710 2021-015
    Material Weakness
  • 945711 2021-016
    Material Weakness
  • 945712 2021-017
    Material Weakness Repeat
  • 945713 2021-026
    Material Weakness Repeat
  • 945714 2021-015
    Material Weakness
  • 945715 2021-016
    Material Weakness
  • 945716 2021-017
    Material Weakness Repeat
  • 945717 2021-018
    Material Weakness Repeat
  • 945718 2021-019
    Material Weakness Repeat
  • 945719 2021-021
    Material Weakness Repeat
  • 945720 2021-024
    Material Weakness Repeat
  • 945721 2021-025
    Material Weakness Repeat
  • 945722 2021-015
    Material Weakness
  • 945723 2021-016
    Material Weakness
  • 945724 2021-017
    Material Weakness Repeat
  • 945725 2021-018
    Material Weakness Repeat
  • 945726 2021-019
    Material Weakness Repeat
  • 945727 2021-020
    - Repeat
  • 945728 2021-021
    Material Weakness Repeat
  • 945730 2021-023
    Material Weakness Repeat
  • 945731 2021-024
    Material Weakness Repeat
  • 945732 2021-025
    - Repeat
  • 945733 2021-015
    Material Weakness
  • 945734 2021-016
    Material Weakness
  • 945735 2021-017
    Material Weakness Repeat
  • 945736 2021-026
    Material Weakness Repeat
  • 945737 2021-015
    Material Weakness
  • 945738 2021-016
    Material Weakness
  • 945739 2021-017
    Material Weakness Repeat
  • 945740 2021-026
    Material Weakness Repeat
  • 945741 2021-015
    Material Weakness
  • 945742 2021-016
    Material Weakness
  • 945743 2021-017
    Material Weakness Repeat
  • 945744 2021-026
    Material Weakness Repeat
  • 945745 2021-015
    Material Weakness
  • 945746 2021-016
    Material Weakness
  • 945747 2021-017
    Material Weakness Repeat
  • 945748 2021-026
    Material Weakness Repeat

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $6.63M
84.063 Federal Pell Grant Program $3.76M
84.031 Higher Education_institutional Aid $2.17M
84.425 Education Stabilization Fund $1.78M
84.007 Federal Supplemental Educational Opportunity Grants $1.12M
84.047 Trio_upward Bound $771,898
84.044 Trio_talent Search $552,558
84.033 Federal Work-Study Program $536,970
84.938 Disaster Recovery Assistance for Education $295,188
84.042 Trio_student Support Services $280,096
47.076 Education and Human Resources $51,642
15.904 Historic Preservation Fund Grants-in-Aid $1,450