Version 4 - Last Updated: 03 May 2023

Financial reports

Payment instalment report: academic year view


Select the relevant academic year, then select Display Details. This page will default to the current academic year. The report is only available from academic year 2017/18 onwards.

Viewing the payment instalment report

The payment instalment report has 3 separate tables:

  • submitted and progressing applications
  • approved for payment
  • not approved for payment

The report will show the details as they were at the close of business the night before.

Submitted Applications

In the Submitted Applications table, the Number column shows the count of all applications that meet the following conditions:

  • the application exists but has never been approved
  • the Learning Aim start date is in the selected academic or financial year
  • the application has no associated payment instalments
  • the application state is Awaiting Validation, Missing Evidence, Awaiting Rejection, Held Pending Budget Approval, Awaiting Investigation or Awaiting Approval

The To Date column shows the entitlement amounts of all the submitted applications.

The information will be correct as at the day before you view the report.

The Monthly Breakdown and Year to Date columns will not have any data for submitted applications.

Applications Progressing

In the Applications Progressing table, the Number column shows the count of all applications that meet the following conditions:

  • the application has been assessed
  • the Learning Aim start date is in the selected year
  • the learner has a Unique Learner Number (ULN) or you have a restriction type of 'Allow Learning Provider to Confirm Attendance without ULN'
  • the learner has a verified National Insurance number
  • the application state is Approved or Withdrawn

The information will be correct as at the day before you view the report.

The To Date, Monthly Breakdown and Year to Date columns will not have any data for submitted applications.

Approved for payment

The Approved for payment table has 4 main sections:

  • paid
  • scheduled with attendance confirmed
  • scheduled awaiting attendance confirmation
  • approved awaiting signature

The paid, scheduled with attendance confirmed and scheduled awaiting attendance confirmation figures include applications that are approved, suspended or withdrawn. 

A further breakdown of the sections shows whether the application is currently suspended, has a missing ULN, National Insurance number or both.

The paid section is filled once the payment run begins and not on the actual payment date.

If you confirm a learner’s attendance with N (not in attendance) or C (not in attendance because their start has moved to a later date), the learner is removed from the Attendance Worklist and will show on the CoC Worklist.

However, the loan amount for these learners will still show under the Attendance confirmation only required subsection, until you submit the appropriate CoC.

The Approved awaiting signature section shows applications where we have not yet received the Online Declaration Form. This section supersedes the missing ULN and National Insurance number sections.

The Approved for payment table contains 4 further sections:

  • total
  • offset
  • facility
  • percentage usage of facility

The total row is the sum of all the instalments in the rows above.

The offset value is any money your organisation owes. It matches the offset in the loan position report.

The facility value is your loan facility value the Education & Skills Funding Agency (ESFA) has sent us for that academic year. For example, for academic year 2023/24 it will run from 1 August 2023 to 31 July 2024. This value matches that on the Loan Facility Details page.

The percentage usage of facility is the value taken from the Loan Facility Details page. If the percentage is no higher than 80%, the field will be green. If it is between 81% and 94%, the field will be amber. At 95% or over it will be red. These amounts will appear in the year to date (YTD) column.

Exporting a csv report

  1. Select Export CSV Report.
  2. Enter a filename.
  3. Select Export Report.

An image of the export report button in the payment instalment report page.


Print this chapter
Back to top