Sweksha Tiwary

Hi Everyone,
I am working as a executive HR spoc in France Based MNC.I am unable to Understand the tax calculation and its not part of my job but i have to do it because i a m suffering from last 2 month mentally torcher.please guide me for this.Details are mentioned below
Name ABC
Basic 22000
HRA 11000
Conveyance Allowance 2000
Education Allowance 400
Special Allowance 3000
Monthly Gross 38400
Annual Gross 460800
Annual Bonus 50000
Annual Income Total 510800

PF 2640
Annual PF 31680
P.Tax 150
Annual P.tax 1800
Please provide the tax calculation wid annual income after deduction tax for unmarried men & women and Married Men& women urgent basis
Thanks & Regards,

From India, Hazaribagh
Sr. Hr Manager
Accounts Work
+2 Others


I am enclosing a tool for calculating the tax. hope it might help you to calculate. I feel it is better if you could have added the medical allowance to reduce the tax
To calculate the TDS you should require all the savings details also.
These tax calculations are done by finance team rite?

From India, Bangalore

Attached Files (Download Requires Membership)
File Type: xls Monthly Salary Statement - CTC and TDS Calculator.xls (84.0 KB, 4070 views)


you can update the relevant details in the relevant fields. So by default it will calculate the tax
From India, Bangalore
Pan Singh

Dear Sweksha,
As you asked, there is no bar for married/unmarried or Fale/Female in Income Tax.
Mr. Jeeva has helped you with a tool thru which TDS (Income Tax) can be calculated.
But before reaching on any Tax deductions, there are many Exemptions, Allowance, Deduction which can be deducted from salary before making any Tax Deduction. The scenario can be different person to person. For better understanding, pls note the below:-
HRA Exemption (almost 50%)- Can b more or less as per actual situation
Conveyance - 19600/pa
80 c Deductions-1.50 L/pa
However, I have made calculation as per detail provided by u. Hope this will meet your requirement.

From India, Delhi

Attached Files (Download Requires Membership)
File Type: xls Tax Calculation Sheet.xls (28.5 KB, 1653 views)

I have just joined this forum. All the queries sought by me reg tax calculation intt calculation have been provided by u n it will be of great help for me.
From India, Delhi
sushma jagdeep singh

how to calculate salary increment sheet with pf & esi calculation
From India, New Delhi

If you are knowledgeable about any fact, resource or experience related to this topic - please add your views.

About Us Advertise Contact Us Testimonials
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2023 CiteHRŽ

All Material Copyright And Trademarks Posted Held By Respective Owners.
Panel Selection For Threads Are Automated - Members Notified Via CiteMailer Server