What You Actually Need to Track Month to Month on Etsy
The Etsy Shop Worksheet Monthly is a spreadsheet template that pulls your shop's key metrics into one place so you can see what's happening without logging into Etsy Stats ten different times. The standard version tracks gross sales, transaction fees, payment processing fees, advertising spend, shipping costs, and net profit. Some versions break down traffic sources, conversion rates, and repeat customer percentage. The point isn't to look pretty. It's to catch problems early. I set up my first one in 2019 because I was flying blind. Etsy's native Stats page gives you numbers, but they're scattered across five different tabs and they don't calculate your actual take-home profit. I built a simple Google Sheet from scratch. It took about three hours. I've done it a dozen times since then for different shops, and each time I start with the same five columns and expand from there. Here's the practical setup. Open a blank sheet. Create these column headers in the first row: Date Range, Gross Sales, Transaction Fees, Payment Processing Fees, Etsy Ads Spend, Shipping Material Costs, Net Profit, Units Sold, Orders Filled, Average Order Value, and Conversion Rate. Fill in the data at the end of each month. The formulas are straightforward. Net Profit equals Gross Sales minus all fees and costs. Average Order Value is Gross Sales divided by Orders Filled. Conversion Rate is Orders Filled divided by Sessions from Etsy Stats.
Once you have three months of data, add a summary section below your main table. Calculate month-over-month growth for Gross Sales, Net Profit, and Units Sold. This tells you whether you're improving or just staying even while inflation eats your margins.
Where People Go Wrong
The biggest issue I see is that sellers track revenue but forget about platform fees until tax season. Etsy takes 6.5 percent transaction fees plus payment processing, which varies by country. In the US it's 30 cents plus 2.9 percent. If your item sells for $20, that's roughly $2 in fees before you even account for shipping or ads. When I first started, I thought my margins were healthy. They weren't. After I added the fee calculations to my worksheet, my actual profit dropped about 18 percent across the board. Another common mistake is not separating personal and business expenses. If you're shipping from home and using personal supplies, track those in your Etsy Shop Worksheet Monthly separately. A client of mine once mixed in $400 of household cleaning supplies with her shipping costs. Her profitability looked terrible for two months until she caught it. Put a dedicated row for non-Etsy business expenses and label it clearly.
Get the Full Details
My Favorite Setup for Scaling
After running multiple shops, I moved to a more detailed version. Instead of one row per month, I use one row per product category. This lets me see which categories are actually profitable versus which ones are just generating busy work. I also track returns separately. Returns in Etsy are messy because the platform doesn't make it easy to follow the money. When a buyer disputes a charge through Etsy's Purchase Protection program, the funds disappear from your balance and you don't always get a clean record of it. Here's a specific edge case I ran into last year. I sold a batch of hand-printed candles through an Etsy promoted listing. The ad spend showed up correctly, but Etsy's automatic refund for a disputed order wiped out the revenue without creating a matching expense line. My worksheet showed income but no corresponding cost. I solved it by adding a Disputed Refunds column and manually logging any order that went through the resolution center. It adds two minutes per dispute, but it keeps your net profit accurate. Without that column, you'll overstate your income by whatever percentage of orders get disputed, which in my experience has ranged from 2 to 8 percent depending on the product category. The other trick I use is a simple conditional formatting rule. If Net Profit drops below zero in any month, the row turns red. If it stays positive for six consecutive months, it turns green. It sounds trivial but it forces you to look at months you might otherwise skip when things seem fine on average. One month in 2022 had barely positive numbers that masked a 40 percent decline in conversion rate. The red flag would have caught it faster than my own judgment.
Download Options
There are free templates available from several Etsy sellers who specialize in shop spreadsheets. The ones that work best usually include preset formulas, auto-calculation fields, and instructions in the sheet itself. I recommend downloading a template and then modifying it to match your actual shop structure rather than using it as-is. Most free versions don't account for shipping material costs or disputed refunds, which are the two areas that cause the most inaccuracies. I also keep a simplified version I use for quick monthly reviews. It has twelve rows, one per month, and about eight columns. I fill it in during the last week of each month and it takes about twenty minutes. The detailed category-based version takes closer to forty-five minutes because I pull data from Shop Manager, Etsy Ads dashboard, and my own receipts. Use the simple version for ongoing tracking. Use the detailed version quarterly for deeper analysis.
When This Approach Falls Short
Spreadsheets don't scale past a certain point. If you're running three or more shops or your monthly order volume exceeds two hundred, manual entry becomes unreliable. You'll miss data, copy formulas wrong, or forget to update a column. At that level, I switched to connecting my Etsy Shop data to a tool like Databox or even a basic Python script that pulls from Etsy's API. The accuracy improvement is significant. The initial setup takes about six hours and requires some technical comfort. There's also the problem of historical data. If you already have an active shop with twelve months of sales, filling in your worksheet retroactively is tedious and often inaccurate because Etsy's export function doesn't give you perfectly clean data for every category you need. You'll have to dig through individual order emails and transaction PDFs. For shops that have been running longer than six months, I recommend starting the worksheet now and accepting that the first few months will have gaps. Don't try to force perfect historical entries. Focus on getting the current month right. The worksheet method works well for one-shop sellers making under five thousand dollars a month. Beyond that, the time investment starts to outweigh the clarity you get from it. But for the majority of Etsy sellers, it's the cheapest and most flexible way to actually understand what's happening in their shop each month.
