What is included
- Shift records capture cash and card tips; the pool view calculates participant shares and payout amounts.
- Front-of-house allocation uses hours and role points, with an optional separate kitchen share.
- Setup includes role weights and optional card fees; the dashboard separates cash and payroll portions.
- Google Sheets and demo/blank Excel files are included; local participation and pooling rules must be checked separately.
Based on the Etsy listing reviewed October 28, 2026. Check the current listing for any later changes.
What to prepare
For the workflow this product is designed around, gather:
- The shift date and the recorded tips for that shift
- The participants and inputs required by your tip-sharing method
- Your approved tip-sharing rules and supporting records
A practical way to use your records
Define the shift being recorded, gather the source figures and use the restaurant's approved sharing method. Review the total allocation against the recorded pool before finalizing the shift record. Confirm the product supports your method on its Etsy listing.
A worked example
Fictional arithmetic example: a manager checks one shift's tip allocation under an already-approved hours-based method.
- Recorded pool
- $240 for one shift
- Participant A
- 6 eligible hours under the defined example method
- Participant B
- 4 eligible hours under the same method
- Example allocation settings
- Equal role points, 0% separate kitchen share and no card fee
- Keep the pool, participants and hours tied to the same shift and confirm that the actual policy permits the method being used.
- Check the calculated shares against the source pool before finalizing the shift record, including any rounding adjustment.
Result: The example has 10 hours in total and $24 per hour, giving shares of $144 and $96. They reconcile to $240. This demonstrates arithmetic only; it does not establish who may participate or what local rules permit.
Fictional figures explain the workflow; they do not represent customer results or guarantee particular template fields. See the included features above and the current Etsy listing.
A closer look at Restaurant Tip Pool Calculator & Tip Sharing Spreadsheet
Additional previews from this product's Etsy listing. Open any image for a larger view.
Learn the method
Questions about this product
Does this include server and bartender tip records?
Yes. Server tip tracking, bartender tip logs and tip-out figures are included.
Does the calculator choose my restaurant's tip policy?
No. It provides a spreadsheet for tip-sharing records. Your restaurant must define an appropriate policy and verify that the calculation setup matches it.
Which spreadsheet formats are listed?
This product is described for Google Sheets and Excel. Confirm the included files, software requirements and delivery instructions on its current Etsy listing.
