Ductile Iron Pipes DIP Manufacturing Reconciliation India (Jindal SAW + Electrosteel + Srikalahasti)

An Indian ductile iron pipes (DIP) manufacturer operating a large-capacity DIP production plant (illustrative persona: a 320,000 tonnes per annum DIP plant at Kosi Kalan in Uttar Pradesh, or a 400,000 tonnes per annum DIP plant at Rajgangpur in Odisha, or a 300,000 tonnes per annum DIP plant near Tirupati in Andhra Pradesh) supplying the Jal Jeevan Mission (JJM) and AMRUT (Atal Mission for Rejuvenation and Urban Transformation) government water pipeline programmes through L1 EPC contractors — large infrastructure EPC companies such as L&T Construction, NCC Limited or Ashoka Buildcon — carries an order-book cost accounting stack tying per-tonne DIP dispatch to five separate compliance and accounting surfaces every month. Section 194Q of the Income-tax Act 1961 buyer-side TDS at 0.1 percent above the fifty lakh rupees aggregate per previous year applies to every L1 EPC contractor customer. GST at 18 percent under HSN 7307 21 applies to every pipe supply invoice under IS 8329 and ASTM A536 specifications. Bank guarantee at 5 to 10 percent of contract value plus 10 percent performance guarantee is provided by the DIP manufacturer to the L1 EPC contractor beneficiary. Retention money receivable at 5 to 10 percent of contract value released after the defect liability period is variable consideration under Ind AS 115, a financial asset under Ind AS 32 and subject to expected credit loss measurement under Ind AS 109. The reconciliation discipline that stitches order book by JJM and AMRUT category, Section 194Q per L1 contractor, bank guarantee register, retention money receivables ageing and the Ind AS 115 variable consideration position together is the subject of this ductile iron pipes DIP manufacturing Jindal SAW Electrosteel reconciliation walkthrough.

Quick reference

The reconciliation in one paragraph

An Indian DIP manufacturer supplying JJM and AMRUT government water pipeline projects through L1 EPC contractors must capture every rupee of the order book against the per-contract-per-month DIP supply compliance ledger keyed on the contract number and the L1 EPC contractor buyer. The core reconciliation surface holds the pipe supply invoice register at 18 percent GST under HSN 7307 21 reconciled to GSTR-1 outward supply and GSTR-3B liability, the per-L1-EPC-contractor Section 194Q TDS reconciliation matching TDS deducted per the L1 EPC contractor’s payment advice against the DIP manufacturer’s 26AS annual tax credit statement, the bank guarantee register with outstanding bank guarantee quantum per contract plus cumulative bank commission accrued and paid, the retention money receivable ageing per contract with defect liability period start date and expected release date, the Ind AS 115 variable consideration schedule for the retention money component of transaction price, and the Ind AS 109 expected credit loss measurement on the retention receivable balance. Order-book classification by JJM works contract, AMRUT works contract, Smart Cities, private industrial and export category preserves the per-category revenue and gross margin position through the plant profit and loss. Every material deviation between invoice-to-collection, computed-TDS-to-26AS-credit, outstanding-BG-to-contract-value or retention-receivable-to-variable-consideration is flagged as a month-end break for the plant CFO and the commercial head, with escalation to the statutory auditor where the deviation crosses the materiality threshold.

What the scenario looks like in India — a Kosi Kalan DIP plant persona

The illustrative persona for this walkthrough is a large Indian DIP manufacturer operating a 320,000 tonnes per annum DIP plant at Kosi Kalan in Uttar Pradesh, feeding a JJM and AMRUT order book across Uttar Pradesh, Bihar, Madhya Pradesh, Rajasthan, Haryana and the National Capital Region for water transmission and distribution pipeline supply. The plant runs centrifugal casting lines for DN 80 to DN 1200 diameter DIP with PN 10 to PN 40 pressure class certifications under IS 8329 and ASTM A536, produces the full complement of pipe fittings and specials (bends, tees, tapers, flanges), applies the standard zinc metallisation external coating with bitumen or polyurethane top coat and cement mortar internal lining, and dispatches pipe consignments direct to project sites across the L1 EPC contractor customer footprint.

Illustrative Indian DIP manufacturers running the same JJM and AMRUT government-water-pipeline order-book compliance stack include Jindal SAW (with DIP plants at Kosi Kalan in Uttar Pradesh, Nashik in Maharashtra and Mundra in Gujarat), Electrosteel Steels (under Vedanta group, with DIP plants at Rajgangpur in Odisha and Khardah in West Bengal), Srikalahasti Pipes (Andhra Pradesh with a DIP plant near Tirupati), Welspun Corp (with DIP capability alongside its steel pipes and line pipes portfolio) and Ratnamani Metals and Tubes. Every one of these manufacturers has run DIP supply into JJM and AMRUT works contracts through L1 EPC contractor buyers for the last several years, and the accounting discipline documented here is the standing month-end close mechanic for any DIP manufacturer operating the government water pipeline supply franchise. The parallel export leg to Africa (Nigeria, Ghana, Kenya, Egypt), Southeast Asia and the Middle East for water pipeline projects sponsored by African Development Bank, Asian Development Bank, World Bank and Islamic Development Bank runs on a similar contract-and-retention mechanic with foreign exchange exposure added.

The regulatory overlay — Section 194Q, HSN 7307 21 GST, Ind AS 115, Ind AS 32 and Ind AS 109

Five regulatory anchors govern an Indian DIP manufacturer’s JJM and AMRUT government-water-pipeline order-book cost accounting. Section 194Q of the Income-tax Act 1961 anchors the buyer-side TDS mechanic on the L1 EPC contractor’s pipe purchase from the DIP manufacturer. CGST Act 2017 read with the GST Rate Notification anchors the 18 percent GST on HSN 7307 21 pipe supply. Ind AS 115 anchors the retention money treatment as variable consideration in the transaction price. Ind AS 32 anchors the classification of the retention receivable as a financial asset and the bank guarantee cash margin as a restricted financial asset. Ind AS 109 anchors the expected credit loss measurement on the retention receivable. Ind AS 37 anchors the contingent liability disclosure of the outstanding bank guarantee at the DIP manufacturer level.

Section 194Q of the Income-tax Act 1961 (introduced by Finance Act 2021, effective 1 July 2021) requires any buyer of goods to deduct tax at source at 0.1 percent of the sum exceeding fifty lakh rupees paid to a resident seller in a previous year. When an L1 EPC contractor such as L&T Construction, NCC Limited or Ashoka Buildcon procures ductile iron pipes from a DIP manufacturer for JJM or AMRUT supply, the L1 EPC contractor is the buyer and the DIP manufacturer is the resident seller. Once the aggregate purchase from that DIP manufacturer in a previous year crosses the fifty lakh rupees threshold, every subsequent pipe supply invoice attracts the 0.1 percent buyer-side TDS. The L1 EPC contractor deposits the TDS by the seventh of the following month, files the Section 194Q TDS return quarterly and issues the TDS certificate. The DIP manufacturer holds the 26AS annual tax credit statement to reconcile the aggregate TDS deducted by every L1 EPC contractor customer and claims the credit against its own tax liability. Section 194C on works contract payment by the government to the L1 EPC contractor is a separate downstream event that does not touch the DIP manufacturer — the pipe supply is a purchase-of-goods transaction, not a works contract. The Section 194Q on iron ore purchase and mining lease payments for a steel plant sibling walkthrough covers the parallel Section 194Q mechanic on the raw material input side, and the TDS payment code 1031 Section 393 SL 8 purchase-of-goods India walkthrough documents the Section 194Q payment code and reporting mechanic.

The CGST Act 2017 read with the GST Rate Schedule notification imposes GST at 18 percent on tube or pipe fittings of iron or steel falling under HSN 7307 21 including ductile iron pipes. The DIP manufacturer raises a GST tax invoice under Rule 46 of the CGST Rules 2017 at 18 percent IGST (inter-State supply) or 18 percent CGST plus SGST equivalent (intra-State supply); the L1 EPC contractor claims Section 16 input tax credit against the tax invoice subject to GSTR-2B match with the DIP manufacturer’s GSTR-1 outward supply return. On the downstream government project execution side, the L1 EPC contractor’s outward supply to the State Jal Nigam under the works contract attracts GST at either 12 percent (works contract of civil construction nature to Government) or 18 percent depending on the specific work item classification.

Ind AS 115 Revenue from Contracts with Customers (Companies (Indian Accounting Standards) Amendment Rules 2018) governs the recognition of revenue. Paragraphs 47 to 54 address the transaction price. Paragraph 50 defines variable consideration — the transaction price may include an amount subject to a variable element such as a rebate, refund, credit, price concession, incentive, performance bonus, penalty or other similar item. Retention money in an infrastructure supply contract is variable consideration; the DIP manufacturer estimates the retention money receivable at contract inception, applies the constraint under paragraph 56 for the amount for which it is highly probable that a significant reversal in cumulative revenue will not occur, and recognises revenue accordingly. The retention receivable is a financial asset under Ind AS 32 and subject to expected credit loss under Ind AS 109 at each reporting date — 12-month expected credit loss for retention receivables released within the normal defect liability cycle, lifetime expected credit loss where a significant increase in credit risk has occurred.

A worked example — Kosi Kalan DIP plant FY 2026-27 annual order-book close

Illustrative — the following figures represent the operating pattern of an Indian DIP manufacturer operating a 320,000 tonnes per annum DIP plant at Kosi Kalan in Uttar Pradesh. Public disclosures by listed Indian DIP majors do not reveal per-contract per-project bank guarantee and retention money quantum in the granularity below; cross-verify against the current Income-tax Act 1961 Section 194Q provisions, the current GST Rate Notification for HSN 7307 21, the current Ind AS 115 and Ind AS 109 standards and your own contract master before action. The Rs 90,000 per tonne pipe realisation used below is an illustrative reference point for a mixed DIP diameter and pressure class order-book and does not represent the actual current market price for any specific pipe class or delivery period.

The Kosi Kalan DIP plant closes its FY 2026-27 order book at 320,000 tonnes of DIP production dispatched across four customer categories:

On the Section 194Q dimension, the L&T Construction Delhi and NCC Limited Hyderabad JJM order book together — Rs 3,240 crore — sits well above the fifty lakh rupees aggregate threshold per previous year per L1 EPC contractor. Both L1 EPC contractor customers deduct Section 194Q 0.1 percent buyer-side TDS on every DIP supply invoice from the DIP manufacturer once the previous-year aggregate crosses the threshold. The illustrative aggregate Section 194Q TDS deducted by the two L1 EPC contractors together for the year is 0.1 percent of the Rs 3,240 crore-and-above pipe supply (net of the fifty lakh rupees threshold consumed once per L1 EPC contractor per previous year) — the DIP manufacturer holds the 26AS annual tax credit statement to reconcile the TDS deducted by both L1 EPC contractors to its own books and claims the credit against its own tax liability for the assessment year. The AMRUT L1 (State-level PSU) and private industrial customers each contribute independently to the DIP manufacturer’s Section 194Q reconciliation surface. The export leg (approximately Rs 720 crore) is outside Section 194Q — the foreign buyer is not a resident buyer under the Income-tax Act 1961 and Section 194Q does not apply to export sales.

On the bank guarantee dimension, the JJM plus AMRUT domestic government-project pipe supply of Rs 3,240 crore plus Rs 1,080 crore = Rs 4,320 crore attracts bank guarantee at 5 percent of contract value as security deposit — Rs 216 crore of bank guarantee outstanding at the DIP manufacturer level in favour of the L1 EPC contractor beneficiaries. Adding the performance guarantee at 10 percent takes the total outstanding bank guarantee position to approximately Rs 648 crore. The bank commission at an illustrative 1 percent per annum on the outstanding bank guarantee quantum is Rs 6.48 crore per annum charged to the profit and loss account as a period expense. Where the DIP manufacturer’s banker requires cash margin (illustrative 25 percent cash margin), Rs 162 crore of the manufacturer’s cash sits as restricted cash under Ind AS 32 in the notes to the financial statements as bank margin deposit.

On the retention money dimension, the JJM plus AMRUT domestic supply of Rs 4,320 crore attracts retention money at 5 to 10 percent — illustrative Rs 216 crore to Rs 432 crore of retention money receivable outstanding across the contract portfolio at any point in time, released after the defect liability period completes (typically 12 to 24 months post-commissioning of each pipeline package). The DIP manufacturer holds an Ind AS 115 variable consideration schedule per contract with the retention money receivable estimated at contract inception, the constraint under paragraph 56 applied, and cumulative revenue recognised. The Ind AS 109 expected credit loss on the retention receivable is measured at each reporting date — 12-month expected credit loss (illustrative 0.5 to 1.5 percent of the retention receivable balance) for retention within the normal defect liability cycle, and lifetime expected credit loss where a significant increase in credit risk has been identified. The illustrative expected credit loss charge for the year is Rs 3 to Rs 8 crore flowing through the profit and loss account and reducing the carrying value of the retention receivable.

Common reconciliation breakages

Five breakages recur across Indian DIP manufacturers running the JJM and AMRUT government-water-pipeline order-book compliance stack.

• Order-book classification incorrectly tagged as works contract (Section 194C) instead of pipe supply (Section 194Q) at capture stage, cascading into a wrong TDS reconciliation. The distinction between a pipe supply transaction (Section 194Q on the L1 EPC contractor buyer at 0.1 percent) and a works contract transaction (Section 194C at 2 percent) is regulatory-hard-wired. A capture-stage misclassification (an order-book entry tagged as works contract when the DIP manufacturer is in fact only supplying pipes to an L1 EPC contractor) produces a wrong TDS expectation on both sides — the DIP manufacturer expects 2 percent TDS from the L1 EPC contractor customer but only 0.1 percent Section 194Q is actually deducted, producing a 26AS reconciliation gap. Reconciliation discipline: the contract master holds an explicit transaction-type tag (pipe-supply-to-L1-EPC-contractor for Section 194Q, works-contract-to-government for Section 194C — the latter not applicable to a DIP manufacturer) at contract capture stage, and the applicable TDS section reference is a master-driven read against the transaction-type flag.

• Section 194Q fifty lakh rupees threshold consumption not tracked per L1 EPC contractor per previous year, producing incorrect first-invoice TDS treatment. Section 194Q applies at 0.1 percent on the sum exceeding fifty lakh rupees aggregate per L1 EPC contractor per previous year. A DIP manufacturer that does not track the L1 EPC contractor’s cumulative previous-year purchase from itself against the fifty lakh rupees threshold cannot advise the L1 EPC contractor accurately on when the threshold crosses and TDS deduction begins — the L1 EPC contractor either deducts Section 194Q too early (on invoice before the threshold crosses) or too late (missing the first threshold-crossing invoice). Reconciliation discipline: the contract master holds the L1 EPC contractor’s cumulative previous-year aggregate purchase from the DIP manufacturer as a running counter, resets on 1 April each year, and produces a Section 194Q applicability flag on every new invoice raised.

• Bank guarantee register incomplete — outstanding BG quantum understated, cumulative bank commission not accrued, or expired BG not returned to bank. The bank guarantee register at the DIP manufacturer level must hold a per-contract bank guarantee record with issuance date, expiry date, contract number, L1 EPC contractor beneficiary, bank issuing branch, guarantee amount, cash margin or non-fund-based limit utilisation tag, bank commission accrual and cumulative bank commission paid. A register that misses one or more BGs (a manually issued BG at a smaller branch not entered into the central register), that fails to accrue the monthly bank commission expense, or that fails to trigger BG return-to-bank on contract closure or on defect liability period completion produces an incorrect Ind AS 37 contingent liability disclosure and continuing bank commission cost drag. Reconciliation discipline: monthly reconciliation of the bank guarantee register to the banker’s BG portfolio statement, with any gap flagged for the treasury team investigation and correction.

• Retention money receivable ageing stale — Ind AS 115 variable consideration constraint not refreshed and Ind AS 109 expected credit loss under-measured. The retention money receivable ageing must be refreshed at each reporting date with the contractual defect liability period start date, expected release date, actual release status per contract, and any Ind AS 109 significant-increase-in-credit-risk trigger. A stale ageing (retention receivable ledger not updated for actual release events, or defect liability period expiry dates not tracked) produces an incorrect Ind AS 115 variable consideration constraint position — cumulative revenue recognised may need reversal, or previously constrained retention may need release into revenue. The Ind AS 109 expected credit loss on retention receivables where the L1 EPC contractor’s own government-project payment cycle has deteriorated needs to move to lifetime expected credit loss with the incremental provision through the profit and loss account. Reconciliation discipline: the retention money receivable ledger is refreshed monthly per contract with the ageing bucket, the defect liability period expiry date and the Ind AS 109 credit risk trigger (any L1 EPC contractor customer with a delay in retention release beyond the contractual defect liability period is flagged for lifetime expected credit loss measurement). The reconciliation failure mode analysis design pillar frames the accounting-treatment-master-driven-computation discipline that surfaces this class of failure at the computation stage.

• GSTR-1 outward supply on HSN 7307 21 not fully reconciled to the pipe supply invoice register and to the buyer’s GSTR-2B input tax credit availability. The DIP manufacturer’s GSTR-1 outward supply return at 18 percent GST under HSN 7307 21 must reconcile line-by-line to the internal pipe supply invoice register and to the L1 EPC contractor buyer’s GSTR-2B input tax credit availability. A gap between GSTR-1 filed and the pipe supply invoice register (invoices issued but missed in the GSTR-1 filing, or invoices in the register with a wrong HSN or wrong GST rate) produces a downstream GSTR-3B liability short-payment exposure. A gap between the DIP manufacturer’s GSTR-1 and the L1 EPC contractor buyer’s GSTR-2B (invoices in GSTR-1 not appearing in GSTR-2B due to a technical or filing delay) produces a customer input tax credit blockage and a downstream commercial dispute. Reconciliation discipline: monthly GSTR-1 outward supply reconciliation to the internal pipe supply invoice register and quarterly cross-check with the L1 EPC contractor buyer’s confirmation of GSTR-2B input tax credit availability. The reconciliation playbook for monthly close framework provides the operational cadence discipline for the monthly GST outward-supply reconciliation.

How a reconciliation platform handles this

A purpose-built steel and pipes reconciliation platform ingests every DIP supply invoice at 18 percent GST under HSN 7307 21, every L1 EPC contractor payment advice with Section 194Q TDS deducted, every bank guarantee issuance and return event, every retention money receivable creation and release event, every Ind AS 115 variable consideration schedule refresh and every Ind AS 109 expected credit loss measurement update against a per-contract-per-month DIP supply compliance ledger keyed on the contract number and the L1 EPC contractor buyer. The platform tags each entry at capture with the applicable transaction-type flag (pipe-supply-to-L1-EPC-contractor for Section 194Q, not works-contract for Section 194C), the contract category tag (JJM, AMRUT, Smart City, private industrial, export), the Section 194Q previous-year-aggregate counter for the L1 EPC contractor customer, and the Ind AS 115 variable consideration schedule reference for the retention money portion. Standing dashboard controls surface any pipe supply invoice with a wrong HSN or GST rate, any L1 EPC contractor customer where the Section 194Q previous-year-aggregate has crossed the fifty lakh rupees threshold and the buyer has not yet begun TDS deduction, any bank guarantee expiring in the next 60 days without a return-to-bank action, any retention receivable past the contractual defect liability period expiry date without release action, and any Ind AS 109 significant-increase-in-credit-risk trigger requiring a lifetime expected credit loss update. Match-rate improvement of 51 to 88 percent on the pipe-supply-invoice-to-payment reconciliation, the Section 194Q-TDS-deducted-to-26AS-credit reconciliation and the retention-receivable-to-Ind-AS-115-variable-consideration reconciliation, combined with an ISO 27001:2022 posture and DPDP Act 2023 aligned data handling for regulator-facing submissions, is what makes the platform an infrastructure investment for a large Indian DIP manufacturer serving the JJM and AMRUT government-water-pipeline supply franchise — rather than a spreadsheet substitute that leaves the order-book tagging, the Section 194Q threshold counter, the bank guarantee ageing and the retention receivable Ind AS 115 and Ind AS 109 discipline as manual overheads on a hybrid commercial-plus-finance team. The commercial pillar for the steel and pipes sub-cluster is steel reconciliation software India; the broader authority for the platform is reconciliation software India. Operational lookups sit in the Section 393 payment code finder for the correct Section 194Q payment code and the Section 16(4) ITC exposure calculator for the parallel GST input tax credit exposure. The trust posture on coverage limits sits in human errors detection envelope.

Terra Insight Editorial Team Reconciliation Infrastructure

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

Published 28 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