How do you calculate payroll with tips?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payroll tax deductions 4
Help with a formula 2
PAYROLL CALCULATION 4
3D Array Payroll 2
Locking cell data from change 1
can excel calculate payroll taxes? 1
Amazon warehouse managers are muscling employees to save money. 2
Calculating payroll cost 1

Back
Top