Skip to main content
Skip to content
Back to Ecommerce Accounting Hub

Etsy Seller Accounting Guide

Everything you need to master Etsy bookkeeping: multi-layered fee breakdowns, Shop Manager exports, Star Seller finances, and free QuickBooks import.

6.5% + $0.20 listing|3% + $0.25 processing|Free QB Import

Etsy Fee Structure Breakdown

Etsy has one of the most complex fee structures of any marketplace. Understanding each layer is critical for accurate profit calculations.

$0.20

Listing Fee

Charged per listing, per quantity. Each listing costs $0.20 upfront and auto-renews every 4 months ($0.20 again). For multi-quantity listings, a new $0.20 fee is charged each time a unit sells. A listing with 10 units incurs $0.20 x 10 = $2.00 in listing fees if all units sell.

6.5%

Transaction Fee

Etsy's marketplace commission, applied to the total sale amount including the item price and shipping cost charged to the buyer. A $50 item with $5 shipping generates a $3.58 transaction fee (6.5% of $55). This is Etsy's largest single fee.

3% + $0.25

Payment Processing

Etsy Payments processing fee for credit card, debit card, Apple Pay, Google Pay, and PayPal transactions through Etsy. Applied to the total order amount. US rate is 3% + $0.25; international rates vary by country (typically 4% + local currency equivalent).

12–15%

Offsite Ads Fee

Charged on sales attributed to Etsy's off-platform advertising on Google, Facebook, Instagram, and Pinterest. Shops earning $10,000+/year pay 12% and cannot opt out. Shops under $10,000 pay 15% but can opt out. Only charged when an ad click leads to a sale within 30 days.

Variable CPC

Etsy Ads (On-Platform)

Optional pay-per-click advertising within Etsy search results. You set a daily budget ($1–$25+/day) and Etsy charges per click. CPC varies by category and competition. Track Etsy Ads spend separately from offsite ads fees — they are different programs with different ROI profiles.

0.5%

Regulatory Operating Fee

Applied to the order total in certain jurisdictions where Etsy faces additional regulatory costs. Currently active in several countries and some US states. This fee appears as a separate line item in your Etsy Payments account.

Total Fee Example

A $50 item with $5 shipping costs approximately: $0.20 listing + $3.58 transaction (6.5%) + $1.90 processing (3% + $0.25) = $5.68 total (10.3% effective rate). Add 12–15% offsite ads if the sale came from an Etsy ad.

How to Export Etsy Transactions

Etsy provides transaction data through Shop Manager. Here are the three main export methods for your accounting needs.

1

Finances CSV Download

Best for: Complete transaction-level detail with fee breakdowns.

  1. Log in to Etsy Shop Manager at etsy.com/your/shops/me
  2. Navigate to Finances > Payment account
  3. Set your desired month using the date selector
  4. Click Download CSV at the top of the page
  5. The CSV includes every transaction, fee, deposit, and adjustment

This export includes: date, type, title, info, currency, amount, fees and taxes, net amount, and payout/deposit details.

2

Monthly Statements

Best for: Month-end reconciliation and audit documentation.

  1. Go to Finances > Payment account
  2. Scroll to Monthly statements at the bottom
  3. Click the desired month to view the statement
  4. Download as PDF for your records

Monthly statements show: sales, fees, refunds, deposits, adjustments, opening balance, and closing balance — ideal for month-end bank reconciliation.

3

Orders CSV Export

Best for: Order-level analysis with buyer and product details.

  1. In Shop Manager, go to Orders & Shipping
  2. Use the filter to set your date range
  3. Click Download CSV
  4. This gives you order-level data with buyer names, items, and quantities

The orders export includes: order number, buyer, items, quantity, price, shipping, transaction ID, and ship date. Combine with the Finances CSV for complete financial records.

Common Etsy Accounting Challenges

Etsy's multi-layered fee structure and unique marketplace features create specific bookkeeping challenges. Here are the five most common.

1. Star Seller Metrics and Financial Impact

Pursuing Star Seller status affects your bottom line in ways that are not immediately obvious. Faster shipping means higher shipping costs. Generous return policies to maintain review scores mean more refunds. The question is whether the visibility boost justifies the additional costs.

Track these metrics:

  • Average shipping cost per order (before and after pursuing Star Seller)
  • Refund rate and total refund value per month
  • Revenue change after achieving/losing Star Seller badge
  • Net profit margin with and without Star Seller-related costs

2. Digital vs Physical Product Accounting

Many Etsy sellers offer both digital downloads and physical products. These have fundamentally different cost structures: digital products have near-zero marginal cost, while physical products involve materials, labor, packaging, and shipping.

Best practice:

  • Create separate revenue accounts or classes for digital and physical sales
  • Track COGS (Cost of Goods Sold) only for physical products
  • Digital products may be sales tax exempt in some states
  • Calculate profit margin for each category independently

3. Etsy Ads and Offsite Ads Cost Tracking

Etsy has two separate advertising programs that are frequently confused: Etsy Ads (on-platform, optional, pay-per-click) and Offsite Ads (off-platform, mandatory for high-volume sellers, pay-per-sale). They must be tracked separately for accurate ROI analysis.

Accounting setup:

  • Create an "Etsy Ads" expense account for on-platform CPC advertising
  • Create an "Etsy Offsite Ads" expense account for off-platform commissions
  • Calculate ROAS (Return on Ad Spend) for each program separately
  • Offsite ads appear in your Finances CSV; Etsy Ads appear in a separate billing section

4. Fee Pattern Recognition and Forecasting

With 4–6 different fee types per transaction, Etsy sellers often underestimate their true cost of sale. The effective fee rate varies significantly based on item price, shipping charges, whether offsite ads were involved, and international vs domestic sales.

Key patterns:

  • Low-price items (<$10) have effective rates of 15–20% due to flat fees
  • Free shipping items have lower transaction fees (6.5% of price only, not shipping)
  • Offsite ad sales add 12–15% on top of all other fees
  • Monitor your monthly effective fee rate to set accurate prices

5. Deposit Schedule and Reconciliation

Etsy deposits funds to your bank on a rolling schedule (typically daily or weekly, depending on your account settings). Each deposit bundles multiple orders and fee deductions, making it difficult to match bank deposits to individual sales.

Solution:

Reconcile at the Etsy Finances level, not the bank deposit level. Import individual Etsy transactions into a dedicated "Etsy Payments" clearing account in QuickBooks. Match each Etsy deposit to the corresponding bank deposit as an internal transfer.

Complete Etsy Accounting Workflow

Follow these six steps every week (or month) to keep your Etsy shop books clean and audit-ready.

1

Download Finances CSV from Shop Manager

Log in to Etsy Shop Manager and navigate to Finances > Payment account. Select the month you want to reconcile and click "Download CSV". This file contains every sale, fee, refund, deposit, and adjustment for the period.

2

Upload to PrimeConnect Etsy Converter

Open the Etsy to QuickBooks converter and upload your Finances CSV file. The tool automatically recognizes Etsy's CSV format, splits out each fee type (listing, transaction, processing, offsite ads), and maps everything to QuickBooks-compatible categories.

3

Review Fee Breakdown and Mapping

Preview the converted transactions in the tool's preview table. Verify that listing fees, transaction fees, processing fees, and offsite ads fees are correctly separated. Customize the QuickBooks account names if you use non-standard account names.

4

Download in Your Preferred Format

Choose your output format: CSV for QuickBooks Online manual import, IIF for QuickBooks Desktop with full double-entry support and per-fee-type line items, or QBO for Web Connect bank feed import. All formats include fee separation.

5

Import into QuickBooks

Import the converted file into your Etsy clearing account in QuickBooks. For QBO files: File > Utilities > Import > Web Connect Files. For IIF: File > Utilities > Import > IIF Files. For CSV: Banking > Upload Transactions.

6

Match Deposits and Reconcile

Match each Etsy Payments deposit to the corresponding bank deposit. The deposit amount equals the sum of sales minus all fees, refunds, and adjustments for that deposit batch. Your Etsy clearing account balance in QuickBooks should match your Etsy Payments available balance at all times.

Importing Etsy Data into QuickBooks

Detailed instructions for every QuickBooks version and import method.

QuickBooks Online

  • CSV:Banking > Upload Transactions > select your Etsy account > upload file > map columns
  • QBO:Banking > Upload Transactions > drag QBO file to upload area
  • Tip:Create a dedicated "Etsy Payments" bank account in QBO. Etsy fees will appear as negative amounts for easy expense categorization.

QuickBooks Desktop

  • IIF:File > Utilities > Import > IIF Files > select file > confirm import
  • QBO:File > Utilities > Import > Web Connect Files > select Etsy account
  • Tip:IIF format preserves all Etsy fee types as separate split lines in each journal entry — ideal for detailed cost analysis

QuickBooks Self-Employed

  • CSV:Transactions > Import > upload CSV with date, description, and amount columns
  • Note:QBSE does not support IIF or QBO — use CSV format only
  • Tip:Tag Etsy sales as "Business" and Etsy fees as "Business — Platform Fees" for accurate Schedule C reporting

Etsy Tax and Compliance Considerations

Key tax obligations and reporting requirements for Etsy sellers.

1099-K Reporting

Etsy issues Form 1099-K through Etsy Payments when you exceed the IRS threshold. The form reports gross sales before any Etsy fees are deducted. Your QuickBooks gross revenue must reconcile with this number.

Find your 1099-K in Shop Manager under Finances > Legal & tax info. If your gross does not match, check for refunds, cancellations, and sales tax collected (which Etsy includes in the 1099-K gross).

Sales Tax (Marketplace Facilitator)

Etsy collects and remits sales tax in all US states that have marketplace facilitator laws. This means Etsy handles sales tax compliance for most domestic transactions. The tax collected appears in your exports as a separate line item.

Record marketplace-collected sales tax as a pass-through, not revenue. Since Etsy remits it, you do not need to file separately for marketplace-facilitated sales (but you do for direct sales outside Etsy).

Deductible Etsy Expenses

All Etsy fees are fully deductible: listing fees ($0.20), transaction fees (6.5%), payment processing (3% + $0.25), offsite ads (12–15%), Etsy Ads CPC, Etsy Plus ($10/month), and Pattern ($15/month). Additionally, deduct materials, shipping supplies, packaging, postage, home office space, and equipment used for production.

Hobby vs Business Classification

The IRS distinguishes between a hobby and a business. If Etsy is your business, you can deduct all expenses against income. As a hobby, you report income but cannot deduct expenses beyond income. The IRS looks at profit motive, expertise, time invested, and history of income. Keep records that demonstrate business intent.

Etsy Accounting Best Practices

Follow these seven practices to maintain clean, audit-ready books for your Etsy shop.

1

Create an Etsy Clearing Account

Set up a dedicated "Etsy Payments" bank account in QuickBooks. Import all Etsy transactions here. When Etsy deposits arrive at your bank, record transfers between accounts. This keeps individual transactions trackable and reconciliation clean.

2

Track Every Fee Type Separately

Create separate expense sub-accounts for: Listing Fees, Transaction Fees, Payment Processing Fees, Offsite Ads Fees, and Etsy Ads. This granularity lets you calculate your true cost per sale and identify which fees are growing fastest.

3

Separate Digital and Physical Revenue

Use different revenue accounts or classes in QuickBooks for digital downloads versus physical products. Digital products have ~90%+ margins while physical products typically have 30–60% margins. Blending them hides your true profitability.

4

Track COGS for Physical Products

For physical products, track Cost of Goods Sold including materials, supplies, packaging, and labor. This gives you accurate gross profit margins and helps you price products correctly to maintain profitability after Etsy's multi-layered fees.

5

Monitor Effective Fee Rate Monthly

Calculate your total fees as a percentage of gross sales each month. A healthy Etsy shop typically sees 10–13% effective rates without offsite ads, or 15–20% with them. Spikes indicate pricing issues, increased offsite ad attribution, or a shift toward low-price items.

6

Record Shipping Costs as COGS

Shipping costs are a direct cost of fulfilling orders. Record postage, packaging materials, and shipping supplies as COGS sub-accounts. Compare shipping revenue charged to buyers against actual shipping costs to ensure you are not losing money on shipping.

7

Archive Monthly Exports and Statements

Download both the Finances CSV and the monthly PDF statement at the end of every month. The PDF is your audit-ready document; the CSV is your data backup for re-import if needed. Also save the Orders CSV for item-level detail. Store in a clear folder structure: Etsy/2026/02-February-Finances.csv.

Related Tools

Free tools to streamline your Etsy accounting workflow.

Etsy to QuickBooks Converter

Convert Etsy Shop Manager CSV exports to QuickBooks CSV, IIF, or QBO format with listing fee breakdown.

Open tool

Multi-Channel Merge

Combine Etsy exports with other platforms into a single QuickBooks file.

Open tool

Ecommerce Analytics

Compare fees and revenue across Etsy and 10 other platforms.

Open tool

CSV to IIF Converter

Convert any CSV file to QuickBooks Desktop IIF format.

Open tool

Import Troubleshooter

Diagnose and fix QuickBooks import errors automatically.

Open tool

Related Platform Guides

Selling on more than Etsy? These guides cover accounting for other marketplaces popular with handmade and vintage sellers.

Shopify Accounting Guide

Shopify Payments fees, payout reconciliation, multi-currency handling, and QuickBooks import workflows for DTC stores.

Read guide

Amazon Accounting Guide

Settlement reports, FBA fees, multi-marketplace bookkeeping, and how to import Amazon transactions into QuickBooks.

Read guide

eBay Accounting Guide

Managed payments accounting, Seller Hub exports, 13+ fee types, and how to reconcile eBay payouts in QuickBooks.

Read guide

Frequently Asked Questions

Common questions about Etsy seller accounting and QuickBooks import.

How do I export my Etsy transactions for accounting?

In Etsy Shop Manager, go to Finances > Payment account. Click "Monthly Statements" for a monthly summary or "Download CSV" on the Finances overview for detailed transaction data. For the most comprehensive export, use Finances > Legal & tax info > Download CSV which includes all fee breakdowns.

What fees does Etsy charge sellers?

Etsy charges four main fees: a $0.20 listing fee per item (renewed every 4 months or on sale), a 6.5% transaction fee on the sale price including shipping, a payment processing fee of 3% + $0.25 per transaction, and offsite advertising fees of 12-15% on sales attributed to Etsy's off-platform ads. Additional costs include Etsy Ads (optional, pay-per-click), Pattern website ($15/month), and Etsy Plus ($10/month).

How should I track Etsy listing fees in QuickBooks?

Create a dedicated "Etsy Listing Fees" expense sub-account under your Advertising or Platform Fees parent account. Listing fees are charged at $0.20 per listing, renewed every 4 months automatically, and charged again on each sale for multi-quantity listings. Track them separately from transaction fees for clear cost analysis.

What is the difference between Etsy transaction fees and payment processing fees?

The 6.5% transaction fee is Etsy's marketplace commission on the total sale amount (item price + shipping). The 3% + $0.25 payment processing fee is the credit card processing charge through Etsy Payments. Together, they total approximately 9.5% + $0.25 per sale before listing and advertising fees.

How do I account for Etsy offsite advertising fees?

Offsite ads fees (12% for shops earning $10,000+/year, 15% for shops under $10,000) are charged only on sales attributed to Etsy's off-platform advertising (Google, Facebook, Instagram, Pinterest). Record these as a marketing expense. You can opt out of offsite ads if your shop made less than $10,000 in the prior year.

How does Etsy Star Seller affect my accounting?

Star Seller status itself does not directly affect fees or financial accounting. However, maintaining Star Seller metrics (95%+ on-time shipping, 95%+ 5-star reviews, $300+ in 3 months) impacts your business decisions around shipping speed and refund policies. Track refund rates and shipping costs to ensure Star Seller pursuit remains profitable.

How do I handle Etsy sales tax in QuickBooks?

Etsy collects and remits sales tax automatically in states where marketplace facilitator laws apply (currently all US states with sales tax). The tax amount appears in your Etsy CSV export. Record collected sales tax as a pass-through — it's not your revenue. Map it to a "Sales Tax Collected" liability account.

Should I track digital and physical product sales separately?

Yes. Digital products have different cost structures (no shipping, no materials) and tax treatment (some states exempt digital goods from sales tax). Create separate revenue accounts or classes in QuickBooks for "Digital Products" and "Physical Products" to get accurate profitability reporting for each product type.

Ready to Import Etsy into QuickBooks?

Stop manually entering Etsy transactions and fees. Upload your Shop Manager CSV, get a QuickBooks-ready file in seconds. 100% free, 100% browser-based.

Convert Etsy to QuickBooks — Free

← Back to Ecommerce Accounting Hub