The Customer Lifetime Value report ranks customers by invoice revenue and buying history metrics.
What this report is for
Use Customer Lifetime Value to compare customers by revenue, invoice count, average order value, purchase frequency, lifespan, and last invoice date.
This is a sales history report. It is not a margin report, not a receivables aging report, and not a payment collection report.
Screen path
Dashboard > Sales > Reports > Customer Lifetime Value
Filters and actions
| Control | What it does |
|---|---|
Customer Type (Sort Code) |
Filters customers by sort code. |
Top N Customers |
Limits results to the top number of customers by total revenue. Maximum shown in the UI is 500. |
Time Period (Years) |
Filters invoice history to all time, past 1 year, past 2 years, past 3 years, or past 5 years. |
Apply Filters |
Runs the report with selected filters. |
Copy for Excel |
Copies tab-delimited customer metrics to the clipboard. |
Refresh |
Reloads the report. |
| Information button | Opens a short explanation of selected metrics. |
Metrics and columns
Overall averages shown above the table:
| Metric | Meaning |
|---|---|
Avg Customer Order Value |
Average of each customer's average order value. |
Overall Avg Invoice |
Total revenue divided by total invoice count. |
Avg Purchases/Year |
Average purchase frequency across included customers. |
Avg Lifespan (years) |
Average years between each customer's first and last invoice. |
Customer table columns:
| Column | What it shows |
|---|---|
Customer Code |
Customer code. |
Customer Name |
Customer name. |
Total Revenue |
Sum of invoice total amounts for the included invoice set. |
Invoices |
Count of invoices included for the customer. |
Avg Order Value |
Average invoice total for the customer. |
Purchases/Yr |
Invoice count divided by customer lifespan, with a minimum lifespan divisor of one year. |
Lifespan (yrs) |
Years between first and last invoice in the included data. |
Last Invoice |
Most recent invoice date in the included data. |
What happens behind the scenes
PAX reads customers, sort codes, and invoices with positive invoice totals. Results are ordered by total revenue descending.
The report can filter invoice history by customer sort code and by a years-back period. When Top N Customers is entered, PAX limits the returned customer list.
This report uses invoice totals. It does not calculate gross profit, cash collected, open receivables, return-adjusted balance, or customer credit.
Running, refreshing, or copying the report does not update customers, invoices, payments, or accounting.
Troubleshooting
A customer is missing
Likely cause: The customer has no positive invoice totals in the selected period, or the sort-code filter excludes the customer.
Safe fix: Clear filters or change the time period to All Time.
Contact support if: The customer has qualifying invoices but still does not appear.
Revenue differs from Sales Analysis
Likely cause: Customer Lifetime Value uses invoice total amounts, while Sales Analysis uses shipment-linked sales and cost data.
Safe fix: Use Sales Analysis for shipped margin and Customer Lifetime Value for customer invoice history.
Contact support if: A specific invoice total appears wrong in customer history.
Average order value seems different from overall average invoice
Likely cause: Avg Customer Order Value gives each customer equal weight. Overall Avg Invoice is weighted by total invoice volume.
Safe fix: Use the information button in the report for the metric explanation.
Contact support if: The math appears inconsistent for the same filter set.