CoinsAndLedgers Seller Profit Hub 2026: Bookkeeping & Fee Calculator for Etsy Shops
Know exactly what you keep from every Etsy sale after EVERY fee. Paste your Etsy Sold Orders CSV into one cell. That's the whole import. Every order's real fee stack appears instantly: listing fee, 6.5% transaction fee, payment processing (including the sales-tax nuance most spreadsheets get wrong), Offsite Ads at your tier with the $100 cap, even currency conversion. ⚡ CSV IMPORT, NOT DATA ENTRY Copy your Etsy export, paste once, done. Column mapping is adjustable, so the import survives Etsy's CSV format changes. 💰 TRUE PER-ORDER PROFIT Fee base → every fee line → net revenue, per order and per month. A fee-mix chart shows where your money actually goes. 🏷️ PRICING CALCULATOR THAT WORKS BACKWARDS Forward: "what do I keep at $25?" Reverse: "what price puts $10 in my pocket per sale?" The reverse solver is exact: it handles all percentage fees simultaneously and auto-corrects when the Offsite Ads $100 cap kicks in. 🧾 QUARTERLY TAX ESTIMATE (2026 ENGINE) Self-employment tax with the 2026 wage base, QBI deduction with its cap, the new 2026 federal brackets, your state rate, right down to the quarterly payment and its due dates. Year View lays out your whole year in Schedule C line order. 📦 BUILT FOR REAL SHOPS • Per-listing COGS linked to orders by SKU (physical sellers) • Digital sellers: works with zero setup beyond Settings • Refund tracking, business-use %, meals at 50% • Expense categories mapped to Schedule C lines • "Uncategorized" safety net so no deduction silently disappears 📈 PRO EXTRA — FEE HISTORY TAB A 2024→2026 Etsy fee-rate table with change annotations, so you can see how the fee maze shifted and trust that this year's numbers are current. ✅ VERIFIED, NOT VIBES Every formula is tested against a reference engine with three full seller scenarios before release. 2026 fee rates and tax constants verified January 2026. And all of this lives on ONE settings tab, so a mid-year Etsy change is a one-cell fix. WHAT'S INSIDE • Google Sheets template (copy link the link: A free Google account is all you need) • Pro Fee History tab (2024→2026 rate history) • Quick Start PDF (productive in under 10 minutes) • FAQ PDF (the 10 questions everyone asks) REQUIREMENTS Free Google account. Built for US sellers filing Schedule C. Not compatible with Excel. NOTE Tax figures are planning estimates, not tax advice. This product was designed and engineered by me, with AI-assisted tooling used during development and testing.
Get it → nelsonwave32.gumroad.com