How to Calculate Basic, DA & HRA etc., - basic pay Xls Download
CiteHR
 
HOME ANSWERED NEW ABOUT LOGIN
Home > Human Resource Section > Employee Compensation & Benefits

How to Calculate Basic, DA & HRA etc.,

mail2murugesan.e Started The Discussion:

Dear All, How to calculate Basic Pay, DA, HRA, Conveyance & Other Allowances from Gross Salary of Rs.20,000/-. I want know the correct formulas. Kindly do the needful. Regards Murugesh

shrimin - 
sir

I also need the same format for calculation of Basic, PF, Conveyance, pay slip etc.

And I ned the struture/policy if you have regarding conveyance + meal claims of marketing emoloyees who are in field.
Please help...

Shrimin

shivakanth - 
hi all, Pls tell me procedures for filling up & how to submit of PF, ESI, Prof . Tax forms. regards, Shivakanth

vkokamthankar - Contributing Member
Dear,

Please note, there is no single formula to arrive at Salary Breakup and there are different formulas followed by different organizations, as per their own thinking and convenience. While deciding salary structure one has to remember following points
  • Most of the statutory liabilities like PF, Gratuity, and Bonus etc. are percentages of Basic plus DA. Hence any rise in Basic or DA will increase statutory liabilities
  • It is not necessary to have DA in Salary Structure. For that matter none of the items are compulsory or must.
  • Income Tax treats some salary items (HRA, Conveyance) differently for the purpose of calculation of Income Tax liability. Hence organizations decide the breakup considering legal provisions to minimize tax liability.
  • Some organizations keep some or all items of salary structure as percentage of Basic Pay. Whenever there is increase in Basic Pay, other items also increase automatically.
  • Some organizations keep some or all items of salary structure as fixed allowances. In this case allowances remain uniform in respect of all employees. These allowances won’t change unless specific rise is given in those allowances.
  • Some organizations divide entire gross salary into fix percentages to arrive at breakup of salary structure. In this case only percentages are uniform but allowances of individual will be different.
One can choose any one combination or can also have mixed combination/s.
Also search for previous posts on same subject. There is lot of material already available on citehr.

Thanks & Regards
Quote:
Originally Posted by mail2murugesan.e View Post
Dear All,

How to calculate Basic Pay, DA, HRA, Conveyance & Other Allowances from Gross Salary of Rs.20,000/-. I want know the correct formulas. Kindly do the needful.

Regards
Murugesh

sarmakpk - Contributing Member
IT is may be useful


Attached FilesProvided by community member sarmakpk. Join us to learn and grow with your peers.
File Type: xls MUSTER SHEET.xls (20.0 KB, 9432 views)
anuj_4242 - Contributing Member
Dear All, Hope the attachment will help you out with Salary calculation and break up!!


Attached FilesProvided by community member anuj_4242. Join us to learn and grow with your peers.
File Type: xls Salary Break up calculator.xls (17.0 KB, 9128 views)
Hi,

Thanks for your information.

But I can't able to open this documents.

I don't know the reason. Kindly resend once again or send a mail to -

Regards
Murugesh

Quote:
Originally Posted by Spoke View Post
Hi

Please find the complete CTC with formulas @ Salary sheet, Payslip, Bank List, Master data

kcchandel - 
Dear All,
I am newly appointed as HR-MANAGER,in an educational institute. The total number of employees are 60.but employees drawing salary less thn 6500/p.m. are only 5. I want to know the institute is coverable under E.P.F.and E.S.I.C. ACT or not.
Thanks & Regards

sekhar2211 - 
I Thinks the percentages in the attachment are not that much satisfying. CCA Should be not more than Rs.800/- TA should be not more than Rs.1200/- Thanks Sekhar

srini2r - 
Dear Mr. Murgesh,

Kindly calculate..the 30% basic in the CTC.
40% HRA in the Baic.
TA deduction (approx 800/month).
PF-12% of Basic.
Bonus - 10% Baic
(I think he/she is not application to ESIC deductions).
Medclaim - as per company agreement with (Insurance commpany).
Other Balance amount to be in special pay.


Regards
Srinivasulu.R

Found This Useful? +Vote Up This Page Via Google.  

Why Vote? User validation is extremely important for good content to prosper.



Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.
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.
COMMUNITY SPONSORS


Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


20
LIKES

16864
VIEWS

15
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login & Explore or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network