Blog · Finance metrics and formulas
The cost of customer retention divides a defined retention cost pool by retained accounts. Use a worked segment example, cost boundaries, spreadsheet formulas and reconciliation checks to compare your own programs.
The cost of customer retention is a defined retention cost pool divided by retained accounts from the same opening cohort. The result is useful only when the cost scope, customer definition and measurement period stay consistent. It describes spending per account that stayed; it does not prove that the spending caused those accounts to stay.
Cost per retained account = Eligible retention costs / Retained original accounts
Retained original accounts = Opening accounts − Original accounts lost during the period
Use this as a management measure with a written policy. A renewal program's cost pool might include account review labor, renewal messages and concessions granted to keep customers. A broader relationship measure might include routine support as well. Either can answer a business question, but comparisons require the same boundary.
Keep acquisition outside this calculation. The distinction between winning new business and preserving existing business belongs in customer acquisition versus retention. Customers added during the period also stay outside the retained-account denominator, even when the same team works on both activities.
Decide how to treat concession dollars. In this example, they are an economic cost of retention, recorded as a positive analytical amount even if the accounting entry reduces revenue. They must not also appear in the campaign expense line. When assessing contribution after retention, check whether those credits already reduced net sales before deducting them again.
Use an opening customer list, a closing customer list or qualifying transaction export, and the ledger or program cost register. Join them by a stable account ID. A renamed customer is still the same account; a parent company with several billing accounts needs one consistent counting rule.
For a subscription business, specify whether retained means active, paying or renewed at the cutoff. For a repeat-order business, specify the inactivity window and seasonality treatment. The cohort retention table method covers the account test in detail.
The cost register needs transaction ID, posting date, account or segment, activity, amount and inclusion flag. Labor allocations also need recorded hours and the approved loaded hourly rate. Reconcile allocated hours to available team hours so the same work cannot be assigned to several programs.
Keep the invoices, credit documents and payroll support behind the rows. The IRS recordkeeping guidance identifies purchases, sales and payroll transactions as sources of supporting documents. Those records make the management allocation traceable as well.
An illustrative US business-services company measures its opening customers from January 1 through March 31, 2026. Its program-only scope includes renewal labor, campaign costs and retention concessions. Routine delivery and new-customer acquisition are excluded.
First, classify the source cost pool. Amounts are exact USD values.
| Cost register classification | Amount (USD) | Included in retention cost? |
|---|---|---|
| Renewal labor | 26,400 | Yes |
| Retention campaigns | 6,600 | Yes |
| Retention concessions | 3,000 | Yes, counted once |
| New-customer acquisition | 12,000 | No |
| Routine delivery | 18,000 | No |
| Source pool total | 66,000 |
Eligible retention cost is 26,400 + 6,600 + 3,000 = $36,000. The excluded amounts total 12,000 + 18,000 = $30,000, and the complete classification returns 36,000 + 30,000 = $66,000.
Allocate the eligible rows to the segments below. Program costs include work on the opening accounts that subsequently left, as well as those that stayed.
| Segment | Opening accounts | Retained accounts | Renewal labor (USD) | Campaigns (USD) | Concessions (USD) |
|---|---|---|---|---|---|
| Industrial clients | 60 | 54 | 10,800 | 2,700 | 1,500 |
| Healthcare clients | 40 | 38 | 7,600 | 1,900 | 500 |
| Business services clients | 50 | 40 | 8,000 | 2,000 | 1,000 |
| Total | 150 | 132 | 26,400 | 6,600 | 3,000 |
For spreadsheet columns A:F in that order, calculate eligible cost in G2, cost per retained account in H2 and retention rate in I2:
=SUM(D2:F2)
=IF(C2=0,NA(),G2/C2)
=IF(B2=0,NA(),C2/B2)
Fill the formulas down through row 4. Dollar ratios below are rounded to two decimals; retention percentages are exact.
| Segment | Cost calculation (USD) | Eligible cost (USD) | Cost per retained account (USD) | Retention rate |
|---|---|---|---|---|
| Industrial clients | 10,800 + 2,700 + 1,500 | 15,000 | 277.78 | 90% |
| Healthcare clients | 7,600 + 1,900 + 500 | 10,000 | 263.16 | 95% |
| Business services clients | 8,000 + 2,000 + 1,000 | 11,000 | 275.00 | 80% |
| Total | 15,000 + 10,000 + 11,000 | 36,000 | 272.73 | 88% |
The company cost is 36,000 / 132 = $272.73. Its retention rate is 132 / 150 = 88%. Divide totals; averaging the segment cost ratios would give each segment equal weight regardless of how many accounts stayed.
The cost columns must reproduce the eligible cost register: labor of $26,400, campaigns of $6,600 and concessions of $3,000. Any unallocated row remains visible as an exception until assigned or explicitly excluded. Do not spread a difference across segments merely to make the total match.
The account bridge must also close:
| Segment | Opening accounts | Lost accounts: opening minus retained | Retained accounts |
|---|---|---|---|
| Industrial clients | 60 | 6 | 54 |
| Healthcare clients | 40 | 2 | 38 |
| Business services clients | 50 | 10 | 40 |
| Total | 150 | 18 | 132 |
Thus 150 − 18 = 132. Count each opening account once. On a deduplicated account sheet, a conditional count can test segment and retained status together; COUNTIFS documentation describes this multiple-condition count. Covirage is not affiliated with Microsoft or Google.
Healthcare clients have the lowest measured cost per retained account and the highest retention rate in this example. That is a starting point for review, not proof of better program performance. Contract terms, account size and the likelihood of leaving may differ by segment.
Finance owns cost boundaries and reconciliations. Customer success or account management owns activity classification and account status. Together they should compare retained contribution with spending. For routine delivery economics, use cost to serve; for the losses from departures, use cost of customer churn.
Bring your customer status export and retention cost workbook to Covirage. Covirage maps the columns, and its tools compute and check eligible spending, retained-account counts and segment ratios; the external AI model explains the results with every figure traced to its rows. Create a free Covirage account, which takes about a minute, and bring a sample of your own data.
See customer profitability for the wider account economics behind the retention decision.
Include costs whose purpose fits your stated retention scope, such as renewal outreach, account review labor and retention campaigns. Show concessions separately because they can reduce revenue rather than appear as expenses. Keep routine fulfillment and acquisition spending outside a program-only measure.
Divide by retained original accounts when reporting cost per retained account. Dividing by the opening customer base gives spending per account exposed to the program, which answers a different question. Label both measures clearly and exclude new customers from the retention denominator.
A lower cost can reflect efficient work, easier accounts or a narrower cost definition. Review retained contribution and service levels alongside the figure. Cost per retained account does not establish how many customers stayed because of the program.
Retention costs describe a defined effort to keep customers. Cost to serve describes resources used to fulfill and support their business. Some activities overlap, so assign each cost once and document which measure includes it before combining the results.