Product profit and pricing calculator
The question before you list anything: what is left after the goods, the shipping and the fees, and what would you have to charge to keep the margin you want. One row per product, and the sheet says it in plain words.
Get the spreadsheet
Free. The file downloads straight away and the link is emailed to you as well, so you can find it again on the laptop you actually work on.
What is inside
- Settings: your card rate, fixed fee and the margin you are aiming for.
- Products: cost, shipping, price in; profit, margin, markup, break-even ROAS and the target price out.
- A verdict column that says whether a product can carry paid advertising or only organic traffic.
How to use it
- Open it in Excel, or upload it to Google Drive and open it with Google Sheets. Everything survives the trip: formulas, dropdowns and formats.
- Fill in the sand-coloured cells. They are the only ones meant for typing; every white cell is a formula that keeps itself correct.
- Start with the Settings sheet. The rates there drive every fee calculation in the workbook, and they come from your own account, not from us.
- Keep it open at the end of each week. A spreadsheet you update on the day you remember is worth more than a perfect one you fill in once a year.
Why we give it away
We build real business apps with AI tools and publish what they cost down to the cent, and these sheets came out of doing that: they are the ones we keep open ourselves. Giving them away costs us nothing and puts us in front of the people we write for. How we test explains where the numbers in them come from.
Questions
What margin is good enough?
Under about 30% there is nothing left to buy customers with: the product only works on free traffic. Around 45% and up, paid acquisition has room to work. The sheet marks each row for you.
What is break-even ROAS?
The return on ad spend at which the advertising exactly pays for itself: what the customer pays divided by the profit the order leaves. Below it, every ad-driven sale costs you money.
Can I use it for print on demand or dropshipping?
Yes. Put the supplier price in "your cost" and their shipping in "shipping you pay"; everything else works the same.
The other templates
- Shopify income and expenses tracker — What did my store actually make this month?
- Store launch budget and break-even planner — What will it cost me to start, and when do I break even?
- Ad spend and ROAS tracker — Which of my campaigns actually made money?
Free calculators if you would rather work it out in the browser than in a spreadsheet.
Read next
Systeme.io Free Plan: What We Measured on a Real Account
We built on a Systeme.io free account on Sept 16, 2026: one automation rule, one campaign, a forced from-address, and two screens that never loaded.
How to Build a Booking App Without Code (We Built Two)
We built two real booking apps on free AI builders and logged every credit. What $0 gets you, what breaks, and the exact feature that makes you pay.