Reader question: When an affiliate dashboard shows a commission, what has actually happened, what can still change, and when is it reasonable to call the result cash?
Affiliate reporting often compresses a transaction into one bright number. A click becomes an order; an order becomes a commission; a commission becomes “earnings.” That compression is convenient and commercially dangerous. There are at least four useful states: an estimate, an eligible transaction, an adjusted commission, and cash received. Each answers a different question.
The distinction is not academic. Amazon’s current Commission Income Statement defines a qualifying purchase, subtracts specified costs from qualifying revenue, excludes some canceled or returned orders, and pays on a later schedule. Amazon Commission Income Statement Shopify Collabs likewise puts commissions into a pending holding period before a payout can be processed. Shopify Collabs payment guidance These are provider rules, not a universal affiliate formula. The useful commercial habit is to preserve the state that the evidence actually supports.
Four states, four different claims
| Ledger state | Working definition | What the row can support |
|---|---|---|
| Estimate | A forecast based on assumptions such as clicks, conversion, order value, and rate. | “If the assumptions hold, the model points to…” |
| Eligible transaction | An order or event that satisfies the program’s credit, product, customer, and timing rules. | “This event is currently inside the program’s payable definition.” |
| Adjusted commission | The amount left after the program applies its rate basis, refunds, cancellations, reversals, caps, rounding, or other contract rules. | “The current payable amount is…” |
| Cash | Funds actually released through the selected payout method and received or made available. | “This amount arrived on this date.” |
An estimate is not a weak version of cash. It is a different object. Amazon expressly makes no representation about the amount of traffic or commission income an associate should expect. Amazon Associates Operating Agreement A forecast can be useful for deciding whether a placement is worth the work, but its assumptions belong in the record beside the number.
Attribution is a credit rule, not a payout promise
An attribution window answers, “Which click or referral may receive credit, and for how long?” It does not answer, “When will the creator be paid?” A return or locking window answers whether the credited event survives post-purchase review. A payout schedule answers when the approved amount is released. Mixing the three makes a dashboard look more certain than the agreement is.
Amazon’s current session ends at the first of 24 hours, an order for a Product other than a defined Digital Product, or a click on a Special Link that is not the associate’s own. Cart addition must occur during the qualifying session; an eligible cart order must be completed within 89 days of the initial click. Fulfillment and payment must also occur within 180 days of purchase. Qualifying revenue reflects specified deductions from receipts. Amazon Commission Income Statement These are Amazon-specific boundaries, not assumptions for every brand.
Shopify Collabs documents a different boundary around payment. A commission stays pending for a merchant-selected holding period of one to 90 days so an order can be checked for refunds. A full cancellation or refund during that period removes the commission from the pending total; after the merchant pays, automatic payouts run twice monthly and require at least $25 in the next-payout balance. Shopify Collabs payment guidance The practical lesson is simple: write down the referral window and the return or hold window separately.
A small illustrative reconciliation
The following case is hypothetical, not observed performance. Assume a program advertises a 10% rate, and a report shows eight orders at $75 each after a creator’s links were used.
- Estimate: eight reported orders × $75 × 10% = $60. This is a planning number. It has not yet established eligibility or payment.
- Eligible transaction: six orders satisfy the program’s referral and product rules. The eligible gross base is six × $75 = $450, producing a provisional $45 at the stated rate. The two excluded orders remain in the audit trail with an exclusion reason.
- Adjusted commission: during the return or review period, one $75 order is canceled and another order has a $50 refund. If this program calculates the rate on the remaining qualifying base, the adjusted base is $450 − $75 − $50 = $325, and the adjusted commission is $32.50.
- Cash: the $32.50 is still not cash until the action clears the program’s hold and the payout is released. Before that date, cash received is $0. After release, the ledger records the actual receipt, currency, date, and any disclosed conversion fee or withholding.
The arithmetic is deliberately plain. It shows why “sales,” “commission,” and “payout” should not be used as interchangeable columns. A fixed fee, a lead event, a tiered rate, a partial reversal, or a tax treatment would change the calculation. Keep the example’s assumptions visible instead of presenting the result as a benchmark.
Keep one row per transaction
A useful affiliate ledger can be small. For each event, keep:
- the transaction or action ID, click or referral time, link or code, and program version;
- the currency, rate basis, qualifying revenue definition, and attribution window;
- gross order value and the amount currently treated as eligible;
- status: estimated, pending, adjusted, approved, reversed, paid, or cash received;
- adjustment amount, reason, date, and the source report or provider explanation;
- lock or review date, scheduled payout date, actual receipt date, and payout method.
Do not overwrite an estimate when a transaction becomes eligible. Append the next state. If a $45 provisional commission becomes $32.50 after a return, the difference is an auditable adjustment, not a mysterious “performance decline.” If the provider later corrects a row, preserve the old report and record the correction date.
Use two reconciliation checkpoints. First, after the stated return or action-lock period, compare the eligible rows with reversals and the provider’s approved total. Second, after the payout date, compare the approved total with the payout record and the amount actually received. A dashboard can establish a status; it does not, by itself, establish a bank receipt.
The stop condition is an unknown, not a zero
Pause a forecast or a commercial commitment when the written terms do not identify the rate basis, currency, qualifying event, attribution window, return or reversal policy, payout timing, and minimum threshold. Ask for the missing terms or mark them unknown. Do not turn an unknown hold period into an optimistic cash date.
Tax reporting, sales tax, and local disclosure duties are separate questions that may require professional advice. This ledger is an operational way to keep commercial states honest. Its purpose is not to promise a return; it is to show which part of the return, if any, has earned the right to be called money.
Sources and limitations
- Amazon Associates Program Commission Income Statement — checked September 2, 2026; updated April 14, 2026; supports session exclusions, in-session cart additions, 89-day ordering, 180-day fulfillment/payment, deductions, adjustments, rounding, and payment timing. Limitation: eligibility remains subject to all Amazon-specific conditions, not a universal affiliate rule.
- Amazon Associates Program Operating Agreement — checked September 2, 2026; updated October 15, 2025; supports Amazon’s statement that traffic and commission income are not guaranteed and that Amazon customers remain subject to Amazon’s customer and order rules. Limitation: this is a provider agreement, not independent financial guidance.
- Shopify Help Center, “Getting paid for commissions on Shopify Collabs” — checked September 2, 2026; supports pending commissions, merchant-selected one-to-90-day holds, cancellation and full-refund treatment, twice-monthly payout scheduling, the $25 threshold, currency conversion possibility, and adjustment after refunds or cancellations. Limitation: Collabs settings and merchant terms control the actual result; the page does not establish a general industry standard.