An Excel (XLSX) workbook for salons, barbershops and beauty studios that pool their tips. For each week you type the cash tips and card tips of every day and each person's hours; the workbook shares the pool among the team by hours worked, by role points (optionally multiplied by hours) or in equal shares, as you choose in Setup. Every person gets a payout rounded to the cent, and the leftover cents are handed out so the payouts always add up to the pool, with the rounding shown. A weekly summary and a five-week month summary show the pool, the hours and each person's total. One download holds five complete editions (English, Italian, Spanish, French and German), each with a fictional DEMO workbook and an empty BLANK one. It does arithmetic only: tip rules differ by country and it is not payroll, tax or legal advice.

The problem it solves

Splitting a shared tip jar by hand means arguments about hours, a calculator, and cents that never add up. Without a written method everyone has to trust that the split was fair.

Who it is for

Salon owners, barbershop managers and beauty studio teams who collect tips in a common pool and want a clear, repeatable and transparent way to share them.

What you get

• Three split methods, chosen in Setup: by hours worked, by role points, or in equal shares
• Role points can count once per person present or be multiplied by the hours worked, with up to 6 roles and 12 staff
• A weekly sheet for cash tips and card tips for each day, with an optional card fee percentage taken off card tips only
• Payouts rounded to the cent: leftover cents go to the largest remainders, so the total always matches the pool and the rounding is shown
• Clear handling of edge cases: people with no hours get no share, and if nobody has hours the amount is shown as Not shared instead of disappearing
• A weekly summary and a five-week month summary with each person's total, hours and amount per hour
• Five full language editions in one purchase, each with a fictional DEMO workbook and a BLANK one

How you use it

1. Download and unzip the file, then open the folder of the language you want.
2. Open the DEMO workbook in desktop Excel and look at a Week sheet and the Summary to see how it works.
3. Open the BLANK workbook, save a working copy and, on Setup, enter your salon name, the Monday your first week starts, the split method and the card fee percentage.
4. Still on Setup, list your roles with their points and your staff (up to 12 people), each with a role.
5. Each week, type the cash and card tips for each day and each person's hours on the Week sheet, then read the Payout column and the Summary.

Questions