Guide
Etsy Bookkeeping for Taxes: The Records You Actually Need at Year End
Etsy already has every number you need — sales, shipping, and fees are all sitting in your Shop Manager statements. What most sellers are missing isn't the data, it's a place where it's already organized by month and reconciled against those statements before tax season arrives.
Every number a tax return needs from an Etsy shop already exists somewhere in your Etsy account — gross sales, shipping charged, fees taken, refunds issued. None of it is missing. What's usually missing is organization: those figures sit scattered across CSV exports and monthly statements, in Etsy's own categories rather than the ones a tax professional actually wants, and pulling them together in April from twelve months of exports is a genuinely bad way to spend an evening. A simple habit of logging sales and expenses by month, using Etsy's own exports as your source, turns that scramble into a total you can hand over in minutes.
What year-end records actually consist of
Four categories of numbers, organized and totaled, are what a tax professional needs from an Etsy shop:
| Record | Where it comes from |
|---|---|
| Gross sales by month | Order totals from your Etsy Orders CSV, before fees. |
| Shipping charged to buyers | Postage collected on each order, logged separately from the item price. |
| Etsy fees | Listing, transaction, and payment processing fees, from your statement CSV. |
| Business expenses by category | Materials, postage you paid for, packaging, marketing, software, and anything else spent running the shop, from your own receipts and card statements. |
None of these individually is hard to find. What takes the work is pulling them into one place, organized by month, so that by December you have twelve months of totals sitting ready instead of twelve months of exports you haven't opened yet.
Sales by month, not one big annual pile
Logging sales monthly rather than annually does two things. It keeps the data close enough to when it happened that discrepancies are easy to check — a mismatched order is one row to investigate in a month's worth of sales, not a needle in a year's worth. And it gives you a running total throughout the year, so you're not discovering your shop's actual revenue for the first time in the same sitting you're trying to file taxes.
Per order, the figures worth keeping are the gross sale amount and the shipping charged to the buyer, kept in separate columns rather than combined — shipping income and item revenue behave differently and a tax professional will generally want to see them apart. A monthly total of both, recalculating itself as you add rows, is enough; you don't need a running annual figure updated by hand if each month already totals correctly and a year view sums them.
Etsy fees deserve their own category, separate from your own expenses
It's tempting to lump Etsy's fees in with your other costs under one "expenses" total, but fees and expenses are answering different questions. Etsy's fees — listing fees, transaction fees, payment processing — are the cost of selling through the platform, and they scale with your sales. Materials, postage you bought yourself, packaging, and marketing are the cost of making and shipping the product, and they don't necessarily move in lockstep with sales the same way fees do. Recording Etsy fees as their own expense category, alongside but distinct from materials or packaging, is what lets you see how much of your revenue the platform itself is taking versus how much your production costs are taking — two very different numbers that a single blended expense total hides.
One practical note: Etsy's fee rates and structure change, and any figures you keep for reference should be checked against Etsy's current fee schedule rather than assumed from memory. The fee amount that actually matters for your books is the one on each order's own statement, not an estimate.
What a monthly log won't do for you
Worth being direct about this before it becomes an assumption you're relying on. A straightforward monthly sales-and-expense log doesn't pull your Etsy CSV in automatically — you're typing the figures in yourself, using the CSV as your source. And logging a gross sale amount and a materials expense category separately isn't the same as calculating cost of goods sold per item; a simple log gives you accurate totals for revenue and for expenses, but it won't tell you the profit margin on any one product unless it's specifically built to match costs to individual sales. If per-item profitability is what you're after, that's a different kind of tool than a monthly bookkeeping log, and it's worth checking which one you actually have before tax season arrives and you're expecting a number it was never built to produce.
Reconciling your log against Etsy's own numbers
A log is only useful if it actually matches reality, and the way to check that is a spot-check, not a full audit every month. Pick a handful of orders from that month's CSV export and confirm the gross sale, shipping, and fee amounts in your log match what Etsy's statement actually shows for those same orders. This takes a few minutes and catches the two most common problems early: a figure typed in wrong, or an order logged in the wrong category. Finding either while it's one row is a quick fix; finding either in April, buried in a year of entries, is a much longer afternoon.
Etsy's own statements are the source of truth in this relationship. If your log and Etsy's numbers disagree on a specific order, trust the statement and correct your log, not the other way around. For a deeper monthly reconciliation routine — including checking that gross sales minus fees minus refunds actually matches what hit your bank account — see our guide on Etsy shop bookkeeping, the monthly routine. To sanity-check what a single sale's fees should look like before you enter it, the Etsy fee & profit calculator runs the math on one order at a time.
Turning twelve months of logs into a year-end handoff
If sales and expenses have been logged monthly all year, the year-end step is almost mechanical: total gross sales across all twelve months, total shipping charged, total each expense category including Etsy fees, and subtract expenses from revenue to get a net figure. That's the number, along with the category breakdown behind it, that goes to a tax professional — not a shoebox of statements, not a request to reconstruct the year from memory. The difference between a stressful tax season and a boring one is almost entirely whether that totaling happened gradually across twelve months or all at once in a rush.
What this doesn't cover
This is a guide to organizing Etsy shop records, not a guide to filing taxes. What counts as taxable income, what's deductible, how sales tax collected by Etsy on your behalf should be treated, and how a shop should be structured for tax purposes all depend on rules that vary by where you live — none of which a spreadsheet or this article can tell you. Keep clean, monthly, reconciled records and bring them to a qualified tax professional; deciding how the numbers get reported is their job, not a bookkeeping habit's.
Frequently asked questions
What records does an Etsy seller actually need at year end?
Four things, organized and totaled: gross sales by month, shipping charged to buyers, Etsy fees by type, and your own business expenses by category. Add those up correctly and you have revenue, fee costs, and expense totals ready to hand to a tax professional. What most sellers are missing isn't the underlying data — Etsy's statements have it — it's a place where all four have already been organized and totaled instead of sitting as raw exports.
Does a bookkeeping spreadsheet import my Etsy CSV automatically?
Not unless it specifically says so — a plain monthly log with sales and expense rows is something you type into by hand, using Etsy's CSV exports as your source data, not a tool that reads the CSV in for you. That's a meaningfully different workflow than an automated import, and it's worth knowing which one you have before you're relying on it in a busy month.
Does this kind of tracker calculate cost of goods sold per item?
Not automatically, in most simple sales-and-expense trackers — check the one you're using. A typical setup logs gross sale amount and shipping charged per order, and materials or supply costs as a separate monthly expense category, rather than matching a specific cost to a specific item sold. That gives you accurate revenue and accurate total expenses, but not a built-in profit margin per product; if you need that, look for a tool that explicitly does per-item costing.
Why record Etsy fees as their own category instead of folding them into expenses?
Because fees and expenses answer different questions. Fees are the cost of selling through the platform — listing, transaction, and payment processing charges — and they scale with your sales. Materials, postage, and packaging are the cost of making and shipping the product. Keeping them in separate categories, even though both reduce your profit, is what lets you see your actual take-home per sale versus your cost to produce, rather than one blended number that hides which side is eating your margin.
How do I reconcile a monthly log against Etsy's own numbers?
Pick a handful of orders from Etsy's CSV export each month and check that the gross sale amount, shipping charged, and fee amount in your log match what Etsy actually shows for those same orders. A quick spot-check catches a mistyped figure or a category mix-up while it's one row to fix, rather than a full year of numbers you have to untangle later. Etsy's own statements are the source of truth here — your log should match them, not the other way around.
Is a monthly sales-and-expense log enough to file my Etsy shop's taxes?
No. It's the organized record that makes filing possible, not the filing itself. What counts as income, what's deductible, and how an Etsy shop should be reported all depend on rules that vary by where you live and how your shop is structured — none of which a spreadsheet knows. Bring your organized totals to a qualified tax professional and let them handle how those numbers actually get reported.
Want twelve months of this already laid out?
The Etsy Seller Bookkeeping Toolkit includes a Seller Bookkeeping Tracker with twelve monthly tabs (Jan–Dec), each with its own Sales section (date, order #, item, quantity, gross sale, postage charged) and Expenses section (date, vendor, category, amount, notes) across eight editable categories including a dedicated Etsy Fees category. Each month totals itself, and a Year Dashboard rolls all twelve into revenue, expenses, and net by month, plus a category breakdown, your best month by net and by revenue, and your highest-expense month — all without manual math. Worth knowing plainly: you enter the figures yourself from Etsy's CSV exports; it doesn't import them automatically, and materials costs are tracked as a monthly category total, not matched item-by-item to specific sales. Alongside it: an Order & Inventory Tracker and a Fee & Profit Calculator for checking a single sale.
One-time purchase. No subscription. It's a set of spreadsheets — not tax software, and not tax advice.
Need a spreadsheet built around your exact business instead? We build custom workbooks to order — delivered in 5 business days.