Splitting tips by hours worked is the method most people can explain in one sentence: everyone gets a share in proportion to the hours they put in. It is also the method that goes wrong most often in practice, because real shifts are not tidy. Someone leaves early. Someone comes in for the rush. Someone's clock-in is wrong.
Here is how the method works, with the awkward cases included, and a spreadsheet template so you do not have to build one.
The basic method
Three steps.
- Add up the total tips in the pool for the period (a shift, a day, a week).
- Add up the total hours worked by everyone in the pool for the same period.
- Divide the tips by the hours to get a rate per hour. Multiply each person's hours by that rate.
Example: one shift, four people.
Pool: $600. Hours: Ana 8, Ben 8, Cal 6, Dee 4. Total: 26 hours.
Rate per hour: $600 ÷ 26 = $23.08 (rounded).
- Ana: 8 × $23.08 = $184.62
- Ben: 8 × $23.08 = $184.62
- Cal: 6 × $23.08 = $138.46
- Dee: 4 × $23.08 = $92.31
Total: $600.01. Rounding will leave you a cent or two out; decide in advance where it goes.
That is the whole method. The difficulty is in the inputs.
Where it gets awkward
Partial shifts and early leavers. If Cal was scheduled for 8 hours but left after 6, the honest number is 6. Using scheduled hours instead of actual hours is the most common error in a manual hours-based pool. It rewards the schedule, not the work, and the people who stayed notice.
Late clock-ins and forgotten clock-outs. Hours-based pools are only as good as the time data. A server who forgot to clock out at 10pm and was auto-clocked at midnight just took two hours of the pool from everyone else. Reconcile the clock data before you split.
Different roles, same hours. A pure hours split treats an hour behind the bar and an hour running food as equal. Many operators do not want that. The fix is to combine hours with a role weight: multiply each person's hours by a point value for their role, then split by the weighted total. That is the points system, which we cover in The Tip Pool Point System, Explained.
Weighted example. Same four people, but Ana and Ben are servers at 1.0, Cal is a bartender at 1.0, Dee is a busser at 0.5.
- Ana: 8 × 1.0 = 8
- Ben: 8 × 1.0 = 8
- Cal: 6 × 1.0 = 6
- Dee: 4 × 0.5 = 2
Weighted total: 24. Rate: $600 ÷ 24 = $25.00.
- Ana: $200. Ben: $200. Cal: $150. Dee: $50.
Split shifts and role changes. If Dee bussed for 2 hours then hosted for 2, and the roles are weighted differently, treat them as two entries. Most manual sheets cannot do this cleanly. Most disputes start here.
Who is in the pool. Hours-based or not, managers and supervisors are never in it, and whether back-of-house can be included depends on whether you take a tip credit. See who can be in a tip pool.
Where Ferry fits
A spreadsheet handles one shift at one location. It does not pull actual hours from the POS, it does not know that Dee changed roles at 8pm, and it cannot be trusted across five locations with five closing managers.
Ferry Tip Manager pulls sales and hours from your POS and HCM data, applies the split method you have configured (hours, points, percentage or a combination), handles role changes and partial shifts from the actual clock data, and delivers payroll-ready files with the calculations already in them. Fully automated, no manager intervention at shift end.
The template is a good start. When it stops being enough, that is usually around location three. Book a demo.
FAQ
How do you split tips by hours worked?
Add up the total tips in the pool and the total hours worked by everyone in the pool. Divide tips by hours to get a rate per hour, then multiply each person's actual hours by that rate.
Should I use scheduled hours or actual hours to split tips?
Actual hours. Using scheduled hours rewards the schedule rather than the work and is the most common source of disputes in hours-based pools.
Can you split tips by hours and by role at the same time?
Yes. Multiply each person's hours by a weight for their role, then split the pool by the weighted total. This is a points-based pool.
Is there a free tip splitting calculator?
Yes. Ferry's free tip pooling calculator splits a night's tips in seconds, and the spreadsheet template in this article handles hours-based and weighted splits.