GoWithFund
Sign in
💳Smart Finance• Private Net Worth, Envelope Budgeting, Cashflow & Wealth Engine

Bookkeeping for Etsy Sellers: The Complete Guide

Master bookkeeping for Etsy sellers with this complete guide. Track fees, refunds, and inventory with a free spreadsheet template.

GoWithFund Editorial Team
GoWithFund Editorial Team
••7 min read
Etsy seller's desk with laptop, notebook, calculator, and receipts for bookkeeping
Quick Answer

Bookkeeping for Etsy sellers is the process of recording every sale, fee, refund, and expense from your shop so you can calculate true profit, file accurate taxes, and make informed business decisions. This guide covers Etsy-specific challenges, a chart of accounts, and a free spreadsheet template to get started.

🌱
Key takeaways
  • Etsy fees (listing, transaction, payment processing, offsite ads) are deductible business expenses.
  • Separate business and personal finances with a dedicated bank account and credit card.
  • Track inventory costs and COGS to calculate true profit margin.
  • Use a bookkeeping system that handles Etsy's fee structure and refunds.
  • Set aside 25–30% of profit for taxes and review your books monthly.
  • Download our free Etsy bookkeeping spreadsheet to automate calculations.

Bookkeeping for Etsy Sellers: The Complete Guide

Bookkeeping for Etsy sellers is the process of recording every salean calculate true profit, file accurate taxes, and make informed business decisions. This guide covers Etsy-specific challenges, a chart of accounts, and a free spreadsheet template to get started.

Key Takeaways

  • Etsy fees (listing) are business expenses that reduce your taxable income.
  • Separate business and personal finances with a dedicated bank account and credit card.
  • Track inventory costs and cost of goods sold (COGS) to know your real profit margin.
  • Use a bookkeeping system—spreadsheet or software—that handles Etsy's fee structure and refunds.
  • Set aside 25–30% of profit for taxes, and review your books monthly.
  • Download our free Etsy bookkeeping spreadsheet to automate calculations.

Why Bookkeeping for Etsy Sellers Is Different

Etsy bookkeeping differs from generic small-business accounting because Etsy deducts multiple fees before paying you, and refunds can complicate revenue tracking. You need to record gross sales, fee expenses, and net deposits separately to comply with tax rules and understand profitability.

Etsy-Specific Bookkeeping Challenges

Etsy sellers face unique bookkeeping hurdles:listing fees. Each must be recorded correctly to avoid overpaying taxes or misstating income.

  • Listing fees: $0.20 per item listed (renewed every four months or after a sale).
  • Transaction fee: 6.5% of the item price plus shipping and gift wrap (as of 2024).
  • Payment processing fee: 3% + $0.25 per transaction in the US (varies by country).
  • Offsite ads fee: 12–15% of sales attributed to offsite ads (mandatory for shops over $10k/year).
  • Refunds: Etsy credits the transaction fee but not always the payment processing fee.
  • Sales tax: Etsy collects and remits sales tax in many jurisdictions; you must record it as a liability, not income.

These fees can consume 10–15% of revenue, so tracking them is essential for accurate profit calculation. [stat needed: average Etsy fee percentage]

How Etsy Fees Affect Your Profit

Etsy fees directly reduce your net income. For example, a $30 sale with 6.5% transaction fee ($1.95), 3% + $0.25 payment processing ($1.15), and $0.20 listing fee leaves $26.70 before shipping and COGS. If your item costs $10 to make, your profit is $16.70—a 55.7% margin. Without tracking fees, you might think you earned $30.

Use a bookkeeping system that categorizes each fee separately. This helps you see the true cost of selling on Etsy and adjust pricing accordingly.

Setting Up Your Etsy Chart of Accounts

A chart of accounts is a list of categories for recording transactions. For Etsy sellers, customize it to capture income sources and fee types. A standard small-business chart works, but adding Etsy-specific accounts improves clarity.

Recommended Accounts for Etsy Sellers

Use these accounts to organize your Etsy bookkeeping:

Account TypeAccount NameDescription
IncomeEtsy SalesGross revenue from product sales
IncomeShipping IncomeAmount charged to customers for shipping
ExpenseEtsy Listing Fees$0.20 per listing
ExpenseEtsy Transaction Fees6.5% of sale price
ExpenseEtsy Payment Processing Fees3% + $0.25 per transaction
ExpenseEtsy Offsite Ads Fees12–15% of attributed sales
ExpenseCost of Goods Sold (COGS)Materials, packaging, labor
ExpenseShipping ExpensesPostage and shipping supplies
ExpenseRefundsMoney returned to customers
LiabilitySales Tax PayableSales tax collected by Etsy (if applicable)

Adjust account names to match your bookkeeping software or spreadsheet. Consistency is key.

How to Record Etsy Transactions

Record each Etsy sale as gross revenue, then deduct fees as separate expenses. For refunds, reverse the original sale and record any non-refundable fees as expenses. Here's a step-by-step framework:

  1. Download your Etsy payment account CSV monthly.
  2. Enter gross sale amount as income (Etsy Sales).
  3. Record each fee (listing, transaction, payment processing) as an expense.
  4. For refunds, reduce income and record any retained fees as expenses.
  5. Reconcile the net deposit to your bank account.

This method ensures your books match your bank statements and tax reports.

Free Etsy Bookkeeping Spreadsheet

We've created a free Etsy bookkeeping template to simplify your record-keeping.It includes tabs for sales. The spreadsheet automatically calculates net profit and fee totals.

How to Use the Template

Download the template (link below) and follow these steps:

  1. Enter each sale in the Sales tab:date.
  2. Record fees in the Fees tab:listing.
  3. Log expenses in the Expenses tab:COGS.
  4. Update inventory in the Inventory tab: purchases and cost per unit.
  5. Review the Profit Summary tab for monthly and annual profit.

The template is compatible with Excel, Google Sheets, and Numbers. It's designed for Etsy sellers with up to 500 transactions per month. For higher volume, consider accounting software like QuickBooks or Xero.

Note: The template is a starting point; consult a tax professional for your specific situation.

Etsy bookkeeping spreadsheet on a computer screen with a hand pointing

Etsy Seller Taxes: What You Need to Know

Etsy sellers must report business income and expenses on their tax return. In the US, you'll likely file Schedule C (Profit or Loss from Business) with Form 1040. Etsy provides a 1099-K if you meet the threshold ($20,000 and 200 transactions in 2023; threshold changes to $600 in 2024). Even if you don't receive a 1099-K, you must report all income.

Deductible Expenses for Etsy Sellers

Common deductible expenses include:

  • Etsy fees (listing)
  • Cost of goods sold (materials, packaging)
  • Shipping supplies and postage
  • Home office (if exclusive and regular)
  • Business software and subscriptions
  • Advertising and marketing
  • Professional services (accountant, lawyer)

Keep receipts for all expenses. The IRS requires records to support deductions.

How Much Should Etsy Sellers Set Aside for Taxes?

Set aside 25–30% of net profit for federal and state income taxes, plus self-employment tax (15.3% in the US). For example, if your net profit is $10,000, set aside $2,500–$3,000 for income tax and $1,530 for self-employment tax. Adjust based on your tax bracket and state.

Consider making quarterly estimated tax payments to avoid penalties.

Etsy Profit Tracking and Cash Flow

Profit tracking shows whether your shop is actually making money. Cash flow tracking ensures you have enough cash to cover expenses. Both are critical for Etsy sellers.

How to Calculate Your Etsy Profit Margin

Profit margin = (Revenue – COGS – Fees – Other Expenses) / Revenue × 100. For example, if revenue is $1,000, COGS is $300, fees are $150, and other expenses are $100, profit is $450, and margin is 45%. Track this monthly to spot trends.

Use the free spreadsheet to automate this calculation.

Managing Cash Flow for Your Etsy Shop

Etsy pays sellers via Etsy Payments, typically within 1–3 business days after shipment. To manage cash flow, keep a buffer for slow months, track upcoming expenses (e.g., restocking), and avoid spending all revenue immediately. Use a separate bank account for your shop.

For a more robust cash-flow overview, consider the GoWithFund Smart Finance app, which offers budgeting and cash-flow reports tailored to freelancers and small teams.

Etsy seller reviewing profit and cash flow reports on a tablet
Keshav Gautam
Verified E-E-A-T Author

Keshav Gautam

Director, GoWithFund Inc.

Published on behalf of GoWithFund Inc., a registered U.S. 501(c)(3) tax-exempt public charity in Idaho (EIN: 33-1243835 | Idaho SOS #5902503). Articles are reviewed for statutory compliance under IRS Internal Revenue Code Section 170.

GoWithFund Smart Finance0% Platform Fee Ecosystem

Take Control of Your Personal Wealth & Cashflow

Stop letting predatory apps sell your financial data. Enjoy instant net worth calculations, automated envelope budgeting, and 1-click CPA exports.

100% Donor Funds DeliveredInstant Stripe Direct DepositNo Monthly Retainers
Recommended Reading
Explore all Smart Finance guides
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read
Accounting Web App Strategic Implementation Guide - GoWithFund Smart Finance Guide Cover Visual
💳 Net Worth & Wealth
Nov 22, 2026•5 min read

Accounting Web App: Strategic Implementation Guide

Manage real-time cashflow telemetry, envelope spending limits, net worth forecasting, and private financial planning for accounting web app in-depth guide.

GoWithFund Support

GoWithFund Support

Director, GoWithFund Inc.

Read