How much is a customer worth over their full relationship?

Bottomline calculates customer lifetime value from your transaction history so you know what each customer relationship is actually worth.

Are newer cohorts more or less valuable than older ones?

Bottomline groups customers by their start date and compares revenue per cohort so you can see whether newer customers are as valuable.

What's my LTV:CAC ratio?

Bottomline calculates lifetime value and acquisition cost to show whether your customer economics are sustainable.

What's my monthly churn rate?

Bottomline calculates your churn rate automatically by comparing active customers at the start and end of each month.

What's my average customer lifespan?

Bottomline calculates average customer lifespan from your transaction history, showing how long the typical customer relationship lasts.

What's the LTV trend over time?

The absolute LTV number is useful. But the direction it is moving tells you whether your business is getting better or worse at creating valuable customer relationships. Here's how to track the trend.

6 min read

The short answer

Calculate LTV quarterly and plot the results. LTV = Average revenue per customer per month x Average customer lifespan x Gross margin. If each component is recalculated every quarter and the resulting LTV is plotted over time, you can see whether the trend is up (customers are becoming more valuable), flat (stable), or down (your customer economics are deteriorating).

Why LTV direction matters more than the number itself

An LTV of $15,000 is neither good nor bad in isolation. It depends on your acquisition cost, your margin structure, and your industry. But an LTV that was $18,000 six months ago and is now $15,000 tells you something important: your customer relationships are becoming less profitable.

LTV declines for three reasons: customers are spending less per month (lower ARPC), customers are leaving sooner (higher churn, lower lifespan), or your margins are shrinking. The trend tells you something is wrong. The components tell you what.

Conversely, a rising LTV trend means your investments in retention, product quality, or pricing are paying off. Customers are staying longer, spending more, or both. That is the compounding effect that separates businesses that scale from businesses that plateau.

How to decompose an LTV trend into its components

When LTV changes, one or more of its inputs changed. Here is what each component tells you:

ARPC declining: Customers are spending less per month. Check pricing, order size, and upsell effectiveness.

Lifespan declining: Customers are leaving sooner. Check churn rate, satisfaction, and competitive pressure.

Gross margin declining: You are keeping less per dollar. Check COGS, supplier costs, and pricing power.

Tracking LTV alone tells you “things are getting better or worse.” Tracking ARPC, lifespan, and margin alongside LTV tells you why.

How to track LTV trends using QuickBooks Online

1
Calculate LTV at the end of each quarter
Follow the LTV calculation steps (Sales by Customer Summary for ARPC, churn rate for lifespan, P&L for gross margin). Record the resulting LTV in a tracking spreadsheet.
2
Record each component alongside the total
In your spreadsheet, track ARPC, lifespan, gross margin, and LTV separately for each quarter. This lets you see which input drove any change.
3
Compare quarter over quarter
After 3-4 quarters, you have enough data to see a trend. Is LTV climbing, flat, or declining? Which component is driving the change?
4
Look for leading indicators
Churn rate usually moves first, then ARPC follows. If churn spiked last quarter but ARPC has not changed yet, the LTV decline is just starting. Margin changes usually reflect cost-side pressure that is independent of customer behavior.

Total time: 30-40 minutes per quarter, on top of the monthly metrics you should already be tracking. The LTV trend is a quarterly exercise built on monthly inputs.

How to track LTV trends using Xero

1
Calculate LTV quarterly from your invoice and P&L data
Same process as QuickBooks: ARPC from invoice exports, churn rate from customer list comparisons, gross margin from the P&L. Record quarterly.
2
Track and compare each quarter in a spreadsheet
Record LTV and its three components. Compare across quarters. Plot if possible. The trend line tells the story.

Total time: 30-40 minutes per quarter. Same effort as QuickBooks with the Xero invoice export as the data source.

What consistent LTV trend tracking requires

Discipline to calculate quarterly, without skipping. A trend requires at least 4 data points. That means a full year of quarterly calculations before you have a reliable trend line.
Consistent methodology each quarter.If you change how you define “active customer” or “churn” between quarters, the trend is meaningless. The method must stay the same.
The trend is only useful with the decomposition. Knowing LTV went from $18K to $15K is an alarm bell. Knowing it happened because churn rate went from 3.5% to 5.2% while ARPC stayed flat tells you exactly what to fix.

Or track LTV trends automatically with full decomposition

Bottomline calculates LTV and its three components every month, plots the trend, and highlights which input is driving any changes. No quarterly spreadsheet ritual required.

LTV trend (last 4 quarters)

Q2 2025ARPC $1,25026 mo61% margin$19,800

Q3 2025ARPC $1,20025 mo62% margin$18,600

Q4 2025ARPC $1,18023 mo60% margin$16,400

Q1 2026ARPC $1,15022 mo60% margin$15,100

LTV declined 24% over 4 quarters. Primary driver: declining customer lifespan (26 to 22 months). ARPC and margin relatively stable.

From a real Bottomline report. LTV is shown with all three components so you can see what is driving the change.

The decomposition at the bottom is the most valuable part. Knowing LTV dropped 24% is a problem statement. Knowing that customer lifespan is the primary driver tells you the solution is in retention, not pricing or cost management. That specificity turns a vague concern into a clear priority.