Etsy Bookkeeping HQ

$30

Your shop's money in one calm place — income, expenses, fees, monthly P&L and a tax-time summary.

Get it — $30

Secure checkout on Stripe. Instant download after payment. We currently sell to customers in the United States only.

Who we sell to

MockWren Studio sells to customers in the United States. Our workbooks calculate US sales tax and work in US dollars, and we are not registered for EU or UK VAT, so we do not currently sell into those markets. Everything we publish for free — the blog, the forum, every guide on the site — is open to read from anywhere.

#etsy bookkeeping #shop accounting #tax prep #profit and loss

FormatExcel · 6 sheets

AccessEveryone

DeliveryInstant download

Last revised2026-08-09 · v1.1

Details

Most shops keep their books in three places: the Etsy dashboard, a bank app, and a feeling.

Tax time is when that stops working.

What is inside

Income Log — every sale, with the fees already broken out
Expense Log — what you actually spent, in the categories a tax return asks for
Fee Auto-Calc — the fee maths runs itself, so a mistyped fee cannot quietly become a wrong profit
Monthly P&L — revenue, costs and profit by month, with the chart drawn for you
Tax-Time Summary — the totals in the shape your accountant asks for

2,226 formulas across six sheets. You type the sale; the workbook does the rest.

Why the numbers are right

The fee columns model Etsy's two different fee bases separately, which most templates do not. Rates are editable in one place and carry the page they came from.

What this is not

It is a bookkeeping tool, not tax advice, and it does not file anything for you. For filing questions, talk to a professional. That is stated inside the workbook too.

Who this is not for

If you have fewer than about ten sales a month, a notebook is genuinely fine. This starts paying for itself when the volume gets past what you can hold in your head.

What you get

One Excel workbook (.xlsx), six sheets, plus a read-me. Instant download. Works in Excel, Numbers and Google Sheets.

Also available in the Mockwren Etsy shop at the same price.

If a file will not open, or is not what this page described, email support@mockwrenstudio.com and it gets fixed or refunded.

What changed

2026-08-09Added the new bilingual thank-you note to the download. The previous one was written for Etsy buyers and asked for an Etsy review — something a customer buying here cannot do. v1.1
2026-08-02First release v1.0

Version1.1 Licence

One perpetual licence. Use it for your own business, on unlimited products and shops, for as long as you like. Commercial use included. You may not resell, share or redistribute the workbook itself.

Products are created in-house unless the product page says otherwise, and are for educational use. We make no income or performance claims — outcomes depend on your own effort and circumstances.