A 30-minute monthly routine for Etsy bookkeeping

Updated September 14, 2026 · 6 min read · Sources checked on publication

Etsy bookkeeping is not hard, it is just easy to postpone — and postponing changes its nature. Done monthly it’s half an hour of mechanical work. Done once, in April, for twelve months at once, it becomes a lost weekend of reconstructing what happened, with receipts missing and details forgotten.

The routine

1. Download the two files (5 minutes)

Etsy splits what you need across two exports, and you need both:

• The Orders CSV — what sold, when, for how much, and what you charged for shipping.
• The monthly statement — what Etsy actually charged, fee by fee. In Shop Manager: Finances → Monthly statements → View all monthly statements, choose the month, and Generate CSV. Etsy emails you when it’s ready.

The statement matters most, because it’s the only record of real fees rather than estimates, and it’s the document your largest deduction rests on. It’s also the one people forget, then have to chase twelve of.

2. Record the month’s numbers (10 minutes)

Revenue, fees by type, shipping labels, refunds. Three rules that prevent most errors:

• Never sum a single statement column. Sales sit in Amount and fees in Fees & Taxes, so adding one alone produces a meaningless figure. This is the most common mistake by a distance.
• Exclude Deposit and Payment rows. They’re transfers of money already counted; including them double-counts.
• Keep sales tax out of revenue. For US orders Etsy collects and remits it on your behalf — it was never yours.

The statement guide explains every row type if a line looks unfamiliar.

3. Add what Etsy doesn’t know (10 minutes)

Materials, packaging, equipment, subscriptions, anything bought for the shop. This is the part no export contains and the part most often under-claimed — not through carelessness but because receipts scatter.

The habit worth building is photographing a receipt when you buy, not filing it later. The checklist of what belongs here is in hidden shop expenses.

4. Note the things that will confuse you later (5 minutes)

A sentence per oddity. A refund issued this month for a sale two months ago. A material price that jumped. A month where you were away. In April, these notes are the difference between an explanation and an afternoon of detective work.

Refunds especially: they land in the month they were issued, not the month of the sale, which is the single most common reason a month looks wrong — and at year end it’s the reason a December sale and its January refund straddle two tax years.

Don’t reconcile to the penny

A month’s statement will not tie out exactly against that month’s orders, and chasing that is the most common way people give up on bookkeeping. The reasons are structural rather than mistakes: refunds cross months, listing renewals lag the sales that caused them, some sales haven’t cleared, and sales tax passes through without ever being yours.

Treat a single month as directional and the year as authoritative. If a month looks strange, check for a refund from a previous month before assuming you’ve made an error.

The quarterly addition

Once a quarter, spend an extra twenty minutes on the question the monthly routine doesn’t answer: which products actually earned?

Bookkeeping tells you what the shop did. It doesn’t tell you which of your products deserves next quarter’s materials and hours — and those are different questions with different answers, because a shop total blends a product earning $14 a sale with one earning $1. The bestseller problem covers why the blend misleads.

Also worth a quarterly glance: your fixed costs. Subscriptions accumulate, and each one is a number of extra orders you have to pack every month to pay for — break-even makes that concrete.

Why monthly, specifically

Three reasons, in increasing order of importance. Statements are easier to generate while you remember which month you need. Receipts are still findable. And most importantly, a monthly number is early enough to act on — you can change a price in March because February told you something, which is not available to someone who finds out in April of the following year.

MakerMargin does the mechanical half of this from the two files Etsy exports — matching per-order fees to their orders, keeping shop-level costs at shop level, applying your material costs, and producing a tax-ready year-end summary. The receipts and the notes stay yours.

Statement download steps, the two-column structure, and the treatment of sales tax for US orders are from Etsy’s help centre guidance on monthly statements and its Fees & Payments Policy, read 14 September 2026. This is general guidance on record-keeping, not tax or accounting advice.