Books and stock, one file
An Etsy shop's money sits in three places: the orders file, the payment account and the bank, and a one-person shop squares them by hand. I built one workbook for the shop owner who does the books alone: sales, fees and refunds on one tab, stock that counts itself down from those sales, and a monthly profit you can hand straight to a tax return.
The question
this build answers
How do I keep my Etsy sales, expenses and stock in one place without paying for accounting software?
From the first trigger
to the finished job.
The working version, step by step.
Paste your orders into Sales
I set Sales up for one line per item sold. You type or paste the price, postage, discount, fees and any refund, and I made gross and net revenue formulas, so nothing else needs working out.
Map your Etsy download
The CSV mapping tab tells you which column of your Etsy download goes where. I checked every column name against live exports from my own shop, including the one catch: Etsy only puts the card processing fee in its order files, so the other fees come from your monthly statement.
Log what you spend
Expenses takes one line per purchase, with a category from a fixed list and the business share you claim. I made the category list strict, so every expense lands in the breakdown as well as in the monthly total.
Let stock count itself
Give each product the same SKU on Sales and Inventory, and I count the units sold from your orders. On hand, a reorder flag and the stock value update from there.
Match each payout to the bank
The Deposits tab puts what Etsy says it paid next to what landed in your account and shows any gap, so a missing payout shows up the week it happens.
Read the month and the tax year
Monthly summary builds twelve months of profit from the tabs above. The tax reconciliation page lays the year out the way a UK Self Assessment return asks for it and bridges your books to a US Form 1099-K.
The workbook, instant download
Etsy bookkeeping spreadsheet and inventory tracker: sales, expenses, stock, deposits and the tax year
I send the nine-tab workbook, a README with the weekly routine and a sources file. It is an instant download with nothing to install. If you would rather hand the setup over with your own figures already in it, message me from the order.
Open the bundle on EtsyChecked by recalculating it
Before listing it, I recalculated all 2,310 formulas across the nine tabs with a formula engine outside Excel, and none returned an error.
I then typed a sample shop into a copy: six orders, a refund, three expenses and three products. Every monthly figure came out the way I worked it by hand, including an April that shows a loss because of one large materials order.
A bug I found and fixed
My first build let you type a category that was not on the list. That expense counted in the monthly profit but disappeared from the category breakdown, so the two totals disagreed.
I changed the category and stock-type columns to accept only values from their lists, and Other covers anything that does not fit.
The parts that break
Etsy can rename a column. The mapping tab names the columns as they appeared in my own exports on 17 September 2026, and if yours differ, go by what the column means.
The tax page records the thresholds I read on gov.uk and irs.gov on 17 September 2026. Those figures change, so each one names its page for you to check against your own year.
Before you spend anything
The fit matters.
Who should not buy this
If you already keep your books in accounting software, I would stay with it. This is for a shop owner doing the books in a spreadsheet.
If you are VAT registered and need a VAT return, or you want a return filed for you, this workbook covers neither.
Yours to keep
What lands
on your desk.
- A nine-tab Excel workbook that opens in Numbers and LibreOffice and imports into Google Sheets
- Sales, expenses, inventory, deposits, monthly profit and a UK and US tax-year page, all linked
- A README with the weekly routine
- A sources file naming every tax figure and the page it came from
See the work
Open the proof.
Published case studies of running systems. Each links to the thing itself.
A few useful
answers.
Does it work in Google Sheets?
Import it through File, Import, Upload. Every formula in it uses a function Google Sheets supports, and I checked the results on a filled sample copy before I listed it.
Will it import my Etsy CSV automatically?
You paste the columns in yourself. The mapping tab shows which column of your Etsy download goes into each Sales column.
Is it tax advice?
It isn't tax advice. It lays your figures out the way a UK return and a US Form 1099-K ask for them, and names the government page behind every threshold.
Can I use it for another sales channel too?
Every sale has a channel column, so your own site or a second marketplace can sit alongside Etsy in the same file.
A little further down
the same path.
Related builds for the rest of your business.
Pricing an Etsy listing from what you actually keep
Read the build ↗
Logging receipts and business miles for an Etsy shop's tax year
Read the build ↗
Working out the true cost of a handmade piece, time and overheads included
Read the build ↗
Buying all 17 Etsy seller tools in one download
Read the build ↗
Tracking Etsy orders, dispatch dates and stock in one sheet
Read the build ↗
Getting a custom banner, logo and brand board for an Etsy shop
Read the build ↗Make this work for you
Your tools.
Your working version.
Want this built and handed over working? Tell me what your version needs to do. One line is enough to start.
Start a brief