Calculating ROI on Field Sales Software: A Template I Actually Use With FMCG Distributors

Last month a distributor in Sharjah sent me a WhatsApp at 11pm. "Sufyan, my CFO wants the ROI math before Sunday. Help."

He runs 38 sales reps across the Northern Emirates. Biscuits, juices, a couple of personal care brands. Decent business — around AED 4.2M monthly secondary sales. He'd been demoing Zivni for three weeks and his team loved it. But the CFO wanted numbers.

So I sent him the same spreadsheet I send everyone. And honestly, it's the same template I wish someone had handed me back when I was on the other side of these conversations, trying to justify software to a finance team that thought Excel was already too fancy.

Let me walk you through it.

The four buckets that actually matter

Most ROI decks for FMCG software are bloated with vanity metrics. "Improved visibility." "Better decision-making." Sure, fine. But CFOs don't sign off on adjectives.

There are really only four buckets where field sales software produces measurable money:

1. Productive selling time recovered. Your reps lose time. To paperwork, to manual order forms, to calling the office to check stock, to driving the wrong sequence of outlets. In the audits we've run with distributors in Karachi, Riyadh, and Manchester, the average rep spends 2 hours and 17 minutes a day on non-selling work. That's not me rounding for effect — that's the actual median across 14 distributor audits we did in 2024.

If you can claw back even 45 minutes per rep per day, on a team of 38 reps, that's roughly 28 extra selling hours daily. Multiply by your average order value and conversion rate.

2. Outlet coverage uplift. Reps with planned beats and GPS-tracked attendance hit more outlets. Not because they're being watched (though that helps) — because the route is actually planned. My Sharjah friend was averaging 22 outlets per rep per day on paper. The actual GPS data, once we ran a pilot, showed 14. Reality vs. report card.

3. Order value lift from better SKU recommendations. This one's quiet but huge. When a rep walks into a grocery in Al Khobar with a voice-order app that suggests "this outlet hasn't ordered Lipton 100s in 6 weeks, and they're a high-velocity SKU here" — basket size grows. We typically see 8–14% uplift in lines per order in the first 90 days.

4. Reduced returns, expiry write-offs, and reconciliation losses. Most distributors I talk to bleed 2–4% of revenue here. Better shelf audits, better forecasting, fewer "I forgot to mark that return" moments.

The template — fill in your own numbers

Here's the actual structure. Steal it, adapt it, send it to your CFO:

A. Current State
- Number of field reps: ___
- Average monthly secondary sales: ___
- Outlets in universe: ___
- Outlets covered per rep per day (actual, not reported): ___
- Average order value: ___
- Returns + expiry as % of sales: ___

B. Expected Improvements (be conservative)
- Selling time recovered per rep per day: 45 min
- Outlet coverage uplift: 18%
- Order value uplift: 9%
- Returns reduction: 1.2 percentage points

C. Annual Gain Calculation
- Coverage gain × avg order value × working days
- Order value uplift × current order count × working days
- Returns saved × annual sales
- Subtract: software cost (users × $5–15/month × 12)
- Subtract: implementation + training (one-time)

D. Payback Period (months)
= Total Year 1 Investment ÷ Monthly Net Gain

For my Sharjah friend, the math came out to a payback of 2.8 months. Conservative version. The aggressive version (which I don't recommend showing the CFO first) was 1.6 months.

Where founders and distributors mess this up

I used to pitch ROI by stacking every possible benefit. "Look at all this value!" It backfired. CFOs are professional skeptics. If your deck claims 340% ROI in year one, they assume you're lying about all of it.

Here's the thing — under-promise on the numbers. If you genuinely believe coverage will go up 25%, write 15% in the business case. When the actual results land at 22%, you're a hero. When you promise 25% and deliver 18%, you're a vendor problem.

The other mistake: ignoring the soft costs of not doing this. A distributor I worked with in Lahore lost their second-biggest principal because they couldn't produce outlet-level coverage reports. The principal moved to a competitor who could. That's not a line item in any ROI template, but it's a real number. Around PKR 90M annually, in his case.

And one more — don't forget attrition. Field reps quit. A lot. In FMCG, annual turnover in the GCC sits around 34% based on the HR data distributors share with us. Replacing a rep costs roughly 1.5x their monthly salary by the time you factor in recruitment, training, and the lost productivity gap. Software that makes reps' lives easier (no more paper forms, no more arguments about attendance, gamified targets they can actually see) reduces this. Not to zero. But meaningfully.

What I'd actually do this week

If you're a distributor reading this and you're somewhere between "curious" and "my principal is breathing down my neck about visibility," do this:

Pick 5 reps. Run a 30-day pilot. Measure the four buckets before and after. Don't trust vendor case studies (including mine) — trust your own data on your own outlets.

That's the only ROI template that actually matters. The spreadsheet is just a way to explain the result to people who weren't in the field with you.

If you want the actual Excel version of this template, message me on the Zivni site and I'll send it over. No form, no demo gating. It's just a spreadsheet, and you should have it whether you end up using us or FieldAssist or building something in-house.

What does your current rep day actually look like, hour by hour? If you don't know — and most distributors don't, not really — that's where to start.