Etsy Seller Bookkeeping Spreadsheet | Profit & Fee Tracker for Google Sheets & Excel
This Etsy seller bookkeeping spreadsheet shows your real profit after every Etsy fee, label, material and expense, and turns Etsy's monthly statement CSV into a checked, tax-ready P&L.
✦ WHAT'S INCLUDED
• Bookkeeping spreadsheet (.xlsx), example version with a full sample year (329 orders)
• Blank version (.xlsx), all formulas ready
• Step-by-step PDF guide for Google Sheets and Excel
✦ FEATURES
• Dashboard: gross sales, Etsy fees, net profit, margin, orders, average order, tax set-aside and fees as % of sales
• Every Etsy fee per order: listing/renewal, 6.5% transaction, payment processing and Offsite Ads, from editable 2026 rates
• Cost of goods fills in automatically from your product cost list
• Etsy monthly statement CSV import: amounts read, grouped and health-checked for bad pastes and duplicates
• Fee reconciliation: what Etsy actually charged vs. what your orders predict, month by month
• Monthly P&L, quarterly estimated-tax set-aside with IRS due dates, and a mileage log
• Top 5 products by real net profit, expenses by tax-style category, goal tracker and charts
• Sales tax Etsy collects is tracked but kept out of profit
• Room for 500 orders, 400 expenses, 200 trips and 600 statement lines
✦ WHY IT'S DIFFERENT
• Fee reconciliation and a statement health check, not just a fee calculator
• Quarterly estimated tax, mileage and top products in one file
• A complete sample year so you can see every feature working
• Both Google Sheets and Excel, no macros, no subscription
✦ HOW IT WORKS
1. Buy and download your files instantly after checkout.
2. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it in Excel.
3. Follow the Start Here tab. Everything else calculates.
✦ GOOD TO KNOW
• Instant download: nothing physical is shipped.
• Works in Google Sheets (free) and Microsoft Excel 2016+ / Microsoft 365 / Excel for the web. Not compatible with Apple Numbers.
• Works on desktop and in the Google Sheets and Excel phone apps (a computer is easiest for setup).
• No macros. Example and blank versions included. Licensed for one person or one business.
• Record-keeping and planning tool, not tax, legal or financial advice.
• Questions? Message me. I usually reply within a day.
© SageAndSheets. Please do not share or resell. Because this is a digital download, refunds aren't offered, but if anything isn't working, message me and I'll make it right.