LIVE GST Certification Course by CA Arun Chhajer begins 27th April. Register Now!!

Automatic Salary Slip Generator using Excel

BINU.M.S (MCOM MBA ICWAI-Inter(Studying)) (197 Points)

09 July 2008

Dear Friends

I am using Excel for preparing Salary Statements.I want to know
how excel can be used to prepare payslips automatically.Can
any one tell me the process/function which is used to convert
salary statement into salary slips.I am expecting a quick and
positive response from you...

Thanks In advance
BINU.M.S

Reply
Follow
Share

39 Replies

Sauve (Management Consultant) (25 Points)
Replied 09 July 2008

Hi,

A very quick (probably dirty too) solution is as follows:

1. Use the FILE->PAGE SETUP option and click the SHEET tab and set "ROWS TO REPEAT AT TOP" as the column-heading of your EXCEL Worksheet. Press OK button after you have done it.

2. Now launch the FILE->PRINT PREVIEW option and click the button named MARGIN. (You will see this button on the top).

3. We will now set the margin to print only one record per page. To do this pull the Top Margin indicator thread downwards and then pull the Bottom Margin indicator thread upwards. Note that the print preview shows one record and column heading in each page. Do cycle through the records by clicking the NEXT button and satisfy yourself about the format before printing.

Suggestion: To save pages, you can save the printout to a text file, open this saved file using an editor and replace the PAGE BREAK characters by couple of NEW-LINE CHARACTERS or by a simple continuous line (“-------”) to act as separator between records. (Do this only if you are comfortable with the process.)

A neat solution would be to use Excel Macros (using VBA or VB) or to import the data from your worksheet into a database and then programe the printout as desired.

Hope this helps.

1 Like

BINU.M.S (MCOM MBA ICWAI-Inter(Studying)) (197 Points)
Replied 09 July 2008

Thanks for the reply friend.I will check it out.

Anyone who have other ideas about this subject.Please share it...

Regards

BINUMS

(Guest)

HAVE U ANY IDEA ABOUT MS.ACCESS? IF YES THEN USING LINKING OPTION U CAN GENERATE & MANAGE SALARY SLIP WITH BEST ACCURACY. IN EXCEL U WILL FACE PROBLEMS 2 MANAGE REPORT. i.e. salary slip

regards

Satyendra sahu (service) (216 Points)
Replied 09 July 2008

Hi all

I am agree with vikas, nice suggestion to use MS ACCESS.

Good

BINU.M.S (MCOM MBA ICWAI-Inter(Studying)) (197 Points)
Replied 10 July 2008

Dear all

First of all Thanks for the reply.Both of you are suggesting MS Access is

better option for generating salary slips than Excel.My Idea is based on a Excel

Sheet that will have serial no of employees,their emp.code ,Basic,HRA

other deductions etc.So now how we can automatically generate Salary slips

based on the employee serial number.If you are suggesting MS Access is

good idea please tell me how we can link MS Acess with that Excel sheet or

if you have any other ideas also using excel please share it.

Regards

BINUMS

(Guest)

thanks

(Guest)

Originally posted by :BINUMS

Dear Friends
Binums could could you send me your salary slip statemant sheet i m working in Contractor service. every month i m facing lot of problem when i make wages of our employee plz tell me about how can i make eszy salary slip

thankyou

BINU.M.S (MCOM MBA ICWAI-Inter(Studying)) (197 Points)
Replied 02 August 2008

Mr.Nitin

After lot of discussions with lot of people I found MS office template ie,

payroll calculator.xls is useful for automatic preparation of salary

statements.If you want that template please download it from Microsoft

website...That will be helpful

(Guest)

dear sir,

i need a salary slip format .

please provide us

thanking you

deepak kumar

(Guest)

Payroll Processing Software in excel,

for this i need the functionality of storing data in some permanent file, making updations etc

so gong step by step first of all i want to know how to store data in excel / in database thru excel. Automatic salary Calculation & All Type Report Geberator in Ms Excelneratalary Slip Generator using Excel
Please send me file attached in Excel Format