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. |
All times are GMT +1. The time now is 06:27 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com