| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do you calculate payroll with tips?
Does anyone know how to set up a payroll spreadsheet that not only calculates
hours and wages, but also tips? I need it it to do all of the taxes as well. Pretty much the normal payroll spreadheet, but claiming earned tips as well. |
|
#2
|
|||
|
|||
|
Assuming that your data items are in columns and your employees in rows, I'd
add two columns next to wages: Tips and Total Earnings. Total earnings being the sum of Tips and Wages. HTH -- Sincerely, Michael Colvin "sarah" wrote: Does anyone know how to set up a payroll spreadsheet that not only calculates hours and wages, but also tips? I need it it to do all of the taxes as well. Pretty much the normal payroll spreadheet, but claiming earned tips as well. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i make overtime in my payroll sheet calculate after 42.5 h. | Excel Worksheet Functions | |||
| payroll calculator for ontario canada, cant convert ontario rates. | Excel Discussion (Misc queries) | |||
| Not able to calculate. | Excel Worksheet Functions | |||
| Need help with conditional rates and roster times for payroll | Excel Discussion (Misc queries) | |||
| How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions | |||
Linear Mode
