ICICI

Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

EXCEL FORMULA FOR PROFESSIONAL TAX

Asif Khan (Taxation executive) (410 Points)

28 February 2011  

HI FREINDS

I WANT TO CALCULATE THE PROFESSIONAL TAX DEDUCTED BY THE COMPANY FROM THE SALARY OF THE EMPLOYEES. THERE ARE AROUND 500 EMPLOYEES IN THE COMPANY AND THE PROFF TAX SLAB IS AS FOLLOWS  SALARY UPTO 3000 NO PT, FROM 3000 TO 3500 PT = 60 RS, FROM 3501 TO 5000 PT=120, FROM 5001 TO 10000  PT=175 RS, ABOVE 10000 PT=200. I HAVE TO FEED THE PT DEDUCTED FROM THE SALARIES IN AN EXCEL SHEET CONTAINING THE LIST OF 500 EMPLOYEES. IS THERE ANY FORMULA SO THAT THE EXCEL WOULF AUTOMATICALY CALCULATE THE PT FOR THE ENTIRE SALARY COLUMN AS THE SLAB.

PLS HELP ITS URGENT


 5 Replies

CMA.Baskar.V (Cost Accountant) (395 Points)
Replied 04 March 2011

Dear Asif,

According to your requirement, I made excel sheet with sample data 

I hope it will more help to you..........

with regards,

Baskar.V


Attached File : 44 pt calcuation excel file.xls downloaded: 20959 times
1 Like

Md.yaseen khan (accountant) (21 Points)
Replied 07 November 2012

Open excel formula for professional tax

chirag (Assist. Manager) (42 Points)
Replied 26 February 2016

I require Professional Tax Wokring Format. Please help me for this

Abhay Gaikwad (2 Points)
Replied 06 July 2021

I require  all state professional Tax working formula in my excel sheet.

Please help me for this

 

M M Bhatt (Self Employed) (22 Points)
Replied 13 July 2021

Search each and every 29 States Professional Tax Excel Sheet And Combined in One Excel Sheet by yourself 


Leave a reply

Your are not logged in . Please login to post replies

Click here to Login / Register  


Related Threads


Loading



Subscribe to the latest topics :
Search Forum:

Trending Tags