Program operations · Free tool
Paste or upload affiliate sales, exclude refunds, apply a commission rate and payout threshold, then export partner payout totals.
Sales reconciliation
Required columns: partner, amount, and status.
Payout run
Payable now
$211.75
Balances at or above the threshold.
Total commission
$211.75
$847.00 confirmed revenue.
Excluded sales
2
Pending, refunded, or cancelled rows.
| Partner | Sales | Revenue | Commission | Status |
|---|---|---|---|---|
| jamie@partner.co | 1 | $499.00 | $124.75 | Payable |
| alex@partner.co | 2 | $348.00 | $87.00 | Payable |
| sam@partner.co | 0 | $0.00 | $0.00 | Carry forward |
Manual programs often start with a spreadsheet containing partner identifiers, transaction values, and statuses. This calculator groups confirmed transactions by partner, applies a percentage commission, and identifies balances that meet your payout threshold.
Processing happens inside your browser. The pasted sales data is not submitted to Refport or stored by this page.
Use the columns partner, amount, and status. Status can be confirmed, pending, refunded, or cancelled. Confirmed sales count toward commissions; the other statuses remain visible in the reconciliation summary but are excluded from payable totals.
Questions, answered
No. The calculator parses and groups the data locally in your browser.
Only rows marked confirmed are included in commissions. Pending, refunded, and cancelled rows are excluded.
Yes. Download a CSV containing each partner's confirmed revenue, commission, and payout status.
Keep planning
Start tracking referrals, rewarding advocates, and growing faster with Refport.