Bookkeeping guide for Etsy sellers
Etsy Bookkeeping for Sellers — a Monthly Routine, Not a Second Job
Bookkeeping for Etsy sellers is one small, ongoing job: every month, write down what came in, what Etsy took, and what you spent — so that when tax season asks, the numbers already exist. Done monthly it takes about half an hour. Left to January, it takes a weekend and a shoebox.
This page is general education, not accounting or tax advice. How you file is a decision to review with a qualified tax professional.
What Etsy bookkeeping actually is
It is the record-keeping underneath your taxes: a running note of sales, fees, and spending, kept while each month is still fresh. It is not the tax return itself.
Think of it as two halves. Etsy records its half automatically — every sale, every fee, every payout. The other half — what your materials cost, what you paid for postage and packaging, what’s sitting on your shelves — exists only if you write it down. Bookkeeping is joining those two halves monthly, so that year-end jobs like your Schedule C cost of goods sold are arithmetic, not archaeology.
What Etsy records for you — and what only you can record
Etsy keeps this half
- Every sale, and what the buyer paid — in your Orders and Order Items downloads.
- Every fee it charged you, totalled in the monthly statement.
- Your payouts — the deposits it sent your bank, and when.
- A 1099-K at year end, if your sales pass the reporting threshold.
Only you can record this half
- What your materials cost — Etsy never sees a single supply receipt.
- Postage and packaging you bought anywhere other than Etsy’s labels.
- What’s on your shelves — the inventory counts your taxes turn on.
- Mileage, market fees, subscriptions, studio costs — the small stuff that adds up.
The categories worth tracking
Six buckets cover nearly every dollar in a small Etsy shop. The names matter less than using the same ones every month.
SIX BUCKETS — EVERY DOLLAR LANDS IN ONE
Same buckets, every month
Money in
Gross sales — what buyers paid, before any fees — plus refunds you gave, kept as their own line so the two never blur.
Etsy fees
Listing fees ($0.20 an item), the 6.5% transaction fee, payment processing (3% + $0.25 an order), and ads if you run them. Your monthly statement already totals these.
Materials & supplies
Everything that becomes the product, plus the supplies used up making it. This is the half Etsy never sees — and the half your taxes turn on.
Shipping & packaging
Postage you bought, boxes, mailers, labels, tissue. What you charged buyers for shipping is income; what you spent is a cost. Track both.
Running the shop
Tools and equipment, software and subscriptions, listing photos, market and craft-fair fees.
Space & travel
Mileage to suppliers and the post office, and a home-studio share of costs if you claim one. A dated note beats a January guess.
How payouts, fees and the 1099-K fit together
Three numbers that confuse sellers every year, because they’re all “what I made” — and all different.
Your payout is the gross, minus Etsy’s fees, minus refunds, minus any shipping labels bought through Etsy — and it arrives on Etsy’s deposit schedule, not sale by sale. Your 1099-K is the gross before any of that comes out, which is why it will always be the biggest of the three numbers. Your books need all of them: gross income, fees as their own line, and the deposits that actually landed. For the fee math itself, order by order, use the batch Etsy fee calculator.
How to do bookkeeping for Etsy: the monthly checklist
Six small jobs, once a month, about 30 minutes. This is the entire routine — everything else is year-end, and year-end gets its own section below.
THE MONTHLY ROUTINE
≈ 30 minutes
1. Download the month’s Etsy files
Your Orders and Order Items CSVs, and save the monthly statement — the fees live in the statement, not in the order files.
2. Match the payouts to your bank
Gross sales − fees − refunds should equal what actually landed. If it doesn’t, find out why this month, while the orders are still familiar.
3. Log every material purchase
Date, supplier, what it was, how much. Receipts go in one folder — a shoebox is fine, a phone photo of each receipt is better.
4. Log postage and packaging you paid for
Anything bought outside Etsy’s labels never appears in Etsy’s files. If you don’t write it down, it doesn’t exist at tax time.
5. Note refunds and discounts
A line each, with the reason while you still remember it. Refunded money is not income, and your records should say so plainly.
6. Jot a rough inventory note
What big materials came in, what’s running low. Not a count — just a note. The one real count happens on December 31.
Spreadsheet, software, or a one-sitting report?
Three honest ways to handle the same job. They’re good at different things, and one of them is ours — so here is what it deliberately does not do.
A spreadsheet
Free, fully yours, and exactly as good as the habit behind it. You are the system: every month you type, sort and total. For a small shop that keeps the routine above, it is genuinely enough — most “bookkeeping templates” are just this, with nicer formatting.
Bookkeeping software
An ongoing system — running books, often live inventory — for a monthly subscription. It still has to be fed every purchase and sale; it organises the work rather than removing it. The right buy when you need stock counts or sell across many channels, as our honest comparison spells out.
This kit — the finish, not the books
Seller Profit Rescue is not bookkeeping: it tracks nothing month to month and keeps no ledger. What it does is the year-end finish — take the Etsy files and cost spreadsheets your routine produced, and turn them into the Schedule C worksheet, your true profit per product, and the prices you need when costs rise. One sitting, one-time price.
Etsy bookkeeping questions, answered straight
Kept the records all year? Get the finished numbers
Your monthly routine produces the files. The kit turns them into your Schedule C cost of goods sold worksheet, a true profit ranking of every product, and the new price each one needs when material costs rise — one sitting, pay once, files never leave your computer. Start with the free preview:
Join the launch list for the $59 launch price: