PaySlip Generation From Excel. - Pay Slip
CiteLegal
 
HOME RISE NEW ABOUT LOGIN
Home > Human Resource Section > Forms, Formats & Questionnaires

PaySlip Generation From Excel. - Pay Slip

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.

Indresh - Member Since: Aug 2008
Hi Rajasekar, Can you explain me about the mail merger option. How do I go about it and what are the steps.

rajasekar16 - Member Since: May 2008
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

Akshu Puri - Member Since: Jan 2009
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

venkat@tower - Member Since: Jan 2009
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

Bhanumurthy - Member Since: Nov 2006
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.

Indresh - Member Since: Aug 2008
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.

chaitra_krishnaiah - Member Since: Jan 2008
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.

krishnarfc - Member Since: Feb 2007
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 FilesProvided by community member krishnarfc. Join us to learn and grow with your peers.
File Type: xls Salary Statement.xls (292.0 KB, 6310 views)
bmchr - Member Since: Sep 2007
Hi Indresh, u can download the trial version of pdf convertor and convert your excel sheet into pdf format and use as pay slip.



Found This Useful? +Vote Up This Page 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.




Explore Topical Knowledge Areas

Interesting Relevant Discussions


DISCUSSSION STATISTICS


11
LIKES

26772
VIEWS

33
REPLIES

PLEASE KEEP YOUR CONDUCT PROFESSIONAL AND POLITE


3M Users, 100K+ Documents & 450K+ Discussions

Share »

Community Support & Professional Insights. Login or Register.
Email/Username     Password  

About Us - Advertise - Contact Us - RSS   On Google+  
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service
Facebook Page | Follow Us On Twitter | Linkedin Network