ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you calculate payroll with tips? (https://www.excelbanter.com/excel-discussion-misc-queries/39940-how-do-you-calculate-payroll-tips.html)

sarah

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.

Michael

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