Natural Options Saved 5 Hours/Week with Automated Sales Dashboard
Your weekly sales meeting is based on last week’s numbers.
By the time your operations lead finishes pulling data from three Excel tabs, reconciling shortfalls by hand, and formatting a report, the business has already moved on. You are making decisions based on outdated numbers.
The system was built for manual work. It was never going to keep up.
Here’s what sales reporting looks like in most Malaysian SMEs:
- You manually key sales data into spreadsheets — and by the time anyone reads it, it’s already out of date
- You calculate weekly shortfalls by hand, across multiple tabs
- You chase people via text messages and reminders, hoping someone follows up
- Your sales data and marketing activity live in separate files — no one has the full picture
Natural Options, a Malaysian health product distributor selling Surya Cider through Watsons, Guardian, Big Pharmacy, and other pharmacy chains, was living this every week.
Look, the Finance and Operations Manager spent 4–5 hours every week pulling Excel tabs together just to show the team what happened. The weekly huddle was happening. The data was wrong.
Look describes it: “Preparing the sales report — weekly, monthly, by-product, by-channel — takes a lot of manual work. We don’t have any automation at Natural Options.”
The Operational Problem: Manual Sales Reporting
Most companies treat this as a people problem. The team isn’t fast enough. The process needs to be tighter. More follow-ups.
Here’s what’s actually broken.
When 80% of your reporting time goes to data entry, only 20% is left for strategy and action. More effort doesn’t fix that. Fixing the system does.
Four operational problems were driving Natural Options’ reporting issue:
- Your data is always outdated. Sales figures were manually entered and already stale by the time anyone reviewed them. Nothing refreshed automatically.
- You’re doing the same math every week. Calculating weekly shortfalls required manual reconciliation every single time. One formula error broke the entire report.
- You need to remind and chase people. There were no triggers or automated follow-ups — just text reminders and a “Pending” list. The team was always reacting.
- Your sales and marketing data don’t talk to each other. Sales lived in Excel. Marketing activity lived in Word. Nobody had a single view of both.
Look: “The whole process becomes a lot more frustrating when you open up more channels. When you want to compare channel to channel, or look at the details of each individual channel, you have to do multiple reports. Multiply that by the number of months, weeks, and days — it becomes very burdening.”
The result: a sales team making weekly decisions on incomplete data.
What the Digital Agent Team Built for Natural Options
Kabel deployed a Digital Agent team to Natural Options with one clear goal: automate sales reporting and build a live dashboard the team could actually use in their weekly huddle.
The team consisted of early-career talent matched to this specific problem. They had no prior experience with health product distribution.
That turned out to be an advantage.
Look: “When I first knew that the digital agents were students who just graduated, we were a bit doubtful. But we went with the ‘why not’ mentality — give them a chance. They only took one month to complete it. Previously, other companies told us they needed half a year just to understand the whole process.”
They came in without assumptions. They mapped the existing workflow, found where data was being typed twice, and built the system from scratch.
The solution was called Cider Analytics — a sales BI dashboard with four layers:
1. One Place for All Your Sales Data
Every retail channel — Watsons, Guardian, Big Pharmacy, Health Lane, Alpro, and others — connected into one live view. No more pulling from separate files.
The dashboard showed gross sales YTD, average selling price, total units sold, and return rate — updated automatically. Seasonality trends were visible at a glance. What used to require a manual year-over-year comparison was now a chart.
2. Targets That Adjust Automatically
Previously, if your team missed Week 1’s target, the shortfall just sat there. Nobody automatically knew what Week 2 needed to recover.
Cider Analytics introduced a carry-forward rule: miss a target in Week 1, and the system adds that gap to Week 2’s target automatically. Your team always chases a live, adjusted number — not a fixed budget that ignores what actually happened.
Example: A brand underperforms by RM487.50 in Week 1. The system sets Week 2’s adjusted target to RM828.75 — original target plus the shortfall. Achievement percentage updates in real time.
No more manual reconciliation. No more chasing numbers in a spreadsheet.
3. See Exactly Which Products Are Making You Money
Before, the team could see total sales by retailer — but not which products were driving that revenue versus which were just filling shelf space with thin margins.
Cider Analytics solved this two ways:
- 80/20 Analysis. Automatic sorting showed which SKUs generated the top 80% of net revenue. It instantly surfaced that Watsons drove 56.35% of total revenue — a number the team had never seen before.
- Product-level breakdown. Each product variant had its own row: net sales, average selling price, gross profit, return quantity, and share of total revenue. You could see at a glance which products to push and which were underperforming.
For a sales team making range decisions, this was the visibility they’d never had before.
4. Problems Get Flagged — You Don’t Have to Find Them
The dashboard automatically flagged when key metrics fell outside acceptable ranges — selling price drops, high return rates, forecast gaps.
Your operations lead no longer had to scan through rows to find problems. The system surfaced them.
What Natural Options Has Now: A Sales Intelligence Dashboard
Before DXP:
- Reporting: 4–5 hours per week pulling Excel tabs together
- Sales Tracking: Text lists of “Pending meetings”
- Inventory: Guesswork based on sales volume
- Visibility: Hindsight — what happened last month?
After DXP:
- Reporting: Real-time, zero consolidation time
- Sales Tracking: Visual pipeline with live Achievement %
- Inventory: Return quantity and sold quantity in one view
- Visibility: Foresight — what do you need to hit next week?
The results were measurable:
- 5 hours saved per week — the operations lead stopped building reports and started using them.
- Decision lag dropped from 7 days to 0 — real-time dashboards replaced weekly PDF reports.
- The team started focusing on selling again. Their attention shifted from building spreadsheets to hitting targets.
Look: “I only need to spend 10 seconds a day to match the raw data total against the dashboard total. As long as the numbers are the same, the data is displaying correctly. Previously, I’d spend 5 hours just to prepare a weekly report, and a full day for monthly report.”
Sales Reporting Problem Across Malaysian SMEs
Natural Options isn’t unusual. The same operational problem — reporting consuming your team’s best hours — shows up across retail, distribution, professional services, and F&B.
A Digital Agent team at a consulting firm consolidated scattered reporting into dashboards and cut turnaround by 3–5x.
An online gift delivery company went from no data to a centralised operations dashboard, giving management real-time visibility into branch performance, driver productivity, and delivery delays, in 10 weeks.
Same pattern every time: your business logic is locked inside an Excel file, with manual work. A scoped sprint breaks the cycle.
How to Start: A Simple Roadmap
If your team is spending hours every week just getting the numbers ready, here’s where to start with DXP:
Week 1: Map it. Audit your manual spreadsheets. Find where data is entered more than once. Define what you actually need from the new system.
Week 2: Clean the data. Standardise your SKU names, retailer labels, and date formats. Most BI projects fail here before the dashboard is even built.
Week 4: Build the dashboard. Connect your data sources. Set up the logic — carry-forward rules, 80/20 sorts, return rate tracking. Test with real numbers.
Week 10: Run your first live huddle. Use the dashboard in the meeting. Leave the spreadsheets behind.
Get the business logic right. Automate it. The dashboard runs from there, without you.
Transform Your Sales Reporting
If your weekly reporting is still costing your team hours, it won’t fix itself. Automate how your business tracks sales, and the reporting runs itself.
Natural Options already had the data. They just had spend 5 hours of manual work weekly before the sales team could see it.
A Digital Agent team scoped the problem, built the system, documented the handover, and gave the operations lead 5 hours back every week.
A scoped team. A clear outcome in 10 weeks. Five hours recovered, every week.
Check out Digital Acceleration Program (DXP) to see how a Digital Agent team can automate your sales reporting and build the dashboards for your business to scale.
Frequently Asked Questions
1. What is DXP?
The Digital Acceleration Program (DXP) puts a team of Digital Agents — early-career talent matched on skills and learning speed — on one specific operational problem within a fixed timeframe.
Every sprint ends with documented systems, dashboards, or workflows your team can run independently. The focus is delivery, not training hours.
2. How does automating sales reporting help my business?
Manual sales reporting wastes time and introduces errors. When you automate it:
- Your team sees real-time data — not last week’s numbers
- Shortfall calculations update automatically — no manual math
- Your sales team focuses on hitting targets instead of building reports
- You can see which products and channels are actually driving revenue
3. Does my business need technical expertise to benefit from DXP?
No. The Digital Agent team handles the build. You define the outcome. They audit your current workflow, build the system, and hand it over with documentation. Your team doesn’t need to know how it was built — just how to use it.
