EN
Shipping and Logistics

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
  1. What will you be able to do by the end of this training?
  2. Lesson 1: Why doesn't customer revenue show profitability?
  3. Lesson 2: How do you prepare data for the analysis?
  4. Lesson 3: How do you find a customer's gross profit?
  5. Lesson 4: How do you calculate the financing cost of payment terms?
  6. Lesson 5: How do you factor in the cost per order?
  7. Lesson 6: How do you rank customer contribution?
  8. Lesson 7: What do you do about an unprofitable or low-contribution customer?
  9. Lesson 8: How do you track customer profitability monthly?
  10. What are the most common mistakes in customer profitability?
  11. How do you track customer profitability with NetKasam?
  12. Mini quiz: Test what you have learned
  13. Conclusion: calculate the contribution of your five largest customers
  14. 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.

Training mapThe six steps of customer profitability analysis
  1. 01
    DataPull each customer's sales, discounts, returns, collections and order count.
  2. 02
    GrossFind gross profit from net sales and cost of goods sold.
  3. 03
    Payment termsCalculate the financing cost from the average collection days.
  4. 04
    OrdersAdd number of orders × cost per order.
  5. 05
    ContributionRank customer contribution and contribution margin.
  6. 06
    ActionSet 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.

FactorHow does it affect profit?Difference between customers
DiscountLowers the unit priceA large customer may get a higher discount
ReturnReduces net sales and profit; processing returns brings costsSome customers return a lot
DueYou receive the money late; a financing cost arisesPayment terms can range from 15 to 90 days
Order frequencyEach order brings a fixed processing costMany small orders are expensive
Product mixBuying high- or low-margin productsVaries 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.

  1. Choose the period: At least 12 months; because of seasonality, a short period misleads.
  2. Work out net sales: Gross sales − discounts − returns (include return invoices).
  3. Add the cost: The cost of goods sold for the products the customer bought.
  4. Find the collection days: Account balance ÷ daily sales, or the difference between invoice and payment dates.
  5. 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 Calculator

Lesson 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):

CustomerNet salesGross marginGross profitDays to collectNumber of orders
A: Yıldız Market600.000 ₺%35210.000 ₺75120
B: Demir Gıda400.000 ₺%40160.000 ₺3080
C: Akın Tekstil250.000 ₺%3895.000 ₺4550
D: Su Elektrik150.000 ₺%4567.500 ₺1520
E: Ay Kırtasiye100.000 ₺%3030.000 ₺90200
Total1.500.000 ₺%37,5562.500 ₺470
ChartFive customers' share of net sales: A and B make two-thirds of sales
  • 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.

FormulaThe six formulas of the customer profitability calculation
  1. Net sales = Gross sales − Discounts − Returns
  2. Gross profit = Net sales − Cost of goods sold
  3. Financing cost = Net sales × Collection days ÷ 360 × Annual rate
  4. Order cost = Number of orders × Fixed cost per order
  5. Customer contribution = Gross profit − Financing cost − Order cost
  6. 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.

CustomerGross profitFinancingOrder costCustomer contributionContribution margin
A: Yıldız Market210.000 ₺30.000 ₺18.000 ₺162.000 ₺%27,0
B: Demir Gıda160.000 ₺8.000 ₺12.000 ₺140.000 ₺%35,0
C: Akın Tekstil95.000 ₺7.500 ₺7.500 ₺80.000 ₺%32,0
D: Su Elektrik67.500 ₺1.500 ₺3.000 ₺63.000 ₺%42,0
E: Ay Kırtasiye30.000 ₺6.000 ₺30.000 ₺−6.000 ₺−%6,0
Total562.500 ₺53.000 ₺70.500 ₺439.000 ₺%29,3
ChartAt Yıldız Market, from ₺600,000 in net sales to ₺162,000 in customer contribution
  1. Net sales₺600,000
  2. Cost of goods sold−₺390,000
  3. Gross profit₺210,000
  4. Financing cost (75 days)−₺30,000
  5. Order cost (120 orders)−₺18,000
  6. Customer contribution₺162,000

Prepared with sample values.

ChartContribution margin: A, first in revenue, is second to last in margin; E is not on the chart because it is at a loss (−6.0%)
  1. D: Su Elektrik42.0%
  2. B: Demir Gıda35.0%
  3. C: Akın Tekstil32.0%
  4. 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.

CustomerProblemActionExpected effect (example)
E: Ay Kırtasiye200 small orders, 90-day payment termsMinimum order and weekly consolidated orders; cutting payment terms to 45 daysIf 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 MarketHigh discount, 75-day payment termsMoving payment terms to 60 days or charging deferred payment chargeFinancing ₺30,000 → ₺24,000: contribution +₺6,000
C: Akın TekstilModerateMonitoring; raising the margin with promotions-
D: Su ElektrikNo problem, small volumeOffers and promotions to increase volumeGrowth 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 monthCheck customer balances, average collection days and limitsAccounting
Once a quarterPull the customer contribution table and compare the rankingAccounting, sales
Once a quarterSet actions for unprofitable and low-contribution customersSales manager
Once a yearReview discount, payment term and minimum order policiesManagement
Takeaways from the exampleFour numbers from the example customer analysis
  • ₺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?

  1. Judging customers by revenue. Discounts, payment terms and order costs are ignored.
  2. Ignoring the cost of payment terms. A customer with long payment terms looks good in the profit table.
  3. Not accounting for cost per order. A customer with small orders is mistaken for a profitable one.
  4. Skipping returns. The net sales of a customer who returns a lot shrink.
  5. Deciding on a single period's data. Seasonality misleads.
  6. Dropping an unprofitable customer outright. First try to improve things with payment term, price and order rules.
  7. 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.

  1. If net sales are ₺240,000, gross margin is 40%, collection days are 60 and annual financing is 24%, what is the financing cost?
  2. If the same customer placed 60 orders and the cost per order is ₺150, what is the customer contribution?
  3. What is the contribution margin?
  4. Why can the customer ranked first by revenue be last in contribution margin?
  5. What is the first action for an unprofitable customer with many small orders?

Answer key:

  1. 240.000 × 60 ÷ 360 × 0,24 = 9.600 ₺.
  2. Gross profit ₺96,000; order cost ₺9,000; contribution 96,000 − 9,600 − 9,000 = ₺77,400.
  3. 77.400 ÷ 240.000 = %32,25.
  4. High discounts, long payment terms and many orders lower the margin; revenue does not show these.
  5. 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.

Start FreeProfit Margin Calculator

Read similar articles

19 free tools

Commission, shipping, VAT and profit calculations in your browser, no sign-up needed.

All tools