You sold 40 units last week, your Stripe notifications looked healthy, and yet your bank balance still feels weirdly flat. If you've ever stared at your numbers wondering which products are actually carrying the business, a product profitability spreadsheet is usually the fastest way to stop guessing.
This article will show you how to calculate profitability at the product level with a simple spreadsheet you can actually maintain. You'll learn what to track, how to structure the sheet, and how to spot the products that deserve more attention versus the ones quietly draining your margin.
Why revenue alone gives you a false sense of performance
A lot of solopreneurs track sales first because sales are visible. Your storefront tells you what sold. Your payment processor tells you what came in. But neither tells you what stayed.
That's where people get caught. A product can look like a winner because it sells often, then turn out to be mediocre once you layer in delivery costs, payment fees, refunds, software overhead, and your time.
Profitability is what lets you make better decisions. Not just “what sold,” but “what was worth selling.”
We've seen this especially with lean product businesses. Someone might sell a spreadsheet template, a digital toolkit, and a lower-priced mini-offer. The mini-offer can bring in the most orders while contributing the least real profit after transaction fees, customer support time, and promo discounts.
If you sell operational tools like FoundersfoldCo-style resources or spreadsheet products through a simple storefront, this matters even more. Small shifts in delivery costs or discounting can change the picture quickly.
What to include in your product profitability spreadsheet
A useful product profitability spreadsheet doesn't need 14 tabs and a finance degree. It needs the right inputs, consistently tracked.
At minimum, create one row per product and a column for each cost or revenue driver that affects profit. Start simple, then add detail only when it helps you make a better decision.
The essential columns to track
- Product name
- Units sold
- Sale price per unit
- Gross revenue
- Cost of goods sold or delivery cost per unit
- Payment processing fees
- Refunds or chargebacks
- Discounts applied
- Allocated overhead
- Net profit
- Profit margin %
If you're selling digital products, “cost of goods sold” may be low, but don't assume it's zero. File hosting, affiliate payouts, deal platform fees, customer service tools, and ad spend can all belong here depending on how you run the business.
Overhead allocation is where many spreadsheets fall apart. You don't need perfect accounting precision, but you do need a fair method. If your email software, design app, and storefront subscription support all products, spread those costs across your product lines using a method you can repeat monthly.
Keep direct costs and shared costs separate
This makes your numbers easier to trust. Direct costs belong to the specific product. Shared costs are business-wide expenses that you allocate using a rule, such as percentage of revenue or percentage of sales volume.
That distinction matters because it helps you answer two different questions: “Is this product profitable on its own?” and “Is this product still worth keeping once it carries its share of the business?”
How to set up the formulas without making the sheet messy
Your spreadsheet should let you scan the whole product line in one view. If you need to click five tabs to understand one product, the system is too fussy.
Here's a clean structure for the main calculations.
Core formulas to use
Gross Revenue = Units Sold × Sale Price
Total Direct Costs = (Units Sold × Cost per Unit) + Payment Fees + Refunds + Discounts
Net Profit = Gross Revenue − Total Direct Costs − Allocated Overhead
Profit Margin % = Net Profit ÷ Gross Revenue
That's enough to get a working product profitability spreadsheet in place.
For example, say you sell three spreadsheet products: a planner, a dashboard, and a business tracker. The dashboard might sell fewer units than the planner, but if it has a higher selling price, fewer refunds, and almost no support requests, it can end up as your strongest product by margin.
I've seen plenty of solo businesses discover that their “best-seller” was mostly just their busiest product, not their most profitable one.
Use one assumptions area
If you have costs that repeat each month, keep them in a small assumptions section at the top or in a separate tab. Payment fee estimates, software subscriptions, and overhead totals should live there rather than being typed manually into random cells.
That way, when your costs change, you update once and the rest of the sheet follows. If you want a ready-made version of that structure, a business command centre spreadsheet can save you from rebuilding the logic from scratch.
How to allocate overhead without overthinking it
This is the step people either skip or turn into a three-hour side quest. Don't do either.
You just need a method that is consistent and close enough to reality to support decisions.
Three practical ways to allocate shared costs
- By revenue: higher-earning products absorb more overhead
- By units sold: useful when products are similar in type and support demand
- By time/support load: best when one product creates far more customer admin than others
If you sell digital spreadsheets, I usually prefer revenue allocation first, then adjust if one product clearly creates a heavier support burden. For instance, a premium spreadsheet with onboarding videos may sell less often but still require more post-purchase help than a simple one-tab calculator.
This doesn't need to be perfect to be useful. It needs to stop you from believing every dollar of sales is equally good.
What your product profitability spreadsheet should help you decide
Once the sheet is built, the real value isn't the math. It's the decisions you can make with confidence.
A strong product profitability spreadsheet should show you which products deserve promotion, which need repricing, and which might be adding noise instead of profit.
Questions your numbers should answer fast
Can you raise the price on a strong-margin product without hurting demand? Is a low-ticket product worth keeping if it brings refunds and support requests? Are discounts eating more margin than you realised?
One of the clearest examples is bundle strategy. You might think bundling helps average order value, but your sheet may show that bundling your highest-margin spreadsheet with a lower-margin product drags down the total profit per order more than expected.
Another common discovery: a product with modest volume but almost no support load is often more valuable than a popular product that constantly creates edge-case customer questions.
That kind of visibility changes how you plan launches, promos, and even your product roadmap.
Common mistakes that make your profitability numbers useless
Most spreadsheet mistakes aren't formula errors. They're assumption errors.
If your sheet tells you every product is healthy, but your cash flow says otherwise, one of these is usually the culprit.
- Ignoring refunds because they “don't happen often”
- Forgetting payment fees or marketplace commissions
- Treating all discounts as marketing wins instead of margin reductions
- Leaving out recurring software costs
- Never updating the sheet after launch month
Fresh data matters more than fancy formatting. I'd rather see a plain spreadsheet updated every month than a beautiful dashboard running on stale assumptions.
It's also worth resisting the urge to track everything from day one. Start with enough detail to see product-level profit clearly. Then add complexity only if it changes a decision.
That's especially true for solopreneurs. Your spreadsheet should support the business, not become the business.
Once you can see which products truly pay their way, you're in a much better position to simplify your offer suite, protect margin, and grow with less stress. If you want a cleaner system for tracking the numbers that actually matter, take a look at LaunchedWithAI's Spreadsheet.