Indresh Started The Discussion:
Hello,

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.


Regards

Indresh.
Posted 4th March 2009 From India, Bangalore
Hi Rajasekar, Can you explain me about the mail merger option. How do I go about it and what are the steps.
Posted 4th March 2009 From India, Bangalore
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

Regards
Rajasekar

Posted 4th March 2009 From India, Madras
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
Posted 4th March 2009 From India, Chandigarh
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

Regards
venkatesh
Chennai
Posted 4th March 2009 From India, Madras
Outsource to Talentpro. We have one of the best payroll system in India. You can concentrate on you key functional area You can mail me to kbmurthy@gmail.com for more info.
Posted 4th March 2009 From India, Hyderabad
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.

Regards

Indresh.
Posted 5th March 2009 From India, Bangalore
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.
Posted 5th March 2009 From India, Bangalore
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
Posted 5th March 2009 From India, Hyderabad
Attached Files
Shared By Cite.Community Member "krishnarfc" For Public Download
File Type: xls Salary Statement.xls (292.0 KB, 15235 views)
bmchr 
Hi Indresh, u can download the trial version of pdf convertor and convert your excel sheet into pdf format and use as pay slip.
Posted 5th March 2009 From India, Bangalore
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.

Regds.
Ranjit J. Pandya
Posted 5th March 2009 From India, Ahmadabad
Hi, indresh Try this and send u r comment. note P.Tax calculated for TN Thx Kris
Posted 5th March 2009 From India, Kochi
Attached Files
Shared By Cite.Community Member "Krishnaa" For Public Download
File Type: xls Sample STRUCTURE- Temp-.xls (32.0 KB, 1543 views)
mail merge are really superb but actually Vlookup is one of the best formula which are saved in one sheet Hasmukh
Posted 6th March 2009 From India, Ahmadabad
Hi All, Thanks for your replies, can anybody provide me the template of the Salary slip And Leave Form, i just treid but not working, please provide. Regards Renu Rana
Posted 6th March 2009 From India, Delhi
Mail Merge is good; but for a beginner sometimes the formatting is difficult. You have to remember what format you have in the excel sheet does not show itself in word. For one who loves to experiment, there is much to explore. If we do not have a HRMS system: Mail merge is a good option to print all kinds of letters using one singe template, so that there is not much data duplication.

Vlookup() command in excel is the simplest for a small company. It is not at all complicated. And for payslips it is the best option. Once again you do not have to store two different files. You can use sheet1 for source data and sheet 2 for the Payslip format.

Keep asking any amount of questions you like and please do not get discouraged by people who say 'it is a waste of time'
Posted 6th March 2009 From India, Bangalore
Dear All, Please find attached Payroll in Excel with automated Payslip & salary register.... Regards, Sameer
Posted 6th March 2009 From India, Thana
Attached Files
Shared By Cite.Community Member "sameer.hirlekar" For Public Download
File Type: xls PAYROLL.xls (211.5 KB, 2202 views)
One more format for all. Attached is a format for payslip as well. I hope this helps
Posted 6th March 2009 From India, Bangalore
Attached Files
Shared By Cite.Community Member "Kavitha Janya" For Public Download
File Type: xls Book1.xls (42.0 KB, 1291 views)
Sameer, The excel "Payroll.xls" that you have provided opens with the all the cells populated as "#N/A" in the Salary register sheet. Please help me to rectify this
Posted 8th August 2009 From Oman, Muscat
Hey Frnds can anyone help me in making of salary slip. I don't have any idea how to make and I have to make 4 years salary slip without showing PF ....yet getting 9456/Rs n i have to show all salary slips since 2005 .........it may be easy for u guyz as u all seems professionals .....Plz mail me if u want any information u can mail me at ...... I wud be thankful to u...waiting for reply....
Posted 31st October 2009 From India, Kanpur
Attached Files
Shared By Cite.Community Member "piyush0581" For Public Download
File Type: doc Piyush.doc (40.5 KB, 973 views)
Dear All,

Could anyone please explain the steps to interface the employee data (MS Excel Sheet) with the Payslip format (MS Word).

So that I could generate payslip for our company employees periodically with your great help.

Prabakar

Posted 24th February 2010 From India, Madras
[QUOTE=Indresh;630385]Hello,

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
Regards

Mr. Indrersh

Please send your master file for payslip generation. I can able to prepare either excell or word formate depends on your wish

Here attached for enclosed copy for view sample
Posted 26th February 2010 From India, Hyderabad
Attached Files
Shared By Cite.Community Member "sarmakpk" For Public Download
File Type: doc autofin payslip.doc (314.0 KB, 2107 views)
File Type: xls SALARY STATEMENT.xls (322.5 KB, 1748 views)
rak12 
I tried from letters and mailing option but its showing address like f2, f3 not the values... pls if anyone knew about generation of a payslip explain it in step by step
Posted 20th March 2010 From India, Hyderabad
Pls send ur salary sheet for auto payslip generate purpose. I will send in excell sheet for auto generate payslip as well as word file also If any query pls free feel contact 09160019220.
Posted 23rd March 2010 From India, Hyderabad
Indresh

Open your Word Document

Choose Main Menu -> Tools - > Letters and Mailings

After enabling Letters and Mailings, you can use its tool bar, then try to use these buttons one by one that will lead you to select the fields whichever to be displayed in your document.

After selecting necessary fields, <<< ABC>> that will make the link to fetch out the data from your excel and and display it word in the specified positions.

It is so easy process, you can make it. Do it then you will get it.

Regards
Prabakar
Posted 24th March 2010 From India, Madras
KPK SARMA sarmakpk1981@gmail.com Thank you so much for your kindful support and reply Regards Prabakar
Posted 24th March 2010 From India, Madras
Hi All

have viewed the above attachment for payroll and payslip but cannot adapt myself. What I am looking for is how top prepare the formula so as to have the inforMation from the payroll transferred to the payslip. I have a colleague working on this attachment but he is no more. So I find myself at a loss to add or delete new recruits. What I mean is to have a good tutorial to start afresh. Anyone to help.
Posted 16th June 2010 From Mauritius
HELP i have 200 employee i need a spread sheet that i can use to do payslip, that calculate and accumulate figure and on another sheet is show PAYE only
Posted 12th November 2010 From Botswana, Gaborone
respected sir i need entire dept formats of esi and pf and all the labour dept formats can any one mailme to my email id ravi.nandi82@gmail.com
Posted 12th November 2010 From India, Bangalore
thnnx for your guidence.

can you help me in doing the job such as if the excel sheet contain 100 employees and then how to connect all this employee into the payslip through the mail merge so that at a time all 100 payslip will be generated as the master pay excel sheet is final.

Waiting for your reply.
Posted 13th August 2012 From India, Mumbai
hi.. i saw your about comments and responding to the post... i understood how to prepare in excel sheet... then how can i generate for each individual
Posted 13th September 2013 From India, Hyderabad






 
 
 
 







Found This Useful? +Vote Up This Via Google.  

Why Vote? User validation is extremely important for good content to prosper.
Disclaimer: This network and the advice provided in good faith by our members only facilitates as a direction towards the actions necessary. The advice should be validated by proper consultation with a certified professional. The network or the members providing advice cannot be held liable for any consequences, under any circumstances.

About Us - Advertise - Contact Us - RSS   On Google+  
Copyright 2016 Cite.Communities (CiteHR.Com) User contributions are owned by the contributor.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network