This free Excel tip pool calculator splits a night’s tips by hours worked (with optional role weights and a separate back-of-house share) and — unlike most tip-out sheets — guarantees the individual payouts add up to the exact total, to the cent. Download it below, type in hours, and read the payout column.
Download: Restaurant Tip Pool Calculator (.xlsx)
Free, no sign-up. Works in Excel and LibreOffice; in Google Sheets use File > Import. 3 sheets: How to use, Tip Pool (up to 50 employees), Eligibility notes.
Why most tip pool spreadsheets are off by a few cents
The usual formula is =ROUND(pool * my_hours / total_hours, 2) in every row. Each row looks right, but the rounded rows rarely add back up to the pool. Three simple cases, calculated exactly:
| Pool | Split | Each person (rounded) | Sum of payouts | Error |
|---|---|---|---|---|
| $100.00 | 7 equal shares | $14.29 | $100.03 | 3¢ over — paid out money that doesn’t exist |
| $1,000.00 | 3 equal shares | $333.33 | $999.99 | 1¢ left in the drawer |
| $200.00 | 6 equal shares | $33.33 | $199.98 | 2¢ left in the drawer |
A few cents sounds trivial, but it means the sheet never reconciles with the cash count, someone has to fudge a row by hand every night, and “the spreadsheet says” stops being a reliable answer when a server asks why their share looks off. The free calculators we checked while researching this (from tip-payout and scheduling software vendors) don’t document how they handle this at all.
How this calculator splits the money
- Points = hours × weight. Weight defaults to 1 (a pure hours split). Give roles different weights if your house policy does — for example server 1.0, bartender 1.2, busser 0.7.
- Optional back-of-house share. Set a percentage in B4 (e.g. 20%) and the pool is split into a front-of-house pot and a back-of-house pot first; each pot is then divided by points within that group. Leave it at 0% for one pool across everyone.
- Largest-remainder rounding. Everyone first gets their exact share rounded down to the cent. The leftover cents — never more than one per person — go to the people whose dropped fraction was largest, ties broken by row order. Nobody is ever more than one cent from their exact share, and the total always matches.
- A check cell. B6 turns green “OK” when payouts equal the total. It turns red if money can’t be allocated — for example you set a BOH share but nobody in BOH has hours.
Ineligible employees (Eligible = N) and blank rows get zero points automatically. Group and Y/N entries are case- and space-insensitive, so ” boh” and “y” still work.
Worked example: $1,487.35 with a 20% back-of-house share
This is the sample data that ships in the file. The values below are what the spreadsheet itself calculated (recalculated in LibreOffice and read back), not numbers typed in by hand.
| Employee | Group | Hours | Weight | Eligible | Payout | Per hour |
|---|---|---|---|---|---|---|
| Maria (server) | FOH | 6.5 | 1 | Y | $268.08 | $41.24 |
| James (server) | FOH | 7 | 1 | Y | $288.71 | $41.24 |
| Aisha (bartender) | FOH | 8 | 1.2 | Y | $395.94 | $49.49 |
| Tom (busser) | FOH | 5 | 0.7 | Y | $144.35 | $28.87 |
| Sam (host) | FOH | 4.5 | 0.5 | Y | $92.80 | $20.62 |
| Dana (floor manager) | FOH | 9 | 1 | N | $0.00 | — |
| Luis (line cook) | BOH | 8 | 1 | Y | $169.98 | $21.25 |
| Kim (dishwasher) | BOH | 6 | 1 | Y | $127.49 | $21.25 |
| Total | $1,487.35 | |||||
Look at the BOH pot ($297.47 split 8:6): the exact shares are $169.9829… and $127.4871…. Rounded down that’s $169.98 + $127.48 = $297.46, one cent short. The cent goes to Kim, whose dropped fraction (0.71¢) was larger than Luis’s (0.29¢) — so the pot balances exactly.
Who is allowed in the tip pool?
The spreadsheet does the math; it doesn’t decide who’s eligible. Under U.S. federal law, per the Department of Labor’s Fact Sheet #15 (checked September 29, 2026):
| Situation | Federal rule | In this sheet |
|---|---|---|
| Managers and supervisors | May not keep employees’ tips (only tips customers give them directly for service they personally provide) | Set Eligible = N |
| Employer takes a tip credit (cash wage below $7.25, minimum $2.13/hr) | Pool limited to customarily tipped employees | Keep BOH share at 0%; list only tipped roles |
| Employer pays at least $7.25/hr in cash | A mandatory pool may include back-of-house staff | BOH share can be used |
Many states have stricter rules than the federal baseline, so check your state labor department too. This is a summary for orientation, not legal advice.
What each column does
| Column | You type? | Purpose |
|---|---|---|
| A–E (yellow) | Yes | Name, group (FOH/BOH), hours, weight (blank = 1), eligible (Y/N) |
| G Points | No | Hours × weight, or 0 if ineligible, blank, or zero hours |
| H Pool | No | Which pot the person is paid from (ALL when there’s no BOH share) |
| I Exact share | No | Unrounded share — useful for explaining a payout |
| J Payout | No | The amount to pay, balanced to the cent |
| K Tips per hour | No | Payout ÷ hours, for comparing roles |
| L–O (hidden) | No | Rounding helpers: floor, fraction, rank, leftover cents |
What was actually verified, and what wasn’t
Verified: the template was generated with real Excel formulas, recalculated by LibreOffice Calc (headless), and the calculated payouts were read back and compared cent-for-cent against an independent Python implementation of the same method using exact decimal arithmetic. That ran on 20 cases — the sample above, a single pool, 3-way and 7-way equal splits, a $0 pool, blank rows and zero hours, lowercase/space-padded entries, a BOH share with no BOH staff (the check cell correctly flags MISMATCH), and 12 randomized rosters of 2–50 people with random hours, weights, eligibility and BOH shares. All 20 matched exactly, every balanced case summed to the total, and no cell produced an Excel error.
Not verified: the file was not opened in Microsoft Excel itself or imported into Google Sheets — both use the same standard functions (SUMIFS, SUMPRODUCT, ROUNDDOWN), but that’s an expectation, not a test. The legal summary is from the DOL page, not from a lawyer.
Using it every week
Most kitchens copy the Tip Pool tab once per shift or per pay period (right-click the tab > Move or Copy > Create a copy). If you run the sheet in Google Sheets and want the payout table sent to managers automatically, the same idea as our script that emails a Sheets range as a PDF on a schedule works — point its range at the payout columns.
Tracking invoices rather than tip shifts? The same build-it, verify-it, reconcile-it approach went into our invoice tracker and AR aging template that handles partial payments — it ages the unpaid balance instead of the full invoice amount.