Know what goes into the number.
Practical methods for the sales, agreements and decisions behind a salon commission run.
Reconcile a salon commission period, from source rows to a clear total
A complete commission reconciliation method: fix the period, inspect source rows, apply recorded rates, explain exceptions and prepare the handover.
First close · 6 min readService 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.
Calculation methods · 6 min readCommission tax basis: make the amount behind the percentage explicit
Compare tax-inclusive and tax-exclusive commission using supplied amounts, signed refunds and transparent reverse-tax arithmetic.
Calculation methods · 6 min readCommission rounding: find the cent instead of hiding it
Reproduce a one-cent commission difference, compare rounding per line with rounding a total, and apply one signed rounding policy consistently.
Calculation methods · 6 min readInvoice date versus payment date: the same week can contain different sales
Trace date-based differences between sales and payment reports using a three-sale example, a clear bridge and consistent period boundaries.
Source data · 6 min readOverlapping sales exports: find repeated rows without losing real sales
Compare two overlapping exports with line references, reconcile repeated amounts and distinguish duplicate candidates from legitimate repeated services.
Source data · 6 min readStaff attribution: distinguish who did the work from who took the payment
Check staff fields, confirm aliases and reconcile service-provider attribution with a worked example where cashier mapping changes the result.
Source data · 6 min readWhen report totals do not match, build a bridge before changing anything
A diagnostic sequence for mismatched salon reports: align dates and filters, compare tax bases, inspect duplicates and refunds, then reconcile commission.
Troubleshooting · 6 min readA partial refund, traced to the original item
Follow a partial salon refund from its original sale through signed tax, calculation basis and commission arithmetic, with a complete AUD example.
Refunds & adjustments · 6 min readA refund after the close: link the periods without rewriting the past
Trace a later refund to a completed commission run, check the original rate and preserve a clear two-period record with a worked AUD example.
Refunds & adjustments · 6 min readDiscounted services: avoid subtracting the same discount twice
Compare list-price and discounted-price commission assumptions, inspect source discount fields and reproduce the effect with a worked AUD service sale.
Calculation methods · 6 min readPackages and prepaid services: separate the sale from the visit
Map package sale and redemption events, compare explicit allocation methods and identify where a flat-rate CSV commission workflow needs more evidence.
Complex source events · 6 min readGift cards: follow the sale through to redemption
Trace a gift-card purchase, redemption and service line without counting the same amount twice in a salon commission worksheet.
Source records · 6 min readA cancelled appointment is not an itemised sale
Separate appointment status, cancellation fees, refunds and actual sale lines before reviewing a salon commission period.
Exceptions · 6 min readDecide what belongs in the commission basis
Review tips, gift-card payments, fees and other non-service items with an explicit inclusion decision and a reconciling sales bridge.
Calculation rules · 6 min readKeep a mid-period rate change tied to its dates
Use sale-date agreements for a mid-period rate change, check the boundary and preserve the rate evidence in the final record.
Calculation rules · 6 min readRebuild a staff statement from its sales lines
Trace a staff commission total through services, retail, refunds, exclusions and source references with a complete worked statement.
Close & handover · 6 min readOne service, two staff: establish the split first
Document shared-service attribution, test the allocated sales basis and avoid counting a full service once for each staff member.
Source records · 6 min readCorrect the explanation before changing the total
Distinguish source corrections, commission review decisions and separate payroll adjustments while preserving references and calculation evidence.
Exceptions · 6 min readGive every sale one place in the calendar
Define inclusive commission dates, inspect boundary rows and prevent gaps or overlaps between weekly, fortnightly and monthly runs.
Close & handover · 6 min readHand over a commission close someone can reproduce
Build a concise salon commission handover pack with a cover sheet, source register, summary, detail, decisions and a receiving check.
Close & handover · 6 min readWhere a commission worksheet stops and payroll begins
Understand the Australian payroll boundary: commission arithmetic, employment rules, payslips, deductions and reporting are separate checks.
Payroll boundary · 6 min readCheck the formula before disputing the commission
Compare provider-reported commission with a supplied flat-rate formula by aligning basis, category, attribution, dates and rounding.
Calculation rules · 6 min readShare the evidence a reviewer needs, and no more
Prepare useful salon sales samples, remove unnecessary personal details and understand browser tools, local workspace storage and iCloud sync.
Data handling · 6 min readHow to audit a salon commission report before a pay run
Choose the right source report, trace a refund to its original sale, compare the calculation and keep a review record before handing commission to payroll.
Commission review · 8 min read