Your bank ping says the deposit landed. It feels like a win. Then ads renew, a refund hits, packaging costs show up, and the leftover is thinner than the payout screen promised. Deposit scheduled is not the same as true profit.
This guide is for Etsy sellers and local shop owners who confuse cash-in with what they actually keep after fees, cost of goods, ads, refunds, and mileage. You will leave with a weekly money sitting, a short scorecard, and a clear line between invoice collections and leftover profit. For DIY worksheets, see our Products page.
Why payout screens lie by omission
Payout tools answer one question: money moved. They do not answer whether that money covers product cost, platform fees, shipping labels, returns, ad spend, or the drive to a vendor. Owners who spend every deposit like take-home pay discover the shortfall at tax time or when inventory restock fails.
Local shops hit the same trap with cash and card batches. A busy Saturday feels rich until supplies, wages, and processor fees are counted. Etsy sellers see listing fees, transaction fees, offsite ads, and refunds stacked on top of COGS. Mixed sellers (online plus storefront) get two incomplete pictures and no single leftover number.
Separate three money jobs
Keep these lanes distinct so one tool does not pretend to do all three:
- Collections: invoices sent, deposits taken, aging, and getting paid for finished jobs
- True profit: revenue minus fees, COGS, ads, refunds, and operating costs you actually paid
- Tax set-aside: a jar percentage you move aside from collected cash (not filing advice, just a habit)
Collections answers “who still owes me.” True profit answers “what did I keep.” Mixing them is how unpaid invoices look like profit and how paid invoices hide a loss after fees.
A 15-minute weekly money sitting
Pick one weekday and the same 15-minute slot. Phone on Do Not Disturb. Open last week’s sales and one expense source (bank export, processor, or Etsy statements).
- Log gross sales for the week (Etsy orders and local cash or invoice rows in the same place)
- Estimate or paste platform fees on marketplace rows; skip those fees on pure cash jobs
- Add COGS for units sold, not units bought “just in case”
- Add ads, refunds, shipping overages, and mileage at your chosen rate
- Write the leftover and the margin on a one-line scorecard
If the leftover is negative two weeks in a row, stop guessing. Raise price, cut a weak SKU, or pause ads that do not cover their cost. Visibility work on Maps still matters, but a shop that sells below true cost cannot advertise its way to health.
Scorecard fields that keep owners honest
Use a simple weekly card you can fill without a CPA:
- Gross revenue this week
- Marketplace fees (or zero in local-only mode)
- COGS for units sold
- Ads + refunds + shipping overages
- Mileage and other out-of-pocket ops
- Net leftover and margin percent
- Tax set-aside moved to a separate account or envelope
Trend the margin for four weeks. A single good deposit week can hide a thin margin story. Four weeks of thin margins is a product or pricing problem, not a motivation problem.
Etsy mode vs local-shop mode
On marketplace rows, fee estimates belong next to the order. Confirm rates against your own statements. Starter estimates drift. On local cash and invoice rows, skip marketplace fees and still log COGS, ads, refunds, and mileage. Mixed shops should tag each row so the dashboard can show marketplace profit and storefront profit without blending them into one fake average.
Never treat an Etsy “deposit scheduled” email as the weekly profit number. It is a transfer notice. Profit is what remains after the costs that made those sales possible.
Common ways shops fake themselves rich
Watch for these patterns in your own numbers:
- Counting a deposit that still has an open refund window
- Ignoring packaging, labels, and “small” supplies because they feel too minor to track
- Booking ad spend as brand building with no weekly leftover check
- Treating inventory purchases as profit because the shelf looks full
- Skipping mileage because the van “was going that way anyway”
None of those habits require bad intent. They require a quiet worksheet that makes the leftovers visible. Once the scorecard is boring and weekly, the drama drops. You either keep the SKU, raise the price, or stop feeding ads that never recover.
What this is not
A true-profit worksheet is not QuickBooks, not a CPA engagement, not tax advice, and not Etsy’s official fee calculator. It is an owner habit with formulas you can see. No kit can guarantee you are profitable. Fee rates change. Confirm them. If you need filings or formal books, hire a professional. Public contact for product questions is [email protected] only.
Pair profit with visibility without mixing the tools
Shops that show up on Maps still need honest leftover math. Keep your Google Business Profile, reviews, and phone stack working so demand arrives. Keep profit tracking separate so that demand does not celebrate a loss. Owner AI can help you draft a weekly money note as a secretary. It should not answer the shop phone or act like a DID receptionist.
Where to get the worksheets
If you want a printable binder plus a spreadsheet with working formulas for Etsy, local, or mixed mode, the True Profit Tracker is on Gumroad ($11). Browse the full set of local-shop systems on Products. Instant download. Worksheet and SOP style. Not a live bookkeeping service.
Bottom line
Celebrate deposits after you subtract the costs that created them. Run a short weekly sitting, keep collections and true profit in separate lanes, and fix thin margins before you buy more ads. Clear leftover math is how a visible shop stays open.
Leave a Reply