Service and retail commission: reconcile a mixed basket
Separate service and retail lines, apply each supplied rate, and trace discounts, returns and unknown categories in a mixed salon sale.
An invoice can contain a service, a retail product and an item that does not fit either category. Applying one percentage to the invoice total hides those differences. The reliable unit of calculation is the item line, with its own category, signed basis and recorded rate.
The useful part
Classify each item before calculating commission. Sum the rounded line results; do not apply an average service-and-retail percentage to the invoice total.
Keep the invoice together and the calculations separate
Retain the invoice reference on every item line. It connects the basket while allowing each item to carry the appropriate category. A colour service and a bottle of shampoo can share an invoice reference without being duplicate transactions.
If the source provides only an invoice total, request item detail before applying different category rates. Splitting a total by guesswork produces a calculation that cannot be checked against the sale. The required evidence is the item, amount, category and attributed staff member for each line.
Work the service and retail amounts independently
This fictional AUD basket uses a supplied exclusive basis. Mia has a 40% service rate and a 10% retail rate. The two service lines use the same percentage, but remain separate so the source record stays traceable.
| Item | Category | Basis | Rate | Commission |
|---|---|---|---|---|
| Colour service | Service | $120.00 | 40% | $48.00 |
| Blow-dry | Service | $40.00 | 40% | $16.00 |
| Shampoo | Retail | $30.00 | 10% | $3.00 |
| Total | Mixed | $190.00 | — | $67.00 |
Two useful subtotals
Service commission is $64.00; retail commission is $3.00. Together they explain the $67.00 staff total.
Use a category register for unclear items
A category name is a source label, not an agreement about how an item should be treated. Keep a short register of unfamiliar labels, example items and the confirmed destination category. Review new labels when they first appear rather than automatically treating every unknown item as a service.
Packages, gift cards, fees and tips need their own documented treatment before inclusion. If a product line has been categorised as service in the source, correct the mapping or source classification through a traceable process. Changing only the rate to conceal a classification error makes later returns harder to reconcile.
Keep adjustments attached to their original category
Suppose the shampoo is later returned with a supplied basis of −$30.00. At the example’s retail rate of 10%, the arithmetic adjustment is −$3.00. Using the 40% service rate instead would produce −$12.00: a $9.00 difference caused entirely by classification.
For a basket-level discount, inspect whether the export already allocates the discount to item lines. Do not subtract the full discount from every item. If an allocation is absent, obtain a documented allocation method before calculating separate category results; the calculator cannot decide that method for you.
Check categories before checking the grand total
A useful spot check is to swap the two category rates on paper. The deliberately wrong result makes clear why an apparently small mapping error can materially change the commission. Preserve the correct line-level calculation as the evidence; an overall weighted percentage is only a summary.
- Group accepted source lines by staff member and category.
- Verify that service and retail bases add to the included mixed-basket basis.
- Calculate each line using its category rate and the same rounding policy.
- Sum service commission, retail commission and signed adjustments separately.
- Compare the combined result with the source-reported amount and explain each difference.
Know when the flat-rate model stops fitting
Trimsum supports a flat service percentage and a flat retail percentage for a staff rule. A tier based on monthly sales, a fixed amount per item, a product-specific override or a split between two staff members is a different calculation model. Do not compress one of those arrangements into a misleading flat percentage.
The public service-and-retail calculator is useful for checking supplied category totals. For a complete close, retain the individual items, staff attribution, exclusions and adjustment references as well. A correct combined number should be the outcome of that record, not a substitute for it.
Put it to work.
Enter separate bases and rates to see both category results and the combined amount.
Check service and retail totals