ValueQuarry Pricing, profit, and payout tools

Calculator template

Etsy Seller Profit Template

Customize an Etsy-style seller profit calculator with price, quantity, product cost, shipping, fees, and ads.

Review the inputs and formulas below, then open this template in the calculator builder to customize the field names, values, result styles, and notes.

Open this template in the calculator builder Browse all calculator templates

Inputs

What people fill out

  • Sale price

    Uses sale_price in formulas, starts as a currency field, and begins at 42.

  • Quantity

    Uses quantity in formulas, starts as a number field, and begins at 1.

  • Product cost

    Uses product_cost in formulas, starts as a currency field, and begins at 14.

  • Shipping cost

    Uses shipping_cost in formulas, starts as a currency field, and begins at 6.

  • Marketplace fee

    Uses market_fee in formulas, starts as a percent field, and begins at 6.5.

  • Payment fee

    Uses payment_fee in formulas, starts as a percent field, and begins at 3.

  • Fixed fee

    Uses fixed_fee in formulas, starts as a currency field, and begins at 0.45.

  • Ad spend

    Uses ad_spend in formulas, starts as a currency field, and begins at 2.5.

Outputs

What the template calculates

  • Order profit

    Format currency

    Result style primary

    Formula (sale_price * quantity) - (product_cost * quantity) - shipping_cost - ((sale_price * quantity) * market_fee) - ((sale_price * quantity) * payment_fee) - fixed_fee - ad_spend

    Estimated profit after marketplace fees, payment fees, shipping, and ads.

  • Profit margin

    Format percent

    Result style metric

    Formula ((sale_price * quantity) - (product_cost * quantity) - shipping_cost - ((sale_price * quantity) * market_fee) - ((sale_price * quantity) * payment_fee) - fixed_fee - ad_spend) / (sale_price * quantity)

    Profit as a share of gross order revenue.

  • Estimated payout

    Format currency

    Result style breakdown

    Formula (sale_price * quantity) - ((sale_price * quantity) * market_fee) - ((sale_price * quantity) * payment_fee) - fixed_fee

    Marketplace payout before product cost, shipping, and ads.

Use cases

When this template helps

  • Estimate profit on a typical marketplace order.
  • Include shipping, listing fees, transaction fees, and ads.
  • Turn marketplace math into an editable custom calculator.

Related

More ways to work with this math

FAQ

Quick answers

Short answers for the questions that usually come up first.

Can I edit this etsy seller profit template?

Yes. Open the template in the builder, then change the labels, values, formulas, notes, or output display styles to fit your workflow.

Can I save a version after I change it?

Yes. Save it on this device, export JSON, or copy a share link after you make changes.

Can I use this as a starting point for a different calculator?

Yes. Templates are meant to be edited. Remove fields, add new ones, or swap formulas if you want a different custom calculator.