Sr. Manager Hr/admin
Sweksha Tiwary
Head Hr And Admin
Accounts Work
+2 Others

Thread Started by #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 1800
Please provide the tax calculation wid annual income after deduction tax for unmarried men & women and Married Men& women urgent basis
Thanks & Regards,
21st December 2015 From India, Hazaribagh
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?
21st December 2015 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls Monthly Salary Statement - CTC and TDS Calculator.xls (84.0 KB, 2593 views)

you can update the relevant details in the relevant fields. So by default it will calculate the tax
21st December 2015 From India, Bangalore
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.
22nd December 2015 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls Tax Calculation Sheet.xls (28.5 KB, 1204 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.
24th December 2017 From India, Delhi
how to calculate salary increment sheet with pf & esi calculation
3rd May 2018 From India, New Delhi
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 @ 2017 Cite.Co™