Etsy / Amazon FBA Profit Calculator

What you get

A single Excel workbook with five interconnected sheets that calculate true net profit per SKU after accounting for COGS, packaging, inbound shipping, marketplace fees, advertising spend, and a return reserve. The Assumptions sheet drives the entire model — update a fee rate once and every downstream figure adjusts automatically. A dedicated price floor formula on the Platform Margin sheet means you never accidentally list a product below break-even on either marketplace.

Who it's for

Solo sellers running an Etsy shop, an Amazon FBA operation, or both, who suspect their posted margins don't reflect what actually lands in their account. It's the right tool when SKU count or ad spend has grown past what a back-of-envelope calculation can honestly track — and before a bad reorder decision turns a thin margin into a loss.

What's inside

• Assumptions sheet — editable fee schedules for Etsy and Amazon FBA; change a rate once and all sheets recalculate without manual edits
• SKU catalog with cost inputs — one row per product capturing COGS, packaging costs, and inbound shipping
• Per-platform margin breakdown — side-by-side net profit per unit for Etsy and Amazon FBA, with an auto-calculated price floor for each SKU
• Ad spend integration — allocates advertising cost per unit so profit figures reflect actual paid-traffic overhead
• Return reserve — a configurable percentage that reduces realized revenue before profit is finalized
• Monthly P&L sheet — rolling cash-flow view across all active SKUs showing gross and net margin by month
• Reorder Calculator — restocking alerts driven by sell-through rate and supplier lead time, so inventory decisions are data-led rather than reactive

How to use it

Download the .xlsx file and open it in Excel or Google Sheets. Begin on the Assumptions sheet to confirm or adjust the platform fee rates that match your account tier, then populate the SKU catalog with your cost data. The margin, P&L, and reorder sheets calculate from there with no additional configuration required.