Finding 1153064 (2024-001)

Material Weakness Repeat Finding
Requirement
N
Questioned Costs
-
Year
2024
Accepted
2025-09-15
Audit: 366317
Organization: County of Westchester (NY)

AI Summary

  • Core Issue: Errors in the calculation and disbursement of Pell Grant refunds due to failures in a new financial aid reporting system.
  • Impacted Requirements: Refunds must be issued within 14 days, and accurate reporting to the U.S. Department of Education is mandatory.
  • Recommended Follow-Up: Test new systems thoroughly, improve data integrity controls, enhance reconciliation processes, provide staff training, and monitor compliance with disbursement timelines.

Finding Text

Refunds of Title IV Funds Calculation and Disbursement Errors (Significant Deficiency - Special Tests and Provisions) Identification of Federal Program: Assistance Listing Number and Title: 84.063 - Federal Pell Grant Program. Cluster: Student Financial Assistance Cluster. Federal Agency: U.S. Department of Education. Federal Award Identification: P063P231905. Fiscal Year 2023-2024 (College). Criteria: Per 34 CFR § 668.164 and 34 CFR § 668.21, Title IV funds, including Pell Grant disbursements, must be made to or on behalf of eligible students within prescribed timeframes. Refunds and disbursements must occur within 14 calendar days of the date funds are credited to the student's account. Institutions must also ensure accurate reporting and reconciliation with the U.S. Department of Education's Common Origination and Disbursement (COD) system and federal payment system (G5). Condition: During the Fall 2023-2024 semester, 125 Pell Grant refund checks totaling $144,576 were issued incorrectly due to failures in the newly implemented student financial aid reporting system. Errors Identified: 1. 10 checks totaling $11,087 were cashed, with only $1,233 returned to the College. The remaining $9,854 is considered questioned costs. 2. 51 checks totaling $56,263 were cashed, and accounts were later adjusted with student cooperation. 3. 64 checks totaling $77,226 were stopped before payment. The errors were discovered approximately six weeks into the Fall 2023-2024 semester during the month of November. The new student financial aid reporting system was discontinued, the old system reinstated, and manual corrections were entered into each affected student's account. Cause: System and operational failures due to inadequate implementation of the new student financial aid reporting system: 1. Data integrity issues - Unauthorized entries and inaccurate data. 2. Communication failures - Lack of timely notifications to students. 3. Disbursement errors - Scheduled disbursement dates canceled and rescheduled. Inconsistencies with the U.S. Department of Education's COD system data. 4. Compliance date reporting errors. 5. Insufficient training on the new student financial aid reporting system. 6. Incorrect financial aid packaging, requiring manual reprocessing. Effect or Potential Effect: Pell Grant refunds were not issued within the 14-day regulatory requirement. Students received incorrect disbursement amounts. Risk of noncompliance with federal requirements for timeliness, accuracy, and reconcilation. Questioned costs totaling $9,854. Context: Total population affected: 125 refund checks totaling $144,576. Statistically valid sample tested: 37 checks, stratified across three error categories. Tested 10 cashed checks not returned, 13 cashed checks where student accounts were subsequently adjusted and 15 checks where stop payments were issued. The errors were systemic, stemming from the new student financial aid reporting system's operational rollout, and not an isolated occurence. Identification as Repeat Finding: Not identified as a repeat finding from the prior year. Recommendations: - Ensure thorough testing and validation of any new financial aid systems prior to implementation. - Implement data integrity controls to prevent unauthorized or erroneous entries. - Enhance reconciliation procedures with COD and G5 systems. - Provide comprehensive staff training before and during system transitions. - Establish monitoring to ensure disbursements meet the 14-day requirement. View of Responsible Officials' Corrective Action Plan: The following Corrective Action Plan was prepared by the management of Westchester Community College. It has not been audited and is solely the responsibility of the College. The plan is provided in response to the finding identified in the Schedule of Findings and Questioned Costs.

Corrective Action Plan

Corrective Action Plan (CAP) Institution: Westchester Community College New York Program Audited: Assistance Listing Number & Title: 84.063 – Federal Pell Grant Prepared for: Submission to Single Audit reporting package through the Federal Audit Clearinghouse (FAC) and Aid, Director, Financial Management Group – Federal Student Aid Date: August 27, 2025 1. Finding Reference • Audit Report Section: [Insert Finding Number/Reference] Finding 2024-001: Refunds of Title IV Funds Calculation and Disbursement Errors (Significant Deficiency - Special Tests and Provisions) • Description of Finding: Summarize the audit finding clearly as stated in the audit report. During the Fall 2023-2024 semester, 125 Pell Grant refund checks totaling $144,576 were issued incorrectly due to failures in the newly implemented student financial aid reporting system. • Errors Identified: 1. 10 checks totaling $11,087 were cashed, with only $1,233 returned to the college. The remaining $9,854 is considered questioned costs. 2. 51 checks totaling $56,263 were cashed, and accounts were later adjusted with student cooperation. 3. 64 checks totaling $77,226 were stopped before payment. 2. Root Cause Analysis • Cause of Noncompliance: Explain why the issue occurred (e.g., lack of internal controls, insufficient training, system error). System and operational failures due to inadequacy of the new student financial aid reporting system. • Contributing Factors: List any secondary factors (e.g., staff turnover, policy misinterpretation). 1. Data integrity issues – Automatic updates resulted in unauthorized entries and inaccurate data. 2. Communication failures – Early reports by staff of system errors were not addressed in a timely manner, resulting in delayed communication. 3. Disbursement errors – Scheduled disbursement dates canceled and rescheduled as a result of system’s inability to package students correctly. 4. SFP processing was inconsistent with US DOE COD system data. 5. Compliance date reporting errors due to SFP processing. 6. Training on the new SFP system was insufficiently provided by the vendor. In-person and self-paced training modules also not provided by the vendor. 7. SFP system contributed to incorrect financial aid packaging, requiring manual reprocessing 8. The SFP system was not aligned with unique community college scheduling features (e.g. parts of term such as winter session, 8-week semesters). 3. Corrective Action Plan Planned Corrective Measures: Detail the specific steps WCC management will take to correct the deficiency. To mitigate further damage, WCC reinstated the prior software system in April 2024, however, since the ISIRs were already determined, manual adjustments were made to students. This required additional corrective action steps: • Manual Data Corrections – Financial aid counselors manually reviewed data on approximately 6400 students and made corrections, student by student. • Reconciliation with G5 Data – Financial aid data had to be manually reconciled with G5, the federal payment system. • Compliance Adjustments – Transaction dates for compliance reporting were corrected. • Award Authorization – Student award amounts required manual verification, authorization, and approval. • Bursar’s Office Delays – Due to system errors, Bursar’s Office delayed processing refunds to prevent further financial discrepancies. • Parallel setup of on-prem financial aid system in March 2024 to prepare for the 2024-25 academic year. • Extraction of 2023-24 academic year financial aid data from SFP system and import into on-prem financial aid system. • Discontinue use of SFP on approximately 7/1/2025. • Responsible Party: Name/Title of the person(s) responsible for implementing corrective action. Garrett McAlister, Vice President of Information Technology; Dawn Gillins, Acting Vice President of Administrative Services/CFO; Dr. Erik Fortune, Assistant Vice President of Administration; Dr. Sandra Ramsey, Director of Enrollment Services; Nicola Howard-Brown, Acting Director of Financial Aid; Richard Cruz, Manager of Fiscal Operations; Garth Walcott, Program Administrator- Bursar Operations; Brian Murphy, former VP of Administrative Services/CFO; Dante Cantu, VP of Student Affairs; Anita Cook, former Director of Financial Aid. • Resources Required: Identify resources such as additional staff, training, IT system upgrades. Additional financial aid professional staff, IT/SFP system consultants. • Timeline: Expected completion date(s) for each corrective measure. Financial aid system remediation and awarding is complete. 2023-24 student financial aid data extraction/import for future reference in process. 4. Monitoring & Follow-Up • Ongoing Oversight - Describe how WCC will monitor to ensure corrective actions remain effective: WCC has a fully documented academic year financial aid project plan that is followed to ensure the timely implementation of tasks. • Internal Review Mechanisms: WCC will include periodic reviews aligned with standard DOE reporting timelines. Increase reconciliation frequency between G5 and COD. Increase periodic reviews, reports to leadership, and internal audit spot checks. 5. Evidence of Implementation • Documentation: List the types of evidence that will be maintained (e.g., revised policies, training logs, updated system reports). Project plan to revert back to previous system, training schedules, policy updates as they occur, and relevant updated system reports. • Retention: Confirm that documentation will be retained in accordance with federal regulations. WCC confirms that documentation will be retained in accordance with federal regulations. 6. Management Certification I certify that the corrective actions described above will be implemented as stated and monitored to ensure full compliance with federal requirements. Signed: Belinda S. Miles Name: Belinda S. Miles, Ed. D. Title: President Date: August 29, 2025

Categories

Student Financial Aid Special Tests & Provisions Subrecipient Monitoring Reporting Significant Deficiency

Programs in Audit

ALN Program Name Expenditures
93.558 Temporary Assistance for Needy Families $71.34M
93.575 Child Care and Development Block Grant $64.01M
21.027 Coronavirus State and Local Fiscal Recovery Funds $60.30M
14.267 Continuum of Care Program $17.13M
93.778 Medical Assistance Program $15.58M
84.063 Federal Pell Grant Program $15.42M
93.658 Foster Care Title IV-E $11.46M
10.561 State Administrative Matching Grants for the Supplemental Nutrition Assistance Program $10.31M
93.667 Social Services Block Grant $9.93M
20.507 Federal Transit Formula Grants $8.75M
93.659 Adoption Assistance $7.68M
93.563 Child Support Services $7.52M
14.218 Community Development Block Grants/entitlement Grants $6.91M
84.268 Federal Direct Student Loans $3.65M
10.557 Wic Special Supplemental Nutrition Program for Women, Infants, and Children $3.08M
93.323 Epidemiology and Laboratory Capacity for Infectious Diseases (elc) $2.47M
20.500 Federal Transit Capital Investment Grants $2.38M
84.425 Education Stabilization Fund $2.03M
93.958 Block Grants for Community Mental Health Services $1.35M
17.258 Wioa Adult Program $1.30M
93.568 Low-Income Home Energy Assistance $1.24M
20.205 Highway Planning and Construction $1.22M
84.048 Career and Technical Education -- Basic Grants to States $1.02M
93.044 Special Programs for the Aging, Title Iii, Part B, Grants for Supportive Services and Senior Centers $701,139
17.259 Wioa Youth Activities $691,246
20.106 Airport Improvement Program, Infrastructure Investment and Jobs Act Programs, and Covid-19 Airports Programs $680,229
16.922 Equitable Sharing Program $674,114
14.900 Lead Hazard Reduction Grant Program $594,565
93.243 Substance Abuse and Mental Health Services Projects of Regional and National Significance $531,623
20.513 Enhanced Mobility of Seniors and Individuals with Disabilities $528,113
93.090 Guardianship Assistance $500,665
84.181 Special Education-Grants for Infants and Families $486,694
93.150 Projects for Assistance in Transition From Homelessness (path) $474,418
93.045 Special Programs for the Aging, Title Iii, Part C, Nutrition Services $411,427
14.231 Emergency Solutions Grant Program $386,015
84.033 Federal Work-Study Program $371,373
84.335 Child Care Access Means Parents in School $357,488
11.307 Economic Adjustment Assistance $344,000
93.052 National Family Caregiver Support, Title Iii, Part E $331,000
93.556 Marylee Allen Promoting Safe and Stable Families Program $329,915
93.977 Sexually Transmitted Diseases (std) Prevention and Control Grants $327,299
16.839 Stop School Violence $320,000
97.036 Disaster Grants - Public Assistance (presidentially Declared Disasters) $318,410
14.239 Home Investment Partnerships Program $312,200
93.053 Nutrition Services Incentive Program $309,285
84.042 Trio Student Support Services $303,360
16.741 Dna Backlog Reduction Program $300,258
16.590 Grants to Encourage Arrest Policies and Enforcement of Protection Orders Program $293,069
81.128 Energy Efficiency and Conservation Block Grant Program (eecbg) $282,250
93.967 Centers for Disease Control and Prevention Collaboration with Academia to Strengthen Public Health $264,191
93.994 Maternal and Child Health Services Block Grant to the States $251,200
14.401 Fair Housing Assistance Program $247,852
93.674 John H. Chafee Foster Care Program for Successful Transition to Adulthood $230,469
16.575 Crime Victim Assistance $228,570
20.600 State and Community Highway Safety $205,171
93.747 Elder Abuse Prevention Interventions Program $195,369
97.106 Securing the Cities Program $173,479
16.606 State Criminal Alien Assistance Program $171,794
93.767 Children's Health Insurance Program $166,359
84.031 Higher Education Institutional Aid $149,181
93.268 Immunization Cooperative Agreements $147,404
16.040 Matthew Shepard and James Byrd, Jr. Hate Crimes Education, Investigation and Prosecution Program $147,070
16.004 Law Enforcement Assistance Narcotics and Dangerous Drugs Training $114,998
93.914 Hiv Emergency Relief Project Grants $109,469
84.007 Federal Supplemental Educational Opportunity Grants $103,573
21.032 Local Assistance and Tribal Consistency Fund $100,000
17.278 Wioa Dislocated Worker Formula Grants $92,692
16.835 Body Worn Camera Policy and Implementation $86,905
97.042 Emergency Management Performance Grants $86,042
93.043 Special Programs for the Aging, Title Iii, Part D, Disease Prevention and Health Promotion Services $67,894
16.036 Comprehensive Forensic Dna Analysis Grant Program $67,135
20.616 National Priority Safety Programs $62,935
16.742 Paul Coverdell Forensic Sciences Improvement Grant Program $57,197
93.071 Medicare Enrollment Assistance Program $52,147
16.320 Services for Trafficking Victims $50,803
16.588 Violence Against Women Formula Grants $50,000
93.779 Centers for Medicare and Medicaid Services (cms) Research, Demonstrations and Evaluations $44,890
93.669 Child Abuse and Neglect State Grants $42,671
16.300 Law Enforcement Assistance FBI Advanced Police Training $38,125
66.472 Beach Monitoring and Notification Program Implementation Grants $34,750
97.067 Homeland Security Grant Program $24,133
93.698 Elder Justice Act – Adult Protective Services $24,130
10.558 Child and Adult Care Food Program $23,155
93.069 Public Health Emergency Preparedness $11,533
96.006 Supplemental Security Income $10,400
47.076 Stem Education (formerly Education and Human Resources) $9,104
93.671 Family Violence Prevention and Services/domestic Violence Shelter and Supportive Services $8,555
16.548 Delinquency Prevention Program $8,455
12.903 Gencyber Grants Program $5,274
93.008 Medical Reserve Corps Small Grant Program $4,500
17.245 Trade Adjustment Assistance $1,253