supriya1515
8

Hi
I newly joined as HR-Executive in one small concern with 25 to 30 members,can anyone help me in preparing the salary in simple format.And still we don't have PF,ESI and HRA etc only the Basic salary.Could any one forward me the format to calculate the salary in simple form with leave deduction
Thanks

From India, Bangalore
supriya1515
8

Hi Thanks for ur reply could u pls forward me the formulae for that,bcoz we dedute for more then one day salary and it would be fine for me if i get the formula for that
From India, Bangalore
M.Sayeed
80

Please find attachments 1, With PF deduction 2, Without PF, just simple salary. Thanks,
From Kuwait, Hawalli
Attached Files (Download Requires Membership)
File Type: xls SALARY(1).xls (23.5 KB, 11102 views)
File Type: xls SALARY with out PF Deduction.xls (22.5 KB, 25562 views)

lakshika.nagpal
3

Hi
Supriya
I`ll suggst u to make compensation policy first... ya it will take time but without policy in Hr you will be needing the help of othr at every step....and aply for ESI & PF asap...
In Compnsation policy you will have to decide few things like
1. Grade of empolyees
2. Basic pay as per the grade
3. Conv. allw. as per the grade
4. HRA
5 . othr allw.

From India, Delhi
kumujegan
1

dear sir,
i am kumudha, i am new joining in my company at hr department .how to handle the hr department? how to follow the ledger? and how many ledger follows the department?
kindly help me.
thanks & regards,
kumudha.7708959776

From India, Selam
hansa vyas
198

dear Mr. sayeed,
I have some doubts in the salary sheet with PF.i hope i can ask & clear my doubt.
1.In Basic salary u had used formula 1200/D4*F4,why you had taken 1200 & suppose if different people hv different basic than.
2. In DA column it is 900 from where does or only 900 is used ,is it standard or for what it is taken.
Regards,
Hansa Vyas

From India, Udaipur
bhaven Gala
Dear Hansa Vyas,
Whatever Sayeed is given that is absolute perfect. in that there is no doubt at all.
Basic may be different for different people & DA there is Skilled Base & that there is table given Commercial office (Tardeo).
Regards,
Bhaven Gala

From India, Mumbai
M.Sayeed
80

Dear Mr. Hansa,
1, 1200 is used as an example, if its other then 1200, then formula is same, total days - absent days..
2, Daily allowance 900 is also used as an example, its not standard.
Please review below attached for more detials its really very well explain..this I have downloded from this forum only.
Thanks,

From Kuwait, Hawalli
Attached Files (Download Requires Membership)
File Type: xls Salary Sheet & PF PT Calculation & Challan.xls (2.81 MB, 11956 views)

gsanjeev1973@gmail.com
7

if you use attached sheet your work very easy
From India, Delhi
Attached Files (Download Requires Membership)
File Type: xls SALARY.xls (23.0 KB, 5154 views)

Krishnamkn
8

Dear Supriya,
The simple format for salary Calculation with necessary formula including PF, ESIC & PT. If its not necessary to you can delete columns. Its may be full fill your query.
Regards,
Krishna Murthy
Bangalore

From India, Bangalore
Attached Files (Download Requires Membership)
File Type: xls Sample Salary Statement.xls (34.0 KB, 2605 views)

Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.






Contact Us Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2024 CiteHR ®

All Copyright And Trademarks in Posts Held By Respective Owners.