The short answer
A product and customer margin report shows what you actually keep on each product and each customer after all the costs to serve them: discounts, rebates, freight, returns, and handling, not just the cost of goods. To build one, combine invoice-level sales from your ERP with true landed product cost and the customer-specific costs that usually sit outside the standard margin calculation.
Key takeaways
- Gross margin on the invoice hides the costs that make some customers unprofitable.
- Start from invoice line detail, not monthly summaries, so you can slice by product and customer.
- Add freight, rebates, returns, and special handling to get net margin by customer.
- A simple margin matrix shows which products and customers to grow, fix, or reprice.
- Agree on cost definitions first. Most margin reports fail on definitions, not math.
Most manufacturers and distributors can tell you revenue by customer in seconds. Ask which customers are actually profitable and the answer takes a week and three spreadsheets, if it comes at all.
That gap matters because the costs that separate a good customer from a bad one rarely show up in the standard margin. Freight terms, rebate programs, return rates, small order sizes, and custom packaging all sit in different places, so the report everyone looks at makes every account look roughly the same.
What is a product and customer margin report?
A product and customer margin report breaks profit down by individual product and individual customer, after the costs specific to each. It answers “where do we make money?” at the level where decisions about pricing, mix, and service get made.
It is different from a standard P&L, which shows profit for the whole business, and from gross margin on an invoice, which ignores what it costs to serve each customer after the sale.
What data do you need to build it?
You need invoice line detail, accurate product cost, and the customer-specific costs that usually live outside the ERP’s margin field.
| Data | Where it usually lives | Why it matters |
|---|---|---|
| Invoice lines | ERP sales history | Revenue and quantity by product, customer, and date |
| Landed product cost | ERP item cost, purchasing, inbound freight | Standard cost often understates what you really paid |
| Discounts and rebates | Pricing agreements, spreadsheets, AP | Rebates paid quarterly are invisible on the invoice |
| Outbound freight | Carrier bills, shipping system | Free freight terms can erase margin on small orders |
| Returns and credits | RMA logs, credit memos | High-return customers cost more than their sales show |
| Cost to serve | Warehouse and service team estimates | Small orders, special packaging, and rush handling add up |
How do you build the report step by step?
Build it in layers, starting with what you trust and adding cost categories one at a time.
- Pull invoice line detail for the last 12 months, by product, customer, quantity, and net price.
- Attach landed product cost to each line, including inbound freight and duties where they apply.
- Allocate rebates and discounts back to the customers and products that earned them.
- Add outbound freight and returns by customer, using actual carrier bills and credit memos.
- Estimate cost to serve with simple drivers, such as orders per month or lines per order.
- Review results with sales and operations before anyone acts on them, so definitions are agreed.
If this means stitching spreadsheets from several systems, or several companies, you are not alone. It is the same problem we covered in why your companies still run on five versions of the same spreadsheet.
Not sure which customers are really profitable? Book a working session and we will scope your margin report together.
How do you read a margin report once it’s built?
Sort customers and products into four groups based on volume and net margin. Each group calls for a different action.
- High volume, high margin: protect and grow. These are your best accounts.
- High volume, low margin: fix. Review pricing, freight terms, rebates, and order patterns.
- Low volume, high margin: grow carefully. There may be room to sell more.
- Low volume, low margin: reprice, set minimums, or move to a lower-cost service model.
The same view works for products. A product that looks healthy on gross margin may slip once returns and special handling are counted.
Should the margin report be a spreadsheet or a dashboard?
A spreadsheet is fine for a first pass to test definitions. Once the logic is agreed, move it to a refreshed dashboard so it updates automatically instead of being rebuilt each quarter.
A dashboard also lets sales see margin before they quote, which is where most margin is won or lost. If your systems cannot supply the data cleanly, the fix may be a better connection between your ERP and other systems rather than a new ERP. Our approach starts by agreeing on the definitions.
Frequently asked questions
What is the difference between gross margin and net margin by customer?
Gross margin by customer is revenue minus product cost on the invoice. Net margin by customer also subtracts the costs of serving that customer, such as rebates, freight, returns, and special handling. Net margin is what shows whether an account is truly profitable, and it often reorders your customer ranking.
How far back should a product margin analysis go?
Twelve months is a good starting point because it covers seasonality and a full rebate cycle. Going back further helps spot trends, but older data may reflect pricing and costs that no longer apply. Start with a year, agree on the method, then extend the history if the business needs it.
Can you build a margin report without changing ERP systems?
Yes, in most cases. The data usually already exists across the ERP, shipping system, and pricing spreadsheets. The work is connecting those sources and agreeing on cost definitions. Replacing an ERP is rarely needed just to get margin visibility, and it takes far longer than building the report.
What is cost to serve?
Cost to serve is the cost of handling a customer’s business beyond the product itself, including order processing, picking and packing, freight, returns, and customer service. Two customers buying the same product can have very different costs to serve, which is why net margin by customer varies so widely.
Who should own the margin report?
Finance usually owns the definitions and accuracy, while sales and operations use it to make decisions. Shared ownership matters. If sales does not trust how costs are allocated, they will ignore the report. Agree on the method together before results are shared, and review it at least quarterly.
