Case Study · FMCG Super-Stockist Distribution
How an FMCG Super-Stockist Recovered 47% in Leaked Scheme Claims
Industry
Multi-Principal FMCG Super-Stockist
Revenue Band
₹40-60 Cr annual turnover
Company Size
90-130 employees, 12 van routes
Tools Deployed
Zoho Inventory, Books, Creator, Analytics
This multi-principal super-stockist handles distribution for six FMCG brands across 12 dedicated van routes. Quarterly scheme reconciliation with each principal had become a black hole, with lakhs in valid claims slipping through the cracks every cycle. Expiry management was equally broken, costing the business heavily in write-offs on short-shelf-life SKUs.
The Problem
Running six principal relationships meant six different scheme structures, six credit note formats, and six quarterly reconciliation cycles. The operations team was drowning in spreadsheets with no single source of truth for what was owed.
Untracked Scheme Claims
Each principal announced trade schemes via circulars, but the team tracked eligibility in disconnected Excel files. By quarter-end, 30-40% of valid claims were never filed because no one mapped dispatches to active scheme slabs in real time.
FEFO Picking Failures
Warehouse staff picked stock based on bin proximity, not expiry dates. Short-shelf-life products like biscuits, snacks, and personal care items expired on shelves without batch-level expiry tracking. Annual write-offs crossed ₹18 lakhs, eating directly into thin distributor margins.
Slow Van Route Settlement
Each van salesman returned with a mix of cash, cheques, UPI screenshots, and unsold stock. Settling 12 routes took the accounts team 3-4 days per cycle. Discrepancies between physical returns and Tally entries carried forward for weeks unresolved.
The Solution Stack
The implementation focused on three priorities: real-time scheme tracking against dispatches, enforced FEFO picking at the warehouse, and same-day van route settlement across all 12 routes.
FEFO Picking, Batch Tracking & Van Stock Control
- Batch-level tracking with manufacturing and expiry dates on every inward entry from all six principals
- FEFO-enforced pick lists generated automatically, flagging near-expiry batches 30 days before shelf life ends
- 12 van warehouses configured as sub-locations with daily stock transfer and return workflows
- Composite items mapped for combo scheme SKUs dispatched as bundled packs
Multi-Principal Billing, GST & Credit Note Management
- Principal-wise chart of accounts isolating margins, scheme income, and credit notes per brand
- Auto-generated GST invoices synced from Inventory dispatches, eliminating double entry from Tally
- Credit note templates mapped to each principal’s format for scheme claims and sales returns
- Van salesman expense tracking with daily cash/cheque/UPI reconciliation journals
Scheme Tracker & Van Route Settlement App
- Custom scheme master with slab definitions, validity periods, and principal-specific eligibility rules
- Automatic scheme matching: every dispatch line item checked against active scheme slabs in real time
- Van settlement forms with photo upload for damaged returns, auto-calculated outstanding per route
- Quarterly claim generator producing principal-ready reconciliation reports with supporting invoice references
Principal-wise P&L, Expiry Alerts & Route Performance
- Per-principal profitability dashboards factoring in scheme income, returns, and credit notes
- Expiry heatmap showing batch-wise days-to-expiry across all warehouse locations
- Route-wise daily settlement status board visible to management and accounts team
- Scheme claim leakage report comparing eligible dispatches against filed claims per quarter
The Zoho Inventory implementation anchored the warehouse side, while Zoho Books for GST and billing replaced manual Tally workflows entirely.
Before vs. After
| Process Area |
Before Zoho |
After Zoho |
| Scheme Claim Filing |
Manual Excel tracking, 30-40% of valid claims missed each quarter |
Auto-matched to dispatches, 95%+ claims filed within the quarter |
| Warehouse Picking |
Proximity-based picking, no expiry visibility at pick time |
FEFO-enforced pick lists with 30-day expiry alerts |
| Van Route Settlement |
3-4 days per cycle, manual cash and stock reconciliation |
Same-day settlement with photo-verified returns |
| Expiry Write-offs |
₹18L+ annual losses on expired short-shelf-life SKUs |
Near-zero write-off with proactive liquidation of aging batches |
| Principal Reconciliation |
Quarterly fire drill with incomplete data, disputes lasting weeks |
System-generated claim packs with invoice-level references |
| GST Compliance |
Tally-based, manual entry of van invoices lagging by 5-7 days |
Auto-synced invoices from dispatch, filed within 24 hours per GST portal deadlines |
| Principal Profitability View |
Aggregated P&L, no visibility into per-brand margins |
Real-time principal-wise margin dashboard including scheme income |
Implementation Phases
01
Discovery & Data Audit Weeks 1-2
- Mapped scheme structures across all six principals, documenting slab types, validity rules, and claim formats
- Audited 14 months of Tally data to identify recurring scheme leakage patterns and expiry write-off peaks
- Documented van route workflows including cash handling, return processes, and settlement cycles
- Catalogued 1,200+ active SKUs with batch-tracking and shelf-life requirements
02
Core Setup & FEFO Configuration Weeks 3-5
- Configured Zoho Inventory with batch tracking, FEFO rules, and 12 van sub-locations
- Set up Zoho Books with principal-wise chart of accounts and credit note templates
- Built Inventory-to-Books sync for automatic invoice generation on dispatch
- Migrated opening stock with batch-level expiry dates from warehouse physical count
03
Scheme Tracker & Van Settlement App Weeks 5-8
- Built Creator app with scheme master, slab engine, and auto-matching logic against dispatch data
- Developed van settlement module with multi-mode collection entry (cash, cheque, UPI) and return logging
- Connected Creator to Inventory and Books via Deluge workflows for real-time data flow
- Tested scheme matching accuracy against two quarters of historical dispatch data
04
Analytics, Training & Go-Live Weeks 8-10
- Built Analytics dashboards for principal profitability, expiry heatmaps, and scheme leakage reports
- Trained warehouse team on FEFO pick list workflows and near-expiry alert responses
- Ran parallel operations for one full settlement cycle across all 12 van routes
- Filed first system-generated quarterly scheme claims with two principals as pilot
The scheme tracker and settlement module were built on Zoho Creator’s low-code platform, with Zoho Analytics dashboards layered on top for management visibility.
Results
Within two quarterly cycles of go-live, the business recovered scheme income that had been silently leaking for years. Van route settlement moved from a multi-day backlog to a same-day close, and the warehouse stopped bleeding money on expired stock. The finance team now enters each FY with clean principal-wise books instead of a pile of unresolved disputes.
0%
Less unclaimed principal schemes
0x
Faster van route settlement
₹0L
Annual expiry write-off saved
Quarterly Scheme Claims Recovery and Expiry Metrics
What This Means for FMCG Super-Stockists
Multi-principal distributors lose margin not on sales, but on the back-end: unclaimed schemes, expired stock, and settlement delays that compound silently quarter after quarter. The fix is not better spreadsheets. It is a system that matches every dispatch to every active scheme slab automatically and enforces picking discipline at the warehouse floor, turning two of the biggest hidden cost centres into recoverable income. See how similar results have been achieved in our other FMCG case studies.
Frequently Asked Questions
How does the scheme tracker handle different slab structures across principals?
Each principal’s scheme is configured as a separate entry in the Creator scheme master with its own slab tiers, validity window, and eligibility criteria. When a dispatch is recorded, the system checks the line items against all active schemes for that principal and flags qualifying volumes. This means a buy-10-get-1 scheme from one brand and a percentage discount slab from another are both tracked independently without manual cross-referencing.
Can the FEFO system work with van stock that sits outside the main warehouse?
Yes. Each van is configured as a sub-location in Zoho Inventory with its own batch-level stock register. When stock is transferred from the main warehouse to a van, the batch and expiry data travels with it. Returns from van routes are logged back with the same batch references, so expiry tracking stays accurate across the entire chain from warehouse shelf to van to retailer.
What happens when a principal changes scheme terms mid-quarter?
The operations team updates the scheme master in Creator with a new validity start date. All dispatches before the change date remain mapped to the old slab, and dispatches after the change pick up the revised terms. The quarterly claim generator produces separate line items for each scheme version, so the reconciliation with the principal stays clean and auditable.
How long did it take for the accounts team to stop using Tally in parallel?
The parallel run lasted one full settlement cycle, roughly three weeks. The main friction point was van salesmen adapting to the mobile settlement form instead of paper slips. By the second month, the accounts team was closing daily reconciliation in Zoho Books directly. Tally was retained only for statutory filing until the GST return workflow in Books was validated across two filing cycles.
