Fees on one Etsy sale
sellerprofit_etsy_feesRead-onlyIdempotent
Works out Etsy's fees on one sale, line by line: the $0.20 listing fee, the 6.5% transaction fee, the 3% + $0.25 payment processing fee (also charged on sales tax), the 2.5% currency conversion when it applies, and the Offsite Ads fee (12% or 15%, at most $100) when the sale came from an Offsite Ad. Call it when a seller asks what Etsy takes from a sale, or what they keep from it before costs. Pass the item price and shipping charged; optionally the sales tax rate, whether it was an Offsite Ads sale and at which rate, and a currency mismatch. Returns each fee, the total, its share of the order and what's left, in US dollars, with the dated Etsy rules and their sources. Free, no sign-in. Takes numbers only; nothing is stored.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| itemPrice | Yes | The item price on this sale, US dollars, before shipping. | |
| offsiteAds | No | Did this sale come from an Offsite Ad? none, or the rate the shop pays: 12-percent (the shop has sold $10,000 or more in any 12 months) or 15-percent (under $10,000). Default none. | none |
| salesTaxRate | No | The sales tax rate the buyer paid, as a fraction (0.07 is 7%). Etsy charges its 3% processing fee on the tax too. Default 0. | |
| shippingCharged | No | What the buyer paid for shipping, US dollars (0 if free). | |
| currencyMismatch | No | True when the listing's currency differs from the payment account's (Etsy adds 2.5%). Default false. |
Output Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| fees | Yes | ||
| text | Yes | ||
| rates | Yes | Which rules the numbers use, as of when, and where they come from. | |
| platform | Yes | ||
| salesTax | Yes | ||
| afterFees | Yes | Order total minus every fee: what's left before materials, packaging, the label and ads. | |
| totalFees | Yes | ||
| offsiteAds | Yes | ||
| orderTotal | Yes | Item + shipping the buyer paid, before tax, US dollars. | |
| feeShareOfOrder | Yes | Total fees ÷ order total. |