From Excel to SaaS: A 90-Day Migration Plan for Pakistani FMCG Distributors
Last March I sat in a distributor's office in Faisalabad watching his accountant open an Excel file with 47 tabs. Forty-seven. One tab per beat, color-coded by salesman, with formulas that broke if anyone sorted a column.
He was proud of it. And honestly? He should be. That file had run a Rs. 38 crore business for six years.
But it was also the reason he hadn't slept properly in months.
If you're running an FMCG distribution house in Lahore, Karachi, Multan, or anywhere in between, you probably know the file I'm talking about. Maybe yours has 20 tabs. Maybe 80. Either way, you've outgrown it — you just haven't admitted it yet.
So here's a 90-day plan to actually move off Excel without breaking your business. I've helped about 30 distributors through this now, and I've gotten enough things wrong to know what works.
Days 1–30: Don't Touch the Software Yet
This is the part everyone skips. They sign up for Zivni (or BeatRoute, or FieldAssist, or whatever) on a Monday and expect their team using it by Friday. Then they're shocked when it fails.
First month is about cleaning your house.
Start with your outlet master. Pull every shop from every Excel sheet, every WhatsApp group, every salesman's notebook. You'll find duplicates. A lot of them. One distributor I worked with in Sialkot had the same kiryana store listed 4 times across three salesmen — different spellings, different phone numbers, same shutter.
De-duplicate. Get real GPS coordinates (not approximations from Google searches — actual pins). Tag each outlet by channel, by size, by frequency.
Then do the same for your SKU master. Real prices, real schemes, real packing. If your trade scheme is "buy 10 get 1" but your sheet still shows last quarter's "buy 8 get 1," fix it now. Software amplifies whatever data you feed it. Garbage in, garbage out, but at 100x speed.
Also — and this is the bit nobody likes — talk to your salesmen. Not a meeting. Coffee. One-on-one. Ask them what they actually do during the day, not what they're supposed to do. You'll learn things that change your rollout plan.
I used to think this discovery phase was overkill. Then I watched a distributor in Karachi burn $4,200 on a migration that failed because nobody told the owner that two of his salesmen couldn't read English fluently. Whole interface had to change.
Days 31–60: Pilot With One Beat, Not the Whole Team
Here's where most FMCG digitization projects die. The owner gets excited, rolls out to all 18 salesmen at once, and within two weeks half the team is back to paper because "the app is slow" or "the network in Korangi doesn't work."
Pick one beat. Just one. Ideally your second-best salesman — not your best (he doesn't need the help and will resist) and not your worst (he'll blame the software for his own performance).
Run parallel for three weeks. Yes, parallel. He does Excel AND the app. It's painful. He'll complain. Do it anyway, because you need to compare numbers and find the gaps.
During this phase, watch for:
- Orders that get logged in the app but don't match the delivery sheet
- Outlets the salesman visits that aren't in the system
- SKUs he sells that you forgot to add
- The exact moment of day when the app gets used least (usually 2-4pm, post-lunch slump)
Fix these as they come up. Don't batch them. Real distributor software migration works when feedback loops are 24 hours, not 2 weeks.
By day 55, you should have one salesman who's faster on the app than on paper. If you don't, something's wrong — stop and diagnose before scaling.
Days 61–90: Roll Out, But Stagger It
Now you scale. But not all at once.
Week by week, add 2-3 salesmen. Pair each new person with someone already trained. Make the trained guy responsible for the new guy's first week of adoption — give him a small bonus tied to it (Rs. 5,000 works wonders).
Keep Excel running in parallel for ONE more month at the back office level. I know this sounds contradictory after everything I've said, but your accountant needs a safety net while he learns to trust the new reports. Trust takes time. Don't rush it.
By day 75, you should be tracking these five things daily from the SaaS — not Excel:
- Productive calls per salesman (visits that resulted in orders)
- Strike rate by beat
- Lines per bill (a real measure of merchandiser effort)
- Outlets not visited as per plan
- Average order value trend
If any of those five aren't reliable yet, you're not ready to kill Excel. Keep parallel running another two weeks.
Day 90 isn't when you finish. It's when you stop calling it a "migration" and start calling it "how we work."
What I Got Wrong Early
Look, I'll admit this — when we first started rolling out Zivni in Pakistan in 2022, I thought the hard part was the technology. Building good voice order entry in Urdu-English mix. Making the app work on Rs. 15,000 Android phones. GPS that doesn't drain battery in 40°C summer.
That stuff was hard. But it wasn't the hardest part.
The hardest part is convincing a 52-year-old distribution owner that his Excel file — the one he built himself, the one that survived two recessions and a pandemic — isn't his friend anymore. It's the ceiling he keeps banging his head on.
If you're reading this and you recognize yourself in that Faisalabad office I mentioned — 47 tabs, formulas held together with prayer — you don't need to panic. You don't need to migrate tomorrow.
But maybe start the conversation with your team this week. Ask them what they'd fix if they could. You'll be surprised how many answers they already have.
And when you're ready to actually move, 90 days is enough. As long as you spend the first 30 not touching software at all.