Apps Additional Payments Analyser

Analyze incentives, small employer waivers, and additional payments

What is the Apps Additional Payments Report? (Report 158-164)

The Apps Additional Payments Report shows additional payments generated under Funding Model 36 (apprenticeships from 1 May 2017). These are bonus payments and incentives paid to providers, employers, or apprentices on top of regular training funding.

Types of Additional Payments Shown:

Provider payments: 16-18 additional payments for providers (£1,000 per eligible apprentice)
Employer payments: Incentives for employers taking on eligible apprentices
Apprentice payments: Direct payments to eligible 16-18 year olds or 19-24 year olds

Report Timing:

Generated after the ILR submission window closes. Shows which employers have had additional payments generated for them. Does not include EAS (Employment Advisory Service) data as that's at aggregate level only.

Key Features of the Report

Employer Identification

Shows employer identifier from ILR and employer name from Apprenticeship Service (where available). The intention is to clearly show which employers have received additional payments.

Separate Rows for Payment Types

When apprentice, provider, and employer additional payments are generated, these appear on separate rows in the report for clarity.

Payment-Based Rows

Rows based primarily on payments made for each collection (R01 to R14), not on latest ILR return. This preserves historical payment data even if ILR records change.

Negative Payments Shown

When apprentices removed from ILR, negative payments (recoveries) are shown. ILR details won't be displayed, but negative payment will appear for the collection where removal occurred.

Understanding Additional Payments

16-18 Additional Payments for Providers

Providers receive £1,000 for each 16-18 year old apprentice (or eligible 19-24 year old):

£500 paid after 90 days on programme
£500 paid on successful completion
Eligible 19-24 year olds include those with EHC plan or formerly looked after

Employer Incentive Payments

Additional payments to employers for hiring eligible apprentices (amounts and criteria vary by policy period):

Small employer incentives (fewer than 50 employees)
Hiring incentives during specific policy periods
Additional support for specific age groups or circumstances

Apprentice Payments

Direct payments made to eligible apprentices (typically 16-18 year olds or eligible 19-24 year olds) under specific funding schemes.

What the Analyser Shows

Dashboard Summary

• Total additional payments by type (provider, employer, apprentice)
• Number of apprentices receiving additional payments
• Breakdown by employer
• Monthly payment trends

Detailed Analysis

• Individual apprentice payment records
• Employer identifier and name information
• Payment amounts per collection period
• Negative payments (recoveries) tracking

Employer View

• Group by employer to see total additional payments per employer
• Identify employers benefiting from incentives
• Track small employer waivers and special schemes

How to Use the Analyser

1Download Report from ESFA

• Available as CSV file
• Generated after ILR submission window closes
• Do not rename the file from its original DfE format

2Upload to Analyser

Upload your CSV file. The tool will:

• Validate the filename and structure
• Parse the payment data
• Group by payment type and employer

3Review Dashboard

View summary statistics showing total additional payments broken down by provider payments, employer payments, and apprentice payments

4Analyze by Employer

Switch to table view to explore payments by employer, filter data, and identify which employers are benefiting from additional payments

Understanding Separate Rows

When multiple payment types are generated for the same apprentice, they appear on separate rows:

Example:

•Row 1: Provider payment (£500 for 90 days)
•Row 2: Employer payment (small employer incentive)
•Row 3: Apprentice payment (direct to learner)

This separation makes it clear who receives each payment and how much.

Important Points

•No EAS data: Does not include Employment Advisory Service data (aggregate level only)
•Payment-based rows: Based on payments made (R01-R14), not latest ILR file
•Removed apprentices: ILR details won't show, but negative payments (recoveries) will appear
•Data matching errors: If earnings exist but no payment made (e.g., data matching error), apprentice won't appear
•Multiple rows normal: Separate rows for provider, employer, and apprentice payments is expected behavior
•Historical data: Positive payment in earlier collection, negative in collection where apprentice removed

Key Use Cases

Track Provider Additional Payments

Monitor 16-18 (and eligible 19-24) additional payments to ensure you're receiving expected £1,000 per eligible apprentice

Employer Incentive Analysis

Identify which employers are benefiting from incentive payments and track small employer waivers

Recovery Tracking

Monitor negative payments to understand recoveries from withdrawn or removed apprentices

Financial Forecasting

Use historical payment data to forecast additional payment income for budgeting

Tips for Managing Additional Payments

•Track eligibility: Ensure 16-18 year olds and eligible 19-24 year olds are correctly identified in your ILR
•Monitor 90-day trigger: First £500 provider payment triggers after 90 days - track learner progress
•Expect separate rows: Don't be concerned about multiple rows for same apprentice - it's by design
•Review negative payments: Check negative payments match previous positives for withdrawn learners
•Compare collection periods: Analyze across R01-R14 to understand payment timing patterns
•Cross-reference with ILR: Match additional payments to your ILR learner records

Ready to Analyze?

Upload your Apps Additional Payments Report to track incentives and additional payments.

Open Analyser