Rahul Sethi
Hr/personnel/admin
Mohanlalverma_jsg
Insurance Advisor
Amar.sabato
Professional
Mukeshmba1987@gmail.com
Recruitment & Ir
+3 Others

Thread Started by #Rahul Sethi

Hi all,

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.

Step 2

Enter The Days In the Month In Column U 5 as 30 or 31.

Step 3

Enter The Fresh Paid Days of The Employees For THe month Concerned.

Step 4

Insert OT Hours

Step 5

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

Thanls :lol:

Rahul Sethi
8th January 2008 From India, Delhi

Attached Files
Membership is required for download. Create An Account First
File Type: xls salary_191.xls (669.5 KB, 6019 views)

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.
Thanks,
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
regards
amar
19th January 2008 From India, Mumbai
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,
Mayur Dayama

30th September 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
hi friends, there r many word/excel files which r not opening without password? can any one suggest password? Thanx Lakhan
7th November 2008 From India, Delhi
Mr. Rahul Sethi ji,
Respected Sir,
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
9313292048

15th January 2009 From India, New Delhi
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
Hello 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,
Bharat Redekar
3rd September 2017 From India, Mudhol
I cannot open this file.. Can u tell me the password
22nd December 2018 From India, Kottayam
can you please provide password. it is protected.
29th December 2018 From India, Bangalore
Reply (Add What You Know) Start New Discussion

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)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™