Etsy Seller Profit Tracker Spreadsheet - Bookkeeping Hub, Fee Calculator, Orders, Expenses & Dashboard for Google Sheets

Selling on Etsy is the fun part. Knowing what you actually made is the hard part. Between the transaction fee, payment processing, listing fees, shipping and what your items cost to make, the payout number Etsy shows you is not your profit. This bookkeeping hub logs every order and subtracts every fee for you - so you see your true profit, order by order, product by product, and on one simple dashboard.

- DASHBOARD - total revenue, total Etsy fees, total costs and expenses, net profit and net margin %, plus orders count and average order value, all pulled in automatically from the Orders and Expenses totals; set your own Tax Set-Aside % and the amount to set aside from your profit calculates itself
- ORDERS - every sale with date, item, sale price, shipping charged, shipping cost and item cost; the transaction fee (6.5% of price + shipping charged), payment processing fee (3% + $0.25) and listing fee ($0.20) calculate themselves per order, along with total fees and net profit per order (12 sample orders prefilled, room for more)
- PRODUCTS - each product with sale price, item cost, margin per unit and margin %, plus totals - spot the products that barely earn and reprice or retire them
- EXPENSES - every business cost with a category dropdown (Materials, Packaging, Shipping, Software, Marketing, Office, Fees, Other) and an automatic by-category summary powered by SUMIF, plus a grand total that feeds the Dashboard
- FEE CALCULATOR - price a listing before you publish it: type a price, shipping charged, shipping cost and item cost and see every fee, your net profit and your margin. Flip Offsite Ads to Yes for the worst case (simplified as a plain 15% of price + shipping charged; Etsy's per-order cap is ignored, so treat it as a worst-case estimate)
- START HERE - a 5-step setup guide with the full fee-rate legend used in this tracker (US default rates - check your own shop's rates in Shop Manager, as Etsy can change or vary them)

WHAT'S INSIDE (6 sheets):
- START HERE - 5-step setup guide + Etsy fee-rate legend
- DASHBOARD - your whole Etsy shop at a glance, fully automatic
- ORDERS - order log with every Etsy fee and net profit per order
- PRODUCTS - per-product price, cost and margin table
- EXPENSES - business expense log with dropdowns and SUMIF category summary
- FEE CALCULATOR - pre-listing profit and margin calculator, with Offsite Ads worst case

HOW IT WORKS: Download instantly, type in the yellow cells, everything calculates automatically. No spreadsheet skills needed - if you can type, you can run this.

WHAT YOU GET: 1 Excel file (.xlsx, 6 sheets), works in Microsoft Excel and Google Sheets. Instant download.

PLEASE NOTE: Digital download; no physical item ships. The file comes prefilled with realistic sample data (one small Etsy shop: 12 orders, $548.00 revenue, $57.46 in Etsy fees, $129.64 true profit, 8 products and 9 business expenses) so you can see every formula working - just type over it with your own shop's numbers.

Organizer only - not tax advice. This tracker helps you organize your Etsy income, fees and expenses, and the tax set-aside is a planning habit, not a tax calculation; talk to a qualified tax professional about your own situation.

FREQUENTLY ASKED QUESTIONS:

Q: I opened the spreadsheet in Google Sheets and it says "view only" - how do I edit it?
A: That happens with Google Sheets from time to time. Open the file, then in the top menu choose File, then Make a copy. The copy belongs to you and is fully editable. If it still won't open, try a computer or laptop instead of a phone, a different browser, make sure you're signed in to Google Sheets, and check that your Google Drive has space. Still stuck? Message me on Etsy and I'll help you sort it out.

Q: I can't download my purchase on my phone - what am I doing wrong?
A: Nothing - the Etsy app doesn't support downloading files. Open your browser (log out of the Etsy app first if it keeps redirecting you), sign in to Etsy, and download from your Purchases page on a mobile browser, or use a laptop or desktop. Once the file is saved you can open it on your phone any time.

Q: What exactly is a spreadsheet template?
A: It's a ready-made spreadsheet with all the formatting and formulas already built in. Download it, type in the yellow cells, and everything else calculates itself. Colors, headings and layout can be customized if you like, but you never need to touch a formula.

Q: Are these Etsy's current fee rates?
A: The tracker uses the US default rates: transaction fee 6.5% of (price + shipping charged), payment processing 3% of (price + shipping charged) + $0.25, and a $0.20 listing fee. Etsy can change or vary rates (for example by country), so check your own shop's rates in Shop Manager - the START HERE sheet shows exactly which rates this tracker uses.

Q: Can I return or exchange my purchase?
A: Because this is a digital download, returns and exchanges aren't possible once the file has been downloaded - you'll always keep access to it in your Etsy account. If you bought it by accident and haven't downloaded it yet, send me a message and I'll take care of it.

Q: Is it available in other languages?
A: Right now the planner is in English only.

*This digital product has been created with the assistance of AI Tools, then refined by me, the seller*