FMCG Reconciliation Software for India: TPM, Modern Trade, Quick Commerce, PLISFPI
Six reconciliation surfaces in one platform for India's PLISFPI beneficiaries and the next-tier mid-market: Trade Promotion Management accrual vs payout, modern-trade settlement (DMart, Reliance Smart, More, Spencer's, Star Bazaar/Trent, Walmart Best Price, Metro), general-trade distributor pyramid (Botree and Bizom DMS vs SAP/Oracle/Tally), quick commerce under Section 52 TCS at the notified 0.5% rate (Blinkit, Zepto, Swiggy Instamart), CGST Section 15(2) trade-discount valuation, and PLISFPI claim filing across the 53 named beneficiaries. India-native by construction — codes, sections and notifications baked into the variance taxonomy, not bolted on.
The densest reconciliation surface in Indian consumer goods
India's FMCG sector is roughly ₹5+ lakh crore, growing about 11% YoY value in Q4 FY25 per NielsenIQ. Rural volume growth (around 8.4%) has outpaced urban (around 2.6%) for multiple consecutive quarters. The sector is dominated by a barbell: mega-cap leaders — HUL, ITC, Nestle India, Britannia, Tata Consumer, Dabur, Marico, Varun Beverages, GCPL, Colgate, P&G, Mondelez, Patanjali Foods, Adani Wilmar, Reckitt — and a deep mid-market of regional and category specialists.
The reconciliation surface is unusually dense because the route to consumer runs through four parallel channels with structurally different settlement, accrual and tax rails: Trade Promotion Management (TPM) drift across general-trade distributor pyramids, modern-trade settlement files with format-per-account variance, quick commerce (Blinkit, Zepto, Instamart) under Section 52 TCS, and the cross-channel CGST Section 15(2) discipline that governs whether trade discount reduces taxable value. The 22 September 2025 GST 2.0 rate rationalisation has consolidated soaps, shampoos, toothpaste, biscuits, chocolates and most metal kitchenware to the 5% slab, creating a GSTR-2B/3B straddle that dominates FY26 reconciliation.
Generic horizontal tools were not built for this. ERPs hold primary sales but not DMS secondary; account reconciliation tools treat scheme accrual as a single GL line; spreadsheets re-key modern-trade settlement files each cycle. TransactIG is built around the six FMCG-specific surfaces — each tied to the relevant section, code or notification — so the variance is named, classified and actioned in one platform.
Six reconciliation surfaces in one platform
Each surface is independently complex. Together, they are the FMCG finance and tax workload. TransactIG handles all six on a single ingest, single variance taxonomy, single audit trail.
Trade Promotion Management (TPM)
TPM accrual reconciliation against actual distributor payout — broken down by BOGO, slab, growth-vs-base, visibility, secondary-display and trade-spend scheme. Ties scheme master, trade-spend ledger, distributor claim register and GST credit-note action together. CGST Section 15(2) treatment applied scheme-by-scheme: invoice-recorded discount reduces taxable value; post-supply discount with prior agreement reduces only if recipient reverses ITC. Audit-defensible variance file per scheme and per distributor.
Modern Trade settlement
Settlement reconciliation against DMart (around 7-day cycle), Reliance Smart / RSL (around 10-day cycle), More Retail (around 14-day cycle), Spencer's, Star Bazaar/Trent, Walmart Best Price and Metro Cash & Carry. Format-per-account variance, BTL marketing offset, listing-fee debit-note discipline, quality-check reject debit, and prompt-payment discount handling. Cross-tied against the supplier's SAP/Oracle/Tally invoice register at SKU and PO level.
General Trade distributor pyramid
Primary sales (ERP) vs secondary sales (Botree, Bizom, FieldAssist DMS) reconciliation across the super-stockist, CFA, sub-stockist and retailer pyramid. The structural secondary-sales gap — where DMS feed lags primary-sales close by 5-15 days and primary returns are re-classified — is closed at the GSTIN and beat level. Section 393(1) Sl. 18 / payment code 1015 distributor-commission TDS at 5% (replacing legacy Section 194H) is classified at the payout level.
Quick Commerce under Section 52 TCS
Settlement reconciliation against Blinkit (Zomato), Zepto, Swiggy Instamart, Tata 1mg and Flipkart Minutes. Section 52 TCS at the notified 0.5% rate (CBIC Notification 15/2024-CT effective 10 July 2024 — 1% is the statutory ceiling, 0.5% is what is actually notified). NOTE: Section 9(5) does NOT apply to FMCG goods (it covers only four notified categories — passenger transport, accommodation, housekeeping and restaurant). TCS deducted is tied to GSTR-8 and electronic-cash-ledger credit at SKU and dark-store level.
Section 15(2) trade-discount valuation
The most-litigated FMCG GST clause. Invoice-recorded discount reduces taxable value if shown on the tax invoice and linked to the supply. Post-supply discount reduces taxable value only if prior agreement is documented at or before supply and the recipient reverses corresponding ITC. TransactIG classifies every trade-discount line by Section 15(2) treatment — eligible, ineligible, conditional — and produces the credit-note-vs-debit-note action GSTIN-by-GSTIN that statutory and tax audit teams can defend.
PLISFPI claim filing
Production-Linked Incentive Scheme for Food Processing — ₹10,900 crore, FY 2021-22 through FY 2026-27 (final eligible year), 53 named beneficiaries (HUL, ITC, Nestle India, Britannia, Tata Consumer, Varun Beverages, Bikaji, Bikanervala, Haldiram Snacks, Haldiram Foods International, Balaji Wafers, Anmol Industries, GCMMF/Amul, Parag Milk, Keventer Agro, Dabur and others). Claim mechanic is incremental sales over base-year FY 2019-20 evidenced by audited financials, GSTIN-level sales, branding-spend audit and product-category mapping. Claim filing within 7 months of FY-end.
Coverage across the FMCG operator landscape
The Production-Linked Incentive Scheme for Food Processing (PLISFPI) names 53 beneficiaries across four eligible segments — ready-to-eat / ready-to-cook, processed fruits and vegetables, marine products, and mozzarella cheese. The Ministry of Food Processing Industries (MoFPI) administers the ₹10,900 crore commitment running FY 2021-22 through FY 2026-27 (final eligible year). TransactIG's FMCG coverage is built around these tiers and the next-tier regional mid-market that aspires to qualify under successor schemes.
| Tier | Representative names | Coverage focus |
|---|---|---|
| Tier 1 — Large category | HUL, ITC, Nestle India, Tata Consumer, Britannia | Multi-category portfolios across the 5%, 12% and 18% slabs with the September 22 2025 rate-rationalisation straddle, complex TPM across 200+ live schemes per quarter, RSL/DMart/More format coverage |
| Tier 1 — Beverages and snacking | Varun Beverages, Bikaji, Bikanervala, Haldiram Snacks, Haldiram Foods International, Balaji Wafers, Anmol Industries | PLISFPI claim build across ready-to-eat / ready-to-cook segment, depot-level secondary sales reconciliation, quick-commerce dark-store SKU-level settlement |
| Tier 1 — Dairy | GCMMF/Amul, Parag Milk, Keventer Agro | Federation/cooperative accounting, sachet-vs-tetrapak SKU classification, modern trade chilled-chain settlement |
| Tier 1 — Personal care and HPC | GCPL, Dabur, Marico, Colgate, Reckitt | September 22 2025 GST 2.0 5% slab consolidation for soaps/shampoos/toothpaste, MR/SR field-force settlement reconciliation |
| Mid-market regional | Regional players in oils, ghee, masala, beverages, snacking | PLISFPI eligibility analysis, distributor pyramid scaling from single-state to multi-state, scheme accrual discipline at lower cadence |
Brand names are referenced as published PLISFPI beneficiaries per MoFPI's scheme guidelines. TransactIG coverage applies whether or not a given company has engaged Terra Insight; named brands do not imply a commercial relationship.
GST 2.0 rate rationalisation and the September 2025 GSTR-2B/3B straddle
CBIC Notifications 09-16/2025-CTR effective 22 September 2025 consolidated soaps, shampoos, toothpaste, biscuits, chocolates and most metal kitchenware to the 5% slab. The economic story is well-known; the reconciliation story is harder. The September 2025 GSTR-2B and GSTR-3B return periods straddle the cut-over: pre-22 invoices carry the prior 12% or 18% rate, post-22 invoices carry the new 5% rate, and the same HSN can appear at two different rates in one return.
The dominant audit finding in FY26 closes is supplier invoices that crossed the 22 September 2025 boundary with the wrong rate — a 12% invoice dated 23 September against an HSN that moved to 5%, a 5% invoice dated 21 September against an HSN that was still at 12% on that day, or a credit note dated post-22 against an invoice dated pre-22 where the rate-bridge logic is not documented. TransactIG splits the September 2025 period internally at the boundary, ties ITC at each rate to the correct procurement window, flags boundary-crossing supplier invoices automatically, and produces the rate-bridge evidence statutory auditors and GST officers ask for — consistent with the working-paper discipline the Institute of Chartered Accountants of India (ICAI) expects on rate-transition audits.
The September 2025 straddle is a one-time event; the discipline it forces — per-HSN rate-window classification, per-invoice rate-validity validation, and credit-note-rate alignment with the original invoice — is permanent infrastructure for any FMCG supplier with HSNs subject to future rate notifications.
Spreadsheet vs ERP-bundled vs TransactIG for FMCG
How each of the six FMCG reconciliation surfaces is handled by spreadsheet workflows, by ERP-bundled receivables/accrual modules, and by TransactIG's India-native variance taxonomy.
| Dimension | Spreadsheet | Generic ERP-bundled | TransactIG |
|---|---|---|---|
| TPM accrual vs distributor payout | Tracked in Excel scheme registers; quarterly variance of 5-15% common; CGST Section 15(2) treatment applied manually | Generic accrual GL in SAP/Oracle without scheme-level decomposition; no link to GST credit-note action | Per-scheme accrued vs paid variance with Section 15(2) classification (invoice-recorded vs post-supply with ITC reversal) and credit-note-vs-debit-note action per distributor GSTIN |
| Modern trade settlement | Per-account spreadsheets re-keyed monthly; BTL/QC reject debits absorbed without action; format change breaks workflow | ERP receivables module; format-per-account variance is the spreadsheet team's problem, not the ERP's | Native DMart / RSL / More / Spencer's / Star Bazaar format ingestion; SKU and PO-level tie; BTL and QC reject debits actioned with evidence file |
| General Trade DMS vs ERP | Secondary sales close in a separate report cycle; primary-vs-secondary gap aggregated, not closed beat-by-beat | ERP holds primary; Botree/Bizom DMS holds secondary; reconciliation is project work each month-end | Botree/Bizom/FieldAssist native ingestion; secondary-sales gap closed at GSTIN and beat level; Section 393(1) Sl. 18 / code 1015 commission TDS at 5% classified at payout level |
| Quick commerce Section 52 TCS | ECO settlement files downloaded per dark-store; TCS reconciliation done quarterly against GSTR-8 | ERP receivables module records the gross sale; TCS deduction tracked outside; Section 9(5) vs Section 52 classification often confused | Native Blinkit / Zepto / Instamart ECO file ingestion; Section 52 at 0.5% notified TCS tied to GSTR-8 and electronic cash ledger; Section 9(5) NOT applied (correctly — it covers only the four notified categories) |
| Section 15(2) trade-discount valuation | Manual scheme-by-scheme classification; prior agreement evidence stored in distributor master, not linked to TPM file | ERP credit-note module without GST classification of taxable-value reduction vs financial discount | Each trade-discount line tagged invoice-recorded vs post-supply; prior agreement linked from distributor master; recipient ITC reversal tracked; statutory audit defence pack produced |
| PLISFPI claim build | Spreadsheet-only build by tax team; CA certification reconciles with audited financials at quarter close | ERP holds period sales; base-year comparison and category mapping done outside; CA team rebuilds each year | Claim-period sales by GSTIN and product category tied to base-year FY 2019-20 with variance vs ERP and GSTR-1; branding-spend audit pack produced for CA certification within the 7-month post-FY filing window |
A national HPC supplier closing September 2025
A national HPC supplier of soaps, shampoos and toothpaste — pick any of the named operators (HUL, GCPL, Dabur, Colgate) for context — closing September 2025 sees three concurrent issues: (1) the 22 September 2025 GST 2.0 cut-over splits its HSN ranges to 5% mid-month; (2) Q2 FY26 TPM accrual is due quarter-end with around 180 live schemes across general trade and modern trade; (3) quick-commerce settlement files from Blinkit, Zepto and Instamart for the cut-over fortnight carry mixed rates that must be tied to Section 52 TCS at the notified 0.5%.
TransactIG splits the September period at 22 September 2025, classifies each invoice by the rate notified on its date of supply, flags supplier invoices that crossed the boundary with a stale rate (the dominant September close issue), ties scheme accrual against actual distributor payout broken by BOGO/slab/growth-vs-base, and reconciles quick-commerce settlement at SKU and dark-store level against Section 52 TCS at the 0.5% notified rate. The output for statutory audit is a single per-surface evidence file, not three separate spreadsheet workstreams.
Illustrative. Figures and scenario shown for explanatory purposes only; do not infer disclosed brand performance, contractual terms or operational metrics of any named company. Named operators are referenced as public-market examples of the segment.
Estimate your TPM accrual-vs-payout drift right here
Plug in your monthly secondary sales and trade-spend accrual rate; the reconciler surfaces ageing buckets, stale-claim provision, and Section 15(2) discount-treatment flags. Runs in your browser — no data leaves your device.
Accrual inputs
Open-claim exposure (Cr)
Ageing buckets · provision recommendation
Open-claim exposure is allocated across the five ageing buckets using a default mix derived from the disciplined-operations baseline (HUL, ITC, Marico, Nestle India). Stale-claim exposure (180+ days) takes 100 percent provision under Ind AS 37 by default. Adjust the bucket shares if your prior-period ageing snapshot is materially different.
| Bucket | Share % | Exposure | Provision % | Provision (Cr) | Note |
|---|---|---|---|---|---|
| 0 - 30 days | % | ₹0.00 Cr | 0% | ₹0.00 Cr | Current. Face value. |
| 31 - 60 days | % | ₹0.00 Cr | 0% | ₹0.00 Cr | Within target lead time. Face value. |
| 61 - 90 days | % | ₹0.00 Cr | 10% | ₹0.00 Cr | Approval-cycle red flag. Light provision. |
| 91 - 180 days | % | ₹0.00 Cr | 50% | ₹0.00 Cr | Ind AS 37 partial provision. Investigate. |
| 180+ days (stale) | % | ₹0.00 Cr | 100% | ₹0.00 Cr | Full provision. Settle promptly or write off. |
| Total | 0% | ₹0.00 Cr | ₹0.00 Cr |
Operational flags
Audit a Modern Trade settlement right here
Pick the chain (DMart 7-day, Reliance Smart 10-day, More 14-day, or custom), drop in your gross invoice and the standard debit pattern, and the calculator surfaces net settlement variance and 4 red flags. Runs in your browser — no data leaves your device.
Modern Trade settlement inputs
DMart settles on a 7-day cycle and takes a prompt-payment discount at source.
Tax-invoice value as raised on the chain (taxable + GST).
Default 3 per cent for DMart; 0 per cent for other chains. Section 15(3) treatment depends on prior agreement.
Chain claim against a pre-approved scheme circular. Reconcile units claimed vs units in circular.
Visibility fee, anniversary spend, end-cap, brand-day participation. Validate against agreed BTL budget.
Slotting allowance per SKU per store cluster. Above 25 per cent of invoice is flagged.
DC-level quality rejects. Requires Section 34 credit note if original supply value is being reduced.
GRN-vs-invoice short-receipt %.
Price drift per unit at receipt.
FMCG reconciliation resources
The FMCG cluster hub, three FMCG-specific interactive tools, Wave 1 cornerstone articles, and the cross-cluster guides that meet at the FMCG operating problem.
Frequently Asked Questions
What does FMCG reconciliation software for India actually reconcile? +
An FMCG reconciliation platform built for India ties together six surfaces that no horizontal accounting tool covers natively: (1) Trade Promotion Management — quarterly TPM accrual against actual distributor payout, broken down by BOGO, slab, growth-vs-base and trade-spend scheme; (2) modern trade settlement against DMart (around 7-day cycle), Reliance Smart (around 10-day cycle), More (around 14-day cycle), Spencer's, Star Bazaar/Trent, Walmart Best Price and Metro Cash & Carry; (3) general trade primary sales (ERP) vs secondary sales (Botree/Bizom DMS) across the super-stockist/CFA/sub-stockist/retailer pyramid; (4) quick commerce settlement files from Blinkit, Zepto and Swiggy Instamart under the Section 52 TCS regime at the notified 0.5% rate; (5) CGST Section 15(2) trade-discount valuation across invoice-recorded and post-supply discount; and (6) PLISFPI claim filing across the 53 named beneficiaries against base-year FY 2019-20 incremental sales. TransactIG ingests each surface in its native format and ties variances to the relevant section, code or notification.
How is TPM accrual reconciliation different from generic accruals work? +
TPM accrual is the largest balance-sheet item below revenue for most Indian FMCG companies and the most-litigated under CGST Section 15(2). The reconciliation problem is structural: trade-marketing teams accrue scheme spend at the period end based on offer mechanics (BOGO, slab, growth-vs-base, visibility, secondary-display), distributor claim cycles run on calendar dates that rarely line up with the accrual close, and post-supply discount under Section 15(2) reduces taxable value only when prior agreement is documented and the recipient reverses ITC. TransactIG ties scheme master, trade-spend ledger, claim register and GST credit-note action together so finance can see, per scheme and per distributor, the accrued amount, the paid amount, the post-supply discount eligible for valuation reduction, and the credit-note-vs-debit-note action GSTIN-by-GSTIN. Statutory and tax audit evidence is produced as a single per-scheme variance file.
How does TransactIG handle the September 22 2025 GST 2.0 rate rationalisation? +
CBIC Notifications 09-16/2025-CTR effective 22 September 2025 consolidated soaps, shampoos, toothpaste, biscuits, chocolates and most metal kitchenware to the 5% slab. This created a straddle inside the September 2025 GSTR-2B and GSTR-3B: pre-22 invoices carry the prior 12% or 18% rate, post-22 invoices carry the new 5% rate, and the same HSN can appear at two different rates in one return period. TransactIG splits the period internally at the 22 September 2025 boundary, ties ITC at each rate to the correct procurement window, flags supplier invoices that crossed the boundary with the wrong rate (the dominant reconciliation issue in the September 2025 return), and produces the rate-bridge evidence statutory auditors and GST officers ask for during FY26 audit.
Why is Section 9(5) of CGST not the right rail for FMCG goods on quick commerce? +
Section 9(5) of the CGST Act covers only four notified categories: passenger transport, accommodation services, housekeeping services and restaurant services. FMCG goods sold through Blinkit, Zepto or Swiggy Instamart do NOT fall under Section 9(5). The applicable rail is Section 52 (Tax Collected at Source), where the e-commerce operator collects TCS at the notified rate of 0.5% (CBIC Notification 15/2024-CT effective 10 July 2024 — 1% is the statutory ceiling, 0.5% is what is actually notified). TransactIG reconciles the quick-commerce ECO settlement file at SKU and dark-store level against the supplier's ERP sales register, ties TCS deducted to GSTR-8 filed by the operator and to the electronic cash ledger credit visible to the supplier, and produces the audit trail that confirms Section 52 (not Section 9(5)) treatment.
Who claims PLISFPI and how does reconciliation evidence figure in the claim? +
PLISFPI is a ₹10,900 crore Production-Linked Incentive scheme for food processing run by MoFPI, spanning FY 2021-22 through FY 2026-27 as the final eligible year. It has 53 named beneficiaries across four segments — ready-to-eat / ready-to-cook, processed fruits and vegetables, marine products and mozzarella cheese — including HUL, ITC, Nestle India, Britannia, Tata Consumer, Varun Beverages, Bikaji, Bikanervala, Haldiram Snacks, Haldiram Foods International, Balaji Wafers, Anmol Industries, GCMMF/Amul, Parag Milk, Keventer Agro and Dabur. The claim mechanic is incremental sales over base-year FY 2019-20 (with adjusted growth thresholds documented in the scheme guidelines), evidenced by audited financials, GSTIN-level sales evidence, branding spend audit and product-category mapping. Claim filing typically happens within 7 months of FY-end. TransactIG ties claim-period sales by GSTIN, by product category and against base year, surfaces variances between ERP, GSTR-1 and the claim file, and produces the audit pack the chartered-accountant-certified claim requires.
Stop carrying TPM, modern trade and quick-commerce variance as quarterly noise
TransactIG ingests your SAP, Oracle or Tally primary sales; Botree, Bizom or FieldAssist DMS secondary sales; modern-trade settlement files; quick-commerce ECO settlement files; GSTR-2B downloads and bank statements in their native formats. Six FMCG reconciliation surfaces, one variance taxonomy, one audit pack. ISO 27001:2022 certified.