Minute Read 3

How To Calculate Customer Lifetime Value In Xero (Easy Guide)

 

If you own a business, there is one number you really need to know.

It is called your Customer Lifetime Value.

Sounds fancy… but it is actually very simple.

And once you know this number, you can make smarter marketing decisions, grow faster, and stop guessing.

In this guide, I will show you exactly how to calculate Customer Lifetime Value in Xero step-by-step.

No complicated maths.
No confusing business words.
Just simple and practical.

What Is Customer Lifetime Value?

Customer Lifetime Value (also called LTV or CLV) is how much money one customer brings into your business over time.

For example:

If one customer spends R10,000 with you over 3 years…

Then your Customer Lifetime Value is R10,000.

This number is important because it helps you answer questions like:

• How much can I spend on ads?
• How much is a lead worth?
• Am I making money from marketing?
• How can I grow my business faster?

Most business owners track profit…

But very few track LTV.

That is a big mistake.

Why Customer Lifetime Value Matters

Let’s say you know your average customer is worth R20,000 over their lifetime.

That means you can spend more money to get a new customer.

Because you already know what they are worth in the long run.

This helps you:

✅ Run smarter ads
✅ Make better decisions
✅ Grow with confidence
✅ Stop guessing

The businesses that understand their numbers usually grow faster.

How To Calculate Customer Lifetime Value In Xero

Good news.

Xero already has the data you need.

Here is the simple process.

Step 1: Log Into Xero

First, log into your Xero account.

Once inside, go to:

Reporting → All Reports

Step 2: Search “Top Customers”

In the search bar, type:

Top Customers

Then click:

Top Customers – Receivable Invoice Detail

This report shows your customers and how much they spent.

Step 3: Remove The Graph

To keep things simple:

• Click on “Chart”
• Change it to “None”
• Click “Update”

Now the report is much easier to read.

Step 4: Choose The Right Columns

Make sure these columns are selected:

• Contact
• Gross

This helps you see your top customers clearly.

Step 5: Set Your Date Range

This is VERY important.

You want to go back at least 3 years.

Why?

Because Customer Lifetime Value works best with more data.

If your business is older, even better.

Go back 5 years if you can.

Step 6: Click Update

Xero will now show:

• Your customers
• Your total revenue
• Your top spenders

Now scroll to the bottom.

Step 7: Find Your Unique Customers

At the bottom, you will see how many unique customers you had.

Example:

157 customers.

Perfect.

Now you have the two numbers you need:

1. Total Revenue
2. Total Customers

Step 8: Calculate Your Customer Lifetime Value

Now divide:

Total Revenue ÷ Total Customers

That gives you your Customer Lifetime Value.

Simple.

Example

Let’s say:

• Total Revenue = R1,570,000
• Total Customers = 157

Then:

R1,570,000 ÷ 157 = R10,000

That means each customer is worth about R10,000 to your business.

Now you can use that number for smarter marketing.

How To Use Your Customer Lifetime Value

This is where things get exciting.

Once you know your LTV, you can work backwards.

For example:

If a customer is worth R10,000…

And your profit margin is good…

You may be happy spending R1,000 or even R2,000 to get a new customer.

Most businesses never think this way.

They just guess.

But data helps you grow faster.

Save The Report

One last tip.

Save this report in Xero.

Then check it every month.

Ask yourself:

• Is my LTV going up?
• Is it going down?
• Are customers spending more over time?

This gives you a simple growth score for your business.

Final Thoughts

Customer Lifetime Value is one of the most important numbers in business.

And the best part?

You can calculate it inside Xero in just a few minutes.

No expensive software.
No complicated setup.
Just simple business data.

If you want to grow your business smarter, start tracking your LTV today.

And if you want help understanding your numbers, marketing, or lead generation…

Book a free 30 minute strategy session here

Until next time 🙂