Simplifying Professional Tax Calculations: How to Use This Excel Add-In for Various States

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