Examples
Examples
Try the starting example
- Orders: ID, eligible base $, refunded eligible base $, commission %, supplied status approved/pending/rejected, net commission paid $
- A,100,20,10,approved,10 B,200,0,5,approved,9 C,100,0,10,pending,0
- Expected net commission by order ($)
- A: 8.00; B: 10.00; C: 0.00
- Total expected commission ($)
- $18.00
- Total recorded net commissions paid ($)
- $19.00
- Paid minus expected ($)
- $1.00
- Positive order overpayments ($)
- $2.00
- Positive order underpayments ($)
- $1.00
Try another scenario
- Orders: ID, eligible base $, refunded eligible base $, commission %, supplied status approved/pending/rejected, net commission paid $
- A,100,20,10,approved,8 B,200,0,5,approved,9 C,100,0,10,pending,0
- Expected net commission by order ($)
- A: 8.00; B: 10.00; C: 0.00
- Total expected commission ($)
- $18.00
- Total recorded net commissions paid ($)
- $17.00
- Paid minus expected ($)
- -$1.00
- Positive order overpayments ($)
- $0.00
- Positive order underpayments ($)
- $1.00
Calculation method
Calculation method
Expected net commission by order ($)
For approved orders round (eligible base−refunded eligible base)×rate to US cents. Other supplied statuses have zero currently expected commission.
Total expected commission ($)
Sum expected per-order commissions.
Total recorded net commissions paid ($)
Sum signed recorded net paid amounts, including supplied reversals.
Paid minus expected ($)
Recorded paid−expected.
Positive order overpayments ($)
Sum max(0,paid−expected) separately by order.
Positive order underpayments ($)
Sum max(0,expected−paid) separately by order so errors cannot cancel silently.
Symbols and units
- a
- Orders: ID, eligible base $, refunded eligible base $, commission %, supplied status approved/pending/rejected, net commission paid $
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Assumptions & limits
Assumptions & limits
- A per-order reconciliation under supplied approval states and rates. It does not attribute clicks, verify retailer orders, infer eligibility, fetch an affiliate account or trigger payment.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.
Further reading
Google Merchant Center: product-data terminology and consistency background ↗
Background reading; this does not imply endorsement or independent review of SumFizz.