About the Customer Profitability Calculator
This customer profitability calculator works out how much one customer or account actually earns you once every cost of serving them is counted. Revenue is easy to see in your sales reports; what is often hidden is the cost to serve — the discounts and rebates you granted, the cost of the goods, the handling and freight on every order, support time, account management and the cost of financing slow payers.
Enter a year of activity for the customer and the calculator walks from gross revenue down to net revenue, gross profit, operating profit after cost to serve and finally annual profit after spreading the original acquisition cost over the expected relationship. It also shows profit margin, profit per order and lifetime profit over the years you expect to keep the customer.
Use it in a customer profitability analysis to compare key accounts, to decide whether a large but demanding client is worth its discounts, to set minimum order sizes or to price a renewal. The financing cost assumes the customer’s balance is outstanding for the days-to-pay you enter, funded at your cost of capital.
With the default inputs, the annual customer profit (after cac) is $35,545.62. Change any value above to recalculate instantly.
How to use the customer profitability calculator
- 1Enter a year of gross sales for the customer and the discount or rebate rate they receive.
- 2Enter product cost as a percentage of net sales (100% minus your gross margin).
- 3Add the number of orders and what each order costs you to handle and ship.
- 4Add support hours, account management cost and how long the customer takes to pay.
- 5Enter what it cost to win the customer and how many years you expect to keep them.
- 6Compare annual profit and margin across customers to find your best and worst accounts.
Formula and method
Net revenue is gross sales R less discounts and rebates D. Gross profit is net revenue less product cost, entered as a percentage of net revenue. Cost to serve adds the per-order handling and freight cost times the number of orders, support hours times the loaded hourly cost, account management cost and the financing cost of receivables — net revenue × days-to-pay ÷ 365 × cost of capital k, which approximates the average balance the customer owes you over the year.
Operating profit is gross profit minus cost to serve. To compare customers fairly, the one-time acquisition cost is spread evenly over the expected lifetime and subtracted to give annual customer profit. Lifetime profit is operating profit × lifetime years minus the acquisition cost, without discounting.
- R
- Gross annual sales to the customer
- D
- Discounts, rebates and allowances
- k
- Annual cost of capital
- CAC
- One-time customer acquisition cost
Worked examples
Healthy wholesale account
A 5% discount turns $120,000 of sales into $114,000 of net revenue, and 60% product cost leaves $45,600 gross profit. Orders ($2,880), support ($1,800), account management ($3,000) and 45 days of receivables at 8% ($1,124) cost $8,804 to serve. After spreading the $5,000 acquisition cost over 4 years, the customer earns about $35,546 a year.
High-maintenance, heavily discounted customer
After a 12% discount and 65% product cost the account produces only $12,320 of gross profit, but 120 small orders ($7,200), 150 support hours ($6,750), account management and slow payment cost $17,529 to serve. The customer loses about $5,209 a year before acquisition cost and $7,875 after it.
Large key account with few big orders
Net revenue is $230,000 and 30% gross margin gives $69,000. Twelve large orders cost $2,400 to handle and ship, support $1,200, account management $6,000 and 60 days of receivables at 10% about $3,781, so cost to serve is $13,381. The account earns $55,619 a year — a 24.2% margin.
Frequently asked questions
How do you calculate customer profitability?+
Start with the revenue the customer generates, subtract discounts and the cost of the products sold to them, then subtract every cost of serving that customer — order processing, delivery, support, sales effort and the cost of extended payment terms. Spreading the acquisition cost over the relationship gives a fair annual profit.
What is cost to serve?+
Cost to serve is the total cost of supporting a customer beyond the product itself: handling and shipping orders, customer service, account management, returns, special packaging and financing the time they take to pay. Two customers with the same revenue can have very different costs to serve.
Why can a big customer be unprofitable?+
Large customers often negotiate deep discounts, long payment terms, frequent small deliveries and dedicated service. Each concession is reasonable on its own, but together they can push the cost to serve above the gross profit the volume generates.
How is customer profitability different from customer lifetime value?+
Customer profitability usually looks at actual profit over a period such as a year, with all costs to serve allocated. Customer lifetime value projects future profit over the whole relationship, often with churn and discounting. This calculator shows both an annual and a simple lifetime figure.
What should I do with unprofitable customers?+
Common fixes are raising prices, reducing discounts, introducing minimum order sizes or delivery charges, moving the customer to lower-cost service channels and enforcing payment terms. Only drop a customer if those changes fail and they do not cover any of your fixed costs.
Results are estimates for educational purposes and are not financial advice. Rates, fees and terms vary — confirm with your lender or a licensed advisor before making decisions.