TPM Accrual vs Payout Reconciler

Trade Promotion Management accrual rates for Indian FMCG sit in the 8 to 14 percent of secondary sales band, with the central tendency at 10 to 12 percent. The drivers are category-specific: high-volume / low-margin staples (atta, edible oil, sugar, salt) operate at the lower end (6 to 9 percent) because the manufacturer relies on volume and any further discount erodes contribution; processed foods, beverages, and personal care typically accrue 10 to 12 percent because the trade scheme architecture (slab, quantity, end-of-period, festival) requires room to fund all four; HoReCa, premium personal care, and impulse confectionery push the upper end (13 to 16 percent) because the depth of in-store visibility schemes (cooler placement at Modern Trade, end-cap at quick commerce) requires structural funding. The accrual rate is not the gross trade-spend percentage published in annual reports - that figure (which can run higher, 18 to 22 percent at HUL, ITC FMCG, Nestle India, Britannia, Marico, Dabur, GCPL) blends TPM, ATL spends (broadcast and digital media), BTL (POSM, sampling), and channel margin support. The number you accrue against secondary sales for distributor-claim-driven reconciliation is the TPM subset, and the discipline is to baseline it against the prior 12-month rolling payout-to-sales ratio per state and per channel.

Section 15(2) of the CGST Act governs whether a trade discount sits inside or outside the taxable value of supply. The discount is excluded from taxable value (i.e. GST is charged on the post-discount amount) only if both of two conditions hold: (a) the discount is recorded on the invoice at the time of supply, OR (b) the discount is given by a separately issued credit note that is linked to specific invoices AND was established in terms of an agreement entered into at or before the time of supply AND the recipient (distributor) reverses the input tax credit attributable to that discount. Where the discount is post-supply, agreed only after the original sale, or not traceable to specific invoices, GST stays on the original gross value and the distributor retains full ITC. The operational consequence for FMCG TPM: invoice-recorded slab and quantity discounts pass cleanly under (a); post-period claims for promotion participation, end-of-period rebates, and visibility schemes that are not contractually pre-agreed do NOT qualify under (b) and require either (i) charging GST on the gross supply value with no ITC reversal by the distributor and the manufacturer absorbing the GST on the discount, or (ii) re-engineering the scheme into invoice-recorded discount form. The reconciler flags 'Section 15(2) review' on any claim category where post-supply credit notes exceed 30 percent of total claim volume, because that pattern usually indicates schemes that fail condition (b).

End-to-end settlement of an FMCG distributor TPM claim (claim filed by distributor to bank-credit at distributor) takes 30 to 90 days in disciplined operations, 90 to 180 days in mid-tier operations, and beyond 180 days in operations with manual claim validation and unresolved scheme-eligibility disputes. The internal stages typically split: 5 to 10 days for ASM/RSM scheme-attribution sign-off (was the secondary sales claim line attributable to scheme X?), 10 to 30 days for finance validation (do invoice references match the claim, does the slab volume tally), 7 to 21 days for treasury batch approval, and 5 to 15 days for ERP-to-bank disbursement. Industry research benchmarks place HUL, ITC, and Marico at the disciplined end (often under 60 days), Nestle India and Britannia in the 60 to 90 day band, and the mid-cap basket (regional FMCG, Patanjali, several state-level players) at 90 to 150 days. A 35-day average approval lead time is the operational sweet spot: above 60 days, the ageing tail starts to drag working capital at the distributor, distributor-incentive-claim friction erodes trust, and the next channel survey shows up in the trade margin negotiation. The reconciler surfaces this with an explicit red-flag at the 60-day mark.

A stale claim is a distributor TPM claim that has been open for more than 180 days from the original claim submission date and is unlikely to be settled at face value - either because the underlying scheme period has lapsed beyond the contractually-stipulated claim window, because the supporting invoices and signed POSM proofs cannot be retrieved, or because the scheme eligibility has been disputed and not closed. Under Ind AS 37 (Provisions, Contingent Liabilities and Contingent Assets), where a present obligation exists from a past event (the scheme was run and the distributor performed) and a reliable estimate of the outflow can be made, a provision must be recognised. The standard FMCG policy is a tiered ageing provision: 0 to 90 days at face value (no provision), 91 to 180 days at 25 to 50 percent provision (depending on category and historical settlement ratio), and 180+ days at 100 percent provision either to settle promptly at agreed value or to write off through Ind AS 109 derecognition with audit-trail documentation. The reconciler flags 100 percent provision on any 180+ days bucket because that is the audit-defensible default; finance teams that historically settle 180+ at 60 percent should keep their policy but document the lookback that supports the 40 percent reversal. The 22 September 2025 GST 2.0 rate rationalisation (CBIC Notifications 09 to 16 / 2025-CTR) changed several FMCG HSN-rate mappings - any stale claim straddling that date needs the rate applicable at the original supply date, not the current rate, for both provision and any eventual settlement.

The TPM Accrual vs Payout Reconciler is an accrual-to-actual-cash drift tool: monthly secondary sales drive an accrual at a configured rate, distributor claims received in the month consume that accrual, and the residual builds an open-claim liability that ages through buckets. It is the right tool for the FMCG finance team that owns the trade-spend P&L and needs to surface whether accrual is over or under the realised payout run-rate, whether the open-claim liability is concentrated in stale buckets that need Ind AS 37 provisioning, and whether the 35-day target approval lead time is being met. The Modern Trade Settlement Variance Calculator (sibling tool) is invoice-level: invoice raised against a Modern Trade chain (DMart, Reliance Smart, More, Spencer's, Star Bazaar/Trent, Walmart Best Price, Metro Cash & Carry), payment received, and the gap decomposed into TMS deductions (listing fees, slotting, listing renewals, damaged-goods debits, OTIF penalties, prompt-payment-discount). It is the right tool for the Key Account Manager owning a specific chain receivable and reconciling per-invoice short-pay. Both tools share the same data source (the distributor or chain settlement file plus the manufacturer claim register) and the same downstream operational layer in TransactIG, but they answer different questions at different organisational altitudes: accrual policy at the trade-spend level, vs settlement variance at the chain-invoice level.