Skip to content
GraviPointThe Centre of Productivity
  • AI AgentNew
  • Pricing
  • Community
Log inGet started free
TemplatesTravel & HospitalityHospitality OperationsTip Pool Calculator

SpreadsheetHospitality OperationsFree

Tip Pool Calculator

Split the night’s tips fairly by hours worked and role points, with each person’s share, payout and tips per hour.

Shown with sample data

Colour

Tip Pool Calculator

Split the night’s tips fairly by hours worked and role points, with each person’s share, payout and tips per hour.

Tip pool
$2,455
Hours worked
64.5
Average tips per hour
$38.06
Rounding difference
$0.01
Should be within a few cents
Tip payout by employee
  • Priya Nair$376.18
  • Chloe Wang$376.18
  • Kayla Brooks$352.67
  • Marco Ruiz$282.14
  • Tom Reed$258.63
  • Ben Ortiz$235.11
  • Ana Silva$169.28
  • Jake Miller$164.58

How to use it

  1. 1Enter the shift’s card tips and cash tips on the Pool sheet.
  2. 2Agree the points for each role with your team and set them on the Roles sheet (all 1s = split by hours only).
  3. 3List everyone who worked with their role and hours.
  4. 4Pay out the Tip payout column and keep a copy of the sheet as your record.

In this workbook

  • About
  • What’s included
  • How to use
  • Questions
  • Related resources

About this template

Tip pools cause arguments when nobody can see the maths. Enter the card and cash tips for the shift, each employee’s role and hours, and the points each role earns; the calculator works out everyone’s points, share of the pool, payout to the cent and tips per hour, and shows any rounding difference so the payouts add up exactly. Set every role to 1 point for a pure hours-based split.

Who it’s for

  • Nightly or weekly tip pools
  • Mixed teams of servers, bartenders, bussers and runners
  • Showing staff a transparent, consistent split

What’s included

  • Staff sheet: Everyone in the pool with hours, points and payout.
  • Pool sheet: The tips going into the pool.
  • Roles sheet: Points per hour for each role.

How to use it

  1. 1Enter the shift’s card tips and cash tips on the Pool sheet.
  2. 2Agree the points for each role with your team and set them on the Roles sheet (all 1s = split by hours only).
  3. 3List everyone who worked with their role and hours.
  4. 4Pay out the Tip payout column and keep a copy of the sheet as your record.

Tips

  • Tip-pooling laws vary by country and state. In the US, for example, managers and supervisors generally may not keep tips from a pool, and some states restrict who can be included. Check your local rules; this is not legal advice.
  • Put the points system in writing and share it with staff before you use it.
  • Record tips paid out for payroll tax reporting where your jurisdiction requires it.

Questions

How does a points-based tip pool work?

Each role is worth a number of points per hour. A person’s points are hours × role points; their share of the pool is their points divided by everyone’s points.

What is a fair points split?

A common starting point is servers and bartenders 10, food runners 6, bussers and barbacks 5, hosts 4, but agree it with your team.

Can card processing fees be deducted from tips?

Some jurisdictions allow deducting the fee on the tip portion only; others forbid it. Leave the deduction at 0 unless you are sure it is allowed.

Related searchestip pool calculatortip out calculatortip sharing spreadsheettip distribution by hourstip pooling points systemrestaurant tip split

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Download a copy

Downloads need a free account.

SpreadsheetHospitality OperationsFree

Tip Pool Calculator

Split the night’s tips fairly by hours worked and role points, with each person’s share, payout and tips per hour.

A free account keeps your copy safe so you can come back to it. Have one? Log in

Download a copy

Downloads need a free account.

Details

Format
Spreadsheet
Category
Hospitality Operations
Sheets
3
Setup
10 min
Level
Beginner
Price
Free

Your copy is private to you.

More hospitality operations templates

View all
Recipe & Menu Costing Calculator2 sheets

Dishes costed

4

Average food cost

23%

Dishes above 35%

1

ABCD
1DishCategoryPortions per batchMenu price
2Tomato & basil soupStarter10$7.50
3Grilled chicken saladMain4$16.00
4Beef burger with friesMain4$13.00
5Chocolate brownieDessert12$6.50
Menu
SpreadsheetHospitality Operations

Recipe & Menu Costing Calculator

Cost every dish from its ingredients, see food cost percentage and margin, and get a price that hits your target.

10 min setupPreview
Vacation Rental Booking & Income Tracker2 sheets

Nights booked

30

Net income

$5,262

Average nightly rate

$169

Fees by platform
$309
$45.20
$38.40
Booking.comVrboAirbnb
SpreadsheetHospitality Operations

Vacation Rental Booking & Income Tracker

Bookings from every platform with nights, fees and net payout, plus occupancy and income for the season.

10 min setupPreview
Hotel Housekeeping Schedule2 sheets

Rooms to clean

6

Done

3

Early arrivals

2

ABCD
1RoomRoom statusPriorityHousekeeper
2101Check-outEarly arrivalRosa
3102Stay-overNormalRosa
4103Check-outNormalAhmed
5104Vacant cleanNormalN/A
Today
SpreadsheetHospitality Operations

Hotel Housekeeping Schedule

Assign rooms to housekeepers with room status, priority and inspection results.

10 min setupPreview

Practical guides and new resources, monthly.

One short email with new templates, calculators and how-tos. Unsubscribe any time.

GraviPointThe Centre of Productivity

Find the right resource. Make it work for you. Get things done with spreadsheets, documents, forms and calculators you can use right in your browser.

support@gravipoint.com
  • @gravipoint
  • @GraviPoint
  • GraviPoint
  • 𝕏@gravipoint

Templates

  • All templates
  • Budgets & expenses
  • Invoices & billing
  • Project management
  • HR & people
  • Inventory & stock
  • Sales & CRM
  • Financial calculators

Popular

  • Monthly budget
  • Invoice
  • Employee shift schedule
  • Weekly timesheet
  • Project plan & Gantt chart
  • Inventory tracker
  • Expense report
  • Mortgage calculator

Solutions

  • Individuals & households
  • Freelancers & consultants
  • Founders & startups
  • Small business owners
  • Teams & operations
  • Students & educators

Company

  • About
  • Features
  • Pricing
  • Community
  • Journal
  • Contact
© 2026 GraviPoint. All rights reserved.
  • Privacy
  • Terms
  • Help centre
  • FAQ