Modern Trade Settlement Variance Calculator (Per-Chain Debit Decomposition)

Every Modern Trade chain in India runs its own commercial template, deduction taxonomy, settlement window, and file format. DMart settles on a tight 7-day cycle and offers a prompt-payment discount on EFT-paid invoices (commonly cited at 2 to 3 per cent on the published vendor practice) which is taken at source on the remittance, not as a separate credit note. Reliance Smart and Reliance Retail bulk-PO settlements run a longer 10-day window with BTL marketing claims and visibility-fee adjustments applied centrally. More Retail allows a 14-day GRN tolerance and is known for QC reject and short-receipt debits booked at the DC. Spencer's, Star Bazaar (Trent), Walmart Best Price (cash-and-carry) and Metro Cash & Carry each have their own listing fee, slotting allowance, and shrinkage adjustment patterns. The file format follows the chain's ERP — SAP IS-Retail for DMart, Oracle Retail for Reliance, custom for More — so even when the underlying debit reasons rhyme, the column headers, deduction codes, and amount sign conventions do not match across chains. A brand selling into five Modern Trade chains effectively maintains five reconciliation pipelines.

Public coverage of DMart's vendor practice describes a prompt-payment discount given in exchange for the chain's short 7 to 11 day settlement cycle, paid via EFT. The rate brands cite in trade press and earnings call commentary is in the range of 2 to 3 per cent of invoice value, though the contracted figure is private to each vendor. Treat 3 per cent as a working upper bound for modelling purposes — anything above 4 per cent on a single SKU line should be flagged for review against the master vendor agreement. Two GST nuances apply. First, when the prompt-payment discount is recorded on the original tax invoice (or via a credit note issued under a prior agreement that is known at the time of supply and can be linked to the invoice) it qualifies for exclusion from taxable value under Section 15(3) of the CGST Act and reduces GST. Second, when the discount is a pure financial accommodation applied at settlement without that linkage, it stays inside taxable value and is treated as a settlement deduction. The calculator records the discount as a debit; the brand's GST team confirms which Section 15(3) treatment applies row by row.

BOGO and combo schemes on Modern Trade are funded by the brand against a pre-approved scheme circular issued before the promotion window. The chain prices the consumer offer (buy one get one, two for the price of one, combo at flat rate) at its POS, then claims reimbursement from the brand based on units sold during the scheme period. The brand reconciles three documents: the scheme circular (units committed, rate, period), the chain's claim (units sold per the chain's POS report), and the brand's own depletion at that chain (units invoiced minus units claimed as scheme-funded). Discrepancies cluster in three places: a chain claims for units sold after the scheme period closed, the per-unit reimbursement rate diverges from the circular (often because of mid-period MRP revision), or the claim is for SKUs that were not part of the scheme circular. In this calculator, the BOGO scheme reimbursement claim is entered as a debit (the chain takes it as a deduction from the brand's settlement); the brand records the same number as a marketing expense once the scheme is reconciled. GST treatment follows Section 15(3) for invoice-recorded promotional discount and Section 15(2) where the BOGO is structured as a free supply.

Under Section 34(2) of the CGST Act, the brand (as supplier) issues a credit note when the value of supply is being reduced — for quantity short-receipt, quality reject, post-supply trade discount with prior agreement, and similar reductions. The chain (as recipient) must reverse a corresponding amount of input tax credit only if it had already claimed that ITC on the original invoice. The reverse direction is more common in Modern Trade: the chain raises a debit note (commercial debit note, not a GST debit note) for prompt-payment discount, listing fee, BTL claim, line-fill penalty and shrinkage. Where the debit reduces the original supply value with the brand's prior agreement, the brand issues a Section 34(1) credit note and the chain reverses ITC; the chain's commercial debit note is the trigger but the GST instrument is the brand's credit note. Where the debit is for a fresh supply by the chain back to the brand (slotting allowance, in-store visibility, end-cap display, anniversary spend), the chain issues a tax invoice on the brand for that service supply at 18 per cent GST, the brand claims that as input credit, and there is no ITC reversal on the original FMCG supply. The Section 34 30-November-following-FY deadline applies to the credit note path.

This calculator computes one chain's settlement at a time, by design — each chain has its own debit pattern and the goal is to drive a focused per-chain reconciliation conversation with the KAM, not a portfolio average. Run the calculator once per chain per settlement cycle, capture the variance and the red flags, and feed the seven results (or however many chains you sell into) into a chain-wise tracker. The chain-wise tracker is where the consolidated month-end view lives. At production scale a brand selling FMCG into all seven covered chains will run hundreds of settlement files a month against thousands of invoices, with the per-chain deduction taxonomy normalised so that DMart's prompt-discount and More's GRN-shortage roll up into a comparable brand-level deduction Pareto. That production view is what TransactIG operates inside FMCG finance teams — the calculator above is the single-cycle, single-chain version a KAM can run on a phone before the QBR.