Posted on 21 October 2025
Free Profit Margin Template in Excel, Google Sheets, Word and PDF
- Available to download in Excel, Google Sheets, Word and PDF, with a filled sample to copy
- Works out margin, markup and profit per unit for up to 40 products, after discounts, returns and tax
- Counts freight, packaging and card fees, and gives the price that hits your target margin
- Compares your gross, EBITDA, operating and net margin with 17 industries (NYU Stern, January 2026)
A profit margin template is a spreadsheet that shows how much of each sale you keep as profit. You enter price, discount, units and every direct cost per product, and it takes out tax, works out margin and markup, flags items below target and gives the price that would hit it.
Last updated: November 9, 2026
What it is
A profit margin template that shows how much of each sale you keep. Price, discount, units and every direct cost go in. Margin, markup, the price you need and a status for every product come out.
When you need it
When sales look healthy but the bank balance doesn't agree. Or when a supplier raises prices and you need to know what to charge now.
What's inside
A product sheet for up to 40 items, a gross to net business view, a price planner, industry benchmarks and a one-page summary.
Formats
The profit margin template Excel file, a Google Sheets copy, plus Word and PDF. The Word and PDF files are a one-page worksheet you can fill in by hand.
Want to see it filled in first?
Make your own copy of the filled sample in Google Sheets.
What Is the Profit Margin Template?
You sold $11,354 of paint last month. Great month?
Not quite. After the discount, the freight and the card fees, every gallon kept $8.41. That's a 24.6% margin on your best seller.
A profit margin template is a spreadsheet that shows how much of each sale you keep as profit. You enter the price, discount, units sold and every direct cost per product. It takes the tax out, works out margin and markup, flags items below your target and gives the price that would hit it.
You'll hear it called a profit margin spreadsheet, a margin template, a margin calculator Excel template or a product profitability sheet. Same job. One number per product: the share of the selling price you keep.
as you charge it
minus discount and tax
buy, ship, pack, fees
net price minus cost
profit / net price
What it isn't: a profit and loss statement, a tax return or a markup calculator. Markup divides profit by cost. Margin divides it by price. Mix them up and a 40% margin turns into a 66.7% markup on the same sale.

Profit Margin Template vs P&L, Profitability Analysis and Margin Calculator
Four tools, four different questions. Pick the one that answers yours.
| Tool | The question it answers | Covers | Best for |
|---|---|---|---|
| Profit margin template | Which products make money, and what should each one cost? | Every product, one period | Pricing and product decisions |
| Profit and loss statement | Did the business make a profit? | The whole business | Owners, lenders, tax time |
| Profitability analysis | Is profit rising or falling over time? | Periods side by side | Monthly and yearly reviews |
| Contribution margin statement | How much does each sale add toward fixed costs? | Fixed vs variable costs | Break even planning |
| Margin calculator | What is the margin on this one sale? | One item | A quick check |
A P&L tells you whether you made money. A profit margin template tells you which products made it, and which ones quietly gave it back.
New to income statements? Start with this guide to the profit and loss statement. Want the full statement in a file? The profit and loss statement template carries every line from revenue to net profit.
Which Margin Tool Fits Your Situation?
| If your situation is... | Use this | Where to find it |
|---|---|---|
| You want the margin on one sale, right now | Online margin tool | Margin calculator |
| You sell many products and want to rank them | Product sheet with status and target price | Products sheet |
| You need to set a price for a new item | Price for a target margin | Price Planner sheet |
| You are about to run a promotion | Discount effect and extra units table | Price Planner sheet |
| You compare this year with last year | Period by period view | Profitability analysis template |
| Your costs are mostly fixed | Fixed vs variable split | Contribution margin income statement |
| You want to work it out on paper | One-page worksheet | Word and PDF files |
What Does the Profit Margin Template Contain?
Eleven inputs per product in the profit margin template Excel file. Everything else is a formula.
| Field | What goes in it | Why it matters |
|---|---|---|
| Selling price per unit | The price as you charge it | The starting point, before tax and discount come out |
| Average discount | The typical discount on that item | A 10% discount on a 40% margin item leaves 33.3% |
| Units sold and returned | Units in the period, and units that came back | Returns are revenue you gave back |
| Purchase or make cost | What one unit costs you to buy or produce | The cost most people stop at |
| Freight, duty and handling | Inbound shipping and import costs per unit | Bulky goods hide their real cost here |
| Packaging and other direct cost | Boxes, fixings, labels, direct labor | Small per unit, large per year |
| Card or marketplace fee | The fee as a percent of price | A 2.9% fee scales with every sale |
| Margin and markup | Calculated | The same profit, measured two ways |
| Price for target margin | Calculated | What to charge to hit your goal |
| Status | On Target, Below Target, Loss or Check | Tells you where to look first |
The field that matters most? Full unit cost. Your supplier invoice is only part of it. Leave out freight and fees and every margin on the sheet looks better than the bank account will.
What the Enerpize Profit Margin Template Includes
We built it backwards from the questions an owner asks on a slow Tuesday. Which product is losing money? What should I charge? Is my margin normal? Each sheet answers one of them.
A Price Tag With the Tax Taken Out
Shelf price includes VAT or GST? Say so once in Settings. The template divides every price by one plus your tax rate, then takes the discount off, before it works out a single margin. A $116 price with 16% VAT becomes $100.
Every Cost on the Scale, Not Just the Invoice
Purchase cost, freight and duty, packaging and the card fee each get their own column. In the sample, a garden hose that costs $22 to buy really costs $30.04 to sell. At a 25% discount it sells for $25.50. That's a loss on every hose.

The Products That Pay the Rent
Each row shows its share of total gross profit. The $12.99 LED bulb pack brings in 15.8% of all gross profit. The $149 thermostat brings in 3.5%. Price alone won't tell you that.

A Price Worked Backwards From the Margin You Want
Every row gives the price that would hit your target, in the same terms as the price you charge. Discount and tax included. The Price Planner does the same for a new item, and shows what a promotion really costs.

From Gross Margin to Net on One Sheet
Product totals flow into a whole business view. Add rent, salaries, marketing, depreciation, interest and income tax, and you get gross, EBITDA, operating and net margin for the same period.

A Ruler From Outside Your Shop
Pick your industry from 17. The template sets your gross, EBITDA, operating and net margin beside the figures for US listed companies, from NYU Stern's January 2026 margin data. Software keeps 71.7% gross. Grocery retail keeps 26.3%. Your own number finally has context.

Margin, Markup and Discounts: The Tables That Prevent Pricing Mistakes
Most pricing errors start with one word used for two things. Here are both, side by side.
| Margin you want | Markup on cost that gets you there | On a $30 cost, charge |
|---|---|---|
| 20% | 25.0% | $37.50 |
| 25% | 33.3% | $40.00 |
| 30% | 42.9% | $42.86 |
| 35% | 53.8% | $46.15 |
| 40% | 66.7% | $50.00 |
| 50% | 100.0% | $60.00 |
Now the discount. It comes straight out of your margin, not your price.
| Margin before | 10% off | 20% off | Extra units needed at 10% off |
|---|---|---|---|
| 30% | 22.2% | 12.5% | +50.0% |
| 40% | 33.3% | 25.0% | +33.3% |
| 50% | 44.4% | 37.5% | +25.0% |
A 40% margin item at 10% off needs a third more units just to stand still.
Every row in the template gets one of four status codes:
On Target At or above your target margin.
Below Target Still profitable, under your goal. The row shows the price that fixes it.
Loss Sells for less than it costs to buy, ship, pack and get paid for.
Check Something in the row needs fixing first, such as returns above units sold.
Profit Margin Template Example (Filled Sample)
Cedar Street Supplies is a fictional hardware store. Twelve products, October 2026, a 35% target margin. Make a copy of the filled sample in Google Sheets and follow along.
How to Read the Cedar Street Sample
| What you see | The number | What it tells you |
|---|---|---|
| Revenue | $56,659.33 | After discounts and returns, without tax |
| Gross profit | $20,591.81 | What is left after full product cost |
| Blended margin | 36.3% | Above the 35% target, so the total looks fine |
| Products on target | 6 of 12 | Half the range is below target or losing money |
| Interior paint | 24.6% margin on $11,354 | The best seller is 10.4 points short. Target price $44.37, not $38 |
| Garden hose | 17.8% loss | A 25% discount plus $6.50 freight per hose |
| Net margin | 2.8% vs 5.2% industry | Running costs take 31.4% of revenue |
The lesson? A healthy blended margin can hide six problem products. The total is an average. Your decisions happen one row at a time.
Profit Margin Formulas in Excel and Google Sheets
Every profit margin formula below works the same in Excel and Google Sheets. Price is in B2, full unit cost in C2. Format the result cells as a percentage.
Profit Margin Formula
=(B2-C2)/B2
Profit divided by the selling price. A $50 sale that costs $30 gives a 40% margin.
Markup Formula
=(B2-C2)/C2
Same profit, divided by cost. The same $50 sale is a 66.7% markup.
Price for a Target Margin
=C2/(1-D2-E2)
D2 is your target margin, E2 your card or marketplace fee. A $30 cost with a 40% target and no fee needs a $50 price.
Take the Tax Out of a Price
=B2/(1+F2)
F2 is the tax rate. A $116 price with 16% VAT is $100 before tax. Work out margin on the $100.
Blended Margin Across Products
=(SUM(S6:S45)-SUM(T6:T45))/SUM(S6:S45)
Total gross profit over total revenue. Never the average of the row margins. In the sample: $20,591.81 / $56,659.33 = 36.3%.
Fill a Whole Column at Once in Google Sheets
=ARRAYFORMULA(IF(B2:B="","",(B2:B-C2:C)/B2:B))
One formula in the top row fills every product below it. Wrap single cells in =IFERROR((B2-C2)/B2,"") so blank rows stay clean.
Gross, Operating and Net Margin
Gross profit margin = Gross profit / Revenue
Operating margin = Operating profit / Revenue
Net margin = Net profit / Revenue
Cedar Street: 36.3% gross, 3.9% operating, 2.8% net. Each line takes off one more layer of cost.
How to Use the Profit Margin Template
Seven steps take the profit margin template from blank to a pricing decision.
1- Fill In Settings
Open the profit margin template Excel file or your Google Sheets copy. Enter your business, the period, your currency, whether prices include tax, your target margin and your industry. Every other sheet reads from here.
⚡ Tip: No target yet? Start with your industry's gross margin from the Benchmarks sheet.
2- List Your Products
One row per product or service, with a code you recognize. Up to 40 rows.
⚡ Tip: Start with your top 20 sellers. They usually carry most of the profit.
3- Enter Prices and Discounts
Use the price you actually charge, and the average discount on that item over the period.
⚡ Tip: Take the average from your sales report, not the discount you wish you gave.
4- Enter Every Direct Cost
Purchase cost, freight and duty, packaging and the card fee percent. Leave a cell blank if a cost doesn't apply.
⚡ Tip: Divide one freight bill by the units it carried to get freight per unit.
5- Read the Status Column
Start with Loss rows, then Below Target rows with the biggest revenue. Compare your price with the price for target.
⚡ Tip: A Check status means a row needs fixing first. The Check column says what.
6- Decide, Then Test the Change
Raise a price, cut a cost or drop a discount. Change the yellow cell and watch the margin move.
⚡ Tip: Use the Price Planner before any promotion to see how many extra units it needs.
7- Add the Business View
Enter rent, salaries, marketing and the other running costs for the same period on Business Margins.
⚡ Tip: Use the same month on every sheet, or the margins won't match.
Common Profit Margin Mistakes
✕ Calling a markup a margin
Why it matters: Profit over cost is markup. Label it margin and a 40% margin shows as 66.7%.
Fix: Divide by the selling price. Keep markup in its own column.
✕ Averaging the row margins
Why it matters: A slow seller with a 60% margin counts as much as your best seller.
Fix: Divide total gross profit by total revenue.
✕ Working from a tax-inclusive price
Why it matters: Treat a $116 VAT inclusive price as revenue and a 40% margin reads as 48.3%.
Fix: Take the tax out first, or set Prices include tax to Yes.
✕ Leaving out freight and fees
Why it matters: Invoice cost alone flatters bulky and low priced items most.
Fix: Add freight, duty, packaging and the fee percent per unit.
✕ Putting rent and salaries into product cost
Why it matters: Gross profit margin drops, and you start cutting products that are fine.
Fix: Keep running costs on the Business Margins sheet.
✕ Ignoring returns
Why it matters: Revenue you refunded still sits in the margin.
Fix: Enter units returned. The template uses net units.
Importance of the Profit Margin Template
Here's a number to sit with. The average US listed company outside finance kept 8.56 cents of every revenue dollar as net profit, across 4,822 firms in NYU Stern's January 2026 data.
Under nine cents. Small mistakes in pricing eat that fast.
Revenue Hides Losses
Cedar Street made a 36.3% blended margin while one product lost $503.88. Totals don't show that. Rows do, and rows are what a profit margin template is built on.
Discounts Cost More Than They Look
At a 30% margin, a 20% discount leaves 12.5%. You need three times the units to earn the same gross profit.
Prices Need a Floor
When a supplier raises costs, the price for target column tells you the new price before you print a single label.
Benchmarks Keep You Honest
A 36% gross margin sounds strong until you see the net margin is 2.8%. The industry comparison tells you whether to look at prices or running costs first.
Profit Margin Spreadsheet vs Software
| Profit margin spreadsheet | Enerpize | |
|---|---|---|
| Product costs | Typed in by hand | Purchase price stored on each product |
| Selling prices | One price per row | Selling price, minimum price and discount per product, plus price lists |
| Sales and refunds | Copied from your sales records | Taken from invoices and refunds |
| Profit by product | Recalculated each month | Product Sales Profit report for any date range |
| Sharing | Email the file | Print or export to CSV, Excel or PDF |
| Best for | Testing prices and planning | Running the numbers every day |
How Enerpize Tracks Profit Margins
What if the margin column filled itself in every time you sold something?
Purchase and Selling Price on Every Product
Each product in Enerpize inventory management holds a purchase price, a selling price, a minimum price and a discount. Enter a profit margin with the purchase price and the system calculates the selling price for you.

Your Whole Range With Both Prices in View
The product list shows the selling price and purchase price for each item next to its stock status. A thin gap between the two lines is easy to spot.

Price Lists for Retail, Trade and Promotions
Price lists set different prices for the same products. You can apply one to a branch, a client, a region or a time period, then use it on invoices.

Product Sales Profit Report
Pick a date range. The report shows sales, refunds, net sales, total cost and profit for each product, with profit as a percent of sales and of cost. Group it by product, client, employee or salesperson, then print or export it.

Notice the total: 46.8% profit to sales, against 36.3% in the template. The report uses each product's cost. The template also counts freight, packaging and card fees. Run both and you'll see what the extras cost you.
Profit on Every Invoice Line
The Yearly Profits Report lists each sale with quantity, unit purchase price, unit selling price, discount and profit, grouped by day, week, month or year. That's where a discount that went too far shows up.

For the whole business view, Enerpize accounting covers your books, and purchase management handles supplier orders and bills.
Profit Margins in the United States
A US price tag usually leaves sales tax off. That makes the margin math simpler, until a return or a discount gets in the way.
The IRS lays out the same order on Schedule C (Form 1040), 2026. Line 1 is gross receipts or sales. Line 2 is returns and allowances. Line 4 is cost of goods sold, worked out in Part III from purchases, cost of labor, materials and supplies and other costs. Line 5 is gross profit.
What to add:
- Set Prices include tax to No if your prices leave sales tax off
- Enter units returned, so revenue matches line 3
- Put direct labor and materials in the cost columns, the way Part III groups them
⚑ Practical note: The template works per unit from what you sold. Schedule C works from opening and closing inventory. Use the template for pricing, and your accounts for the return.
Profit Margins in the United Kingdom
Consumer prices in the UK usually include 20% VAT. If you're VAT registered, that fifth of the price was never yours.
There's a second "margin" too. Under the VAT margin schemes for eligible second-hand goods, HMRC charges VAT on the margin only. Take the purchase price from the selling price, then multiply by 1/6 at the 20% rate. HMRC's example: bought for £1,500, sold for £2,000, a £500 margin and £83.33 VAT. The guidance was last updated on 2 November 2026.
What to add:
- Set Prices include tax to Yes and the rate to 20% if your prices include VAT
- Keep margin scheme stock on its own rows or in its own copy
- Record the purchase price for each margin scheme item, since VAT depends on it
⚑ Practical note: The template's tax setting assumes VAT on the full price. For margin scheme sales, VAT comes out of the margin instead. The profit margin template is not a VAT record.
Profit Margins in India
In India, the MRP on a pack already includes every tax. The Legal Metrology (Packaged Commodities) Rules, 2011 define the retail sale price as "inclusive of all taxes". So the GST has to come out before you measure margin.
A ₹1,180 MRP with 18% GST is ₹1,000 before tax. Your margin starts from ₹1,000.
Dealers in second-hand goods have one more rule. Under Rule 32(5) of the CGST Rules, the taxable value is the selling price minus the purchase price, a negative value is ignored, and no input tax credit can be claimed on the purchase.
What to add:
- Set Prices include tax to Yes and enter your GST rate
- Enter the MRP as the selling price, and the template takes GST out
- Track margin scheme goods on separate rows
⚑ Practical note: Each product can carry a different GST rate. If yours do, use one copy of the template per rate, or enter prices before GST and set Prices include tax to No.
Profit Margins in the United Arab Emirates
UAE shelf prices are shown with 5% VAT included, as the Federal Tax Authority has told businesses. An AED 105 price is AED 100 before VAT.
Two more rules touch margin. The FTA published a VAT guide on the profit margin scheme in January 2026, covering VAT on the margin for eligible goods, including sales at a loss or at breakeven. And corporate tax runs at 9% on taxable profits above AED 375,000, which comes off your net margin, not your gross.
What to add:
- Set Prices include tax to Yes and the rate to 5%
- Enter corporate tax on the Business Margins sheet under income tax
- Keep profit margin scheme goods in their own rows
⚑ Practical note: Gross margin decides prices. Net margin after corporate tax decides what you can reinvest. Check both before you plan the year.
Who Can Use the Profit Margin Template?
Anyone who sells more than one thing, at more than one price, gets something from a profit margin template.
Retail Stores
Hundreds of items, a few that carry the month. Rank them by share of gross profit and price the rest with care. More on retail store management.
Paint and Hardware Shops
Heavy, bulky stock means freight eats margin. The sample is a hardware store for that reason. See Enerpize for paint shops.
Online Sellers
Marketplace fees and returns run high. Put both in and the real margin appears. Selling online? See Enerpize for online stores.
Service Businesses
Treat an hour or a job as the unit, and direct labor as its cost. The sample's shelf installation keeps a 47.7% margin.
Wholesalers and Distributors
Thin margins and big volumes. A one point change on a top seller matters more than ten points on a slow one.
Accountants and Advisors
Hand a client the product sheet before the pricing meeting. The status column starts the conversation.
Profit Margin Glossary
| Term | Meaning |
|---|---|
| Profit margin | Profit as a share of the selling price |
| Markup | Profit as a share of cost |
| Gross profit | Revenue minus cost of goods sold |
| Gross profit margin | Gross profit over revenue |
| Cost of goods sold | The direct cost of what you sold |
| Net price | Price after discount, without tax |
| Full unit cost | Purchase cost plus freight, packaging and fees per unit |
| Blended margin | Total gross profit divided by total revenue |
| EBITDA margin | Profit before interest, tax, depreciation and amortization, over revenue |
| Operating margin | Operating profit over revenue |
| Net margin | Net profit over revenue |
| Margin scheme | A VAT or GST rule that taxes only the margin on eligible goods |
Key Takeaways
- Margin divides profit by price. Markup divides it by cost. A 40% margin is a 66.7% markup.
- Take tax out first. A $116 price with 16% VAT is $100 of revenue.
- Count every direct cost. The sample hose costs $22 to buy and $30.04 to sell.
- Blended margin is total gross profit over total revenue: 36.3% in the sample.
- A healthy total can hide problems. Six of the sample's 12 products are below target or at a loss.
- At a 40% margin, a 10% discount needs 33.3% more units for the same gross profit.
- US listed companies outside finance kept a net margin of 8.56% in January 2026.
- The price for target column turns a low margin into a decision: $44.37 for the sample paint, not $38.
Frequently Asked Questions
How do I calculate profit margin in Excel?
Put the price in B2 and the full unit cost in C2, then enter the profit margin formula =(B2-C2)/B2 and format the cell as a percentage. A $50 price and a $30 cost give 40%. Use the price after discount and without tax.
What is the profit margin formula in Google Sheets?
The same as Excel: =(B2-C2)/B2. To fill a whole column with one formula, use =ARRAYFORMULA(IF(B2:B="","",(B2:B-C2:C)/B2:B)).
What is the difference between margin and markup?
Both use the same profit. Margin divides it by the selling price, markup divides it by the cost. A $50 sale that costs $30 is a 40% margin and a 66.7% markup.
How do I price a product for a 30% margin?
Divide the cost by 0.7. A $30 cost needs a $42.86 price. If you pay a card or marketplace fee, take it off too: cost / (1 minus margin minus fee).
What is a good profit margin for a small business?
It depends on the industry. In January 2026, US listed retailers in special lines kept 35.3% gross and 5.2% net, while software companies kept 71.7% gross. Compare yourself with your own industry and your own trend.
Should profit margin include sales tax, VAT or GST?
No. Tax you collect belongs to the government. Take it out of the price before you work out margin. The template does this when you set Prices include tax to Yes.
What is the difference between gross, operating and net profit margin?
Gross profit margin takes off the cost of goods sold. Operating margin also takes off running costs and depreciation. Net margin takes off interest and tax as well, so it is always the smallest.
How do I calculate one margin across several products?
Divide total gross profit by total revenue. Don't average the product margins, because that ignores how much each product sells.
About the Author
Omar El Bahr is a Senior Digital Growth Specialist at Enerpize, where he leads SEO, content strategy, and organic growth across international markets. He is a Forbes Communications Council contributor and has written for Entrepreneur on business communication and digital strategy.
Disclaimer
The Enerpize profit margin template and this article are for general information. They are not accounting, tax or legal advice, and the template is not a tax form. Sample figures are fictional and screenshots show sample data. Check tax rules with your tax authority or adviser.
