Attaching Herewith The Salary Preparation Register with Automatic Payslip Generator for Small & Medium Scale Industry.
In The Format As soon as We prepare the salry summary by just inserting the attendance paid days of employees summary & Payslip Is Generated Automatically.
Procedure for Generating Summary: Step 1
Copy the Entire Sheet of Last Month By Right Clicking The Sheet and Creating a Copy Of it.
Dec ---Right Click --- Move or Copy ----Creat a Copy -- ok
Change The Name of Month In New Worksheet Available.
Enter The Days In the Month In Column U 5 as 30 or 31.
Enter The Fresh Paid Days of The Employees For THe month Concerned.
Insert OT Hours
Insert Advances & Arrears (If Any)
Salary Is Ready
For New Employees Simply Insert The Rows and Copy The Last Employee With new details.
It Also Prepares Amount Payable For ESIC & PF.
Procedures For PAyslip Genration
Copy The Entire Payslip Sheet As Done In Summary.
Choose The First Payslip For NEccessary Changes. Lookin to Each Cell of It where u Find A formula VLOOKUP. Change The Month Name in The Formula As Ur New Month entered for Summary. This Is to Be Done For All The Cells Of First Payslip.
Simply Copy The Entire First Payslip with Changed Month & Paste it To No. Of Slips Required For The month. The No. Should MAtch With The No. Of Employees In the Summary.
Here are ur Payslips Ready.
These Payslips Can also be utilised as Salary register as Option and space available for Employee Signature.
Please mind That Whatever Changes u Make in Salary Summary reflects to PAyslip.
S.No. Is Very Important. If The Sl. No. Of Summry Sheet is Wrong The Payslips May reflect The wrong data so alaways Check the Sl. No. of employees in Summary Before getting a printout.
For Any further Querry Pls. reveret Back On This Site or
Please Go through,
Very Easy & Simple Formulation has been Used To Connect Payslip With Summary.
Anybody in ur office who knows a little Excel can help u.
Pls. Feel Free To Revert Back any Time.
Rahul :lol: :lol:
From India, Delhi
hey dear rahul...its very gud enough that u have posted a nice salary statement for mid or small industry ,but wht is use of that thing if that doesnt open....i mean to say dear than please remove the password criteria in ur spreadsheet as u hav posted.. thanx a bunch
From India, Mumbai
Good day, Please help i cant view the attachment, i tried but it seems that i am not priviledge to do so.... what appears seem to be the web page of the site... thanks in advance.
From Philippines, Cainta
Mr. Rahul Sethi ji,
I'm a new member of this site and found it that this is a very usefull for management jobs Like HR.
I'm working with SADHNA MEDIA PVT. LTD. as a Office Exeutive at noida.
sir i found a salary sheet which is created by you, it is very useful to me.
plz guide to me in future.
thanks and regards
mohan lal verma
Hi Rahul, Thanks for your kind guidance over the salary sheet. Can you please let me know the password for it? I hope this salary sheet will be useful for me. Thank once again. Regards,Prasanna
From India, Hyderabad
Thanks for your kind guidance over the salary sheet. Can you please let me know the password for it?
I hope this salary sheet will be useful for me. Thank once again.
From India, Mudhol
If you are knowledgeable about any fact, resource or experience related to this topic - please add your views using the reply box below. For articles and copyrighted material please only cite the original source link. Each contribution will make this page a resource useful for everyone.