P Ramachandran
Hr & Administrative Manager
Head Payroll And Compliance
Employee Relations
Manager - Payroll & Emp Admin
Shashi HRD
Hr Professional
Mba Student
Timekeeping & Payroll
+9 Others

Thread Started by #durgaprasadkp@gmail.com

Hi, Please find the attachment of PF,ESI,PT,TDS,FBT calculator.... Hope this will be useful to you....... Regards Prasad
5th June 2008 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls PT,ESIC,TDS,FBT,S[1][1].Tax Calculator.xls (144.0 KB, 17021 views)

Dear Prasad,
First of all thank u very much for the file format.But is this file prepared as per the rules & regulations in Maharashtra ? coz slabs of ptax in Maharashtra are as follows
Rs. 2500 - P Tax is NIL
Rs. 2500 - Rs. 3500 - Rs.60
Rs. 3500 - Rs. 5000 - Rs.120
Rs. 5000 - Rs.10000- Rs. 175
Rs. 10000 & above P Tax is Rs. 200 per month except Feb
Rs.300 in the month of Feb( Max of Rs.2500 per annum )
Can u work it out for maharashtra,PF & all ?
15th March 2009 From India, Pune
Dear Prasad, When I saw your attachment file. I see it’s a Magic calculator, Nothing to do anything for calculation. So nice of you. Come on keep it up.
23rd March 2009 From India, Mumbai
Good effort Mr. Prasad,

I have gone through the calculator, but this has some confusing statements due to changes or amendments in laws/policies.


1.In PF calculator you have mentioned 8.33% goes to PENSION Fund
3.67% goes to PF Fund from employee's contribution which is actually goes from employer's contribution.

Employee: 12% (P.F)
Employer: 3.67% Provident Fund (A/c 1) + 8.33% Pension (A/c 10) + 1.10% Admin Charges on PF (A/c 2) + 0.50% EDLI (A/c 21) + 0.01% Admin Charges on EDLI (A/c 22) =>13.61% on basic

2. Service Tax has been revised now and its 10% inspite of 12%, edu cess and higher sec cess are same.

3.It's not clear for which state PT is been calculated. In MP there are slabs fixed for the same:
120000-150000 1000 / year or 83 / month (difference adjusted in last deduction)

150000-180000 1500 / year or 125 / month

> 180000 2500 / year or 212 / month

but formulae used in calculator are something different.

Rest of the calculator is OK.........yes....the checklist is really useful.


25th March 2009 From India, Indore
Dear durgaprasad, Really a good work and helpful to all - wish u all the best P.RAMACHANDRAN
31st March 2009 From India, Madras
1.Please send me this PF,ESI,PT,TDS,FBT calculator....
2. the following mentioned company employee salary how to considered and % rate.
Basic, HRAMisc. AllowanceMedical AllowanceConveyance AllowanceEducation AllowanceConveyance Re-imbursementOtherArrearsBonusLTA
2nd April 2009 From India, Bangalore
Hi Prasad, could you explain me on Basic salary of the employer, what amount is to be incorporated or is that basic salary of the employee and employer been the same Regards Ravi
7th April 2009 From India, Hyderabad
Its a very helpful calculater...
i was go'n thru PF calculater.....y u hv made/devided 2 colums of basic salary of employee n employer...and i hv a question about....the condition of 6500 as basic salary...can u explain me tht....
5th May 2009 From India, Bangalore
Please note that there is a minor mistake in the ESI calculation sheet which shows 'admin charges' but this not applicable in ESI
7th May 2009 From India, Noida
Hi Durga, The calculation index is rally nice and helpful. I have been geiing inputs from differnt sources but most of the were bit confusing but your is the best !!! Cheers, Amit
8th May 2009 From India, Lucknow
Hi Durga,
The calculation index for PF ,ESI And TDS etc is rally nice and helpful.Moreover it is all consolidtaed in one excell. I have been getting inputs from differnt sources but most of the were bit confusing but your`s is the best !!!
8th May 2009 From India, Lucknow
Hello sir,

iam neha MBA (HR), would also like to know all about 'payroll and compensation system' in companies..

As a fresher i dont about this function much
could u please help me out in this

even i tried to download this attachment but it was not opened.

could you please send me relevant information on 'Payroll & compensation sytem' on my e-mail id-

i'll be very greatful to you sir

hope for your reply
21st May 2009 From India, Pune
Dear Prasad The PF calculater is amazing.It’s very useful.Thanks for sharing ur knowledge.Prasad just i want to spk with u.can u give ur contact number or else u can contact me on 9769018254.
23rd May 2009 From India, Mumbai
Hi good work it is useful ... A small suggestion and request kindly advise on the pt for all states in india best regards
23rd May 2009 From India, Mumbai
i have worked in m\s parakh enterprises a sister consultant of ralon industries pvt ltd bhopal. i have left my service and till o date i have not received my pf amount. my pf no is PN/6094/1448 . Can you send me the status of my application.
18th June 2009 From India, Pune
[Hi, Very useful one Keep Sending these Please find the attachment of PF,ESI,PT,TDS,FBT calculator.... Hope this will be useful to you....... Regards Prasad
16th July 2009 From India, New Delhi
Dear All, Can anybody tell me, is there any salary limit in contract labour Act. What I know it is below Rs 1600/- pm. Goutam Kr Tapedar
29th July 2009 From India, Vijayawada
Need some information on PF calculation on below points 1) PF is calculated 12% on basic but is this fixed also of Rs 780? 2) Pf is calculated on Basic * spl. Allowant if both total is below 6500?
29th July 2009 From India, Mumbai
let me remind u tht PT slab is changed from 1st July 09 also FBT is nw nt deducted. so kindly make the necessary changes in the attachment & use it.
9th August 2009 From India, Mumbai
Hello Every One...
Please send me complete formula for calculate salary.
ex. i just want to give net 60000 salary p.m. to my employee.
so how to calculate all the taxes?
how to generate salary?
Thank You.
Sanjay Pansuriya
5th October 2009 From India, Ahmadabad
Very time saving and useful calculator. It can be used for presentation of data in required form. Goutam Kumar Tapedar 9934370039
20th October 2009 From India, Vijayawada
Hi Prasad,
the calculator which you sent is useful.
Can you please help me in designing an offer letter with new tax details.
It will be useful to me in doing the revision of offer letters to employees with tax exemptions/eligibility criteria.
Kind Regards,
HR Associate
10th May 2010 From India, Madras
Thanks for sharing valuable knowledge, I would like request you to kindly guide us on latest -2018 working in single excel sheet maintaining Salary Payroll including PF, ESIC, TDS, Professional Tax-Madhya Pradesh etc.
I am working as Assistant to CA-Firm , I also work part time -Accounting ,interested for IT-Software Development Companies ( Indore-M.P.) Mobile No-098264-43046 Emial ID
21st August 2018 From India
Reply (Add What You Know) Start New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2019 Cite.Co™