Edible Oil FMCG Reconciliation — Refining, Bottling, Distribution

A national edible oil FMCG brand’s controller closes the quarter with two open reconciliation questions on the audit committee agenda. First — the customs duty ledger on 43,000 tonnes of crude palm oil landed at Kandla during the quarter shows a BCD-plus-AIDC outflow that ties within a rupee to the bills of entry; but the reconciliation to the refinery’s inward bulk-oil register shows a 217-tonne shortfall against the discharge quantity, and no one has yet decided whether it is genuine transit loss (within the 0.5% tolerance the refinery historically allows) or a weighment mismatch that a customs audit will chase. Second — the Schedule I stock-transfer invoices from the Kutch refinery GSTIN to the Silvassa bottling GSTIN, at 5% output GST on refined palmolein at a fair-market-value basis, show a ₹18 crore gap between the refinery’s GSTR-1 outward and the bottling plant’s GSTR-2B inward for the trailing three months. The gap ties to nine invoices posted in the wrong HSN — HSN 1511 (palm oil, refined) versus HSN 1512 (sunflower/safflower) — a rate-and-classification error the refinery finance team caught on internal audit but had not yet corrected via GSTR-1 amendment. This is edible oil FMCG reconciliation India at production scale, and the operating shape — with Adani Wilmar’s Fortune franchise and Patanjali Nutrilite as illustrative players — is the standard by which the sub-category’s controllers close the year.

Quick reference

The reconciliation in one paragraph

Edible oil is one of the most reconciliation-intensive FMCG sub-categories in India. Every litre in a Fortune, Nutrilite, Sundrop, Saffola, or Dhara pack travels through five statutorily distinct stages: crude import with a bill of entry at Kandla, JNPT, or Kakinada attracting Basic Customs Duty at 20% and Agriculture Infrastructure and Development Cess at 5%; refining at a licensed plant where crude palm, soybean, or sunflower oil is bleached, deodorised, and fractionated; refinery-to-bottling inter-GSTIN stock transfer that qualifies as a Schedule I deemed supply requiring a tax invoice at fair market value with 5% output GST; a bottling stage that may be captive or contract, with contract bottling triggering Section 393(1) Sl. 4 TDS on the job-work fee; and distributor secondary sales into general trade under a scheme matrix where every scheme requires a Section 15(2) treatment determination. Bolted onto all five stages is the periodic MRP intervention — the government occasionally directs brands to freeze or reduce MRP on notified pack sizes during a defined window, and the trade-margin absorption per batch per location is a reconciliation surface unique to price-sensitive commodity FMCG categories.

What the edible oil FMCG chain actually looks like in India

Consider the operating shape of a national brand at scale. Adani Wilmar’s Fortune franchise runs multiple refineries — the flagship Mundra unit in Kutch, plants at Krishnapatnam and Kakinada on the east coast, and units at Haldia, Bundi, and Mangaluru — each importing crude palm oil or crude soybean oil against a bill of entry at the nearest customs port, refining to standard refined palmolein, refined soybean oil, and refined sunflower oil, and pushing to captive or contract bottling operations for pouch, PET jar, and tin pack finishing under the Fortune, King’s, Bullet, Raag, and Aadhaar sub-brands. Patanjali’s Nutrilite oil franchise runs a comparable footprint through its Ruchi Soya asset base with Nutrilite, Ruchi Gold, and Mahakosh sub-brands. Marico’s Saffola operation, Emami’s Healthy & Tasty, and Bunge’s Dalda occupy similar operating shapes.

The reconciliation surface is denser than a snacks or personal-care category for four reasons. First, the imported crude oil flow is duty-sensitive at both BCD and AIDC layers, and any tariff-heading misclassification between HSN 1511 (palm), HSN 1507 (soybean), HSN 1508 (groundnut), HSN 1512 (sunflower/safflower), or HSN 1514 (mustard/rapeseed) — refined variants versus crude — triggers customs-notice risk. Second, the refinery-to-bottling flow is invariably inter-state (a Kutch refinery pushing to a Silvassa bottling plant is a common shape), and the Schedule I deemed-supply invoice must move end-to-end through GSTR-1 outward, GSTR-2B inward, and GSTR-3B settlement. Third, contract bottling under the brand’s label is standard in the industry to expand capacity without capital; the job-work invoice, TDS deduction, and ITC-04 physical-movement reporting run in parallel. Fourth, edible oil is a price-sensitive commodity where the government can and does intervene on MRP — during 2021 to 2023 the DoCA issued multiple directives asking brands to hold or reduce MRP on notified pack sizes during festive quarters and inflation spikes, and every such directive is a reconciliation event that flows through the FG-in-pipeline register.

The Schedule I overlay — refinery-to-bottling deemed supply

The Schedule I of the CGST Act 2017 treats certain transactions as supply even without consideration. Item 2 of Schedule I specifically covers supply of goods or services between distinct persons in the course or furtherance of business. Distinct persons here means the same PAN with different GSTINs — either separate state registrations of the same legal entity, or separate registrations in the same state for business verticals under Rule 11 of the CGST Rules. When a refinery in Kutch (Gujarat GSTIN) pushes 500 tonnes of refined palmolein per month to the bottling operation in Silvassa (Dadra and Nagar Haveli GSTIN) of the same PAN, the movement is a Schedule I deemed supply.

The mechanics are strict. The refinery must issue a tax invoice on the movement, valued per Rule 28 of the CGST Rules at the open market value of the goods (or at 90% of the price at which the goods are supplied by the recipient to the next unrelated buyer, or at cost plus 10%, depending on which valuation option the brand elects). Output GST at 5% on refined edible oil applies. The bottling GSTIN takes ITC of the same 5% in its GSTR-2B, netting to zero cash impact for the brand at consolidated PAN level — but the reconciliation surface between the refinery’s GSTR-1 outward and the bottling plant’s GSTR-2B inward is real, and any gap surfaces as a Section 15 valuation dispute or a Section 16 ITC availment challenge at year-end. The Section 15(2) CGST trade-discount valuation discipline applies here too — any transfer-price adjustment between refinery and bottling GSTIN must be documented, and mid-year valuation revisions require credit-note or debit-note flows through both GSTINs.

The customs duty overlay — BCD, AIDC, and the tariff-heading question

Crude palm oil at HSN 1511 10 00, crude soybean oil at HSN 1507 10 00, crude sunflower oil at HSN 1512 11 10, and crude mustard oil at HSN 1514 11 10 all attract Basic Customs Duty at 20% on the CIF landed value plus AIDC at 5% on the same base, per the September 2024 tariff revision that widened the refining margin structurally. Refined variants of the same lines attract a materially higher tariff wall — the refining margin is the domestic industry’s operating premium and the reason integrated players build refinery capacity rather than importing refined oil directly.

The reconciliation implication is that the customs duty ledger — bill of entry number, port, HSN, tariff notification reference, CIF value, exchange rate, BCD, AIDC, and Social Welfare Surcharge at 10% on aggregate customs duty — must tie to the shipping bill and the port charge invoices, and cross-foot to the refinery’s inward bulk-oil register weighted at discharge. The 0.5% transit-loss tolerance most brands allow between bill-of-entry quantity and refinery-inward weighment is not a customs tolerance — it is an internal accounting choice — and any excess above the tolerance is either a genuine loss requiring documentary support or a weighment mismatch that a customs audit will chase.

A worked example — Adani Wilmar Fortune palmolein quarter

A national edible oil brand runs a quarter with 43,000 tonnes of crude palm oil landed at Kandla against 27 bills of entry, refined at the Mundra unit to yield approximately 41,500 tonnes of refined palmolein at a 96.5% refining recovery, stock-transferred to bottling operations at Silvassa (60% of volume), Krishnapatnam (25% of volume), and Bundi (15% of volume) as Schedule I deemed supply, and pushed into the distributor network as Fortune Refined Palmolein Oil in 1 litre pouch, 5 litre jar, and 15 kilo tin SKUs.

Illustrative — public disclosures do not reveal internal per-consignment landed cost, refining recovery, or per-SKU secondary sales; the figures here are representative of the operating pattern, not actual brand data. Cross-verify against your own bill-of-entry file, refinery yield register, and DMS export before action.

The quarterly reconciliation pack pulls the following:

Three reconciliation findings surface. First, on the customs side, 8 of the 27 bills of entry show a discharge-weighment shortfall between 0.6% and 0.9% — above the 0.5% internal tolerance — and require documentary support (surveyor report, drainage certificate) before the excess loss can be provisioned. Second, on the Schedule I chain, nine invoices in the middle of the quarter posted under HSN 1512 instead of HSN 1511, causing a ₹18 crore GSTR-1-to-2B classification gap that must be corrected via a GSTR-1 amendment before the annual return cycle. Third, on the distributor scheme side, a growth-over-base rebate scheme launched at quarter-start was booked as Section 15(2) qualifying, but the distributor ITC-reversal acknowledgements are missing on 34 of 218 credit notes — those 34 credit notes are re-classified as financial credit notes that do not reduce GST liability, and a ₹0.8 crore GST re-provision is passed. The TPM accrual versus payout reconciliation for FMCG machinery covers the scheme-accrual pattern in depth.

The MRP overlay — periodic government interventions

Edible oil is one of the few FMCG categories where the central government occasionally issues direct MRP interventions. Under the Legal Metrology (Packaged Commodities) Rules 2011 and periodic Consumer Affairs Ministry advisories, when domestic edible oil prices spike — as they did in 2021 through 2023 during the Ukraine-driven crude palm oil rally and again during a mid-2024 refined edible oil spike — the DoCA can direct brands to hold or reduce MRP on notified pack sizes for a defined window, typically 30 to 90 days.

When the directive lands, the brand’s packaging lines already have pouches, jars, and tins printed at the earlier MRP moving through the pipeline — FG at the plant, in-transit consignments to CFAs, stock at CFA warehouses, stock at super-stockist and distributor points, and shelf inventory at retail. The reconciliation problem is fourfold. First, identify all FG at the old MRP across every location by batch code and pack size. Second, compute the trade-margin absorption per pack size at the revised MRP — the brand’s exit price to the distributor stays the same in most directives, so the trade margin at CFA and distributor levels is the buffer that absorbs the MRP reduction, and the brand may issue a commercial credit note to protect distributor economics. Third, execute the re-stickering discipline under the Packaged Commodities Rules — every pack at the old MRP that continues to sit in the market must be re-stickered with the revised MRP, and the intimation to the Legal Metrology inspector must go out on time. Fourth, reconcile the credit-note flow through GSTR-1 for the down-chain margin protection — this is a Section 34 credit-note cycle and must respect the November-of-following-FY window.

A batch-level MRP register keyed by batch code, SKU, pack size, printed MRP, current MRP, and location is the operational backbone. Without it, the trade-margin absorption is silently absorbed across the distributor network and surfaces only as unexplained margin variance at year-end.

Common reconciliation breakages

Five patterns account for most of the year-end pain in edible oil FMCG reconciliation.

• Bill-of-entry to refinery-inward weighment mismatch beyond the 0.5% transit-loss tolerance without documentary support triggers customs-audit risk on suspected under-declaration; the reconciliation register must carry surveyor reports and drainage certificates for any excess loss.
• HSN misclassification on the Schedule I stock-transfer invoice — posting HSN 1512 (sunflower) when the physical movement is HSN 1511 (palm), or refined-line HSN when the movement is a crude-line intermediate — causes GSTR-1-to-2B gaps that surface at annual return reconciliation and drive Section 73 notices.
• Contract-bottling TDS deducted on gross invoice value instead of the job-work fee only, when the brand supplies the bulk oil as customer-supplied material. The correct base is the job-work component; the customer-supplied oil is not part of the invoice value for Section 393(1) Sl. 4 (194C) deduction.
• Missing distributor ITC-reversal acknowledgements on Section 15(2) post-supply discount credit notes, causing what the brand booked as GST-reducing credit notes to be re-classified as financial credit notes at year-end. See the GST 2.0 FMCG rate rationalisation piece for the September 2025 rate context.
• MRP-directive FG-in-pipeline register not maintained, so when a government directive lands, the brand cannot identify all batches at the old MRP across CFAs and distributors, cannot compute the trade-margin absorption per location, and cannot execute the re-stickering intimation on time.

How a reconciliation platform handles this

A modern reconciliation platform ingests the customs bill-of-entry file, the refinery bulk-oil register, the Schedule I stock-transfer invoice log, the contract-bottling job-work register with TDS deduction detail, the distributor secondary-sales feed from the DMS, and the batch-level MRP register — and produces the end-to-end reconciliation pack described above with drill-down at each stage. The platform’s multi-pass matching engine ties refinery outward to bottling inward at HSN and value level, cross-foots the customs duty ledger to the refinery-inward weighment, classifies each distributor scheme against Section 15(2) treatment logic, and surfaces MRP-directive FG-at-risk across CFA and distributor locations from a single register. Customers reconciling in this category historically report match rates rising from around 51% at go-live to 88% within one to two quarters, freeing controller time from spreadsheet chasing and moving the year-end close from qualified-audit risk to a clean sign-off.

Terra Insight Reconciliation Infrastructure

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

Published 1 July 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