Home / Templates / Shift Tip Pool Record Sheet
Free worksheet

Shift Tip Pool Record Sheet

A per-shift record that lists every pool participant with hours, role points, weighted hours, share, and how it was paid, so any close can be rebuilt months later.

Download the worksheet (.csv)

Reviewed for 2026, updated September 8, 2026.

A tip record is only complete if someone who was never in the building could rebuild the calculation from it. This sheet captures the fields that make that possible for one pool period: who was in the pool, what role they worked, how many hours, what point value the policy assigns to that role, and the share that resulted. Fill in one row per person per role, so an employee who moved from the floor to the bar mid-shift gets two rows. Write the pool total, the pool period, the date, and the approver's name at the top of the printed sheet.

The math is the weighted hours method covered in our guide at /guide/ and in the article at /blog/split-tips-hours-vs-points/. Weighted hours are hours times points per hour, with a server as the reference role at 1.0. The pool rate is the pool total divided by the sum of all weighted hours, and each share is that person's weighted hours times the pool rate. The Tip Pool Split by Hours and Points Calculator at /tools/tip-pool-split-calculator/ produces the pool rate for you; this sheet is where you record the per-person result and keep it with your payroll files. The point values below are placeholders, not recommendations; use the numbers in your own written policy.

EmployeeRole in this periodHours in pool periodPoints per hourWeighted hoursShare of poolPaid via
Server 1ServerYour hours1.0 (reference role)Hours x pointsWeighted hours x pool ratePayroll
Server 2ServerYour hours1.0 (reference role)Hours x pointsWeighted hours x pool ratePayroll
Server 3 (left early)ServerActual clocked hours1.0 (reference role)Hours x pointsWeighted hours x pool ratePayroll
Bartender 1BartenderYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool ratePayroll
Bartender 2BartenderYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool ratePayroll
BarbackSupportYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool ratePayroll
BusserSupportYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool ratePayroll
Food runnerSupportYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool ratePayroll
HostSupportYour hoursYour policy value, relative to a server at 1.0Hours x pointsWeighted hours x pool rateCash, signature on file
Split shift (one person, two rows)Server, then bartenderHours per role on separate rowsPoints for each roleHours x points per rowWeighted hours x pool rate per rowPayroll
TotalsAll rolesSum of hoursn/aSum of weighted hoursMust equal the pool totalCash total and payroll total

Also from TipPoolr