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

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.

$100
What the buyer pays on a $100 sale, no shipping charged
$9.95
What Etsy takes: $6.50 transaction + $3.25 processing + $0.20 listing
$90.05
What’s left toward your payout — before refunds and shipping labels

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

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.

Plus once a year, on December 31: count what’s on your shelves, at cost. Why that count matters is the Schedule C worksheet guide’s whole subject.
Thirty minutes a month is roughly six hours a year. Rebuilding a year in January — from bank statements, email receipts and memory — takes most sellers longer than that, and produces worse numbers.

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

Little and monthly beats perfect and never. Once a month: download your Etsy order files and monthly statement, check that payouts match your bank deposits (gross − fees − refunds), log the month’s material purchases and any postage you paid outside Etsy, and file the receipts in one place. That routine — about 30 minutes — is the whole job for most small shops. At year end those records are what your Schedule C is built from, which is why they have to exist before January.
Yes — free templates are easy to find, and an honest answer about them: a plain spreadsheet you actually update every month beats expensive software you abandon by March. What a spreadsheet can’t do is the year-end heavy lifting — costing every product from your recipes, or reconciling a year of orders at once. Seller Profit Rescue isn’t a spreadsheet and there’s nothing to download: it runs in your browser, reads the Etsy files and cost spreadsheets you already keep, and turns them into finished reports in one sitting.
Most small shops don’t — not yet. Software earns its monthly subscription when you need live inventory counts, sell across several channels at once, or have someone else doing the books. If your real pain is narrower — “every January I rebuild the year from scattered files” — a monthly routine plus a one-sitting year-end finish covers it, for a one-time price instead of rent. When ongoing inventory is genuinely the problem, we say so plainly in our comparison with Stocksmith (formerly Craftybase).
Because they measure different things. The 1099-K reports what buyers paid — the gross, before Etsy took anything. Your deposits are what’s left after the fees (9.5% in percentage fees, plus the flat per-order charges), refunds, and any shipping labels bought through Etsy. The gap between the two numbers is expected, and your books should show both: gross income on one line, Etsy’s fees on their own line. What the 1099-K is not — your cost of goods sold — is a separate number again, covered on our Schedule C page.
Keep the order files and monthly statements Etsy gives you, your payout records, receipts for materials, postage, packaging and supplies, and your year-end inventory count. The IRS’s general guidance is to keep tax records for at least three years after you file the return they support — longer in some situations, which is a question for your tax professional. Digital copies are fine; “somewhere on a dead laptop” is not.
Monthly is the sweet spot: about 30 minutes while the month is still familiar, and problems surface while they’re small. Quarterly is the floor below which the receipts start winning. Once a year is how January becomes a lost weekend of archaeology — and the numbers you reconstruct from memory are the ones that stop matching your bank account.
No — plainly. It keeps no running ledger, tracks nothing month to month, and holds no inventory. What it does is the finish: it takes the files your bookkeeping produced — Etsy’s order exports and your own cost spreadsheets — and in one sitting turns them into your Schedule C cost of goods sold worksheet, a true profit ranking of every product, and the new prices you need when material costs rise. The monthly habit stays yours; the January scramble is what it removes.

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: