Cost of customer churn: measure the lost contribution

The cost of customer churn is the contribution lost when customers leave, plus incremental spending to replace them and handle their exit. Calculate it over a stated period and distinguish the estimate from booked expenses. Lost sales are an opportunity shortfall, not a new expense in the general ledger.

1. Define the departures and the time horizon

Start with a customer billing export containing account ID, invoice date, net revenue and product or service. Add confirmed termination dates or the inactivity rule used to identify departures. For repeat-order businesses, B2B churn without a subscription explains why silence alone may not establish a lost customer.

Choose one reporting window. An account that leaves at the beginning loses more selling months than an account that leaves near the end. Expected purchases should reflect contracts, order cadence and seasonality, rather than automatically extending the latest invoice.

The worked example uses an illustrative US maintenance supplier and the April 1 through June 30, 2026 budget window. Departures occur at the start of April, May and June. Expected monthly sales remain steady under the example's assumptions, and no replacement contribution arrives within the window.

2. Assemble revenue, avoidable cost and spending rows

Use the finance team's approved customer forecast or expected order schedule for revenue that would have occurred without the departures. Match the related costs that stop when those orders stop. The relevant contribution is revenue less those avoidable costs; OpenStax explains contribution margin as revenue available after variable costs to cover fixed expenses and profit.

Replacement spending is incremental campaign and sales activity assigned to these departures. Exit costs are documented transition work. Original acquisition spending is excluded because it has already occurred; the customer acquisition cost method covers that separate measure.

Retain cost-document IDs and allocation support. The IRS recordkeeping guidance explains how business transactions generate supporting documents used in the books. Use those records to reconcile the spend, while keeping estimated lost revenue clearly labeled.

3. Calculate each component in the spreadsheet

Lost contribution = Expected lost revenue − Costs avoided

Churn exposure before replacement contribution = Lost contribution + Incremental replacement spending + Exit costs

Place the input table in columns A:F, with Alder on row 2. In G2:J2, enter these formulas and fill through row 4:

=B2*D2
=C2*D2
=G2-H2
=I2+E2+F2

The formulas return lost revenue, avoided costs, lost contribution and total exposure, respectively. These formulas work in Excel and Google Sheets. No rounding is needed for the example's whole-dollar calculations.

The company loses $52,000 of expected revenue but avoids $31,400 of costs. The contribution shortfall is therefore $20,600. Replacement spending totals $3,900 and exit costs total $1,300, giving 20,600 + 3,900 + 1,300 = $25,800 of exposure.

4. Reconcile the result and replacement activity

The first identity is 52,000 − 31,400 = $20,600. The second is 20,600 + 5,200 = $25,800. Summing J2:J4 must equal the same component totals:

=SUM(J2:J4)
=SUM(G2:G4)-SUM(H2:H4)+SUM(E2:E4)+SUM(F2:F4)

For a transaction-level spend sheet with account IDs in column A, amounts in B and spending type in C, the replacement-spend check for the account in A2 is:

=SUMIFS(Spend!B:B,Spend!A:A,A2,Spend!C:C,"Replacement")

SUMIFS documentation confirms that the function sums rows meeting multiple criteria. Covirage is not affiliated with Microsoft or Google.

Tie the spending totals to approved ledger categories and investigate unassigned amounts. Also reconcile the departed-account list to customer status records. A customer-level total built from duplicate billing IDs will inflate both losses and replacement allocations.

If replacement customers contribute during the window, subtract their incremental contribution when reporting the net shortfall. Keep their acquisition spending visible. Otherwise the report can imply that all lost sales stayed unfilled after new business had already restored part of them.

Where it goes wrong

• Adding revenue and contribution losses. Contribution already starts from lost revenue. Adding both counts the same loss twice.
• Assuming every allocated cost disappears. Fixed salaries or rent may remain after the account leaves. Only deduct documented avoidable costs.
• Mixing horizons. A full year's lost sales and a quarter's replacement spending do not describe a consistent window.
• Charging historical acquisition again. Original acquisition spending belongs in customer lifetime cost, not as a newly incurred consequence of departure.
• Treating the estimate as a retention budget. Compare intervention spending with expected contribution preserved and uncertainty; cost of customer retention measures that spending separately.

Measure churn exposure on your own file in Covirage

Bring your billing export, customer cost file and replacement-spend records to Covirage. Covirage maps the columns, and its tools compute and check the separate components; the external AI model explains the result 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 sales insights for the account and revenue questions that support this review.