Payslip Template Pakistan (Free Excel Download)

Pakistan Payslip Template (Free Excel Download)

A ready-to-use payslip template for Pakistani employers, with the country's statutory deduction lines built in: employee and employer EOBI contributions, the employer ESSI social security contribution, and income tax withheld per the FBR slabs. Copy it into Excel or Google Sheets and it is ready for your monthly payroll run.

How to Use This Template

1. Fill in the employer and employee header fields once — they stay the same every month.
2. Enter gross monthly earnings (basic salary plus allowances and overtime).
3. Apply the EOBI, ESSI and income tax lines exactly as shown — the calculation basis is described beside each line.
4. Issue one copy to the employee and keep one for your payroll records.

Pakistan Payslip Template

Employer: [Company Name] | EOBI Employer Reg. No.: [] Employee: [Full Name] | CNIC No.: [] Designation: [] | EOBI Insured Person No.: [] Pay Period: [Month / Year] | Payment Date: [DD/MM/YYYY]

Employer contributions (not deducted from employee):

Worked Example

Monthly gross salary: PKR 80,000 (no other allowances).

• EOBI employee: the current EOBI schedule applied to the notified wage (deducted)
• Income tax: withheld per the FBR slabs for the employee's tax bracket (deducted)
• Net pay: 80,000 − EOBI employee share − income tax
• EOBI employer: the current EOBI schedule applied to the notified wage (employer cost)
• ESSI employer: the provincial schedule applied to wages up to the ceiling (employer cost)
• Total employer cost: 80,000 + employer EOBI share + employer ESSI share

Statutory Notes for Pakistan Payroll

• EOBI (Employees Old-Age Benefits Institution) is the federal pension scheme — contributions come from both the employer and the employee, calculated on the notified wage per the current EOBI schedule.
• ESSI (Employees' Social Security Institutions) is administered by the provinces (Punjab, Sindh, Balochistan, Khyber Pakhtunkhwa) — the employer contributes on wages up to the provincial wage ceiling; confirm your province's schedule.
• Income tax is withheld by the employer each month under the FBR's salary slabs.
• The employer shares of EOBI and ESSI are company costs and must never be deducted from the employee's pay.
• Always verify the current EOBI contribution schedule, your province's ESSI rates and wage ceiling, and the FBR tax slabs before each payroll year, as rates and thresholds change.

Pro Tips

• Show employer contributions on the slip. Staff often don't realise the company pays EOBI and ESSI on top of their salary — printing it builds trust and reduces disputes.
• Keep the EOBI insured-person number on every payslip. It is the single identifier auditors and the institution ask for.
• Match the province. ESSI rules and ceilings differ by province — a Karachi template does not automatically work for a Lahore payroll.
• Reconcile monthly. Gross minus deductions must equal net pay to the paisa; a one-rupee rounding drift repeated across staff compounds fast.
• File withheld tax correctly. Withholding is only half the job — remit it to the FBR on schedule and keep the receipts with your payroll file.

Frequently Asked Questions

Q1: What is the difference between EOBI and ESSI on a Pakistani payslip? A: EOBI is the federal old-age pension scheme funded by employer and employee contributions. ESSI is the provincial social security scheme (medical and related benefits) funded by the employer, with rates and wage ceilings set by each province.

Q2: Is ESSI deducted from the employee's salary? A: No. ESSI is employer-only by scheme design. If you see it as a deduction on a payslip, that is an error.

Q3: How is income tax calculated on a Pakistani salary? A: The employer withholds it each month using the salary slabs published by the Federal Board of Revenue (FBR), based on the employee's estimated annual income.

Q4: Which ESSI schedule applies to my company? A: The one for the province where the employee works — Punjab (PESSI), Sindh (SESSI), Balochistan (BESSI) or Khyber Pakhtunkhwa. Rates and wage ceilings differ, so confirm with your provincial institution.

Q5: What is the total cost to the employer beyond gross salary? A: Gross salary plus the employer shares of EOBI and ESSI per the current schedules. Print both on the slip so the true cost is visible.

Q6: What numbers must appear on every Pakistani payslip? A: At minimum the CNIC number, the EOBI insured-person number and the pay period — auditors and the social security institutions ask for these first.