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.

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.