First page of the P11D Benefits in Kind TrackerExcel workbook preview

UK tax (HMRC)

P11D Benefits in Kind Tracker

P11D benefits in kind tracker in Excel: P11D sections A to N, car and fuel benefit, Class 1A National Insurance, payrolled items and the 6 July deadline.

Excel workbook · 21 KB Built on free official texts

3 free downloads per account. Just your email and a 6-digit code.

Need more than 3? Every template for $249, once. Lifetime access, including the templates we add later. See pricing

About this template

Employers report taxable expenses and benefits given to employees and directors on form P11D, and the Class 1A National Insurance on them on form P11D(b), by 6 July after the tax year. Class 1A is then paid by 22 July if paid electronically. Payroll and finance teams need one list that captures every benefit, values it correctly, and shows which items were payrolled instead.

This workbook tracks each benefit by P11D section, works out the taxable value after amounts made good, and calculates Class 1A at the rate in the settings. Car and fuel benefit follow HMRC's P11D working sheet 2 for 2025 to 2026, and the summary gives totals per section and per employee. Figures come from gov.uk guidance and sit in dated input cells. It also flags the mandatory payrolling of benefits from April 2027.

Who it is for

The payroll manager or financial accountant who must file P11Ds and the P11D(b) by 6 July and has benefits scattered across invoices, payroll and expense claims.

What is inside

  • Benefits register with 14 worked items for the 2025 to 2026 tax year and 22 blank rows
  • P11D section dropdown with all 14 sections, A to N
  • Taxable value, Class 1A and the P11D or payrolled result by formula on every row
  • Car and fuel sheet following P11D working sheet 2: capital contribution cap, unavailable days, private use payments and fuel benefit
  • Settings sheet with 12 rates and limits for 2025 to 2026, each with its gov.uk source, and the deadlines by formula
  • Summary sheet per P11D section and per employee, with the Class 1A total for the P11D(b)
  • Flags for trivial benefits over the limit and open items, and a note on mandatory payrolling from April 2027

How to use it

Check every figure on the Settings sheet against gov.uk for the tax year you report, then enter each car on the Car and fuel sheet and each benefit on the register.

Files

  • XLSXp11d-benefits-in-kind-tracker.xlsx21 KB

Opens in Microsoft Word or Excel, Google Docs or Sheets, and LibreOffice. Built on free, official texts that anyone can read: laws, regulations, standards and guidance published by public bodies. A template to adapt, not legal, tax or accounting advice.

Questions about this template

When are the P11D and P11D(b) due?

gov.uk says employers must report expenses and benefits, give employees a copy and report the Class 1A National Insurance owed by 6 July after the end of the tax year. Class 1A must reach HMRC by 22 July if paid electronically or 19 July by cheque. A late P11D(b) costs GBP 100 per 50 employees for each month or part month.

Do payrolled benefits go on a P11D?

No. HMRC's guidance on completing P11D says you do not submit a P11D for benefits taxed through payroll. You still file a P11D(b) so that you can pay the Class 1A National Insurance due. From 6 April 2027 cars, fuel, vans and medical insurance must be payrolled, and most other benefits from 6 April 2028.

What is a trivial benefit?

gov.uk says a benefit is trivial, and need not be reported, if it cost GBP 50 or less to provide, is not cash or a cash voucher, is not a reward for work or performance and is not in the employee's contract. Directors of close companies are limited to GBP 300 of trivial benefits in a tax year.