Tip pool split sheet
Print this page (Ctrl+P / Cmd+P). Example rows are illustrative; blank rows are for your numbers. Back to the template
| Name | Role | Hours | Points | Weighted hours | Share % | Payout |
|---|---|---|---|---|---|---|
| Alex | Server | 32 | 1 | 32 | 28.4% | 341.33 |
| Sam | Server | 28 | 1 | 28 | 24.9% | 298.67 |
| Jo | Bartender | 30 | 1 | 30 | 26.7% | 320.00 |
| Riley | Busser | 25 | 0.5 | 12.5 | 11.1% | 133.33 |
| Max | Runner | 20 | 0.5 | 10.0 | 8.9% | 106.67 |
To split by points, give roles a weight (for example servers 1, bussers 0.5); weighted hours = hours x points. Each payout = pool x weighted hours / total weighted hours, and a check cell shows any rounding difference.
Free template from thehospitalityinsider.com/templates/