Automation library

Automate affiliate and creator payout reconciliation, before the money goes out

Updated · By Ecomsellertool editorial team

Short answer

Before you pay affiliates or creators, match every commission the affiliate platform claims to a real order in your store. Remove cancelled, refunded, disputed and self-referred orders, pay once when a link and a code both claim the same order, and hold orders still inside the return window. Rules do the matching and the math; a person approves the payout list and the accounting entry.

  • Payable commission = (commissionable sales on eligible orders - refunded sales) x rate + released holds - clawbacks.
  • Shopify Collabs holds each commission for 30 days by default (1 to 90 days by setting) and cancels commission on canceled and fully refunded orders during that time (checked November 14, 2026).
  • Shopify Collabs adds a 2.9% processing fee to every automatic commission payment, charged on the Shopify bill.
  • Shopify's Order object gives access to only the last 60 days of orders by default, so a reconciliation that waits out a return window needs access to all orders.
  • The IRS instructions for 2026 forms say to enter nonemployee compensation of $2,000 or more in box 1a of Form 1099-NEC; card and third-party network payments go on Form 1099-K. Not tax advice.

The step map: who runs each step

Trigger: Month-end close of the affiliate program, plus a weekly check of commissions that leave the holding period in the next seven days.

Each step of the workflow in order, and whether a fixed rule, an AI model or a person runs it
StepWhat happensWho runs it
1The workflow pulls the affiliate platform's commission report for the period: one line per claimed order, with the affiliate, the link or code that earned it, the order value, the rate and the commission.Rule
2Each claimed order is matched to the store's own order by order number. The match reads the order's status, discount codes, refunds, cancellation, disputes, payment methods, customer and shipping address.Rule
3The decision table runs on every matched line: cancelled, fully refunded, partly refunded, disputed, self-referred, paid by gift card, claimed by two affiliates, exchanged, or still inside the return window.Rule
4Orders that last month's run held for the return window are rechecked and released or removed. Orders already paid that were refunded afterwards become clawback lines.Rule
5The payable commission is computed per affiliate with the formula, next to the platform's own figure, and every difference is listed order by order with its reason.Rule
6A person reviews the held cases and the differences, decides the ones the rules cannot, and approves the payout list.Person
7The approved list becomes a payout file or a bill per affiliate, and one balanced accrual entry is drafted for QuickBooks Online or Xero with the list attached. Payment itself is released by a person.Rule
8Each affiliate gets a statement of orders paid, removed and held, with reasons. The run is logged, and held and deferred orders carry into next month.Rule

7 rule steps · 0 AI model steps · 1 person step. A rule follows fixed logic you approve; an AI model handles messy input and its output is checked by rules; a person makes the calls listed below.

Person

What stays with a person

  • The program terms the rules encode: which orders earn commission, the return window, and the tie-break when two affiliates claim one order
  • Every held case: open chargebacks, suspected self-referral, a leaked code, and any order the report claims that the store cannot find
  • Clawing back a commission that was already paid, and how to tell the affiliate
  • Approving the payout list and releasing the payment
  • The accounts the entry posts to and anything about tax forms, decided with your accountant
Tools

Which tools can run it

  • Your affiliate platform's own holding or locking period, plus a monthly spreadsheet check, for a small program on one store
  • Zapier, Make or n8n pulling the commission report and store orders into a sheet, with an approval step in Slack or email
  • Custom code on your accounts, for several stores or affiliate platforms, per-order audit trails, clawbacks and the accounting entry

Systems it connects

  • Shopify orders, refunds and disputes
  • Affiliate or creator platform (commission report)
  • Returns tool or 3PL returns data
  • QuickBooks Online
  • Xero
  • Payout tool or bank file
  • Approval queue in Slack or email

Build size: Medium

Matching orders is simple; the work is writing the program rules down, carrying holds and clawbacks across months, and a difference list finance can sign.

An affiliate platform counts a commission the moment an order is placed with a creator's link or code. Your store keeps changing that order for weeks afterwards: it is cancelled, partly refunded, charged back, or exchanged. If nobody compares the two before payout, you pay commission on sales you gave back, pay two creators for one order, and pay a creator for buying with their own code. This recipe runs that comparison every month and gives finance a payout list it can sign. It is one page of our automation library.

Which orders should lose, keep or wait for their commission?

Start here, because every other step applies this table. Each row is a case the workflow can detect from your own order data. The middle columns say what the data shows and the usual treatment; the last says who decides. The treatments are common choices, not rules of law. Your affiliate terms decide, so copy the table, change it to match your terms, and have the person who owns the program sign it.

CaseWhat the data showsWhat to do with the commissionWho decides
Full refundRefunds on the order add up to the full item valueRemove it. If it was already paid, add a clawback lineRule; a person approves any clawback
Partial refundRefunds add up to less than the item valuePay on what the customer kept: commissionable sales minus the refunded salesRule
Cancelled before fulfillmentThe order has a cancellation date and nothing shippedRemove itRule
ChargebackA payment dispute is open on the orderHold until the dispute closes. Remove it if you lose; pay it if you winA person, after the outcome
Paid with a gift card or store creditA gift card or store credit is one of the payment methodsPay or exclude by your written terms. The sale is real, but some brands exclude the part paid by store creditProgram owner sets the rule once
A gift card bought through the linkThe line item is a gift cardOften excluded or held, because a gift card sold is not yet a sale; see our gift card liability recipeProgram owner and accountant, once
Code used by a non-affiliate, or a leaked codeRedemptions far above the creator's normal rate, or orders arriving from coupon sitesHold the spike orders. Pay or reduce them by your termsA person; the discount code leak alerts recipe supplies the evidence
Two affiliates on one orderOne creator's link and another creator's code on the same order numberPay once, by your written tie-break (the code wins, or the last click wins)Rule; a person only if the terms are silent
Self-referralThe customer's email, name or shipping address matches the affiliate's own recordRemove it if your terms exclude own purchasesA person confirms the match
ExchangeA return with a replacement item; the net order value may go up or downPay on the final net value once the exchange is completeRule
Still inside the return windowDelivery date plus your return window is after the cut-off dateDefer to the next run. Do not pay yet and do not removeRule
Claimed order not found in the storeThe report has an order number the store does notHold and ask the platform. Never pay an order you cannot seeA person

Three outcomes come out of the table: pay, remove, or wait. "Wait" has two forms that must not be mixed. A deferred order is fine and only needs time. A held order needs a person. Keeping them apart is what stops the held pile from growing every month until nobody trusts it.

How do you calculate the payable commission?

Compute it yourself from the store's numbers, per affiliate, and then compare it with what the platform says. The difference is the reason for the exercise.

Payable commission = (commissionable sales on eligible orders − refunded sales on those orders) × commission rate + holds released from earlier months − clawbacks on orders already paid

An eligible order is one that matched a real store order and came out of the decision table as "pay". Commissionable sales is whatever your terms pay on, usually item value after discounts and before shipping and tax. Write that definition down once, because the platform may use a different base.

A worked example

Every number here is illustrative, not from any store or client. One creator earns 10%. In the month, the platform's report claims 42 orders at $80 of commissionable sales each: $3,360 of sales and $336.00 of commission.

Line (illustrative)OrdersSalesEffect on the base
Claimed by the platform42$3,360Start
Cancelled before fulfillment2$160Removed
Fully refunded3$240Removed
Self-referred (creator's own address)1$80Removed
Also claimed by another creator; the tie-break gives it to them1$80Removed
Not found in the store1$80Held, not paid
Open chargeback1$80Held, not paid
Still inside the return window5$400Deferred to next month
Partial refunds on 4 of the orders that stay4 (kept)$120Reduced
Eligible base this month28$2,120$3,360 − $1,240

The base is 28 orders at $80, which is $2,240, minus $120 of partial refunds: $2,120. At 10% that is $212.00. Two lines come from earlier months. Orders deferred last month have now passed the return window with $300 of clean sales, so $30.00 is released. One order paid last month was refunded afterwards for $50, so $5.00 is clawed back.

Payable = $212.00 + $30.00 − $5.00 = $237.00, against $336.00 claimed

The $99.00 gap is not an error by the platform. It counted orders at checkout; the store knows what happened next. The creator's statement shows each removed, held and deferred order with its reason, which is what keeps the conversation short.

Where should the numbers come from?

No single system holds the whole picture. The platform knows who referred the order. The store knows what became of it.

SourceWhat it knowsWhat it missesUse it for
The store's own order and refund dataThe final state of each order: refunds, cancellation, disputes, payment methods, discount codes, customer and addressWhich affiliate's link the buyer clicked, unless a code was usedThe truth about whether a sale stood
The affiliate platform's reportWhich affiliate earned which order, the rate, and its own commission figureWhat happened after its cut-off, your return window, self-referrals, a second platform's claim on the same orderThe claim to be checked
A custom build that joins bothEvery order with both views, holds and clawbacks carried across months, one audit trailNothing that is in the two sources; it costs a build and upkeepThe payout list and the accounting entry

On Shopify, the store side comes from one object. Shopify's Order object lists the discount codes used, the refunds applied, the cancellation date, the payment disputes on the order "such as chargebacks or payment inquiries", the payment gateways used and the customer's visits before the order (checked November 14, 2026). The same page carries a limit that matters here: only the last 60 days of orders are accessible by default, and older records need a request for access to all orders. A run that waits out a 30-day return window after delivery will reach past 60 days, so ask for that access at the start.

If you run creators through Shopify Collabs, the claim side is its Sales report. Shopify's page on managing creators in Collabs says the report can be filtered by date range and program and exported (checked November 14, 2026). For a daily feed, the page on using Flow with Shopify Collabs lists an order attributed trigger among its Collabs-specific triggers, for orders a creator has driven (checked November 14, 2026). Marketplaces that run and pay their own creator programs settle differently, so we check those platform by platform in a project rather than describe them here; our TikTok Shop page covers how its creator commission fits into a SKU's costs.

How long should you wait before paying?

Longer than your return window. A commission paid before the window closes is a commission you may have to ask the creator to repay. Most platforms give you a waiting period for exactly this reason, and the first job is to set it to match your own policy.

Shopify's page on paying creators on Collabs says all affiliate commissions are first subject to a holding period, 30 days by default and adjustable from 1 to 90 days, and that during it "the commission of canceled and fully refunded orders are automatically canceled" (checked November 14, 2026). After the holding period the commission is added to your Shopify bill automatically, with a 2.9% processing fee on every automatic commission payment. During the period you can open a payment dispute with a creator over a commission you find suspicious.

That page does not say what happens to a partial refund, or to a refund made after the holding period ends. Those are the two cases to check yourself, which is why the workflow runs a weekly list of commissions about to leave the hold, with partial refunds, open disputes and self-referral flags beside each one. A person can then act while there is still time.

Affiliate networks work the same way under other names. impact.com's page on action locking and payment scheduling describes a locking period in which a brand makes any modifications or reversals, says an action cannot be updated once the period has passed, and gives 90 days as the maximum when locking is set in days (checked November 14, 2026). Whatever the tool, the rule is the same: finish the reconciliation before the lock, not after.

How does the approved list reach your ledger?

As one accrual per month, with the payout list attached. Commission is a selling cost of the month the sale happened, even if the cash leaves later, so most accountants book the approved amount as an expense and a payable, then clear the payable when the payout runs. In the worked example the draft entry is a $237.00 debit to affiliate commission expense and a $237.00 credit to commissions payable. Whether the $40.00 on deferred orders and the $16.00 on held orders are also accrued is your accountant's decision, not the workflow's.

In QuickBooks Online, Intuit's journal entry guide says the total of the Debits column must equal the total of the Credits column (checked November 14, 2026). In Xero, the Xero Accounting API specification defines manual journal lines where debits are positive and credits are negative, and shows the error returned when total debits do not equal total credits (checked November 14, 2026). The workflow drafts the entry; a person posts it. If commission is also a line in your margin reports, it belongs in contribution margin per order, next to discounts.

What should stay with a person?

The rules match, sort and add up. People decide anything that changes what a creator is paid for a reason a rule cannot prove. That means every held case: an open chargeback, which our chargeback evidence recipe works in parallel; a suspected self-referral; a code that has leaked; an order the store cannot find. It also means every clawback, because asking a creator to repay affects the relationship, and the final approval of the list. Refund amounts themselves come from your returns and refunds workflow; this recipe only reads them.

One more decision sits outside the monthly run: the terms. If your affiliate terms do not say what happens on a partial refund, a gift card order or a two-creator order, the workflow has nothing to apply. Write those rules before building. Product you send to creators for free is a separate flow, covered in our creator gifting orders recipe, and should not be mixed into commission.

Which tool should run it?

For a small program on one store, the platform's own holding period plus a monthly spreadsheet check is enough: export the commission report, export orders, match on order number and apply the table by hand. A workflow tool such as Zapier, Make or n8n fits once you want the weekly pre-payout list and an approval step; our Zapier vs Make vs n8n comparison covers how they differ. Custom code earns its cost with more than one affiliate platform or store, holds and clawbacks that span months, or a finance team that wants every difference traced to an order. It can run on Ecomsellertool Growth OS beside your order and margin data.

Who builds affiliate payout reconciliation for ecommerce brands?

Ecomsellertool builds finance workflows like this one on your own store, affiliate platform and accounting accounts. We have built software on Amazon's seller APIs since 2017 and shipped 50+ tools for 100+ teams. We start with your affiliate terms and the decision table, then build the matching, the holds, the payout list and the draft entry. Send a project brief below, or read how our workflow automation service works.

None of our published case studies is an affiliate payout build, so here is the closest finance work we have shipped:

  • Recomputing a number instead of trusting one report. For Seller-Drive we built a fee calculation engine that computes fees Amazon does not provide, from predefined criteria and business rules, next to fee data pulled from Amazon's APIs on a schedule and shown in a profit and loss statement. Recomputing commission from order data follows the same pattern.
  • Refunds inside the numbers. For Beezboard we built a business performance graph that shows refund cost and promotions next to COGS, Amazon fees and net margin, with sales and refund analyses run for the same date range.

You keep your accounts, your data and the custom code we build; the Growth OS base is licensed to you.

Get your payout reconciliation built

Send us how you pay affiliates and creators today

Describe the workflow you want automated. We reply with a written plan: scope, timeline and a fixed price.

A few sentences is enough: what happens today, who does it and how often.

Starts when you fill in the form

A quick private check that runs in your browser. No tracking, no puzzles.

A person reads every brief. You get a written plan within 2 business days; no obligation.

Frequently asked questions

How do I reconcile affiliate commissions before paying them?

Export the affiliate platform's commission report for the period and match every line to the order in your own store. Remove orders that were cancelled or fully refunded, reduce partly refunded ones, hold disputed orders and orders still inside the return window, and check each order is claimed once. Then compute the commission yourself and compare it with the platform's figure.

Should I pay affiliate commission on refunded orders?

Most programs do not, but your program terms decide. A full refund or a cancellation usually removes the whole commission, and a partial refund reduces it in proportion. The practical question is timing: wait until the return window has closed before paying, so you do not have to ask an affiliate to return a payment.

How long should I wait before paying affiliate commissions?

At least as long as your return window, plus the time a returned parcel takes to arrive and be refunded. Shopify Collabs uses a holding period of 30 days by default and lets you set 1 to 90 days. If your return policy is 30 days from delivery, a 30-day hold from the order date is too short.

What happens when an order has an affiliate link and a different creator's discount code?

Two affiliates can both claim it, especially if links and codes are tracked in different tools. Write one tie-break rule into your program terms, such as the code wins or the last click wins, and apply it every month. The workflow finds these orders by listing every order number that appears under more than one affiliate, then pays one commission.

Do I pay commission when an affiliate buys with their own code?

That is a program rule, so write it down. Many brands exclude self-referred orders. The workflow flags an order when the customer's email, name or shipping address matches the affiliate's own record, and a person confirms it, because a family member at the same address is a judgment call.

Do I need to send a 1099 to influencers and affiliates I pay?

Ask your accountant; this is not tax advice. The IRS instructions for 2026 forms say to report nonemployee compensation of $2,000 or more in box 1a of Form 1099-NEC, and that payments made by card or through a third-party network are reported on Form 1099-K by the payment settlement entity instead. A payout list per affiliate per year gives your accountant the totals.

Jaimin Dholakia, founder of Ecomsellertool
Jaimin Dholakia · Founder
Schedule a call

Get this workflow built on your own systems.

Prefer to talk the workflow through first? Schedule a free call with the engineers who would build it. Selling on Amazon? The free 24-hour diagnostic finds the operations gaps in your account: connect it with Login with Amazon, on Amazon’s own consent screen (we only read data; we never change listings, prices, stock or ads), and get a report within 24 hours of connecting, on business days.

Free · 30 minutes · Pick any open slot