I am trying to figure out a way to create a tip-out sheet for my restaurant something in the lines along;
then to break down what the server made in tips and create a formula for the tip out process for tip out pool - Bar 5% Buss/Run 15% Host 3%
Please Login or Register to view this content.
Thanks!
Last edited by JBeaucaire; 05-24-2017 at 11:33 AM.
See the workbook at https://app.box.com/s/7eure8q5bljsn9nkjgx2
Entia non sunt multiplicanda sine necessitate
Originally Posted by shg
Thanks but what about the first part?
I want to get a formula to break down servers cashouts based on plugging in their daily sales while using theirs bar sales and food sales
What does that mean? What are the rules? Provide a clear example.I want to get a formula to break down servers cashouts based on plugging in their daily sales while using theirs bar sales and food sales
based on total sales, breaking down into columns like cash recvd cc recvd comps/voids cc tips and how much they owe at the end of the shift, all while using the POS printout from the waiter.
like columns then have excel do the formula;
server name | Sales | | Receipts |
(gross from pos) |Food Sales| Beverage Sales | (-)credit cards| (-)discounts | (-/+) Cash Due|
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks