Etsy Bookkeeping for Beginners: Track Every Dollar in 2026

The complete guide to managing your Etsy shop finances—from tracking your first sale to preparing for tax season. No accounting degree required.

You made your first Etsy sale. Congratulations! Then you bought more supplies. Paid Etsy fees. Bought shipping labels. Ran some ads. And suddenly you're staring at your bank account wondering: Am I actually making money?

This is where most new Etsy sellers get stuck. You're creative, not an accountant. But here's the truth: good bookkeeping is the difference between a profitable shop and a expensive hobby. The good news? Etsy bookkeeping is simpler than you think—once you know what to track and how to organize it.

I've been selling on Etsy since 2018, and I've made every bookkeeping mistake in the book. I've also helped hundreds of sellers set up systems that actually work. This guide will show you exactly what to track, which tools to use, and how to stay organized without spending hours on spreadsheets.

💡 Why This Matters

Proper bookkeeping isn't just about taxes. It helps you make better business decisions, understand which products are actually profitable, and avoid cash flow surprises. Most successful Etsy sellers spend 1-2 hours per month on bookkeeping—and it saves them thousands in tax time stress and bad business decisions.

What You Need to Track (The Essential Four)

Etsy bookkeeping boils down to four categories. Track these consistently, and you'll have everything you need for taxes, profit analysis, and business decisions.

1. Income (Money Coming In)

Every sale generates income, but Etsy's payment system can be confusing. Here's what to track:

Gross sales: The total amount customers paid (including shipping)
Etsy fees: Transaction fees, payment processing fees, listing fees, offsite ads
Net deposits: What actually hits your bank account
Refunds and returns: Track these separately for accurate profit calculations

2. Expenses (Money Going Out)

Every dollar you spend on your business is potentially tax-deductible. Common Etsy expenses include:

Materials and supplies: Everything that goes into making your products
Shipping costs: Labels, packaging materials, tape, boxes
Tools and equipment: Printers, cutting machines, cameras, computers
Software and subscriptions: Marmalead, design tools, accounting software
Marketing: Etsy ads, social media ads, promotional materials
Office expenses: Internet, phone, workspace costs
Professional services: Accountant fees, legal fees, business licenses

3. Inventory (What You Have)

If you make physical products, inventory tracking is crucial for understanding true profitability:

Raw materials: Track quantities and costs of supplies on hand
Finished goods: How many completed products are ready to sell
Cost of goods sold (COGS): The actual cost to make each item you sold

For digital products or print-on-demand, inventory tracking is simpler—you mainly track design time and software costs.

4. Taxes (What You'll Owe)

Set aside money for taxes throughout the year. Most Etsy sellers need to track:

Income tax: Federal and state taxes on your profit
Self-employment tax: Social Security and Medicare (about 15.3% of profit)
Sales tax: If you're collecting it from customers (Etsy handles most of this)
Quarterly estimated payments: Required if you expect to owe $1,000+ in taxes

A common rule of thumb: set aside 25-30% of your profit for taxes. Adjust based on your tax bracket and state.

Your Bookkeeping System: Three Options

You don't need fancy software to start. Choose the system that matches your shop size and comfort level with technology.

Option 1: Simple Spreadsheet (Best for New Sellers)

If you're making fewer than 50 sales per month, a spreadsheet is perfect. Create one with these tabs:

Income: Date, Order Number, Customer, Gross Sale, Fees, Net Income
Expenses: Date, Vendor, Category, Amount, Notes
Inventory: Item, Quantity, Cost per Unit, Total Value
Monthly Summary: Total income, total expenses, profit, tax savings

Update your spreadsheet weekly—it takes 15-20 minutes and keeps you on top of your finances. Download your Etsy CSV files monthly and cross-reference them with your records.

📊 Pro Tip: Use Etsy's CSV Downloads

Go to Shop Manager → Finances → Payment Account → Download CSV. This gives you a complete record of all transactions. Import this into your spreadsheet monthly to catch anything you missed. Keep these files—they're your backup if your spreadsheet ever gets corrupted.

Option 2: Accounting Software (Best for Growing Shops)

Once you're doing 50+ sales per month, dedicated accounting software saves hours and reduces errors. Popular options include:

QuickBooks Online

The industry standard. Connects directly to Etsy, automatically imports transactions, and generates tax reports. Pricing starts around $30/month for the Simple Start plan.

Best for: Sellers who want professional-grade reports and plan to scale beyond Etsy.

Wave Accounting

Free accounting software with paid add-ons. Great interface, solid features, and you can't beat the price. No direct Etsy integration, but you can import CSV files easily.

Best for: Budget-conscious sellers who don't mind manual CSV imports.

GoDaddy Bookkeeping (formerly Outright)

Built specifically for online sellers. Simple interface, automatic Etsy sync, and good expense tracking. Check current pricing on their website.

Best for: Sellers who want simplicity over advanced features.

Option 3: Hire a Bookkeeper (Best for Established Shops)

If you're doing $50,000+ in annual sales, hiring a bookkeeper might be worth it. Typical costs range from $200-500 per month depending on transaction volume. They'll handle categorization, reconciliation, and tax prep—freeing you to focus on making and selling.

Look for bookkeepers who specialize in e-commerce or small creative businesses. They'll understand Etsy's fee structure and common deductions for makers.

Track Your Etsy Profits Like a Pro

Marmalead's profit tracking features help you understand which products are actually making money. See real costs, fees, and profit margins for every listing. Plus, use Marma AI to optimize listings that aren't performing—turning slow sellers into profit drivers.

Try Marmalead Free →

The Weekly Bookkeeping Routine (20 Minutes)

Consistency beats perfection. Here's a simple weekly routine that keeps your books current without taking over your life:

Monday Morning (10 minutes)

Log into Etsy and review last week's sales
Record any new income in your spreadsheet or software
Check for any refunds or disputes
Verify that deposits match your records

Friday Afternoon (10 minutes)

Gather receipts from the week (supplies, shipping, etc.)
Categorize and record all expenses
Update inventory if you bought materials
Take photos of paper receipts and store digitally

That's it. Twenty minutes per week keeps you current. At month-end, you'll spend another 30 minutes reconciling everything and generating reports.

Understanding Etsy's Fee Structure

Etsy's fees can feel overwhelming at first. Here's what you're actually paying and how to track it:

Listing Fee: $0.20 per listing

Charged when you create or renew a listing. Listings auto-renew when they sell or after 4 months. Track these monthly—they add up fast if you have a large catalog.

Transaction Fee: 6.5% of sale price

Charged on the item price plus shipping. This is your biggest fee. On a $30 item with $5 shipping, you pay $2.28 in transaction fees. Always factor this into your pricing strategy (see our pricing guide).

Payment Processing Fee: 3% + $0.25

Charged on the total order including shipping and sales tax. On that same $35 order, you pay $1.30. This is separate from the transaction fee—yes, you pay both.

Offsite Ads Fee: 12-15% of sale price

Only charged if Etsy's ads bring you a sale. 15% for most sellers, 12% if you do $10,000+ in annual sales. This fee is controversial but mandatory for larger sellers. Track it separately—it can significantly impact profit margins. Learn more in our offsite ads guide.

⚠️ Common Mistake: Forgetting About Fees

New sellers often calculate profit as "sale price minus materials." But Etsy fees typically eat 10-12% of your sale price (more with offsite ads). Always subtract fees before calculating profit. A $30 item with $5 in materials isn't $25 profit—it's closer to $20 after fees.

Tax Deductions Every Etsy Seller Should Know

Proper bookkeeping makes tax time easier and helps you claim every deduction you're entitled to. Here are the most commonly missed deductions:

Home Office Deduction

If you have a dedicated workspace, you can deduct a portion of rent, utilities, and internet. Use the simplified method ($5 per square foot, up to 300 sq ft) or actual expense method. Keep photos and measurements of your workspace.

Vehicle Expenses

Trips to the post office, craft store, or shipping supply store are deductible. Track mileage with an app like MileIQ or keep a simple log. Standard mileage rate is typically around $0.67 per mile (check current IRS rates).

Education and Training

Online courses, books, workshops, and conferences related to your business are fully deductible. This includes courses on photography, marketing, or learning new craft techniques.

Software and Tools

Marmalead, design software, photo editing tools, accounting software—all deductible. Also includes your website hosting, email marketing tools, and any apps you use for business.

Phone and Internet

Deduct the business-use percentage of your phone and internet bills. If you use your phone 50% for business, deduct 50% of the bill. Keep one month's detailed log to establish your percentage.

Marketing and Advertising

Etsy ads, social media ads, business cards, promotional materials, and even product samples you give away for reviews. All deductible. Track every marketing dollar you spend.

💡 Quarterly Estimated Taxes

If you expect to owe $1,000+ in taxes, you need to make quarterly estimated payments (April 15, June 15, September 15, January 15). Use IRS Form 1040-ES to calculate. Set aside 25-30% of your profit each month so you're ready. Missing these payments results in penalties—even if you pay everything at tax time.

Separating Business and Personal Finances

This is the #1 piece of advice from every accountant: separate your business and personal money. Here's how:

Open a Business Bank Account

You don't need a formal business entity (LLC, etc.) to open a business checking account. Most banks offer free or low-cost accounts for sole proprietors. Use this account exclusively for Etsy income and business expenses.

Benefits: Clean records for taxes, easier bookkeeping, professional appearance, and legal protection if you ever get audited.

Get a Business Credit Card

Use one credit card exclusively for business purchases. This creates a perfect paper trail and simplifies expense tracking. Many business cards offer cash back or rewards on common business expenses like shipping and office supplies.

Pay yourself a regular "salary" by transferring money from your business account to personal. This makes it clear what's profit versus what's business funds.

Inventory Tracking for Physical Products

If you make physical products, inventory management affects both your taxes and profitability. Here's what you need to know:

Calculate Cost of Goods Sold (COGS)

COGS is the actual cost to make each item you sold. Formula: Beginning Inventory + Purchases - Ending Inventory = COGS.

Example: You started the year with $500 in materials. You bought $2,000 more during the year. At year-end, you have $300 in materials left.

COGS = $500 + $2,000 - $300 = $2,200

This $2,200 is deductible as a business expense. Track your inventory at least quarterly to keep this accurate.

Track Material Costs Per Product

Know exactly what each product costs to make. Include materials, packaging, and a portion of shared supplies (like glue or thread). This helps you:

Price products profitably
Identify which products have the best margins
Make smart decisions about what to promote
Calculate accurate COGS for taxes

CraftyTrendy's profit calculator can help you track per-product costs and margins. It factors in all Etsy fees and helps you see which products are actually profitable. Check current features at their website.

Year-End Bookkeeping Checklist

December is bookkeeping crunch time. Here's your year-end checklist to make tax season painless:

Financial Review (Early December)

Review all income and expense categories for accuracy
Reconcile bank and credit card statements
Verify all Etsy deposits match your records
Check for any missing receipts or documentation
Calculate estimated profit for the year

Tax Prep (Late December)

Count physical inventory and calculate value
Determine your COGS for the year
Make any last-minute deductible purchases
Organize receipts by category
Calculate home office deduction
Total up mileage for the year

Document Gathering (January)

Download annual Etsy reports (Shop Manager → Finances)
Get 1099-K from Etsy (if you did $20,000+ in sales)
Compile all 1099s from other income sources
Generate profit & loss statement
Create expense summary by category
Schedule appointment with accountant (if using one)

Common Bookkeeping Mistakes to Avoid

Learn from others' mistakes. Here are the most common bookkeeping errors I see Etsy sellers make:

Mixing Personal and Business Expenses

Using your personal account for business purchases makes bookkeeping a nightmare and raises red flags in audits. Keep them separate from day one. If you already mixed them, start separating now—better late than never.

Not Tracking Small Expenses

That $3 roll of tape, $8 in shipping supplies, $15 in printer ink—it all adds up. Small expenses can total thousands per year. Track everything, no matter how small. Use a receipt scanning app if paper receipts pile up.

Forgetting About Sales Tax

Etsy collects and remits sales tax in most states, but not all. Check your state's requirements. If you sell at craft fairs or have a website, you might need to collect and remit sales tax yourself. This is separate from income tax.

Waiting Until Tax Season

Trying to reconstruct a year of finances in March is miserable. You'll miss deductions, make errors, and stress yourself out. Do a little bookkeeping every week. Your future self will thank you.

Not Backing Up Records

Keep digital copies of everything. Scan receipts, save Etsy reports, backup your spreadsheets to cloud storage. The IRS requires you to keep records for 3-7 years. A hard drive crash shouldn't wipe out your financial history.

When to Hire Professional Help

You don't need an accountant on day one, but there are times when professional help is worth every penny:

Hire a CPA When:

You're making $30,000+ in annual profit
You're forming an LLC or corporation
You're getting audited (obviously)
Your taxes are complex (multiple income streams, rental properties, etc.)
You want to maximize deductions and minimize tax liability

A good CPA typically costs $300-800 for tax preparation but can save you thousands in taxes and penalties. They also provide peace of mind—you know your taxes are done correctly.

Hire a Bookkeeper When:

You're spending 5+ hours per month on bookkeeping
You're making mistakes or falling behind
Your time is better spent making products or marketing
You're doing $50,000+ in annual sales

Bookkeepers handle day-to-day transaction recording and reconciliation. They're less expensive than CPAs (typically $200-500/month) and free up your time for revenue-generating activities.

Focus on What You Do Best—Let Tools Handle the Rest

Good bookkeeping starts with understanding your numbers. Marmalead helps you track which products are profitable and which need optimization. Use Marma AI to improve underperforming listings and the Chrome extension to create optimized listings in seconds—so you can spend less time on admin and more time growing your shop.

Start Your Free Trial →

Frequently Asked Questions

Do I need to report Etsy income if I made less than $600?

Yes. All income is taxable, regardless of amount. The $600 threshold is just when Etsy is required to send you a 1099-K form. Even if you made $100, you need to report it on your tax return. The good news: you can deduct expenses against that income, potentially resulting in zero taxable profit.

Can I deduct my craft supplies even if I haven't sold the finished products yet?

Not exactly. Materials become deductible when you sell the finished product (as part of COGS). Until then, they're considered inventory—an asset, not an expense. However, supplies that aren't part of finished products (like shipping materials, office supplies, or tools) are deductible when purchased.

How long should I keep my Etsy financial records?

Keep records for at least 3 years from the date you filed your tax return. If you underreported income by more than 25%, keep records for 6 years. If you didn't file a return or filed a fraudulent return, keep records indefinitely. When in doubt, keep everything—digital storage is cheap.

Should I form an LLC for my Etsy shop?

It depends on your situation. An LLC provides legal protection and can have tax benefits, but adds complexity and cost (filing fees, annual reports, separate tax returns). Most sellers start as sole proprietors and form an LLC once they're doing $20,000+ in annual sales or have significant liability concerns. Consult with a CPA or attorney for your specific situation.

What's the difference between gross income and net income?

Gross income is total sales before any deductions. Net income is what's left after subtracting all expenses, fees, and costs. For taxes, you're taxed on net income (profit), not gross sales. This is why tracking expenses is so important—every legitimate deduction reduces your tax bill.

Your Bookkeeping Action Plan

Bookkeeping doesn't have to be overwhelming. Here's your step-by-step plan to get organized:

This Week

Open a separate business bank account
Choose your bookkeeping system (spreadsheet or software)
Download all Etsy CSV files from the past year
Create folders for digital receipt storage

This Month

Set up your spreadsheet or accounting software
Record all income and expenses from the current month
Establish your weekly bookkeeping routine
Calculate your estimated quarterly tax payment

This Quarter

Catch up on any missing records from previous months
Reconcile all accounts
Review your profit margins by product
Make your quarterly estimated tax payment
Adjust your pricing if needed based on true costs

Good bookkeeping is a habit, not a project. Start small, stay consistent, and your financial records will become second nature. The peace of mind alone is worth the effort—knowing exactly where your business stands financially lets you make confident decisions about growth, pricing, and investment.

🎯 Remember

You don't need to be perfect. You just need to be consistent. Track your income, record your expenses, separate business from personal, and keep good records. Do these four things, and you'll be ahead of 80% of Etsy sellers. The rest is just refinement.

Etsy Bookkeeping for Beginners: Track Every Dollar