
The short answer: Tronc software is the better choice for most UK hospitality businesses. Spreadsheets cost nothing up front, but they rely on manual data entry, break easily as teams grow, and make it hard to prove compliance with the Employment (Allocation of Tips) Act 2023. Tronc software automates tip splits, keeps the three-year records the law requires, and, through an independent tronc scheme, removes employer National Insurance (15%) and employee National Insurance (8%) from tips.
A spreadsheet can still work for a single small venue with a simple, even split. Once you have multiple roles, multiple sites or more than a handful of staff, the time, risk and missed NIC savings usually outweigh the cost of software. If you manage tips in Excel or Google Sheets today, this guide explains exactly what you gain, and what you risk, by staying put.
What is tronc, and why does how you manage it matter?
A tronc is a pooled arrangement for sharing tips, gratuities and service charges among staff. It is run by a troncmaster, a person or organisation independent of the employer who decides how the pool is split. When the employer has no say in the allocation, tronc payments are exempt from National Insurance for both the business and its employees. Income tax is still due through PAYE.
Since 1 October 2024, the Employment (Allocation of Tips) Act 2023 has made tip handling a legal obligation, not just good practice. Employers in England, Scotland and Wales must:
- pass on 100% of qualifying tips to workers, with no deductions beyond tax;
- allocate tips fairly, following the statutory Code of Practice;
- have a written tipping policy available to all staff;
- pay tips by the end of the month after they were received;
- keep records of tips received and how they were allocated for three years;
- give workers access to their tipping records on request.
Workers can take claims to an employment tribunal, which can order unpaid tips to be repaid and award compensation. That is why the tool you use to split tips now matters as much as the split itself.
Managing tronc in spreadsheets: the hidden costs
Spreadsheets are where most venues start. They are familiar, flexible and already on every laptop, so it is easy to see why so many managers still split tips in Excel or Google Sheets.
Where spreadsheets fall down
- Manual data entry. Someone has to copy card tips from the POS, hours from the rota and cash tips from the till every pay period. Each copy is a chance for error.
- Fragile formulas. One overwritten cell or broken range can underpay a whole team, and nobody may notice for weeks.
- No audit trail. A spreadsheet rarely shows who changed what, when. That makes it hard to evidence fair allocation if a worker challenges it.
- Record-keeping burden. You must keep three years of records in a form you can share with any worker who asks. Scattered files and old versions make that slow and risky.
- Poor transparency for staff. Staff usually see a single number on a payslip, not how it was worked out. Low visibility breeds distrust, even when the split is fair.
- Missed NIC savings. A spreadsheet does not make you independent of the allocation. Running a compliant tronc scheme needs a genuinely independent troncmaster, which most in-house setups lack.
- Key-person risk. The spreadsheet often lives in one manager’s head. When they leave, the logic leaves with them.
- Doesn’t scale. Multiple roles, split shifts, several sites and agency staff turn a simple sheet into a maze.
The real cost of a spreadsheet is rarely the software. It is the hours of admin every pay run, the errors that slip through and the National Insurance you keep paying.
What tronc software does differently
Tronc software replaces the manual steps of a spreadsheet with an automated, auditable process. Good platforms connect to your POS and rota, apply your split rules, and handle payment and records for you.
- Automatic data sync. Card tips and service charges flow in from your EPOS; hours and roles come from your rota or payroll.
- Flexible, rule-based splits. Split by hours, role, points, department, site or shift, and change the rules without rebuilding formulas.
- Built-in compliance. A written tipping policy, three-year records and on-time payouts are generated as you go, not reconstructed later.
- Independent troncmaster. An HMRC-registered provider acts as troncmaster, so tips can be paid free of National Insurance.
- Staff visibility. Employees see their own tips, hours and payslips in an app or dashboard.
- Multi-site reporting. Head office sees every venue in one place.
Signs it’s time to switch to tronc software
- Tip admin takes more than an hour or two each pay period.
- You split by role, points or department, not just hours.
- You run, or plan to run, more than one site.
- Staff have questioned how their tips were calculated.
- You can’t quickly produce a worker’s tipping record from three years ago.
- You pay employer NIC on tips and service charges today.
- One person is the only one who understands the spreadsheet.
If two or more of these sound familiar, the savings in time and NIC will usually cover the cost of software within the first few months.
Frequently asked questions
Can I legally manage tronc in a spreadsheet?
Yes. The law does not require software. But you must still allocate tips fairly, have a written tipping policy, pay tips by the end of the following month and keep three years of records. A spreadsheet makes each of these harder to prove.
What is the difference between a tronc and a tip split?
A tip split is simply how tips are divided. A tronc is a formal scheme run by an independent troncmaster. Because the employer does not control the allocation, tronc payments are free of National Insurance.
Do tips paid through a tronc scheme still pay income tax?
Yes. Income tax is deducted through PAYE. Only National Insurance is removed.
How much does tronc software cost?
Most providers charge a monthly fee, often per employee. JustTip starts at £8.99 per employee per month (ex VAT), with no long-term contract.
What happens if I get tip allocation wrong?
Workers can bring a claim to an employment tribunal. The tribunal can order you to repay tips owed and award compensation.
How long does it take to switch from a spreadsheet to tronc software?
Most venues can switch in days. Connect your POS, confirm your split rules and invite staff to the platform. Your existing spreadsheet history can be kept alongside the new records.









