Seller Profit Guard

A complete Etsy Offsite Ads 15 percent worked example

Last updated: 2026-07-30

Written and reviewed by Seller Profit Guard Editorial Team.

For a $40 item plus $5 shipping, the 15% Offsite Ads fee is $6.75. If other reconciled Etsy fees are $4.725 and product, labor, packaging, and label costs total $18.50, the order retains $15.025 contribution, displayed as $15.03. That equals a 33.4% contribution margin before overhead and income tax.

15 percent worked fixture flow from attribution and fee base through rate, cap, costs, contribution, evidence, and recovery
This original flow explains the full-precision attributed-order ledger without buyer, order, payment, bank, contact, or credential data.

15 percent worked fixture: scope and decision

The fixture uses a USD model, verified attribution, the 15 percent rate, a $100 USD cap, no gift wrap, no applicable tax in the fee base, no refund, and a fully reconciled $4.725 subtotal for non-ad Etsy fees.

Order revenue and fee base are both $45 in this narrow example. The uncapped Offsite Ads fee is $45 multiplied by 0.15, which equals $6.75. The per-order cap does not change that result.

Build the full-precision attributed-order ledger before acting

Direct cost is $12 for product and labor, $1.50 for packaging, and $5 for the carrier label. Together with $4.725 of other Etsy fees, non-ad deductions equal $23.225.

Full-precision contribution is $45 minus $6.75 minus $23.225, or $15.025. The interface displays $15.03 while retaining full precision for comparison. The $12 target is cleared by $3.025.

Step 1: freeze the scenario boundary

Record USD model currency, attributed dashboard state, 15 percent effective rate, $100 USD cap, order date, click window, fee-base tax treatment, refund state, source date, and reviewer.

Recalculate “Step 1: freeze the scenario boundary” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 1: freeze the scenario boundary” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

Step 2: reconcile $45 of order revenue

Enter $40 of item revenue and $5 buyer-paid shipping. Do not net the $5 shipping label against the buyer charge before calculating the advertising fee.

Recalculate “Step 2: reconcile $45 of order revenue” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 2: reconcile $45 of order revenue” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

15 percent worked fixture step 2: reconcile $45 of order revenue diagram
This original diagram makes $15.03 displayed contribution visible and reviewable.

Step 3: calculate the uncapped ad fee

Multiply the $45 fee base by 15 percent. Preserve $6.75 as its own row with base, rate, source, currency, and attribution evidence.

Recalculate “Step 3: calculate the uncapped ad fee” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 3: calculate the uncapped ad fee” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

Step 4: test the per-order cap

Compare $6.75 with the entered $100 USD cap. The uncapped fee is lower, so no cap is applied. Preserve the comparison even when it does not change the total.

Recalculate “Step 4: test the per-order cap” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 4: test the per-order cap” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

Step 5: import other Etsy fee rows

Use the fee-stack result of $4.725 only for this same documented order. Do not copy it to another bank country, currency, quantity, tax status, or refund state.

Recalculate “Step 5: import other Etsy fee rows” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 5: import other Etsy fee rows” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

15 percent worked fixture step 5: import other etsy fee rows diagram
This original diagram makes $15.03 displayed contribution visible and reviewable.

Step 6: subtract order-variable cost

Subtract product and direct labor, packaging, and shipping label after marketplace fees. Keep overhead, owner pay, and income tax outside this contribution fixture.

Recalculate “Step 6: subtract order-variable cost” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 6: subtract order-variable cost” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

Step 7: read target gap and margin

Contribution is $15.025, target gap is $3.025, and contribution margin is 33.388 percent before display rounding. These values describe entered assumptions only.

Recalculate “Step 7: read target gap and margin” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 7: read target gap and margin” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

Step 8: reconcile the actual statement

Match the modeled Offsite Ads row, other fees, refunds, credits, taxes, currency, and payout period to the Payment account before using the result for pricing.

Recalculate “Step 8: reconcile the actual statement” from the supported fixture rather than copying a displayed total. Preserve $45 revenue, $6.75 Offsite Ads fee, $4.725 other Etsy fees, $18.50 direct cost, and $15.025 contribution only for $40 item plus $5 shipping at 15 percent. The full-precision attributed-order ledger must reject a $45 order with no attributed advertising row as equivalent because its attribution row is materially different.

The evidence log for “Step 8: reconcile the actual statement” should show formula, internal amount, displayed amount, target gap, and responsible source. Re-run the same fixture after any change to rounding, fee base, rate, cap, or other-fee import. Compare an approved private statement sample only after matching order scope, currency, refund state, and reporting period.

15 percent worked fixture step 8: reconcile the actual statement diagram
This original diagram makes $15.03 displayed contribution visible and reviewable.

Verification, release, and statement feedback

Before changing price, shipping, promotion, participation assumptions, or calculator defaults, preserve the full-precision attributed-order ledger, official-source versions, account evidence pointer, current inputs, expected fixtures, tests, build, route state, and rollback identifier. Confirm the exact target environment and safe-stop on an unexpected account or production context.

After one bounded action, rerun $40 item plus $5 shipping at 15 percent, a $45 order with no attributed advertising row, the cap fixture, and a declared-conflict fixture. Inspect full-precision and displayed amounts, mobile results, canonical, sources, original visuals, internal links, and the approved private statement observation. Restore the prior packet if a critical result cannot support $15.03 displayed contribution.

Limits, privacy boundary, and next action

This guide and calculator use seller-entered summaries and synthetic fixtures. They do not retrieve Etsy data, authenticate attribution, choose a rate, convert the cap automatically, settle tax, reproduce every refund or payout, estimate incrementality, change advertising, or prove ranking, traffic, qualified intent, AdSense approval, income, or final profit.

Keep buyer names, emails, addresses, messages, order IDs, payment rows, bank details, tax identifiers, labels, tokens, OAuth material, credentials, and raw CSV outside the full-precision attributed-order ledger. Verify current Etsy sources and the seller's actual account, reconcile an approved privacy-safe sample, record closure or rollback, and obtain qualified accounting, tax, or legal advice when material.

Sources and further reading

Related Seller Profit Guard tools

Next step: Open the Etsy Offsite Ads Margin 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.