How to Find Customers Who Have Stopped Buying in Sage 50
One of the easiest ways to increase sales isn’t always finding new customers.
It’s reconnecting with the customers you already have.
For many SMEs, thousands of pounds in potential revenue are sitting within their existing customer database. The challenge is identifying which customers have quietly reduced their spending—or stopped buying altogether.
If you’re using Sage 50, the information is already there.
The difficulty is finding it quickly.
The Questions Every Sales Manager Wants Answered
Businesses regularly ask questions like:
- Which customers haven’t ordered in the last 30, 60 or 90 days?
- Which customers bought this time last year but not this year?
- Which customers have reduced their spending?
- Which accounts have stopped buying certain product lines?
- Which customers have switched to ordering less frequently?
- Which customers should our sales team contact first?
- Which customers are at risk of being lost?
These are incredibly valuable questions because they often lead directly to additional sales opportunities.
Unfortunately, they’re also some of the hardest reports to produce using standard Sage 50 reporting.
Why Most Businesses Never See the Problem
The information usually exists.
It’s just hidden.
Most SMEs rely on standard sales reports that show:
- Sales this month
- Top customers
- Customer balances
- Outstanding debtors
Useful reports—but they don’t highlight who has quietly disappeared.
One Sales Director from a distribution company told us:
“We always celebrated our biggest customers, but we never noticed the ones we’d slowly lost.”
By the time someone realised, many had already moved to competitors.
The Excel Problem
To identify lost customers, many businesses export sales history from Sage 50 into Excel.
Then they:
- Compare different date ranges.
- Build pivot tables.
- Use lookup formulas.
- Create comparison reports.
- Filter customers manually.
- Produce lists for the sales team.
Every reporting period, the same process starts again.
One customer admitted:
“It took longer to identify who to call than it did to actually call them.”
A Real Customer Story
A wholesale business approached Illuminis Insight Software because their sales team felt they were constantly chasing new business while overlooking existing customers.
The Managing Director suspected they were losing customers gradually, but there was no easy way to prove it.
Our consultants reviewed their existing Sage 50 reports and Excel workbooks to understand how the business measured customer activity.
We recreated the reporting process inside Octelas and built automated reports that highlighted:
- Customers who hadn’t ordered for 30, 60 or 90 days.
- Customers spending less than the previous year.
- Customers who had stopped buying specific product groups.
- High-value customers showing declining purchasing patterns.
- Customers whose average order values were falling.
Instead of waiting until the end of the quarter, the sales team received fresh information every morning.
The Sales Director later told us:
“Within the first few weeks we recovered several customers we didn’t even realise we’d lost. The system paid for itself much faster than we expected.”
Small Changes Can Deliver Huge ROI
Another manufacturing customer discovered that several long-standing customers had gradually reduced their orders over twelve months.
The decline had been so gradual that nobody noticed.
Using Octelas, those trends became immediately visible.
The sales team contacted the customers, uncovered changes in buying habits and secured additional business before the relationships were lost completely.
The Managing Director later commented:
“We’d been spending thousands trying to win new customers while existing ones were quietly slipping away.”
That insight alone generated one of the quickest returns on investment the company had seen from any software project.
Your Reporting Should Work For Your Sales Team
Every business defines an inactive customer differently.
Some use 30 days.
Others use 90 days.
Some compare against last year.
Others compare rolling twelve-month periods.
Some analyse by customer.
Others by product group or region.
That’s why Illuminis Insight Software doesn’t provide fixed reports.
We work with you to understand how your business measures customer activity.
We review your existing spreadsheets, sales reports and management information before recreating the reporting logic inside Octelas.
The reports are built around your business—not ours.
More Than Business Intelligence
Many businesses investigating customer reporting also consider Microsoft Power BI.
Power BI can display customer trends beautifully.
But somebody still needs to build the reports.
Maintain the calculations.
Understand your business rules.
Support users.
Make future changes.
Without an ongoing reporting partner, those responsibilities usually fall back on your own team.
We Become Your Data Partner
Illuminis Insight Software takes a different approach.
We don’t simply install reporting software and leave.
We become your long-term reporting and data partner.
As your business changes, your reporting changes with it.
Need to identify customers who have stopped buying a particular product?
We’ll build it.
Need alerts when key accounts reduce their spending?
We’ll configure them.
Need to combine Sage 50 data with information from your CRM or eCommerce platform?
We’ll integrate it.
Need another customer analysis report before your next sales meeting?
We’ll create it.
Your reporting evolves continuously because we’re there to support it.
Stop Looking Back. Start Acting Sooner.
The best time to contact a customer isn’t six months after they’ve stopped buying.
It’s when the first warning signs appear.
Octelas by Illuminis Insight Software automatically analyses your Sage 50 data, identifies customers whose buying habits are changing and presents the information through live reports and dashboards that help your sales team take action sooner.
No more manual Excel comparisons.
No more hunting through sales history.
Just meaningful insights that help you retain customers, increase revenue and make better commercial decisions.
That’s why businesses across manufacturing, wholesale, distribution, construction and many other sectors choose Illuminis Insight Software—not simply for reporting software, but for a trusted long-term partner who helps turn business data into measurable growth.