• Find us on:

Schedule of loss spreadsheet for unfair dismissal claims

This Excel Spreadsheet has been developed specifically for an unfair dismissal claim. Use it with the guide on How to prepare your Schedule of Loss for the Employment Tribunal to calculate your Basic and Compensatory Award with precision. With this spreadsheet, your heads of loss are easy to calculate with formulas for adjustments such as the ACAS uplift and grossing up options.



Use this spreadsheet to calculate your schedule of loss for unfair dismissal.The schedule of loss is also called the statement of remedy. The Employment Judge will ask you to prepare one at your first preliminary hearing. It is used to tell the Employment Tribunal how much compensation you believe you are entitled to. Your compensation is calculated under “heads of loss”, and there is a different type of calculation for the different types of loss that you can claim. Your schedule of loss will show how much you are claiming under each head of loss. Losses are calculated on gross pay for the Basic Award and net pay for the Compensatory Award. The schedule of loss is made up of;

  1. The Basic Award
  2. The Compensatory Award.

The following heads of loss come under the Compensatory Award;

  • Wages/Salary due
  • Payment in lieu of notice
  • Outstanding holiday pay
  • Past loss of earnings
  • Future loss of earnings
  • Loss of future pension entitlements





You may also like…


The information and content on this website is provided for general information purposes only and is not intended to constitute legal or other professional advice. Legal information or content on this website relates only to the laws of England and Wales. You should not take any actions based on information found on this website without first seeking appropriate legal advice with respect to your specific matter. No representations or warranties are made about the suitability, currentness, comprehensiveness and/or accuracy of the information and other content contained on this website. It should be noted that legal information and content can rapidly become out of date and we give no undertaking to keep this website up to date. All liability for any loss or damage of any kind which may be suffered as a result of accessing and using the information and/or content of this website is hereby excluded to the full extent permitted by law.