Star Bazaar / Trent FMCG Settlement Reconciliation

A national FMCG controller at Tata Consumer Products opens her Star Bazaar settlement pack for the trailing twelve months ending 31 May 2026. The Tata Sampann portfolio — atta, besan, dal, spice blends, ready-to-cook — has dispatched approximately ₹38 crore of consignments to Trent Hypermarket Private Limited across the Star Bazaar store network during the period, and settlement files have settled approximately ₹34.6 crore net of central scheme reimbursement, BTL allocation, returns, and damage. A ₹3.4 crore gross receivable sits open, and the controller’s question is the same one every FMCG finance leader asks on every modern-trade chain: how much of the open receivable is normal cycle, how much is dispute territory, and how much represents claims the chain has rejected and the brand has not yet provisioned. Layered onto that — because Tata Consumer and Trent are both Tata Sons-controlled entities — every per-SKU line on the Star Bazaar settlement file also has to clear Section 92 / 92BA arms-length-pricing scrutiny under the Income-tax Act 2025, with a Form 3CEB specified-domestic-transaction tagging that the Transfer Pricing Officer will examine on every assessment cycle. This is Star Bazaar Trent FMCG settlement reconciliation, and the discipline that resolves it sits at the intersection of modern-trade settlement variance and intra-group transfer pricing.

Quick reference

What the Star Bazaar settlement actually looks like in India

Star Bazaar is the hypermarket banner operated by Trent Limited’s hypermarket subsidiary, structured under Trent Hypermarket Private Limited (THPL), itself a Tata-group company. The format runs across a network of large-box stores in tier-one and tier-two Indian cities — Hyderabad, Bangalore, Chennai, Pune, Mumbai, Surat, and others — competing with DMart, Reliance Smart, More Retail, and Spencer’s. For FMCG suppliers, Star Bazaar is structured similarly to other organised modern-trade chains, but the settlement carries a few patterns specific to the Trent operating model. The settlement file arrives on a weekly or fortnightly cadence depending on the chain’s commercial agreement with the supplier. For a Tier-1 supplier like Tata Sampann, weekly settlement is the norm. Each file is keyed by the supplier’s PO and dispatch register and decomposes into five streams. The first is gross sales by SKU by store — Trent’s POS data aggregated across the period, with line items for every Tata Sampann SKU sold at every Star Bazaar location. The second is the margin / markdown line — Trent’s contracted margin on the SKU (varying by category — staples typically 18 to 22 percent, packaged foods 22 to 28 percent, premium impulse 28 to 35 percent) deducted from the gross sales. The third is central scheme reimbursement — corporate-level rebates and growth incentives negotiated at the brand-level for the chain, calculated as a percentage of period sales and reimbursed to Trent through a credit-note flow back to the supplier. The fourth is BTL allocation — in-store activations, end-cap displays, retailer-funded sampling, and promoter program costs allocated to participating stores based on the BTL approval log. The fifth is deductions — returns, damage, shortage, and amortised listing-fee adjustments. The supplier reconciles all five streams against its own dispatch register, scheme master, BTL approval log, and credit-note cycle to arrive at the net receivable position per settlement window. The complexity at Star Bazaar scale — 60-plus stores, hundreds of Tata Sampann SKUs, weekly cycles — means that the reconciliation is structurally similar to the DMart FMCG settlement reconciliation and the Reliance Smart (RSL) FMCG settlement flows. What sets Star Bazaar apart in the supplier’s reconciliation universe is what happens when both the chain and the brand sit inside the same corporate group.

The Section 92 / 92BA arms-length overlay — when both ends are Tata

Tata Consumer Products Limited (parent of Tata Sampann) and Trent Limited (parent of THPL / Star Bazaar) are both controlled by Tata Sons Private Limited at the apex of the Tata group. For Indian tax purposes, this makes the two entities associated enterprises under Section 92A of the Income-tax Act 2025 — and any supply of goods or services between them falls under the transfer-pricing perimeter the moment it crosses the materiality threshold for specified domestic transactions. Section 92 lays down the substantive rule: income from a specified domestic transaction between associated enterprises must be computed having regard to arms-length price. The price the supplier charges to the related-party buyer must be benchmarked against what the supplier would have charged — or did charge — in comparable transactions with unrelated parties. For Tata Sampann’s supply to Star Bazaar, the comparable set is the brand’s actual settlement flows with DMart, Reliance Smart, More Retail, and Spencer’s — all non-Tata-group modern-trade chains. The per-SKU price-and-scheme structure must be benchmarked SKU-by-SKU against this comparable set, and the Transfer Pricing Officer expects this benchmarking to be contemporaneous and documented under Section 92D. Section 92BA defines the specified-domestic-transaction perimeter. It captures certain expenditure that would otherwise be allowed as a deduction (including payments to related parties under Section 40A(2)(b)) and transactions referred to in sub-section (2A) of Section 80-IA. The Tata Sampann / Star Bazaar flow falls into this universe when aggregate intra-group transaction value crosses the prescribed threshold for the financial year — historically the Section 92BA threshold sat at ₹20 crore aggregate, and brands at Tata Sampann’s scale will routinely cross it on a single year’s Star Bazaar flow alone. The Section 92BA filing requirement is Form 3CEB, certified by the supplier’s chartered accountant and filed alongside the income tax return. Form 3CEB requires a per-transaction listing of specified domestic transactions, including the methodology used for arms-length determination (Comparable Uncontrolled Price, Resale Price Method, Cost Plus, Profit Split, or Transactional Net Margin). For FMCG settlements, the CUP method on a per-SKU comparable basis is the cleanest defence — but it requires that the supplier’s reconciliation produce a per-SKU price-and-scheme audit trail that survives a Transfer Pricing Officer’s questioning. A net-receivable reconciliation alone does not survive; the per-SKU TP file does. This is the structural difference between a Star Bazaar settlement and a DMart or Reliance Smart settlement for a Tata-group brand. The accounting reconciliation is similar; the regulatory overlay is fundamentally heavier because same-parent transactions do not escape arms-length pricing scrutiny under Section 92 or 92BA.

The GST overlay — Section 15(2) on the central scheme reimbursement

The central scheme reimbursement line on every Star Bazaar settlement file is governed by Section 15(2) of the CGST Act. The three-prong test that runs across every modern-trade scheme structure — covered in detail in our BOGO scheme accounting and Section 15(2) GST and slab discount distributor claim recovery walkthroughs — applies line by line on the Trent settlement. Discounts recorded on the original tax invoice (typically slab discounts printed on the Tata Sampann dispatch invoice line) are excluded from taxable value automatically and require no further Section 15(2) plumbing. Post-supply central scheme reimbursement qualifies for value reduction only if three conditions are met: the scheme was established by agreement at or before time of supply (the master commercial agreement between Tata Sampann and THPL covering the Star Bazaar range, plus the scheme circular issued before the period), the credit note specifically references the invoices it adjusts, and THPL reverses the ITC attributable to the discount amount. Where any prong fails, the scheme amount sits inside the taxable value and the supplier loses the GST relief — typically a 5% loss on rationalised HSNs post-22-September 2025, having dropped from 18% pre-transition. For Tata-group flows, the ITC-reversal acknowledgement is a particular reconciliation challenge. Because both entities are in the same corporate group, the operational discipline of THPL formally acknowledging ITC reversal back to Tata Sampann is sometimes treated as a “we’ll fix it intra-group” item — which it cannot be, because the GST law tests at the legal-entity level, not the corporate-group level. The reconciliation pack must capture the ITC-reversal acknowledgement per credit note before classifying any post-supply scheme as Section 15(2) qualifying. Cross-cluster, this is the same discipline covered in the retro credit note FMCG scheme quarter-end walkthrough.

A worked example — Tata Sampann Star Bazaar settlement, FY 2025-26

A Tata Consumer Products controller pulls the Tata Sampann Star Bazaar reconciliation pack on 30 June 2026 for the trailing twelve months ending 31 May 2026. Tata Sampann’s dispatch register shows approximately ₹38 crore of consignments invoiced to THPL state-GSTINs across the Star Bazaar network over the period. The Star Bazaar settlement files received over the same period total approximately ₹34.6 crore net. Illustrative — Tata Consumer Products’ segment disclosures do not break out Star Bazaar settlement at this granularity; the figures here are representative of the operating pattern, not actual brand data. Cross-verify against your own dispatch register and Trent settlement files before action.

Common reconciliation breakages

Five operational breakages account for the majority of the open-item universe on Star Bazaar settlement reconciliations.

• GSTIN mis-mapping across state entities. Trent Hypermarket Private Limited holds state-wise GSTINs for each state of Star Bazaar operation; Tata Sampann holds state-wise GSTINs across its manufacturing and depot footprint. A Hyderabad Star Bazaar settlement line crediting a Tamil Nadu Tata Sampann GSTIN by accident creates a GSTR-2B mismatch that blocks ITC on Trent’s side and surfaces in the brand’s books as an unreconciled credit. Because both are Tata-group, the mismatch invites internal back-and-forth rather than a clean third-party dispute escalation, and stale intra-group items accumulate.
• Central scheme classification gaps. Schemes settled via credit note without the corresponding ITC-reversal acknowledgement get classified as Section 15(2) qualifying when the actual GST treatment forces a non-qualifying classification. The brand recognises GST relief on the GSTR-1 amendment cycle that is later reversed, with interest implications under Section 50.
• BTL allocation reconciliation gaps. BTL spend on in-store activations is approved per-store per-event by the brand’s commercial team, but the chain’s settlement file allocates BTL across participating stores using a different allocation rule — typically pro-rata to period sales rather than the brand’s per-event approval. The variance creates open BTL items per store that must be reconciled to the brand’s BTL approval log, not just to the settlement file.
• Per-SKU TP benchmarking gaps. The reconciliation pack is built to surface net receivable, not to surface per-SKU price variance against comparable non-group settlements. Without a per-SKU comparable view, the Section 92D contemporaneous documentation is built reactively at TP-study time, and gaps surface during Transfer Pricing Officer questioning rather than during the brand’s own controls.
• Returns and damage variance. Star Bazaar’s central returns processing aggregates damage and shortage claims across stores before crediting back to the brand, which creates a lag between the brand’s own RTV ledger and the settlement-file deductions. Cross-cluster, this pattern is the same as the return-to-vendor RTV damage credit note FMCG and breakage damage FMCG distributor claim flows; the open items that result are routine but must be aged and provisioned correctly. For brands also reconciling modern trade settlement variance across the broader chain network, the Star Bazaar pattern is structurally similar at the operations layer but heavier at the regulatory layer because of the Tata-group transfer-pricing overlay.

How a reconciliation platform handles this

A purpose-built FMCG reconciliation platform parses each Star Bazaar settlement file into its five constituent streams, matches the gross-sales stream to the supplier’s dispatch register at the GSTIN-pair / SKU / store-DC / date level, classifies each central scheme line for Section 15(2) treatment with explicit ITC-reversal acknowledgement capture, tags every per-SKU line with a comparable arms-length benchmark drawn from the supplier’s non-group modern-trade settlements, and surfaces ageing buckets keyed to settlement file date with intra-group items separately flagged for related-party disclosure. The output is a weekly reconciliation pack the FMCG controller can hand to the GST team, the TP team, and the statutory auditor without rebuilding the analysis three times — closing the loop on net receivable, GST credit-note correctness, and Form 3CEB-ready per-SKU TP documentation in a single workflow. Customer outcomes on similar modern-trade reconciliations have moved automated match rates from roughly 51% to 88% on these multi-stream chain settlements, with the residual surfaced as actionable disputes per store and per SKU rather than as a single net-receivable gap.

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