How to Calculate Customer Profitability? Training on Which Customers Make You Money After Discounts, Returns, Payment Terms and Order Costs
How do you calculate customer profitability? Customer contribution after discounts, returns, payment terms and order costs, and spotting unprofitable customers: an 8-lesson guide with examples.
Contents 14 sections
- What will you be able to do by the end of this training?
- Lesson 1: Why doesn't customer revenue show profitability?
- Lesson 2: How do you prepare data for the analysis?
- Lesson 3: How do you find a customer's gross profit?
- Lesson 4: How do you calculate the financing cost of payment terms?
- Lesson 5: How do you factor in the cost per order?
- Lesson 6: How do you rank customer contribution?
- Lesson 7: What do you do about an unprofitable or low-contribution customer?
- Lesson 8: How do you track customer profitability monthly?
- What are the most common mistakes in customer profitability?
- How do you track customer profitability with NetKasam?
- Mini quiz: Test what you have learned
- Conclusion: calculate the contribution of your five largest customers
- Frequently Asked Questions About Customer Profitability
Your largest customer's name comes up in every meeting: they buy ₺600,000 a year and everyone is afraid of losing them. But you give that customer discounts, collect payment in 75 days and deal with dozens of small orders a month. A small customer who bought ₺150,000 the same year, pays in 15 days and works with a small number of orders may be earning you proportionally much more. The customer with the biggest revenue may not be the most profitable. The way to see this is a customer profitability analysis.
This article is not a narrative but an 8-lesson hands-on training. We will answer the question how do you calculate customer profitability with a five-customer example: net sales, the effect of discounts and returns, the financing cost of payment terms and collection time, cost per order and customer contribution. Then we will identify the unprofitable customer and see what to do about them. At the end there is a mini quiz and a monthly routine. For the value a customer will bring over the whole relationship, see the article on customer lifetime value; here we measure what that customer earns you this period.
What will you be able to do by the end of this training?
In short: For each customer, you will find net sales, gross profit, payment term cost and order cost, rank customer contribution, identify the unprofitable customer and choose the right action for them.
- 01DataPull each customer's sales, discounts, returns, collections and order count.
- 02GrossFind gross profit from net sales and cost of goods sold.
- 03Payment termsCalculate the financing cost from the average collection days.
- 04OrdersAdd number of orders × cost per order.
- 05ContributionRank customer contribution and contribution margin.
- 06ActionSet price, payment term and order rules for unprofitable and low-contribution customers.
The 8 lessons of the training: (1) why revenue misleads, (2) data preparation, (3) gross profit, (4) payment term cost, (5) order cost, (6) ranking customer contribution, (7) action for unprofitable customers, (8) monthly routine.
Lesson 1: Why doesn't customer revenue show profitability?
In short: Revenue shows only the sales amount. Because discounts, returns, payment terms and order frequency differ from customer to customer, the same revenue produces very different profits.
| Factor | How does it affect profit? | Difference between customers |
|---|---|---|
| Discount | Lowers the unit price | A large customer may get a higher discount |
| Return | Reduces net sales and profit; processing returns brings costs | Some customers return a lot |
| Due | You receive the money late; a financing cost arises | Payment terms can range from 15 to 90 days |
| Order frequency | Each order brings a fixed processing cost | Many small orders are expensive |
| Product mix | Buying high- or low-margin products | Varies with the customer's product preferences |
Lesson 2: How do you prepare data for the analysis?
In short: For each customer you need 12 months of net sales, cost of goods sold, returns, average collection days and number of orders. The data comes from customer account and invoice records; that is why the accuracy of the records determines the quality of the analysis.
- Choose the period: At least 12 months; because of seasonality, a short period misleads.
- Work out net sales: Gross sales − discounts − returns (include return invoices).
- Add the cost: The cost of goods sold for the products the customer bought.
- Find the collection days: Account balance ÷ daily sales, or the difference between invoice and payment dates.
- Count the orders: Annual number of orders per customer.
For tracking account balances and payment terms, see the article how to track customer accounts; for return records, see return invoice. In NetKasam, you manage customer and supplier accounts, generate statements and export customer sales to Excel with saved reports (customer account tracking, reports).
Free toolProfit Margin CalculatorLesson 3: How do you find a customer's gross profit?
In short: Gross profit = net sales − cost of goods sold. Gross margin by customer shows the combined effect of discounts and product mix.
Our example business's five customers (annual; figures are chosen only to illustrate the method):
| Customer | Net sales | Gross margin | Gross profit | Days to collect | Number of orders |
|---|---|---|---|---|---|
| A: Yıldız Market | 600.000 ₺ | %35 | 210.000 ₺ | 75 | 120 |
| B: Demir Gıda | 400.000 ₺ | %40 | 160.000 ₺ | 30 | 80 |
| C: Akın Tekstil | 250.000 ₺ | %38 | 95.000 ₺ | 45 | 50 |
| D: Su Elektrik | 150.000 ₺ | %45 | 67.500 ₺ | 15 | 20 |
| E: Ay Kırtasiye | 100.000 ₺ | %30 | 30.000 ₺ | 90 | 200 |
| Total | 1.500.000 ₺ | %37,5 | 562.500 ₺ | 470 |
- A: Yıldız Market₺600,00040%
- B: Demir Gıda₺400,00026.7%
- C: Akın Tekstil₺250,00016.7%
- D: Su Elektrik₺150,00010%
- E: Ay Kırtasiye₺100,0006.7%
Prepared with sample values.
Ranked by gross profit, the order is A, B, C, D, E. A looks like the largest customer and E the smallest. When payment terms and order costs are added, the picture changes.
Lesson 4: How do you calculate the financing cost of payment terms?
In short: Financing cost = net sales × collection days ÷ 360 × annual financing rate. A receivable outstanding with a customer is your own cash; its cost should be charged against profit.
- Net sales = Gross sales − Discounts − Returns
- Gross profit = Net sales − Cost of goods sold
- Financing cost = Net sales × Collection days ÷ 360 × Annual rate
- Order cost = Number of orders × Fixed cost per order
- Customer contribution = Gross profit − Financing cost − Order cost
- Contribution margin = Customer contribution ÷ Net sales
The annual rate is your own financing cost; 24% is assumed in the example.
In the example, the annual financing cost is 24% (2% per month). For A: 600,000 × 75 ÷ 360 × 0.24 = ₺30,000. For B: 400,000 × 30 ÷ 360 × 0.24 = ₺8,000. For C: 250,000 × 45 ÷ 360 × 0.24 = ₺7,500. For D: 150,000 × 15 ÷ 360 × 0.24 = ₺1,500. For E: 100,000 × 90 ÷ 360 × 0.24 = ₺6,000. To find your own financing cost, see the loan calculator tool; for calculating late payment charges, see the article how to calculate deferred payment charge.
Recommended readingHow to Calculate Late Payment Interest?Lesson 5: How do you factor in the cost per order?
In short: Each order brings a fixed processing cost regardless of quantity: invoicing, packaging, shipping preparation, collection follow-up. That is why a customer who places many small orders is expensive.
In the example, the fixed cost per order is ₺150. Order costs: A 120 × 150 = ₺18,000; B 80 × 150 = ₺12,000; C 50 × 150 = ₺7,500; D 20 × 150 = ₺3,000; E 200 × 150 = ₺30,000. E's average order size is 100,000 ÷ 200 = ₺500 in net sales and ₺150 in gross profit; in other words, each order only covers its own processing cost.
Lesson 6: How do you rank customer contribution?
In short: Customer contribution = gross profit − financing cost − order cost. Rank customers by contribution amount and contribution margin; together they produce a picture very different from the revenue ranking.
| Customer | Gross profit | Financing | Order cost | Customer contribution | Contribution margin |
|---|---|---|---|---|---|
| A: Yıldız Market | 210.000 ₺ | 30.000 ₺ | 18.000 ₺ | 162.000 ₺ | %27,0 |
| B: Demir Gıda | 160.000 ₺ | 8.000 ₺ | 12.000 ₺ | 140.000 ₺ | %35,0 |
| C: Akın Tekstil | 95.000 ₺ | 7.500 ₺ | 7.500 ₺ | 80.000 ₺ | %32,0 |
| D: Su Elektrik | 67.500 ₺ | 1.500 ₺ | 3.000 ₺ | 63.000 ₺ | %42,0 |
| E: Ay Kırtasiye | 30.000 ₺ | 6.000 ₺ | 30.000 ₺ | −6.000 ₺ | −%6,0 |
| Total | 562.500 ₺ | 53.000 ₺ | 70.500 ₺ | 439.000 ₺ | %29,3 |
- Net sales₺600,000
- Cost of goods sold−₺390,000
- Gross profit₺210,000
- Financing cost (75 days)−₺30,000
- Order cost (120 orders)−₺18,000
- Customer contribution₺162,000
Prepared with sample values.
- D: Su Elektrik42.0%
- B: Demir Gıda35.0%
- C: Akın Tekstil32.0%
- A: Yıldız Market27.0%
Prepared with sample values.
Result: A is first in revenue and first in contribution amount, but second to last in contribution margin; the discount and 75-day payment terms it gets bring its margin down. D is small but has the highest margin. E, with ₺100,000 in revenue, causes a loss of ₺6,000.
Lesson 7: What do you do about an unprofitable or low-contribution customer?
In short: First find the cause: is the discount too high, the payment term too long, or the orders small and frequent? Depending on the cause, apply price, payment term, minimum order or order consolidation; if none of these work, restructure the relationship.
| Customer | Problem | Action | Expected effect (example) |
|---|---|---|---|
| E: Ay Kırtasiye | 200 small orders, 90-day payment terms | Minimum order and weekly consolidated orders; cutting payment terms to 45 days | If orders fall to 100, the cost is ₺15,000; if payment terms become 45 days, financing is ₺3,000: contribution +₺18,000 |
| A: Yıldız Market | High discount, 75-day payment terms | Moving payment terms to 60 days or charging deferred payment charge | Financing ₺30,000 → ₺24,000: contribution +₺6,000 |
| C: Akın Tekstil | Moderate | Monitoring; raising the margin with promotions | - |
| D: Su Elektrik | No problem, small volume | Offers and promotions to increase volume | Growth at the same margin |
The effect of two changes for E: if orders drop from 200 to 100, the order cost becomes ₺15,000; if payment terms drop from 90 to 45 days, the financing cost becomes 100,000 × 45 ÷ 360 × 0.24 = ₺3,000. The new contribution is 30,000 − 3,000 − 15,000 = ₺12,000, that is, a move from a loss to +₺12,000 (from −6,000 to 12,000, a total improvement of ₺18,000). On the price side, see the articles discounting without losing money and wholesale and retail price list, and the logic of minimum orders.
Lesson 8: How do you track customer profitability monthly?
In short: Refresh the customer contribution table once a quarter; track payment terms and limits every month. Write down action dates for unprofitable customers and measure the result in the next quarter.
| When? | What to do? | Who? |
|---|---|---|
| Every month | Check customer balances, average collection days and limits | Accounting |
| Once a quarter | Pull the customer contribution table and compare the ranking | Accounting, sales |
| Once a quarter | Set actions for unprofitable and low-contribution customers | Sales manager |
| Once a year | Review discount, payment term and minimum order policies | Management |
- ₺439,000total contribution of the five customers (29.3%)
- 27.0%contribution margin of the largest customer
- −₺6,000contribution of the small customer with many orders
- +₺18,000effect of the payment term and order changes for E
For a customer-based price and discount policy, in NetKasam you can define discounts or promotions for your customers individually or in groups (special price settings). To link customer profitability results to a sales bonus plan, see the article how to calculate sales bonuses.
What are the most common mistakes in customer profitability?
- Judging customers by revenue. Discounts, payment terms and order costs are ignored.
- Ignoring the cost of payment terms. A customer with long payment terms looks good in the profit table.
- Not accounting for cost per order. A customer with small orders is mistaken for a profitable one.
- Skipping returns. The net sales of a customer who returns a lot shrink.
- Deciding on a single period's data. Seasonality misleads.
- Dropping an unprofitable customer outright. First try to improve things with payment term, price and order rules.
- Doing the analysis only once. Customer behavior changes; repeat it quarterly.
How do you track customer profitability with NetKasam?
- Customer accounts and statements. You manage customer balances and generate and share statements (customer account tracking).
- Risk and discount settings. You classify customers and define separate discounts and limits; new sales are restricted at the risk level.
- Customer groups. You classify customers and suppliers into groups and run special promotions and announcements.
- Reminders. Automatic reminders are sent for payments coming due and overdue.
- Saved reports. You save the customer sales report and export it to Excel (reports).
- Invoice tracking. You track issued invoices and returns (invoice tracking).
- Bookkeeping is free. e-Invoice, customer and supplier accounts, inventory, cash, bank and expense management are free in every plan; see the pricing page for details.
Mini quiz: Test what you have learned
In short: Answer the 5 questions below, then compare with the answer key. 4 or 5 correct shows you have completed the training.
- If net sales are ₺240,000, gross margin is 40%, collection days are 60 and annual financing is 24%, what is the financing cost?
- If the same customer placed 60 orders and the cost per order is ₺150, what is the customer contribution?
- What is the contribution margin?
- Why can the customer ranked first by revenue be last in contribution margin?
- What is the first action for an unprofitable customer with many small orders?
Answer key:
- 240.000 × 60 ÷ 360 × 0,24 = 9.600 ₺.
- Gross profit ₺96,000; order cost ₺9,000; contribution 96,000 − 9,600 − 9,000 = ₺77,400.
- 77.400 ÷ 240.000 = %32,25.
- High discounts, long payment terms and many orders lower the margin; revenue does not show these.
- Applying a minimum order quantity and consolidated (weekly) orders.
Frequently Asked Questions About Customer Profitability
How do you calculate customer profitability?
For each customer, subtract the cost of goods sold from net sales, then deduct the financing cost of payment terms and the processing cost per order. The result is customer contribution; divided by net sales, it gives the contribution margin.
Why does financing cost enter customer profitability?
A receivable outstanding with a customer is your own cash, and it has a cost. A customer with long payment terms earns you less at the same gross profit.
How do you find the cost per order?
Measure the time and material cost per order of invoicing, packaging, shipping preparation and collection follow-up for a week, and divide by the number of orders.
Why might a customer with high revenue not be profitable?
High discounts, long payment terms, many orders and returns reduce the margin. Revenue does not show these effects.
What do you do if there is an unprofitable customer?
First look at the cause; try shortening payment terms, a minimum order, consolidating orders and adjusting prices. If none of these work, the relationship is restructured.
Is customer profitability the same as customer lifetime value?
No. Customer profitability measures the contribution for the period; lifetime value estimates the total value the customer will bring over the whole relationship.
Can I define customer-specific discounts in NetKasam?
Yes. You can define discounts or promotions for your customers individually or in groups, and do this from the account detail or product detail pages.
Does NetKasam send customers payment due reminders?
Yes. It sends automatic reminders for payments coming due or overdue; you can also send balance reminders by bulk SMS.
Conclusion: calculate the contribution of your five largest customers
Customer profitability does not require a big analytics system. Pick your five largest customers, work out net sales, gross profit, payment term cost and order cost for each, and rank them by contribution margin. If an unexpected ranking emerges, the first customer you should talk to is not the one first in revenue but the one last in contribution.
Bookkeeping Is Now Completely Free
Manage your bookkeeping and e-Invoice operations with NetKasam without paying a thing. Customer and supplier accounts, inventory, collections and more in one panel, completely free.