Job Retention Scheme Claim Calculator

Here is the link to the HMRC Government Calculator, which you should use to calculate your furlough reimbursement.

We have created the spreadsheets below for you to use to check the government website calculations.

WEEKLY PAID EMPLOYEE

November 2020 to June 2021 Furlough Claim Calculator - Weekly Paid - Use this spreadsheet to calcuate any furlough for weekly paid employees from November 2020 to June 2021.

July 2021 Furlough Claim Calculator - Weely Paid - Use this spreadsheet to calcuate any furlough for weekly paid employees for July 2021.

August & September 2021 Furlough Claim Calculator - Weekly Paid - Use this spreadsheet to calcuate any furlough for weekly paid employees for August and September 2021.


MONTHLY PAID EMPLOYEE

November 2020 to June 2021 Furlough Claim Calculator - Monthly Paid - Use this spreadsheet to calculate any furlough for monthly paid employees in November 2020 to June 2021 - including normal furlough, part-time, return to work, leaving employment etc.

July 2021 Furlough Claim Calculator - Monthly Paid - Use this spreadsheet to calculate any furlough for monthly paid employees in July 2021 - including normal furlough, part-time, return to work, leaving employment etc.

August & September 2021Furlough Claim Calculator - Monthly Paid - Use this spreadsheet to calculate any furlough for monthly paid employees in August and September 2021 - including normal furlough, part-time, return to work, leaving employment etc.

When using either of these spreadsheets, you will see that there is an 80% furlough tab and a 100% furlough tab. You will need to use the appropriate sheet for whether you kept your employee on 100% or reduced their pay to 80%. These sheets are able to calculate part months (so part on full pay and part on furlough) but they cannot accomodate any unusual items on the payroll.

Our spreadsheets (however great their accuracy) is designed to be used as a checking tool for you, we do not take any responsibility for calculation errors that result from this.

HISTORICAL CALCULATORS

2019/2020 Tax Year Calculator - Use this spreadsheet to calcuate any furlough for monthly paid employees in March 2020.

2020/2021 Tax Year Calculator (April-June 2020) - Use this spreadsheet to calculate any furlough for monthly paid employees from April 2020 to June 2020.

2020/2021 Tax Year Calculator (July 2020) - Use this spreadsheet to calculate any furlough for monthly paid employees in July 2020.

2020/2021 Tax Year Calculator (August 2020) - Use this spreadsheet to calculate any furlough for monthly paid employees in August 2020.

2020/2021 Tax Year Calculator (September 2020) - Use this spreadsheet to calculate any furlough for monthly paid employees in September 2020.

2020/2021 Tax Year calculator (October 2020) - Use this spreadsheet to calculate any furlough for monthly paid employees in October 2020 - including normal furlough, part-time, return to work, leaving employment etc.

2020/2021 Tax Year Return to Work Calculator (April-June 2020 return) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work between April 2020 to June 2020 for the month they return to work.

2020/2021 Tax Year Return to Work Calculator (July 2020 return) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work in July 2020 for the July 2020 payroll. 

2020/2021 Tax Year Return to Work Calculator (August 2020 return) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work in August 2020 for the August 2020 payroll.

2020/2021 Tax Year Return to Work Calculator (September 2020 return) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work in September 2020 for the September 2020 payroll. 

2020/2021 Tax Year Part-Time Furlough Calculator (July 2020) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work part-time in July 2020 for the July 2020 payroll. 

2020/2021 Tax Year Part-Time Furlough Calculator (August 2020) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work part-time in August 2020 for the August 2020 payroll.

2020/2021 Tax Year Part-Time Furlough Calculator (September 2020) - Use this spreadsheet to calculate furlough pay for monthly paid employees who return to work part-time in September 2020 for the September 2020 payroll.

2019/2020 Tax Year Calculator - Use this spreadsheet to calcuate any furlough for weekly paid employees in March 2020.

2020/2021 Tax Year Calculator - Use this spreadsheet to calculate any furlough for weekly paid employees in April 2020 onwards.