salary_sheet_wb_shyamali.xlsx

	A	B	C	D
1	CONFIGURATION SHEET — Shyamali Engineering Works
2	Change the yellow cells below — the entire Salary Sheet updates automatically
3
4	PARAMETER	RATE	EFFECTIVE DATE	NOTES

5	DA Rate (WB 2025-26)	113.0%	Apr 2025	113% of Basic — WB Labour Gazette 2025-26
6	HRA Rate	30.00%	Standard	30% of Basic (Urban — Howrah/Kolkata)
7	PF Rate — Employee	12.00%	Statutory	12% of Basic, ceiling ₹15,000
8	PF Rate — Employer	12.00%	Statutory	Employer match, booked separately
9	ESI Rate — Employee	0.75%	Statutory	0.75% of Gross Salary
10	ESI Rate — Employer	3.25%	Statutory	3.25% of Gross Salary
11	PF Basic Ceiling (₹)	15,000	Statutory	Mandatory PF on Basic up to this amount
12	ESI Gross Ceiling (₹)	21,000	Statutory	ESI not deducted if Gross > this
13
14	PROFESSIONAL TAX SLABS — West Bengal (on Monthly Gross)
15	Gross ≤ ₹10,000	0	Nil
16	₹10,001 – ₹15,000	110	₹110 / month
17	₹15,001 – ₹25,000	130	₹130 / month
18	₹25,001 – ₹40,000	150	₹150 / month
19	Gross > ₹40,000	200	₹200 / month (maximum)
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100