Need Help into create an Automatic Payroll System on Excel

[Frank94]

Hello,

Ive started a new job as a marketing representative, and i have to do data entry and payroll manually. its a pain in the back if im honest, and i was wondering about doing a data entry + payroll system automatic in excel. basically, the only thing to enter would be the number of hours someone worked. The pay works by hour and with bonus. meaning for any name that are written off or booked into an appointment there a bonus that gets added up.

basically i want that when someone write in the name of either a booked or none booked appointment, that on the payroll sheet, it adds the corresponding bonus to the person payroll.

If Anyone could tell me what fonctions to use i would be grateful.

Thank You

[Kevin#]

welcome to the forum
can you tell us
- how many sheets are there?
- what are they called?
- what are the column titles are on each sheet?
- is the data input weekly or monthly?
- are they collated on weekly or monthly basis?
- which columns will be input?
- which columns will be calculated AND what is the calculation description for each column

[Frank94]

there will be a minimum of 5 sheets. 1 sheet is the Data Entry, and the 4 other are for the employee payslip (one sheet per employee)

So far data entry is Called "PAP" Then the other are Named Francisco, Sacha, Alex, Christian.

On the data Entry We got "Code,(emptyslot),Date,Représentant,Nom,Adresse,Ville,# de telephone,Service,Bouqué,Date Rendez-Vous,Note" (Code is A1 and Note is L1)
As on the payroll im currently remaking the file, ill ahve it ready by tomorrow. my emplyee payroll system was a mess, and was not efficient to work with.

Data are inputed on a daily basis But payrolls are made weekly. I can attach tomorrow an exemple of the excel file.

[newdoverman]

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[FDibbins]

Have you tried a google search for this? (a search for "excel payroll template" got almost 1/2 million)