Score yourself first
One point for every “yes”. Keep the number: we'll come back to it at the end.
- Customer information lives in more than one spreadsheet.
- Reps keep their own notes or lists.
- You can't see the pipeline without asking someone.
- A follow-up has slipped in the last month that you know of.
- Two reps would define “Qualified” differently.
- Finding a customer's full history means asking around.
- Someone builds the weekly report by hand.
- A customer has been called by two of your people about the same thing.
- You've hired, opened a location or added a channel this year.
- Your best rep's pipeline would be hard to pick up if they left tomorrow.
Tidy what gets recorded and look again in six months.
This week has probably already happened to you.
And it's costing you deals you can't see.
Most growing sales teams score 5 or higher. Here's what a 7 looks like from the inside.
The row that said everything was fine
Diana Rashid runs sales at Langit Biru Solutions. Twenty-five people, three years of steady growth, one shared spreadsheet called Sales_Leads_FINAL.xlsx.
Row 2 is the biggest deal of her quarter. Awan Mendung Sdn Bhd. RM180,000. Status: Proposal. It looks fine. That's the problem.
IllustrativeThe only record of the deadline is on Farid's desk.
What the row doesn't say
The customer asked for a revised proposal three weeks ago. The revision was due last Friday. Farid, the rep, wrote the deadline on a Post-it and then spent the week on a tender. Nobody else knew there was a deadline.
The spreadsheet isn't wrong. It's just the last thing someone typed.
The status is accurate as of whenever someone last remembered it.
“What's the next step?” gets answered from memory.
Deadlines live somewhere other than the customer record.
A spreadsheet records what happened. It has no way of telling you what didn't.
Where the lead actually lives
Diana starts piecing Awan Mendung back together. It takes her most of the morning.
First enquiry. Marketing logged it in their own sheet.
Copied over as “Awan Mendong”. Different spelling, new row.
Discovery call notes. Paper.
Pricing talk, on Farid's phone.
First proposal, sent from his inbox.
The revised requirements. 2 min 40 sec.
IllustrativeSix places, one customer: Awan Mendung Sdn Bhd, RM180,000.
Nothing is missing, exactly. It just isn't anywhere the business can see it.
Your team isn't losing information. It's storing it in six places and trusting that one person remembers where.
The pipeline meeting
Tuesday is pipeline review. Diana asks each rep to walk through their deals.
Farid says Awan Mendung is “Qualified, looking strong.” Another rep marks a deal “Qualified” after the first friendly call. A third waits for a confirmed budget. Same word, three meanings. Add them up and you get a forecast built on optimism.
Nobody is lying. The spreadsheet just lets every rep run their own definition. So the meeting becomes a status update read aloud.
Almost none on what happens next.
“They seemed keen on the call.”
“They replied to my email.”
“Budget confirmed in writing.”
Six stages that mean the same thing to everyone
| Stage | Means | Moves on when |
|---|---|---|
| 1 · New lead | We know they exist | A rep has made contact |
| 2 · Contacted | We've spoken | Need and decision-maker confirmed |
| 3 · Qualified | Real need, real budget | Proposal requested |
| 4 · Proposed | Proposal is with them | They respond with terms |
| 5 · Negotiation | Terms on the table | Signed, or lost |
| 6 · Won or lost | Closed | Reason recorded, either way |
The “moves on when” column is the one that matters. Write it down, and it stops depending on who's filling in the sheet.
What a missed follow-up costs
A missed follow-up never makes noise. The customer just goes quiet, and three weeks later someone marks the deal “Lost: no response.”
Do the maths once. It changes how the Tuesday meeting feels.
| Example | Yours | |
|---|---|---|
| New leads a month | 40 | |
| × Share that never get a timely follow-up | 10% | |
| × Your normal win rate | 25% | |
| × Average deal size | RM60,000 | |
| = Revenue leaking each month | RM60,000 |
From deals nobody decided to lose. No one argued for dropping them. They just ran out of reminders.
IllustrativeExample figures only. Use your own.
That's the quiet cost. The louder one is Awan Mendung, which is one missed Friday away from joining it.
The call sales didn't know about
Amirul Hakim, Operations Director at Awan Mendung, calls Langit Biru. Not about the proposal. About a login issue on the system they bought last year, open for eleven days.
The service team knows about the ticket. Sales doesn't. So when Farid finally calls Amirul that afternoon to apologise for the late proposal, he walks straight into it. From Amirul's side, this is one company. It just doesn't look that way from the inside.
IllustrativeSales, service and history on one record. Farid would have seen the case before he dialled.
Customers experience one company. A spreadsheet shows them as three rows in three files.
The same week, replayed
Run Diana's week again, this time with one shared customer record.
| With the spreadsheet | With one shared record | |
|---|---|---|
| Mon | Diana finds the overdue revision by chance, three days late. | The deadline was logged on the deal. It turned amber on Thursday and red on Friday. Diana asks before it passes. |
| Tue | 90 minutes of reps reading out statuses. | Opens on the live dashboard. Goes straight to the five deals with overdue actions. 40 minutes. |
| Wed | Farid is blindsided by an 11-day-old service case. | Farid sees the case on the account and opens with it. The call goes from awkward to useful. |
The missed deadline is caught before it's missed.
The pipeline meeting, spent on next steps.
Farid knows about the open case before he dials.
Nothing in that week needed new people or harder work. It needed the information in one place, and something that notices when a date goes past.
The dashboard is the visible part. What actually changes is that everyone works from the same version of the customer.
What Diana sees on Tuesday morning
IllustrativePipeline, overdue actions and owners, in one view.
Every number on the screen should point to an action
Open the list and call them today.
Check each one has a next step with a date.
See where deals stall, and ask why.
If a number doesn't tell someone what to do next, take it off the screen.
Automation keeps Farid on the phone
Farid's week has about eight hours of admin in it. Copying leads between sheets. Setting reminders. Writing up calls. Building the Friday report.
A full selling day, spent typing.
Automation takes the admin away. It doesn't take away the conversations.
| The system handles | Farid keeps |
|---|---|
| Assigning new web leads to the right rep | The first call |
| Reminding him before a deadline, not after | Deciding what the revision needs |
| Logging emails against the account | Reading Amirul's mood on the phone |
| Building the pipeline report | Explaining why a deal slipped |
IllustrativeOne reminder, on Thursday, with the open service case attached. That's the whole difference between this story and a lost deal.
The point isn't fewer conversations. It's the right conversation at the right time, with the history already on screen.
Moving without bringing the mess
Diana is convinced. Her first instinct is to import Sales_Leads_FINAL.xlsx into a CRM and be done by lunch.
That's how you get the same mess with a nicer interface. Three years of spreadsheets means duplicate companies, contacts who left in 2024, and five versions of “Qualified”.
Answer these before you move anything
- 1Which list is the one we trust?
- 2Which companies appear more than once, under different spellings?
- 3Which contacts haven't responded in over a year?
- 4What does every record need, as a minimum?
- 5Which six stages are we using, and what moves a deal between them?
- 6What gets archived instead of migrated?
Reps adopt a CRM when it helps them: fewer reminders to keep, less history to chase. They drop it when it feels like reporting for management.
The first week the manager asks for “a quick spreadsheet summary”, the team learns the CRM is optional. Run the Tuesday meeting from the CRM, and it becomes how the business works.
How it ended
Farid sent the revised proposal on Wednesday night, with an apology and a fix date for the login issue. Awan Mendung signed three weeks later.
Diana kept the deal. What stayed with her was the feeling of finding it by luck. She'd opened the spreadsheet on a Monday for another reason and happened to ask.
The spreadsheet wasn't the wrong place to start. It got Langit Biru to 25 people. It was just never built to tell Diana what hadn't happened.
From six places to one working record
We help growing businesses move from scattered customer information to one working CRM, set up around how your team actually sells.
Where your information lives today, and where it leaks.
Your trusted list moved over. The duplicates left behind.
Stages, fields and views that match how your team really sells.
Built around the actions each role needs to take.
Assignment, reminders and logging, so reps stay on the phone.
We stay past go-live, until the Tuesday meeting runs from it.
How the work runs
Advise
Work out what's actually broken, and what to build first.
Build
Set up, migrate and connect, around how you sell.
Grow
Stay after go-live, until people use it on a Tuesday.
Telcowin is a Salesforce Summit Partner. See our CRM and Salesforce pages for more.
Look at the number you wrote at the start
4 or more? Bring us the spreadsheet your team uses today.
In 45 minutes we'll walk through how one lead comes in, gets assigned and gets followed up, and show you where it leaks. You leave with a one-page map of your pipeline, whether or not you work with us.
Built for People. Backed by Tech. Better Experiences.
Langit Biru Solutions, Awan Mendung Sdn Bhd and every person in this story are fictional. All figures and screens are illustrative.
Keep reading: chapters 2 to 9
Find out whether Diana keeps the deal. Tell us where to reach you and the rest of the guide opens straight away, with the PDF to keep.
By submitting the form you agree to share your information and be contacted by Telcowin.
Your private information is protected as per our Data Processing Policy.