Hello seniors:
I am ruban pursuing MSW(HR) in mar gregorios college. Actually i prepared one payroll process. I am attaching a file pls go throught it and give me a suggestions to improve my self. Seniors hopefully waiting for your replys.Actually before i prepared one i posted in cite hr with that suggestion i revised this. pls give your suggestion and correction.
Thanks and regards
Ruban kumar.R

From India, Madras
Attached Files (Download Requires Membership)
File Type: xls NEW SALARY.xls (33.0 KB, 1128 views)

Dear, you have designed it wonderfully, but thier is some changes, Note: Sum of PF., P.T. AND ESIC should be deudted from earned salary.
From India, Thana
Attached Files (Download Requires Membership)
File Type: xls Copy of NEW SALARY.xls (33.0 KB, 428 views)

Dear Mr Rupan Kumar, Greetings... I found a mistake in Employers EPF Contribution. Mistakenly you have considered 15,000 instead of 6,500. Pl check. Regards, Chengalvarayan K
From India, Madras
Dear Rupan, Your HRA=40% of gross and it cannot be more than 50% of Basic. So kindly rectify it. Your sheet need to be more organized way. Regard’s Shaikh
From India, Bhubaneswar
In your sheet still you have calculated the ESI contribution of employee & employer on the basis of Gross per month but it should be on actual salary, and also you have calculated the P.F. contributions of employer on the basis of Gross per month but it should be on the basis of earned Basic yesh the checking of PF applicablity may be on the basis of actual basis.
From India, Bangalore
Dear Rupan, Attaching one salary calculation sheet. you need to fill the date and it eill grnerate automatically. Hope you will find it easy Regard’s Shaikh
From India, Bhubaneswar
Attached Files (Download Requires Membership)
File Type: xls SALARY.xls (316.5 KB, 393 views)

Hi! Its very much useful .. few comments .. limits for pf deduction if ceiling at 6500. deduction of welfare fund for employee and employers too. Ashish
From India, Delhi
If we read the definition of of employee in Shops of Establishment Act of Punjab
employee works on piecerate ,
This means one is free to work whether it is on daily wage basis.
Thus employees are working on piecerate rate basis .And I want to develop a standard piecerate salary sheet where I cen get his deductions on PF, ESI, W.F. etc.
His individual job cards( the details of his pieces made on any specific days.
for reference please see the attachment.
thanking you all!
Ashish

From India, Delhi
Attached Files (Download Requires Membership)
File Type: jpg Picture.jpg (632.1 KB, 27 views)

hello seniors: what is percentage of admin charges ? y employer is paying the admin charges anyway employer is already paying 12%? Thanks and regards Ruban kumar.R
From India, Madras
Hi, It appears the basic Information Sheet. Also while going thro' the Sheet U have given 12%PF on the Total Baisc itself. Is is not the Basic reduced for leave Period. Check this one
From India, Bangalore
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.