Calculation guide
Use tax-inclusive billings in one reporting currency. Refund rates refer to billed value. Remove refunds and included sales tax before applying each market’s effective store fee. Enter contract and tax rates from the statement.
Σ gross × (1 − refunds/100) ÷ (1 + tax/100) × (1 − commission/100)
Inputs
Tax-inclusive billings
Example entry 1200 (in the selected currency).
Refunded share of billings
Example entry 10 %. Allowed range 0 to 100.
Sales tax rate
Example entry 20 %. Allowed range 0 to 100.
Store fee rate
Example entry 12 %. Allowed range 0 to 100.
Worked example
Regional statements
| Tax-inclusive billings | Refunded share of billings | Sales tax rate | Store fee rate |
|---|---|---|---|
| 1,200 | 10% | 20% | 12% |
| 600 | 0% | 0% | 10% |
| Result | Value |
|---|---|
| Total net store proceeds | 1,332 |
| Refunded billings | 120 |
| Sales tax after refunds | 180 |
| Store commissions | 168 |
How each input affects this example
Each row starts from the worked example and changes one input.
| Input | Original input | New input | Affected result | Original result | New result |
|---|---|---|---|---|---|
| Tax-inclusive billings (row 1) | 1,200 | 1,320 | Total net store proceeds | 1,332 | 1,411.2 |
| Refunded share of billings (row 1) | 10% | 11% | Total net store proceeds | 1,332 | 1,323.2 |
| Sales tax rate (row 1) | 20% | 22% | Total net store proceeds | 1,332 | 1,319.016393 |
| Store fee rate (row 1) | 12% | 13% | Total net store proceeds | 1,332 | 1,323 |
