01
Fair shares to the penny
By hours worked, or hours × points per role you agree with your team (the Code of Practice lists role and hours as objective factors). Any rounding penny goes to the last shift, so each period adds up exactly
For restaurants, pubs, cafés & hotels
7 reasons to share tips fairly, to the penny
Since 1 October 2024 every tip, gratuity and service charge must reach your staff in full, be shared fairly, and be paid by the end of the month after the customer paid. This spreadsheet does the sums: log the day's tips and each person's hours, and it shares every pay period to the penny, shows the legal pay-by date, fills in your written tipping policy and keeps the records a worker can ask for.
- Excel & Google Sheets, no macros
- Example + blank file
- Start-here guide
- One-off price, no subscription
Screens from the included example file. All names and figures are fictional.
80staff
3,000tips rows
4,000shifts
0macros, add-ons or subscriptions
The list
Why a ready-made tracker beats paper and a blank spreadsheet
02
Weekly, fortnightly, 4-weekly or monthly pay periods, each with the legal pay-by date
(end of the following month) and a status: open, to pay, overdue, paid on time or paid late
Get the tracker · £19.99 Instant download · Excel & Google Sheets
03
Allocation
Pick a period for every person's hours, points, share and amount, ready to pass to payroll or the troncmaster
Tax and NI
Choose who decides the shares (you, or an independent troncmaster) and your service charge type (optional or compulsory). Each period shows the tips that carry Class 1 NI (HMRC E24), with a 2026/27 NI estimate on the Dashboard
Written tipping policy that fills in from Settings: how tips are collected and shared
Role points, payroll or tronc PAYE, agency workers, records and reviews. Edit and share it with all workers
Statement and Requests
A tips record for any worker and any months, plus a log of written requests with the 4-week reply date and the once-every-3-months and 3-year rules
Dashboard
Tips this tax year, tips by month and source, shares by role, periods overdue, a "What needs your attention" list (pay-by dates, policy review, consultation, requests, tronc PAYE scheme) and 3 charts
Get the tracker · £19.99 Instant download · stuck? Email us for help
Compare
Three ways to keep these records
| Feature | Paper or notes | A blank spreadsheet | This tracker |
|---|---|---|---|
| Fair shares to the penny | ✗No | ~ If you build it | ✓ Built in |
| Allocation | ✗No | ~ If you build it | ✓ Built in |
| Tax and NI | ✗No | ~ If you build it | ✓ Built in |
| Statement and Requests | ✗No | ~ If you build it | ✓ Built in |
| Dashboard | ✗No | ~ If you build it | ✓ Built in |
| Cost | Free, plus your time | Free, plus your time | £19.99 once |
What's inside
Everything you download
3 files
- XLSX UK-Tronc-Tips-Tracker.xlsxfilled with fictional example data (12 staff, 30 weekly periods) so you can see how it works
- XLSX UK-Tronc-Tips-Tracker-BLANK.xlsxan empty copy, ready for your own business
- PDF Start-here.pdfone-page quick-start guide, including how to open it in Google Sheets
Also included
- Checks on every row: text in a date or amount, unknown source or name, duplicates, shifts before a start date or after…
- Agency workers included: their share is shown as paid to the agency, which must pass it on in full
- Up to 80 staff, 3,000 tips rows and 4,000 shifts
Good to know
- A Health check on the Start Here tab and a Check/Status column on every log flag missing or odd entries
- Code of Practice on fair and transparent distribution of tips (29 July 2024) and Acas guidance on tips, checked 02/11/2026
- Northern Ireland is not covered by the Act: the tracker still works, but check local rules
- Dates show as DD/MM/YYYY
Is it right for you?
Made for some, honestly not for others
A good fit if you…
- restaurants, pubs, cafes and hotels in England, Wales and Scotland, whether you share tips yourself through payroll or use an independent troncmaster
- use Excel or Google Sheets on a computer
- want to pay once, not another subscription
Not for you if you…
- need Apple Numbers or mobile-only editing
- want someone to do the records for you
How it works
Three steps, about 10 minutes to set up
- 1
Set up once
Your business, pay period, how you share and role points on Settings, then one row per person on Staff (about 10 minutes)
- 2
Log as you go
Tips by date and source on Tips, hours per person per day on Hours
- 3
Share, pay and record
Allocation for who gets what, the date paid on Periods, and the Tips Policy printed for your team
Microsoft Excel2010 or newer (Windows & Mac) and Microsoft 365
Google SheetsFree Google account. Upload the .xlsx, then set the locale to United Kingdom
0
No macrosNothing to enable, no add-ons or subscriptions. Not designed for Apple Numbers or mobile-only editing. A computer is recommended
- Instant download
- Example + blank file
- Start-here guide
The offer
Master Tronc & Tips Tracker UK
£19.99one-off · no subscription
- Filled with fictional example data (12 staff, 30 weekly periods) (UK-Tronc-Tips-Tracker.xlsx)
- An empty copy, ready for your own business (UK-Tronc-Tips-Tracker-BLANK.xlsx)
- One-page quick-start guide, including how to open it in Google Sheets (Start-here.pdf)
- Licensed for use within one business or household
Price includes VAT where applicable — calculated at checkout. Secure checkout by Payhip.
Questions? Email info@phkmedia.co.uk
Stuck after you buy? We'll help you set it up.
Digital download, nothing is posted. This spreadsheet is a record-keeping aid, not legal or tax advice and not payroll software. Terms & licence.
Bundle
Also in 2 bundles with related tools
Employer Complete BundleIt's Monday, someone has called in sick, a new starter needs a right to work check, the tronc is due and the fire alarm test was last week, or was it?
£84.99£137.90 one by one
Hospitality BundleClose of service: fridges to check, tills to cash up, tips to share fairly, and the cleaning chemicals file still out of date.
£41.99£69.95 one by one
FAQ
Questions people ask
Does it pay my staff?
No. It works out who gets what and when; you pay through payroll or the tronc.
Does it work on a phone?
You can view it in the Google Sheets app, but entering data is easiest on a computer.
What happens after I pay?
This is a digital product. Nothing physical will be shipped. Your download link appears straight after checkout and is also emailed to you.
Can I get help if I'm stuck?
Yes. Message us at info@phkmedia.co.uk and we'll help you set it up.