Map Extract
Free tool

Turn payslip PDFs into a CSV summary

A director paying themselves through a small company, a bookkeeper checking a client's payroll, or anyone gathering a year of payslips for a mortgage or tenancy application can pull the key figures from up to 50 PDF payslips into one spreadsheet-ready table.

Runs in your browser. Nothing you enter is uploaded.

Summarising payslips

  1. Choose the payslips

    Select up to 50 PDF payslips at once. More can be added afterwards; they are appended to the same table.

  2. Let them be read

    Each file's text is read and the usual payslip labels are looked for: pay date, tax code, gross pay, income tax, National Insurance, student and postgraduate loan, pension and net pay.

  3. Check the table

    One row per payslip, with totals of gross, tax and NI and net pay above it. Look at the Unexplained column first.

  4. Download

    Press Download CSV for payroll-summary.csv, which opens in Excel, Google Sheets or accounting software. Clear empties the table.

Example: one month's payslip

This fictional payslip from a small sign-making company was read by the same parser the tool uses. Gross pay less the deductions found equals the net pay exactly, so the unexplained difference is zero.

When we removed the student loan line from the same text, the check showed £36.00 unexplained: the signal that a deduction was missed or the payslip has an item the parser does not recognise.

Input
Pay date 28/10/2026, Tax code 1257L
Gross pay 2,450.00, Income tax 281.80, National Insurance 98.56
Pension 122.50, Student loan 36.00, Net pay 1,911.14
Result
File,Employee,Pay date,Period,Tax code,NI number,Gross,Income tax,Employee NI,Student loan,Postgraduate loan,Pension,Net pay,Unexplained difference
october.pdf,,28/10/2026,,1257L,,2450.00,281.80,98.56,36.00,,122.50,1911.14,0.00

Reading the Unexplained column

The figure is gross pay minus every deduction the tool found minus net pay. Anything other than £0.00 means either another deduction exists on that payslip, such as a salary sacrifice, a union fee or a cycle-to-work scheme, or a figure was not read. Open that payslip and compare.

Payslip layouts vary between payroll providers, so some labels may not be recognised. The tool reads the text layer only: a scanned or photographed payslip has none and needs OCR first.

  • Check tax codes against the official guidance on GOV.UK if a code looks wrong; the tool reports codes, it does not judge them.
  • Keep the CSV as securely as the payslips themselves: it holds the same personal and financial details.

Questions people ask

How do I get figures from PDF payslips into Excel?

Choose the payslip PDFs here, check the table that appears and press Download CSV. Open the CSV in Excel or Google Sheets. Each payslip is one row with pay date, tax code, gross, income tax, NI, loans, pension and net pay, plus a column showing anything that does not add up.

What does the Unexplained difference mean?

It is gross pay minus the deductions found minus net pay. On a correctly read payslip with only standard deductions it is zero. A non-zero figure points to another deduction, such as salary sacrifice or a union subscription, or a value the tool did not read, so check that payslip.

Does it work with every payroll provider's payslips?

It works with payslips that are real text PDFs and use common UK labels such as Gross pay, Income tax, National Insurance and Net pay. Unusual layouts or wording may leave some figures blank. Scanned payslips need OCR first, because they contain only an image of the text.

Is it safe to put payslips into an online tool?

With this tool the payslips are not uploaded: they are opened and read by your browser on your own computer, and the CSV is built there. Payslips contain your NI number and pay, so keep the downloaded CSV somewhere secure and delete it when you no longer need it.

Where your data goes

Payslips are read in your browser and never uploaded. The text of each PDF is processed in your device's memory, the CSV is built locally, and closing or clearing the page removes the table.

Checked against the tool on

Top