Gross Profit by Product: Find Your Real Winners
Your best-selling product is not always your best product. Some items fly off the shelf and leave almost nothing behind once you pay for them, while a quiet item in the corner may be carrying your whole year. Working out gross profit by product shows you which is which, and the first week of January, with a full year of sales behind you, is the perfect time to do it.
Key takeaways
- Gross profit by product is each item's sales minus the direct cost of those sales. It tells you what each product actually contributes.
- Rank products by total gross profit, not by revenue or units sold. The order often changes.
- Look at both gross profit per unit and gross margin percentage, because each one answers a different question.
- Use the results to push, fix, reprice or retire products, then review the list every quarter.
Most small business owners know their top sellers by heart. Ask a bakery owner, a candle maker or a hardware shop manager what sells best and they will answer in a second. Ask which product earns the most money after its own costs, and the answer usually takes longer, if it comes at all. That gap is where hidden profit, and hidden losses, live.
This guide walks you through a simple way to calculate gross profit for every product or service you sell, using numbers you already have. You do not need special software. A spreadsheet, your sales report and your supplier invoices are enough to get started.
A quick note: this article is general information about business finances, not accounting or tax advice. How you value inventory and assign costs can affect your tax return, so check with an accountant or bookkeeper if you plan to change how you record costs in your books.
What gross profit by product actually means
Gross profit is what is left from sales after you subtract the direct cost of the goods or services you sold. When you work it out product by product, you see how much each item contributes toward your rent, wages, marketing and, eventually, your own profit.
The basic formula is short:
- Gross profit = revenue from the product minus the direct cost of the units sold.
- Gross profit per unit = selling price minus direct cost per unit.
- Gross margin percentage = gross profit divided by revenue, times 100.
Direct costs are the costs that rise and fall with each unit you sell. For a product business, that usually means the purchase price or materials, inbound shipping, packaging and any per-unit labor that goes straight into making the item. For a service business, it can mean subcontractor fees, materials used on the job and the hours of staff time spent delivering it.
What to leave out
Rent, insurance, your website, general marketing and admin salaries usually stay out of gross profit. They are overheads that exist whether you sell one unit or a thousand. Keeping them out makes the comparison between products fair and simple. You will deal with overheads separately when you look at net profit.
Per unit vs total vs percentage
Each number answers a different question, so it helps to keep all three side by side.
- Per unit tells you how much you earn every time one sells.
- Total gross profit tells you how much the product contributed over the period. This is the number that pays the bills.
- Margin percentage tells you how efficient the product is, and how much room you have for discounts or cost increases.
A product with a high percentage but tiny volume can matter less than a modest-margin item that sells every day. That is why the ranking should start with total gross profit.
Gather the numbers you need
Before you open a spreadsheet, collect your raw material. Pick a period long enough to smooth out odd weeks. A full year works well in January, and a quarter works for regular reviews afterward.
- Sales by product. Export units sold and revenue per product from your point of sale system, online store or invoicing records. Use revenue after discounts and refunds, not list price.
- Cost per unit. Pull recent supplier invoices or your inventory records. If costs changed during the year, use an average or the cost that applied to most sales.
- Extra per-unit costs. Add inbound shipping, packaging, card processing fees if you want to include them, and any per-order costs such as labels or inserts.
- Labor for made or delivered items. If you or your staff spend measurable time on each unit, estimate the minutes and apply an hourly cost.
- Returns and waste. Note products with high returns, breakage or spoilage, because those costs belong to the product too.
Common mistake
Using the original cost from when you first stocked a product. Supplier prices drift, shipping rates change and packaging costs creep up. If you calculate gross profit with an old cost, a product can look healthy on paper while it quietly loses margin every month. Check the latest invoice for each item before you trust the result.
How to calculate gross profit by product, step by step
With your numbers ready, the calculation takes an afternoon even for a long product list. Follow these steps in order.
- List every product or service. One row each. Group tiny variations, such as colors of the same item, if their costs and prices match.
- Enter units sold and net revenue. Use revenue after discounts and refunds for the period you chose.
- Enter the full direct cost per unit. Include materials, shipping in, packaging and per-unit labor.
- Calculate total direct cost. Units sold times direct cost per unit.
- Calculate gross profit. Net revenue minus total direct cost.
- Calculate margin percentage. Gross profit divided by net revenue, times 100.
- Sort by total gross profit. Largest at the top. Then add a column showing each product's share of total gross profit.
A gross profit by product template
Copy these columns into a spreadsheet and add one row per product. The amounts are made up for illustration only.
| Product | Units sold (example) | Net revenue (example) | Direct cost per unit (example) | Total direct cost | Gross profit | Margin % | Share of total gross profit |
|---|---|---|---|---|---|---|---|
| Large soy candle | 1,200 | $33,600 | $11.00 | $13,200 | $20,400 | 61% | 48% |
| Mini candle gift set | 2,500 | $37,500 | $12.50 | $31,250 | $6,250 | 17% | 15% |
| Wax melts (pack) | 3,000 | $24,000 | $2.80 | $8,400 | $15,600 | 65% | 37% |
In a real sheet, the last column divides each product's gross profit by the total for all products.
Hypothetical example
Look at the made-up numbers above. The mini gift set brings in the most revenue, $37,500, and the owner thinks of it as the star product. Yet once each set's costs are counted, it keeps only $2.50 per unit and contributes just 15% of gross profit. The humble wax melts earn less revenue but more than twice the gross profit of the gift set. The large candle, with fewer units, is the real winner. Without the table, the owner would probably have ordered more gift sets for next season and fewer wax melts, which is exactly backward.
Read the results: four kinds of products
Once your list is sorted, most products fall into one of four groups. Sorting them this way turns a page of numbers into a plan.
Stars: high margin, high volume
These are your real winners. They sell often and keep a healthy share of every sale. Protect them: keep them in stock, feature them in your marketing and watch their costs closely. A small supplier price increase on a star has a big effect on your year.
Workhorses: low margin, high volume
These bring people in and keep the till busy, but each sale leaves little behind. They may still earn their place if they lead customers to buy other items. Ask whether you can trim their cost, raise the price slightly or bundle them with a higher-margin item.
Hidden gems: high margin, low volume
These earn well per sale but few people know about them. Better placement, a mention in your newsletter or a spot next to a popular product can lift sales without a big spend. They are often the quickest win on the list.
Drains: low margin, low volume
These take up shelf space, cash and attention while giving little back. Consider repricing, redesigning or retiring them. Before you drop one, check whether loyal customers rely on it or whether it is part of a set that sells well.
Pro tip
Add a column for inventory turnover if you hold stock. Inventory turnover is cost of goods sold divided by average inventory. A product with a fine margin but very slow turnover ties up cash on your shelves, which can matter as much as the margin itself.
Turn the numbers into decisions
The point of this exercise is not a prettier spreadsheet. It is better choices about what you buy, make, promote and stop selling. Here are the main levers.
- Reprice. If a product sells steadily at a thin margin, a modest price rise may barely affect demand. Test it on one product first and watch sales for a few weeks.
- Reduce the cost. Ask suppliers about volume pricing, switch packaging, combine shipments or simplify the product. Even small savings per unit add up on high-volume items.
- Reposition. Move hidden gems to where customers will see them, online and in store. Put them on your home page, near the till or in your welcome email.
- Bundle. Pair a low-margin workhorse with a high-margin add-on so the overall sale earns more.
- Retire. Drop drains that cannot be fixed. Sell through the remaining stock, then use the space and cash for stronger lines.
Common mistake
Cutting a low-margin product without checking what else its buyers purchase. A coffee shop's plain filter coffee may earn little on its own, but if most of those customers also buy a pastry, removing it could hurt total gross profit. Look at typical baskets or orders before you retire anything popular.
Notes for service businesses and makers
If you sell your time, labor is usually your biggest direct cost, so measure it honestly. Track how many hours each type of job really takes, including travel, revisions and setup, not just the hours you quote. Time tracking for a few weeks can be eye-opening, because some "quick" jobs turn out to take twice as long as you thought.
Makers face a similar trap. It is easy to count materials and forget the hours spent pouring, sewing, sanding or packing. Put a fair hourly cost on your own time, even if you do not pay yourself a wage yet. Otherwise every product looks more profitable than it is, and you may price yourself into a busy but unrewarding year.
If you sell on marketplaces or through retailers, include their per-sale fees or the wholesale discount in your direct costs. The same item can have very different gross profit depending on the channel it sells through, so you may want one row per product per channel.
Your gross profit by product checklist
- Choose your period, such as last year or last quarter
- Export units sold and net revenue for each product or service
- Update the direct cost per unit from recent invoices
- Add shipping in, packaging, per-unit labor, fees and waste
- Calculate gross profit, margin percentage and share of total
- Sort by total gross profit and label stars, workhorses, gems and drains
- Pick one or two changes to test this quarter
- Book a recurring quarterly review in your calendar
Frequently asked questions
What is a good gross margin for a product?
It depends heavily on your industry, pricing and how much overhead the business carries, so there is no single right figure. Compare each product with your own other products and with what your overheads need. If total gross profit does not cover your fixed costs with room to spare, something needs to change.
How often should I calculate gross profit by product?
A full review once a year and a lighter check every quarter suits most small businesses. Recheck sooner if a supplier raises prices, you change your packaging or you launch a big promotion.
Should I include card processing fees and marketplace fees?
If those fees are charged per sale, including them gives a more honest picture, especially when you compare sales channels. Whatever you decide, apply the same rule to every product so the comparison stays fair.
Is gross profit the same as net profit?
No. Gross profit only subtracts direct costs. Net profit also subtracts overheads such as rent, insurance, software, general marketing and admin wages, plus interest and tax. A product can have strong gross profit while the business as a whole still makes a loss.
Related reading
The bottom line
Revenue tells you what customers buy. Gross profit by product tells you what actually keeps your business going. Pull your sales and cost figures for last year, build the simple table, sort by total gross profit and look for your stars, workhorses, hidden gems and drains. The results will often surprise you.
Use this quiet start to the year to make one or two clear changes, then repeat the review every quarter. Small, steady adjustments to the right products can add up to a noticeably healthier year.
