Reconciliation Software for Indian Jewellers
Built for Indian jewellery retailers, wholesalers and manufacturing houses: mixed-rate GST invoicing where a single line carries 3% gold + 5% making + 18% components, job-work vs Section 194Q classification for karigar payments, old-gold trade-in under Rule 32(5) of the CGST Valuation Rules, RBI Gold Metal Loan dual-leg settlement, BIS HUID-level hallmarking pass-through, and Section 269ST high-value walk-in cash controls. India-native by construction — codes, sections and notifications baked into the variance taxonomy, not bolted on.
Six reconciliation surfaces built for jewellers
Each surface is independently complex. Together, they are the jewellery finance and tax workload. TransactIG handles all six on a single ingest, single variance taxonomy, single audit trail.
Mixed-rate GST invoicing (3% + 5% + 18%)
A single retail jewellery invoice for a diamond-studded gold ornament legitimately carries three GST rates against three HSN codes: 3% on gold value (HSN 7113 under CBIC Notification 05/2017-CTR), 5% on making charge (when billed separately under Notification 03/2018-CTR — or 3% when embedded as a composite supply), and 18% on stone-only components and packaging. POS systems often collapse these into a weighted-average line or misclassify making charge as gold. TransactIG splits every invoice at the tax-line level, ties each line to the correct HSN and notified rate on the date of supply, reconciles POS output to GSTR-1 filed and GSTR-2B ITC available to B2B customers, and flags composite-vs-mixed supply classification issues before the return is filed.
Job-work vs Section 194Q classification
Karigar payments sit at the boundary of three tax treatments. Pure labour on the jeweller's gold — title never passes — is job-work under Section 393(1) with the payment code corresponding to legacy 194C. Where the karigar buys gold, adds value and sells the finished piece back, the payment can be re-characterised as purchase of goods under Section 194Q at 0.1% (buyer turnover above ₹10 crore, per-seller purchases above ₹50 lakh). Registered GST karigars switch the rail again. TransactIG classifies every karigar payment against contract type, gold-supply flow and PAN-linked cumulative payment history, and produces a per-karigar working paper with the section, rate and exception cases flagged for Form 3CD Clause 34(a) evidence.
Old-gold trade-in — Rule 32(5) margin scheme
Rule 32(5) of the CGST Valuation Rules provides that where a dealer buys second-hand goods and sells them after minor processing, GST applies only to the margin (sale price minus purchase price), not the gross sale value. A walk-in customer trading a 20g old chain against a 25g new necklace triggers Rule 32(5) treatment — but POS systems commonly invoice the gross new-piece value and credit the trade-in as a return, producing a GSTR-1 outward supply that does not match the margin-scheme mechanic. TransactIG tags every retail transaction with a trade-in flag, computes the Rule 32(5) margin, ties reported outward supply on GSTR-1 to the margin, and produces the assay/purity certificate reference and old-gold weight audit trail statutory auditors ask for.
Metal-loan settlement (RBI GML framework)
A Gold Metal Loan is denominated in physical gold. The jeweller draws (say) 5 kg from a nominated bank pool account, fabricates and sells jewellery, and settles the loan by returning physical gold or cash-equivalent at a fixed price date. Reconciliation is dual-leg: the fixed leg tracks weight and purity (995/999 fineness) against the bank pool account; the floating leg tracks interest and price fixing at LBMA AM/PM fix or the MCX equivalent. Rupee working-capital reconciliation is one dimension; GML is two. TransactIG ingests bank pool-account statements alongside the jeweller's fabrication ledger, ties the fixed leg at weight/purity level and the floating leg at fix-date level, and produces the RBI-audit-defensible reconciliation treasury and statutory audit teams need.
Karigar labour TDS discipline
Beyond job-work vs 194Q classification, the karigar payment file requires the per-payee working paper that Form 3CD Clause 34(a) audit expects: PAN capture rate, threshold monitoring across the fiscal year, deduction rate applied against contract type, deposit challan reference, TDS return (26Q / 27EQ) tie-back, and Form 16A issuance discipline. Jewellers with 50-500 karigars across multiple workshop clusters (Kolkata Bowbazar, Rajkot, Coimbatore, Thrissur, Amritsar) run into the classic threshold-crossing miss where the aggregate crosses ₹1 lakh mid-year and the retrospective deduction is not booked. TransactIG surfaces threshold-crossing candidates before the crossing event, ties every deduction to a challan reference and a 26Q entry, and produces the per-karigar TDS card the tax-audit team needs.
BIS hallmarking cost pass-through
Under the Hallmarking of Gold Jewellery and Gold Artefacts (Amendment) Order 2021, hallmarking with a HUID (six-character alphanumeric identifier) is mandatory for gold jewellery sold in India — effective in phased rollout across 288+ notified districts. Every piece of hallmarked jewellery carries a BIS-registered Assaying and Hallmarking Centre (AHC) hallmarking fee, typically ₹45 per piece for gold and ₹25 for silver plus assay charges. Retailers pass this through to the customer as a line item; the reconciliation surface is tying AHC invoice reference against HUID against the retail invoice line, so the pass-through is auditable and the AHC vendor account reconciles clean. TransactIG ingests AHC vendor invoices at HUID level, ties them to POS-line-level hallmarking pass-through, and produces the BIS compliance audit trail District Manager, IS/QA teams and statutory audit reference.
What makes jewellery reconciliation different from every other retail vertical
Indian jewellery reconciliation sits at the intersection of five constraints that do not converge anywhere else in retail. First, the three-rate GST mechanic — gold at 3%, making at 5% (under CBIC Notification 03/2018-CTR when billed separately), diamond and stone components at 3%, and stone-only or packaging lines at 18% — is not an edge case but the default invoice shape. A single retail invoice for a diamond-studded gold necklace routinely carries three or four distinct HSN codes at three distinct rates, with composite-vs-mixed supply classification driving whether the making charge is at 5% (separately billed) or 3% (bundled into the composite gold supply). Point-of-sale software that treats an invoice as a single tax line breaks GSTR-1 the moment the customer is B2B.
Second, the bullion counterparty carries a dual role. The same nominated bank or bullion importer (SBI, HDFC, ICICI, Kotak, Federal Bank, IndusInd, MMTC-PAMP, others) can be both a Gold Metal Loan lender (physical gold in) and a bullion supplier (INR purchase). The same MCX or India Bullion Exchange (IBJA) price feed drives both the price-fixing leg of the metal loan and the daily rate cards on the retail shop floor. Treating the counterparty as either a "lender" or a "supplier" — the way generic AP/AR modules do — loses the reconciliation entirely; the two flows must be tied at pool-account level.
Third, high-value walk-in cash is structural. Section 269ST of the Income-tax Act caps a single cash receipt at ₹2 lakh; PAN capture is mandatory above ₹2 lakh in cash or ₹5 lakh on a single invoice; Statement of Financial Transactions (SFT) reporting under Section 285BA and Rule 114E covers aggregate high-value cash. A jeweller processing 40-80 walk-in transactions per store per day at average ticket sizes above ₹1 lakh cannot enforce Section 269ST as a back-office control — it must run at POS-save-time or the compliance gap opens at every sale.
Fourth, physical goods flow does not match the invoice flow. Old-gold trade-in physically enters the store as raw material; is assayed for purity (818, 875, 916, 995 fineness) at the shop floor; is credited against the customer's new-piece purchase; and is later refined or sent for melting. The invoice reflects Rule 32(5) margin. The physical flow reflects a raw-material intake. Reconciling the two requires assay certificate, HUID reference (where new-piece hallmarking applies), old-gold weight and purity band all tied to the same retail invoice line.
Fifth, the RBI Gold Metal Loan framework layers a foreign-currency-priced physical-goods facility on top of the ordinary rupee balance sheet. The fixed leg (weight in grams at fineness) reconciles to the bank pool account; the floating leg (interest and price fix at LBMA AM/PM or MCX equivalent) reconciles to the treasury ledger. Statutory audit expects both legs to tie to a single fabrication and sale of the underlying gold. Rupee working-capital loan reconciliation is one dimension; GML is two. Generic reconciliation software treats it as one and produces a working paper that does not stand up to RBI-linked bank audit.
A single retail invoice, five tax lines, three GST rates
A walk-in customer buys an 18g 22K gold ring with a 0.75ct SI-grade diamond. The invoice legitimately splits into five tax lines against three distinct HSN codes and three distinct GST rates. TransactIG classifies each line at POS-save-time; GSTR-1 outward supply reflects the split; GSTR-2B ITC available to a B2B customer reflects the correct rate against each HSN.
| Line description | HSN | GST rate | Taxable value (₹) | GST (₹) |
|---|---|---|---|---|
| 22K gold value (18g at ₹6,200/g) | 7113 | 3% | 1,11,600 | 3,348 |
| Making charge (₹450/g on gold weight) | 9988 | 5% | 8,100 | 405 |
| Diamond components (0.75ct SI grade) | 7113 | 3% | 42,000 | 1,260 |
| Hallmarking pass-through (HUID assigned) | 9988 | 18% | 45 | 8 |
| Presentation packaging box | 4819 | 18% | 180 | 32 |
| Invoice total (three-rate composite) | — | — | 1,61,925 | 5,053 |
Illustrative. Gold rate, making charge, diamond value and hallmarking fee shown for explanatory purposes; do not treat as market rates. Making charge shown as separately billed at 5% (Notification 03/2018-CTR) — where making is bundled into the composite gold supply, the entire composite attracts 3%. Composite-vs-mixed supply classification is itself a reconciliation surface.
Jewellery reconciliation surfaces vs generic reconciliation software
How each of the six jewellery reconciliation surfaces is handled by generic horizontal reconciliation software (ERP-bundled or standalone), versus TransactIG's India-native, jewellery-aware variance taxonomy.
| Dimension | Generic reconciliation software | TransactIG |
|---|---|---|
| Mixed-rate GST invoicing | POS collapses gold + making + stones into a single weighted-average tax line, or misclassifies making charge as gold and misses the 5% notification. | Splits every invoice at the tax-line level against HSN 7113 (gold at 3%), HSN 9988 (making at 5% under Notification 03/2018-CTR), stone components at 3%, packaging at 18%. GSTR-1 outward-supply tie per line. |
| Karigar TDS classification | One TDS rate applied uniformly to all karigar payments — 194C at 1%/2% — regardless of whether title in gold actually passed. Section 194Q at 0.1% missed on karigars who are net-sellers to the jeweller. | Per-karigar contract-type classification (job-work under Section 393(1) code 194C vs purchase-of-goods under Section 194Q). PAN-linked cumulative-payment threshold monitoring. Per-karigar working paper for Form 3CD Clause 34(a). |
| Old-gold trade-in | Trade-in invoiced as a gross new-piece sale with a separate customer-return line for the old gold. GSTR-1 outward supply shows gross retail value; Rule 32(5) margin scheme not applied. | Every retail transaction flagged for trade-in. Rule 32(5) margin computed (sale minus purchase). GSTR-1 outward supply reconciled to margin. Assay/purity certificate reference and old-gold weight tied to invoice. |
| Metal-loan settlement | Bank statement reconciled to interest expense as if the loan were denominated in rupees. Physical gold pool account and price-fix leg tracked in a treasury spreadsheet outside the system. | Dual-leg reconciliation: fixed leg at weight/purity (995/999 fineness) against bank pool-account statement; floating leg at LBMA AM/PM fix or MCX equivalent against the notional principal. RBI audit-defensible. |
| High-value walk-in cash | Cash receipts booked to a single cash-in-hand GL. Section 269ST ₹2 lakh single-transaction limit not enforced at POS; PAN capture at ₹2 lakh cash threshold and ₹5 lakh single-invoice threshold enforced manually. | Per-invoice Section 269ST validation before invoice save. PAN capture threshold flags at the POS. Aggregate per-customer per-day cash monitoring for structuring detection. Statement of Financial Transactions (SFT) evidence pack. |
| BIS hallmarking cost tie | AHC vendor invoices booked to a hallmarking-cost GL. HUID not tied to retail invoice line. Pass-through to customer is a line-item flat rate without invoice-level audit trail. | AHC vendor invoices ingested at HUID level; each HUID tied to the retail invoice line where the pass-through was billed. Per-piece BIS compliance audit trail; AHC vendor account reconciles clean at month-end. |
Six reasons jewellers choose TransactIG
A multi-pass matching engine trained on the jewellery variance taxonomy — not a generic reconciliation tool with a jewellery skin.
Mixed-rate GST built-in, not bolted on
3% gold, 5% making, 18% components — the three-rate mechanic is the default POS behaviour, not a post-close adjustment. Composite-vs-mixed supply classification runs before the return is filed.
Karigar TDS classified per payment
Job-work under Section 393(1) code 194C, purchase-of-goods under Section 194Q at 0.1%, or GST rail — classified per karigar against contract type, gold-supply flow and PAN-linked threshold history.
Old-gold margin scheme is a first-class primitive
Rule 32(5) trade-in is a POS flag, not a manual adjustment. Assay, purity, old-gold weight and Rule 32(5) margin are tied to the retail invoice for statutory audit evidence.
Gold Metal Loan dual-leg reconciliation
Fixed leg at weight/purity against bank pool account; floating leg at LBMA/MCX fix against notional principal. RBI GML framework audit trail delivered as a single evidence pack.
HUID-level BIS hallmarking tie
AHC vendor invoices ingested at HUID level; per-piece hallmarking pass-through tied to the retail invoice line. BIS Hallmarking Amendment Order 2021 compliance audit trail on demand.
High-value walk-in cash controls
Section 269ST ₹2 lakh single-transaction limit enforced at POS. PAN capture threshold flags at ₹2 lakh cash and ₹5 lakh single invoice. SFT evidence pack for high-value cash monitoring.
Related jewellery reconciliation insights
Wave 1 cornerstone articles on the six jewellery reconciliation surfaces — each anchored to a specific Indian tax code, RBI framework, or regulatory notification.
Frequently Asked Questions
What does jewellery reconciliation software for India actually reconcile? +
Jewellery reconciliation software built for India ties together six surfaces that no horizontal accounting or ERP tool covers natively: (1) mixed-rate GST invoicing where a single invoice line carries 3% on gold value, 5% on making charge and 18% on studded diamond or gemstone components — CBIC Notification 05/2017-CTR read with the 03/2018-CTR making-charge notification; (2) karigar and job-worker payments classified between job-work (Section 393(1) with the applicable payment code) and purchase-of-goods (Section 194Q at 0.1% over the ₹50 lakh threshold with buyer turnover above ₹10 crore); (3) old-gold trade-in valuation under Rule 32(5) of the CGST Valuation Rules — the margin scheme — where GST applies only to the value addition, not the full retail price; (4) metal-loan settlement under the RBI Gold Metal Loan (GML) framework, tying the fixed leg (physical gold delivery) against the floating leg (price on the interest date) at pool-account level; (5) BIS hallmarking cost pass-through under the Hallmarking of Gold Jewellery and Gold Artefacts (Amendment) Order 2021, including HUID tracking against Assaying and Hallmarking Centre invoices; and (6) high-value cash walk-in receipts under Section 269ST (₹2 lakh limit) and PAN capture threshold rules. TransactIG classifies each line item by the relevant rule, section or notification and produces a single audit-defensible variance file per surface.
How does a jewellery reconciliation platform handle mixed 3% / 5% / 18% GST rates on a single invoice? +
The mixed-rate mechanic is the defining feature of Indian jewellery GST. Gold jewellery attracts 3% under CBIC Notification 05/2017-CTR (HSN 7113); making charges attract 5% under CBIC Notification 03/2018-CTR when billed separately (or 3% when embedded in the composite supply — the composite-vs-mixed determination itself is a reconciliation surface); studded diamonds or coloured gemstones attract 3% but stone-only components and packaging attract 18%. A single retail invoice for a diamond-studded gold necklace legitimately carries three tax lines against three HSN codes and three rates. Point-of-sale software often collapses these into a weighted-average line or misclassifies the making charge, breaking GSTR-1 outward supply and creating downstream ITC mismatches for B2B buyers. TransactIG splits every invoice into its component tax lines against the correct HSN, ties each line to the notified rate on the date of supply, reconciles POS-line-level output against GSTR-1 filed and against GSTR-2B ITC available to the customer, and flags composite-vs-mixed supply classification issues before the return is filed. The audit output is a per-invoice tax-line variance file consistent with the working-paper discipline the Institute of Chartered Accountants of India (ICAI) expects on jewellery GST audits.
What TDS section applies to karigar (labour) payments and how does classification affect reconciliation? +
Karigar payments sit at the boundary between three treatments and the classification is the reconciliation surface. If the karigar supplies pure labour on the jeweller's gold (a classic job-work relationship where title in the gold never passes), the payment is job-work under Section 393(1) of the Income-tax Act 2025 (payment code corresponding to legacy Section 194C, currently at 1% for individual/HUF and 2% for other payees, over the applicable per-transaction and aggregate thresholds). If the karigar buys gold, adds value and sells the finished piece back — title passes twice — the payment can be re-characterised as a purchase of goods under Section 194Q at 0.1% (when the buyer's turnover exceeded ₹10 crore in the prior year and per-seller purchases in the year exceed ₹50 lakh). Where the karigar is a registered dealer supplying under GST, the tax rail switches again to CGST provisions. TransactIG classifies every karigar payment against contract type, gold-supply flow and PAN-linked cumulative payment history, and produces a per-karigar TDS working paper with the section applied, the rate applied and the exception cases flagged for tax-team review — the same evidence discipline that tax audit reports under Form 3CD Clause 34(a) require.
How does jewellery reconciliation software handle old-gold trade-in under Rule 32(5)? +
Old-gold trade-in is one of the two or three most-litigated jewellery GST clauses. Rule 32(5) of the CGST Valuation Rules — commonly called the margin scheme — provides that where a dealer buys second-hand goods and sells them after minor processing that does not change the nature of the goods, GST applies only to the difference between the sale price and the purchase price (the margin), not the full sale value. In practical retail, a walk-in customer trades in a 20g old gold chain against a new 25g necklace; the jeweller credits the trade-in value, invoices only the net addition and reports the margin under Rule 32(5). The reconciliation problem is that POS systems often invoice the gross new-piece value and separately credit the trade-in as a return, producing a GSTR-1 outward supply figure that does not match Rule 32(5) treatment. TransactIG tags every retail transaction with a trade-in flag, computes the Rule 32(5) margin, ties the reported outward supply on GSTR-1 to the margin-scheme mechanic, and produces the assay/purity certificate reference and old-gold weight audit trail for statutory audit. Where Rule 32(5) is misapplied (e.g., trade-in from a registered dealer where the input tax credit rail should have been used instead), the classification flag surfaces before the return is filed.
What is metal-loan reconciliation and how is it different from a rupee working-capital loan? +
A Gold Metal Loan (GML) under the RBI framework is denominated in physical gold — the jeweller receives, say, 5 kg of gold from a nominated bank (SBI, ICICI, HDFC, Kotak, Federal Bank, IndusInd, or one of the RBI-nominated bullion importers), fabricates jewellery, sells it, and settles the loan by returning either physical gold or cash equivalent at a fixed price date. The reconciliation is dual-leg: the fixed leg tracks gross weight, purity (995 fineness for standard gold, 999 for pure) and physical delivery against the bank's gold pool account; the floating leg tracks the interest (typically LIBOR-plus in USD terms or an equivalent MCLR-plus INR rate) and the price-fixing event where gold is booked at LBMA AM/PM fix or the equivalent MCX benchmark. Rupee working-capital loan reconciliation ties a single principal against interest and repayment — one dimension. GML reconciliation ties two dimensions: physical gold weight against the pool account, and price fixing against the notional principal at settlement. TransactIG ingests bank pool-account statements alongside the jeweller's fabrication ledger, ties the fixed leg at weight/purity level and the floating leg at fix-date level, and produces the RBI-audit-defensible reconciliation the treasury and statutory audit teams need.
Stop treating jewellery reconciliation as a spreadsheet problem
TransactIG ingests your POS invoice detail (Compudyne, Sunmicro, Jewelmate, Marg, custom), karigar payment ledger, bank pool-account statements, MCX/IBJA price feeds, GSTR-2B downloads and AHC hallmarking vendor invoices in their native formats. Six jewellery reconciliation surfaces, one variance taxonomy, one audit pack. ISO 27001:2022 certified. Multi-pass matching engine trained on the Indian jewellery variance taxonomy.