Etsy Seller Bookkeeping Tracker — sales, fees & tax set-asides for maker businesses (Excel + Google Sheets)

See your shop's real profit — not just your Etsy revenue.

Etsy Seller Bookkeeping Tracker is a single spreadsheet system for Etsy sellers, makers, and craft-fair businesses who want every dollar in one place without paying for accounting software.

WHAT'S INSIDE

Dashboard — income vs expenses by month (with chart), YTD profit, open and overdue wholesale/custom orders, and a full expense-category breakdown. All automatic.

Transactions — log every dollar with Type/Category dropdowns made for makers: craft materials, inventory resale, Etsy listing fees, transaction & processing fees, Offsite Ads, packaging, postage, craft fair fees, and more (Schedule C aligned).

Wholesale & custom order log — Draft/Sent/Paid status with automatic days-overdue counting, built for wholesale, consignment, and custom orders.

Mileage log — supply runs, post office trips, fairs; deductible value from your editable IRS-rate setting.

Quarterly tax estimator — a suggested set-aside per quarter from your own effective-rate estimate, so tax season never ambushes you.

Settings & guide — your rates, the category list, and a plain-English quick guide.

WHY YOU'LL LIKE IT

Zero setup: no macros, no add-ins, no accounts. Opens in Excel 2016+ and imports into Google Sheets in one click. Maker-ready categories out of the box — stop squeezing Etsy fees into "misc". Ships with clearly-marked sample data so you can see every report working before you type a thing — delete the sample rows and it's yours. New year? Duplicate the file and keep going. No subscription, ever.

YOU GET

Etsy-Seller-Tracker-v1.xlsx (the full system), quick-start guide (PDF included in the zip), single-user license (personal/business use; no resale).

HONEST NOTES

Brand-new product from a small template studio — v1.0. Spotted a bug or want a category added? Message us through Payhip and we'll fix it in the next update. Buyers get free updates to v1.x. Estimates in the workbook are plain math, not tax advice.