
Etsy Offsite Ads Fee Formula
Learn how an Etsy offsite ads sale estimate is calculated, including ad fees, total fees, net payout, profit, and profit margin.
This page explains the math behind an Etsy offsite ads fee estimate. It shows how order revenue, selling fees, and your own item and shipping costs combine to affect what you keep from a sale.
- 100% Free
- No Sign-Up Required
- Private & Secure
- Mobile Friendly
Estimated Profit
Where:
Add the item price and shipping charged to get order revenue. Subtract the offsite ads fee, transaction fee, and payment processing fee to get payout before costs. Then subtract your item cost and shipping cost to estimate profit.
Variables Explained
| Variable | What It Means | Unit |
|---|---|---|
| itemPrice - Item price | The product price paid by the buyer before tax. | currency |
| shippingCharged - Shipping charged to buyer | The shipping amount collected from the buyer. | currency |
| adFeeRate - Offsite ads fee rate | The percentage used to estimate the offsite ads fee. | percent |
| etsyTransactionFeeRate - Etsy transaction fee rate | The transaction fee percentage included in the estimate. | percent |
| paymentProcessingRate - Payment processing rate | The percentage part of the payment processing fee. | percent |
| paymentProcessingFixed - Payment processing fixed fee | The fixed amount added to the payment processing fee. | currency |
| itemCost - Item cost | Your cost to make or buy the item. | currency |
| shippingCost - Shipping cost to you | Your cost to ship or deliver the order. | currency |
Step-by-Step Calculation
Calculate order revenue
Combine the item price and shipping charged to the buyer.
orderRevenue = itemPrice + shippingCharged
Calculate the offsite ads fee
Apply the selected offsite ads percentage to total order revenue.
offsiteAdsFee = orderRevenue * (adFeeRate / 100)
Calculate the transaction fee
Estimate the transaction fee using the order revenue and the rate entered.
transactionFee = orderRevenue * (etsyTransactionFeeRate / 100)
Calculate the payment processing fee
Add the percentage-based processing fee and the fixed processing fee.
paymentProcessingFee = orderRevenue * (paymentProcessingRate / 100) + paymentProcessingFixed
Calculate total fees and payout before costs
Subtract all included selling fees from revenue to estimate payout before your own costs.
netPayoutBeforeCosts = orderRevenue - (offsiteAdsFee + transactionFee + paymentProcessingFee)
Calculate total seller costs and profit
Subtract your product and shipping costs to estimate profit.
estimatedProfit = netPayoutBeforeCosts - (itemCost + shippingCost)
Calculate profit margin
Express estimated profit as a percentage of order revenue.
profitMargin = estimatedProfit / orderRevenue * 100
Worked example for one Etsy offsite ad order
Order revenue
35.00 + 5.00
$40.00
Offsite ads fee
40.00 × 15%
$6.00
Transaction fee
40.00 × 6.5%
$2.60
Payment processing fee
40.00 × 3% + 0.25
$1.45
Total fees
6.00 + 2.60 + 1.45
$10.05
Net payout before costs
40.00 - 10.05
$29.95
Estimated profit
29.95 - (12.00 + 4.50)
$13.45
Final Result
Estimated profit is $13.45, and profit margin is 33.6% of the $40.00 order revenue.
Assumptions
- ✓The offsite ads fee applies to the order revenue made up of item price plus shipping charged.
- ✓The transaction fee rate and processing fee values entered are accurate for the market being estimated.
- ✓Item cost and shipping cost reflect the seller's actual direct costs for that order.
- ✓Taxes, refunds, discounts, and account-level adjustments are excluded unless built into the values entered.
Limitations
- !Actual Etsy payouts may differ because of taxes, refunds, discounts, reserves, or currency conversion.
- !This estimate does not include listing fees or other optional or market-specific Etsy charges unless added manually outside the formula.
- !Profit margin can be misleading if order revenue is very low or if costs not entered are material.
- !Fee structures can change over time, so past assumptions may not match future payouts.
Common Mistakes to Avoid
Entering item price but forgetting to include shipping charged to the buyer when comparing real payout.
Using product cost only and leaving out the seller's actual shipping cost.
Selecting the wrong offsite ads fee rate for the shop.
Ignoring the fixed payment processing fee and only using the percentage portion.
Comparing the estimate to a real payout that includes tax, refunds, or discounts not entered here.
Related Formulas
Frequently Asked Questions
How is Etsy offsite ads fee calculated in this calculator?
It multiplies order revenue by the selected ad fee rate. Order revenue is item price plus shipping charged to the buyer.
Does the formula include shipping charged to the buyer?
Yes. Shipping charged is included in order revenue, so it affects the offsite ads fee and other percentage-based fees in this estimate.
How do you calculate net payout before costs?
Net payout before costs equals order revenue minus the offsite ads fee, transaction fee, and payment processing fee.
How is estimated profit calculated for an Etsy offsite ad order?
Estimated profit equals net payout before costs minus item cost and shipping cost.
What is the profit margin formula here?
Profit margin is estimated profit divided by order revenue, multiplied by 100.
Why can my real Etsy payment amount differ from this formula?
Real payouts can include taxes, refunds, discounts, listing fees, currency conversion, and other account adjustments not included in this estimate.
Ready to calculate your result?
Use the calculator to get instant results with your own inputs.