Struggling with Excel? How to Calculate Profession Tax in Maharashtra Based on Salary

Profession Tax Slab in Maharashtra

The profession tax slab in Maharashtra is as follows:
- Above Rs 10,000, the profession tax is Rs 200
- Above Rs 5,000, it is Rs 175

I need assistance with the generation of the amount in the profession tax column based on the salary amount. Please provide me with the formula.

Thanks and have a good day.

Good Morning!

Your question pertains to the calculation of professional tax (P.T.) based on salary slabs in Maharashtra, specifically for those earning above Rs 5000/- and Rs 10000/-.

Here's a simple way to calculate it:

1. 💰 If an employee's monthly salary is above Rs 10,000, the P.T. will be Rs 200. There's no need for a calculation in this case. If the salary is above Rs 10,000, P.T. is Rs 200.

2. 💰 If an employee's monthly salary is above Rs 5000 but less than or equal to Rs 10,000, the P.T. would be Rs 175. Again, no calculation is needed. If the salary falls in this range, P.T. is Rs 175.

These professional tax slabs are set by the Maharashtra State Government under the Maharashtra State Tax on Professions, Trades, Callings, and Employments Act, 1975.

Do remember that Professional tax is deducted from the employee's salary every month, so it's important to calculate it correctly.

Also, keep an eye out for any changes in the tax slabs, as they can be revised by the state government.

I hope this helps! Have a good day! 😊