...
UKPRN – If you have set up PICSWeb for multiple providers, you can choose which provider you want to reconcile funding for by selecting a UKPRN from the drop-down menu.
ILR Year
Reconciliation Type – Here you can specify which ESFA funding report you are reconciling, as explained above.
Select New File to Reconcile – If you have already run reconciliation for the same UKPRN, ILR Year and Reconciliation Type, the report file may have been saved. If so, this option will appear, allowing you to use the previously uploaded report file or to upload a new file.
File – Selecting this field will open a window where you can upload the ESFA funding report. Alternatively, you can drag and drop a file onto the field from another window. Both .csv and .xlsx file formats will be accepted.
Store Uploaded File for Reconciliation Updates – If this is ticked, the file uploaded will be saved for future reconciliation. When a user tries to run a reconciliation with the same UKPRN, ILR Year and Reconciliation Type, they will have the option to use the saved file or upload a new one.
| Note |
|---|
Make sure that you only upload the original file as downloaded from the ESFA. Opening a file and saving it in Excel can cause some data to be reformatted, which will affect the reconciliation process. |
...
Once you have configured your options, select Continue. If you have selected any other Reconciliation Type than Apps Monthly Payment, the reconciliation will be added to the list with the Processing label.
...