A creator affiliate payout statement should show which orders earned commission, which remain pending, what changed after returns, and how the approved balance became a payment. Give creators enough detail to reproduce the calculation using a private order reference. Leave customer names, email addresses, delivery addresses and payment details out of the creator-facing statement.
Use two connected records: an order ledger that explains earnings and a payment summary that explains the transfer. A single total cannot tell a creator whether the difference came from a refund, an eligibility hold or currency conversion.
State what the statement covers
Put the creator identifier, program name, statement ID, activity period, cutoff time zone and issue date at the top. Identify the commission terms and their effective date. Include the support channel for questions.
Distinguish these dates:
- Order date: when the purchase happened.
- Eligibility date: when the commission can leave its hold, subject to the program's checks.
- Adjustment date: when a refund or correction changed earnings.
- Payment date: when the payment provider reports the transfer's status.
A statement can contain activity for orders placed in an earlier period. Use the order reference to connect later corrections to the original entry.
Modash's guide to paying affiliates recommends keeping each affiliate's payment history to help resolve disputes. The template below makes that history traceable without sending a customer export.
An annotated hypothetical statement
Every identifier, amount, date and term in this example is hypothetical. It illustrates a custom program, rather than reproducing any platform's report.
Example terms. Commission is 10% of eligible merchandise after discounts and refunds. Shipping, sales tax and gift cards do not earn commission. Each order below belongs to this creator under the program's agreed attribution rules. Commission stays pending for 14 days after the order. There is no minimum payout threshold in this example.
The activity period is August 1 through August 31, 2026, in UTC. The statement includes a September 5 payment confirmation. Opening approved, unpaid commission is USD 8.00; opening pending commission is zero.
Order ledger
All amounts in this hypothetical ledger are USD. The starting base already excludes discounts, shipping, sales tax and ineligible products. Refunds shown here occurred during August and reduce that base under the example terms.
| Private reference | Order date | Starting base | Refunded base | Original commission | Reversal | Remaining commission |
|---|---|---|---|---|---|---|
| R-A | Aug 1 | 100.00 | 0.00 | 10.00 | 0.00 | 10.00 |
| R-B | Aug 3 | 80.00 | 30.00 | 8.00 | -3.00 | 5.00 |
| R-C | Aug 5 | 60.00 | 60.00 | 6.00 | -6.00 | 0.00 |
| R-D | Aug 25 | 50.00 | 0.00 | 5.00 | 0.00 | 5.00 |
| Total | 290.00 | 90.00 | 29.00 | -9.00 | 20.00 |
The arithmetic for each order is:
Original commission = starting eligible base × commission rate
Reversal = refunded eligible base × original commission rate
Remaining commission = original commission − reversalThe ledger displays reversals as negative entries. In the formula, reversal means the positive amount being subtracted. For R-B, USD 80.00 × 10% gives USD 8.00. The USD 30.00 refund removes USD 3.00, leaving USD 5.00.
Eligibility notes
The same hypothetical statement needs a reason and an expected next event for each unresolved amount.
| Reference | Status at Aug 31 | Explanation | Next event |
|---|---|---|---|
| R-A | Approved | Hold ended Aug 15 | Included in September payment |
| R-B | Approved | Partial refund on Aug 10; hold ended Aug 17 | Remaining USD 5.00 included |
| R-C | Reversed | Fully refunded Aug 12 | No commission payable |
| R-D | Pending | Hold ends Sep 8 | Review for release on Sep 8 |
USD 20.00 remains after reversals, but only USD 15.00 is approved for this payment. The other USD 5.00 remains pending.
These labels are recommendations for a custom statement. Preserve your platform's own status names and explain them. For example, Shopify Collabs payment documentation describes a holding period, merchant billing and creator payout activation as separate steps. During its holding period, Collabs automatically cancels commissions for canceled and fully refunded orders. That documentation does not establish a universal partial-refund formula.
For the decisions behind reversal entries, use the guide to reconciling affiliate commissions after returns.
Reconcile the ledger to the payment
Put manual adjustments on their own lines. Include a reason, approval date and reference to the corrected statement or order. Avoid an unexplained entry named "other."
In this hypothetical example, a September payment includes a USD 2.00 correction approved on August 28. An earlier statement applied the wrong rate to private reference R-OLD. The correction restores the missing commission and does not duplicate a current order.
| Hypothetical balance movement | USD |
|---|---|
| Opening approved, unpaid balance | 8.00 |
| Newly approved commission from the ledger | 15.00 |
| Prior-statement correction, R-OLD | 2.00 |
| Approved balance at Aug 31 | 25.00 |
| Commission settled by Sep 5 transfer | -25.00 |
| Approved balance remaining after transfer | 0.00 |
| Pending commission, shown separately | 5.00 |
The pending amount must not enter the payable subtotal. If a minimum threshold delays payment, show the approved amount carried forward and the applicable threshold. Explain any failed transfer separately from commission eligibility.
Use a payout schedule creators can understand to define when approved balances move into payment batches.
Show the currency conversion separately
Name the order currency, commission accounting currency and payout currency. If the system converts at more than one stage, show each conversion. Record the provider, conversion date, applied rate, rate direction and any separately charged fee. Label an estimate as an estimate until the provider confirms it.
Here is the hypothetical remittance attached to the statement. It assumes one conversion, at payment, and an agreed fee borne by the creator.
| Hypothetical payment detail | Value |
|---|---|
| Settled commission | USD 25.00 |
| Payment reference | PAY-SEP-EXAMPLE |
| Provider status | Completed, Sep 5 |
| Applied conversion rate | EUR 0.9000 per USD 1.00 |
| Converted amount | EUR 22.50 |
| Separate creator-paid fee | EUR 1.00 |
| Net payment | EUR 21.50 |
USD 25.00 × 0.9000 gives EUR 22.50; subtracting EUR 1.00 gives EUR 21.50. The fee reduces the cash received, while the transfer settles USD 25.00 of commission.
For this example, round each order commission to two decimal places using half-up rounding, then sum the rounded entries. Apply the conversion to the payment total, round that result to two decimal places, then subtract the fee. State your actual system's method, because rounding at another stage can change totals.
Do not reuse these invented rates or fees as platform defaults. Shopify says Collabs automatic payments operate in USD and that a creator cashing out in another currency pays a conversion fee. The statement should show the actual provider record. See handling affiliate sales in several currencies for the broader currency decisions.
Explain the payment without identifying the customer
Use a creator-specific private reference that support can map to the internal order. Keep that mapping restricted. Exclude customer contact fields, order-access links, full basket descriptions and free-text refund notes from the statement. A reason such as "partial eligible-item refund" explains the adjustment without repeating a customer's message.
This is a recommended field design. In the UK GDPR context, the ICO's data minimisation guidance says personal data should be limited to what the stated purpose needs. The page is under review following the Data (Use and Access) Act. Private references still need controlled access; replacing a name does not justify publishing the ledger.
Keep advertising reminders separate from the accounting entries. For endorsements affecting US consumers, the FTC's influencer disclosure guidance calls for clear disclosure of financial relationships with the endorsement. A private payout statement does not communicate that relationship to the audience. Treat these as operational notes, not legal advice or a complete compliance checklist.
Before sending the statement, recalculate one order, one reversal and the transfer total. Then check that every pending amount has a next review date and every deduction has a reason the creator can question using its private reference.
