You have accepted all cookies. You can change your cookie settings at any time.
This is a new service – your
feedback will help us to improve it.
Created 21 January 2021 16:51
Can anyone help, or guide, me please to understand the ESFA Remittance Advice in more detail? I have looked for guidance, and looked through our ILR data, but didn't have any joy with working out specific payments and what this relates to. Any assistance would be appreciated.
No one has replied to this post.
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!
21 January 2021 17:14
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.
22 January 2021 16:48
I have the same problem. Where did you find the 'Apps Monthly Payment report'
22 January 2021 17:06
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.
25 January 2021 10:24