Payslip Generation From Excel. - Xls Download - CiteHR
Salary Processing,final Settlements,medical
Akshu Puri
Mba (hr)
+15 Others

Cite.Co is a repository of information created by your industry peers and experienced seniors sharing their experience and insights.
Join Us and help by adding your inputs. Contributions From Other Members Follow Below...
Can anybody tell me how to generate the payslip from excel sheet or is there any other option. I want to generate from Salary Master Sheet, so every month I dont need the change the values in salary slip.

Hi Rajasekar, Can you explain me about the mail merger option. How do I go about it and what are the steps.
Mail merge is option where you can merge the word file and excel file. You just have your salary structure format in word file and using mail merger import datas from the excel file.
Else u call me at 098401 80725


Hello Sir i tried to find mail merge option in excel but all in vain .... could you pls guide me abt this option like where is it in excel i know abt word but nt excel. Regards Akshu
Dear All
Payslips can easily be generated through Microsoft word > Tools > Letter & Mailings > Mail merger. It is one of the easiest way you can generate payslip as per the required format from excel to word. If any one needs help pl reach me at 9841160500. I am here to help you friends

Hi All,
Thanks for your replies, can anybody provide me the template of the mail merger, i just treid but not working, please provide the step by step details adopt mail merger for sending salary slips.

Let me try explaining the step by step process of Mail Merge...

1 - Form a template in a word document.

Example: Dear Mr. Name, Your employee number is: Emp No, You would be earning a CTC of: CTC

2 - Open an Excel Sheet which contains the information for all the MS word fields: Example:
Name Emp No CTC
ABC 123 10,000
CCC 458 20,000
SSS 666 15,000 and so on

3 - In word click on Tools - Letters and Mailings - Mail merge wizard. A screen will pop up on you word document showing Mail Merge heading.

4 - On bottom right corner you will find "Starting document" link which will be colored in Blue. Click on the link. You will be directed to "Select recipients" link. Click on "select recipients" You will next be directed to " Browse" link.

5 - Click on "Browse" it will ask you to select the document to which you need to merge. Select the data source. you need to select the Sheet number in which your main data is stored. Click "Ok" Minimise tehe Excel sheet. and open the word document.

6 - In word document select the word "name" Example: Dear "name" and select on insert merge field icon (you can find the icon in MAil merge toolbar). as soon as you click the icon you will get a window which will ask you to choose the field for which you need to merge.

7 - Select the appropriate field and click on Insert button.

8 - Then close.

Similarly for Emp No and CTC. after finishing the entire process you can view the final results when you click on "view merged data" icon

I hope i have explained Mail merge in brief. Let me know if you find any hurdles while merging the document.

Dear Indresh, I’m forwarding the format for making the salaries in MS Excel sheet. You modify it what you can wish. Regards, Krishnam Raju

Attached Files
Membership is required for download. Create An Account First
File Type: xls Salary Statement.xls (292.0 KB, 18330 views)

Hi Indresh, u can download the trial version of pdf convertor and convert your excel sheet into pdf format and use as pay slip.
I agree with some who say that this is not worth wasting time.
All I would say is, Friends, let us not forgo our exploratory streak. Solutions are available in MS Office in the form of Help (F1). Let us explore.
Actually, the payslip should be designed in MS Word and the data should be fetched in using Mail Merge. You can even put the company logo / other graphics / Some good quotes in the header / footer.
Try it out, it is very easy and time saving.
Ranjit J. Pandya

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™