DOCUMENTS / LOCAL / FREE

Salary slip Excel worksheet

The Excel download is a single sheet named Salary slip, not a workbook with a tab for each month. Gross earnings is the SUM of basic, HRA, and other allowance. Total deductions is the SUM of PF, ESI, professional tax, and TDS, and net pay subtracts total deductions from gross earnings.

Published · Updated

An Excel salary slip whose gross pay, total deductions, and net pay calculate from the cells you edit. Free PDF, Word and Excel downloads.

Salary slip Excel worksheet format sample in Word and Excel

Download or edit this sample

Edit document details
MAKE IT YOURS

Choose your style

Excel gross pay, total deductions, and net pay calculate from the amount cells. PF, ESI, and tax rates are not looked up.
Live document previewA4 · 1 page
YOUR COMPANYSAMPLESalary statementSalary slip Excel worksheetEMPLOYEE DETAILSEmployer[employer legal name]Employee[employee name]EarningsDeductionsBasicINR 20,000PFINR 1,800HRAINR 8,000ESIINR 0Other allowanceINR 2,000Professional taxINR 200Gross earningsINR 30,000TDSINR 0NET PAYINR 28,000Made with OpenToolSuite.com01

What each part means

Employer and employee

Use the employer’s legal name, employee ID and pay period.

Earnings

Separate Basic, HRA and other allowances; do not confuse CTC with cash earnings.

Deductions

Enter actual payroll PF, ESI, professional tax and TDS amounts. This template does not calculate statutory eligibility or rates.

Questions

What does Salary slip Excel worksheet include?

The employer, the employee, the pay period, earnings, deductions, and the net pay that results from those figures.

Does it calculate PF, ESI, or income tax?

No. Type those amounts. The Excel salary slip does not look up statutory rates.

Are the sample names real people?

No. Replace the name, the identifiers, and the amounts with the payroll record.

Which files can I download?

PDF and Word. Where Excel is offered, gross pay, total deductions, and net pay are formulas that update when you edit the amount cells.

Can I edit it in Word?

Yes. DOCX contains editable text. Customized PDF exports preserve the layout as page images; direct English sample PDFs contain searchable text. Neither is a digitally signed document.

Is my entered information uploaded?

Document generation happens in this browser. Optional consented analytics measures actions, never document contents.

Check before you use it

Use employer-approved payroll figures. A self-created sample is not proof of employment or payment.

  1. Replace every sample or bracketed field with accurate information.
  2. Check dates, amounts, identifiers and the intended recipient’s requirements.
  3. Open the exported file and obtain any required employer, landlord or legal approval.

Prepared by Feroz Sheikh ·