Handmade Seller Payment Tracker

You're pulling in thousands a month but still can't tell if Tuesday's craft fair actually made you money after booth fees, card fees, and supplies.

Track real take-home pay across Etsy, craft fairs, and Shopify — so you always know your profit after every platform fee, booth cost, and payout cut.

Running a handmade business across multiple sales channels sounds like a dream — until you're staring at three different deposit amounts, a stack of market receipts, and zero idea which channel is actually making you money. That's exactly what this spreadsheet fixes.

**The Handmade Seller Payment Hub gives you three things immediately:**
- Your real take-home after Etsy fees, Shopify transaction cuts, and booth or market costs
- A clear view of every order and payout across all your channels in one place
- A running profit number you can actually trust — no accountant required

---

**WHO THIS IS FOR**

You're doing somewhere between $3K and $15K a month. You sell on Etsy, maybe at weekend markets or craft fairs, possibly through a Shopify store or local wholesale accounts. You're processing 50 to 200 orders a month and managing it all yourself. You're not broke — but you're also not totally sure whether you're actually building something profitable or just staying busy.

If you've ever deposited a week's earnings and thought "wait, that seems low," this template was built for your exact situation.

---

**WHAT'S INSIDE**

**Multi-Channel Order Log**
Every sale — Etsy, local market, Shopify, wholesale — goes into one unified tracker. Date, item, quantity, channel, sale price, and any associated fees. No more hunting through three apps to piece together last month's revenue.

**Fee Calculator by Channel**
Etsy charges listing fees, transaction fees, and payment processing. Shopify takes a cut depending on your plan. Craft fairs cost booth rental plus card reader fees. This hub accounts for all of it so your profit number is real, not optimistic.

**Payout Dashboard**
See every deposit — what it came from, what was deducted before it hit your account, and how it compares to your gross sales. Spot the gap between what you made and what you kept. That gap is where most handmade sellers are silently losing money.

**COGS Tracker**
Log your material costs per product or per order. Know your actual cost of goods sold so your margin math is accurate. A $40 sale with $22 in materials and $6 in fees leaves you $12 — this template shows you that clearly, every time.

**Monthly Profit Summary**
One tab rolls everything up: total revenue by channel, total fees, total COGS, and net profit for the month. Printable, shareable, and ready to hand to a bookkeeper or tax preparer if you ever need one.

**Craft Fair and Market Module**
Dedicated section for in-person sales. Log your booth fee, card processing costs, cash sales, and itemized inventory sold. Know your net for every single market before you even pack up your table.

**Wholesale and Custom Order Tracking**
Got boutiques or bulk buyers? Track those separately with net terms, deposit amounts, and balance due — so you're never chasing an invoice you forgot you sent.

---

**HOW IT WORKS**

This is a plug-and-play Excel and Google Sheets spreadsheet — no formulas to build, no setup beyond entering your sales channel names and fee rates. Every calculation is already wired in. You enter your orders, and the dashboard updates automatically.

Works in Microsoft Excel (all versions from 2016 onward) and Google Sheets. No macros, no VBA, no add-ons required. If you work from your phone or share access with a partner or VA, Google Sheets handles that seamlessly.

**Licensed for personal and single-business use only.**

---

**THE MANUAL ALTERNATIVE**

Right now, a lot of handmade sellers are doing some version of this: exporting CSVs from Etsy, saving Square or PayPal receipts, keeping a notes-app tally from the weekend market, and trying to reconcile all of it once a month in a spreadsheet they half-built themselves at midnight. That process takes hours. It produces numbers you're not fully confident in. And it means decisions — should I do that market again? Is Shopify worth the monthly fee? — get made on gut feeling instead of data.

This template replaces all of that with one clean system that takes about ten minutes a week to maintain.

At $27.99, it costs less than a single booth space at most local markets — and it tells you whether that booth space is worth booking again.

---

**INSTANT DOWNLOAD**

You'll receive your file immediately after purchase. Open it, enter your channel names and fee rates, and start logging today. Everything is pre-formatted and documented with instructions inside the file.

Questions? Message @bizgrid_co directly — we respond fast.

Perfect for: Etsy seller doing $3K–$15K/month across Etsy, local markets, and maybe a Shopify store — managing 50–200 orders monthly without an accountant

Why now: Etsy's 2024 fee stack (6.5% transaction + 3% + $0.25 payment processing + $0.20 listing + offsite ads up to 15%) means sellers routinely miscalculate true margins; rising competition forces tighter cost control and faster payout reconciliation to fund inventory restocks

✓ Instant digital download
✓ Works with Microsoft Excel (Mac & PC) and Google Sheets
✓ No technical skills required
✓ Formulas and calculations already built in

📋 LICENSE: Personal and single-business use only. This template may not be resold, redistributed, or used to create derivative products for sale.