Define the pool before calculating a share
Start with one named shift and a documented pool total. Keep the underlying cash and card records, the participant list and the hours used by the calculation. An hours model needs a consistent definition of those hours; mixing scheduled hours for one person with actual recorded hours for another changes the result.
This guide uses fictional participants A, B and C, a $480.01 pool and an already selected hours-based method. It teaches reconciliation, not who may join a pool or which policy a restaurant should adopt. Apply your restaurant’s approved method and applicable requirements. The US Department of Labor’s tipped-employee guidance is one official reference for US operators; requirements elsewhere can differ.
Worked example: why rounded shares can miss one cent
The recorded hours are 6, 5 and 4, giving 15 hours in total. Participant A’s unrounded allocation is $480.01 × 6 ÷ 15 = $192.004. Calculate each share from the full pool and retain precision until rounding the individual currency amounts.
| Participant | Hours | Unrounded allocation | Rounded base | Recorded adjustment | Final allocation |
|---|---|---|---|---|---|
| A | 6 | $192.004000 | $192.00 | $0.00 | $192.00 |
| B | 5 | $160.003333… | $160.00 | $0.01 | $160.01 |
| C | 4 | $128.002667… | $128.00 | $0.00 | $128.00 |
| Total | 15 | $480.01 | $480.00 | $0.01 | $480.01 |
The example records the one-cent adjustment against B solely to show a complete audit trail. That is not a recommended allocation rule. Use the rounding treatment specified by your approved method, record its reason and check that the final allocations equal the original pool.
Keep the formula and the adjustment in different columns
For an illustrative three-row sheet, put the pool in H2 and hours in B2:B4. Use C for the unrounded allocation, D for the rounded base, E for a separately recorded adjustment and F for the final allocation.
- C2:
=IF(SUM($B$2:$B$4)>0,$H$2*B2/SUM($B$2:$B$4),"") - D2:
=IF(C2="","",ROUND(C2,2)) - F2:
=IF(D2="","",D2+E2) - Unallocated remainder before adjustments:
=ROUND(H2-SUM(D2:D4),2) - Final reconciliation difference:
=ROUND(H2-SUM(F2:F4),2)
Fill the participant formulas down. An all-zero hours total is incomplete input, not a valid zero-dollar allocation. Google’s ROUND documentation explains the rounding function. These cell references describe this teaching layout, not a promise about the paid template’s columns.
Check the records that arithmetic cannot confirm
A zero reconciliation difference proves that the entered allocations add to the entered pool. It does not prove that the pool or hours are correct. Match the pool to its source records, confirm the shift dates and review every participant’s hours before treating the calculation as final.
- A missing person changes everyone else’s proportional share.
- A duplicate shift can allocate the same pool twice.
- Rounding an hourly rate first can produce a different total from rounding final allocations.
- A manual correction to hours should preserve the original entry and the reason for the change.
- An allocation is not evidence that payment was completed; keep the payment reference separately.
Download the example and close the shift with a check
Download the fictional tip pool example CSV
The CSV contains example values, not live formulas. The same $480.01 pool is repeated on the three participant rows as context; do not sum that repeated column. Sum the hours and allocation columns, then compare the final allocation total with the pool once. Keep the adjustment note with the shift record.
For ongoing records, compare the actual preview of the SheetChief Tip Pool Calculator Spreadsheet and the restaurant template collection. SheetChief sells these products. Confirm that the paid template supports your chosen method and required fields before buying; this example is a separate learning resource.
Put this into practice
Restaurant Spreadsheet Templates for Google Sheets & Excel · Try the free calculator
Compare the actual product previews and included files before choosing a paid template.
Sources and further reading
The explanations and worked examples are prepared for SheetChief. These sources support the referenced methods or platform instructions.
Questions, answered
How do I split a tip pool by recorded hours?
In an hours-based model, multiply the pool by each person’s hours divided by total hours. Use a consistent hours definition, then reconcile the rounded amounts to the pool.
Why can rounded allocations be one cent short?
Each unrounded share may contain fractions of a cent. Rounding the individual shares can produce a total different from the original pool. Keep the difference visible and apply the documented rounding treatment of your approved method.
Does a zero reconciliation difference prove the shift is correct?
It proves only that the entered final allocations match the entered pool. You still need to verify the source pool, participants, hours, adjustments and payment records.
Related SheetChief tools
These are our own products. The examples above explain the task; check each Etsy listing to confirm which features and formats are included.
