1 / 10Log your orders and the workbook works out every Etsy fee, your cost of goods and your profit, then shows your net profit month by month on the dashboard. Try a price in the calculator before you list.
- 7sheets in the workbook
- 2 filessample data + blank copy
- Excel + Google Sheetsno macros or add-ins
Everything inside Etsy Seller Tracker
Orders
Listing, transaction, payment processing and Offsite Ads fees on every sale, with the profit for each item.
Products
Cost per item (your time included), fees, profit and margin, plus a suggested price for your target margin.
Stock
Stock left for every product, a reorder level and a stock status that flags what to reorder.
Pricing calculator
Try a price and see the fees, your profit, your break-even price and the price that reaches your target margin.
Expenses
Log shop expenses with categories you can edit.
Dashboard
Revenue, fees, shipping labels, expenses and net profit by month, plus profit by product and where your fees go.
Fee settings
Every fee rate is a cell on the Settings sheet, so you can match your own country or a change in fees.
Your two files
- Workbook with a sample shopInksets_Etsy_Seller_Tracker.xlsx
- Blank workbook, ready for your shopInksets_Etsy_Seller_Tracker_Blank.xlsx
Both are .xlsx workbooks. Start with the sample copy to see how everything works, then use the blank copy for your own numbers.
The sheets inside
- Start Here
- Dashboard
- Settings
- Products
- Orders
- Expenses
- Pricing Calculator
7 sheets, starting with a Start Here guide that explains every step.
Four steps from payment to done
Pay, download the two files and open them in Microsoft Excel, or upload them to Google Sheets.
On the Settings sheet, check the fee rates and set your hourly rate and target margin.
Add your products with their costs, price and stock.
Log each order and your expenses. Everything else calculates.
Before you buy
We want you to know exactly what this workbook is and isn't.
Etsy is named only because this workbook is built around Etsy's seller fees. Not affiliated with or endorsed by Etsy.
- US seller fees are filled in: a $0.20 listing fee, 6.5% transaction fee, 3% + $0.25 payment processing and 15% Offsite Ads (up to $100 per order; the rate is 12% for some bigger shops, so change it if that applies to you). Fees change over time, so check the current rates and update them on the Settings sheet.
- Fees are estimates for your records. Your Etsy Payments account shows the exact amounts.
- White cells are for you to type in. Grey cells calculate automatically.
- Room for 150 products, 2,000 order lines and 600 expenses.
- For record keeping only. It is not tax advice.
- This is a digital download. Nothing will be shipped.
- Digital product: all sales are final. If anything doesn't work, email hello@inksets.us and we'll help.
Common questions
Does it work for shops outside the US?
Yes, once you change the fee rates on the Settings sheet to match yours. The filled-in rates are the US ones.
What if Etsy changes its fees?
Every rate is a cell on the Settings sheet. Type the new rate and every order and product updates.
Does it connect to my shop?
No. You type in your own orders and costs. Nothing connects to your shop or your bank.
Which programs does it work in?
Microsoft Excel and Google Sheets. The workbooks have no macros, no add-ins and no links to other files.
What do I get after I pay?
Two .xlsx files: a copy with sample data, so you can see how it works, and a blank copy to start with. You land on a download page right after payment, and we email you a link that works for 90 days.
Do I need an account?
No. You pay with Stripe Checkout, and the download page and the emailed link are all you need. We keep your email address and your order so the link keeps working.
How do I open it in Google Sheets?
Upload the .xlsx file to Google Sheets, then choose File > Save as Google Sheets. That gives you your own copy to edit there.
Can I get a refund?
It's a digital product with instant access, so all sales are final. If a file won't open or something doesn't work as described, email hello@inksets.us and we'll help. See our refund policy.
Can I share the files or use them for clients?
The files are for your own use. Please don't resell, share or redistribute them. See our terms.
I lost my download link.
Enter your email on the download page and we'll send the link again.
You might also like
Small businessBookkeeping + Invoices
Invoices, income, expenses and profit in one workbook.
Real estateRental Property Tracker
Properties, tenants, rent and expenses for every rental.
Personal financePaycheck Budget Planner
See what's left to spend from every paycheck.
Etsy Seller Tracker
See what you really keep from every sale. Instant download, no account, all sales final.