How to Convert UK Payslips to CSV or Excel
Convert UK payslips with PAYE, National Insurance, and pension data to CSV or Excel. Works with Sage, Xero, and BrightPay formats.
UK payslips contain a unique set of fields that differ from their US counterparts. Between PAYE income tax, National Insurance contributions, workplace pension auto-enrolment, and student loan repayments, a British payslip packs a lot of financial detail into a single document. When you need that data in a spreadsheet — for self-assessment, mortgage applications, or switching accountants — a reliable conversion tool saves hours of manual data entry.
Quick Summary: UK payslips have fields you will not find on US paystubs — tax codes, NI categories, pension auto-enrolment, and student loan repayments. StubToCSV recognises all of these and extracts them into clean CSV or Excel format. Works with Sage, Xero, BrightPay, IRIS, and Moneysoft payslips.
How UK Payslips Differ from US Paystubs
If you are familiar with American paystubs, UK payslips follow a different structure driven by HMRC regulations. Here are the key differences:
| Feature | UK Payslip | US Paystub |
|---|---|---|
| Income tax system | PAYE with tax codes (e.g., 1257L) | Federal withholding based on W-4 |
| Social contributions | National Insurance (NI category letter, e.g., A) | Social Security + Medicare (FICA) |
| Retirement | Workplace pension auto-enrolment (typically 5% employee, 3% employer) | 401(k) / 403(b) (voluntary, variable rates) |
| Student loans | Deducted through payroll (Plan 1, 2, 4, or Postgraduate) | Not payroll-deducted |
| Statutory payments | SSP, SMP, Statutory Paternity Pay | FMLA (unpaid), state-specific programs |
| Tax year | April to March | January to December |
Important: Your payslip shows your tax code (like 1257L), which determines your tax-free allowance and the rate applied to the rest of your earnings. This is fundamentally different from the US system. If your tax code is wrong, you could be overpaying or underpaying PAYE all year — converting your payslips to a spreadsheet makes it easy to spot this.
Common UK Payroll Providers and Their Formats
UK payslips come from a variety of payroll platforms, and each produces slightly different PDF layouts:
| Provider | Typical Users | Layout Style |
|---|---|---|
| Sage Payroll | Most common UK payroll software, especially SMEs | Structured grid with clearly separated earnings, deductions, and NI sections |
| Xero Payroll | Modern small businesses and accountants | Clean, minimal, straightforward table format |
| BrightPay | Payroll bureaux and accountants | Detailed NI calculations and pension breakdowns |
| IRIS Payroll | Larger organisations and payroll service providers | Can be complex with multiple pages for many pay elements |
| Moneysoft | Smaller employers using desktop payroll | Compact but includes all mandatory fields |
Each of these providers generates PDFs with different layouts, column positions, and label conventions. A conversion tool needs to handle this variation rather than relying on a single fixed template.
Tip: Not sure which payroll provider your employer uses? Check the header or footer of your payslip PDF — most providers include their branding or software name somewhere on the document. Either way, StubToCSV handles all major UK formats automatically.
Why Convert UK Payslips to Spreadsheets
There are several compelling reasons to get your payslip data out of PDFs and into a structured format.
Self-assessment tax returns. If you have income from multiple sources, freelance work alongside employment, or need to claim expenses, having your payslip data in a spreadsheet lets you reconcile PAYE deductions against your total tax liability before submitting your self-assessment to HMRC.
Mortgage and rental applications. Lenders and letting agents typically ask for three to six months of payslips. Having this data in a clean spreadsheet alongside your bank statements creates a complete income picture that is easy to reference during the application process.
Switching accountants. When you move to a new accountant, they need your payroll history in a workable format. A single CSV file with dates, gross pay, deductions, and net pay is far more useful than a stack of PDFs.
Year-end reconciliation. Comparing your final payslip YTD figures against your P60 is an essential check. Spreadsheet format makes it easy to verify that cumulative PAYE, NI, and pension figures match what your employer reports to HMRC.
Visa and immigration applications. UK visa applications often require detailed proof of income. Having payslip data organised in a spreadsheet alongside bank statements supports a thorough application.
Pro Tip: For self-assessment, convert all payslips from April to March (the UK tax year) to get a complete dataset. This is different from the US calendar-year approach and catches people out every year.
Step-by-Step: Converting Your UK Payslip
Converting a UK payslip to CSV or Excel takes under a minute with AI-powered extraction:
-
Gather your payslip PDFs. Download them from your employer’s payroll portal or HR system. Most UK employers now provide digital payslips through platforms like Sage HR, Xero Me, or BrightPay Connect.
-
Upload to the converter. Go to StubToCSV’s payslip converter and drag your PDF onto the upload area.
-
AI processes the document. The dual-AI extraction system reads your payslip layout, identifies UK-specific fields (tax code, NI number, pension contributions, student loan deductions), and structures everything into clean rows and columns.
-
Review the extracted data. Check the preview to confirm all fields are captured correctly. The AI handles variations between Sage, Xero, BrightPay, and other UK payroll formats automatically.
-
Download your file. Choose CSV format for data import or Excel format if you want to add formatting, formulas, or pivot tables.
Note: Your documents are processed by AI in real-time and never stored, so your National Insurance number and salary details remain private throughout the conversion.
What Fields Are Extracted from UK Payslips
A thorough UK payslip conversion captures all of these categories:
| Category | Fields |
|---|---|
| Employee details | Name, NI number, employee number, department |
| Pay period | Pay date, tax period, tax year |
| Earnings | Basic pay, overtime, bonuses, commission, allowances |
| Tax | Tax code, PAYE deducted, cumulative tax paid |
| National Insurance | NI category, NI contributions (employee and employer where shown) |
| Pension | Employee contribution, employer contribution, scheme type |
| Other deductions | Student loan, childcare vouchers, cycle to work, union fees |
| Totals | Gross pay, total deductions, net pay, YTD figures |
Tip: If your payslip includes employer contributions (employer NI, employer pension), these will be extracted as separate fields. They are useful for understanding your total compensation cost but should not be included when calculating your personal deductions or net pay.
Tips for UK Payslip Conversions
-
Check your tax code. After conversion, verify that the extracted tax code matches what is on your payslip. An incorrect tax code in your records could mask an underpayment or overpayment of PAYE that needs correcting with HMRC.
-
Convert a full tax year. For self-assessment, convert all payslips from April to March (the UK tax year) so you have a complete dataset. This makes it straightforward to verify your P60 totals and identify any discrepancies.
-
Keep NI records. Your National Insurance contributions affect your State Pension entitlement. Maintaining a spreadsheet of NI contributions by tax year provides a personal record you can cross-check against your HMRC online account.
-
Separate employee and employer contributions. When analysing pension data, make sure you are looking at the right column. Your employee contribution is what comes out of your pay; the employer contribution is additional and does not reduce your take-home pay.
Warning: If your tax code changes mid-year (common after a job change, marriage, or HMRC review), your payslips will reflect different tax calculations before and after the change. When summing PAYE across the year, this is expected behaviour — but it can look like an error if you are not aware of it. Compare your total against your P60 to confirm everything reconciles.
Key Takeaway: UK payslips have a distinct structure driven by PAYE, National Insurance, and pension auto-enrolment rules that US-focused tools often miss. StubToCSV’s AI extraction recognises all UK-specific fields and handles the format differences across Sage, Xero, BrightPay, and other providers automatically — giving you clean, accurate spreadsheet data for self-assessment, mortgage applications, or any other purpose.
Get Started
Need your UK payslips in spreadsheet format? Try the payslip to CSV converter or payslip to Excel converter. Three free conversions per month, no account required — just upload your PDF and download the result.