salary slip excel international payroll how-to

How to Convert a Salary Slip PDF to Excel

Convert salary slip PDFs to Excel format with AI-powered extraction. Works with international payroll formats from India, UAE, UK, and more.

A salary slip — the term used in much of the world outside the United States for what Americans call a pay stub — documents your monthly earnings, deductions, and net pay. Whether you are working in India, the UAE, Singapore, the UK, or anywhere else that uses the term “salary slip,” converting these documents from PDF to Excel gives you structured data for tax filing, visa applications, loan documentation, and personal financial planning.

Quick Summary: Upload your salary slip PDF to StubToCSV for AI-powered extraction to Excel. Handles international payroll formats including Indian CTC structures, UAE WPS slips, UK PAYE payslips, and more. Dual-verified in under 30 seconds.


Salary Slip Formats by Country

Salary slips vary significantly by country due to different tax systems, mandatory contributions, and employment regulations.

CountryKey ComponentsUnique Elements
IndiaBasic salary, HRA, DA, PF, professional taxCTC breakdown, HRA exemption
UAEBasic salary, housing allowance, transportWPS-compliant, no income tax
UKGross pay, PAYE tax, National Insurance, pensionTax code, NI number
SingaporeBasic salary, CPF contributions, allowancesCPF employer and employee share
CanadaGross pay, CPP, EI, federal/provincial taxTwo levels of income tax
AustraliaGross pay, PAYG tax, superannuationSuper guarantee percentage
GermanyBruttolohn, Lohnsteuer, SozialversicherungChurch tax, solidarity surcharge

Note: StubToCSV’s AI reads the salary slip contextually, so it adapts to the specific format and terminology of each country’s payroll system automatically.


Step-by-Step Conversion

  1. Download your salary slip PDF. Access your employer’s HR portal, payroll system, or email where salary slips are distributed. Download the PDF for the month you need.

  2. Upload to StubToCSV. Visit the salary slip to Excel converter and upload your PDF.

  3. AI extraction processes the document. Dual-AI verification extracts every field — earnings components, statutory deductions, employer contributions, and net pay. Under 30 seconds.

  4. Review and download. Check the structured data and download as Excel.

Tip: Many international employers distribute salary slips via email. Save these PDFs before converting — email attachments are the most common source of salary slip PDFs globally.


Indian Salary Slip: CTC Breakdown

Indian salary slips are particularly complex because of the Cost to Company (CTC) structure, which breaks compensation into numerous components.

ComponentCategoryTax Treatment
Basic SalaryEarningsFully taxable
HRAAllowancePartially exempt under Section 10(13A)
Dearness Allowance (DA)EarningsFully taxable
Special AllowanceEarningsFully taxable
ConveyanceAllowanceExempt up to limit
Medical AllowanceAllowanceExempt up to limit
PF (Employee)DeductionTax-deferred
PF (Employer)ContributionNot shown in net pay
Professional TaxDeductionState-level tax
TDSDeductionFederal income tax
ESIDeductionIf applicable

Converting an Indian salary slip to Excel is especially valuable because the CTC structure makes manual tracking difficult. With 10-15 components per slip, having the data in a spreadsheet lets you verify HRA exemptions, track PF accumulation, and ensure TDS aligns with your tax liability.


UAE Salary Slip: WPS Format

UAE salary slips are simpler from a tax perspective (since the UAE has no income tax) but are critical for banking, visa renewals, and loan applications.

ComponentPurpose
Basic SalaryCore compensation, used for gratuity calculation
Housing AllowanceOften 25-30% of package
Transport AllowanceFixed monthly amount
Other AllowancesEducation, phone, etc.
DeductionsAbsence, advances, insurance
Net PayWPS transfer amount

Important: In the UAE, the ratio of basic salary to total salary matters significantly for gratuity calculations. Converting your salary slip to a spreadsheet lets you track this ratio and estimate your end-of-service gratuity accurately.


Why Convert Salary Slips to Excel?

Use CaseHow Spreadsheet Helps
Visa applicationsMany countries require income documentation in organized format
Loan applicationsBanks want consistent income proof; spreadsheet shows averages
Tax filing (India, UK, etc.)Verify TDS/PAYE against annual tax computations
Relocation planningCompare salary components across countries
Financial planningTrack take-home pay trends, savings rate, tax burden
Employment verificationClean documentation for background checks

Pro Tip: If you are relocating internationally, convert your current salary slips and your new offer’s expected salary slip into the same Excel format. This lets you do an apples-to-apples comparison of gross pay, taxes, mandatory contributions, and take-home pay between countries.


Tips for International Salary Slips

  1. Watch for currency formatting. Different countries use different decimal and thousands separators. Indian slips use commas (1,00,000 for one lakh), while most other countries use standard notation (100,000). StubToCSV handles these formatting differences.

  2. Track mandatory contributions. PF in India, CPF in Singapore, Super in Australia, NI in the UK — these are mandatory savings that affect your take-home pay but build long-term wealth. Track them in your spreadsheet.

  3. Convert annually for tax filing. In countries with annual tax filing (like India), converting all 12 monthly slips gives you a complete dataset for verifying Form 16 or equivalent tax statements.

  4. Keep records for visa applications. Many immigration processes require 3-6 months of salary documentation. Maintaining converted salary slips in a spreadsheet ensures you always have this documentation ready.


Get Started

Convert your salary slip to Excel with StubToCSV. AI-powered extraction handles salary slips from India, UAE, UK, Singapore, and 50+ countries. Dual verification ensures accuracy regardless of format. Try it free — Pro plans available.