Etsy Seller Tax Prep: Bank Statement Organization Guide

Quick Answer {#quick-answer}

For Etsy sellers, tax prep has two parts: reconciling your Etsy income against your bank deposits and 1099-K, and capturing every material, supply, and business expense as a deduction. Convert your bank statement with QuickBankConvert, add a Category column, and you have the foundation for a clean Schedule C.

Understanding Etsy Income on Your Bank Statement {#etsy-income}

How Etsy Pays You

If you use Etsy Payments (required for most sellers), your funds accumulate in your Etsy account and are deposited to your bank account on a daily or weekly schedule. Your bank statement will show deposits labeled "Etsy Inc." or "Etsy Payments."

Importantly, your bank deposits are net of:

• Etsy listing fees ($0.20 per listing)
• Transaction fees (6.5% of the sale price including shipping)
• Etsy Payments processing fees (3% + $0.25 per transaction)
• Any refunds you issued

Your 1099-K (issued if you processed more than $5,000 in gross sales through Etsy Payments) shows the gross amount before fees.

The Three Documents You Need

Report the 1099-K gross amount as income. Then deduct Etsy's fees as a business expense (Line 10, Commissions and Fees). The result matches your net bank deposits.

Callout: Even if you do not receive a 1099-K—because your sales were below the threshold—you are still required to report all Etsy income. The threshold determines whether Etsy files a form with the IRS, not whether your income is taxable.

Tax Deductions for Etsy Sellers {#etsy-deductions}

Materials and Supplies (Cost of Goods Sold)

This is typically the largest deduction for Etsy sellers. Every dollar you spent on raw materials—yarn, wood, resin, paint, fabric, beads—is a deductible business expense.

Bank statement clues: Purchases at craft stores (Michaels, JOANN, Hobby Lobby), Amazon supply orders, wholesale supplier payments.

Shipping Costs

If you charge customers for shipping but the actual shipping cost is higher, the difference is a business expense. Even if shipping is included in your item price, the postage you paid is deductible.

Bank statement clues: USPS, UPS, FedEx, Pirateship, ShipStation, Shippo charges.

Etsy Fees

Transaction fees, listing fees, and payment processing fees appear on your Etsy Payments statement, not directly on your bank statement (they are deducted before deposit). Pull the total from your Etsy Payment account statement and deduct it as Commissions and Fees.

Packaging Supplies

Boxes, tissue paper, bubble wrap, tape, thank-you cards, labels, stamps. These are supply expenses, not cost of goods sold.

Photography Equipment and Props

If you photograph your own products, a dedicated camera, lighting, backdrop, and props are deductible. Mixed-use equipment (a phone you also use personally) is deductible at the business-use percentage.

Software Subscriptions

Canva Pro for graphics, Adobe Creative Suite, Tailwind for Pinterest, email marketing tools, bookkeeping software. All deductible as business expenses.

Home Office

If you create your Etsy products at home and have a dedicated workspace, you may qualify for the home office deduction. The space must be used regularly and exclusively for business.

Professional Development

Craft courses, business books, Etsy seller courses, marketing webinars—all deductible as education expenses to maintain or improve your business skills.

Callout: Keep receipts for all material purchases. The IRS can ask you to prove that your materials are actually used in your products and not for personal crafting. A simple system—a labeled folder for receipts, organized by month—is sufficient for most Etsy sellers at any level.

Cost of Goods Sold: The Etsy Seller's Hidden Deduction {#cogs}

Cost of Goods Sold (COGS) is the direct cost of the materials used in the items you actually sold during the year. It is calculated using this formula:

Beginning Inventory (materials on hand January 1)
+ Purchases during the year
- Ending Inventory (materials on hand December 31)
= Cost of Goods Sold

This matters because if you bought $3,000 of yarn in December but only sold $500 worth of finished items before year-end, you cannot deduct the full $3,000 immediately. You deduct the cost of what was sold; the rest rolls into next year's beginning inventory.

For most small Etsy sellers with fast-moving inventory, COGS is close to their annual material purchases—but tracking it accurately is still important.

The Etsy Seller Bank Statement Workflow {#bank-workflow}

Step 1 – Download Your Bank Statement

At tax time (or better, quarterly), download your full bank statement for all accounts you use for Etsy business.

Step 2 – Convert with QuickBankConvert

Upload your PDF or CSV to QuickBankConvert. The tool normalizes your statement into a clean spreadsheet where all Etsy deposits are clearly labeled and sortable.

Step 3 – Flag All Etsy Deposits

Filter for all "Etsy Inc." or "Etsy Payments" rows. Sum them to get your total net bank deposits from Etsy. This number should match your Etsy Payment account statement's net deposit total for the year.

Step 4 – Identify Material and Supply Purchases

Sort by description to find all purchases at craft suppliers, Amazon (filter for business orders), and shipping carriers. These are your COGS and supply deductions.

Step 5 – Categorize All Remaining Business Expenses

Assign Schedule C categories to every remaining business expense in your bank statement: software subscriptions, photography equipment, shipping supplies, professional development, home office utilities (if applicable).

Step 6 – Reconcile with Etsy Payment Statement and 1099-K

Pull the Etsy Payment account statement from the Etsy Seller Portal. Note total gross sales, total fees, and total net deposits. Cross-check net deposits against your bank statement total. The gross sales figure should match your 1099-K (if you received one).

Step 7 – Prepare Schedule C

Transfer your totals:

• Line 1 (Gross receipts): Etsy gross sales (from 1099-K or Etsy statement)
• Line 4 (COGS): Material costs from COGS calculation
• Line 10 (Commissions and Fees): Etsy transaction + processing fees
• Other lines: as categorized above

Manual vs. QuickBankConvert for Etsy Sellers {#tools-comparison}

The time you save using QuickBankConvert is time you can spend on your craft, your marketing, or simply not doing accounting on a Saturday night.

Etsy Seller Tax Prep Checklist {#etsy-tax-checklist}

• [ ] Etsy Payment account statement downloaded for full year
• [ ] 1099-K received (if applicable) or income verified from Etsy statement
• ] Bank statement downloaded and converted via [QuickBankConvert
• [ ] All Etsy deposits identified, summed, and reconciled to Etsy statement
• [ ] All material and supply purchases identified from bank statement
• [ ] Beginning and ending inventory counted (for COGS calculation)
• [ ] Shipping costs totaled
• [ ] Etsy fees totaled from Etsy statement
• [ ] All other business expenses categorized
• [ ] Home office deduction calculated (if applicable)
• [ ] Schedule C prepared with all income and expense lines
• [ ] Quarterly estimated taxes reconciled against amounts paid

This guide is for educational purposes only and does not constitute tax or legal advice. Consult a licensed CPA or tax professional for guidance specific to your Etsy business.