How to calculate gross profit percentage correctly

To calculate gross profit percentage, use (gross profit ÷ net sales) × 100, where gross profit is net sales minus cost of goods sold. Subtract discounts and returns from gross sales, deduct COGS, divide the result by net sales for the same period, then multiply by 100. Operating expenses are excluded.

The formula takes a minute to learn. The inputs are where people go wrong. Count the wrong sales figure or leave a cost out, and the percentage tells you something false about your business. This guide covers the steps in order, the spreadsheet method, what counts as a good result, and the cases that break the standard calculation: service businesses, stock losses, and installment sales.

What is the formula for gross profit percentage?#

The formula is: gross profit percentage = (gross profit ÷ net sales) × 100. It tells you how many pence of every pound of sales are left after paying the direct cost of what you sold.

Each part has a precise meaning.

Net sales. What you actually earned from sales, after taking off discounts, returns, and commissions. It is not the total on your invoices.

Cost of goods sold (COGS). The direct cost of producing or buying what you sold in the period. Materials. Direct labour. Stock bought for resale.

Gross profit. Net sales minus COGS. This is a pound figure.

Gross profit percentage. Gross profit divided by net sales, multiplied by 100. This is the figure you compare across months, products, and competitors.

Use the same period for both inputs. If net sales cover March, COGS must cover March. Mixing a quarter of sales with a month of costs produces a number that means nothing.

Gross profit versus gross profit percentage, and what counts as COGS#

Gross profit is a pound amount. Gross profit percentage is a ratio. You need both, because they answer different questions.

Gross profit tells you how much money is available to pay for everything else: salaries, rent, marketing, interest. Gross profit percentage tells you how efficiently you earn it. A business with a large gross profit in pounds can still earn very little on each sale. The percentage exposes that. It also lets you compare a small business with a large one, or this quarter with last.

COGS is the narrower and more contested half of the calculation. It includes costs that exist only because you made or bought something to sell. Raw materials. Stock purchased for resale. Direct labour on the production line. Freight paid to bring stock in. Packaging that ships with the product.

Operating expenses do not belong in COGS. Rent on your head office. Salaries for finance and admin staff. Marketing. Software subscriptions. Interest. These costs continue whether you sell one unit or a thousand, and they sit below the gross profit line on your P&L.

The most common mistake is moving a cost across that line. Put marketing into COGS and your gross margin shrinks for no good reason. Leave direct labour out and it inflates. Pick a rule for each cost, write it down, and apply it every period. A margin that changes because your definitions changed is not information.

How to calculate gross profit percentage with net sales and cost of goods sold#

Four steps take you from your sales records to the final percentage. Work through them in this order.

1. Find net sales. Start with gross sales for the period. Subtract discounts, returns, and commissions. The result is net sales, and it is the denominator for everything that follows.
2. Deduct COGS. Subtract the cost of goods sold for the same period from net sales. The result is gross profit in pounds.
3. Divide. Divide gross profit by net sales. You get a decimal.
4. Multiply by 100. Convert the decimal to a percentage.

A worked example with made-up numbers shows the arithmetic. Say a business has gross sales of £130,000, with £10,000 of discounts and returns. Net sales are £130,000 − £10,000 = £120,000. COGS for the period is £72,000. Gross profit is £120,000 − £72,000 = £48,000. Divide: £48,000 ÷ £120,000 = 0.4. Multiply by 100: 40%. The business keeps 40p of every pound of net sales to cover operating expenses and profit. None of these figures come from a real company.

A published case gives a sense of what real figures look like. In an Open University case study of Remote Sensors Plc for 2025, the company's gross profit margin worked out at 40.71% of sales revenue. The method is the same four steps, just with larger numbers.

The step people skip is the first one. Divide gross profit by gross sales instead of net sales and you understate your margin whenever you give discounts or take returns. Check that the figure in your denominator is the same one you used to calculate gross profit.

How to calculate gross profit percentage in Excel#

A spreadsheet does this in four cells. Set it up once and every new period costs you a few seconds.

1. Put your labels in row 1. Column A: Period. Column B: Net sales. Column C: COGS. Column D: Gross profit. Column E: Gross profit %.
2. Enter your figures in B2 and C2. Net sales go in B2, after discounts and returns. COGS goes in C2.
3. In D2, type =B2-C2. This gives gross profit in pounds.
4. In E2, type =D2/B2. Then select the cell and apply the percentage format from the Home tab. Excel multiplies by 100 for you, so do not add *100 to the formula and then format as a percentage, or the result will be 100 times too large.

Copy row 2 down for each month. A column of monthly percentages shows a drift long before the annual accounts do. A margin that slips two points over a quarter signals a pricing or supplier problem.

Guard against a blank month. A zero in net sales makes =D2/B2 return a divide-by-zero error. Wrap it: =IF(B2=0,"", D2/B2).

If your accounting software already holds the numbers, you can skip the manual entry. Xero, for example, tracks gross, operating, and net profit margins and lets you compare them over time. The trade-off is the same either way: the percentage is only as consistent as the definitions behind it, so keep your revenue and COGS rules fixed across periods.

What is a good gross profit percentage?#

A good gross profit percentage depends on your industry. A margin that is excellent for a wholesaler would signal trouble for a software company. Compare your result with the range for your sector, not with a single target.

Autymate puts software and SaaS at 70% to 90% and wholesale at 20% to 35%. Business Queensland reports that manufacturing or construction businesses may sit between 45% and 60%, while professional services can reach 80% or higher. Treat these as rough guides. Autymate's figures are vendor-reported, and the two sources cover different markets.

The ranges explain something that surprises founders. Wholesalers run on thin margins and survive on volume. Software companies carry high margins and spend heavily on development and sales further down the P&L. A high gross margin does not mean a profitable business, and a low one does not mean a failing one.

Your own trend matters more than any benchmark. A margin that holds steady inside your sector's range is healthy. A margin that falls sharply in a year is a warning, even if the new figure is still inside the range.

Service businesses, inventory write-downs and installment sales#

Gross profit percentage still works when you have no stock. You have to decide what your "cost of goods" is.

For a service business, treat COGS as the direct cost of delivering the work. Direct labour for the people who do the billable work. Subcontractors. Delivery and travel costs tied to a specific job. Materials consumed on a client project. Software or licences used only to deliver the service. Leave out sales, management, and admin salaries, which sit in operating expenses. Then apply the standard formula to your fee income.

Inventory losses are the second trap. Stock written down because it is obsolete, damaged, or worth less than you paid is a real cost of the stock you handled. So is stock lost to theft. Most businesses include these losses in COGS for the period when they are recognised. That lowers your gross profit percentage, and it should. Leaving them out flatters the margin and hides a shrinkage problem. Whichever treatment you choose, record write-downs separately so you can see how much of a margin drop came from losses and how much came from pricing or supplier costs.

Installment sales raise a timing question. When you sell on payment terms, you earn the gross profit over the life of the arrangement, and the treatment depends on your accounting framework and local tax rules. The percentage you calculate on the whole sale at the point of sale may differ from what you recognise period by period. Confirm the rule with your accountant before you rely on it, and calculate the percentage on the sales you have recognised, not on the contract total.

Margin vs markup, and how to calculate profit percentage beyond gross#

Margin and markup are not the same measure. Margin divides profit by the selling price. Markup divides profit by the cost. Take an illustrative item that costs £60 and sells for £100, which gives a gross profit of £40. Margin is £40 ÷ £100, which is 40%. Markup is £40 ÷ £60, which is 66.7%. Quote one when your supplier or customer expects the other and your pricing will be wrong.

"Profit percentage" also gets used loosely. Gross profit percentage stops after COGS. Net profit percentage goes further: it takes net sales, subtracts COGS and every operating expense, interest, and tax, and divides what remains by net sales. If you want that bottom-line figure, use a net profit calculator or your full P&L, not the gross formula.

Keeping gross profit percentage up to date in a financial model#

A margin you calculate once a quarter is already out of date. A startup that changes prices, adds a product, or hires delivery staff shifts its gross profit percentage every month. A static spreadsheet will not tell you until the damage is done.

bluprnts is a financial modelling tool that helps startup founders build a P&L from their own products, pricing, headcount, sales, and costs. Because the P&L is derived from those inputs, the gross margin updates when you change a price or add a product. For the wider method, see the startup financial modelling guides. The need is real: a Q4 2025 Shopify survey found that 42% of merchants named profitability as their primary goal.

Prices and plan limits verified as of November 2026.

FAQs#

What is the difference between gross profit percentage and net profit percentage?#

Gross profit percentage subtracts only the direct cost of goods sold from net sales. Net profit percentage subtracts everything: COGS, operating expenses, interest, and tax. Gross profit percentage shows how well you earn on each sale. Net profit percentage shows what the business keeps after every cost. Net is always lower than gross, unless the business has no costs beyond COGS.

Is a net profit calculator the same as a gross profit percentage calculator?#

No. A gross profit percentage calculator needs two inputs: net sales and COGS. A net profit calculator needs the full cost base, including operating expenses, interest, and tax. Use the first to test pricing and direct costs. Use the second to test whether the whole business makes money. Entering gross figures into a net profit tool gives you a misleading answer.

Should shipping costs be included in cost of goods sold?#

It depends on the direction. Freight you pay to bring stock in is part of COGS, because it is a cost of acquiring what you sell. Shipping you pay to deliver orders to customers is often treated as a selling or distribution expense instead. Choose one rule, apply it every period, and keep it consistent so your margin trend stays comparable.

How often should I recalculate my gross profit percentage?#

Monthly is the practical minimum for most businesses. A monthly figure catches a supplier price rise or an over-generous discount within weeks. Businesses with fast-moving stock or thin margins, such as wholesalers, benefit from checking weekly. Always compare like with like: the same period length, the same definitions of net sales and COGS.

Can gross profit percentage be negative?#

Yes. If COGS is higher than net sales, gross profit is negative and so is the percentage. It happens when you sell below cost, when large inventory write-downs hit a period, or when direct costs run ahead of revenue in a launch phase. A negative figure means each sale loses money before any overheads.

What is the difference between gross profit percentage and markup?#

Both use the same profit figure, but they divide it by different numbers. Gross profit percentage divides by the selling price. Markup divides by the cost. Because the cost is lower than the price, markup is always the larger number for the same sale. Never use the two interchangeably when setting prices.

Conclusion#

Fix your definitions of net sales and COGS in writing, then calculate the figure monthly in a spreadsheet. Compare it with your own trend first and your sector's range second.