CalculatorMasters

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

Estimated Profit = Order Revenue - Offsite Ads Fee - Transaction Fee - Payment Processing Fee - Item Cost - Shipping Cost

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

VariableWhat It MeansUnit
itemPrice - Item priceThe product price paid by the buyer before tax.currency
shippingCharged - Shipping charged to buyerThe shipping amount collected from the buyer.currency
adFeeRate - Offsite ads fee rateThe percentage used to estimate the offsite ads fee.percent
etsyTransactionFeeRate - Etsy transaction fee rateThe transaction fee percentage included in the estimate.percent
paymentProcessingRate - Payment processing rateThe percentage part of the payment processing fee.percent
paymentProcessingFixed - Payment processing fixed feeThe fixed amount added to the payment processing fee.currency
itemCost - Item costYour cost to make or buy the item.currency
shippingCost - Shipping cost to youYour cost to ship or deliver the order.currency

Step-by-Step Calculation

1

Calculate order revenue

Combine the item price and shipping charged to the buyer.

orderRevenue = itemPrice + shippingCharged

2

Calculate the offsite ads fee

Apply the selected offsite ads percentage to total order revenue.

offsiteAdsFee = orderRevenue * (adFeeRate / 100)

3

Calculate the transaction fee

Estimate the transaction fee using the order revenue and the rate entered.

transactionFee = orderRevenue * (etsyTransactionFeeRate / 100)

4

Calculate the payment processing fee

Add the percentage-based processing fee and the fixed processing fee.

paymentProcessingFee = orderRevenue * (paymentProcessingRate / 100) + paymentProcessingFixed

5

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)

6

Calculate total seller costs and profit

Subtract your product and shipping costs to estimate profit.

estimatedProfit = netPayoutBeforeCosts - (itemCost + shippingCost)

7

Calculate profit margin

Express estimated profit as a percentage of order revenue.

profitMargin = estimatedProfit / orderRevenue * 100

Worked example for one Etsy offsite ad order

Item price$35.00
Shipping charged to buyer$5.00
Offsite ads fee rate15%
Etsy transaction fee rate6.5%
Payment processing rate3%
Payment processing fixed fee$0.25
Item cost$12.00
Shipping cost to you$4.50
1

Order revenue

35.00 + 5.00

$40.00

2

Offsite ads fee

40.00 × 15%

$6.00

3

Transaction fee

40.00 × 6.5%

$2.60

4

Payment processing fee

40.00 × 3% + 0.25

$1.45

5

Total fees

6.00 + 2.60 + 1.45

$10.05

6

Net payout before costs

40.00 - 10.05

$29.95

7

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.

Try the Calculator →

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

1

Entering item price but forgetting to include shipping charged to the buyer when comparing real payout.

2

Using product cost only and leaving out the seller's actual shipping cost.

3

Selecting the wrong offsite ads fee rate for the shop.

4

Ignoring the fixed payment processing fee and only using the percentage portion.

5

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.

Try Etsy Offsite Ads Fee