The tronc sheet arrives late on Wednesday
Your hospitality clients pay tips and service charges to staff, some through a tronc arrangement, some through payroll directly. Each period, the general manager or troncmaster sends a spreadsheet: names, hours or points, and the amount each person gets.
Names are nicknames or first names only. Two sites send different layouts. A new starter appears who is not on the payroll yet. The total allocated does not match the total collected on the card machines. And it arrives the day before cut-off.
Why tips data is messy
The allocation is done by the client's team, usually in a spreadsheet they built themselves, often by a manager whose main job is running a restaurant. Card tips, cash tips and service charges come from different sources. Allocation methods vary by site and change when a new manager arrives.
How tips are allocated, and how they are treated for tax and NI, depends on the client's arrangement and advice, and the rules have been revised in recent years. The bureau's job is to process the allocation the client provides, in the way the client's arrangement requires, accurately and on time.
What messy tips data costs
Administrators spend hours matching names and chasing corrections, in the tightest part of the pay cycle. Errors upset staff, who watch their tips closely and compare notes. Figures that do not reconcile with what was collected can raise questions for the client later. And the element setup in the payroll, which keeps tronc payments separate, is easy to get wrong when keying in a hurry.
| Problem in the sheet | What the intake does |
|---|---|
| Nicknames or first names only | Matches to payroll employees, with confirmations for unclear ones |
| Different layouts per site | Maps each site's layout once |
| Staff not on the payroll | Flags as possible starters |
| Total allocated differs from total collected | Shows the difference for the client to explain |
| Wrong element for the type of payment | Maps to the element the client's arrangement requires |
How we build tips and tronc intake
- Each site sends its allocation sheet as it does now, by email or upload. The layout for each site is mapped once, and changes in layout are detected.
- Names are matched to payroll employees using the site, role and previous allocations, with unclear matches confirmed by the administrator once and remembered.
- The client provides, or we read from their EPOS or card provider export where available, the total tips and service charge collected, and the intake compares allocated with collected.
- Differences, unknown employees and unusual amounts are flagged and can be sent back to the client as a specific question.
- Approved figures are prepared for import into your payroll software against the correct elements for the client's arrangement.
- A per-period summary by site shows totals collected, allocated and paid, for the client's records.
The tax and NI treatment of tips depends on how the client's arrangement is set up, which is for the client and their adviser. The intake applies the elements they have agreed with you.
Tips paid right, without the Wednesday scramble
Allocation sheets are read and checked within minutes of arriving. Name matching stops being a guessing game. Totals are reconciled before payroll, not questioned after. Staff get the tips they expect. And the bureau has a clean record per period for every hospitality client.
Do your hospitality clients send sheets like these?
- Tips or tronc allocations arrive as spreadsheets in different layouts.
- Staff are listed by nickname or first name only.
- Allocated totals rarely match collected totals.
- Allocation sheets arrive right before cut-off.
- Tips errors generate complaints from staff.