Understanding the ESFA Remittance Advice

Hi Ian

The Apps Monthly Payment report that is produced around the same day as the remittance is sent out *usually* matches up pretty well? I'd advise using pivot tables to sum by funding type and then using the R* Total columns which should give you values that look somewhat like the remittance!

Hi Steve,

Thanks very much and I eventually found the you report you mentioned :)

I've started to create pivot tables and now looking at the remittance advice, it mentions 'reconciliation' a few times but I can't see what exactly is being reconciled. Is this related to backdated payments i.e. starts/completers being added in later months? I did read the 2020-21 ILR Funding Reports manual but there's no mention of this.

Hi Ian

I have the same problem.  Where did you find the 'Apps Monthly Payment report'

Thank you

Hi Yvonne,

You will find the report in Submit Learner Data. Go to 'Reports'  and then 'Submission History'. You will then see the previous R returns and the Apps Monthly Payment Report is in the 'Period End reports' zip file.