This website uses cookies to store information on your computer. Some of these cookies are used for visitor analysis, others are essential to making our site function properly and improve the user experience. By using this site, you consent to the placement of these cookies. Click Accept to consent and dismiss this message or Deny to leave this website. Read our Privacy Statement for more.
News & Portal: HMRC

100+employees CJRS HMRC Templates

22 June 2020  
Posted by: HMRC
Share |

By HMRC 

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).

Published 19 June 2020 
From: HM Revenue & Customs

Documents

Template (XLS)
MS Excel Spreadsheet, 35KB 

Template (CSV)
View online Download CSV 150Bytes 

Template (ODS)
ODS, 3.74KB 
This file is in an OpenDocument format 

Template (XLSX)
MS Excel Spreadsheet, 11.2KB 

Details

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

  • 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’ll need to ensure that you:

  • provide only the employee information requested here - you might be asked again
  • 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)
  • upload your file as an .xls, .xlsx, .csv or .ods using the templates on this page when you claim

Published 19 June 2020


Get In Touch

The ICPA
Imperial House
1a Standen Avenue
Hornchurch
Essex RM12 6AA

0800 074 2896

01708 448884

Get The ICPA App

To download the ICPA APP, just click on the image below...

Keyword Search
Follow Us

Follow the ICPA on a range of popular Social Networking websites including Facebook, Twitte and LinkedIn.