Rahul Sethi
Hr/personnel/admin
Amar.sabato
Professional
Mohanlalverma_jsg
Insurance Advisor
[email protected]
Recruitment & Ir
+3 Others

Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
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

From India, Delhi

Attached Files
File Type: xls salary_191.xls (669.5 KB, 6100 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:

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

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

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
hi friends, there r many word/excel files which r not opening without password? can any one suggest password? Thanx Lakhan
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

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:
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
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

From India, Mudhol

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.






About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2020 Cite.Co™