Extract UK P11D Data to Excel — Benefit Values into One HMRC-Ready Spreadsheet
P11D season means pulling the two or three populated benefit sections off every employee's draft and typing them into a spreadsheet before the 6 July deadline. Doing that by hand takes around 3 minutes per form — this reads the cash equivalents by what each HMRC section means and drops them into an Excel row in about 5–10 seconds, blank sections left genuinely blank.
Enterprise-grade security · TLS 1.3 encrypted
What You Can Pull from a UK P11D Draft
HMRC organises the P11D into 14 lettered sections (A–N), each covering a benefit category with its own valuation rule — company cars (F), medical cover (G), beneficial loans (H), vans (I), relocation (N). Type the columns you need and the AI finds each cash equivalent by what the section label means, wherever it appears on a Sage, BrightPay, Xero, or IRIS draft.
You define the output — the AI reads the document. Add any section your employees' drafts contain; the list above is the starting set most UK employers need to total their P11D(b).
Why P11D Extraction Fails on Position — and Works on Section Meaning
A P11D is not a bill you read top to bottom — it is a sparse form with up to 14 benefit sections, and every employee's copy is empty in a different place. Payroll software exports it only as a PDF, positions differ between systems, and a mistyped figure flows straight into the Class 1A National Insurance total on the P11D(b). That sparseness and those cross-system differences are exactly what position-based tools get wrong.
The Problem
A director has Sections F, H, and I populated; a field engineer only Section G; an office manager just medical cover. You are not reading the same boxes on every page — you are hunting for whichever two or three of the fourteen sections carry a value, and skipping the empty ones without mistaking a blank for a zero (a zero inflates your Class 1A total).
HMRC mandates the data content of a P11D, not its visual layout, so a Sage draft stacks sections differently from BrightPay or a bureau's own template. A template trained on one provider's coordinates misreads the others — the same reason a payroll team on Reddit describes the annual P11D dance that "catches people every year."
Many payroll systems — BrightPay is a documented example — generate P11Ds as PDF only, with no Excel or CSV export; the official guidance is to extract the figures manually. So the "data" you need for the P11D(b) sits in dozens of PDFs, not in your spreadsheet, and someone has to type it out.
How Custom Column Extraction Solves This
Custom Column Extraction means you type the fields you want — "Car Cash Equivalent," "Medical Insurance Cash Equivalent," "Amount Made Good" — and the AI reads each value by what its section label means, wherever that label appears on the draft. No coordinates, no per-provider zones, no model training.
Because the AI only fills the columns it finds, an employee with just medical cover gets one benefit value and the car and loan columns stay empty. That keeps your Total Taxable Benefit and the Class 1A sum for the P11D(b) accurate — no phantom lines, no inflated liability.
Reading by meaning, not position, means the same column definitions work on a Sage draft, a BrightPay PDF, a bureau export, and a scanned paper copy from an earlier tax year — no re-template when someone switches payroll provider.
From a Stack of P11D Drafts to a Class 1A-Ready Spreadsheet, in Three Steps
If your HR or payroll team is preparing benefits reporting for the 6 July deadline, here is what the workflow looks like from upload to the spreadsheet you total for the P11D(b).
Upload the whole folder of drafts, as-is
Drop in every employee's P11D PDF, scan, or photo — even mixed sources from Sage, BrightPay, and a bureau. Batch processing runs them as one job and merges results into a single spreadsheet. If drafts live with an outsourced payroll bureau, share a Collection Link so they upload straight into your queue without an account.
Type the benefit columns you need
Name your columns once: "Employee Name," "NINO," "Car Cash Equivalent," "Car Fuel Cash Equivalent," "Medical Insurance Cash Equivalent," "Loan Cash Equivalent," "Amount Made Good," "Total Taxable Benefit." The AI reads each section by label meaning and fills the row — skipping sections this employee doesn't have. Add a computed column like "Net Taxable Benefit (Cash Equivalent − Amount Made Good)" and the net figure is filled in during extraction.
Download one Excel, one row per employee
Export XLSX or CSV. Sum the 1A-liable columns and multiply by the Class 1A rate (15% for 2025/26) to build the P11D(b) total. Review Mode highlights where each value came from on the original draft, so a spot-check before submission takes seconds instead of re-reading every form.
When P11D Extraction Works Best — and When to Verify the Output
When it works best
Payroll-generated drafts and clean scans. Sage, BrightPay, Xero or IRIS PDF exports and 200–300 DPI flatbed scans extract with high accuracy because the section labels are machine-printed.
Reading existing drafts, not generating returns. This extracts whatever is on the P11D you already have — it does not produce the form or compute the car's CO2-based cash equivalent for you. You pull the figures, you review them.
Batch processing a whole employee population. Upload many drafts at once and export one spreadsheet with a row per person — the shape your P11D(b) reconciliation actually needs.
When to be cautious
This extracts data — it does not file your P11D. The tool produces the structured spreadsheet; submitting to HMRC still goes through your payroll software or PAYE Online. Spot-check the figures before they feed a submission.
Low-quality scans and handwriting need a verification pass. Shadowed or angled phone photos may blur small printed figures, and hand-written entries reduce accuracy. Review Mode shows exactly which part of the draft each value came from before the numbers go anywhere.
The P11D's role is narrowing. Mandatory payrolling brings company cars and medical benefits into payroll from April 2027 and most other benefits in 2028, but loans, accommodation, and the 2026/27 filing round keep the P11D firmly in use.
Frequently Asked Questions
Can I pull just a couple of P11D sections instead of the whole form?
Yes — that is exactly how it works. Custom Column Extraction means you only get the columns you name: type "Car Cash Equivalent" and "Medical Insurance Cash Equivalent" and the output table has those two benefit columns plus whatever identity fields you asked for. If your company only provides those two benefits, you do not end up with a dozen empty columns for sections you never report.
Will empty sections be filled in as zero?
No. An empty benefit section is left blank rather than filled with 0. On a P11D, a blank section means "no benefit in this category," which is different from a benefit valued at zero. Filling empty sections with 0 would inflate your Total Taxable Benefit and distort the Class 1A National Insurance total that feeds your P11D(b), because those 0 values get summed as if they were real benefits.
Do I need both the Cash Equivalent and the Amount Made Good?
For an accurate P11D(b) total, usually yes. Within a section, the cash equivalent is the taxable value of the benefit and the amount made good is any contribution the employee paid toward it — and the figure that actually flows to HMRC is cash equivalent minus amount made good. A computed column like "Net Taxable Benefit (Cash Equivalent − Amount Made Good)" fills that in during extraction, so the number you sum is already net of employee contributions, one of the more common manual-aggregation slips.
Does it handle scanned or photographic P11Ds?
Yes, as long as the printed text is legible to a human eye. The AI reads the section label by meaning, so a scanned paper form is treated the same as a payroll-software PDF. A clean 200–300 DPI flatbed scan performs best; if the only copy is a shadowed phone photo, expect to verify the small-print figures in Review Mode rather than trusting them at face value.
Will I still need this after mandatory payrolling of benefits starts?
For now, yes. Mandatory payrolling is phased in: company cars, fuel, vans and employer-provided medical benefits move to payroll from April 2027, and most other benefits follow in April 2028. Employment-related loans and living accommodation stay reportable on a P11D, and the full traditional P11D/P11D(b) process runs for tax year 2026/27 (filing by 6 July 2027). So the form — and the need to get its figures into a spreadsheet — remains in use for those categories and that filing round.