• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Salary Computation & Payslip (Additional Entry & Auto Update)

J

John W

New Member
Hi,

In my excel file (Sample-Salary Computation & Payslip), I have 2 worksheets (Salary Computation & Payslip).

Is there any solution such that, any additional entry in a new row under worksheet “Salary Computation” (highlighted in yellow), will automatically create an additional payslip in the worksheet “Payslip”, continuing from the previous 2 payslip?

Any advice?

Thank you.
 

Attachments

Hi:

What is the purpose of multiple payslips, is it for printing ? If yes, a VBA can do this with just one template by looping through the Salary Computation data. Let me know your thoughts.

Thanks
 
Hi Nebu,

Yes, is meant for printing.

Currently I'm facing the following problem:

1. We have staff turnover, and we still new need to print all their payslip for those who have resigned or recruited for the month.

2. Sometime we may even have staff coming back to us and request for another copy as they have lost it.

3. My company is currently reviewing the remuneration package for the staff and this imply there will be changes in the payslip format due to the additional incentives and allowances and also the information added into the payslip.

Can you advice me how VBA Macros can assist me to print additional payslip due to new recruitment and minimise the time taken for the amendment needed to change format of the payslip resulted in changes of the remuneration package ?

Really appreciate your advice.

Thank you.

John.
 
Hi John ,

The basic criterion to be considered is the data volume ; how many employees do you have , and how much of data ( going back how many years ) do you have to retain , either for statutory purposes or for merely administrative purposes ?

Based on the volume of data , if the number of rows of data in a worksheet tab will exceed , say 10000 , then it might be better to consider Access.

Similarly , if the number of employees is a small number , then it can certainly be done using Excel and VBA , but if goes beyond a reasonable number , say if you have 50 or more employees , then it may be better to switch to Access.

Since the printing of the payslip will be an infrequent exercise , it is not necessary to store all printed payslips , unless there will be frequent changes in salaries.

All employee data can be stored in its raw form , and payslips can be generated and printed on the fly.

Narayan
 
Nebu said:
Hi:

Please find the attached , copy the employees to the tab to be printed and click on the button print , it will print payslip for all the records in this tab.

Thanks
Click to expand...

Hi Nebu,

Thank you for your assistance.

Can you advice me the steps on how you do it?

Thank you.
 
Hi:

I have created two tabs one tab is the main data tab which will have all the employees's details( as mentioned my Somendra and Narayan, you can explore the use of access to build the main DB if the no.of employees in your organisation are more).

The next tab is the data for print tab, which will have only those employees who's payslip you want to print.( if using access you can build in a query in access to pull the employee details and link it to the excel) I created this tab so that when you run the macro it won't print the entire DB.

Once you click on the Print button , it will fill in the details from the data for print tab and will print the payslips (in this case 3 pay slips), I have given the salary payment date as month end date - 2 days , you can keep this or else you can create a column for payment day and pull the dates from there.


Thanks
 
Nebu said:
Hi:

I have created two tabs one tab is the main data tab which will have all the employees's details( as mentioned my Somendra and Narayan, you can explore the use of access to build the main DB if the no.of employees in your organisation are more).

The next tab is the data for print tab, which will have only those employees who's payslip you want to print.( if using access you can build in a query in access to pull the employee details and link it to the excel) I created this tab so that when you run the macro it won't print the entire DB.

Once you click on the Print button , it will fill in the details from the data for print tab and will print the payslips (in this case 3 pay slips), I have given the salary payment date as month end date - 2 days , you can keep this or else you can create a column for payment day and pull the dates from there.


Thanks
Click to expand...

Hi Nebu,

Thank you for your guidance.

Cheers.
 
You must log in or register to reply here.
Back
Top