Etsy Bookkeeping: Simple Tax Guide for Small Sellers

October 30, 2026
Written By team taxnookly

Our goal is to provide reliable, helpful, and up-to-date content based on practical tax and bookkeeping principles.

You started your Etsy shop because you love making things. However, you did not start it by staring at spreadsheets. Still, tax season arrives every year, and ignoring your numbers leads to panic.

So what is Etsy bookkeeping, really? Simply put, it is the habit of recording the money that comes into your shop and the money that goes out. It also means keeping shop money apart from personal money. Don’t worry, because you do not need an accounting degree. If you can track your grocery receipts, you can do this.

In fact, good Etsy bookkeeping saves you from the April scramble. For example, you will never again wonder what that $43 charge on your bank statement was. This guide walks you through the exact steps, tools, and tables you need. If you are brand new, start with our Etsy bookkeeping for beginners guide, and then come back here for the full picture.

What Etsy Bookkeeping Really Means

Etsy bookkeeping is a simple record of your shop’s money. First, you write down every sale. Next, you write down every business expense. Finally, you keep proof for both. That is the whole job.

Many sellers think bookkeeping and accounting are the same thing, but they are not. Bookkeeping means recording numbers as they happen. Accounting, on the other hand, means reading those numbers and filing taxes. A tax pro can do the second part if you want. Meanwhile, you only need to do the first part well.

Here is why this matters. The IRS treats your Etsy shop as a business, even if it feels like a hobby. Therefore, you must report all income. At the same time, you can deduct real business costs. As a result, clean records let you do both with confidence.

Your records answer four basic questions:

  1. How much money did my shop earn?
  2. What did I spend to earn it?
  3. How much profit did I keep?
  4. What tax should I set aside?

If you can answer those four questions at any time, your Etsy bookkeeping works. Besides that, everything else in this guide helps you answer them faster.

The Golden Rule of Etsy Bookkeeping: Keep Money Separate

If you take only one lesson from this article, take this one. Open a separate bank account for your shop.

I know it feels like a hassle. However, mixing personal and shop money is the top reason sellers feel stressed at tax time. Because everything lives in one account, every transaction becomes a guessing game. Unfortunately, the IRS does not accept guesses.

A separate account does not need to be fancy. For instance, a free second checking account at your current bank works fine. Follow these simple rules:

  • Send all Etsy payouts to the business account.
  • Pay for all supplies from the business account.
  • Then pay yourself by transferring money out on a set schedule.
  • Never buy groceries or gas with the business card.

Additionally, this setup gives you a clean paper trail. Each deposit is a sale, and each withdrawal is an expense or an owner’s draw. As a result, you can scan a statement in minutes instead of hours.

A separate account also builds trust. If the IRS ever asks questions, you can show a clear, organized record. That peace of mind is worth the ten minutes it takes to open the account.

Choose Your Etsy Bookkeeping Tools

You do not need expensive software to start. In fact, the best system is the one you will actually use every week. So pick a tool that matches your sales volume and your comfort level.

Many new sellers begin with an Etsy bookkeeping spreadsheet free template. Because a simple Google Sheet can handle a few hundred orders a year, it is often enough. However, as you grow, an app can save you hours. Our review of the best bookkeeping app for Etsy compares the top options in detail. Meanwhile, sellers who want full automation often choose QuickBooks for Etsy sellers, because it connects to your bank and tracks fees automatically.

Use this table to compare your options:

ToolBest ForTypical CostEffort Level
Google Sheets or ExcelShops with low order volumeFreeMedium
Wave or similar free appBeginners who want automationFree to lowLow
QuickBooks Self-Employed or Simple StartGrowing shops with many ordersPaid monthlyLow
Hired bookkeeperBusy shops or complex inventoryPaid by serviceVery low

A free spreadsheet is perfectly fine if your shop earns under about $15,000 a year. Still, upgrade when entering data starts to feel like a chore. Also, check current prices on each provider’s website, since plans change often.

Track Your Sales and Expenses Every Week

Many sellers wait until December to do their books. However, this approach backfires. By then, you will forget what half the transactions were, and you will drown in digital receipts.

Instead, use a 15-minute weekly habit. Pick one day, such as Friday afternoon. Then follow these steps:

  1. First, open your business bank account and scan the week’s activity.
  2. Next, log into Etsy Shop Manager and go to Finances, then Payment Account, then Monthly Statements. Download the latest PDF. (Etsy renames menus sometimes, so look for the closest match.)
  3. After that, record your total sales and total expenses in your sheet.
  4. Finally, save any new receipts in your cloud folder.

This routine is the core of a good Etsy income and expense tracker. Your tracker only needs a few columns: date, description, category, amount, and receipt link.

Moreover, the same habit solves how to track Etsy sales for taxes. Each week, you capture the gross sale amount, not just the payout. Gross sales go on your tax return, while fees and shipping costs go in the expense column. Consequently, you will thank yourself in April.

How to Organize Etsy Receipts Without the Headache

Receipts prove your expenses. Without proof, a deduction can disappear in an audit. Therefore, you need a system that is easy enough to keep up.

First, go digital. Take a photo of every paper receipt with your phone, and save it in a cloud folder right away. Likewise, forward email receipts into the same folder. Then name each file with the date and vendor, like “2026-03-14-PackagingCo.pdf”.

We wrote a full walkthrough on how to organize Etsy receipts that covers folder structures and naming rules. In the meantime, here is the short version:

Receipt TypeWhere to Find ItHow to Store It
Supply purchasesEmail, store app, paperCloud folder by month
Etsy fee statementsShop Manager, FinancesDownload monthly PDF
Shipping labelsEtsy or carrier accountSave PDF with order number
Software subscriptionsEmail billing noticesCloud folder labeled “Software”
Mileage logsPhone app or notebookSpreadsheet tab

Keep every receipt for at least three years after you file. Even better, keeping them for four to six years is safer. Fortunately, cloud storage costs little and protects you well.

Etsy Bookkeeping for Inventory and Cost of Goods Sold

If you sell physical products, you must track what your items cost to make. This cost has a name: cost of goods sold, or COGS. It includes the materials and direct costs that go into each product you sell.

Our deep dive on Etsy cost of goods sold explains the full formula. In simple terms, you add your starting inventory to your purchases. Then you subtract your ending inventory. The result is your COGS for the year.

To keep this accurate, you need a stock record. For this, a basic Etsy inventory tracking spreadsheet works well. List each item, its quantity, and its unit cost. Afterward, update it whenever you buy supplies or sell items.

Here is a quick example of what counts as COGS:

Included in COGSUsually Not in COGS
Raw materials (fabric, clay, wax)Etsy listing and transaction fees
Packaging that ships with the itemAdvertising costs
Direct labor you pay to othersHome office costs
Freight cost to receive suppliesSoftware subscriptions

Tracking COGS gives you a true picture of your margins. In addition, it helps you price items correctly, so you do not sell products at a loss.

Understand Your Real Profit and the 1099-K

Here is where many sellers get tripped up. You look at your bank account and see a $500 deposit from Etsy, so you think, “Great, I made $500.” However, that deposit is not your gross income.

Etsy removes listing fees, transaction fees, and payment processing fees before it pays you. Therefore, your deposit is always smaller than your real sales.

Let’s use a simple example. A customer buys a handmade mug for $30 and pays $5 for shipping. As a result, your gross income is $35. Meanwhile, Etsy deposits only $28 after fees.

Line ItemAmount
Gross sale (item plus shipping)$35
Etsy fees taken out-$7
Deposit in your bank$28
Income you report on Schedule C$35
Fee deduction you claim$7

You report the full $35 as income. Then you list the $7 in fees as a business deduction. Because this is normal and legal, you pay tax only on profit.

This same math drives your Etsy profit and loss statement. That report lists income at the top, subtracts expenses, and shows your net profit at the bottom. Read our guide to build one in under an hour.

Now, a quick note on Form 1099-K. The reporting threshold has changed several times in recent years, so please check IRS.gov for the current figure. Remember this key point: you must report all income, even if you never receive a form.

The Self-Employment Tax Reality Check

No one withholds tax from your Etsy payouts. That means you handle two taxes yourself: regular income tax and self-employment tax.

Self-employment tax pays for Social Security and Medicare. The rate is 15.3%, and it applies to about 92.35% of your net profit. Moreover, you calculate it on Schedule SE. Check IRS.gov each year to confirm current rules.

Here is an illustrative example. These numbers are not real data.

StepCalculationResult
Gross shop incomeGiven$15,400
Business expensesFees, boxes, home internet share-$5,100
Net profit$15,400 minus $5,100$10,300
Taxable base$10,300 x 92.35%about $9,512
Self-employment tax$9,512 x 15.3%about $1,455

You will also owe income tax on top of that, and the amount depends on your household income. For this reason, many advisors suggest setting aside 25% to 30% of net profit in a separate savings account. In addition, you can send quarterly estimated payments with Form 1040-ES. That way, you avoid a huge bill in April.

If your net profit is under $400, you generally do not owe self-employment tax. However, you still must report the income.

Common Etsy Deductions and Mistakes to Avoid

Smart bookkeeping helps you claim every deduction you deserve. Likewise, it keeps you away from risky ones.

The IRS rule is simple: an expense must be “ordinary and necessary” for your business. Furthermore, if you get audited, you must prove it with records.

Here are common deductions for Etsy sellers:

Expense CategoryExamplesNotes
Platform feesListing, transaction, processing, ad feesFound on monthly statements
Materials and suppliesFabric, beads, paper, packagingTrack as COGS if sold
Shipping costsPostage, labels, mailersKeep the label receipt
SoftwareDesign tools, accounting appsBusiness use only
Home officeDedicated workspaceSpace must be regular and exclusive
EducationCourses on your craft or businessMust relate to your shop

Now the warning. Some sellers try to write off Netflix, family trips, or personal meals. Please do not do this. After all, if you would feel uncomfortable showing an expense to an IRS agent, you should not deduct it.

The home office rule is strict too. For example, you must use the space regularly and only for your Etsy business. Therefore, a bedroom corner where you also watch TV does not qualify.

Your Yearly Etsy Bookkeeping Calendar

A calendar turns good intentions into action. So use this simple schedule to stay on track all year.

WhenTaskTime Needed
WeeklyLog sales and expenses, save receipts15 minutes
MonthlyDownload Etsy statement, match bank balance30 minutes
QuarterlyReview profit, send estimated tax payment1 hour
Year endCount inventory, run profit and loss report2 hours
January to AprilGather forms, file taxes or meet your tax proVaries

This rhythm keeps your Etsy bookkeeping light. After all, small steps each week beat one giant session each spring. To help the habit stick, set calendar reminders.

If you want to go further, review your numbers every quarter. For example, ask which products earn the most profit. Likewise, ask which expenses grew too fast. Over time, your books will guide real business decisions, not just tax forms.

Questions Sellers Actually Ask About Etsy Bookkeeping

Do I need an LLC to do Etsy bookkeeping properly?
No. You can operate as a sole proprietor, so your bookkeeping steps stay the same and you still file a Schedule C. An LLC, however, offers legal liability protection instead of a tax loophole.

What if I only made $1,500 this year? Do I still report it?
Yes. You must report all income. However, if your net profit is under $400, you generally do not owe self-employment tax. Still, keep basic records anyway.

Can I really deduct my home office?
Yes, but the rules are strict. You must use the space regularly and exclusively for your Etsy business. Before you claim it, check IRS guidance or ask a tax pro.

How long should I keep my records?
The IRS generally recommends keeping tax records for at least three years after you file. However, keeping them for four to six years is safer.

Is a spreadsheet enough, or do I need software?
A spreadsheet works well for small shops. However, switch to an app when your order volume grows or when entering data takes too long.

Conclusion: Start Your Etsy Bookkeeping Today

Etsy bookkeeping does not need to be hard. First, keep your shop money separate. Next, spend 15 minutes each week on your numbers. Then save every receipt, track your costs and your real profit, and set aside money for taxes as you go.

These small habits protect you in an audit. Besides that, they show you which products make money. As a result, your shop can grow with confidence.

Disclaimer

This article is for general information and educational purposes only. It does not constitute tax, legal, or accounting advice. Before making any tax filing or business decision, check the latest guidance on IRS.gov or consult a licensed tax professional.

Sources

Profit or Loss From Business (Sole Proprietorship)
Self-Employment Tax
Tax Guide for Small Business

Author Bio

About Team Tax Nookly

Team Tax Nookly is a dedicated group of bookkeeping professionals and e-commerce tax specialists focused exclusively on the Etsy marketplace. We simplify complex tax regulations and provide actionable financial strategies to help Etsy sellers manage their businesses with complete confidence.