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: 11th January 2008 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
amar 19th January 2008 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. 13th October 2008 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... Dear... pls forward salary format on my email address pls... i am not able to copy, it’d corrupted file. i am waiting for reply... Regards, Mukubha......:icon14: 14th April 2009 From India, Ahmadabad
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 22nd April 2017 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.
Bharat Redekar 3rd September 2017 From India, Mudhol
Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page. Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)