How many customers did I lose this month?
Losing customers is invisible until it isn't. Revenue can stay flat even as your base erodes. Here's how to count the customers who left and start seeing the leak before it drains you.
The short answer
A lost customer is someone who was active last month (or last quarter) but had no transactions this month. Counting them requires comparing your customer lists across two periods. Your accounting software has the data, but you need to do the comparison yourself.
Why lost customers are the silent killer of small businesses
You closed 10 new customers this quarter. Revenue is up. Everything feels like it's working. But during the same quarter, 14 existing customers quietly stopped buying. You just don't know it yet because their absence doesn't show up on any report you look at regularly.
Acquiring a new customer costs 5-7 times more than retaining an existing one. Every customer who leaves represents not just lost revenue, but lost acquisition cost that you already spent. And unlike a bad month of sales, customer losses compound. If you lose 5% of your base every month and only add 3%, you're shrinking even while your pipeline stays active.
The businesses that catch churn early can often prevent it. A phone call to a slipping customer, a pricing adjustment, or a service recovery costs a fraction of what it takes to replace them.
What “lost customer” means in practice
Defining “lost” depends on your business cycle. For a monthly subscription, a customer who cancels is clearly lost. For a service business with irregular buying patterns, you need to define a window. The standard approach:
If your customers typically buy monthly, compare month to month. If they buy quarterly, compare quarter to quarter. The key is consistency: use the same window every time so your trend is meaningful.
How to find lost customers in QuickBooks Online
QuickBooks doesn't have a churn report. Here's the workaround:
- 1Go to Reports → Sales by Customer Summary
Set the date range to last month. Export to CSV. This is your “previously active” list.
- 2Run the same report for this month
Change the date range to the current month. Export to CSV. This is your “currently active” list.
- 3Compare the two spreadsheets
Use VLOOKUP or conditional formatting to find customers who appear in last month's list but not in this month's. Those are your lost customers.
- 4Check each one for context
For each lost customer, go to their profile in QuickBooks and review their transaction history. Were they a one-time buyer? A regular who suddenly stopped? The context matters.
Total time: 20-30 minutes. Two exports, a spreadsheet comparison, and manual review of each lost customer. Doable, but tedious.
How to find lost customers in Xero
- 1Go to Business → Invoices
Filter by last month's date range. Export the list. Pull unique customer names into a spreadsheet column.
- 2Repeat for this month
Filter to the current month, export, and pull unique customer names into a second column.
- 3Find the gaps
Customers in column A (last month) but not in column B (this month) are your losses. Check each one in Contacts to see their full history.
Total time: 15-25 minutes. Similar to QuickBooks, but Xero's lack of a Sales by Customer Summary report means you start from the invoice list instead.
What it takes to track customer losses every month
- 20-30 minutes of spreadsheet work. Exporting, comparing, and reviewing. Not difficult, but easy to postpone.
- You only know they left, not why.Your accounting data tells you someone stopped buying. It doesn't tell you if they switched to a competitor, went out of business, or just paused temporarily.
- You find out after the fact. By the time you run this analysis, the customer has already been gone for weeks. Early warning would have been more valuable than a post-mortem.
Or see lost customers automatically, every month
Bottomline compares your active customer lists across months and shows you exactly who dropped off, along with their full transaction history, so you can see the pattern before it becomes a trend.
You see not just a number, but names, revenue impact, and how long each customer had been with you. That context tells you whether you're losing long-term relationships or just shedding one-time buyers.