Once a funding reconciliation has been run, you can Download the relevant reconciliation reports from the Funding Reconciler page as Excel spreadsheets. Depending on the ESFA Funding Report that you have uploaded, the reconciliation report will contain different worksheets showing the differences between ESFA and PICSWeb data.
Apps Monthly Payments Reconciliation Report
The reconciliation reports for the Apps Monthly Payments report is made up of the following worksheets:
Summary – This displays the Count of items in each of the report worksheets.
YTD Matches – This shows a list of payments by learner with the same Year-to-Date funding values between PICSWeb and the ESFA funding reports.
YTD Differences – This shows a list of payments by learner with different Year-to-Date funding values between PICSWeb and the ESFA funding reports.
ACT Adjustments – This shows a list of payments where the associated Apprenticeship Contract Type (ACT) differ between PICSWeb and the ESFA funding reports.
Funding Matches – This shows a list of payment records with the same value in both your PICS data and the ESFA funding reports.
Funding Differences – This shows a list of payment records with differing values between your PICS data and the ESFA funding reports.
Levy Adjustments
PICS Not ESFA – This shows a list of payment records found in your PICS data but not in the ESFA funding reports.
ESFA Not PICS – This shows a list of payment records found in the ESFA funding reports but not in your PICS data.
Incentive Adjustments – This shows a list of incentive payment records that are not listed as Paid in PICSWeb but are reported as Paid in the funding report.
App Service Adjustments – This shows a list of PICS Episodes where their Apprenticeship Service Status in PICSWeb indicates that they are not on the Apprenticeship Service, but the funding report indicates that they are.
Apps Indicative Earnings Reconciliation Report
The reconciliation reports for the Apps Indicative Earnings report is made up of the following worksheets:
Summary – This displays the Count of items in each of the report worksheets.
Funding Matches – This shows a list of payment records with the same value in both your PICS data and the ESFA funding reports.
Funding Differences – This shows a list of payment records with differing values between your PICS data and the ESFA funding reports.
PICS Not ESFA – This shows a list of payment records found in your PICS data but not in the ESFA funding reports.
ESFA Not PICS – This shows a list of payment records found in the ESFA funding reports but not in your PICS data.
Apprenticeship Data Match Reconciliation Report
The reconciliation reports for the Apps Data Match shows each data mismatch item identified in the report. For each mismatch, additional details are shown to allow you to identify the relevant episode in PICSWeb.
Occupancy Reconciliation Reports
The reconciliation reports for the Main Occupancy, Devolved Adult Education Occupancy, Trailblazer Apprenticeships Occupancy and ALLB Occupancy reports are made up of the following worksheets:
Summary – This displays the Count of items in each of the report worksheets.
Funding Matches – This shows a list of payment records with the same value in both your PICS data and the ESFA funding reports.
Funding Differences – This shows a list of payment records with differing values between your PICS data and the ESFA funding reports.
PICS Not ESFA – This shows a list of payment records found in your PICS data but not in the ESFA funding reports.
ESFA Not PICS – This shows a list of payment records found in the ESFA funding reports but not in your PICS data.