Back to all articles
Affiliate MarketingShopify

Affiliate Payouts Without the Spreadsheet: Timing, Methods, Tax Forms and What to Do When One Fails

Paying affiliates is where good programs quietly lose trust. Learn when to run payouts so refunds cannot bite, how balances become pending payouts, which payment details and tax forms to collect and when, how reversals work, and what to do on the day a payment bounces.

Affiliate Payouts Without the Spreadsheet: Timing, Methods, Tax Forms and What to Do When One Fails

Most affiliate programs are designed around recruitment and commission rates, and then the money part is handled with a spreadsheet, a PayPal login and a Sunday evening. It works for twenty partners. It stops working somewhere around eighty, when one refund lands after a payout, one creator changes their bank account without telling you, and one tax form is missing in January.

Payouts are the moment an affiliate finds out whether the program is real. A payment that arrives on the date you promised, for the amount the dashboard showed, does more for retention than any commission bump. A payment that is late, short or silently reversed does more damage than any recruitment campaign can repair.

This post covers the decisions behind a clean payout run: when to pay, how balances turn into payouts, what to collect and when, how refunds and tax forms fit in, and a checklist for the day itself.

Run your affiliate program on Shopify

Install Reveshare from the Shopify App Store and start turning customers into ambassadors.

Get the app →

1. Pay after the return window, not after the sale

The single most important payout decision is timing, and the rule is simple: commission should not leave your account while the order that earned it can still come back.

If your return window is 30 days, an order placed on the 3rd of the month can be returned until the 3rd of the following month. Paying commission on it on the 15th means you may pay out on revenue you never keep. Multiply that across a program and the refund gap becomes a line item.

The pattern that solves this for most Shopify brands is monthly payouts on the prior month's orders. Orders from September are paid at the end of October or in early November. Every order has had a full return window to survive before its commission is released. Nobody has to check individual orders against a returns list.

1 month
between the order and the payout is the default that keeps refunds out of your payout run

Monthly payouts on prior-month orders line up naturally with a 30-day return window. If your window is longer, push the payout back to match. If it is 14 days, you could pay twice a month without risk, but most brands find monthly is simpler for everyone.

2. Balances, requests and pending payouts

It helps to be precise about the three states money passes through, because they are treated differently in Reveshare and they matter when you remove or audit an affiliate.

An unrequested balance is commission the affiliate has earned that has cleared your holding period but that they have not yet asked to be paid. It sits on their dashboard as available. If an affiliate is removed with an unrequested balance, that balance stops being payable, which is why Reveshare shows it to you before you confirm a removal.

A pending payout is a balance the affiliate has requested and you have not yet paid. It is a debt. Reveshare blocks the removal of any affiliate with a pending payout until it is settled, so nobody's earned money disappears with their account.

A paid payout is done. It is recorded against the affiliate with the date, method and amount, and it is the record you will need for tax reporting.

The practical consequence is that "how much do I owe" has two answers: what has been requested, which you must pay, and what has been earned but not requested, which you should expect to pay. A healthy monthly run clears the first and lets affiliates decide about the second.

3. One run, every program, the right method

If you run more than one program, say a customer ambassador track and a creator track, an affiliate can belong to both and earn in both. Paying them twice, once per program, doubles your fees and confuses them.

Reveshare settles across all of an affiliate's programs with your brand in a single payout. The bulk payout run gathers every pending request, groups them by affiliate, and sends one payment to each affiliate's matched payment method. The affiliate picks the method in their dashboard, PayPal or bank transfer, and you never handle the details by hand.

Spreadsheet payouts

  • Export orders, filter by code, apply the rate, check refunds by eye
  • One PayPal send per affiliate, typed from a column
  • Bank details kept in a document someone has to protect
  • Program by program, so multi-program affiliates get paid twice
  • No record of what was paid for which orders when a dispute arrives

A payout run

  • Commission is calculated per order as it clears, refunds already reversed
  • One bulk run pays every pending request to its matched method
  • Affiliates enter and update their own payment details
  • One payment per affiliate across every program with your brand
  • Every payout is recorded with orders, date, method and amount

See pricing that scales with you

Compare plans and find the right fit for your brand and creator volume.

View pricing →

4. Collect payment and tax details at first payout, not at application

The most common mistake in onboarding is asking for a bank account and a tax ID on the application form. It is the biggest single reason good applicants abandon a join page. They have not been approved, they have not made a sale, and you are asking for their social security number.

Collect in two stages. At application, take name, email and where they will share. At first payout, when there is money to be paid and every incentive to finish the form, ask for the payment method and the tax form.

For US-based programs, the tax side works roughly like this. Confirm the specifics with your accountant, because thresholds and rules change and your situation may differ.

  • W-9 is the form a US person or business gives you so you have their taxpayer identification number. You need it before you can file anything about them.
  • W-8 forms, most commonly the W-8BEN, are what a non-US affiliate gives you to certify they are foreign. There are several variants depending on whether they are an individual or a business.
  • 1099-NEC is the form you file for a US affiliate whose payments in a calendar year cross the reporting threshold. Commission is nonemployee compensation, so it is the NEC variant, not the MISC one. The threshold has changed in recent years, so check the current figure with your accountant before January.

On the Growth and Scale plans, Reveshare includes tax form assistance so the collection happens inside the affiliate's dashboard, tied to their payout record, rather than in your inbox. Whatever plan you are on, the principle is the same: the form is requested when the first payout is requested, and no payout goes out without it.

5. Refunds and reversals

A refund after a payout is the reason section one exists, but even with good timing, some will slip through: a late return, a chargeback, a partial refund on a multi-item order.

Reveshare tracks refunds against the orders that earned commission. When an order is refunded before payout, the commission is reversed and the affiliate's balance goes down. When the refund arrives after the payout has gone out, the reversal is applied against the affiliate's next balance. The affiliate is never asked to send money back, which is unenforceable anyway, and you are never out the commission for more than one cycle.

Two things make reversals painless instead of a source of disputes:

  1. Say it in the terms. One sentence: commission on refunded or charged-back orders is reversed, and if already paid, deducted from the next payout.
  2. Show it in the dashboard. An affiliate who can see that a specific order was refunded and its commission reversed does not write to you. One who sees an unexplained smaller number does.

6. Minimum thresholds

A minimum payout threshold, say $25 or $50, stops you from paying transaction fees on a $3 commission and stops the affiliate from receiving a payment that is mostly fee. It also quietly filters: an affiliate who never reaches $25 in a month is not really active.

Set the threshold low enough that a customer ambassador with three referrals in a quarter still gets paid. Set it high enough that a payout is worth the fee. Balances below the threshold roll forward, they are not lost, and that should be written on the join page next to the payout date.

7. When a payout fails

Every run has one or two failures. They fall into a few predictable buckets.

Wrong or outdated details. The affiliate changed banks or typed a PayPal email with a typo. The payment bounces. The failed payout shows up in your run so you can see who and why. Message the affiliate, ask them to update their method in the dashboard, and re-run for that one affiliate. Do not edit their details for them.

Closed or unverified account. PayPal accounts that are new or unverified sometimes cannot receive business payments above a limit. The affiliate has to resolve this on their side. Tell them what the error said and give them a date for the re-run.

Currency and country mismatch. An affiliate in a country your payment method does not serve, or a bank account in a currency your account cannot send. This one is a policy question. Decide which countries and methods you support, say so on the join page, and do not approve applicants you cannot pay.

Missing tax form. Not a failure exactly, but a payout held until the form arrives. Treat it as a reminder, not an error.

8. Tell affiliates when and how they are paid

Most payout complaints are not about the money. They are about not knowing when it is coming. Three places carry the information:

  • The join page. "Paid monthly via PayPal or bank transfer. September sales are paid in early November. Minimum payout $25." That is the whole policy in three lines.
  • The affiliate dashboard. Their balance, their pending requests, and the history of what was paid and when.
  • The payout email. Sent from your own domain if you run a white-label portal, so it is opened. A short note saying the payout was sent today, with the amount and the method, is the most read email your program will send.

9. The payout-day checklist

Monthly payout day, in order

  • Confirm the holding period: every order in this run is older than your return window.
  • Review the refund and chargeback list for the period and confirm the reversals are already reflected in balances.
  • Run the self-referral and fraud checks from your monthly audit before paying, not after.
  • Check for affiliates with a pending request and no payment method or tax form, and message them today.
  • Run the bulk payout to each affiliate's matched method across all programs.
  • Review the failed list, message each affiliate with the reason, and schedule a re-run within the week.
  • Send or confirm the payout notification email went out.
  • Note total paid, total reversed, and number of failures for your monthly report.

The whole thing takes under an hour once the settings are right, and most of that hour is the fraud check.

Conclusion

Payouts are the part of an affiliate program that affiliates remember. Pay monthly on prior-month orders so nothing is paid before it can be returned. Know the difference between an unrequested balance and a pending payout, and never remove an affiliate who has one. Pay once per affiliate across every program, to a method they chose. Collect payment details and tax forms at the first payout, not the application, and confirm the tax specifics with your accountant. Let refunds reverse automatically and deduct from the next balance when the money has already gone. Say the date, the method and the minimum on the join page, and then keep the date.

Have a question about your program?

Payouts, removals, tier setup, migrations. Write to the team and a real person replies, usually the same day.

Email the team →

Frequently Asked Questions