Are my repeat customers actually coming back?

Bottomline tracks repeat purchase rates and flags customers whose buying frequency is declining.

How many customers did I gain this month?

Bottomline identifies first-time buyers each month and shows you the count alongside your total active customer base.

What's my average customer lifespan?

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

How much is a customer worth over their full relationship?

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

What's my LTV:CAC ratio?

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

Do my customers need me more than once?

Some businesses are built on repeat purchases. Others are one-and-done. The answer changes everything about how you invest in acquisition vs. retention. Here's how to find out which one you are.

6 min read

The short answer

Check your one-time vs. repeat customer ratio. Look at all customers over the last 12 months. What percentage made only one purchase? What percentage came back for two or more? If over 60% of your customers buy only once, your business model depends on a constant stream of new customers. If most customers come back, you have a retention engine that compounds over time.

Why the one-time vs. repeat ratio defines your business model

A roofing company and a coffee shop both serve customers. But the roofing company might see each customer once every 15 years. The coffee shop sees them 4 times a week. Their entire economics are different: the roofer needs to charge enough on one job to justify the acquisition cost. The coffee shop can afford a low margin per visit because the customer comes back hundreds of times.

Most businesses fall somewhere in between, and the exact ratio determines how much you can afford to spend on acquisition, how important retention programs are, and whether your growth model is volume-driven or relationship-driven.

If you think you're a repeat business but 50% of your customers only buy once, you're spending on retention for people who were never going to come back and under-investing in the acquisition that actually drives your growth.

The one-time vs. repeat customer breakdown

The calculation is a simple segmentation of your customer base:

One-time customers: Unique customers with exactly 1 transaction in the last 12 months.

Repeat customers: Unique customers with 2+ transactions in the last 12 months.

Repeat rate: Repeat customers / Total unique customers x 100.

A 40% repeat rate means 4 out of 10 customers come back. A 70% repeat rate means 7 out of 10. The number itself is less important than whether it matches your assumption about your business model and whether it is improving or declining over time.

How to find your repeat rate in QuickBooks Online

1
Go to Reports → Sales by Customer Detail
Set the date range to the last 12 months. Export to CSV.
2
Count transactions per customer
In a spreadsheet, use a COUNTIF or pivot table to count how many transactions each unique customer had.
3
Segment into one-time and repeat
Customers with a count of 1 are one-time buyers. Customers with 2+ are repeat buyers. Count each group.
4
Calculate the ratio and revenue split
Divide repeat buyers by total buyers for the rate. Also sum the revenue from each group. The revenue split is often more revealing: repeat customers might be 40% of the base but 75% of the revenue.

Total time: 15-20 minutes. One export and some pivot table work.

How to find your repeat rate in Xero

1
Export invoices from Business → Invoices
Filter to the last 12 months. Export to CSV.
2
Build a customer transaction count in a spreadsheet
Pivot table with customer name as the row and count of invoices as the value.
3
Segment and calculate
Same split: one-time (count = 1) vs. repeat (count 2+). Calculate the percentage and the revenue share for each group.

Total time: 15-20 minutes. Same spreadsheet approach as QuickBooks.

What tracking repeat rate over time requires

15-20 minutes quarterly (at minimum). This metric does not change fast enough to justify monthly tracking, but quarterly check-ins reveal important shifts.
The overall rate masks segment differences. Customers from different channels, product lines, or price points may have wildly different repeat rates. The aggregate can mislead.
One-time does not always mean “failed.” Some products or services are genuinely one-time purchases. The question is whether the mix matches your expectation and your business model.

Or see your repeat customer ratio automatically

Bottomline calculates your one-time vs. repeat split every month, tracks the ratio over time, and breaks it down by revenue contribution so you see both the customer count and the dollars behind each segment.

Customer purchase behavior (trailing 12 months)

One-time buyers62 customers$84,200 (18%)

Repeat buyers (2-5x)54 customers$168,400 (36%)

Loyal buyers (6x+)32 customers$214,800 (46%)

58% of customers are repeat buyers, generating 82% of revenue. Repeat rate improved from 54% last quarter.

From a real Bottomline report. Customer segments are calculated automatically with revenue attribution.

The revenue split is the key insight. In this example, 42% of customers are one-time buyers but they contribute only 18% of revenue. The 22% who are loyal buyers generate 46% of revenue. That tells you exactly where your business model lives and where to focus your retention investment.