Etsy Seller Hub

1. Set Up Separate Business Finances

Critical for tax compliance: Never mix personal and business finances. Open a dedicated business bank account for your Etsy shop.

• Business checking account (deposit Etsy payouts here)
• Business credit card (only for shop expenses)
• Keep all receipts and invoices organized

2. Choose Your Accounting Method

Cash Basis (Recommended for most Etsy sellers): Record income when money arrives, expenses when paid. Simpler for small shops.

Accrual Basis: Record sales when they occur, expenses when incurred. More accurate but requires more tracking.

3. Create Your Chart of Accounts

Organize all transactions into these categories:

• Revenue: Etsy Sales, Shipping Revenue
• Expenses: COGS, Etsy Fees, Shipping Costs, Materials, Packaging, Supplies
• Assets: Inventory, Equipment, Cash
• Liabilities: Sales Tax Payable, Self-Employment Tax Payable

4. Track Every Transaction

Record what Etsy Payments shows you:

1. Sale date and amount
2. Etsy transaction fee (6.5% for most categories)
3. Payment processing fee (4% + $0.20)
4. Shipping label fees (if used)
5. Final amount deposited to bank

Complete Etsy Fee Breakdown (2025)

Every sale on Etsy incurs multiple fees that reduce your profit. Understanding each is critical.

1. Listing Fee

• Cost: $0.20 per listing
• Duration: Valid for 4 months
• Total annual: ~$15 per item (if renewed 3x/year)
• Tip: Renew only for listings that sell; delete underperformers

2. Transaction Fee

• Cost: 6.5% of sale price (most categories)
• Example: $20 item = $1.30 fee
• Note: Some categories (Vintage, Craft Supplies) may be lower or higher

3. Payment Processing Fee

• Cost: 4% + $0.20 per transaction
• Example: $20 sale = (20 × 0.04) + $0.20 = $1.00
• Includes: Credit card processing, PayPal handling

4. Shipping Label Fee (Optional)

• Cost: $0.08 per label (if purchased through Etsy)
• Alternative: Print your own labels for free via USPS/UPS

Example: Real Etsy Sale

Handmade Necklace:

• Sale Price: $30.00
• Listing Fee (amortized): -$0.10
• Transaction Fee (6.5%): -$1.95
• Payment Processing (4% + $0.20): -$1.40
• Shipping Label Fee: -$0.08
• Net to You: $24.47 (before COGS & shipping cost)

Your COGS: If materials cost $5 and shipping $2.53 = $7.53

Your Profit: $24.47 - $7.53 = $16.94 (56% margin)

Sales Tax Obligations

Important: Etsy now collects and remits sales tax on behalf of most sellers in US states. However, you must understand what this means:

• Etsy collects tax from buyers automatically in most states
• The collected tax is shown in your Etsy Payments account
• This amount is deducted from your payout (you don't keep it)
• Etsy files and remits to states monthly

Your responsibility: Keep records of all sales and taxes collected for your records and potential audits.

Self-Employment Tax

As an Etsy seller, you owe self-employment tax on your net profit:

• Rate: 15.3% (12.4% Social Security + 2.9% Medicare)
• Threshold: Owed when net profit exceeds $400/year
• Example: $10,000 profit = $1,530 self-employment tax (in addition to income tax)

Quarterly Estimated Taxes

If you expect to owe $1,000+ in taxes annually, you must file quarterly estimated taxes:

1. Due Dates: April 15, June 15, September 15, January 15
2. Use Form 1040-ES to calculate quarterly payments
3. File with: IRS or state tax authority
4. Underpayment Penalty: 0.5% per month if underpaid

Record Keeping for Taxes

Keep organized records for IRS audit protection:

• All Etsy monthly statements
• Bank deposit confirmations
• Receipts for materials/supplies
• Shipping receipts
• Advertising expenses (Etsy ads, outside promotion)
• Home office deduction documentation (if claiming)
• Retention Period: Minimum 3 years (7 if significant unreported income)

Digital Products & Tax

If you sell digital items (printables, designs, etc.), sales tax rules are complex:

• Most digital products do NOT require sales tax (software, eBooks)
• Some states tax digital goods—varies by state
• Etsy may or may not collect—varies by location
• Action: Check your state's specific digital product tax rules

Best Accounting Software for Etsy Sellers

1. QuickBooks Online (Most Popular)

• Cost: $30-200/month
• Best For: Sellers with annual revenue $50K-$500K
• Integration: Etsy App Store apps or Link My Books
• Pros: Industry standard, full features, tax-ready reports
• Cons: Learning curve, expensive for small sellers

2. Xero (International-Friendly)

• Cost: $13-70/month
• Best For: International sellers, EU-based shops
• Integration: Direct connection or Link My Books
• Pros: Clean interface, excellent reconciliation, GST/VAT handling
• Cons: Fewer US-specific tax features than QB

3. Link My Books (Best for Etsy)

• Cost: $15-50/month
• Purpose: Auto-syncs Etsy sales to QuickBooks or Xero
• How It Works: Creates daily/weekly invoice summaries with all fees itemized
• Benefit: Saves 5-10 hours/month vs manual entry + eliminates errors
• Recommendation: Use QB Online + Link My Books for best results

Setup Process (Link My Books + QuickBooks)

1. Sign up for QuickBooks Online
2. Install Link My Books from Etsy App Store
3. Authorize Link My Books to access your Etsy shop
4. Link to your QuickBooks account
5. Map Etsy fee categories to QB accounts
6. Enable automatic daily/weekly imports
7. Review & approve suggested transactions in QB

Manual Etsy Reconciliation (No Software)

If using spreadsheets, here's the process:

1. Download Etsy Payments summary (Settings → Payments → Payout history)
2. Create spreadsheet with columns: Date | Sale Amount | Fees | Net | Bank Deposit
3. Sum daily transactions to match bank deposit
4. Record the net amount as revenue, itemize fees separately
5. Track COGS by product sold
6. Do this weekly—don't wait until month-end

Why COGS Tracking Matters

COGS = Cost of Goods Sold = all materials used to make a product. Accurate tracking is essential because:

• Shows true profitability per item
• Identifies underpriced products
• Required for tax deductions
• Reveals which items to focus on vs drop

What to Include in COGS

• Materials: Fabric, wood, beads, paint, etc.
• Packaging: Boxes, tissue, labels, ribbons
• Shipping supplies: Tape, bubble wrap, mailers
• Tools (amortized): If tool cost $100, divide by units made
• Labor (if applicable): Your hourly rate × time spent

Calculating Cost Per Item

Example: Handmade Candle

• Soy wax per candle: $2.00
• Fragrance oil: $0.50
• Wick: $0.25
• Jar: $1.00
• Packaging: $0.50
• Label: $0.10
• Total COGS: $4.35 per candle

If you sell for $15 and Etsy takes $3.47 in fees:

Your profit: $15 - $4.35 - $3.47 = $7.18 per candle (48% margin)

Inventory Valuation Methods

• FIFO (First-In-First-Out): Oldest materials valued first (best for perishables/trendy items)
• LIFO (Last-In-First-Out): Newest materials valued first (tax advantage in inflation)
• Weighted Average: Average cost of all materials (easiest for most sellers)

Tracking Inventory in Your Books

1. Create inventory asset account
2. Record materials purchased (debit inventory, credit cash)
3. When item sells, record COGS expense (debit COGS, credit inventory)
4. Monthly reconciliation: Physical count vs. book count
5. Write off damaged/spoiled inventory immediately

Essential Reports for Etsy Sellers

1. Profit & Loss Statement (P&L)

Shows all revenue and expenses over a time period (monthly/quarterly/annual).

Key Metrics:

• Gross Revenue: Total sales
• Etsy Fees: Transaction + payment processing + listings
• COGS: Materials and packaging
• Gross Profit: Revenue - COGS
• Operating Expenses: Shipping, advertising, software, supplies
• Net Profit: Bottom-line profit

2. Cash Flow Statement

Tracks cash moving in and out. Critical for managing seasonal Etsy sales.

• Identifies months with tight cash
• Helps plan inventory purchases
• Shows impact of refunds/chargebacks on cash

3. Product Profitability Analysis

Compare profit by product to focus on top performers:

• Product name | Units Sold | Revenue | COGS | Fees | Profit | Profit Margin
• Review quarterly to identify low-margin items
• Eliminate underperformers or raise prices

What Your Numbers Should Tell You

• Gross Profit Margin 50%+: Healthy (after COGS)
• Gross Profit Margin 30-50%: Acceptable but watch pricing
• Gross Profit Margin <30%: Too thin—raise prices or reduce COGS
• Net Profit Margin 20%+: Excellent profitability
• Net Profit Margin 10-20%: Good—standard for online sellers
• Net Profit Margin <10%: Review expenses & pricing immediately