Get a demo

Commission & payout calculations

Calculate partner payouts and sales commissions from order data, fee schedules, and SKU catalogs. Output a payout statement per partner every cycle.

Get a demo

The prompt

I want to calculate partner payouts and sales commissions from our order and SKU data. Can you build me a flow that pulls fulfilled order line items from Shopify, joins them against our fee schedule and SKU catalog, calculates payout amounts per partner, and outputs a formatted payout statement?

Just copy and paste the prompt into a new Parabola flow to get started.

What Parabola builds

A workflow with seven steps you can edit:

1. Pull fulfilled order lines. Shopify orders that have shipped, NetSuite invoices, marketplace settlements, and any wholesale invoicing data. The flow ingests every source.

2. Standardize the order. Order ID, SKU, partner or rep code, ship date, gross revenue, net revenue, return status. One row per order line with a consistent shape.

3. Apply the fee schedule. Per partner, per SKU class, per channel. Tiered rates, flat rates, bonus thresholds. The schedule lives in a table, not a formula.

4. Calculate the payout. Per partner, per period. Net of returns, plus or minus any spiffs, with the right currency and tax treatment.

5. Handle clawbacks and adjustments. Returns that cross periods reverse the commission. Bonus accrual catches up when the threshold hits. Each adjustment is traceable.

6. Roll up by partner. Statement per partner with the order detail, the rate applied, and the payout total. Finance reviews the rollup; the partner reads the statement.

7. Output the package. Per-partner statement, period roll-up, JE-ready file for the commission expense and accrual, optional Slack alert when a partner crosses a bonus threshold.

Why teams stop doing this manually

Commission runs combine three things that almost never line up cleanly. The order data, which lives in Shopify or the wholesale system. The fee schedule, which lives in a spreadsheet someone owns. The SKU catalog with the right category coding, which lives in NetSuite. The analyst builds the join every period.

The hard part is not the math. The hard part is the edge cases. A return from last period reduces this period's commission for a rep who no longer covers that account. A new partner gets onboarded mid-month and the schedule was not updated. A bonus tier kicks in for one partner but not another and the formula has to handle both. Every cycle, the spreadsheet grows another tab to handle a new exception.

The work is precise. A partner who gets paid wrong is a relationship problem. A commission accrual that misses the period is an audit problem. The team gets stuck owning a spreadsheet they cannot fully audit themselves.

The repetition is the giveaway. Same join, same schedule, same calculation, every period. That is exactly the kind of work that lives in a flow. The schedule changes get made once in the table. The math runs the same way every cycle. The statement goes out clean.

How it works

Step 1. Paste the prompt.

Open Parabola, paste the prompt in section 2, and let it ask follow-up questions about your fee schedule, your partner structure, and the statement format your partners expect.

Step 2. Connect your data.

API connections to Shopify and NetSuite, plus the fee schedule, partner master, and SKU catalog. Plus the chart of accounts for the commission entry.

Step 3. Run it every cycle.

Monthly for most. Weekly or bi-weekly for high-volume rep commissions. The flow refreshes against the latest data and outputs the statement set for review.

Related prompts

FAQ

Can the flow handle tiered commission rates that change mid-period?

Yes. The fee schedule supports tiered logic with effective dates. A rate change mid-period applies only to orders after the effective date. The flow tracks both rates per partner.

How does it handle commission clawbacks on returns?

Returns that match a fulfilled order from a prior period generate a clawback line on the current statement. The original payout is referenced for traceability.

Can the flow output a branded statement for each partner?

Yes. Template lives in the flow. Per-partner statement with their detail, rate, and total. Optional email send directly from the flow with the statement attached.

What about international commissions with FX?

The flow applies the period FX rate per partner currency. The statement and the JE both reflect the converted amount. Variance from rate fluctuation gets logged.

How does this work with multiple partner programs at once?

One flow per program is the cleanest pattern. Wholesale brokers, affiliate partners, and sales reps each have their own fee schedule and statement format. Same underlying flow structure.
Pay partners on time, every cycle.
Paste the prompt, point it at your orders and fee schedule, and let the payout run on its own.
Start for free