A ready-made tip pool calculator for Excel and Google Sheets. Type in tips and hours, and it splits card and cash tips fairly by hours or role points, day by day, down to the cent.
Download the calculator - $14This spreadsheet does all of that for you and shows its work.
Split each day's tips among that day's crew (fairest), or use one weekly pot. Change it with one dropdown.
Equal per hour, or weight by role (for example Server 1.0, Busser 0.5, Host 0.4). Set your own points.
See exactly how much cash to hand out tonight and how much card tips go through payroll.
Pick a name to get a day-by-day breakdown with a signature line. It answers "how did you get that?"
A balance check confirms every dollar is assigned. It also warns you if a day has tips but nobody eligible clocked in.
Mark a role "Not in pool" and the sheet gives it $0 and flags it, in line with federal tip-pool rules.
Also included: up to 30 staff, a role dropdown, whole-dollar cash rounding, an optional card-fee setting, a sample week to learn from, a Start Here tab and a 2-page Quick Start PDF.
Secure checkout. You get the download link on screen and by email right after you pay.
Yes. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. The formulas, dropdowns and warnings all carry over.
Daily pools give each day's tips to the people who worked that day, which most staff see as the fairest. A weekly pool is simpler. You can switch at any time with one dropdown.
Up to 30 people per week, with any number of roles you define.
You choose who is in the pool. Under federal rules, if you take a tip credit the pool can include only employees who customarily and regularly receive tips, and managers and supervisors can never keep tips. Check your state's rules. The Start Here tab explains this and links to the U.S. Department of Labor fact sheet.
No. It's a simple spreadsheet. You type or paste in the daily tip totals and hours from your POS or time clock.
No. It's a calculation tool. Your tip policy and payroll taxes are up to you, your accountant and your state's rules.
Email me within 14 days and I'll help you set it up or refund you.