Guidance
ESFA: supplementary data collection example file
Updated 19 November 2018
Download CSV 1.75 KB
| ConRefNumber | DeliverableCode | CalendarYear | CalendarMonth | CostType | StaffName | ReferenceType | Reference | ULN | ProviderSpecifiedReference | Value | HourlyRate | TotalHoursWorked | ProjectHours | OrgHours |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Staff Part Time | Staff One | Employee ID | 699258 | Not set | Not set | 3500 | 10 | 350 | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Staff Full Time | Staff Two | Employee ID | 699260 | Not set | Not set | 500 | Not set | 50 | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Staff Part Time | Staff Three | Employee ID | 699260 | Not set | Not set | 75 | 7.5 | 10 | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Other Costs | Not set | Invoice | 1234567X | Not set | Brochures | 1000 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | CG02 | 2016 | 1 | Other Costs | Not set | Invoice | 123456789X | Not set | Not set | 1500 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Apportioned Cost | Not set | Invoice | 9876ST | Not set | Phone expenses | 6345.78 | Not set | Not set | 35 | 140 |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Staff Expenses | Staff Four | Employee ID | 699260 | Not set | Not set | 60 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | AC01 | 2016 | 1 | Staff Expenses | Staff Five | Employee ID | 6991008 | Not set | Not set | 1000 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | CG01 | 2016 | 1 | Grant | Not set | Grant Recipient | Recipient 1 | Not set | Not set | 50000 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | CG01 | 2016 | 1 | Grant | Not set | Grant Recipient | Recipient 2 | Not set | Not set | 25000 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | CG02 | 2016 | 1 | Grant Management | Not set | Grant Recipient | Recipient 2 | Not set | Not set | 1250 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | SD01 | 2016 | 1 | Unit Cost | Not set | LearnRefNumber | Learner1 | 999888777 | Not set | Not set | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | SD01 | 2016 | 1 | Unit Cost | Not set | LearnRefNumber | Learner2 | 777666555 | Not set | Not set | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | SD02 | 2016 | 1 | Unit Cost | Not set | Company Name | Company Name | Not set | Not set | Not set | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | SD03 | 2016 | 1 | Unit Cost | Not set | Other | Learner3 | 666555444 | Not set | Not set | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | ST01 | 2016 | 1 | Unit Cost Deduction | Not set | LearnRefNumber | Learner4 | 555444333 | Not set | Not set | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | NR01 | 2016 | 1 | Funding Adjustment | Not set | Authorised Claims | description of claim | Not set | Not set | 5000 | Not set | Not set | Not set | Not set |
| CCCCCCCCCCCCCCCCCCCC | RQ01 | 2016 | 1 | Funding Adjustment | Not set | Audit Adjustment | description of adjustment | Not set | Not set | -1000 | Not set | Not set | Not set | Not set |