Get it - $14

Weekly tip-outs in minutes, with no calculator math.

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 - $14
Instant download · Excel + Google Sheets · One-time payment, no subscription
Weekly Tip Pool Calculator: hours, payouts and printable payout slip

Tip pooling shouldn't eat your Sunday night.

This spreadsheet does all of that for you and shows its work.

What's inside

Daily or weekly pools

Split each day's tips among that day's crew (fairest), or use one weekly pot. Change it with one dropdown.

Hours or role points

Equal per hour, or weight by role (for example Server 1.0, Busser 0.5, Host 0.4). Set your own points.

Card and cash, kept separate

See exactly how much cash to hand out tonight and how much card tips go through payroll.

Printable payout slips

Pick a name to get a day-by-day breakdown with a signature line. It answers "how did you get that?"

Built-in checks

A balance check confirms every dollar is assigned. It also warns you if a day has tips but nobody eligible clocked in.

Keeps managers out of the pool

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.

How it works

Set it once.
Enter your business name and roles, and choose daily or weekly pools.
Type tips and hours.
Seven days of card and cash tips, plus each person's hours.
Pay out.
Open Payouts, check that the status line is green, and print slips if you need them.

One price. Use it every week.

$14 one-time
  • Weekly Tip Pool Calculator (.xlsx)
  • Works in Excel, Google Sheets, LibreOffice and Numbers
  • Quick Start Guide (PDF)
  • Free updates to this version
Buy and download now

Secure checkout. You get the download link on screen and by email right after you pay.

FAQ

Does it work in Google Sheets?

Yes. Upload the .xlsx to Google Drive and choose File → Save as Google Sheets. The formulas, dropdowns and warnings all carry over.

Daily pools or weekly pool: which should I use?

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.

How many employees does it handle?

Up to 30 people per week, with any number of roles you define.

Can I include kitchen staff?

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.

Does it connect to Toast, Square or my payroll?

No. It's a simple spreadsheet. You type or paste in the daily tip totals and hours from your POS or time clock.

Is this legal or payroll advice?

No. It's a calculation tool. Your tip policy and payroll taxes are up to you, your accountant and your state's rules.

What if it doesn't work for me?

Email me within 14 days and I'll help you set it up or refund you.

Get your Sunday night back.

Download the calculator - $14