How to Identify Loss-Making Customers
Not every customer is a good customer.
Some generate excellent profits year after year.
Others generate impressive turnover while quietly costing your business money.
The challenge is that most SMEs don’t realise which customers are genuinely profitable.
They focus on revenue instead.
A customer spending £250,000 a year may appear to be one of your best accounts.
But if they’re receiving heavy discounts, placing small frequent orders, demanding exceptional levels of support or generating poor margins, they could actually be reducing your overall profitability.
Understanding the difference can completely change the way you manage your business.
Turnover Can Be Misleading
Whether you use Sage 50, Sage 200, Microsoft Dynamics 365 Business Central, Xero, Exchequer, Pegasus Opera, Dynamics NAV, SAP Business One, Brightpearl or another ERP system, your business holds all the data needed to analyse customer profitability.
The problem is bringing it all together.
Business owners regularly ask questions like:
- Which customers generate the highest profit?
- Which customers have the lowest margins?
- Which customers receive the biggest discounts?
- Which customers cost the most to serve?
- Which customers are becoming less profitable?
- Which sectors generate the best returns?
- Which customers should we be focusing on?
- Which customers are actually losing us money?
These questions are surprisingly difficult to answer using standard ERP reports.
Why Excel Becomes the Default
Many businesses export sales into Excel.
Then they export product costs.
Discounts.
Credit notes.
Customer information.
Sometimes delivery costs.
Sometimes rebate calculations.
Everything is merged together to calculate profitability.
The process can take hours—or even days.
Then it has to be repeated every month.
One Finance Director from a wholesale business told us:
“We knew our biggest customers. We had no idea which ones were actually making us money.”
Looking Beyond Sales Figures
Customer profitability is influenced by much more than turnover.
For example:
- Frequent small orders.
- High discount levels.
- Excessive returns.
- Expensive delivery requirements.
- Long payment terms.
- High support costs.
- Special pricing agreements.
- Low-margin product purchases.
Individually, none of these may seem significant.
Together, they can turn a valuable-looking customer into a loss-making one.
A Real Customer Story
A manufacturing company contacted Illuminis Insight Software because they wanted better customer reporting.
Management believed their largest customers were naturally their most valuable.
After reviewing their spreadsheets, we recreated the reporting process inside Octelas and introduced live customer profitability analysis.
The results surprised everyone.
Several of the company’s highest-turnover customers were delivering below-average margins due to years of historic pricing agreements and increasing supplier costs.
Meanwhile, several smaller customers were generating significantly higher profits with far less effort.
The Managing Director later told us:
“It completely changed the way we looked at our customer base. We stopped measuring success purely by turnover.”
The business reviewed pricing, renegotiated agreements and redirected sales efforts towards more profitable opportunities.
Another Customer’s Experience
A national distributor believed they needed to win more business.
After implementing Octelas, they discovered a different opportunity.
Several long-standing customers were consuming a disproportionate amount of sales and support time while generating very little profit.
By identifying those relationships early, they reviewed pricing, adjusted service levels where appropriate and significantly improved profitability without increasing sales volumes.
The Finance Director later commented:
“The software didn’t just improve our reporting. It improved our commercial decision-making.”
Every Business Calculates Profitability Differently
Some businesses measure gross margin.
Others include freight.
Some allocate overheads.
Others consider rebates, commissions or service costs.
That’s why Illuminis Insight Software never assumes profitability should be calculated the same way for every customer.
We begin by understanding how your business already measures performance.
We review your existing Excel reports, management packs and financial calculations before recreating the reporting logic inside Octelas.
The result is reporting that reflects the way your business actually operates.
Dashboards Don’t Solve Business Problems
Many businesses looking to improve profitability reporting investigate Microsoft Power BI.
Power BI is a powerful reporting platform.
But someone still needs to understand your pricing structures.
Your margins.
Your discounts.
Your reporting requirements.
Then build and maintain everything over time.
For many SMEs, that quickly becomes another ongoing project.
More Than a Software Provider
This is where Illuminis Insight Software is different.
We don’t simply implement software.
We become your long-term reporting and data partner.
We understand your business.
We recreate the reports you’ve spent years developing.
We automate the repetitive work.
And we continue supporting your reporting as your business grows.
Need customer profitability by salesperson?
We’ll build it.
Need profitability by product group?
We’ll configure it.
Need alerts when margins fall below target?
We’ll create them.
Need to combine ERP data with CRM, warehouse or service information?
We’ll integrate everything into one reporting platform.
Our customers know they’re never left to manage reporting on their own.
Build a More Profitable Customer Base
Growing sales is important.
Growing profitable sales is even more important.
The businesses that consistently improve performance understand which customers genuinely contribute to long-term success.
Octelas, developed by Illuminis Insight Software, automatically analyses data from Sage, Microsoft Dynamics, Xero, Exchequer, Pegasus Opera, SAP Business One, Brightpearl and many other ERP systems, helping businesses identify profitable customers, low-margin accounts and hidden opportunities to improve performance.
Instead of spending days analysing spreadsheets, your management team receives live insights that support better pricing decisions, stronger customer relationships and improved profitability.
That’s why businesses across manufacturing, wholesale, distribution, construction, engineering, hospitality and professional services choose Illuminis Insight Software as their trusted reporting and data partner—because understanding your customers isn’t just about knowing what they buy, it’s about knowing which relationships help your business grow.