Guidance

COLLECT guidance on completing the section 251 budget return

Updated 12 October 2023

Applies to England

Summary

This publication provides non-statutory guidance from the Education and Skills Funding Agency. It has been produced to help local authority finance officers to complete their section 251 budget returns using the COLLECT system.

Expiry or review date

This guidance will be reviewed before March 2024.

Who is this publication for?

This guidance is for local authority finance officers.

Accessing COLLECT

Access to COLLECT is via DfE Sign-in. If you do not have an account you will need to create one.

You can then request access to your organisation and COLLECT on the ‘Organisations’ tab.

Image of the 'Request access to an organisation' link on DfE Sign-in

Your request will be sent to your organisation’s approvers. If you have already been added to your organisation, you can request access to COLLECT on the ‘Services’ tab.

Image of the 'Request access to a service' link on DfE Sign-in

If you have COLLECT access but are unable to see the budget collection, check with one of your organisation’s approvers whether you have been given access to the collection. You can find out who these are on the ‘Services’ tab under ‘See approvers at an organisation’.

Image of the 'Request access to a service' and 'See approvers at an organisation' links on DfE Sign-in

If you still need assistance, please submit a query using the data collections service request form.

Uploading an XML file

On the ‘Source’ page, select ‘Upload Return from file’.

Image of 'What can I do with my data return?' menu, with 'Upload return from file' highlighted

To upload the return, select ‘Browse’ to navigate to the required XML file. You then need to select ‘Upload’ to load the data.

This image highlights the 'Browse' and 'Upload' buttons on the COLLECT portal

If data is already loaded, you will be asked if you want to overwrite it. Answering ‘no’ will stop the data load, answering ‘yes’ will delete the existing data and load the new data.

Caution: uploading a new XML file will cause the return to be revalidated and any errors/queries will need to be addressed again.

Once the file has been successfully uploaded, the following message will appear:

COLLECT portal message ''Your data return has successfully loaded and is queued for validation. Please return later to view any validation errors identified and Submit your Return'

The data return has now been placed in a queue to be validated. When COLLECT is busy this process may take some time and users may come back later to view any validation errors present within the return.

When you select ‘OK’ you will return to the ‘Source page’ and the status will be ‘Waiting_for_validation’. When the return reaches the front of the queue, the status on the ‘Source page’ will change to ‘Validation_in_progess’ and then ‘Loaded’ when it is finished.

Addressing errors and queries

When a return has been uploaded, a number of validation checks are run against the data in that return and will trigger errors or queries. All errors and queries are highlighted in red against the relevant data item.

Viewing all errors and queries on the return

Select ‘All Errors’ at the top of the screen.

Image of options 'All Errors', 'All Notes', 'Add', 'View', 'Edit' and 'Delete' tabs with 'All Errors' tab circled

You will then be shown a list of all errors and queries relating to your return. You may also find it helpful to download an error report.

Image of all errors and queries relating to the data return on the COLLECT portal

Correcting errors

Select the ‘Details’ button to see which data items the validation is checking, these will shown to the right of the screen. If you select one of the underlined fields you will be directed to the corresponding data item in the return.

Change the mode of the form to ‘edit’ and then select the data item that needs to be changed and update it.

Providing clarification/ supplementary information

If you are satisfied that the value is correct, please enter a brief but meaningful note next to the error/query (rather than ‘OK’ or ‘Correct’ etc.).

To enter a note, first select the pen icon next to the error/query.

Image shows error message and circled pen icon to show where to add a note within the 'Notes' field

Then select ‘Add New Note’.

Image shows page from COLLECT Portal with 'Add new note' circled to show how to add a new note

Type your note into the box provided and select ‘Create’.

Image shows 'Create New Note' page with 'Create' circled in the bottom right hand corner

You must enter a note for all errors/queries, except year-on-year queries (3.1.1 and 1007).

For year-on-year queries you may either enter a note or use the drop-down menu at the bottom of the screen to confirm the figure is correct.

Image of year on year queries drop-down menu

To return to the list of errors, select the ‘Error’ button.

Image of 'Error' button circled

Editing data within your return

LA Table

Use the blue hyperlinks at the bottom of the screen to navigate to the part of your return you wish to edit.

Caution: Using the hyperlinks on the left-hand side may result in unexpected behaviour.

Image of LA Table

Change the mode of the form to ‘edit’ and then select the data item that needs to be changed and update it.

Select ‘View’ followed by ‘Drill Up’ to return to the previous screen.

High Needs Places Table

Select the appropriate hyperlink to take you to the High Needs Places Table.

Use the ‘Edit’ button to edit the data or the ‘Add’ or ‘Delete’ buttons to add or remove schools from the table.

Image of 'Add' 'View', 'Edit' and 'Delete' buttons

Select ‘View’ followed by ‘Drill Up’ to return to the previous screen.

EY Table

Select the appropriate hyperlink to take you to the required section of the EY Table.

Select ‘Click to view individual column descriptors’. This will allow you to view the data entered for this line.

Image of EY Table with 'Click to view individual column descriptors' circled

Use the ‘Edit’ button to edit the data or the ‘Add’ or ‘Delete’ buttons to add or remove rows.

Image of 'Add' 'View', 'Edit' and 'Delete' buttons

Select ‘View’ followed by ‘Drill Up’ to return to the previous screen.

Downloading reports

On the ‘Source Page’, select ‘Launch Reports’.

Image of the source page with 'Launch Reports' button circled

Select the relevant report and then ‘Launch Report’.

Image of Reports page with 'Launch Report' button highlighted

Export the report in the desired format.

Image of the following drop down options: 'Word', 'Excel', 'PowerPoint', 'PDF', 'TIFF file', 'MHTML (web archive)', 'CSV (comma delimited)', 'XML file with report data' and 'Data feed' to export the report

Submitting your return

Return to the ‘Source Page’ by clicking on ‘Back to My COLLECT page’ at the top of the form.

Image to highlight the 'Back to my COLLECT page' option on the COLLECT portal

Then select ‘Submit Return’.

Image of the 'What can I do with My Data Return?' menu with 'Submit return' button circled