A sale price is not the same as what remains after fees and costs. To review a product or listing, begin with order-level records, use the amounts shown in your own payment account, and apply the same cost rules each time.
Etsy’s fees can depend on the service used and the seller’s location. Its current Fees & Payments Policy and Etsy Fee Basics describe the fee categories and where sellers can review account charges. This guide does not estimate or replace those current account-specific amounts.
Start with one order
For each order or sale line, record the amounts that belong to it:
- item revenue and shipping charged to the buyer
- transaction, payment-processing, and any advertising or other marketplace fees shown in your account
- the shipping label or postage cost you paid
- product cost or COGS
- packaging and other direct costs, if you include them in your chosen measure
- refunds or adjustments when they occur
A useful order-level calculation is:
Order-level result = item revenue + shipping charged
- marketplace fees - shipping cost
- COGS - allocated ad cost - other direct costsThe calculation is only as complete as its inputs. Decide whether labor, general overhead, taxes, refunds, and unsold inventory are included in your business measure. Do not compare two listings if one has postage or advertising allocated and the other does not.
Keep listing totals and order results distinct
A listing may have many orders. Calculate each order consistently, then group the resulting rows by a stable product/SKU or listing reference for the time period you want to review. For orders with several products, decide how shared shipping and fees will be allocated and apply that rule consistently. Note that refunds or later fee adjustments can change a period’s total.
Fictional order example
The amounts below are made up to show the arithmetic. They are not typical Etsy fees, a real sale, or a Plain Method customer result.
| Line | Amount |
|---|---|
| Item revenue | $32.00 |
| Shipping charged | $5.00 |
| Fees recorded from the seller account | −$4.10 |
| Shipping label paid | −$6.00 |
| Product cost | −$9.00 |
| Allocated advertising cost | −$2.50 |
| Other direct cost | −$1.25 |
| Illustrative order-level result | $14.15 |
The example excludes any taxes, labor, general overhead, or later adjustments not shown. Use your own records and accounting method for business decisions.
Use a method you can keep current
For a few sales, a spreadsheet table may be enough. Record one sale line at a time, keep the product/SKU reference consistent, and periodically compare your own totals with the marketplace’s payment account. A formula can calculate a result, but it cannot fill in a fee, refund, or cost that was never recorded.
For more listings, a seller workbook can keep product costs, sales, stock movements, and expenses in one place. Check whether it imports automatically or requires manual entry before choosing it.
Where Seller Profit & Inventory OS fits
Seller Profit & Inventory OS is a one-time Excel workbook for recording products, stock, sales, fees, shipping, ads, other costs, and COGS. Its sales records calculate order-level net profit and margin, and its overview summarizes activity by month and channel. R1 is manual-entry; it does not connect automatically to Etsy or another marketplace. It is an operational record-keeping tool, not accounting, tax, or financial advice, and it does not guarantee a business outcome.
See Seller Profit & Inventory OS for the current workbook details and requirements.
Frequently asked questions
What is the simplest way to calculate profit on an Etsy order?
Add item revenue and shipping charged, then subtract the fees and direct costs you choose to include. Use the actual fee records in your account rather than a generic percentage.
Are Etsy fees the same for every seller?
No. The applicable fees can depend on the service and seller/payment-account location. See Etsy’s current policy and your Payment account for your actual charges.
Does a sales spreadsheet automatically import Etsy orders?
Not necessarily. Seller Profit & Inventory OS uses manual entry and does not automatically sync with Etsy.
Is an order-level result the same as business profit?
Not always. It may exclude labor, general overhead, taxes, refunds, or other costs depending on your method. Define the measure before comparing periods or listings.