P Ramachandran
Hr & Administrative Manager
JOSEPHPATRAO
Head Payroll And Compliance
Praveen13ad
Employee Relations
Vidyasdl
Manager - Payroll & Emp Admin
Shashi HRD
Hr Professional
Neha27
Mba Student
Deep2007
Timekeeping & Payroll
Tarun.rosy
Recruitment
+9 Others

PRIME SPONSOR - FACTOHR - Payroll Software with GPS Enabled Attendance, Travel, Performance Management, HRMS. Explore Features
Hi, Please find the attachment of PF,ESI,PT,TDS,FBT calculator.... Hope this will be useful to you....... Regards Prasad

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, 17067 views)

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
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 ?
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.
Good effort Mr. Prasad,

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

Ex......

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.

FYI
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.

Regards,

VK
Dear durgaprasad, Really a good work and helpful to all - wish u all the best P.RAMACHANDRAN
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
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
hi,
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....
Please note that there is a minor mistake in the ESI calculation sheet which shows 'admin charges' but this not applicable in ESI
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
PRIME SPONSOR - TALENTEDGE "Interactive Anywhere Learning". Executive courses from top reputed institutes like IIM, XLRI, MICA. View Courses

Add Reply Start A New Discussion






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™