Reconcile affiliate commissions from held orders to the final payment

A referral dashboard can show an attributed order before the related commission becomes payable. Keep the order reference, creator, commission rule, eligible sale amount and current status together. Preserve the agreement's treatment of discounts, shipping, returns and partial refunds. A headline percentage cannot explain a commission unless its calculation base is also known.

Shopify Collabs places commissions in a holding period and automatically cancels commissions for canceled or fully refunded orders during that period. Its documentation describes later billing and payment stages. Those stages support a reconciliation, but they do not establish that every partial refund or post-payment return will receive the same automatic treatment.

Begin with held commissions from the previous review. Add new eligible referrals, subtract verified cancellations or adjustments and identify amounts released for billing. Then reconcile billed commissions to the merchant invoice and payment evidence. Track charges for processing or currency conversion separately from the creator's commission so the campaign's cost can be understood.

In a hypothetical rollforward, opening held commissions are $900, new commissions are $600 and confirmed cancellations are $150. If $800 moves to billing, the remaining held amount is $550: $900 plus $600 less $150 less $800. The $800 has changed status; it is not a second commission expense merely because it now appears on an invoice.

Use unique commission or order-event identifiers when matching records. Several creators, refunded lines or an adjustment can produce more than one entry around an order. Investigate that detail before deleting an apparent duplicate. The relevant question is whether the business owes two payments, not whether two rows contain the same order number.

For a refund after the holding period, read the agreement and inspect the platform's actual adjustment. Record whether the commission remains earned, is recoverable from a later payment or is disputed. Do not reduce an amount owed to a creator simply because the customer received a refund if the contract does not support that reduction.

Partial returns require the retained order lines and original commission basis. A customer may return the only commission-eligible item while keeping another product. Recalculate the amount using the relevant terms, retain the original calculation and link any correction to it. Keep customer refunds and creator adjustments as separate events even when one causes the other.

Maintain an exception list for commissions waiting on billing, creator payout setup, dispute resolution or another documented step. Assign a next action and owner. A creator payment delay may leave an obligation outstanding; it does not make the acquisition cost disappear. Ask the accountant to align recognition and accruals with the actual arrangement.

For performance review, report commission cost against the associated order cohort, including known reversals and unresolved adjustments. Reconcile that view to the billed and paid totals rather than forcing all three to match in one period. This lets the team judge referral economics while finance can still explain the amount currently due and the cash already paid.