CRM for Small Business in Pakistan: A Two-Week Move Off Excel

The call came on a Thursday. A customer who had asked for a bathroom tiles quotation the week before was on the line, annoyed, because one salesman had quoted him a rate on WhatsApp and another had quoted a different rate when he visited the showroom. The owner checked the Excel sheet. The customer wasn't in it. He checked the notebook at the counter. There was a name that might have been him, with no number. The WhatsApp chat was on the phone of a salesman who was off that day.

If you run a small business in Pakistan, you probably know this owner. The story below is a composite of situations we see again and again when businesses come to us, not one named client. It follows a typical showroom owner in Lahore with five staff, whose leads are spread across an Excel sheet, a counter notebook and three phones, as he moves to a CRM over two weeks: what he set up first, what went wrong, and what changed.

Day zero: three phones, one notebook and "leads final 2.xlsx"

Before changing anything, we asked him to list every place a lead could live. It took ten minutes to write down:

• The Excel sheet. Kept by the accountant and updated when he remembered. There were three versions on the shop computer: "leads", "leads final" and "leads final 2".
• The counter notebook. Walk-ins written by whoever was at the counter. Some with numbers, some with just "Bhatti sahab, 2 bathrooms, will call".
• Three WhatsApp phones. The owner's own number, painted on the shop board. The shop's WhatsApp Business number, used for Facebook ads. And the senior salesman's personal number, which many repeat customers preferred.

Nobody could say how many leads came in last month or from where. Follow-ups happened when someone remembered. The most valuable customer history in the business sat on a phone that belonged to an employee. If three or more of these sound like your shop, your team is not lazy. Your system has run out of room.

A CRM (customer relationship management system) is simply one shared place where every lead, conversation and follow-up date is recorded, so nothing depends on whose phone it happened to be.

Days 1 and 2: agreeing on the stages before opening any software

The owner wanted to see software on day one. We asked for one afternoon with him and the senior salesman first, with a pen and paper. One question: what actually happens between "someone asked" and "money received"?

They settled on six stages:

1. New: messaged, called or walked in, and nobody has replied properly yet.
2. Requirement clear: we know the rooms, the area in square feet, the budget range and the city.
3. Quotation sent: on WhatsApp or printed.
4. Visit or sample: coming to the showroom, or sample tiles sent to the site.
5. Won: advance received by bank transfer, JazzCash, Easypaisa or cash.
6. Lost: with a reason picked from a short list: price, timing, went elsewhere, stopped replying.

Then one rule that mattered more than all six stages: no open lead without a next follow-up date. Plenty of buyers here ask the price, say "I'll let you know", and go quiet while they compare three shops. The shop that follows up politely on day two and again on day five is often the one that gets the order. A notebook can't remind you. A CRM can.

Days 3 to 5: the cleaning job nobody wants to do

Moving data sounds technical. For a small business it is mostly cleaning. This is the order that works:

1. Put everything in one folder. All three Excel files, photos of the notebook pages and exported contact lists.
2. Keep eight columns and drop the rest. Name, phone, area or city, what they asked for, source, stage, last contact date and assigned person.
3. Fix phone numbers into one format. 92 followed by the number without the first zero. Half the sheet had 0300-style numbers, some had +92, a few had spaces in the middle. Until they match, you can't find duplicates.
4. Merge duplicates. Bhatti sahab turned up three times: in the notebook, in the sheet and in the salesman's phone. Keep one record and combine the useful notes.
5. Put every open lead in a stage. If you're not sure, use "Requirement clear" with a follow-up next week.
6. Import a test batch of 50 first. Check the names, numbers and stages on screen before loading the rest.
7. Give every open lead an owner and a date. No orphan leads on day one.
8. Make the old sheets read-only. Otherwise people keep updating Excel "just for now".

What went wrong here was predictable. The salesman's phone had contacts saved as "Tiles DHA" and "Uncle sample". A good number of them needed a phone call before anyone knew who they were. Budget time for that. It is dull work, and it is exactly where your old money is sitting.

Days 6 to 8: getting three phones into one inbox

This was the part the owner worried about most. He did not want to give up the WhatsApp Business App on his phone, and his repeat customers were used to his number.

He didn't have to. With WhatsApp Coexistence on the official WhatsApp Business Platform, the app stays on the phone and the same chats also flow into a shared inbox, where each new conversation creates or updates a contact in the CRM with its source. The shop number went first because it carried the ad traffic. The salesman's personal number was the harder conversation: the owner asked him to point customers to the shop number from then on, and his contacts went into the CRM during the cleaning stage.

Two things surprised the owner, and they surprise most people:

• Old chats come across. During Coexistence onboarding, Meta sends past chats and contacts. When we built this, downloading every old photo in one go hit Meta's rate limit, so our dashboard now fetches old media only when someone opens that chat. For a tiles shop with years of product photos in WhatsApp, that matters.
• Messaging everyone is not free. His first idea was to send every imported contact a "new collection arrived" message from the dashboard. Replies to customers who wrote in the last 24 hours are free, but a first message to anyone outside that window must be an approved template, and Meta charges for it at rates it sets and changes. We sent the campaign only to contacts who had agreed to hear from the shop.

The website form and the Facebook lead forms were connected in the same few days, so each submission landed in "New" with its source attached. That kind of plumbing is what CRM automation means in practice: the CRM fills itself and the team only works the leads.

Days 9 to 11: the first real week, and what broke

Nothing breaks in a demo. Things break on a busy Saturday.

The notebook came back

On Saturday the counter was full and the junior salesman went back to the notebook, because adding a walk-in took too long. The form had eleven fields. We cut it to four required ones: name, number, what they want and next follow-up date. A simple test: if adding a walk-in takes more than a minute on a phone, the form is too long.

The accountant kept updating Excel

The old sheet was read-only on the shop computer, but a copy lived on his own laptop. For three days there were two systems. The owner settled it in one sentence: the CRM is the only list, and anything outside it doesn't count toward sales targets.

The overdue list was embarrassing

On day ten, the overdue follow-up list was full of imported leads nobody had touched in weeks. That was not a CRM problem. It was the first time anyone could see the gap. The senior salesman worked through it over two mornings, and some of those old leads were still interested.

The AI answered in the wrong script

The shop had added an AI assistant to answer night messages in Urdu, Roman Urdu and English and pass serious chats to staff. Customers here send voice notes. In our own setups we have seen speech-to-text write Urdu voice notes in Hindi script, and the AI then replied in Hindi until we forced Urdu transcription. Test any assistant with real voice notes from real customers before you trust it at 11 pm.

Days 12 to 14: who sees what, and four numbers for Monday morning

Access was set up last, once the team was actually using the system:

• Owner: every lead, every stage, every report.
• Salesmen: their own leads plus the shared unassigned list.
• Accountant and warehouse: won orders only, not the sales pipeline.

When a salesperson leaves, you remove their access and reassign their open leads in a few clicks. The history stays with the business.

For reports, the owner asked for twenty charts. We gave him four, checked every Monday: new leads by source, leads won, leads lost with reasons, and overdue follow-ups. Those four show where money leaks. Add another report only when there is a question it will answer.

Off-the-shelf CRM or one built around your shop?

Ready-made CRM software is a monthly subscription you sign up for and configure. It is quick to start and fine for a standard sales process. The catch for many Pakistani businesses: pricing is often per user and in dollars, the features you need may sit on a higher plan, and a proper WhatsApp connection usually needs extra tools. You bend your process to fit the software.

A custom CRM is built around how you already sell: your stages, your fields, Urdu or English labels, approval steps, and links to stock, bookings or billing. Our honest test: if a ready-made tool fits about 80 percent of your process without workarounds, start there. If your team is already fighting the tool, or WhatsApp and your other systems need to talk to it properly, custom usually makes more sense over time. We configure ready-made tools when they fit and build custom ones when they don't, and we only quote after we have seen how you sell.

What a normal week looked like afterwards

No dramatic graph. Just a different kind of week. When a customer called to complain, the owner could open one screen and see every message, quotation and visit. Two salesmen stopped quoting the same customer different rates, because the quotation sat on the record for everyone to see. Leads that came in at night got an answer at night. And when the junior salesman later left for another job, his customers stayed with the shop.

That is the change owners usually describe once the dust settles: the business stops depending on who happens to be holding which phone.

If your leads live in an Excel sheet, a notebook and a few phones today, start small. Write your stages on paper this week and clean one sheet. When you want help with the rest, tell us how you sell through our contact page or on WhatsApp at 0339 4285556, or ask for an audit to find where leads are slipping first.

Further reading

See how this looks in practice across our AI automation, custom CRM and lead generation services, or tell us the outcome you need.