Additional Validation for AVETMISS Excel Files in the Auto Reconciliation Process

In the AVETMISS Results Excel file, column AG contains the field student_pay, which indicates whether payment has been received (“Y” for Yes and “N” for No).

When this file is uploaded through the Auto Reconciliation page in aXcelerate, the system is incorrectly interpreting rows where student_pay = “N” as if the unit has been paid. This leads to inaccurate reconciliation outcomes.

Introducing an additional validation step to correctly identify and process “N” values would ensure data accuracy. This enhancement would be beneficial for all businesses using the State Funding Auto Reconciliation functionality.