Your counter took in a good amount this month, but how much of it is actually profit on the goods you sold? That number is your gross profit, and every other profit figure in the shop starts from it. This guide shows how to calculate gross profit in retail at three levels: a single item, a category such as staples or personal care, and the whole store. We use simple worked examples from a Kerala grocery, show why GST must be kept out of the figures, explain how returns and discounts change the result, and finish with a checklist for reading an item-wise profit report without being misled.
What Gross Profit Means for a Shop
Gross profit is what remains from your sales after you take away the cost of the goods you sold. It does not yet include rent, salaries, electricity, loan interest or software subscriptions. Those come later, when you work out operating and net profit.
Two terms you will see everywhere:
- Net sales: what customers paid you for goods, after sales returns and discounts, and excluding GST.
- Cost of goods sold (COGS): what those same goods cost you to buy and bring into the shop, also excluding any GST you can claim back as input tax credit.
Gross profit is shown in two ways: as an amount in rupees, and as a percentage of net sales, called the gross profit margin. The rupee amount tells you how much money is available to pay your expenses. The percentage lets you compare items, categories, months and branches fairly.
Gross margin is not the same as markup. Margin is worked out on the selling price, while markup is worked out on cost. A product bought at ₹80 and sold at ₹100 has a 25% markup but a 20% margin. If your team mixes the two, prices end up wrong. Our guide on markup vs margin covers the conversion in detail.
The Gross Profit Formulas You Need
Keep these three formulas next to the billing desk:
- Gross profit = Net sales − Cost of goods sold
- Gross profit margin % = Gross profit ÷ Net sales × 100
- Cost of goods sold (store level) = Opening stock + Net purchases − Closing stock
Net purchases means purchases at taxable value (before GST), plus freight and loading you paid to bring the goods in, minus purchase returns and supplier discounts on the bill. Ask your accountant how your books treat items such as cash discounts received later or supplier schemes, and stay consistent month to month.
How to Calculate Gross Profit in Retail at Item Level
Start with one product, because this is where most pricing mistakes hide. The numbers below are illustrative only and are not real market prices. We assume a 5% GST rate purely to make the maths easy. Always check the actual rate for your item’s HSN code.
Worked example: a 1 litre oil pouch in a Thrissur supermarket
- Selling price on the bill, including GST: ₹157.50
- GST inside that price at 5%: ₹7.50, so net selling price = ₹150.00
- Purchase cost from the distributor: ₹140.00 + ₹7.00 GST. The ₹7 is claimed as input tax credit, so the cost for profit purposes = ₹140.00
- Gross profit per unit = ₹150 − ₹140 = ₹10
- Gross profit margin = 10 ÷ 150 × 100 = 6.7%
- If 300 pouches sold this month, item gross profit = 300 × ₹10 = ₹3,000
To get the taxable value from a GST-inclusive price, divide it by (1 + GST rate). At 5%, ₹157.50 ÷ 1.05 = ₹150. Do this before any margin calculation.
Why GST-inclusive figures give the wrong answer
Suppose someone takes the bill amount (₹157.50) and subtracts the invoice total from the distributor (₹147.00). They get ₹10.50 and a margin that looks a little better than it is. GST you collect belongs to the government, and the GST you paid on purchases comes back as credit, so neither is your profit or your cost. Keep both sides of the calculation at taxable value.
There is one important exception. A shop under the composition scheme cannot claim input tax credit, so the GST paid on purchases becomes part of the cost. In that case the cost of the oil pouch would be ₹147, not ₹140. Composition sellers also cannot collect GST from customers, so the full bill amount is the selling price, but the composition tax they pay on turnover is an expense. Confirm the right treatment for your registration with your tax professional. Official GST guidance is on the CBIC GST portal.
Category-Level Gross Profit: Where the Money Really Comes From
Item-level numbers are useful for pricing. Category-level numbers are useful for running the shop. They tell you which sections of the store do the earning and which ones just bring in footfall.
Worked example: one month in a Kochi grocery (illustrative figures)
| Category | Net sales (₹) | COGS (₹) | Gross profit (₹) | GP margin |
|---|---|---|---|---|
| Staples (rice, atta, pulses, oil) | 4,00,000 | 3,52,000 | 48,000 | 12.0% |
| Packaged foods and FMCG | 2,50,000 | 2,05,000 | 45,000 | 18.0% |
| Personal care and household | 1,20,000 | 93,600 | 26,400 | 22.0% |
| Fruits and vegetables | 80,000 | 60,000 | 20,000 | 25.0% |
| Total store | 8,50,000 | 7,10,600 | 1,39,400 | 16.4% |
These are made-up numbers for practice, not benchmarks. Even so, they show some useful patterns:
- Staples bring in nearly half the sales but only about a third of the gross profit. They draw customers in, so cutting them is rarely the answer. They do need tight purchasing.
- Personal care earns ₹26,400 on less than a third of the staples turnover. Better shelf space, cleaner displays and steady stock here can lift the overall store margin.
- Fruits and vegetables show a healthy margin on paper, but only if spoilage is booked. Unrecorded wastage makes this category look better than it really is. Our guide on shrinkage in retail explains how to capture it.
- The store margin of 16.4% is a weighted figure. A small change in the sales mix, with more personal care and fewer staples, moves it even when no price changes.
Store-Level Gross Profit Using Stock Figures
At the end of a month or year, your accountant usually calculates gross profit from stock values instead of adding up every bill. Using the same illustrative Kochi grocery:
- Opening stock at cost (1st of the month): ₹12,40,000
- Net purchases during the month, excluding GST and after purchase returns: ₹7,30,000
- Closing stock at cost after the month-end count: ₹12,59,400
- COGS = 12,40,000 + 7,30,000 − 12,59,400 = ₹7,10,600
- Gross profit = Net sales ₹8,50,000 − ₹7,10,600 = ₹1,39,400 (16.4%)
Here the stock method and the category total agree. In a real shop they often do not, and the gap is worth looking into. If the stock method shows lower gross profit than your item-wise billing reports, the difference is usually shrinkage, unbilled samples, wrongly entered purchase rates or missed stock adjustments. A big gap is a sign to count and check, not something to round off.
Closing stock has a large effect on the result. If closing stock is overstated by ₹20,000, gross profit is overstated by the same ₹20,000. This is why a careful physical count, valued at cost, matters as much as the billing data. For the accounting side, from ledgers to stock valuation, see our overview of accounting and finance in ERP.
How Returns, Discounts and Free Goods Change Gross Profit
Sales returns
Start from gross sales and subtract returns and discounts to reach net sales. For example: gross sales ₹8,80,000 − sales returns ₹18,000 − discounts ₹12,000 = net sales ₹8,50,000. When a returned item is in good condition and goes back on the shelf, its cost also goes back into stock, so COGS falls too. When it is damaged or expired, it should be written off as a loss, not quietly put back as saleable stock.
Discounts
A discount comes straight out of gross profit, because your cost does not change. Take a shampoo with a net selling price of ₹200 and a cost of ₹156: gross profit is ₹44 (22%). Give a 10% discount and the net price falls to ₹180, but cost stays ₹156. Gross profit drops to ₹24 (13.3%). To earn the same ₹44 total, you would need to sell roughly 1.8 times as many units. Run this check before agreeing to a festival offer.
Free goods and schemes
With “buy two, get one free”, the free unit has no sale value but still has a cost, so it belongs in COGS. Where a supplier funds the scheme through a credit note or reimbursement, record that against purchases when it is confirmed, not when it is promised. Otherwise your margin looks good one month and falls the next.
How to Read an Item-Wise Profit Report Without Being Misled
Most billing and ERP software can show item-wise sales and cost data. The report is only as reliable as the data behind it. Check these points before you change a single price:
- Confirm it is GST-exclusive. Both sales and cost columns should be at taxable value, unless you are a composition dealer.
- Check the cost method. Last purchase rate, weighted average and FIFO give different costs when supplier rates change. Use one method consistently and know which one the report is using.
- Look for items with 100% margin. These almost always have no purchase cost entered, often because they were opened as stock without a rate.
- Look for negative margins. Either the item really sells below cost, a supplier rate went up and the selling price did not, or a purchase was entered with the wrong unit (box vs piece, kg vs gram).
- Sort by gross profit in rupees, not just percentage. A 40% margin on an item that sells twice a month matters less than a 12% margin on your fastest-moving staple.
- Compare with last month. A sudden margin jump in one category usually means a data issue, not a miracle.
A Simple Monthly Gross Profit Routine
- Enter every purchase bill with correct taxable value, units and freight before month-end.
- Record sales returns, damages and expiries as they happen, not in a batch at the end.
- Do a physical stock count of at least your high-value categories and value it at cost.
- Calculate store-level gross profit using the stock formula.
- Compare it with the category totals from your billing reports and investigate any gap.
- Review the twenty items with the highest and lowest gross profit and fix prices, costs or data.
- Note what changed, such as supplier rates, offers or mix, so next month’s comparison makes sense.
Software that keeps billing, purchases and stock in one place makes this routine much faster. Our article on the ROI of retail POS software explains how to judge whether that time saving is worth it for your shop.
Keep your margin data clean from the counter: Caddayn Biller handles GST billing, barcode billing, inventory with low-stock and reorder alerts, price lists, units of measure and multi-branch stock, on Windows and the web. Because sales, purchases and stock live in one system, the figures you need for gross profit are recorded as you trade. Download Caddayn Biller and try it with your own items.
Frequently Asked Questions
Should gross profit be calculated with or without GST?
Without GST, for a regular GST-registered shop. The GST you collect is owed to the government, and the GST on purchases comes back as input tax credit, so both are kept out of sales and cost. A composition dealer, who cannot claim credit, includes purchase GST in cost.
What is a good gross profit margin for a retail shop?
There is no single right number. It depends on your categories, location, supplier terms and how much of your sales are low-margin staples. The most useful comparison is your own shop over time and across categories, along with checking that gross profit covers your operating expenses with something left over.
Is gross profit margin the same as markup?
No. Margin is gross profit divided by selling price. Markup is gross profit divided by cost. The same item always shows a higher markup percentage than margin percentage.
Do sales returns reduce gross profit?
Yes. Returns reduce net sales. If the goods go back into saleable stock, their cost also comes out of COGS, so the net effect is the profit you would have made on that sale. Damaged returns that are written off reduce gross profit by their full cost as well.
Why does my store-level gross profit not match the item-wise report?
Common causes are shrinkage, missing or wrong purchase rates, stock adjustments not entered, unit-of-measure errors and differences in cost method. Treat a large gap as a signal to recount and check entries.
This article is general information with illustrative numbers, not tax or accounting advice. Please confirm treatments for your business with your chartered accountant or tax professional.