Skip to content

Affiliate Payout Calculator · Creators & Studios

Monthly affiliate statements with the math checked in code

Each partner's sales and commission from your sales sheet, recalculated in code and sent as a statement after your approval. It never pays anyone.

Available now $99 one-time · never renewsIncluded in Enterprise
Get this agent See how it works

Free account to start. Buying and running live need a paid plan.

  • Runs on a schedule
  • 2 AI steps
  • A person approves before it acts
  • About 20 min to set up

Sound familiar?

The job, before and after this agent.

What it feels like today

  • “Affiliate payout day means a whole evening of filtering spreadsheets and a calculator.”
  • “We once paid a partner on a sale that was refunded the next week.”
  • “Partners ask how we got their number, and we can't always show the working.”

What you get with the agent

  • This month's sales are chosen in code: past your refund window and not yet on a statement.
  • Each partner's sales listed with refunded rows left out, and the commission at their rate.
  • Net sales and commission recalculated in code, with any correction shown to you before approval.
  • Statements emailed after one approval, sale rows marked so none is counted twice, and a summary with the batch total.

Before

On the 1st you export sales, filter by affiliate code, sum each column twice, write five emails and hope nobody spots a refunded sale.

After

On the 1st five statements are waiting in Reviews, each listing the partner's sales and commission, with one AI arithmetic slip already corrected and flagged.

How it works

The whole workflow, step by step.

On the 1st of each month the agent reads your sales sheet in Google Sheets (an export from Gumroad, Lemon Squeezy or Shopify with an Affiliate column) and keeps, in code, the sales at least 30 days old (past your refund window) that aren't on a statement yet. For each partner in your partners tab, AI picks their sales, leaves out refunded rows and drafts a statement email; code adds up the sales and works out the commission at the partner's rate, correcting any AI arithmetic. All statements wait for one approval, are checked in code and emailed, and every sale row in the batch is marked so it's never counted twice. You get a summary with the batch total and any sales whose affiliate isn't in your partners tab. It never sends money.

  1. Trigger1st of every month at 8:00
  2. App callRead the sales
  3. LogicPick this month's sales
  4. App callRead your partners
  5. LogicEach partner
  6. AI stepDraft the partner's statement
  7. LogicCheck the math
  8. LogicAdd up the batch
  9. Human approvalApprove the statements
    • Approved:Each approved statement
  10. LogicEach approved statement
  11. LogicCheck before sending
  12. LogicSend it?
    • Passes:Email the statement
    • Held:Held
  13. OutputHeld
  14. OutputEmail the statement
  15. LogicCount what happened
  16. AI stepFind sales without a partner
  17. LogicEach sale in the batch
  18. App callMark the row
  19. OutputEmail your summary
  20. OutputDone

This is the workflow that opens in your workspace when you set the agent up. Every step can be edited.

  1. Step 11st of every month at 8:00Runs on the 1st of each month. Set your time zone on the trigger.
  2. Step 2Read the salesReads your sales tab (Date | Order | Product | Affiliate | Amount | Refunded | Statement), e.g. a Gumroad, Lemon Squeezy or Shopify export with the affiliate on each row.
  3. Step 3Pick this month's salesIn code, not AI: keeps sales at least 30 days old (past your refund window) that aren't on a statement yet (blank Statement cell). Change the 30 days here (olderThan).
  4. Step 4Read your partnersReads your partners tab (Affiliate | Email | Commission %).
  5. Step 5Each partnerDrafts a statement for every partner row (up to 50).
  6. Step 6Draft the partner's statementAI picks this partner's sales from the batch (copying each amount), leaves out refunded rows, and drafts the statement email with placeholders for the totals.
  7. Step 7Check the mathIn code, never by the AI: adds up the partner's sales, works out the commission at their rate, corrects anything the AI got wrong (flagged to the reviewer) and fills the totals into the email.
  8. Step 8Add up the batchIn code: the total commission across every statement in this batch, for you.
  9. Step 9Approve the statementsEvery partner's statement waits in Reviews together, with the math corrections first. Edit any, set send to false on any that shouldn't go, and approve.
  10. Step 10Each approved statementChecks and emails every approved statement.
  11. Step 11Check before sendingIn code: has sales, still marked to send, one valid partner email, the math fully checked (no TBD) and no placeholders left.
  12. Step 12Send it?Passes: emailed. Otherwise held and listed in your summary.
  13. Step 13HeldNo sales, set to not send, no valid email or the math couldn't be checked; listed in your summary.
  14. Step 14Email the statementSends the statement to the partner from your workspace's sender, with replies to you.
  15. Step 15Count what happenedIn code, not AI: which statements were sent and which are held, with the reason.
  16. Step 16Find sales without a partnerAI lists the sales in this batch whose Affiliate cell matches none of your partners, so you can add the partner or fix the cell.
  17. Step 17Each sale in the batchMarks every sale row of the approved batch so it's never counted twice.
  18. Step 18Mark the rowWrites “Statement <today>” into the row's Statement cell.
  19. Step 19Email your summaryEmails you what was sent and held, the batch total checked in code and the sales without a partner.
  20. Step 20DoneThe run history keeps every statement, the checks and the summary.

Example run

What goes in, and what comes out.

Example with fictional data

Comes in

Sales sheet with 42 rows from September and October; partners tab with Jamie at 20% and Lena at 15%.

The agent produces

Sales past the 30-day refund window are picked in code. Jamie's statement lists two sales totalling $73.50 and a commission of $14.70, with one refunded sale left out.

What you need

Everything it takes to run it.

About 20 minutes from purchase to live. A checklist above the canvas takes you through each step.

Plan

Included in Enterprise; on other paid plans it's $99 once. Agents run live on paid plans, from Basic ($39/mo).

Your AI key

Connect any of 15 AI providers on your own key. Your provider bills usage directly, at cost; we add no markup.

Apps

Checklist

  • A paid plan (agents run live on paid plans).
  • An AI provider key (Settings → AI Providers).
  • Google Sheets, connected in Settings → Integrations.
  • A sales tab (Date | Order | Product | Affiliate | Amount | Refunded | Statement) and a partners tab (Affiliate | Email | Commission %).

Setup, about 20 minutes

  1. Connect your AI provider. The AI steps run on your own key (OpenAI, Anthropic, Google and more). Add one in Settings → AI Providers.
  2. Connect Google Sheets. Connect the Google account that can open your sales sheet (Settings → Integrations → Google Sheets).
  3. Pick the sales and partners tabs. Open “Read the sales” and “Read your partners” and pick the account, spreadsheet and tab for each.
  4. Describe your program. Open “Draft the partner's statement” and replace the placeholder, then enter the Reply-to on “Email the statement”.
  5. Where to mark the rows. Open “Mark the row”: the same account, spreadsheet and sales tab, and the letter of the Statement column.
  6. Your summary. Open “Email your summary” and enter your email and Reply-to.
  7. Test it with Dry Run. Press Dry Run: the agent runs on sample data with no messages sent and nothing written to your apps.
  8. Switch the trigger on. Open the trigger, set your time zone and switch the schedule on. It runs on the 1st of each month at 8:00.

Is it a fit?

Who it's for, and what it won't do.

Built for

  • Creators running an affiliate or partner program
  • Course sellers paying commission to partners
  • Small shops with referral partners and a sales sheet

What it doesn't do

  • It never pays anyone or connects to a bank or PayPal: you pay partners yourself.
  • It reads affiliate data from your sheet, not from Gumroad or Lemon Squeezy directly.
  • Up to 50 partners and 500 sales rows per run; it makes no tax decisions.
  • Nothing is sent or marked before you approve the batch.

We list the limits up front so you can decide before you buy.

Price

$99 one-time

Per workspace. It never renews.

Available now
  • Included at no extra cost on Enterprise.
  • Buying and running it live need a paid plan, from Basic ($39/mo).
  • Dry Run costs nothing: simulated AI and app calls, nothing sent.
  • AI usage is billed by your own provider, at cost. No AI credits to buy from us.
Get this agent See how it works

One-time agent purchases aren't covered by the 30-day money-back guarantee. Refund policy

FAQ

Questions about Affiliate Payout Calculator.

Does it pay the partners?

No. It sends statements and a summary; you pay partners yourself through your usual method.

Can the AI get the commission wrong?

The AI matches sales to partners and writes the email; code recalculates each partner's total and commission and shows any correction before you approve.

Where do the sales come from?

From a Google Sheet with an Affiliate column, for example a Gumroad, Lemon Squeezy or Shopify export. Gumroad's API doesn't provide affiliate details.

Is it worth it compared with doing it by hand?

It's a one-time purchase that never renews and turns payout evening into one review. Live runs need a paid plan; Dry Run is free.

Who does the math?

Code. AI only matches sales to partners and writes the email; the sales total and commission are recalculated in code and any correction is shown to you before approval.

How is a sale never counted twice?

After you approve, every sale row in the batch gets “Statement <date>” in its Statement cell, and only rows with a blank Statement cell are picked next month. Rows with an affiliate that isn't in your partners tab are listed in your summary; clear their Statement cell to include them next month.

Is this a subscription?

No. Affiliate Payout Calculator is a one-time purchase of $99 per workspace and never renews. The Enterprise plan includes it at no extra cost. Running it live needs a paid plan (from Basic ($39/mo)), and your AI provider bills you directly for usage.

Can I test it before it touches real data?

Yes. Once it's set up in your workspace, Dry Run plays every step on sample data with simulated AI and app calls: nothing is sent and nothing in your apps changes. Switch the trigger on only when you're happy.

Put Affiliate Payout Calculator to work.

Free account, no credit card. Your Agents page opens with Affiliate Payout Calculator ready to buy and set up, then Dry Run it before it goes live.

Get this agent See how it works