Etsy Pricing Spreadsheet Template

1. Use one row per Etsy order and keep gross, fees, and costs separate

The spreadsheet works best when each order gets its own row and the sheet keeps gross revenue, Etsy fees, and seller costs in separate columns. Etsy's fee rules do not treat everything as one simple commission, and IRS recordkeeping guidance is clearer when income, purchases, and expenses stay separated instead of blended into one net number.

• Track the order total the buyer sees, then break out each Etsy fee line instead of entering one guessed percentage.
• Keep product cost, packaging, shipping you pay, labor, and overhead allocation as separate seller-cost columns so the sheet can explain why profit changed.
• Use monthly summary rows only after the per-order detail exists, because summary tabs are much less useful when the raw order rows are missing.

2. The minimum useful columns are revenue base, Etsy fee lines, and seller cost lines

A usable Etsy pricing sheet does not need to be huge, but it does need the right buckets. Start with the listing price, quantity, shipping charged to the buyer, gift wrap or personalization charge if used, and any seller-funded discount. Then add separate columns for listing fee allocation, transaction fee, payment processing fee, Offsite Ads fee, Regulatory Operating fee if it applies in your country, and any currency conversion fee. After that, add your product cost and operating-cost columns.

• Revenue-side columns: item price, quantity, shipping charged, gift wrap or personalization, discount, and gross order total.
• Etsy fee columns: listing fee allocation, transaction fee, payment processing fee, Offsite Ads fee, Regulatory Operating fee, and optional currency conversion fee.
• Seller cost columns: materials or product cost, packaging, shipping cost to seller, labor, and overhead allocation.

3. Build the fee base correctly before writing formulas

The biggest spreadsheet mistake is applying every Etsy fee to the wrong base. Etsy's transaction fee applies to the displayed listing price plus the amount you charge for shipping and gift wrapping. The Etsy Payments fee is assessed on the gross order amount, including shipping and tax where applicable. Offsite Ads and Regulatory Operating fees also use their own bases. The sheet should mirror that logic instead of multiplying one guessed fee rate by the sticker price only.

• Use a dedicated fee-base column so every downstream formula references the same audited order value instead of repeating loose math across the sheet.
• Keep payment-processing rate and fixed fee in a settings tab because Etsy states these vary by the country of the seller's bank account.
• Add an ads-on toggle or column because Offsite Ads do not apply to every sale, but when they do, the fee can be large enough to change the required price.

4. Add a settings tab so the sheet stays editable when Etsy updates fees

A good pricing spreadsheet should not hard-code every live fee assumption inside row formulas. Keep editable settings for the transaction fee, listing fee, processing percentage, fixed processing fee, Offsite Ads rate, Offsite Ads cap, Regulatory Operating fee, and any currency-conversion assumption. That way one rate update does not force you to rewrite the whole workbook.

• The global constants tab is where you store your seller country, payment currency, default Offsite Ads assumption, and labor or overhead defaults.
• If you sell in batches, keep an expected-sales-per-listing setting so the listing fee can be amortized rather than treated as a mystery number.
• If your shop uses more than one pricing scenario, create a settings block for each scenario instead of overwriting one shared assumption row every time.

5. Let the spreadsheet calculate both net profit and break-even hints

The point of the sheet is not only to report what happened. It should also tell you whether the current price is healthy. Once the row tracks real order revenue, Etsy fees, and seller costs, the sheet can show net profit, effective Etsy fee rate, profit margin, and a break-even view that tells you whether the listing still works after ads or shipping pressure.

• Use one result column for net after Etsy fees and another for net profit after your own costs, because those are different questions.
• Add an effective Etsy fee rate column so you can see when shipping, ads, or country-specific fees push the platform take above your normal expectation.
• Use a reverse-pricing helper block when you need the item price required to keep a target profit after fees.

6. Keep the spreadsheet useful for records, not just pricing

IRS guidance on recordkeeping makes a good Etsy sheet more valuable than a quick calculator screenshot. Your business books should show gross income as well as deductions and credits, and small businesses need orderly supporting documents for gross receipts, purchases, and expenses. The spreadsheet should therefore work as a pricing tool and as an organized operating log that points back to real invoices, postage receipts, and platform statements.

• Keep order IDs, dates, and SKU or listing names so you can tie spreadsheet rows back to Etsy statements and receipts.
• Do not mix personal spending into the same workbook tab used for business cost tracking.
• If you use home-based overhead or shared expenses, allocate only the business portion rather than forcing personal costs into product pricing.

7. Use a market check after the spreadsheet gives you the price floor

The spreadsheet gives you a defensible price floor, but it does not pick the final market price on its own. SBA guidance still matters: check demand, market saturation, and what buyers already pay for alternatives. If the market will not support the number your sheet requires, that is a signal to improve the offer, reduce cost, change the channel, or rethink the product rather than quietly accepting a weak margin.

• Use the sheet to learn your minimum viable Etsy price first, then compare that number with real competitor and substitute pricing.
• If the market rejects the needed price, change the offer or cost structure instead of pretending the math does not apply.
• Review the sheet again when Etsy fee rules or your shipping pattern change, because the old price floor can become stale.

Suggested sheet tabs

Keep the workbook simple enough to maintain but detailed enough to explain profit.

• Settings tab: seller country, payment currency, listing fee assumption, processing preset, Offsite Ads rate, Offsite Ads cap, Regulatory Operating fee, labor defaults, overhead defaults.
• Orders tab: one row per sale with revenue columns, Etsy fee columns, seller cost columns, and result columns.
• Listings tab: SKU, listing URL, expected sales per listing, default product cost, and current target price.
• Monthly summary tab: total gross sales, total Etsy fees, total product costs, total profit, average order value, and effective fee rate.

Core formulas for the Etsy pricing spreadsheet

gross_order_total = item_price × quantity + shipping_charged + gift_wrap_or_personalization_charge - seller_funded_discount
listing_fee_allocation = listing_fee_per_publish ÷ expected_sales_from_listing or listing_fee_per_publish if you treat each sale separately
transaction_fee = transaction_fee_base × 6.5%
payment_processing_fee = gross_order_amount_for_payments × processing_rate + processing_fixed_fee
offsite_ads_fee = MIN(offsite_ads_base × offsite_ads_rate, offsite_ads_cap) if the order is attributed
regulatory_operating_fee = regulatory_fee_base × regulatory_rate if the seller country is subject to it
etsy_fee_total = listing_fee_allocation + transaction_fee + payment_processing_fee + offsite_ads_fee + regulatory_operating_fee + currency_conversion_fee
net_after_etsy_fees = gross_order_total - etsy_fee_total
net_profit = gross_order_total - etsy_fee_total - product_cost - packaging_cost - shipping_cost_to_seller - labor_cost - overhead_allocation

• Keep processing-rate inputs editable because Etsy states payment processing fees vary by bank country.
• If your shop is in a country where Etsy charges a Regulatory Operating fee, keep that rate in the settings tab rather than burying it in a hidden formula.
• If you want the sheet to produce target prices, add a reverse-pricing block instead of trying to guess a safe markup.

Assumptions

• The page is a spreadsheet structure guide, not a downloadable accounting file bundled inside this working set.
• The worked example uses Etsy's public UK seller-facing fee display because Etsy publicly shows those rates on its UK sell page, but the structure is designed to be adjustable for other seller countries.
• The template assumes you want to track fee-aware order profitability, not replace formal bookkeeping software or tax advice.
• If your shop has country-specific taxes, VAT, or currency-conversion effects beyond the example, those should stay editable in the settings tab rather than being treated as universal constants.

FAQ

Related pages

• Etsy Reverse Price Calculator
• Etsy Break-Even Calculator
• Etsy Offsite Ads Profit Calculator
• How to Price Products After Fees
• How to Price Handmade Products
• How to Include Shipping in Pricing
• Etsy vs eBay Fees Calculator
• All templates
• All calculators

Related tools and guides