Professional Tax Excel Add-In
Hi all, I am sharing an Excel Add-In to determine the Professional Tax in various states. Use the formula as provided below:
| Sr No | State | Amount on Which Prof Tax | Prof Tax | Formula Used |
|-------|--------------|--------------------------|----------|----------------|
| 1 | MP | 15000 | 125 | =ptmp(D4) |
| 2 | West Bengal | 12000 | 110 | =ptwb(D5) |
| 3 | Orissa | 18000 | 150 | =ptorissa(D6) |
| 4 | Maharashtra | 25000 | 200 | =ptmaha(D7) |
State Formulas and Remarks
- West Bengal: =PTWB(Cell Ref)
- Tamil Nadu (Half Yearly): =PTTAMILNADU(Cell Ref)
- Orissa: =PTORRISA(Cell Ref)
- Maharashtra: =PTMAHA(Cell Ref) Please verify slab for February
- Kerala (Half Yearly): =PTKERALA(Cell Ref)
- Madhya Pradesh: =PTMP(Cell Ref) Please verify slab for February
- Karnataka: =PTKARN(Cell Ref)
- Gujarat: =PTGUJ(Cell Ref)
- Assam: =PTASSAM(Cell Ref)
- Andhra Pradesh: =PTANDHRA(Cell Ref)
Thanks and regards,
Anvesh
From India, Mumbai
Acknowledge(0)
Amend(0)
Hi all, I am sharing an Excel Add-In to determine the Professional Tax in various states. Use the formula as provided below:
| Sr No | State | Amount on Which Prof Tax | Prof Tax | Formula Used |
|-------|--------------|--------------------------|----------|----------------|
| 1 | MP | 15000 | 125 | =ptmp(D4) |
| 2 | West Bengal | 12000 | 110 | =ptwb(D5) |
| 3 | Orissa | 18000 | 150 | =ptorissa(D6) |
| 4 | Maharashtra | 25000 | 200 | =ptmaha(D7) |
State Formulas and Remarks
- West Bengal: =PTWB(Cell Ref)
- Tamil Nadu (Half Yearly): =PTTAMILNADU(Cell Ref)
- Orissa: =PTORRISA(Cell Ref)
- Maharashtra: =PTMAHA(Cell Ref) Please verify slab for February
- Kerala (Half Yearly): =PTKERALA(Cell Ref)
- Madhya Pradesh: =PTMP(Cell Ref) Please verify slab for February
- Karnataka: =PTKARN(Cell Ref)
- Gujarat: =PTGUJ(Cell Ref)
- Assam: =PTASSAM(Cell Ref)
- Andhra Pradesh: =PTANDHRA(Cell Ref)
Thanks and regards,
Anvesh
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
PROFESSIONAL TAX SLABS IN VARIOUS STATES.xlsx
Professional tax hyderabad.doc
ALL STATES TAX WEBSITS.pdf