A cancelled appointment is not an itemised sale

Separate the booking timeline from the charge

An appointment may be cancelled before payment, cancelled after a deposit, or recorded as a no-show with a fee. A later booking may use an existing credit. These situations can share a status label while producing different sales records.

Collect the appointment reference, invoice or receipt, fee item, any credit or refund, and the staff attribution. Keep the original labels. A status count is useful for operational reporting, but multiplying cancelled appointments by a service price does not produce an itemised commission basis.

Compare three outcomes for the same booking price

Assume the planned service price was $110.00. The table uses a fictional arrangement that includes completed services at 40% of a supplied tax-exclusive basis and excludes cancellation fees. It illustrates the classification decision; it does not establish how your fees or staff entitlements should be treated.

Make the fee decision explicit

A cancellation fee needs a documented inclusion decision, category, staff attribution and calculation basis. The fact that a fee has the same percentage as a service deposit does not make it a service sale. Nor does a zero result in a worksheet decide who is entitled to receive the fee.

If your supplied arrangement includes a fee but requires a fixed amount, a special rate or a different allocation, the current flat service/retail calculator may not express it faithfully. Keep that item in a separate reviewed schedule instead of altering unrelated service rates to obtain the desired total.

Follow deposits, credits and later refunds

Find what happened to any advance payment. It may remain a credit, be refunded, be applied to another visit or be recorded as a fee. Do not import the advance payment and a later service line as two services without examining the records.

If a fee is reversed, connect the negative record to the original fee. Under the example assumption, both fee and reversal remain outside the service commission basis. A completed service that is later refunded requires a different review: trace the refund to the service and its original calculation.

Check the common mismatches

An appointment report and a sales export can disagree because their date fields, statuses and item types differ. Compare their scope before treating either total as wrong. A fee collected on Monday for a Saturday appointment can fall into different reporting periods depending on the date selected.

Watch for a payment-processor name being used as the earning staff member, a cancelled item left beside its replacement, or a fee grouped under a generic service category. Each needs evidence from the original record rather than a blanket include/exclude rule.

1. Find the financial event and its date.
2. Check whether another line reverses or replaces it.
3. Confirm the category and earning staff.
4. Record the inclusion decision and its source.

Leave a decision that survives the next question

A useful note reads: “Booking B-204 cancelled; fee F-204 is a separate $33.00 item; excluded from this service commission run under worksheet version 2; receipt checked.” A note that only says “no-show” leaves the reviewer guessing whether the fee was overlooked.

In Trimsum, review an unsupported category before finalising. Do not change its category purely to clear a warning. Preserve the explanation in the detail record and include any separately calculated fee schedule in the handover so the recipient sees the full scope.