Payroll deductions summary — free Excel template
A free payroll deductions register: gross pay broken out into income tax, social security, pension and anything else withheld, down to net pay. Download it to audit a pay run by hand, or parse your payslips and export every deduction into its own column.
What’s inside the payroll deductions summary
The template is a single ready-to-use sheet with a frozen header row and one column per field. Its columns are:
- Employee
- Employee ID
- Pay date
- Gross pay
- Income tax
- Social security
- Pension
- Other deductions
- Net pay
How to use this template
Two ways. Fill it in by hand as a plain spreadsheet — or, to skip the typing, upload your payslips to ParseForMe, pick this template as your export format, and the parsed data lands in these columns automatically. Map the fields once and every future document reuses the layout.
Who it’s for
Payroll and finance teams reconciling what was withheld against what was remitted, and accountants checking a pay run line by line before filing.
Frequently asked questions
Is the Payroll deductions summary template free?
Yes — download the .xlsx and use it however you like. No signup is required just to download the template.
How do I fill it in automatically?
Upload your payslips to ParseForMe, then choose this template as your export format. Your parsed data lands in these exact columns — no manual typing.
Can I change the columns?
Yes. Edit the spreadsheet freely. If you re-upload your edited version as your export template, ParseForMe maps the parsed fields to your columns.
Try it on your own document
Drop a document to see the structured data come back.