Hi, Please find the attachment of PF,ESI,PT,TDS,FBT calculator.... Hope this will be useful to you....... Regards Prasad
From India, Bangalore
Acknowledge(0)
Amend(0)
7From India, Bangalore
Acknowledge(0)Amend(0)
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 ?
From India, Pune
Acknowledge(1)
Amend(0)
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 ?
From India, Pune
Acknowledge(1)Amend(0)
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.
From India, Mumbai
Acknowledge(0)Amend(0)
0
0
From India, Mumbai
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply contains inaccuracies. The original post mentioned providing calculators for PF, ESI, PT, TDS, and FBT, not a "Magic calculator." Encouragement to clarify information is recommended.
0
0
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
From India, Indore
Acknowledge(1)Amend(0)
0
0
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
From India, Indore
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Checked)-Great insights, VK! Your clarification on PF contributions is accurate. For Service Tax, it's indeed 10% now, and PT calculations vary by state. Your attention to detail is commendable. Keep up the good work! (1 Acknowledge point)
0
0
Dear durgaprasad, Really a good work and helpful to all - wish u all the best P.RAMACHANDRAN
From India, Madras
Acknowledge(0)Amend(0)
0
0
From India, Madras
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-Great acknowledgment of the effort! Keep supporting each other. (1 Acknowledge point)
0
0
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
From India, Bangalore
Acknowledge(1)
Amend(0)
0
0
2. the following mentioned company employee salary how to considered and % rate.
Basic, HRAMisc. AllowanceMedical AllowanceConveyance AllowanceEducation AllowanceConveyance Re-imbursementOtherArrearsBonusLTA
From India, Bangalore
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Checked)-The information provided is relevant. It is essential to consider the mentioned components like Basic, HRA, Misc. Allowance, Medical Allowance, Conveyance Allowance, Education Allowance, Conveyance Reimbursement, Other, Arrears, Bonus, and LTA for accurate calculations. (1 Acknowledge point)
0
0
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
From India, Hyderabad
Acknowledge(0)Amend(0)
0
0
From India, Hyderabad
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The Basic salary typically refers to the fixed amount of compensation paid to an employee before any extras or deductions. It is the salary agreed upon between the employer and employee, not the employer's salary. It is essential to differentiate between the two for accurate payroll calculations.
0
0
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....
From India, Bangalore
Acknowledge(0)Amend(0)
0
0
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....
From India, Bangalore
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The columns for basic salary for employee and employer in the PF calculator are to differentiate between the contributions made by each party. The condition of ₹6,500 as basic salary is a threshold for PF eligibility. (1 Acknowledge point)
0
0
Please note that there is a minor mistake in the ESI calculation sheet which shows 'admin charges' but this not applicable in ESI
From India, Noida
Acknowledge(0)Amend(0)
0
0
From India, Noida
Acknowledge(0)Amend(0)CiteHR.AI
(Fact Checked)-The user reply is correct. It is accurate that 'admin charges' are not applicable in ESI calculations. (1 Acknowledge point)
0
0
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
From India, Lucknow
Acknowledge(1)Amend(0)
0
0
From India, Lucknow
Acknowledge(1)Amend(0)CiteHR.AI
(Fact Check Failed/Partial)-The user's reply contains inaccuracies as there is no mention of the actual content or accuracy of the attachments related to PF, ESI, PT, TDS, FBT calculations. Encouragement to check the content provided and give feedback would be more appropriate.
0
0
Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
CTC Calculator.xls
CiteHR.AI
(Fact Checked)-The user's reply is correct regarding the professional tax slabs in Maharashtra. The information provided aligns with the latest regulations in the state. (1 Acknowledge point)