Product Margin and Profitability Calculator PRO
Calculate margin and profit after discounts, shipping, fees, ads and returns. Check the discount limit, ad cost limit and free-shipping threshold.
- Profit per order after fees, payments, ads and returns
- Safe discount, max ad cost per order, break-even ROAS and POAS
- Import up to 100 GA4 or marketplace rows and enter unit costs manually
Takes you to the order form: email, payment, file in your inbox.
After payment, we will email you a download link (Excel + PDF) to the address you provide.
- Secure Stripe payment
- Instant email delivery after payment
- Invoice on request
Inside version 2.4
Actual workbook views with the fictional example from the instructions. Open an image to read the details.
Revenue is up but cash is tight? Find where margin disappears.
In online sales, a long queue of costs sits between price and profit: platform fees, payment fees, packaging, shipping, ads and returns. A 20% discount can look harmless, but with typical margins you may need more than 50% extra sales volume just to earn the same amount.
This spreadsheet calculates the result after entered costs and shows: profit or loss, how much you can spend on ads and which discount is still safe.
What you can calculate
profit and margin per order after the costs included in the workbook
the price you need to hit a target margin
maximum safe discount and required sales uplift after a promotion
maximum ad cost per order plus break-even ROAS and POAS
the basket threshold where free shipping stops eating margin
profitability on Amazon, Etsy and other marketplaces
results for up to 100 sales rows after manually entered net unit costs
What is inside
Dashboard with results and decision checklist, basic calculator, full product profitability, target price, discount simulator, Black Friday scenarios, marketplace calculator, free shipping, ROAS/POAS, 20-SKU comparison, CSV import, manual starting points for 8 industries, A4 print report, glossary and sources. No macros: plain Excel, works in LibreOffice too.
Paste up to 100 rows and add costs
The import tab accepts a pasted CSV export, for example GA4 ecommerce purchase data or a marketplace settlement. Map columns and add net unit costs. Results include only those costs and revenue. One VAT rate applies to the set. Missing data in any active row blocks the summary.
Marketplace fees with source links
The package includes a fee cheat sheet for major marketplaces with source links and verification dates. Check the current fee for your category before making a pricing decision.
A report for your partner or accountant
The Report tab formats key metrics, assumptions and status on one A4 page. Add your company name, print or save as PDF.
You already use my free online calculator. Why PRO?
| Online calculator (free) | Calculator PRO (Excel) | |
|---|---|---|
| Margin, markup, price, discounts | ||
| Profit after fees, payments, ads and returns | No | |
| Max ad cost per order, break-even ROAS/POAS | No | |
| Free shipping: minimum profitable basket value | No | |
| Import up to 100 rows and compare 20 SKUs | No | |
| Industry assumptions and 2026 marketplace fee sources | No | |
| Offline work on your data, A4 report | No |
The online calculator is for a quick single-price check. PRO is for decisions: whether your price, promotion and campaign still leave profit.
Who it is for
Store owners, marketplace sellers, marketers planning promotions and small businesses that want pricing based on numbers. Skip it if your ERP calculates SKU profitability automatically or you need a BI platform. This is a deliberately simple Excel workbook.
What you get
- Product_Margin_and_Profitability_Calculator_PRO.xlsx: 16 tabs, no macros
- PDF user guide: where to start and how to read results
- Methodology and tests PDF: how formulas are verified
- 2026 marketplace fee cheat sheet PDF
- Bonus: “Is Your Promotion Profitable?” checklist
- Bonus: “Margin vs Markup” mini guide
- License PDF (single seat, commercial use within your company)
- README with quick start
Why you can trust these formulas
Tests compare results with independent accounting for kept and returned orders. They cover ROAS thresholds, target prices, discounts and incomplete import data. The Methodology and tests PDF records the scope, date and results for release 2.4.
Sheets are protected against accidental formula deletion (no password, you can unprotect in one click), and input fields validate ranges.
What is new in version 2.4
Full refunds with inventory and fee recovery, corrected ROAS thresholds and formula protection. Import identifies missing inputs. The guide walks through a first product analysis and discount decision.
Step two: see how much of that margin your ads consume
Here you calculate product margin and promotion profitability. The Ad Campaign Profitability Calculator PRO takes that margin and calculates break-even ROAS, maximum CPA, a budget range and profit for every campaign.
See the Ad Campaign Profitability Calculator PROFAQ
How is this different from the free calculator on this site?
Do I need advanced Excel skills?
What are the technical requirements?
Will it work for my marketplace?
Where do I get data for the import tab?
Will I receive updates?
Is this accounting advice?
Can I get an invoice?
Check profitability before your next promotion
Buy the workbook and calculate whether your discount, free shipping or ads actually pay off.
Buy now for 35 USDAfter payment, we will email you a download link (Excel + PDF) to the address you provide.
This tool is for analytical and informational purposes only. It is not accounting, tax or legal advice.