Finding 614772 (2022-002)

-
Requirement
N
Questioned Costs
-
Year
2022
Accepted
2022-11-14
Audit: 30742
Organization: Bellevue University (NE)
Auditor: Forvis LLP

AI Summary

  • Core Issue: One monthly reconciliation of the School Account Statement (SAS) was missing, preventing verification of data alignment with financial records.
  • Impacted Requirements: Management must ensure all monthly reconciliations are completed and retained as part of their financial oversight responsibilities.
  • Recommended Follow-Up: Implement stronger controls and automated processes to ensure timely reconciliation and secure storage of SAS files for future audits.

Finding Text

2022-002 Student Financial Assistance Cluster U.S. Department of Education Federal Direct Student Loans ? 84.268 Criteria or specific requirement ? Management is responsible for the reconciliation of the School Account Statement (SAS) data file to the institution?s financial records. Condition ? One monthly reconciliation was not available to be provided to the auditor to support the reconciliation was completed. Questioned costs ? There were no questioned costs identified on the monthly reconciliation requested. Context ? Of the 24 monthly reconciliations for the fiscal year ended June 30, 2022, one was not available to be provided to the auditor to support the reconciliation was completed. FORVIS selected four monthly reconciliations for testing. Effect ? FORVIS was not able to verify the institution reconciled the SAS data file to their financial records. Cause ? The institution went through a system conversion during the fiscal year ended June 30, 2022. During this conversion, the reconciliation was inadvertently not imported into the new system. Recommendation ? Management should ensure that proper controls are in place to confirm monthly reconciliations of SAS data files and the institution?s financial records are completed and retained. Views of Responsible Officials and Planned Corrective Actions ? The University has updated its procedures and policies to better align with their system conversion and continues to improve internal control over reconciliation and record retention. New procedures ensure through automation that the SAS files are downloaded from the federal aid system and processed on a regular monthly occurrence. The SAS information is stored at the student level and copies of the files are maintained in a secure network folder for future retrieval. The University storage of the SAS files and student records align with the federal recommendations and regulatory requirements, ranging from 3 to 7 years.

Categories

Matching / Level of Effort / Earmarking Internal Control / Segregation of Duties

Other Findings in this Audit

Programs in Audit

ALN Program Name Expenditures
84.268 Federal Direct Student Loans $69.71M
84.063 Federal Pell Grant Program $16.17M
84.425 Covid-19 - Arp Higher Education Emergency Relief Fund-Ihes $3.58M
84.425 Covid-19 - Crrsaa Higher Education Emergency Relief Funds-Ihes $1.30M
84.007 Federal Supplemental Educational Opportunity Grants $936,040
84.033 Federal Work-Study Program $81,193
84.425 Covid-19 - Cares Act Higher Education Emergency Relief Fund-Ihes $58,278
84.425 Covid-19 - Arp Higher Education Emergency Relief-Institutional Portion $49,901