MarginGuard — product cover

Category: Spreadsheets · Financial Spreadsheets

About this product

Know your true margin on every SKU, on every channel — before you list it.

BUILT FOR

  • Sellers listing the same products on multiple channels and guessing at margins
  • Anyone who has ever sold "profitably" on paper and lost money after fees, shipping, returns, and ads

HOW IT WORKS

  • Verify your real channel fees and type them into FEE_SETUP; set your target.
  • Add your SKUs — fees, landed costs, profit, margin, and flags compute live.
  • Use the Solver to price below-target SKUs correctly, and COMPARE to pick the right channel per SKU.

FEES ARE YOUR INPUT, NOT OUR PROMISE

Fee schedules change constantly and vary by category. Every fee figure in the setup sheet is an editable starting default — the calculator logic is the product. Always verify the current official fee schedule for your channel and category.

NO EARNINGS PROMISES

MarginGuard is a planning calculator, not financial advice. All sample data is fictional.

INSTANT DOWNLOAD — XLSX + guide. Yours to use in your business, unlimited SKUs.

What's included

  • A 6-sheet calculator workbook (FEE_SETUP, SKU_MARGIN, SOLVER, COMPARE, DASHBOARD, README) — no macros, works in Excel, Google Sheets, and LibreOffice
  • Fee tables for 4 channels (Etsy-style, Amazon-style, eBay-style, own store), all as editable inputs: referral/transaction %, fixed per-order fee, payment processing % + fixed, listing fee
  • SKU sheet with channel dropdowns: total fees, landed cost build-up, net profit $, margin %, and an ABOVE/BELOW TARGET flag on every row
  • Price Solver: enter any SKU's cost stack + channel + target margin and get the required selling price by closed-form math, with a check row that proves the margin closes — or the honest "NOT ACHIEVABLE" when no price can reach it
  • Channel Compare: one SKU costed across all four channels side by side, with a BEST flag on the most profitable channel
  • Dashboard: SKU count, below-target count, average margin by channel, best and worst SKU by profit dollars
  • 12 fully worked fictional sample SKUs (4 below the 30% target) so you see every feature live before you type a single number
  • Quick-Start Guide PDF: the 20-minute setup and the 5-minute weekly routine

Key features

  • True margin per SKU per channel → total fees, landed cost, net profit $, and margin % computed live on every row
  • ABOVE/BELOW TARGET flags → every SKU row is flagged against the target margin you set
  • Price Solver → required selling price by closed-form math, with a check row proving the margin closes (QA sample: solves to $41.85 and checks at 30.007% — HITS TARGET)
  • Honest NOT ACHIEVABLE → when no price can reach the target, the solver says so instead of inventing a number (proven in QA)
  • Channel Compare → one SKU across all four channels side by side, BEST flag on the most profitable
  • Dashboard → SKU count, below-target count, average margin by channel, best and worst SKU by profit dollars
  • QA-verified → 118/118 checks passed against an independent Python model + LibreOffice recalc, 0 error cells

Frequently asked questions

Are the channel fees in the workbook the official rates?

No — every fee figure in the setup sheet is an editable starting default. Fee schedules change constantly and vary by category; always verify the current official fee schedule for your channel and category.

What does the Solver do when a target margin can't be reached?

It returns "NOT ACHIEVABLE" — it will not invent a price that doesn't close.

Is this financial advice?

No — MarginGuard is a planning calculator, not financial advice.

Are the sample SKUs real products?

No — all 12 sample SKUs, names, and numbers are fictional, included so you can see every feature working.

Does it use macros?

No — no macros; it works in Excel, Google Sheets, and LibreOffice.

MarginGuard — product image

MarginGuard

A 6-sheet Excel calculator with editable fee tables for 4 channels, per-SKU fees, landed cost, profit and margin with ABOVE/BELOW TARGET flags, a price solver that tells you the required price — or honestly says NOT ACHIEVABLE — and a side-by-side channel compare.

$29

Buy Now on Gumroad

Related products

More Spreadsheets
Landlord Finance OS — product image
Spreadsheets

Landlord Finance OS

Stop drowning in one-spreadsheet-per-property chaos. Track rent, expenses, and cashflow for up to 10 properties — and turn your year into a CPA-ready tax packet mapped to IRS Schedule E lines. Works in Excel & Google Sheets.

BRRRR Deal Analyzer — product image
Spreadsheets

BRRRR Deal Analyzer

Know your numbers before you buy. This BRRRR spreadsheet computes cash left in the deal, refinance proceeds, cashflow, cash-on-cash return and cap rate — and compares 3 deals side by side. 4 sheets, live formulas, 3 sample deals. For Excel, Google Sheets & LibreOffice.