Influencer Hub homeDiscuss a pilot
Menu

Return-Adjusted Revenue for Creator Campaigns

Calculate return-adjusted creator revenue from eligible merchandise lines and partial refunds. Preserve the original report and explain the revised total.

A folded sales slip with a detachable line and an impression underneath.

Calculate return-adjusted creator revenue by starting with attributed merchandise sales after discounts and subtracting the eligible merchandise value reversed. Keep shipping, tax and other charges in separate columns so the report stays traceable to the order.

Which amounts are in the revenue base?

Return-adjusted revenue is attributed merchandise sales after eligible discounts and reversals, as of a defined cutoff. Choose which paid order statuses qualify and whether non-merchandise amounts matter to any other report. Shopify’s sales reports distinguish discounts, reversals, shipping and taxes, and allocate order-level discounts proportionally. Map your export fields to your policy before importing totals. Shopify sales report definitions

How does a partial refund change one sale?

Preserve the original order allocation and apply the refund to the matching line. Fictional example. An attributed order has a $60 tote and a $40 pouch. The $10 order discount allocates $6 to the tote and $4 to the pouch. Checkout also has $8 shipping and $7 tax, both excluded under this policy.

Merchandise line After discount Eligible refund Revised revenue
Tote $54 $0 $54
Pouch $36 $36 $0
Order $90 $36 $54

If the export contains a tax reversal alongside the pouch refund, keep it on the tax line. If an eligible order is fully canceled, reduce its eligible balance to zero once. Use the same order and refund references to prevent counting a cancellation and its refund twice.

How should the report show the change?

  1. Keep the original $90 order contribution with its report date.
  2. Add the $36 merchandise reversal, its processor or store reference and the date it was processed.
  3. Issue an updated cohort report with a later as-of date and a $54 contribution. If you also maintain a period report, show the reversal in the processing period according to your reporting policy.

Use the return-adjusted revenue calculator to check the base. Send the revised value to the creator KPI report and apply the agreed commission reversal policy for payment.

Pick the grain and the cutoff

One row per merchandise line lets you preserve the intended weight of a discount and keep an excluded item out of the commission base. Define an eligible line by product, paid status, credited creator and currency. Decide when data is frozen for a statement. A later store export may include an adjustment reviewed after your cutoff. When the next reader opens the report, they should know which version of the order data produced the total.

Keep the original sale at its original amount. Add a separate reversal tied to its line reference and the refund event. Verify whether the export already shows net order amount after adjustments. A later snapshot of the net amount and a separate refund ledger can describe the same change. Select one accounting route per report and record how you deduplicate the source.

What the merchandise refund changed
  1. Before eligible refund$90
    $90
  2. After $36 reversal$54
    $54
Fictional order. Both reported totals use eligible merchandise after discounts.

Work a more complicated return across two periods

Fictional case. An eligible bag is $70 and an ineligible strap is $30. A $20 basket discount is allocated proportionally, leaving $56 on the bag and $24 on the strap. The buyer pays $8 in shipping and $6 in tax. In June, they receive a $10 merchandise adjustment on the bag. In July, they return the remaining bag for a $46 merchandise reversal and receive a separate $3 tax adjustment.

The June campaign snapshot should show the bag’s original $56 eligible base and the $10 reduction, leaving $46. The July as-of snapshot brings that eligible life-to-date amount to zero. In a processing-period report, June records the $10 reversal and July records $46. The strap, shipping and tax have a place in the payment or store reconciliation, and stay outside this example’s merchandise base.

Measure June close July close
Original eligible bag base $56 $56
Cumulative eligible reversals $10 $56
Remaining eligible amount $46 $0
Reversal processed within the period $10 $46

Investigate adjustments you can’t match

A financial refund can exist without a clean order-line reference. Put it into a review queue rather than assigning it to the most convenient creator. Look for the order link, affected SKU, amount, tax or shipping allocation and reversal status. Confirm it wasn’t already reflected in the preceding export. If the item still can’t be identified, show the unresolved adjustment separately in the close notes.

If an order was canceled after authorization but before funds settled, check whether it entered the eligible report in the first place. The answer determines whether the ledger needs a reversal or just a canceled-order disposition. When you record a replacement order or shipped exchange, treat its eligibility according to the original agreement and retain the link to any offsetting entry. Avoid double-counting a new line that represents the same purchase.

Share a tie-out with each revision

Show original attributed merchandise, discounts, eligible reversals, adjusted revenue and unresolved items as separate totals. Add a compact explanation of which period each uses. Check that changes sum from the previous snapshot and that each correction has a unique reference. If commission was already approved using the older amount, notify the approval owner with the change and its evidence. They can handle pay according to the agreement rather than inferring what to do from the revenue report alone.

Reconcile a partial reversal with an order-level export

Fictional exception. The store export shows total reversed value of $33, but the merchandise line shows a $28 reduction. The remaining $5 is a shipping reversal. The creator contract applies commission to merchandise after allocated discounts. Set the eligible adjustment at $28 and reconcile the remaining $5 to the shipping field. Save both amounts so a finance reviewer can trace them back to the store’s total. A report that tries to match only the bank or checkout amount will produce a different base.

Check how discounts were reflected before the return. If an order records an item at $70 before discount and $56 after allocation, compare the refund to the $56 eligible base. A report using gross item price could overstate the reversal by reintroducing the original discount. A refund can also create a new discount adjustment in the source export. Reconcile the actual merchant fields before claiming a value is a product refund.

Keep corrections legible across views

If the same return affects a weekly acquisition report, a month-end close and a creator statement, give each view the correct current and original dates. Show which figures were published to internal readers and which payment rows were approved. One adjustment reference connects them without forcing every report to adopt a single cutoff.

Reconcile two lines with different discounts and returns

Fictional checkout. A store sends a creator credit for an order with two eligible home goods. After a product discount, a $90 lamp and a $50 shade carry an additional $14 order discount. Suppose the exported allocation assigns $9 of the discount to the lamp and $5 to the shade. The merchandise base is then $81 and $45. The buyer returns the shade and receives $45 for merchandise plus $3 of related tax. Under the sample policy, the merchandise base falls by $45. The $48 cash refund is still useful for checking the payment record, which measures a different total.

Record Lamp Shade Order merchandise
Before allocated order discount $90 $50 $140
Net eligible merchandise at purchase $81 $45 $126
Eligible merchandise returned $0 $45 $45
Revised eligible merchandise $81 $0 $81

Keep the discount allocation supplied by the order system if the program relies on it. The example uses an aggregate discount field and line-level allocations. Subtracting both would reduce the base a second time. Confirm what a given export field already includes by tying a sample order to its underlying records. If an allocation is missing, flag the row and apply the documented policy once the required evidence is present.

Tie each close to a repeatable source snapshot

A report with an October 31 cutoff and a November 15 revision should both be reproducible. Store the original order extract, refund event timestamps, line references and the rule used to decide whether the return goes back into October or is shown as a subsequent adjustment. When you ingest updates, distinguish a nested change to one refund record from a separate refund event. Verify the event’s source identifier so a repeated import does not reverse the same merchandise twice.

Give each statement its own identity and report the bridged amounts. In the example, the original $126, the $45 returned and the revised $81 should stay visible. At a 10% commission the changed amount is $4.50 if the example agreement uses the revised base immediately. Keep any delay or exception in the payment status separate from the revenue arithmetic. A finance reviewer should be able to match the difference to a line-level source and explain why it appeared in one reporting period.

Compare canceled, exchanged and partially returned orders

A canceled order and a successful sale with a later return can reach the same net amount, with different histories. Keep both the original order eligibility and the subsequent event. An exchanged item may involve an original refund and a replacement order or a product substitution within the same record. Check what the commerce system supplies before treating a replacement as additional creator revenue. Follow the agreed credit conditions on the new item and record whether the replacement order itself was eligible.

The brand can include three lines in a routine sample. Find one order with two discount sources and verify the final merchandise. Find one partial return with a non-merchandise component and verify the eligible adjustment. Find an exchange and determine whether the new record is new revenue or a replacement. Select examples from the relevant reporting period and rerun the check after upgrading the export pipeline or changing how discounts are allocated.

You can explain a mismatch by tracing an identical order across dated snapshots. Before opening a full reporting period, locate the exact source event, decide whether the issue arises from selection, allocation or ingestion, and find any other rows exposed to the same cause. Once a correction is approved, store the prior report and a summary of the difference so both can be reproduced.

Discuss a pilot