{"id":1895,"date":"2026-03-27T04:18:01","date_gmt":"2026-03-27T04:18:01","guid":{"rendered":"https:\/\/aaxonix.com\/resources\/?post_type=case_study&#038;p=1895"},"modified":"2026-03-27T04:27:36","modified_gmt":"2026-03-27T04:27:36","slug":"fmcg-super-stockist-scheme-reconciliation-zoho","status":"publish","type":"case_study","link":"https:\/\/aaxonix.com\/resources\/case-studies\/fmcg-super-stockist-scheme-reconciliation-zoho\/","title":{"rendered":""},"content":{"rendered":"<style>\n.cs-body{max-width:900px;margin:0 auto;padding:32px 0 56px;color:var(--muted);font-size:16px;line-height:1.85;}\n.cs-body h1{font-family:'Fraunces',serif;font-size:clamp(26px,3.5vw,40px);font-weight:900;color:var(--ink);line-height:1.15;margin:0 0 8px;}\n.cs-body h2{font-family:'Fraunces',serif;font-size:clamp(19px,2.4vw,26px);font-weight:800;color:var(--ink);margin:2.8em 0 .8em;line-height:1.2;}\n.cs-body h3{font-family:'Fraunces',serif;font-size:clamp(15px,1.8vw,19px);font-weight:700;color:var(--ink);margin:1.6em 0 .5em;}\n.cs-body p{margin:0 0 1.3em;}\n.cs-body ul{margin:0 0 1.3em;padding-left:1.6em;}\n.cs-body li{margin-bottom:.4em;}\n.cs-body blockquote{border-left:3px solid var(--orange);margin:2em 0;padding:16px 22px;background:var(--surf);border-radius:0 var(--r) var(--r) 0;font-style:italic;color:var(--ink);font-size:16.5px;}\n.cs-body blockquote p{margin:0;}\n.cs-body a{color:var(--blue);text-decoration:underline;text-underline-offset:3px;}\n.cs-body a:hover{color:var(--orange);}\n.cs-eyebrow{display:inline-block;font-size:11px;font-weight:700;letter-spacing:.1em;text-transform:uppercase;color:var(--orange);background:var(--org-xs);border-radius:50px;padding:4px 12px;margin-bottom:18px;}\n.cs-snapshot{display:grid;grid-template-columns:repeat(4,1fr);gap:12px;margin:2em 0;}\n.cs-snap-tile{background:var(--surf);border:1px solid var(--bdr);border-radius:var(--r);padding:16px 14px;text-align:center;}\n.cs-snap-label{font-size:10.5px;font-weight:700;text-transform:uppercase;letter-spacing:.07em;color:var(--dim);margin-bottom:6px;}\n.cs-snap-val{font-size:14px;font-weight:600;color:var(--ink);}\n.cs-problem-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:14px;margin:1.6em 0 2.4em;}\n.cs-problem-card{background:var(--surf);border:1px solid var(--bdr);border-top:3px solid #E8650A;border-radius:0 0 var(--r) var(--r);padding:18px 16px;}\n.cs-problem-card .cs-pc-icon{width:36px;height:36px;background:var(--org-xs);border-radius:8px;display:flex;align-items:center;justify-content:center;margin-bottom:12px;}\n.cs-pc-icon svg{width:20px;height:20px;stroke:#E8650A;fill:none;stroke-width:1.75;stroke-linecap:round;stroke-linejoin:round;}\n.cs-problem-card h3{font-size:13px;font-weight:700;text-transform:uppercase;letter-spacing:.06em;color:var(--ink);margin:0 0 8px;}\n.cs-problem-card p{font-size:13.5px;color:var(--muted);margin:0;}\n.cs-solution-stack{display:flex;flex-direction:column;gap:12px;margin:1.6em 0 2.4em;}\n.cs-sol-row{display:grid;grid-template-columns:160px 1fr;gap:0;border:1px solid var(--bdr);border-radius:var(--r);overflow:hidden;}\n.cs-sol-badge{background:var(--navy);color:#fff;display:flex;flex-direction:column;align-items:center;justify-content:center;padding:16px 12px;text-align:center;gap:6px;}\n.cs-sol-badge .cs-sol-product{font-size:11px;font-weight:700;text-transform:uppercase;letter-spacing:.07em;color:var(--orange);}\n.cs-sol-badge .cs-sol-module{font-size:13px;font-weight:600;color:#fff;}\n.cs-sol-body{padding:16px 18px;background:var(--surf);}\n.cs-sol-body h3{font-size:13px;font-weight:700;color:var(--ink);margin:0 0 6px;}\n.cs-sol-body ul{margin:0;padding-left:1.4em;}\n.cs-sol-body li{font-size:13.5px;color:var(--muted);margin-bottom:.3em;}\n.cs-ba-table{width:100%;border-collapse:collapse;margin:1.6em 0 2.4em;font-size:14px;}\n.cs-ba-table th{padding:10px 14px;text-align:left;font-size:11px;font-weight:700;text-transform:uppercase;letter-spacing:.07em;}\n.cs-ba-table th:first-child{color:var(--dim);background:var(--surf);}\n.cs-ba-table th.before{color:#64748B;background:#F1F5F9;}\n.cs-ba-table th.after{color:var(--orange);background:var(--org-xs);}\n.cs-ba-table td{padding:11px 14px;border-top:1px solid var(--bdr);color:var(--muted);vertical-align:top;}\n.cs-ba-table td:first-child{font-weight:600;color:var(--ink);background:var(--surf);}\n.cs-ba-table td.before{background:#FAFBFC;color:#64748B;}\n.cs-ba-table td.after{background:#FFF8F4;color:#C0440A;font-weight:600;}\n.cs-stats-grid{display:grid;grid-template-columns:repeat(3,1fr);gap:16px;margin:2em 0;}\n.cs-stat-card{background:var(--navy);border-radius:var(--r);padding:24px 18px;text-align:center;}\n.cs-stat-num{font-family:'Fraunces',serif;font-size:clamp(28px,4vw,44px);font-weight:900;color:var(--orange);line-height:1;margin-bottom:8px;}\n.cs-stat-lbl{font-size:12px;color:rgba(255,255,255,.65);font-weight:500;text-transform:uppercase;letter-spacing:.06em;}\n.cs-chart-wrap{background:var(--surf);border:1px solid var(--bdr);border-radius:var(--r);padding:24px;margin:2em 0;}\n.cs-chart-title{font-size:12px;font-weight:700;text-transform:uppercase;letter-spacing:.08em;color:var(--dim);margin:0 0 16px;font-family:'Poppins',sans-serif;}\n.cs-timeline{margin:1.6em 0;display:flex;flex-direction:column;gap:0;}\n.cs-tl-item{display:grid;grid-template-columns:52px 1fr;gap:0;position:relative;}\n.cs-tl-item:not(:last-child)::before{content:'';position:absolute;left:25px;top:52px;bottom:0;width:2px;background:var(--bdr);}\n.cs-tl-badge{width:52px;height:52px;background:var(--navy);color:var(--orange);border-radius:50%;display:flex;align-items:center;justify-content:center;font-family:'Fraunces',serif;font-size:18px;font-weight:900;flex-shrink:0;position:relative;z-index:1;}\n.cs-tl-content{padding:0 0 36px 20px;}\n.cs-tl-title{font-size:15px;font-weight:700;color:var(--ink);margin:12px 0 8px;display:flex;align-items:baseline;gap:10px;flex-wrap:wrap;}\n.cs-tl-dur{font-size:11px;font-weight:600;color:var(--orange);background:var(--org-xs);padding:2px 8px;border-radius:50px;font-family:'Poppins',sans-serif;}\n.cs-tl-content ul{margin:0;padding-left:1.4em;}\n.cs-tl-content li{font-size:14px;margin-bottom:.35em;color:var(--muted);}\n.cs-takeaway{background:var(--navy);border-radius:var(--r);padding:28px 30px;margin:2.4em 0;color:#fff;}\n.cs-takeaway h3{font-family:'Fraunces',serif;font-size:18px;font-weight:800;color:var(--orange);margin:0 0 10px;}\n.cs-takeaway p{font-size:15px;line-height:1.7;color:rgba(255,255,255,.82);margin:0;}\n.cs-faq{margin:2em 0;}\n.cs-faq-item{border-bottom:1px solid var(--bdr);padding:18px 0;}\n.cs-faq-item:last-child{border-bottom:none;}\n.cs-faq-q{font-family:'Fraunces',serif;font-size:16px;font-weight:700;color:var(--ink);margin:0 0 8px;}\n.cs-faq-a{font-size:14.5px;color:var(--muted);margin:0;line-height:1.7;}\n@media(max-width:768px){\n  .cs-snapshot{grid-template-columns:repeat(2,1fr);}\n  .cs-problem-grid{grid-template-columns:1fr;}\n  .cs-sol-row{grid-template-columns:1fr;}\n  .cs-ba-table{font-size:12.5px;}\n  .cs-ba-table th,.cs-ba-table td{padding:8px 10px;}\n  .cs-stats-grid{grid-template-columns:1fr;}\n}\n<\/style>\n\n<div class=\"cs-body\">\n\n<div class=\"cs-eyebrow\">Case Study &nbsp;\u00b7&nbsp; FMCG Super-Stockist Distribution<\/div>\n<h1>How an FMCG Super-Stockist Recovered 47% in Leaked Scheme Claims<\/h1>\n\n<div class=\"cs-snapshot\">\n  <div class=\"cs-snap-tile\"><div class=\"cs-snap-label\">Industry<\/div><div class=\"cs-snap-val\">Multi-Principal FMCG Super-Stockist<\/div><\/div>\n  <div class=\"cs-snap-tile\"><div class=\"cs-snap-label\">Revenue Band<\/div><div class=\"cs-snap-val\">\u20b940-60 Cr annual turnover<\/div><\/div>\n  <div class=\"cs-snap-tile\"><div class=\"cs-snap-label\">Company Size<\/div><div class=\"cs-snap-val\">90-130 employees, 12 van routes<\/div><\/div>\n  <div class=\"cs-snap-tile\"><div class=\"cs-snap-label\">Tools Deployed<\/div><div class=\"cs-snap-val\">Zoho Inventory, Books, Creator, Analytics<\/div><\/div>\n<\/div>\n\n<p>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.<\/p>\n\n<h2>The Problem<\/h2>\n<p>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.<\/p>\n\n<div class=\"cs-problem-grid\">\n  <div class=\"cs-problem-card\">\n    <div class=\"cs-pc-icon\">\n      <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\">\n        <path d=\"M14 2H6a2 2 0 0 0-2 2v16a2 2 0 0 0 2 2h12a2 2 0 0 0 2-2V8z\"><\/path>\n        <polyline points=\"14 2 14 8 20 8\"><\/polyline>\n        <line x1=\"16\" y1=\"13\" x2=\"8\" y2=\"13\"><\/line>\n        <line x1=\"16\" y1=\"17\" x2=\"8\" y2=\"17\"><\/line>\n        <polyline points=\"10 9 9 9 8 9\"><\/polyline>\n      <\/svg>\n    <\/div>\n    <h3>Untracked Scheme Claims<\/h3>\n    <p>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.<\/p>\n  <\/div>\n  <div class=\"cs-problem-card\">\n    <div class=\"cs-pc-icon\">\n      <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\">\n        <path d=\"M21 16V8a2 2 0 0 0-1-1.73l-7-4a2 2 0 0 0-2 0l-7 4A2 2 0 0 0 3 8v8a2 2 0 0 0 1 1.73l7 4a2 2 0 0 0 2 0l7-4A2 2 0 0 0 21 16z\"><\/path>\n        <polyline points=\"3.27 6.96 12 12.01 20.73 6.96\"><\/polyline>\n        <line x1=\"12\" y1=\"22.08\" x2=\"12\" y2=\"12\"><\/line>\n      <\/svg>\n    <\/div>\n    <h3>FEFO Picking Failures<\/h3>\n    <p>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 <a href=\"https:\/\/www.zoho.com\/inventory\/batch-tracking\/\" class=\"sp-content-link\" rel=\"noopener noreferrer\" target=\"_blank\">batch-level expiry tracking<\/a>. Annual write-offs crossed \u20b918 lakhs, eating directly into thin distributor margins.<\/p>\n  <\/div>\n  <div class=\"cs-problem-card\">\n    <div class=\"cs-pc-icon\">\n      <svg viewBox=\"0 0 24 24\" aria-hidden=\"true\">\n        <circle cx=\"12\" cy=\"12\" r=\"10\"><\/circle>\n        <polyline points=\"12 6 12 12 16 14\"><\/polyline>\n      <\/svg>\n    <\/div>\n    <h3>Slow Van Route Settlement<\/h3>\n    <p>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.<\/p>\n  <\/div>\n<\/div>\n\n<h2>The Solution Stack<\/h2>\n<p>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.<\/p>\n\n<div class=\"cs-solution-stack\">\n  <div class=\"cs-sol-row\">\n    <div class=\"cs-sol-badge\">\n      <div class=\"cs-sol-product\">Zoho<\/div>\n      <div class=\"cs-sol-module\">Inventory<\/div>\n    <\/div>\n    <div class=\"cs-sol-body\">\n      <h3>FEFO Picking, Batch Tracking &amp; Van Stock Control<\/h3>\n      <ul>\n        <li>Batch-level tracking with manufacturing and expiry dates on every inward entry from all six principals<\/li>\n        <li>FEFO-enforced pick lists generated automatically, flagging near-expiry batches 30 days before shelf life ends<\/li>\n        <li>12 van warehouses configured as sub-locations with daily stock transfer and return workflows<\/li>\n        <li>Composite items mapped for combo scheme SKUs dispatched as bundled packs<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-sol-row\">\n    <div class=\"cs-sol-badge\">\n      <div class=\"cs-sol-product\">Zoho<\/div>\n      <div class=\"cs-sol-module\">Books<\/div>\n    <\/div>\n    <div class=\"cs-sol-body\">\n      <h3>Multi-Principal Billing, GST &amp; Credit Note Management<\/h3>\n      <ul>\n        <li>Principal-wise chart of accounts isolating margins, scheme income, and credit notes per brand<\/li>\n        <li>Auto-generated GST invoices synced from Inventory dispatches, eliminating double entry from Tally<\/li>\n        <li>Credit note templates mapped to each principal&#8217;s format for scheme claims and sales returns<\/li>\n        <li>Van salesman expense tracking with daily cash\/cheque\/UPI reconciliation journals<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-sol-row\">\n    <div class=\"cs-sol-badge\">\n      <div class=\"cs-sol-product\">Zoho<\/div>\n      <div class=\"cs-sol-module\">Creator<\/div>\n    <\/div>\n    <div class=\"cs-sol-body\">\n      <h3>Scheme Tracker &amp; Van Route Settlement App<\/h3>\n      <ul>\n        <li>Custom scheme master with slab definitions, validity periods, and principal-specific eligibility rules<\/li>\n        <li>Automatic scheme matching: every dispatch line item checked against active scheme slabs in real time<\/li>\n        <li>Van settlement forms with photo upload for damaged returns, auto-calculated outstanding per route<\/li>\n        <li>Quarterly claim generator producing principal-ready reconciliation reports with supporting invoice references<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-sol-row\">\n    <div class=\"cs-sol-badge\">\n      <div class=\"cs-sol-product\">Zoho<\/div>\n      <div class=\"cs-sol-module\">Analytics<\/div>\n    <\/div>\n    <div class=\"cs-sol-body\">\n      <h3>Principal-wise P&amp;L, Expiry Alerts &amp; Route Performance<\/h3>\n      <ul>\n        <li>Per-principal profitability dashboards factoring in scheme income, returns, and credit notes<\/li>\n        <li>Expiry heatmap showing batch-wise days-to-expiry across all warehouse locations<\/li>\n        <li>Route-wise daily settlement status board visible to management and accounts team<\/li>\n        <li>Scheme claim leakage report comparing eligible dispatches against filed claims per quarter<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n<\/div>\n<p>The <a href=\"https:\/\/aaxonix.com\/products\/zoho-inventory\/\" class=\"sp-content-link\">Zoho Inventory implementation<\/a> anchored the warehouse side, while <a href=\"https:\/\/aaxonix.com\/products\/zoho-books\/\" class=\"sp-content-link\">Zoho Books for GST and billing<\/a> replaced manual Tally workflows entirely.<\/p>\n\n<h2>Before vs. After<\/h2>\n<table class=\"cs-ba-table\">\n  <thead>\n    <tr>\n      <th>Process Area<\/th>\n      <th class=\"before\">Before Zoho<\/th>\n      <th class=\"after\">After Zoho<\/th>\n    <\/tr>\n  <\/thead>\n  <tbody>\n    <tr>\n      <td>Scheme Claim Filing<\/td>\n      <td class=\"before\">Manual Excel tracking, 30-40% of valid claims missed each quarter<\/td>\n      <td class=\"after\">Auto-matched to dispatches, 95%+ claims filed within the quarter<\/td>\n    <\/tr>\n    <tr>\n      <td>Warehouse Picking<\/td>\n      <td class=\"before\">Proximity-based picking, no expiry visibility at pick time<\/td>\n      <td class=\"after\">FEFO-enforced pick lists with 30-day expiry alerts<\/td>\n    <\/tr>\n    <tr>\n      <td>Van Route Settlement<\/td>\n      <td class=\"before\">3-4 days per cycle, manual cash and stock reconciliation<\/td>\n      <td class=\"after\">Same-day settlement with photo-verified returns<\/td>\n    <\/tr>\n    <tr>\n      <td>Expiry Write-offs<\/td>\n      <td class=\"before\">\u20b918L+ annual losses on expired short-shelf-life SKUs<\/td>\n      <td class=\"after\">Near-zero write-off with proactive liquidation of aging batches<\/td>\n    <\/tr>\n    <tr>\n      <td>Principal Reconciliation<\/td>\n      <td class=\"before\">Quarterly fire drill with incomplete data, disputes lasting weeks<\/td>\n      <td class=\"after\">System-generated claim packs with invoice-level references<\/td>\n    <\/tr>\n    <tr>\n      <td>GST Compliance<\/td>\n      <td class=\"before\">Tally-based, manual entry of van invoices lagging by 5-7 days<\/td>\n      <td class=\"after\">Auto-synced invoices from dispatch, filed within 24 hours per <a href=\"https:\/\/www.gst.gov.in\/\" class=\"sp-content-link\" rel=\"noopener noreferrer\" target=\"_blank\">GST portal<\/a> deadlines<\/td>\n    <\/tr>\n    <tr>\n      <td>Principal Profitability View<\/td>\n      <td class=\"before\">Aggregated P&amp;L, no visibility into per-brand margins<\/td>\n      <td class=\"after\">Real-time principal-wise margin dashboard including scheme income<\/td>\n    <\/tr>\n  <\/tbody>\n<\/table>\n\n<h2>Implementation Phases<\/h2>\n<div class=\"cs-timeline\">\n  <div class=\"cs-tl-item\">\n    <div class=\"cs-tl-badge\">01<\/div>\n    <div class=\"cs-tl-content\">\n      <h3 class=\"cs-tl-title\">Discovery &amp; Data Audit <span class=\"cs-tl-dur\">Weeks 1-2<\/span><\/h3>\n      <ul>\n        <li>Mapped scheme structures across all six principals, documenting slab types, validity rules, and claim formats<\/li>\n        <li>Audited 14 months of Tally data to identify recurring scheme leakage patterns and expiry write-off peaks<\/li>\n        <li>Documented van route workflows including cash handling, return processes, and settlement cycles<\/li>\n        <li>Catalogued 1,200+ active SKUs with batch-tracking and shelf-life requirements<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-tl-item\">\n    <div class=\"cs-tl-badge\">02<\/div>\n    <div class=\"cs-tl-content\">\n      <h3 class=\"cs-tl-title\">Core Setup &amp; FEFO Configuration <span class=\"cs-tl-dur\">Weeks 3-5<\/span><\/h3>\n      <ul>\n        <li>Configured Zoho Inventory with batch tracking, FEFO rules, and 12 van sub-locations<\/li>\n        <li>Set up Zoho Books with principal-wise chart of accounts and credit note templates<\/li>\n        <li>Built Inventory-to-Books sync for automatic invoice generation on dispatch<\/li>\n        <li>Migrated opening stock with batch-level expiry dates from warehouse physical count<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-tl-item\">\n    <div class=\"cs-tl-badge\">03<\/div>\n    <div class=\"cs-tl-content\">\n      <h3 class=\"cs-tl-title\">Scheme Tracker &amp; Van Settlement App <span class=\"cs-tl-dur\">Weeks 5-8<\/span><\/h3>\n      <ul>\n        <li>Built Creator app with scheme master, slab engine, and auto-matching logic against dispatch data<\/li>\n        <li>Developed van settlement module with multi-mode collection entry (cash, cheque, UPI) and return logging<\/li>\n        <li>Connected Creator to Inventory and Books via <a href=\"https:\/\/www.zoho.com\/deluge\/help\/\" class=\"sp-content-link\" rel=\"noopener noreferrer\" target=\"_blank\">Deluge workflows<\/a> for real-time data flow<\/li>\n        <li>Tested scheme matching accuracy against two quarters of historical dispatch data<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n  <div class=\"cs-tl-item\">\n    <div class=\"cs-tl-badge\">04<\/div>\n    <div class=\"cs-tl-content\">\n      <h3 class=\"cs-tl-title\">Analytics, Training &amp; Go-Live <span class=\"cs-tl-dur\">Weeks 8-10<\/span><\/h3>\n      <ul>\n        <li>Built Analytics dashboards for principal profitability, expiry heatmaps, and scheme leakage reports<\/li>\n        <li>Trained warehouse team on FEFO pick list workflows and near-expiry alert responses<\/li>\n        <li>Ran parallel operations for one full settlement cycle across all 12 van routes<\/li>\n        <li>Filed first system-generated quarterly scheme claims with two principals as pilot<\/li>\n      <\/ul>\n    <\/div>\n  <\/div>\n<\/div>\n<p>The scheme tracker and settlement module were built on <a href=\"https:\/\/aaxonix.com\/products\/zoho-creator\/\" class=\"sp-content-link\">Zoho Creator&#8217;s low-code platform<\/a>, with <a href=\"https:\/\/aaxonix.com\/products\/zoho-analytics\/\" class=\"sp-content-link\">Zoho Analytics dashboards<\/a> layered on top for management visibility.<\/p>\n\n<h2>Results<\/h2>\n<p>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.<\/p>\n\n<div class=\"cs-stats-grid\">\n  <div class=\"cs-stat-card\">\n    <div class=\"cs-stat-num\" id=\"cs-counter-1\" data-target=\"47\" data-suffix=\"%\">0%<\/div>\n    <div class=\"cs-stat-lbl\">Less unclaimed principal schemes<\/div>\n  <\/div>\n  <div class=\"cs-stat-card\">\n    <div class=\"cs-stat-num\" id=\"cs-counter-2\" data-target=\"3.2\" data-suffix=\"x\" data-decimals=\"1\">0x<\/div>\n    <div class=\"cs-stat-lbl\">Faster van route settlement<\/div>\n  <\/div>\n  <div class=\"cs-stat-card\">\n    <div class=\"cs-stat-num\" id=\"cs-counter-3\" data-target=\"18\" data-prefix=\"\u20b9\" data-suffix=\"L\">\u20b90L<\/div>\n    <div class=\"cs-stat-lbl\">Annual expiry write-off saved<\/div>\n  <\/div>\n<\/div>\n\n<div class=\"cs-chart-wrap\">\n  <div class=\"cs-chart-title\">Quarterly Scheme Claims Recovery and Expiry Metrics<\/div>\n  <canvas id=\"cs-chart-1\" height=\"200\"><\/canvas>\n<\/div>\n\n<div class=\"cs-chart-wrap\" style=\"display:grid;grid-template-columns:1fr 1fr;gap:24px;\">\n  <div><div class=\"cs-chart-title\">Before: Time Allocation<\/div><canvas id=\"cs-chart-2a\" height=\"200\"><\/canvas><\/div>\n  <div><div class=\"cs-chart-title\">After: Time Allocation<\/div><canvas id=\"cs-chart-2b\" height=\"200\"><\/canvas><\/div>\n<\/div>\n\n<div class=\"cs-takeaway\">\n  <h3>What This Means for FMCG Super-Stockists<\/h3>\n  <p>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 <a href=\"https:\/\/aaxonix.com\/case-studies\/\" class=\"sp-content-link\">other FMCG case studies<\/a>.<\/p>\n<\/div>\n\n<h2>Frequently Asked Questions<\/h2>\n<div class=\"cs-faq\">\n  <div class=\"cs-faq-item\">\n    <div class=\"cs-faq-q\">How does the scheme tracker handle different slab structures across principals?<\/div>\n    <p class=\"cs-faq-a\">Each principal&#8217;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.<\/p>\n  <\/div>\n  <div class=\"cs-faq-item\">\n    <div class=\"cs-faq-q\">Can the FEFO system work with van stock that sits outside the main warehouse?<\/div>\n    <p class=\"cs-faq-a\">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.<\/p>\n  <\/div>\n  <div class=\"cs-faq-item\">\n    <div class=\"cs-faq-q\">What happens when a principal changes scheme terms mid-quarter?<\/div>\n    <p class=\"cs-faq-a\">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.<\/p>\n  <\/div>\n  <div class=\"cs-faq-item\">\n    <div class=\"cs-faq-q\">How long did it take for the accounts team to stop using Tally in parallel?<\/div>\n    <p class=\"cs-faq-a\">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.<\/p>\n  <\/div>\n<\/div>\n\n<\/div>\n\n<script>\n(function(){\n  var CU = (typeof countUp !== 'undefined' && countUp.CountUp) ? countUp.CountUp : (typeof CountUp !== 'undefined' ? CountUp : null);\n\n  function initCounters(){\n    if(!CU) return;\n    document.querySelectorAll('[id^=\"cs-counter-\"]').forEach(function(el){\n      var cu=new CU(el.id,parseFloat(el.dataset.target)||0,{\n        duration:2.2,useEasing:true,useGrouping:true,\n        prefix:el.dataset.prefix||'',\n        suffix:el.dataset.suffix||'',\n        decimalPlaces:parseInt(el.dataset.decimals||'0',10)\n      });\n      if(!cu.error) cu.start();\n    });\n  }\n\n  function initCharts(){\n    if(typeof Chart==='undefined') return;\n\n    var c1=document.getElementById('cs-chart-1');\n    if(c1) new Chart(c1,{type:'bar',data:{\n      labels:['Scheme Claims Filed (%)','Van Settlement (days)','Expiry Write-off (\u20b9L)','Principal Disputes (per Qtr)'],\n      datasets:[\n        {label:'Before',data:[58,3.5,18,12],backgroundColor:'#94A3B8',borderRadius:4},\n        {label:'After',data:[95,1.1,2,3],backgroundColor:'#E8650A',borderRadius:4}\n      ]},options:{indexAxis:'y',responsive:true,animation:{duration:1200},\n      plugins:{legend:{position:'bottom',labels:{font:{family:'Poppins',size:12},color:'#64748B'}}},\n      scales:{x:{grid:{color:'rgba(0,0,0,.06)'},ticks:{font:{family:'Poppins',size:11},color:'#64748B'}},\n        y:{grid:{display:false},ticks:{font:{family:'Poppins',size:12},color:'#334155'}}}}});\n\n    ['cs-chart-2a','cs-chart-2b'].forEach(function(id,i){\n      var c=document.getElementById(id); if(!c) return;\n      new Chart(c,{type:'doughnut',data:{\n        labels:['Scheme Reconciliation','Van Settlement','Expiry Management','Selling & Operations'],\n        datasets:[{data: i===0 ? [30,35,15,20] : [8,10,5,77],\n          backgroundColor:['#E8650A','#94A3B8','#CBD5E1','#F97316'],borderWidth:0}]\n      },options:{responsive:true,animation:{duration:1200},cutout:'55%',\n        plugins:{legend:{position:'bottom',labels:{font:{family:'Poppins',size:11},color:'#64748B'}}}}});\n    });\n  }\n\n  var grid=document.querySelector('.cs-stats-grid');\n  if(grid&&'IntersectionObserver' in window){\n    var done=false;\n    new IntersectionObserver(function(entries,obs){\n      if(entries[0].isIntersecting&&!done){done=true;obs.disconnect();initCounters();initCharts();}\n    },{threshold:0.1}).observe(grid);\n  } else {\n    initCounters(); initCharts();\n  }\n})();\n<\/script>","protected":false},"excerpt":{"rendered":"<p>A multi-principal FMCG super-stockist recovered 47% of previously unclaimed scheme income by building a unified scheme tracker and FEFO picking system on&#8230;<\/p>\n","protected":false},"featured_media":1894,"template":"","meta":{"cs_card_title":"How an FMCG Super-Stockist Recovered 47% in Leaked Scheme Claims","cs_result_num":"47%","cs_result_label":"Less unclaimed principal schemes","cs_stat2_num":"3.2x","cs_stat2_label":"Faster van route settlement","cs_stat3_num":"\u20b918L","cs_stat3_label":"Annual expiry write-off saved","cs_challenge":"Scheme claims worth lakhs went unreconciled every quarter across six principals.","cs_solution":"Unified scheme tracker and FEFO picking built on Zoho for 12 van routes.","cs_tools":"Zoho Inventory, Zoho Books, Zoho Creator, Zoho Analytics"},"cs_industry":[431],"class_list":["post-1895","case_study","type-case_study","status-publish","has-post-thumbnail","hentry","cs_industry-distribution"],"_links":{"self":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/case_study\/1895","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/case_study"}],"about":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/types\/case_study"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media\/1894"}],"wp:attachment":[{"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/media?parent=1895"}],"wp:term":[{"taxonomy":"cs_industry","embeddable":true,"href":"https:\/\/aaxonix.com\/resources\/wp-json\/wp\/v2\/cs_industry?post=1895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}