Form

Download a template if you're claiming for 16 or more employees through the Coronavirus Job Retention Scheme

Complete a template with the details of the employees you're claiming for and upload this when you claim (for claims on or after 1 July 2020).

From:
HM Revenue & Customs
Published
19 June 2020
Last updated
29 October 2021 — See all updates

Documents

Template (XLSX)

MS Excel Spreadsheet, 154 KB

Template (CSV)

CSV, 169 Bytes

View online

Details

The Coronavirus Job Retention Scheme ended on 30 September 2021.

If you’re claiming on or after 1 July 2020 for 16 or more employees, you’ll need to upload a file containing the following information for each employee:

  • full name
  • National Insurance number (or payroll reference number if you do not have this)
  • payroll reference number (sometimes called a pay identify or staff number)
  • furlough start and end date (using the format DD/MM/YYYY)
  • full amount claimed (pounds and pence)
  • normal hours (using decimals, for example 7.5)
  • actual hours worked (using decimals)
  • furloughed hours (using decimals)

You must upload the template in .xlsx or .csv format when you claim. If you already have the claim forms saved in a different format (such as .xls or .ods), you must save them again as .xlsx or .csv files. The other formats are no longer accepted.

Your template may be rejected if you do not give the information in the right format. If your template is rejected, you’ll see a message on the screen and your claim will not be processed.

You’ll need to make sure you:

  • provide only the employee information requested here - you might be asked again or your template may be rejected
  • submit one line per employee for the whole period
  • do not break up the calculation into multiple periods within the claim
  • do not split data by contract type (for example, those paid weekly and monthly should be claimed for together)
  • do not provide more or less columns than needed
  • upload your file as a .xlsx or .csv (or you can save existing .xls or .ods file types as .xlsx or .csv before uploading them)

Updates to this page

Published 19 June 2020
Last updated 29 October 2021 + show all updates

  1. Updated information because the Coronavirus Job Retention Scheme ended on 30 September 2021.

  2. Welsh translation has been added.

  3. These templates have been updated.

  4. The templates to use when claiming for 16 or more employees have been updated. The guidance for uploading these templates has been updated.

  5. The 'Check Your Data' tab for the Template XML and Template XMLS attachments have been updated.

  6. The XLS and XLSX templates used for submitting a claim for 100 or more employees have been updated.

  7. The templates used for submitting a claim for 100 or more employees have been updated. Employers must now include if an employee has returned from statutory leave before being put on furlough.

  8. Details section updated to tell employers using the template that it may be rejected if the information provided is not given in the right format.

  9. First published.

Sign up for emails or print this page