A reusable Etsy fee stack audit and change-log template
Last updated: 2026-07-30
Written and reviewed by Seller Profit Guard Editorial Team.
A complete audit records order grain, seller bank country, order type, listing and Payment currencies, item, shipping, gift wrap, quantity, each fee base, rate, fixed amount, cap, tax, product and fulfillment cost, contribution target, source and access date, clean and broken fixture, statement row, refund or credit, difference, reviewer, correction, rollback, and next review.
fee audit record: scope and decision
The audit lets another operator reproduce the result without private chat or guesswork. Store the input, base, formula, source, version, expected output, actual observation, approval, and correction separately.
Keep monetary fields atomic. Rate, fixed amount, percentage base, cap, source currency, account currency, statement amount, and display rounding should not be buried in one free-text note.
Build the reversible fee evidence sheet before changing price
Use synthetic examples publicly and aggregate private records operationally. Buyer identities, addresses, messages, order IDs, payment details, bank information, tax identifiers, emails, tokens, credentials, and raw CSV remain outside the artifact.
An empty conditional row is unresolved unless an accountable reviewer records why it is not applicable. Preserve rejected and rolled-back fixtures so later generator changes cannot weaken fee safety.
Section 1: order and account boundary
Record order alias, date, status, quantity, buyer market, seller bank country, domestic or international classification, listing currency, Payment account currency, and payout currency.
In the reversible fee evidence sheet, “Section 1: order and account boundary” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 1: order and account boundary”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 2: order-revenue inputs
Record item, shipping, gift wrap, seller-collected tax, refunds, discounts, credits, and which amount is included in each fee base.
In the reversible fee evidence sheet, “Section 2: order-revenue inputs” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 2: order-revenue inputs”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 3: fixed and percentage fees
Record listing, renewal, transaction, processing, fixed processing, Offsite Ads, cap, currency conversion, regulatory, VAT, and any other seller-service row.
In the reversible fee evidence sheet, “Section 3: fixed and percentage fees” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 3: fixed and percentage fees”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 4: operating costs
Record product, labor, packaging, label, insurance, fulfillment, return-loss assumption, other variable cost, source currency, exchange assumption, and effective date.
In the reversible fee evidence sheet, “Section 4: operating costs” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 4: operating costs”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 5: source and applicability
Record official URL, access date, account setting, statement label, location, order condition, tax status, attribution, source owner, reviewer, and conflict rule.
In the reversible fee evidence sheet, “Section 5: source and applicability” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 5: source and applicability”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 6: calculation fixtures
Record clean domestic, cross-currency, and deliberately broken cases with expected itemized rows, contribution, margin, target gap, decision, and test result.
In the reversible fee evidence sheet, “Section 6: calculation fixtures” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 6: calculation fixtures”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 7: statement reconciliation
Record actual rows, full-precision estimate, display amount, timing, refund, credit, reserve, payout, bank receipt, classified difference, correction, and unresolved balance.
In the reversible fee evidence sheet, “Section 7: statement reconciliation” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 7: statement reconciliation”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Section 8: release and review
Record narrow backup, changed files or assumptions, test evidence, approval, rollback value, release timestamp, public browser result, next official-source review, and next reconciliation sample.
In the reversible fee evidence sheet, “Section 8: release and review” needs a before value, base, formula, unit, currency, authority, expected fixture, reviewer, actual observation, classified difference, after value, and recovery closure. Record complete before-and-after fee packet and a checked box without source or amount with privacy-safe aliases so reproducible fee-model closure is reproducible.
Create atomic audit columns for “Section 8: release and review”: field, before value, base, rate, fixed amount, cap, currency, source, version, order condition, owner, reviewer, expected fixture, actual statement amount, difference class, correction, after value, rollback, closure, and next review. Enter complete before-and-after fee packet without private identifiers and preserve a checked box without source or amount as a rejected row.
Verification, release, and reconciliation controls
Before changing a public price, shipping charge, discount, ad assumption, or calculator default, preserve the reversible fee evidence sheet, source versions, current inputs, expected rows, tests, build, public route state, and rollback identifier. Confirm the exact target and safe-stop on an unexpected production or account context.
After one bounded change, rerun complete before-and-after fee packet and deliberately revisit a checked box without source or amount. Inspect every fee row, currency, full-precision subtotal, displayed rounding, contribution, target gap, source link, desktop and mobile result, and actual statement observation. Restore the prior packet when a critical result does not support reproducible fee-model closure.
Limits, privacy boundary, and next action
This guide and calculator use seller-entered summaries and synthetic fixtures. They do not retrieve Etsy account data, choose a bank-country rate, verify attribution, calculate tax, open statements, authenticate costs, predict returns, determine accounting profit, change prices or ads, or prove ranking, conversion, income, qualified intent, or AdSense approval.
Keep buyer identities, emails, addresses, messages, order IDs, payment rows, bank data, tax identifiers, labels, tokens, OAuth material, credentials, and raw CSV outside the reversible fee evidence sheet. Verify current official sources, reconcile an approved private sample, rerun complete and broken fixtures, move the itemized stack into SKU profit analysis, and record closure or rollback.
Sources and further reading
- Etsy Help: Fees and Taxes for Selling on Etsy: Current listing, transaction, payment, currency-conversion, regulatory, advertising, deposit, tax, and other fee boundaries.
- Etsy Help: Payment Processing Fees: Current bank-country percentage and fixed processing rates, order-type distinctions, fee base, VAT note, refunds, and deposit-fee table.
- Etsy Help: Currency Conversion Fees: Current 2.5% conversion rule when listing currency differs from Payment account currency and the statement source for applied rates.
- Etsy Help: Regulatory Operating Fee: Current seller-location rates and the item, shipping, gift-wrap, and personalization fee base.
- Etsy Help: Offsite Ads: Current 15% and 12% attributed-order rates, enrollment boundary, 365-day revenue test, and policy links.
- Etsy Help: Listing Multiple Quantities: Current listing, auto-renew sold, and multi-quantity mechanics plus fixed-fee conversion context.
- Etsy Help: VAT on Seller Fees: Current VAT scope and invoice context; actual treatment depends on seller location and registration.
- Etsy Help: Sales and Use Taxes on Seller Fees in Texas: Current Texas fee-type and taxable-base boundary; the actual combined state and local rate must come from the seller's invoice context.
- Etsy Help: Manage Your Payment Account: Current Payment account rows, monthly statement export, credits, refunds, Seller Services, shipping, reserve, and transfer context.
- Seller Profit Guard methodology: Local-first calculations, source hierarchy, privacy-safe fixtures, deterministic tests, bounded release, correction, and rollback.
Related Seller Profit Guard tools
- Open the Etsy Fee Stack Calculator: Model each editable order-level fee and contribution layer in the browser.
- Review current Etsy fee references: Check current reference rates and country-dependent boundaries before entering assumptions.
- Run the main Seller Profit Guard: Combine verified marketplace fees with SKU, labor, packaging, shipping, ads, discounts, and return loss.
- Reconcile an Etsy Payment account: Compare modeled fees with actual statement rows, credits, refunds, reserves, and deposits.
- Check Etsy Ads break-even: Use retained contribution to set a safer paid-click ceiling.
- Read the local-first methodology: Keep raw buyer, order, payment, and credential data outside public content and analytics.
- Etsy Fee Stack Formula and Input Contract: Continue the fee formula, worked example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Etsy Fees on a $45 Order: Worked Example: Continue the fee formula, worked example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Etsy Cross-Currency Fee Example: Continue the fee formula, worked example, source, threshold, comparison, routine, interpretation, or audit workflow.
- 12 Etsy Fee Calculation Mistakes: Continue the fee formula, worked example, source, threshold, comparison, routine, interpretation, or audit workflow.
- Reliable Sources for Every Etsy Fee Input: Continue the fee formula, worked example, source, threshold, comparison, routine, interpretation, or audit workflow.
Next step: Open the Etsy Fee Stack 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.