Etsy Bookkeeping Spreadsheet Google Sheets: Etsy Seller Profit Tracker

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.

Who this etsy bookkeeping is for

Made for Etsy and handmade sellers who want to know their real profit after Etsy fees, shipping labels and supplies, and who want tax time to take an afternoon instead of a weekend.

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 to use it

1. Buy once from Etsy, Gumroad or Payhip and download the files instantly.
2. Open the example version first to see the template filled in, then use the blank version for your own details.
3. Upload the .xlsx to Google Drive and open it with Google Sheets, or open it directly in Excel.
4. Follow the PDF guide; formulas update totals, dashboards and alerts as you type.

Frequently asked questions

Can I import my Etsy sales?

Yes. Paste in the CSV you download from your Etsy shop and the fees, net income and monthly profit and loss calculate on their own.

Is this tax advice?

No. It organizes your income and expenses into a clear, tax-ready summary you can hand to your tax preparer.

Does it work in Google Sheets and Excel?

Yes. Every spreadsheet opens in Google Sheets (free) and Microsoft Excel. A step-by-step PDF guide is included.

Is anything shipped?

No. It's an instant digital download, available right after purchase.