An Etsy Offsite Ads margin audit checklist and change log

Last updated: 2026-07-30

Written and reviewed by Seller Profit Guard Editorial Team.

Create one row per assumption with before value, source, effective date, currency, order condition, expected fixture, reviewer, actual Payment account observation, difference class, correction, after value, approval, rollback, and next review. Audit attribution, rate status, fee base, cap conversion, other Etsy fees, direct costs, returns, contribution target, and privacy boundary separately.

field-level Offsite Ads audit flow from attribution and fee base through rate, cap, costs, contribution, evidence, and recovery — This original flow explains the before-expected-actual-recovery template without buyer, order, payment, bank, contact, or credential data.

field-level Offsite Ads audit: scope and decision

An audit template makes every assumption accountable. It prevents a plausible total from hiding a wrong attribution state, rate, base, cap, currency, cost, refund, or target.

Use separate sections for rule evidence, private account evidence, order inputs, platform fee rows, direct costs, expected outputs, actual observations, differences, correction, approval, release, and rollback.

Build the before-expected-actual-recovery template before acting

The template stores privacy-safe aliases and aggregate values only. It points to approved private systems for statements and account evidence without copying buyer, order, bank, tax, contact, credential, or raw CSV data.

Closure requires a reproduced expected fixture and an actual observation or documented planning-only limitation. A checked box without evidence owner, date, and recovery state is not an audit.

Section 1: rule and rate record

Capture official URL, access date, applicable 15 or 12 percent state, threshold evidence label, attribution window, last-click boundary, fee-base rule, cap, currency, and reviewer.

In the before-expected-actual-recovery template, “Section 1: rule and rate record” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 1: rule and rate record” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

Section 2: order and attribution record

Capture privacy-safe alias, order date, attribution status, fee-base components, refund or credit state, model currency, statement period, and source owner.

In the before-expected-actual-recovery template, “Section 2: order and attribution record” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 2: order and attribution record” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

field-level Offsite Ads audit section 2: order and attribution record diagram — This original diagram makes an auditable calculation and recovery trail visible and reviewable.

Section 3: fee calculation record

Capture order revenue, fee base, percentage, uncapped fee, cap conversion, applied fee, other Etsy fee subtotal, and full-precision arithmetic.

In the before-expected-actual-recovery template, “Section 3: fee calculation record” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 3: fee calculation record” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

Section 4: cost record

Capture SKU cost version, direct labor, packaging, carrier label, fulfillment, insurance, other variable cost, expected return loss, currency, and effective date.

In the before-expected-actual-recovery template, “Section 4: cost record” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 4: cost record” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

Section 5: expected output

Capture contribution dollars, contribution margin, target, target gap, Ready-Revise-Stop-Block decision, supported fixtures, and broken fixture.

In the before-expected-actual-recovery template, “Section 5: expected output” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 5: expected output” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

field-level Offsite Ads audit section 5: expected output diagram — This original diagram makes an auditable calculation and recovery trail visible and reviewable.

Section 6: actual observation

Capture Payment account ad fee, other fee rows, refund, credit, tax, conversion, reserve, payout timing, and classified difference without private identifiers.

In the before-expected-actual-recovery template, “Section 6: actual observation” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 6: actual observation” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

Section 7: correction and approval

Capture accountable field, before and after values, reason, test evidence, reviewer, approval boundary, and whether a public or operating change is authorized.

In the before-expected-actual-recovery template, “Section 7: correction and approval” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 7: correction and approval” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

Section 8: rollback and next review

Capture prior packet, recovery command or identifier, restored result, closure owner, policy or variance trigger, and scheduled review date.

In the before-expected-actual-recovery template, “Section 8: rollback and next review” needs a before value, source, effective date, order condition, unit, currency, expected fixture, reviewer, actual observation, difference class, correction, after value, approval, rollback, closure, and next review. Record a synthetic $45 supported fixture and reject a rejected packet with unresolved attribution and refund rows until an auditable calculation and recovery trail is reproducible.

Audit “Section 8: rollback and next review” with an atomic row and a recovery test. Reproduce the expected result from source-linked inputs, record the actual observation, classify any difference, correct one owner-controlled field, rerun all fixtures, and prove the prior packet can be restored. Closure without recovery evidence remains incomplete.

field-level Offsite Ads audit section 8: rollback and next review diagram — This original diagram makes an auditable calculation and recovery trail visible and reviewable.

Verification, release, and statement feedback

Before changing price, shipping, promotion, participation assumptions, or calculator defaults, preserve the before-expected-actual-recovery template, 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 a synthetic $45 supported fixture, a rejected packet with unresolved attribution and refund rows, 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 an auditable calculation and recovery trail.

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 before-expected-actual-recovery template. 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

Etsy Help: How Offsite Ads Work: Current 30-day attribution, 15% and 12% fee rates, $100 USD per-order cap, enrollment, threshold, dashboard, and last-click boundary.
Etsy Fees and Payments Policy: Controlling fee-base, attributed-order, 365-day sales test, tax, currency, cap, opt-out, and lifetime-participation policy language.
Etsy Advertising and Marketing Policy: Current responsibilities and program terms for Etsy Ads and Offsite Ads.
Etsy Help: Fees and Taxes for Selling: Current advertising-fee summary and the surrounding listing, transaction, processing, conversion, regulatory, and seller-fee tax boundaries.
Etsy Help: How to Use Etsy Stats: Current traffic-source and Offsite Ads attribution observations available to a seller.
Etsy Help: Manage Your Payment Account: Payment account, monthly statement, refund, credit, balance, reserve, shipping, and payout reconciliation context.
Seller Profit Guard methodology: Local-first calculations, evidence hierarchy, privacy-safe fixtures, deterministic tests, bounded release, correction, and rollback.

Related Seller Profit Guard tools

Open the Etsy Offsite Ads Margin Calculator: Model one attributed order under the current 15% or 12% rate and cap.
Build the complete Etsy fee stack: Itemize every other marketplace fee before isolating the advertising consequence.
Run the main Seller Profit Guard: Carry the reconciled ad fee into SKU-level cost, shipping, return, and target-profit analysis.
Reconcile the Etsy Payment account: Compare modeled attribution and fees with actual statement rows, refunds, credits, and payouts.
Read the Offsite Ads profit guide: Review the existing operating workflow for attributed orders and retained contribution.
Read the local-first methodology: Keep buyer, order, payment, bank, contact, and credential data outside public pages and analytics.
Etsy Offsite Ads Margin Formula and Inputs: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
Etsy Offsite Ads 15% Fee: Worked Example: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
Etsy Offsite Ads 12% Margin Scenario: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
12 Etsy Offsite Ads Margin Mistakes: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.
Reliable Etsy Offsite Ads Margin Data: Continue the formula, example, source, threshold, comparison, routine, interpretation, or audit workflow.

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.