Sub-Stockist Secondary Sales Reconciliation for FMCG

A national FMCG brand’s regional finance manager opens the May 2026 sub-stockist secondary-sales reconciliation pack for Uttar Pradesh East and reads three numbers in sequence. DMS portal feed for the month — ₹14.7 crore across 312 sub-stockists. Van-tally register total compiled by the field-sales managers across the same 312 sub-stockists — ₹13.9 crore. Retailer scheme-claim submissions for May filed back through the chain — ₹2.1 crore against ₹13.4 crore of qualifying secondary. The variance bridge between DMS and van-tally is ₹80 lakh, or 5.4 percent of the reported base, and the scheme-claim base of ₹13.4 crore is ₹1.3 crore below the DMS feed but ₹50 lakh above the van-tally. Somewhere inside the gap sit 47 ghost retailer codes pushing slow-moving Tiger biscuit packs at quarter-end to clear a state-level slab scheme. This is sub stockist secondary sales reconciliation FMCG at production scale, and the reconciliation discipline that resolves it is what protects the brand from paying schemes against phantom sales and what protects the PLISFPI incremental-sales claim from a CA-certification mark-down.

The reconciliation in one paragraph

A sub-stockist sits between the super-stockist (the brand’s primary appointment in the district) and the retailer (the kirana, the bakery, the modern outlet on the high street). The brand bills the super-stockist; the super-stockist bills the sub-stockist; the sub-stockist’s van dispatches stock to retailers and reports the dispatch back through a Distributor Management System portal — typically Botree, Bizom, or Salesworx. The DMS feed is what the brand treats as canonical secondary sales for trade-promotion accrual, growth-over-base scheme payouts, and incremental-sales certification under PLISFPI. But the DMS feed lags actual retail offtake by 7 to 14 days because of batch data-entry, retailer-master onboarding queues, and returns adjustments. The sub-stockist’s own van-tally register — handwritten by the salesman in the field or captured in a sales-force-automation app — runs ahead of DMS but represents a different cut. The retailer scheme-claim submission comes back up the chain 30 to 60 days later and references retailer codes that may not match the DMS master. Reconciling all three flows is what separates a brand that pays schemes on real sales from a brand that pays schemes on ghost codes.

What sub-stockist secondary sales actually looks like in India

The four-layer general-trade pyramid — brand, super-stockist (or C&F agent feeding super-stockists), sub-stockist, retailer — is the operating backbone of Indian FMCG distribution for categories where direct distribution is uneconomic at scale. A national biscuit brand like Britannia ships Tiger from its Hajipur or Khurda plant to a super-stockist in Lucknow; the Lucknow super-stockist appoints sub-stockists in Gorakhpur, Varanasi, Allahabad, and Kanpur; each sub-stockist runs four to twelve delivery vans against a kirana universe of 500 to 1,500 retailers per van route. The Gorakhpur sub-stockist receives a primary invoice from the Lucknow super-stockist for, say, 2,400 cases of Tiger 100 g at MRP ₹10 per pack, takes the goods inward into the godown, and dispatches against retailer orders over the next 21 to 28 days. The van returns at end-of-day with cash, credit slips, returned packs, and a hand-written delivery sheet listing retailer name, retailer code, packs delivered, MRP value, and signed acknowledgement.

The dispatch flow into the DMS portal is rarely real-time. The sub-stockist’s back-office punches the delivery sheet into the Bizom or Botree screen the next morning — invoice number, retailer code, SKU, quantity, MRP, GST, scheme reference. The DMS portal validates the retailer code against the brand’s retailer master; new codes go into a pending-approval queue routed to the regional sales manager. The DMS line clears the queue 2 to 5 working days later and only then becomes visible in the brand’s secondary-sales report. Returns — packs the retailer refused or damaged units swapped — flow through a separate goods-inward voucher reconciled to the original dispatch invoice over the next 7 to 14 days. By the time the dispatch line is fully reconciled in DMS to its net of returns and credits, two weeks have passed.

The parallel record is the van-tally register. Field sales managers do not trust the DMS feed for daily performance review — DMS lags reality by a week. The sub-stockist office maintains a parallel daily van-tally — total packs dispatched per van per day, beat-wise route productivity, retailer coverage versus target. This van-tally feeds upward to the area sales manager and the regional sales manager as the operating data they manage on. The DMS feed and the van-tally diverge for legitimate reasons (the lag, the pending masters, the returns) and for illegitimate reasons (the ghost retailer codes, the scheme-cycle inflation).

The third record arrives 30 to 60 days after dispatch: the retailer scheme-claim submission. A retailer who participated in a scheme cycle — a Tiger biscuit dealer scheme offering 1 case free on every 10 cases purchased — submits a claim through the sub-stockist for reimbursement. The sub-stockist consolidates the retailer claims for its territory and routes them up to the super-stockist and on to the brand. The retailer codes on the scheme claim should match the DMS master one-to-one; in practice, 4 to 12 percent of claims reference retailer codes the brand cannot reconcile to DMS, either because the sub-stockist generated codes specifically for the scheme cycle or because the scheme captured retailer codes from an older master not refreshed in the current cycle.

The Section 393(1) Sl. 18 regulatory overlay

Sub-stockist commission paid in cash by the brand or by the super-stockist on the brand’s behalf is subject to TDS under Section 393(1) Sl. 18 of the Income-tax Act 2025 at 5% beyond the threshold per deductee per financial year. The provision succeeds legacy Section 194H. Payment codes 1015 and 1016 in the new TRACES taxonomy capture sub-stockist commission deductions, and the deductee reconciles credit at the PAN level in Form 26AS. The deductor — typically the brand’s accounts-payable team for direct sub-stockist commission, or the super-stockist for second-tier appointments where the brand has shifted the deduction obligation — files Form 26Q quarterly.

Two structural errors are common. First, scheme net-off treated as commission. When a scheme is settled by reducing the sub-stockist’s next dispatch invoice by the scheme value, this is a value reduction of the supply (Section 15(2) CGST territory) and not a commission payment. No TDS applies. AP teams that treat every payable line on the sub-stockist ledger as commission over-deduct, and the brand is forced to either issue refund letters at year-end or accept that the over-deduction sits in the sub-stockist’s Form 26AS without an offsetting commission income — a mismatch the sub-stockist’s CA will raise at audit.

Second, threshold straddle. The Section 393(1) Sl. 18 threshold is per deductee per financial year. A sub-stockist who crossed the threshold mid-year on commission alone but had additional payments routed via the super-stockist (so the brand’s direct deduction did not capture the full base) ends up under-deducted at the brand level. The reconciliation engine must aggregate the brand-direct commission and the super-stockist-routed commission per sub-stockist PAN per FY before applying the deduction rule. A sub-stockist running on multiple super-stockists in different states creates a cross-state aggregation problem that the AP team rarely catches without a structured reconciliation.

The Section 15(2) CGST overlay matters for the scheme leg. If the sub-stockist scheme is a post-supply discount that qualifies under the three-prong test — agreement at or before time of supply, linked to specific invoices, and ITC reversal by the recipient — the scheme amount reduces taxable value through a Section 34 credit note. If it fails the test (typically because the sub-stockist does not actively reverse ITC on retro schemes), the scheme amount stays inside the taxable value and the brand cannot reduce GST liability. The TPM accrual vs payout reconciliation article walks the per-scheme Section 15(2) determination in detail; the sub-stockist reconciliation feeds the determination at the lowest tier of the chain.

A worked example — Britannia Tiger through a UP East sub-stockist

A leading biscuit manufacturer — one of the 53 PLISFPI-notified beneficiaries — runs Tiger biscuit secondary sales through 312 sub-stockists in Uttar Pradesh East during May 2026. The brand’s controller pulls the regional reconciliation pack on 18 June 2026 for the May cycle.

Illustrative — public disclosures do not reveal internal sub-stockist secondary breakdowns; the figures here are representative of the operating pattern, not actual brand data. Cross-verify against your own DMS export or van-tally register before action.

The headline reconciliation summary for UP East, May 2026:

The DMS-minus-van-tally variance of ₹80 lakh decomposes into the variance bridge:

The ₹21 lakh ghost-code exposure traces to 47 retailer codes across 12 sub-stockists; the outlet-audit team is dispatched to 12 of the highest-exposure codes and finds 9 closed shops, 2 placeholder codes, and 1 fabricated address that does not exist on the ground. Scheme payouts against these codes are held; the sub-stockist responsible for the largest cluster (4 ghost codes worth ₹6.4 lakh exposure) receives a regional-finance-manager notice and is asked to substantiate or forego the scheme reimbursement on the disputed lines.

The retailer scheme-claim submission of ₹2.1 crore matches against the DMS-reported scheme-eligible secondary of ₹2.05 crore — a ₹5 lakh inflation on the claim side that breaks down further: 14 claim lines reference retailer codes not present in the May DMS master at all (₹2.3 lakh, classified as claim inflation, held), 22 lines reference codes present but with claim quantities exceeding DMS dispatch quantities (₹1.7 lakh, partially approved at DMS quantity), and 8 lines reference correctly but apply the wrong scheme percentage (₹1.0 lakh corrected to scheme matrix rate).

The Section 393(1) Sl. 18 commission reconciliation for May:

Sixteen sub-stockists crossed the per-deductee threshold during May; TDS at 5% on the post-threshold portion is computed at ₹52,800 against May commission. Three sub-stockists with multi-state super-stockist appointments are flagged for cross-state aggregation; the brand-direct deduction is reconciled to the super-stockist-routed deduction and a top-up of ₹14,200 is processed in the May Form 26Q.

Common reconciliation breakages

• Ghost retailer codes — closed shops, placeholder codes, or fabricated outlets in the DMS master that absorb secondary sales at scheme-cycle quarter-end and trigger payouts on phantom retail offtake.
• Reporting lag misclassified as variance — the 7 to 14 day DMS-versus-van-tally lag treated as a reconciliation gap and chased operationally, wasting field-team bandwidth on legitimate timing differences.
• Returns-adjustment double counting — the dispatch line credited once for the return goods inward and credited again when the credit-note net-off lands at the super-stockist tier.
• Scheme net-off treated as commission for TDS — Section 393(1) Sl. 18 over-deduction on what is structurally a Section 15(2) value reduction, distorting Form 26AS for the sub-stockist.
• Cross-state threshold aggregation missed — sub-stockists appointed across multiple super-stockists in different states have commission flows that bypass the brand-direct deduction view, leaving the per-deductee threshold under-applied.
• Scheme-claim retailer codes not in DMS — retailer codes on the scheme claim that fail the DMS master lookup are paid against the sub-stockist’s aggregate rather than the individual retailer, which loses the ghost-code detection signal.

How a reconciliation platform handles this

A reconciliation platform ingests the DMS portal feed from Botree, Bizom, or Salesworx in its native format, the van-tally register from field-sales upload, and the retailer scheme-claim submission from the brand’s claim portal, ties each line against the others on sub-stockist code, retailer code, SKU, and dispatch date, classifies the variance into a fixed taxonomy (reporting lag, pending master, returns timing, ghost-code candidate, scheme-claim inflation), surfaces a ghost-candidate retailer list ranked by exposure for the outlet-audit team, splits the Section 393(1) Sl. 18 commission flow from the scheme net-off flow so that TDS is only deducted on cash commission, aggregates per-deductee commission across super-stockists for the threshold test, and produces an audit-ready evidence pack that the certifying chartered accountant uses to substantiate PLISFPI incremental-sales claims. The platform-level multi-pass matching engine and DPDP-aligned audit trail are the same components that deliver the public 51% to 88% match-rate improvement; the deployment is on AWS Mumbai with ISO 27001:2022 controls. Brands evaluating this surface should review the FMCG reconciliation software India commercial pillar and the broader reconciliation software India capability map.

Cross-cluster bridges and where to read next

Sub-stockist secondary sales is the input data on which TPM accrual versus payout reconciliation runs at the brand level; once the secondary base is clean, the slab discount distributor claim recovery flow processes the discount payouts, the growth-over-base scheme reconciliation closes the annual incentive cycle, and the retro credit-note quarter-end flow handles the bulk Section 34 credit-note cycle. For brands whose secondary flows through modern-trade chains in parallel, the modern trade settlement variance article walks the parallel reconciliation. The five FAQs below address the operational questions Indian FMCG controllers and CFOs ask most often when implementing structured sub-stockist secondary-sales reconciliation.

Terra Insight Reconciliation Infrastructure

Content authored by practitioners with experience at Amazon India, Intuit QuickBooks, and the Tata Group. Meet the team →

Published 27 June 2026

Domain expertise

TDS Reconciliation GST Input Credit Platform Settlements NACH Batch Matching Bank Reconciliation Form 26AS Matching ERP Integrations Enterprise Finance Ops

Reviewed by

NK

Navin Krishnan

Managing Director & Founder — Terra Insight

Ex Amazon India · Intuit QuickBooks · Tata nexarc

ISO 27001:2022 Patent Pending Incorporated 2024