Tax Calculation Issue - Xls Download - CiteHR
Jeevarathnam
Sr. Manager Hr/admin
Dipunik
Accounts Work
+2 Others

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

Hi
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?


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

you can update the relevant details in the relevant fields. So by default it will calculate the tax
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.


Attached Files
Membership is required for download. Create An Account First
File Type: xls Tax Calculation Sheet.xls (28.5 KB, 1300 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.
how to calculate salary increment sheet with pf & esi calculation
This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™