Payslip Generation From Excel. - Xls Download - CiteHR
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...
Hi, indresh Try this and send u r comment. note P.Tax calculated for TN Thx Kris

Attached Files
Membership is required for download. Create An Account First
File Type: xls Sample STRUCTURE- Temp-.xls (32.0 KB, 2290 views)

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

Dear All, Please find attached Payroll in Excel with automated Payslip & salary register.... Regards, Sameer

Attached Files
Membership is required for download. Create An Account First
File Type: xls PAYROLL.xls (211.5 KB, 3109 views)

One more format for all. Attached is a format for payslip as well. I hope this helps

Attached Files
Membership is required for download. Create An Account First
File Type: xls Book1.xls (42.0 KB, 1809 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
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....

Attached Files
Membership is required for download. Create An Account First
File Type: doc Piyush.doc (40.5 KB, 1225 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

[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


Attached Files
Membership is required for download. Create An Account First
File Type: doc autofin payslip.doc (314.0 KB, 3362 views)
File Type: xls SALARY STATEMENT.xls (322.5 KB, 2815 views)

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

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™