Seller Profit Guard worked example: a full-price Etsy order
Last updated: 2026-07-27
Written and reviewed by Seller Profit Guard Editorial Team.
This worked example traces one $74 full-price Etsy order from export evidence to a $30 operating contribution estimate. It separates platform charges, materials, labor, packaging, shipping, and expected loss, then compares the result with a $16 target. Every number is illustrative and must be replaced with current seller records.
What order is this example reviewing?
Assume a seller ships one personalized home-goods SKU at full price. The item revenue is $68 and the buyer is charged $6 for shipping, producing $74 of seller-attributable order value before the example's cost layers. The order is paid, not cancelled, and not refunded. The seller has a stable SKU, a recent cost record, a timed personalization workflow, a label receipt, and a Payment Account row that can be matched.
This is not a claim about a typical Etsy order. The purpose is to show the evidence sequence and arithmetic. The example uses an illustrative $8 total for matched marketplace and payment charges rather than presenting a universal fee formula. A real seller should use the actual statement evidence or a current, country-scoped planning assumption from Etsy's official fee documentation.
| Evidence item | Example value | Source or assumption |
|---|---|---|
| Item revenue | $68.00 | Matched order export |
| Buyer-paid shipping attributable to seller | $6.00 | Matched order export |
| Marketplace and payment charges | $8.00 | Illustrative matched statement total |
| Materials and purchased components | $16.00 | SKU cost record |
| Labor | $8.00 | 24 minutes at $20 per hour |
| Packaging | $2.00 | Current component record |
| Shipping label and handling | $7.00 | Label receipt plus documented handling |
| Expected loss allowance | $3.00 | Dated SKU/category scenario |
Step 1: normalize the order revenue
Begin with the order and line-item grain. Confirm that $68 belongs to the product line and $6 is seller-attributable shipping rather than tax, a marketplace-remitted amount, or a repeated order-level field. If the order contains several items, allocate shared shipping or discounts using a documented method and prove that the line allocations sum back to the order. Preserve currency and signs.
The normalized revenue is $74. Do not replace it with the bank deposit. The deposit can include multiple orders, prior balances, fees, refunds, reserves, and timing. Do not use list price if a seller-funded coupon reduced proceeds. This example is explicitly a full-price case, so no coupon deduction is present.
Step 2: attach actual and private costs
Match the $8 platform-charge total to the reviewed order or use a clearly dated planning estimate if the statement is not yet available. Attach the $16 SKU material record. Convert labor consistently: 24 minutes divided by 60, multiplied by the $20 loaded hourly rate, equals $8. Add the $2 packaging record and the $7 label-plus-handling evidence.
Each number has a different update trigger. The platform charge changes when the fee or program evidence changes. Material changes with supplier or design. Labor changes with the workflow or loaded rate. Packaging changes with components. Shipping changes with carrier, zone, weight, dimensions, insurance, or adjustment. Store those triggers instead of treating the example as a permanent product template.
| Calculation | Arithmetic | Running amount |
|---|---|---|
| Normalized revenue | $68 + $6 | $74 |
| After platform charges | $74 − $8 | $66 |
| After materials | $66 − $16 | $50 |
| After labor | $50 − $8 | $42 |
| After packaging | $42 − $2 | $40 |
| After shipping and handling | $40 − $7 | $33 |
| After expected loss | $33 − $3 | $30 contribution |
Step 3: calculate and label the result
The example's estimated contribution is $30: $74 revenue minus $8 platform charges, $16 materials, $8 labor, $2 packaging, $7 shipping and handling, and $3 expected loss. Its contribution rate is approximately 40.5% of normalized revenue. That rate describes only the cost layers included here. It is not an accounting net-profit margin.
The seller's operating target is $16 per order after those variable and risk layers. The example therefore has $14 of target headroom. That headroom can absorb an adverse fee, shipping, labor, return, or ad case, but it is not permission to spend $14 automatically. The seller should decide which uncertainty actually needs a stress test.
How does Offsite Ads exposure change the example?
For a planning stress test, apply the shop's current, verified Offsite Ads rule and fee base. If the illustrative order were subject to a 12% charge on $74, the scenario charge would be $8.88 and contribution would fall from $30 to $21.12. At an illustrative 15% charge, the scenario charge would be $11.10 and contribution would fall to $18.90.
Both illustrative scenarios remain above the $16 target, but the higher case leaves only $2.90 of headroom. That difference can be consumed by a carrier adjustment, extra personalization time, or a weaker recovery. Etsy's official help currently describes participation, fee-rate, attribution, and order-cap rules. Verify the seller's own status and current source before applying either scenario.
| Scenario | Additional illustrative charge | Estimated contribution | Target comparison |
|---|---|---|---|
| No attributed ad | $0.00 | $30.00 | $14.00 above target |
| 12% planning case | $8.88 | $21.12 | $5.12 above target |
| 15% planning case | $11.10 | $18.90 | $2.90 above target |
| 15% plus $4 carrier adjustment | $15.10 total change | $14.90 | $1.10 below target |
What decision follows from the worked example?
Keep the full-price SKU available because the base evidence clears the target. Do not lower the price merely because the base case has headroom. First confirm whether the product regularly receives Offsite Ads orders, whether shipping adjustments occur, and whether the 24-minute labor time is stable. If the conservative case falls below target, the next action should address the variable that causes the failure.
Possible actions include measuring personalization time again, updating the heaviest variation's shipping record, revising packaging, setting a higher price for an expensive option, limiting a coupon, or increasing the target for a high-return SKU. Record one action, owner, date, and rollback criterion. A worked example becomes operational only when it changes a controlled decision.
- Keep the source row, SKU cost record, fee evidence, and label evidence connected.
- Do not apply the $30 result to a different variation with different cost or weight.
- Do not combine a price, photo, ad, shipping, and coupon change in one test.
- Recheck the order after the statement, refund window, or carrier adjustment matures.
- Use the result to select a bounded action, not to claim accounting profit.
Full-price order example questions
Why include labor if the owner does the work? The time still limits capacity and has an opportunity cost. Use a documented loaded rate appropriate to the operating decision, and disclose that it is an internal assumption rather than a marketplace charge.
Why include expected loss before a return happens? Pricing and promotion decisions concern a population of orders. A dated allowance can reserve for unrecovered return or replacement cost. For retrospective order truth, preserve the actual outcome separately.
Should the $6 shipping charge be treated as profit? No. It is part of seller-attributable revenue in this example, while the $7 label and handling cost is subtracted. The shipping line loses $1 before its effect on any fee base.
Can the $8 platform charge be reused next month? Only if the matched evidence and program rules still support it. A planning model should separate each category and effective date.
Does clearing the $16 target mean the product should be advertised? Not by itself. Demand, conversion, attribution, cash timing, capacity, and downside risk still matter. The result only shows how much contribution the modeled order retains.
Privacy and evidence limits for full-price worked example
A contribution review does not need buyer names, delivery addresses, private messages, payment credentials, marketplace passwords, or a public copy of the seller's order history. It normally needs a redacted transaction key, date, SKU, quantity, seller-attributable revenue, relevant fee evidence, and private cost assumptions. Keep the untouched export in controlled storage and work from a local copy.
Seller Profit Guard is designed to read supported CSV files in the browser. A report can still contain commercially sensitive prices, SKU economics, labor rates, and supplier costs, so treat exports as private operating records. For support, share column names and a made-up example row. If an account-specific reserve, fee, refund, or suspension determines the answer, use the authenticated Etsy record rather than a generic assumption.
- Do not upload buyer identity or address fields for a margin calculation.
- Do not paste raw order rows into public communities, support email, or AI prompts.
- Use public dummy data to reproduce mapping and formula issues.
- Store cost libraries, reports, and change logs as confidential business records.
- Escalate tax, accounting, legal, and account-policy questions to the appropriate official or professional source.
How to apply this full-price worked example in Seller Profit Guard
Open the Etsy CSV profit calculator with a recent, representative order-item export or the public dummy sample. Confirm the revenue, quantity, SKU, shipping, discount, fee, and transaction mappings before importing private cost assumptions. Review missing-cost and mapping warnings first; a precise result built on an empty or misidentified field is not decision-ready.
Run the relevant base and stress scenarios, export the private review list, and record the source period, assumptions, result, decision, owner, and next review date. The useful output is not a perfect score. It is a short, evidence-backed queue of listings or SKUs that need a price, cost, shipping, promotion, or data-quality action.
- Preserve the source export and record its shop, currency, period, and file type.
- Confirm every mapped field and keep missing values unknown rather than zero.
- Attach the correct SKU-level material, labor, packaging, fulfillment, and target assumptions.
- Run a base case plus the page-specific stress or comparison case.
- Inspect the rows that fail the target or evidence-quality gate.
- Record one reversible action and a dated follow-up instead of changing the whole shop.
Related resources
- Open the Etsy CSV profit calculator: Run a browser-local order and SKU contribution review with editable assumptions.
- Build an Etsy SKU cost library: Store material, labor, packaging, shipping, and target assumptions for repeat reviews.
- Reconcile Etsy Payment Account activity: Match order and statement evidence before interpreting cash movement as product economics.
- Review CSV data privacy: Keep raw buyer and order data out of public support and community posts.
- Read the editorial policy: See how sources, corrections, AI assistance, and update dates are handled.
Sources and further reading
- Seller Profit Guard calculation methodology: Calculation scope, editable assumptions, contribution terminology, privacy boundaries, and result limits.
- Etsy Help: Fees and Taxes for Selling: Official fee categories, fee bases, country-dependent processing charges, advertising fees, and Payment Account treatment.
- Etsy Help: Download Sold Transaction Spreadsheets: Official order items, orders, Etsy Payments sales, and Etsy Payments deposits CSV workflow.
- Etsy Help: Manage Your Payment Account: Official sales, fees, refunds, seller services, shipping, monthly statements, balance, and deposit context.
- Etsy Help: How Offsite Ads Work: Official attribution, participation, fee-rate, and order-cap context; verify current shop-specific status.
- Etsy Help: Issue a Full or Partial Refund: Official refund workflow and Payment Account impact reference.
Related Seller Profit Guard tools
- Open the Etsy CSV profit calculator: Run a browser-local order and SKU contribution review with editable assumptions.
- Build an Etsy SKU cost library: Store material, labor, packaging, shipping, and target assumptions for repeat reviews.
- Reconcile Etsy Payment Account activity: Match order and statement evidence before interpreting cash movement as product economics.
- Review CSV data privacy: Keep raw buyer and order data out of public support and community posts.
- Read the editorial policy: See how sources, corrections, AI assistance, and update dates are handled.
- Etsy Profit Formula: Inputs Small Sellers Must Track: Continue the Seller Profit Guard evidence and decision workflow.
- Etsy Discount Profit: Test Coupons and Free Shipping: Continue the Seller Profit Guard evidence and decision workflow.
- Etsy Profit Calculator Mistakes: 12 Cost Traps: Continue the Seller Profit Guard evidence and decision workflow.
- Etsy Profit Data Sources: Build a Defensible Record: Continue the Seller Profit Guard evidence and decision workflow.
- Etsy Profit Thresholds: Break-Even Is Not Enough: Continue the Seller Profit Guard evidence and decision workflow.
Next step: Open the Etsy CSV profit calculator.
This is operational planning help, not tax, accounting, legal, financial, or platform-policy advice. Review the Terms and disclaimer, and verify current platform rules and fee assumptions before changing prices.