Jira & Confluence 
Bitrix24 Salary slip · Excel · India
Salary slip format — EPF, ESI and net pay calculated
Short answer. Enter monthly rates, loss-of-pay days, professional tax and TDS. EPF (employee): 12% of PF wage (basic + DA); the slip can restrict it to the ₹15,000 wage ceiling (EPFO).
We will ask you to confirm this address, then email you the recipient’s reply.
Start typing right in the document — no sign-up. It stays in this browser; save it to your free Layers account to keep it, open it on your phone and share it.
- Issue the slip with the salarytype the date
Check your own case.
A reminder date for your payroll; the slip itself does the calculation.
Meera, Layers template assistant
Enter the monthly rates and LOP days, and I will work out net pay and the employer’s cost.
Change rates on the Settings sheet if your establishment’s rules differ.
Deadlines
The rules, with the source
| What | Deadline | Source |
|---|---|---|
| EPF — employee | 12% of PF wage (basic + DA); the slip can restrict it to the ₹15,000 wage ceiling | EPFO |
| EPF — employer | 12%, of which 8.33% to EPS on wages up to ₹15,000 (max ₹1,250) and the rest to EPF | EPFO |
| ESI | employee 0.75%, employer 3.25%, for employees within the ₹21,000 wage limit | ESIC |
| Earned pay | monthly rate × paid days ÷ days in the month | arithmetic |
| 50% wage check | excluded allowances above half of total pay count as wages | Code on Wages, 2019, s.2(y) |
Rates are editable on the Settings sheet. Professional tax depends on your State; TDS comes from your payroll tax computation. Check rules that apply to your establishment.
Step by step
What to do, in order
1
Company and employee
Name, ID, designation, PAN, UAN, ESIC number, bank account (last 4 digits).
2
Pay month and LOP
Any date in the month; enter loss-of-pay days — paid days update.
3
Monthly rates
Basic, DA, HRA, conveyance, special allowance; overtime and bonus as earned amounts.
4
Deductions
EPF and ESI calculate; enter professional tax, TDS and recoveries.
5
Check the 50% rule
The Wage check sheet shows whether excluded allowances exceed half of total pay.
6
Print or send
One A4 page; share the slip with the employee as PDF.
Questions
Is this salary slip format free?
Yes. Fill it in online and download Excel without signing up.
How is EPF calculated?
12% of basic + DA earned this month. With “restrict to ceiling” on, it is 12% of up to ₹15,000 — ₹1,800 at most.
When is ESI deducted?
For employees covered by ESI: 0.75% from the employee, 3.25% from the employer. With “Auto”, the slip treats a monthly rate total up to ₹21,000 as covered. Coverage is decided per contribution period, so set Yes/No if you know it.
Does it calculate income tax (TDS)?
No. Enter the monthly TDS from your tax computation under the old or new regime.
What is the 50% wage check?
Under the Code on Wages, if allowances excluded from “wages” (such as HRA, conveyance, overtime) exceed half of total pay, the excess is treated as wages. The sheet shows the amount.
Is a salary slip mandatory?
Employers issue wage slips to employees; check the rules for your State and establishment.
Official sources
Other documents
Keep the papers in one place
Letters, receipts and notices in one folder you can share with family or a lawyer. The templates and the editor are free; Layers is free for up to 20 people.
A payroll template, not tax or legal advice. Statutory rates and limits can change; check EPFO, ESIC and your State’s rules.