Understanding Gujarat's Professional Tax and Salary Structure: Can Anyone Share a Detailed Excel Template?

Respected sir,

Please provide the professional tax slab (existing) in Gujarat.

Please provide an Excel sheet of the salary structure with complete details of basic, gross, EPF, EPS, professional tax, ESI, TDS, net payable, etc. (with formulas).

Regards,
Arjun Makwana

Professional tax in Gujarat applies to salary or wage earners whose salary or wage, or both, for a month fall within certain ranges:

(a) not less than Rs. 3000 but less than Rs. 6000: Rs. 20 per month (from April 1, 2008: Rs. 20 per month)

(b) not less than Rs. 6,000 but less than Rs. 9,000: Rs. 40 per month (from April 1, 2008: Rs. 80 per month)

(c) not less than Rs. 9,000 but less than Rs. 12,000: Rs. 60 per month (from April 1, 2008: Rs. 150 per month)

(d) Rs. 12,000 and above: Rs. 80 per month (from April 1, 2008: Rs. 200 per month)

Respected sir,

Thank you for such a quick reply. But I also need an Excel sheet of the salary structure with complete details of basic, gross, EPF, EPS, professional tax, ESI, TDS, net payable, etc. (with formulas) on how much is deductible.

Regards.