Core formulas
The formulas to keep straight
Order revenue = item price + shipping chargedStandard US Etsy fees = $0.20 listing + 6.5% transaction + 3% processing + $0.25 processing fixed feeProfit = order revenue - Etsy fees - shipping label cost - product cost - material cost - labor - packaging - ad spendProfit margin = profit / order revenueMinimum price = (seller costs + fixed fees) / (1 - target margin - percentage fees)What should an Etsy fee spreadsheet template include?
An Etsy fee spreadsheet template should include revenue, Etsy fees, seller costs, labor, ads, and target margin in separate columns. Do not put fees and costs in one lump. That hides the problem when a listing looks busy but keeps little profit.
The FeeProofed CSV template includes editable inputs for item price, shipping charged, shipping label cost, product cost, material cost, labor hours, labor rate, packaging, ad spend, listing fee, transaction fee, payment processing, Offsite Ads, currency conversion, regulatory fee, and target margin.
This guide checked Etsy's Fees & Payments Policy and Etsy Payments Policy on July 3, 2026.
Etsy spreadsheet columns and formulas
Use these columns when building or checking an Etsy pricing spreadsheet.
| Spreadsheet area | Fields to include | Why it matters |
|---|---|---|
| Revenue | Item price, shipping charged | Etsy fees apply to the order revenue base |
| Etsy fees | Listing, transaction, processing, Offsite Ads, conversion, regulatory | Each fee has a different rule and should stay visible |
| Seller costs | Shipping label, product cost, materials, packaging | These costs are not Etsy fees but still reduce profit |
| Labor | Labor hours, labor rate | Handmade and custom products need paid time in the price |
| Ads | Ad spend or attributed Offsite Ads rate | Ads can turn a good price into a weak price |
| Decision | Profit, profit margin, minimum price | The sheet should tell you what to change next |
How do you use the free CSV template?
Download the CSV, open it in Google Sheets or Excel, then replace the two example rows with your listings. Keep the fee columns editable. That makes the file useful when Etsy changes a fee or when your shop uses a non-US payment rate.
The template is built as a spreadsheet starting point, not a locked quote. Format the profit margin column as a percentage after import, then duplicate rows for each listing you want to review.
Use the live Etsy Profit Calculator when you want to check one product in detail. Use the spreadsheet when you want to compare 20 products and find the weak ones.
CSV setup steps for Google Sheets or Excel
The template works as a normal CSV file with formulas in the example rows.
| Step | Action | Check before trusting the result |
|---|---|---|
| 1 | Open /templates/etsy-fee-pricing-template.csv | Make a copy before changing formulas |
| 2 | Replace example listing rows | Use your real shipping label cost and labor time |
| 3 | Set local fee inputs | Change processing, fixed fee, currency, and regulatory fields if needed |
| 4 | Format margin cells | Show profit margin as a percentage |
| 5 | Sort by profit or margin | Fix listings that look busy but earn too little |
What Etsy fee formulas should the spreadsheet use?
For a standard US Etsy order, use $0.20 listing fee, 6.5% transaction fee, and 3% + $0.25 payment processing. Put Offsite Ads, currency conversion, and regulatory fees in separate columns because they do not apply to every shop or order.
The fee formula should start from order revenue: item price plus shipping charged. Then subtract Etsy fees and seller costs to get profit. Do not use payout as profit because payout can include reserves, refunds, labels, ads, and timing differences.
As of July 3, 2026, a standard $50 US Etsy order with no shipping charged has $5.20 in Etsy fees before seller costs.
Etsy spreadsheet fee formulas
US defaults are shown. Replace country-specific processing fields when needed.
| Line | Formula | Default input |
|---|---|---|
| Order revenue | Item price + shipping charged | $50 + $0 = $50 |
| Listing fee | Editable fixed listing fee | $0.20 |
| Transaction fee | Order revenue x transaction fee % | 6.5% |
| Processing fee | Order revenue x processing % + fixed processing fee | 3% + $0.25 |
| Offsite Ads fee | Order revenue x Offsite Ads % | 0%, 12%, or 15% |
| Total Etsy fees | Listing + transaction + processing + optional fee lines | $5.20 on a $50 standard US order |
How do you calculate Etsy profit in a spreadsheet?
Calculate Etsy profit by subtracting Etsy fees and seller costs from order revenue. The seller costs should include shipping label cost, product cost, material cost, labor, packaging, and ad spend. Profit margin is profit divided by order revenue.
A $50 order with $5.20 in standard Etsy fees and $30 in seller costs leaves $14.80 profit. That is a 29.6% margin before income tax and overhead that is not assigned to the order.
The best spreadsheet setup shows both dollars and margin. Dollars tell you what the order keeps. Margin tells you whether the price can survive discounts, ads, or wholesale.
$50 Etsy profit spreadsheet example
US standard fees, no Offsite Ads, no shipping charged.
| Line | Amount | Formula or note |
|---|---|---|
| Order revenue | $50.00 | Item price + shipping charged |
| Standard Etsy fees | $5.20 | $0.20 + 6.5% + 3% + $0.25 |
| Seller costs | $30.00 | $4 label + $14 product + $10 labor + $2 packaging |
| Profit | $14.80 | $50.00 - $5.20 - $30.00 |
| Profit margin | 29.6% | $14.80 / $50.00 |
How do you set a price from target margin?
Set an Etsy price from target margin by putting percentage fees in the denominator. For a US seller with standard Etsy fees, use fixed fees of $0.45 and percentage fees of 9.5% before Offsite Ads. Then divide costs plus fixed fees by one minus target margin minus percentage fees.
If seller costs are $31.50 and the target margin is 30%, the standard US Etsy price is $52.81. That price is not guessed from a competitor. It is the minimum buyer-paid revenue needed for the target margin.
If Offsite Ads can apply, run the same row with 12% or 15% added to the percentage fee input.
Target-margin Etsy price example
US standard fee stack before Offsite Ads.
| Input | Value | Why it is in the formula |
|---|---|---|
| Seller costs | $31.50 | Costs assigned to one order |
| Fixed fees | $0.45 | $0.20 listing + $0.25 processing fixed fee |
| Percentage fees | 9.5% | 6.5% transaction + 3% processing |
| Target margin | 30% | Profit share of buyer-paid revenue |
| Minimum buyer-paid revenue | $52.81 | ($31.50 + $0.45) / (1 - 30% - 9.5%) |
What should non-US sellers change in the template?
Non-US sellers should change the payment processing percentage, fixed processing fee, currency conversion input, regulatory fee input, and listing-fee currency treatment before trusting the spreadsheet. Etsy payment processing depends on the seller's bank-account country.
Do not use the US 3% + $0.25 processing default for a UK, Canada, Australia, EU, or India shop. The template keeps those cells editable so the same sheet can still work after you replace the defaults.
The country rate table in Etsy's Payments Policy was checked on July 3, 2026.
Common Etsy processing inputs by country
Use the official Etsy Payments Policy for the full country table.
| Seller bank-account country | Processing input to check | Extra input to watch |
|---|---|---|
| United States | 3% + $0.25 | Sales tax treatment and Offsite Ads |
| United Kingdom | 4% + £0.20 | 0.48% Regulatory Operating Fee |
| Canada | 3% + C$0.25 domestic and US, 4% + C$0.25 international | 0.50% Regulatory Operating Fee |
| Australia | 3% + A$0.25 domestic, 4% + A$0.25 international | Domestic vs international processing |
| India | 5% + ₹25 | 0.05% Regulatory Operating Fee |
| France | 4% + €0.30 | 1.14% Regulatory Operating Fee |
How often should you update an Etsy fee spreadsheet?
Update an Etsy fee spreadsheet whenever Etsy changes fee rules, your shop changes country or currency, shipping label costs move, labor rates change, or Offsite Ads status changes. A spreadsheet with old fee defaults can make weak listings look healthy.
At minimum, check the fee inputs monthly if the sheet drives live pricing decisions. Also review any listing that depends on low margin, free shipping, discounts, or paid ads.
The template itself is only useful if the inputs stay current.
- Check Etsy's Fees & Payments Policy before major repricing.
- Check Etsy Payments processing rates for the seller's bank-account country.
- Update shipping label costs after carrier rate changes.
- Update labor rate when the seller's time target changes.
- Run Offsite Ads rows with 0%, 12%, and 15% when the margin is tight.
Decision table
Spreadsheet vs calculator vs workspace
Pick the tool that matches the decision.
| Tool | Use it for | Best next action |
|---|---|---|
| CSV spreadsheet | Reviewing many listings | Sort by profit margin and fix weak rows |
| Etsy Profit Calculator | Checking one product in detail | Test costs, fees, shipping, and target margin |
| Etsy Fee Calculator | Seeing what Etsy takes before seller costs | Compare standard fees and Offsite Ads |
| Pricing workspace | Saving profiles and comparing rows on this device | Build fee profiles and export decisions |
Worked examples
Examples you can compare against your own numbers
Example 1: $50 physical listing in the CSV
This example uses the first row in the CSV template: a $50 order, no shipping charged, US standard Etsy fees, $4 label, $14 product cost, 0.4 labor hours at $25 per hour, and $2 packaging.
| Order revenue | $50.00 | Item price plus shipping charged |
|---|---|---|
| Standard Etsy fees | $5.20 | $0.20 + $3.25 + $1.75 |
| Seller costs | $30.00 | $4 label + $14 product + $10 labor + $2 packaging |
| Profit | $14.80 | $50.00 - $5.20 - $30.00 |
| Profit margin | 29.6% | $14.80 / $50.00 |
Takeaway: A spreadsheet should show why a $50 sale is not a $50 profit event.
Check this product liveExample 2: $5 digital download row
This row shows why low-priced digital products need fixed-fee attention. A $5 digital download has no shipping label, but the fixed $0.20 listing fee and $0.25 US processing fixed fee still apply.
| Order revenue | $5.00 | No shipping charged |
|---|---|---|
| Standard Etsy fees | $0.93 | $0.20 listing + $0.33 transaction + $0.40 processing |
| Software or asset allocation | $0.50 | Example seller cost |
| Profit | $3.57 | $5.00 - $0.93 - $0.50 |
| Effective fee rate | 18.5% | $0.93 / $5.00 |
Takeaway: The spreadsheet makes fixed-fee drag obvious on $3 to $5 listings.
Open the digital fee exampleExample 3: target-margin price from the spreadsheet
The minimum price formula uses seller costs, fixed fees, percentage fees, and target margin. This keeps a seller from adding markup to cost and forgetting fees.
| Seller costs | $31.50 | Costs assigned to one order |
|---|---|---|
| Fixed fees | $0.45 | $0.20 listing + $0.25 processing fixed |
| Percentage fees | 9.5% | 6.5% transaction + 3% processing |
| Target margin | 30% | Profit share of revenue |
| Minimum price | $52.81 | ($31.50 + $0.45) / (1 - 30% - 9.5%) |
Takeaway: The target-margin row is the one to use before repricing a listing.
Action checklist
Before you use this number in the real business
- 1Download the CSV template and make a copy.
- 2Replace example rows with real listings.
- 3Update country-specific processing rates before using the sheet.
- 4Enter actual shipping label cost, not only shipping charged.
- 5Put labor hours and labor rate in separate columns.
- 6Run Offsite Ads at 0%, 12%, and 15% for tight-margin listings.
- 7Sort by profit margin and fix the worst rows first.
Common mistakes
Mistakes that make the answer look better than reality
FAQs
Questions people ask before making the decision
Is there a free Etsy fee spreadsheet template?
Yes. FeeProofed has a free Etsy fee calculator spreadsheet template as a CSV file with example rows and formulas. Open it in Google Sheets or Excel, then replace the example rows with your own listings.
What formulas should an Etsy pricing spreadsheet use?
Use order revenue, total Etsy fees, total seller costs, profit, profit margin, and minimum price for target margin. Keep fixed fees and percentage fees separate so the sheet works for low-priced products.
Does the template include Etsy Offsite Ads?
Yes. The CSV has an editable Offsite Ads percentage column. Use 0% for orders with no Offsite Ads, 12% for mandatory lower-rate shops, or 15% for eligible shops that have not opted out.
Can I use the spreadsheet for digital downloads?
Yes. Set shipping charged and shipping label cost to zero, then include any software, asset, design, or support cost you want assigned to the file. The $0.20 listing fee and processing fixed fee still matter on low prices.
Can UK, Canada, or Australia sellers use this template?
Yes, but they should change the processing percentage and fixed processing fee first. Canada and the UK should also use the regulatory fee input where it applies.
Is a spreadsheet better than an Etsy fee calculator?
A spreadsheet is better for reviewing many listings at once. A calculator is better when you want one clean answer, a shareable scenario, or a fast check before changing a price.
How often should I update an Etsy fee spreadsheet?
Update the sheet whenever Etsy changes fees, your shop changes country or currency, or your shipping and labor costs change. If the sheet drives live pricing, check the fee inputs at least monthly.
Sources and notes
Where the assumptions come from
Free CSV spreadsheet template with editable Etsy fee inputs, seller costs, profit formulas, margin formulas, and target-price formulas.
Official Etsy source for listing fees, transaction fees, Offsite Ads, shipping fee base, currency conversion, and regulatory fee rules.
Official Etsy source for country-specific payment processing rates and deposit fees.
Calculator used to check the spreadsheet profit examples and target-margin logic.
Detailed explanation of the fee-aware pricing formula used in the template.