Free Gross Margin Calculator (Excel)
Revenue going up doesn't mean much if your margin is shrinking underneath it. This free calculator shows your gross profit and gross margin percentage — by product or overall — so you can see immediately whether your pricing actually makes you money once direct costs are covered.
No email required · Works in Excel or Google Sheets · Includes a built-in AI prompt
Who this is for
- Product-based business owners setting or checking prices
- Business owners who feel busy but aren't sure if they're actually profitable
- Freelancers and service providers comparing project profitability
- Students learning the difference between revenue and margin
What's included
- Per-product or per-service margin calculator
- Automatic Gross Profit and Gross Margin % calculation
- Side-by-side comparison rows for multiple products
- Built-in AI prompt to flag which products or services are quietly underperforming
Why use a template instead of starting from scratch?
It's easy to eyeball a price and assume it's profitable because the revenue number looks good. Margin only becomes obvious once you actually subtract direct costs — and doing that math by hand for every product, every time you adjust a price, invites errors. This template does it automatically and lets you compare products side by side.
How to Use This Template
Download and open in Excel or Google Sheets
Works identically in either — no macros or add-ins needed.
List each product or service you want to check
Add one row per item if you're comparing multiple products.
Enter the price and the direct cost for each one
Direct cost means what it actually costs you to produce or deliver that specific item — materials, direct labor, packaging, payment processing fees.
Read the automatic Gross Profit and Gross Margin %
The calculator does the subtraction and percentage math for you instantly.
Run the built-in AI prompt to spot what needs attention
Attach the saved file to ChatGPT or Claude and ask which products have the weakest margin and why.
Built-in AI prompt
Once you've filled this template in, it includes a ready-to-use prompt at the bottom of the sheet. Attach your saved file to ChatGPT, Claude, or any AI chat tool and paste it in — you'll get plain-English feedback on which products or services have the weakest margin, how that compares to healthy benchmarks for your type of business, and what to consider changing, no accounting background required.
Common Mistakes to Avoid
Using total business costs instead of direct product costs
Gross margin should only subtract costs directly tied to producing that specific item — rent and admin salaries belong on the P&L as operating expenses, not here.
Ignoring small costs that add up
Payment processing fees, packaging, and shipping supplies are easy to forget but they're real direct costs that shrink your actual margin.
Comparing your margin to the wrong benchmark
A healthy gross margin looks completely different for a software product versus a restaurant versus a retail reseller — compare against your own industry, not a generic number.
Setting a price once and never rechecking it
Material and supplier costs change. A margin that was healthy a year ago can quietly erode if the price never gets revisited.
Frequently Asked Questions
Related Templates
Related Resources
Want the Full Template Library?
70+ editable templates, each with a built-in AI prompt. $7/month, cancel anytime.
Join the Tools Club