Has anyone got any advice on predicting and calculating our monthly payments?
We usually go by our company CRM and PICS reports – 90% of the time these are close enough to the payment we receive. But in recent months they seem to be out by large amounts.
None of the reports on PICS, collection data etc. are similar. Does anyone else have this issue?
Please send an email to to us with a few details and we’ll be happy to take a look into the specifics for you. Unfortunately, it’s been quite difficult to reconcile funding since things were changed for the Apprenticeship Reforms.
Have you checked that all the payments from the employer for the contribution has been entered in PICS as paid? If any have not been, the completion payment will be withheld until it is submitted as confirmed.
I’ve double checked and there are no DLOCK’s, employer contributions have been recorded against completions where applicable and the indicative earnings report matches the PFR from PICS. Just not the payment we received!
I’ve emailed into pellcomp support so fingers crossed they can find something I may have missed.
If you put the raw data from the ESFA ‘Indicative earnings’ report into a pivot table summary by learner ref you can cross reference YTD earnings vs YTD payment for every learner against the ‘Monthly Payment’ report by also using a pivot summary by learner. You can then use a vlookup formula to reconcile the two and identify the discrepancies. Should take about 15 minutes.