Holiday Bonus & Tip Pool Planner — Small Employer Bonus Calculator, Tip Pool Split & December Schedule Excel
Plan December 2026 bonuses and tip pools in one Excel workbook — no guessing, no adding errors.
Built for small employers in restaurants, salons, cafes, and shops.
What you get:
- Bonus Calculator — Enter each employee, annual salary, years of service, and role. Choose Percent (salary × %) or Flat amount per person. The sheet calculates each bonus, the total bonus pool, and a live budget check: WITHIN BUDGET or OVER BUDGET.
- Tip Pool Split — Enter the pool total and hours per employee. The sheet calculates the per-hour rate (pool ÷ total hours) and each person's share. Shares sum to the pool total.
- December Schedule Planner — Week-by-week December 2026 staffing grid with total days per employee. Covers Christmas week and New Year's Eve.
- Budget Summary — Bonus pool + tip pool + combined December people cost in one view.
- Start Here sheet + 4-page PDF guide — Step-by-step setup, worked examples, fairness rules, and a before-payday checklist.
- 8 sample employees pre-filled. Replace them with your own staff in minutes.
Yellow cells are inputs. Blue cells are formulas — the math updates at once.
DISCLAIMER: This workbook does planning math only. It is NOT tax, legal, or payroll advice. Bonus and tip rules, withholding, and tip-pool eligibility vary by location and change over time. Confirm all rules and final amounts with a qualified payroll professional before you pay.
Works in Microsoft Excel and Google Sheets (upload the .xlsx file). Instant download.