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 Type | Account Name | Description |
|---|---|---|
| Income | Etsy Sales | Gross revenue from product sales |
| Income | Shipping Income | Amount charged to customers for shipping |
| Expense | Etsy Listing Fees | $0.20 per listing |
| Expense | Etsy Transaction Fees | 6.5% of sale price |
| Expense | Etsy Payment Processing Fees | 3% + $0.25 per transaction |
| Expense | Etsy Offsite Ads Fees | 12–15% of attributed sales |
| Expense | Cost of Goods Sold (COGS) | Materials, packaging, labor |
| Expense | Shipping Expenses | Postage and shipping supplies |
| Expense | Refunds | Money returned to customers |
| Liability | Sales Tax Payable | Sales 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:
- Download your Etsy payment account CSV monthly.
- Enter gross sale amount as income (Etsy Sales).
- Record each fee (listing, transaction, payment processing) as an expense.
- For refunds, reduce income and record any retained fees as expenses.
- 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:
- Enter each sale in the Sales tab:date.
- Record fees in the Fees tab:listing.
- Log expenses in the Expenses tab:COGS.
- Update inventory in the Inventory tab: purchases and cost per unit.
- 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 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.








