Free Tip Pool Calculator: Restaurant Formula and Excel Setup

Friday service is over. The card terminal and cash count show a $500 tip pool, five people worked 31 eligible hours, and everyone wants the payout before they leave. This is where a tip pool calculator earns its keep: one total goes in, one written distribution rule is applied, and every cent comes back out with an employee name beside it.

For an hours-based pool, the core formula is employee payout = total tip pool x employee eligible hours / total eligible hours. If the restaurant assigns different portions to service, bar, kitchen, or support, calculate each role's share first and then split that share by hours inside the role.

You can run both methods in the free restaurant tip pooling calculator without signing up. The rest of this guide shows the math, the Excel formulas, and the rounding check so you can audit the result instead of trusting a black box.

How to calculate a tip pool by hours

Start with the hours method when every eligible hour carries the same weight. Add the eligible hours, divide each person's hours by that total, and multiply by the pool.

The payout percentages come from hours, not job titles. Ava worked 24.19% of the eligible hours, so her share is 24.19% of the pool before cent allocation. This method is easy to explain and easy for staff to check against a time record.

Eligible hours should come from the restaurant's written policy and approved time record. Do not quietly use scheduled hours for one person and clocked hours for another. Pick one source for the whole pool and record any correction before payout.

The one-cent problem is part of the calculation

If you round each raw payout to two decimals in the example above, the five rows add to $499.99. The formula is correct. Currency simply cannot carry the fractions of a cent produced by 31 hours.

A complete tip pooling calculator needs a cent-allocation rule. One common approach calculates in whole cents, gives everyone their base whole-cent amount, and assigns the remaining cents by the largest fractional remainders with a stable tie-break order. The example gives the tied extra cent to Noah, so the payouts total exactly $500.00.

Do not hide the difference in a general expense row. Label the adjustment, keep the same tie-break rule every time, and verify that distributed tips + any explicitly unallocated share = the original tip total.

When role percentages belong in the pool

Some restaurants decide that an hour in each role should not draw from the same bucket. The policy might assign 60% to service, 20% to bar, and 20% to kitchen and support. That is a policy choice. The calculator's job is to apply it without changing the percentages after the shift.

Using the same $500 close, role percentages create three smaller pools. Hours then decide each payout inside its role.

Role percentages add one failure case: a funded role may have zero worked hours. Decide in advance whether that share stays unallocated, moves to a named fallback role, or is redistributed across active roles. The free calculator exposes all three choices and never moves an empty role's money silently.

Build a tip pool calculator in Excel

A basic Excel tip pool calculator needs a total cell and one employee table. Put the total tips in B1. Use rows 5 through 9 for employee name, role, and eligible hours.

Copy the hours formula through F8. The F9 formula assigns the remaining cents to the named reconciliation row so the sheet totals exactly. That shortcut is transparent, but it is not a largest-remainder calculation. If you want the cent adjustment to follow fractional remainders, use the free calculator or add a tested allocation routine instead of a hidden manual edit.

For role percentages, create a small role table in H5:I7. Put Service, Bar, and Support in H, with 60%, 20%, and 20% in I. Then use =SUMIF($B$5:$B$9,B5,$C$5:$C$9) to calculate role hours and =SUMIF($H$5:$H$7,B5,$I$5:$I$7) to fetch the role share. The payout formula becomes =ROUND($B$1*E5*C5/D5,2), where D is role hours and E is the role percentage.

Microsoft's SUMIF documentation explains the range, criteria, and sum-range arguments used here. Before using the sheet, add four checks: the role percentages equal 100%, no eligible employee has blank hours, no funded role has zero hours without a written rule, and the final payouts equal B1.

Use the tool that matches the closeout job

My default is simple: use the free calculator for an occasional pool, Excel when the calculation must feed another workbook, and a saved weekly workflow when managers keep rebuilding the same employee and hours data.

A correct payout still needs a closeout record

The raw formula does not tell a manager which hours were approved, which roles receive a percentage, what happens to an empty role, or who signed off after a correction. Those decisions are where a repeatable process either holds up or falls apart.

MAXUOD's contribution is the operating handoff. We compare the written policy with the hours and roles in the week, identify the choices that must be explicit, specify the calculation and empty-role rule, put the method into the calculator or saved Maxuod Shift workflow, and verify that every cent reconciles. The final packet is the source total, employee breakdown, method, exception note, and PDF or CSV record.

Measurement is modest but useful: count late corrections, unallocated shares, and payout questions over several closes. The next decision is based on that record. Keep the method if the same inputs produce a clean result, or revise the policy and training if managers keep making the same exception by hand.

The formula cannot decide who may participate

Canadian tip rules differ by province, and payroll treatment can depend on who controls the tips. Ontario says employers may collect and redistribute tips through a tip pool but generally cannot withhold or deduct tips outside permitted cases. British Columbia also allows required redistribution while limiting employer participation. The Canada Revenue Agency distinguishes controlled tips from direct tips when explaining payroll deductions and T4 reporting.

Check the current Ontario tips and gratuities guide, B.C. tips and gratuities guidance, and CRA tip treatment page before changing a policy or payroll process. For a wider provincial overview, read tip pooling laws in Canada and the restaurant tip pooling policy template.

Sources checked on 2026-07-10. This article shares MAXUOD's professional view for education and operations planning. It is not legal, payroll, tax, financial, or purchasing advice. Rules and official guidance can change, so confirm the jurisdiction where each employee works. Product names and trademarks belong to their owners. No affiliate links are used.

Choose the method before the next shift

Hours-based pooling is the clearest default when every eligible hour has equal weight. Role percentage plus hours works when the restaurant has already documented different role shares and has a rule for empty roles. Excel is fine when someone owns the formulas and the reconciliation check. Otherwise, the free calculator removes the part most likely to be missed at close: exact cents.

Run the five-person example in the free tip pool calculator, replace it with one real shift, and compare the output with your written policy before anyone is paid.

FAQ