How I Track My Etsy Finances in One Simple Spreadsheet
Let’s be real — bookkeeping isn’t the fun part of running an Etsy shop.
When I first started selling, I had sales coming in, fees going out, receipts piling up, and zero clue how much money I was actually making. Sound familiar?
Between Etsy fees, shipping, materials, and random business expenses, my finances were all over the place — until I created one simple spreadsheet to track everything in one place.
If you’re an Etsy seller looking for a no-fuss way to stay organized, this post is for you.
Why I Ditched Complicated Tools
I tried using free apps and even a full accounting software, but they were:
Too complicated
Not Etsy-specific
And honestly? Overkill for a small handmade business
I needed something beginner-friendly that showed me:
What I was earning
What I was spending
And what I owed in taxes
So I built my own solution — and now I use it every single week.
What I Track in My Etsy Spreadsheet
Here’s everything I track (with automatic formulas doing the hard work):
Income – All Etsy sales, including item price, shipping, and taxes collected
Etsy Fees – Listing fees, transaction fees, payment processing
Expenses – Materials, packaging, postage, software, advertising
Profit – How much I actually keep after all expenses
Quarterly Tax Estimator – So I’m never surprised during tax season
It’s not just a spreadsheet — it’s my sanity saver.
How It Helped My Business
After I started using this, I felt so much more in control. I could:
Price my products more accurately
Prep for taxes without panic
Make smarter decisions about sales and free shipping
Actually pay myself without wondering if I could afford it
Want to Use the Same Spreadsheet?
I bundled it all into the Etsy Seller Bookkeeping Bundle, so you don’t have to start from scratch. It’s plug-and-play — just open the spreadsheet, follow the instructions, and start tracking everything like a pro.
👉 Get the Etsy Seller Bookkeeping Bundle here
It’s beginner-friendly, completely customizable, and comes with a video tutorial to walk you through setup.
Bonus Tip: Pair It with the Etsy Profit Calculator
If you want to go a step further, I also use my Etsy Profit Calculator to test pricing and see my true profit per product. It’s only $5 and a game-changer if you want to price smarter.