CaratLedger — interactive demo, sample data only · Built by Plexowave
Katargam Unit / Production

Factory Dashboard

RS
Production overview
Shift 1 · 15 Sep 2026 · closing at 7:30 PM
Rough in process
4,812.50 ct
▲ 312.40 ct issued this week
Polished ready
1,946.30 ct
▲ 8.2% vs last month
Karigar output today
128.45 ct
▲ 6.1% 74 of 82 karigars present
Average yield (MTD)
34.8%
▼ 0.6 pt vs Aug target 35.4%

Polished output — last 8 months (ct)

Export CSV
Feb
Mar
Apr
May
Jun
Jul
Aug
Sep
July dip reflects the annual Vacation shutdown (12–26 Jul). September is tracking 2,140 ct against a 2,050 ct plan.

Polished mix by shape

Sep 2026
Round brilliant 46%
Princess 18%
Oval 14%
Pear 12%
Cushion & others 10%

Lots currently on the floor

Open Rough Lots
Lot no.Origin parcelRough ctPcsStageEst. yieldStatus
RL-2609-041Antwerp parcel · 4.5–6.0 ct makeable612.4096Laser sawing36.2%On time
RL-2609-038Mahidharpura dealer · sawn boart428.15184Bruting31.8%On time
RL-2608-033Surat bourse · +2 ct rounds874.6061Polishing (Ghat)38.9%1 day late
RL-2608-029BDB Mumbai · brown mix1,206.75312Table & crown29.4%Yield below plan
RL-2608-024Palanpur trader · CVD rough546.00140Planning (Galaxy)41.5%Re-planning
RL-2607-019Antwerp parcel · fancy shapes389.2072Final polish33.1%On time
RL-2607-012Dealer — Varachha · small goods755.401,048Assortment27.6%Hold — breakage

Top karigars — this week

Job work ledger
JD
Jignesh DholakiaGhat · Table 12 · 84.20 ct received
BK
Bhavesh KakadiyaPahel · Table 07 · 76.90 ct received
NS
Nilesh SavaniBruting · Table 21 · 71.15 ct received
PD
Paresh DetrojaGhat · Table 04 · 58.30 ct received
MG
Mehul GhodasaraTalia · Table 16 · 41.75 ct received

Activity

All events
  • Lot RL-2609-041 issued to sawing — 612.40 ct, 96 pcs

    Today · 9:14 AM · by Kiritbhai Vaghani
  • Packet PKT-4472/A received from Jignesh Dholakia — 3.18 ct polished, yield 39.4%

    Today · 8:42 AM · Ghat table 12
  • 12 stones dispatched to IGI Surat for certification — courier SRT/9841

    Yesterday · 5:20 PM
  • Invoice CL/26-27/0318 raised to Shreeji Gems — ₹42,80,500 incl. 0.25% GST

    Yesterday · 3:05 PM
  • Yield alert on RL-2608-029 — actual 29.4% against planned 33.0%

    14 Sep · 6:48 PM
  • Labour bill settled — Bhavesh Kakadiya, ₹1,84,260 for 1–15 Sep

    14 Sep · 11:30 AM
Rough lots
18 open lots · 4,812.50 ct in process · ₹11.24 Cr rough value
Rough received (Sep)
2,486.90 ct
▲ 11.4% across 6 parcels
Avg cost per rough ct
₹23,360
▼ 2.1% vs Aug ₹23,862
Avg cycle time
18.4 days
▲ 1.2 days planning queue backed up
Lots below plan yield
3
▼ 28.9 ct estimated shortfall

Lot register — FY 2026-27

+ New rough lot
Lot no.ReceivedSupplier / parcelRough ctPcsRate / ctLot valuePlan yieldStage
RL-2609-04112 Sep 26Antwerp parcel · makeable 4.5–6.0 ct612.4096₹41,200₹2,52,30,88036.0%Sawing
RL-2609-03808 Sep 26Mahidharpura dealer · sawn boart428.15184₹18,650₹79,84,99832.0%Bruting
RL-2609-03604 Sep 26Bhavnagar trader · flat & cleavage296.80248₹9,420₹27,95,85624.5%Awaiting plan
RL-2608-03327 Aug 26Surat bourse · +2 ct round makeable874.6061₹58,900₹5,15,13,94038.5%Polishing
RL-2608-02921 Aug 26BDB Mumbai · brown mix parcel1,206.75312₹12,780₹1,54,22,26533.0%Below plan
RL-2608-02416 Aug 26Palanpur trader · CVD lab-grown rough546.00140₹6,340₹34,61,64042.0%Planning
RL-2607-01929 Jul 26Antwerp parcel · fancy shape makeable389.2072₹36,500₹1,42,05,80033.5%Final polish
RL-2607-01214 Jul 26Dealer — Varachha · small goods below 0.02 ct755.401,048₹4,180₹31,57,57228.0%Hold
RL-2606-00626 Jun 26Surat bourse · rejection re-cut parcel213.90158₹7,900₹16,89,81026.0%Closed

Record rough intake

Import from parcel sheet
RL-2609-042
15 Sep 2026
Shubham Rough Traders, Mahidharpura
Makeable · 2.0–3.5 ct
318.65
124
27,400
87,31,010
34.5 — set by planning (Galaxy scan pending)
Rough is weighed on the bond-room scale twice: at gate entry and again at strong-room intake. A mismatch above 0.02 ct blocks the lot until a supervisor signs off.

Stage-wise work in progress

Floor map
PL
Planning & marking842.80 ct · 5 lots · 3 scanners running
SW
Laser sawing1,096.20 ct · 4 lots · 11 machines
BR
Bruting728.55 ct · 3 lots
GH
Ghat / polishing1,604.90 ct · 6 lots · 48 tables
AS
Assortment540.05 ct · 2 lots
Ghat is the bottleneck this fortnight — 6 lots queued against a 40-table steady-state capacity. Consider releasing RL-2608-024 to the Varachha sub-unit.
Polished inventory
1,946.30 ct in the strong room · ₹18.42 Cr valuation · 2,184 packets
Ready for sale
1,412.80 ct
▲ 148 ct graded & priced
At lab / in transit
186.45 ct
▲ 24 stones sent this week
Memo / consignment out
347.05 ct
▼ 9 days avg age on memo: 22 days
Avg realisation / ct
₹94,650
▲ 3.4% better colour mix in Aug lots

Packet register

Filter: shape, sieve, lab
PacketParent lotShapeCaratCutColourClarityCertPrice / ctStatus
PKT-4472/ARL-2608-033Round brilliant3.18ExcellentEVVS2GIA₹6,84,000Ready
PKT-4471/CRL-2608-033Round brilliant2.47ExcellentFVS1GIA₹4,92,500Ready
PKT-4468/BRL-2607-019Oval1.92Very GoodGVS2IGI₹3,18,700At lab
PKT-4465/ARL-2607-019Pear1.54Very GoodHSI1IGI₹1,96,400On memo
PKT-4459/DRL-2608-029Princess1.08GoodISI2₹88,200Ready
PKT-4452/ARL-2608-029Cushion0.94Very GoodJSI1₹71,500Assorting
PKT-4448/FRL-2608-024Round (CVD)2.05ExcellentFVVS2IGI₹64,800Ready
PKT-4441/BRL-2607-012Round star melee18.60GoodG-HVS-SI₹42,300Ready
PKT-4436/ARL-2606-006Emerald1.31Very GoodGVS1GIA₹2,41,900Re-polish
PKT-4430/CRL-2606-006Marquise0.86GoodISI2₹62,100On memo

Sieve-size split

ct
-2
+2
+4
+6
+9
+11
1ct+

Colour holding

Top 6
D
D–E214.60 ct · ₹4.18 Cr
F
F–G468.25 ct · ₹5.92 Cr
H
H–I612.40 ct · ₹4.36 Cr
J
J–K396.15 ct · ₹2.41 Cr
L
L and below254.90 ct · ₹1.55 Cr

Ageing

Strong room
BucketCaratValue
0–30 days824.60₹8.12 Cr
31–60 days512.35₹4.86 Cr
61–90 days318.90₹3.04 Cr
91–180 days204.15₹1.76 Cr
180+ days86.30₹64.2 L
₹64.2 L is stuck in 180-day-old J–SI2 goods. Suggest routing to the Mumbai memo desk at a 4% discount.
Karigar job work
82 karigars on roll · 7 issues pending receipt · ₹18.64 L labour payable this fortnight
Issued (open)
386.20 ct
▲ 7 jobs across 5 departments
Received (Sep)
1,284.95 ct
▲ 12.8% vs Aug same period
Labour payable
₹18,64,120
▲ ₹1.42 L 1–15 Sep cycle
Loss beyond tolerance
2.86 ct
▼ recovery raised on 3 karigars

Issue & receipt register — Sep 2026

+ New job issue
Job no.KarigarDept · TablePacketIssued ctReceived ctLoss %Rate / ctLabour ₹Status
JW-9214Jignesh DholakiaGhat · T-12PKT-4472/A8.063.1860.6%₹1,850₹5,883Received
JW-9211Bhavesh KakadiyaPahel · T-07PKT-4471/C6.242.4760.4%₹1,620₹4,001Received
JW-9208Nilesh SavaniBruting · T-21PKT-4470/B42.8038.1510.9%₹410₹15,642Received
JW-9204Paresh DetrojaGhat · T-04PKT-4468/B5.161.9262.8%₹1,740₹3,341Loss review
JW-9199Mehul GhodasaraTalia · T-16PKT-4465/A62.40₹360Issued
JW-9195Alpesh SutariyaGhat · T-29PKT-4462/D94.15₹1,280Issued
JW-9190Ramesh ZalavadiyaPahel · T-33PKT-4459/D2.861.0862.2%₹1,540₹1,663Received
JW-9186Dinesh KachhadiyaBruting · T-18PKT-4456/A51.2044.6012.9%₹395₹17,617Loss review
JW-9181Hitesh RangpariyaGhat · T-41PKT-4448/F4.922.0558.3%₹980₹2,009Received
JW-9176Sanjay VekariyaTalia · T-09PKT-4441/B124.80₹240Overdue 3 d

Issue a new job

Scan packet barcode
JW-9215
15 Sep 2026 · 10:40 AM
Kiritbhai Vaghani — badge K-0117
Ghat · Table 12
PKT-4475/A (lot RL-2609-041)
7.42
1,850 — Ghat, above 2 ct slab
17 Sep 2026 · 2.95 ct
0.9% of issue weight (0.067 ct) — excess recovered from labour bill

Labour bill summary — 1–15 Sep

Generate payment sheet
KarigarDeptCarat doneGross ₹Recovery ₹Net ₹
Jignesh DholakiaGhat84.201,55,77001,55,770
Bhavesh KakadiyaPahel76.901,24,57801,24,578
Nilesh SavaniBruting318.401,30,5442,1801,28,364
Paresh DetrojaGhat58.301,01,4426,84094,602
Mehul GhodasaraTalia241.7587,030087,030
Alpesh SutariyaGhat62.1579,552079,552
Dinesh KachhadiyaBruting286.101,13,0109,4201,03,590
62 othersMixed1,146.8010,86,5144,88010,81,634
Job work on cut & polished diamonds is billed at 1.5% GST under reverse charge where the karigar is unregistered. Recovery entries post against the karigar ledger, not the lot cost.
Assortment & grading
4C grading desk · 540.05 ct queued · 3 assorters on duty
Queued for assortment
540.05 ct
▼ 62 ct cleared since morning
Graded today
312 packets
▲ 18% against a 265 packet plan
Triple-EX share
41.6%
▲ 2.8 pt after new Ghat SOP
Sent back for re-polish
26 packets
▼ mostly girdle 18 for naturals, 8 for symmetry

Grading worksheet — lot RL-2608-033

Send selection to lab
PacketCaratCutColourClarityPolish / SymFluor.Assorted byRoute
PKT-4472/A3.18ExcellentEVVS2EX / EXNoneKalpesh RanparaGIA cert
PKT-4472/B2.86ExcellentFVS1EX / EXFaintKalpesh RanparaGIA cert
PKT-4471/C2.47ExcellentFVS1EX / VGNoneVipul SojitraGIA cert
PKT-4471/D1.74Very GoodGVS2VG / VGMediumVipul SojitraIGI cert
PKT-4470/A1.42Very GoodHSI1VG / GNoneAshish TogadiyaNon-cert sale
PKT-4470/B1.06GoodISI2G / GStrongAshish TogadiyaNon-cert sale
PKT-4469/A0.92Very GoodGVS2VG / VGFaintKalpesh RanparaIGI cert
PKT-4469/C0.78FairHSI2G / FNoneVipul SojitraRe-polish

Clarity distribution — Sep graded goods

By carat
IF
VVS1
VVS2
VS1
VS2
SI1
SI2
I1
VS1–SI1 carries 61% of graded carats this month, matching the buying profile of the BDB Mumbai desk.

Grade a packet

Load next from queue
PKT-4473/A
RL-2608-033
Round brilliant
2.16
Excellent
F
VS1
None
57.0
61.8
Clean crown, tiny natural on girdle at 4 o'clock — acceptable for cert.
Certification
24 stones at lab · 186.45 ct in transit · avg turnaround 9.4 days
At lab
24 stones
▲ 12 sent in the last 7 days
Certified (Sep)
68 stones
▲ 9.7% 141.82 ct certified
Avg turnaround
9.4 days
▼ 1.8 days faster than Aug
Lab fees (Sep)
₹4,86,300
▲ ₹38,400 64% GIA, 36% IGI

Certificate register

+ Send batch to lab
Cert no.LabPacketCaratGrade (C/Col/Cl)SentReceivedFee ₹Status
GIA 2416832907GIA MumbaiPKT-4472/A3.18EX / E / VVS228 Aug 2606 Sep 2614,820In hand
GIA 2416829441GIA MumbaiPKT-4471/C2.47EX / F / VS128 Aug 2606 Sep 2611,640In hand
IGI 648291735IGI SuratPKT-4469/A0.92VG / G / VS202 Sep 2610 Sep 263,280In hand
IGI 648294118IGI SuratPKT-4468/B1.92VG / G / VS209 Sep 265,940At lab
PendingGIA MumbaiPKT-4472/B2.86EX / F / VS111 Sep 2613,100At lab
PendingIGI SuratPKT-4448/F2.05EX / F / VVS2 (CVD)12 Sep 264,100At lab
Courier SRT/9841IGI Surat12 stone batch21.46Mixed VS–SI14 Sep 2646,200In transit
GIA 2416810228GIA MumbaiPKT-4436/A1.31VG / G / VS104 Aug 2616 Aug 267,450Downgraded
HRD 25081194HRD MumbaiPKT-4430/C0.86G / I / SI222 Aug 2603 Sep 263,900In hand

Prepare lab dispatch

Print packing list
GIA Mumbai — BKC intake counter
Full grading report · express (5 working days)
CERT/2609/07
16 Sep 2026
9 packets · 16.84 ct
₹58,42,000
Transit policy TP-4471 · up to ₹1.5 Cr
Secured angadia — receipt SRT/9847
Inscribe report number on girdle for all stones above 1.00 ct.

Lab performance — last 90 days

Compare
GI
GIA Mumbai112 stones · 8.6 day avg · ₹4,910 avg fee
IG
IGI Surat186 stones · 6.2 day avg · ₹2,640 avg fee
HR
HRD Mumbai34 stones · 12.8 day avg · ₹4,180 avg fee
SG
In-house grading desk412 stones · same day · non-cert goods
One-grade downgrades against the in-house call ran at 6.4% this quarter, all on clarity. The assortment SOP was tightened on 1 Sep for SI borderline stones.
Parties & sales
48 active parties · ₹6.82 Cr billed in Sep · ₹2.14 Cr outstanding
Sales (Sep MTD)
₹6.82 Cr
▲ 14.2% vs Sep last year
Outstanding
₹2.14 Cr
▼ ₹18 L overdue beyond 60 days
Avg collection days
42 days
▲ 4 days credit terms are 45 days
Goods on memo
₹1.28 Cr
▼ 6 parties 347.05 ct out

Sales invoices — Sep 2026

+ New invoice
InvoiceDatePartyCityCaratTaxable ₹GSTTotal ₹Status
CL/26-27/031814 Sep 26Shreeji Gems & ExportsSurat48.6242,69,8300.25%42,80,504Due 29 Oct
CL/26-27/031511 Sep 26Ratnadeep Diamonds LLPMumbai (BDB)62.1868,42,1000.25%68,59,205Due 26 Oct
CL/26-27/031108 Sep 26Mangalam Jewels Pvt LtdAhmedabad14.8626,18,4003.00%26,96,952Paid
CL/26-27/030805 Sep 26Krishna Gems, PalanpurPalanpur96.4031,84,6000.25%31,92,562Paid
CL/26-27/030402 Sep 26Anand Exports (SEZ unit)Surat SEZ124.751,08,26,000LUT / 0%1,08,26,000Paid
CL/26-27/029929 Aug 26Hariom JewellersRajkot9.2418,46,2003.00%19,01,586Overdue 17 d
CL/26-27/029424 Aug 26Pramukh Diam, MahidharpuraSurat184.3046,72,5000.25%46,84,181Due 08 Oct
CL/26-27/029019 Aug 26Navkar Gems, BhavnagarBhavnagar212.6024,18,7000.25%24,24,747Paid

Party ledger balances

Send reminders
PartyGSTINTermsBalance ₹Ageing
Ratnadeep Diamonds LLP27AAGCR4821L1ZP45 days68,59,205Current
Shreeji Gems & Exports24AACFS9126K1Z445 days42,80,504Current
Pramukh Diam24AAKFP3318M1ZR30 days46,84,18123 days
Hariom Jewellers24AADFH7740B1ZQ30 days19,01,58647 days
Giriraj Impex24AAFCG5512N1ZJ60 days21,46,90052 days
Anand Exports (SEZ)24AAECA2298J1ZTAdvance0Settled
Navkar Gems24AANFN6604H1ZB30 days0Settled
Mangalam Jewels Pvt Ltd24AACCM8813F1ZV15 days0Settled

Raise a sale

Pick packets from stock
CL/26-27/0319
15 Sep 2026
Ratnadeep Diamonds LLP, BDB Mumbai
27AAGCR4821L1ZP · Maharashtra (IGST)
6 packets · 11.84 ct
₹2,86,400
₹33,91,000
₹8,478
₹33,99,478
45 days · due 30 Oct 2026
Loose cut and polished diamonds are billed at 0.25% GST; set jewellery at 3%. SEZ and export sales go out under LUT at nil rate with a shipping bill reference.
Reports
FY 2026-27 · period 01 Apr 2026 – 15 Sep 2026 · Katargam unit
Yield YTD
34.2%
▲ 0.9 pt vs FY 2025-26
Turnover YTD
₹34.68 Cr
▲ 16.4% 58% export, 42% domestic
Cost per polished ct
₹68,420
▼ 1.6% rough ₹62,180 + labour ₹6,240
Gross margin
27.6%
▲ 1.3 pt certified goods lifting mix

Lot-wise yield realisation

Download Excel
Lot no.Rough ctPolished ctPlan yieldActual yieldRough cost ₹Labour ₹Sale value ₹Margin
RL-2606-006213.9058.2626.0%27.2%16,89,8101,42,30024,86,400+35.7%
RL-2605-092684.20242.3034.0%35.4%2,18,94,4009,86,4003,14,20,000+37.4%
RL-2605-088412.60128.7133.0%31.2%1,04,79,2405,12,8001,28,64,000+16.9%
RL-2604-071928.40352.7936.5%38.0%4,18,78,00016,24,6006,02,40,000+38.5%
RL-2604-066318.7582.8828.0%26.0%42,16,0003,08,20046,92,000+3.6%
RL-2603-0581,142.60394.2033.5%34.5%3,86,42,00018,46,9005,41,80,000+33.7%
RL-2603-049546.00231.4041.0%42.4%34,61,6406,42,10058,20,000+41.7%
RL-2602-034755.40203.9628.0%27.0%31,57,5724,86,40039,84,000+9.3%

Monthly yield % against plan

Apr – Sep
Apr
May
Jun
Jul
Aug
Sep
Bars show actual yield as a share of the 40% theoretical ceiling. August was the best month at 35.9% on a favourable makeable parcel.

Revenue split

YTD ₹34.68 Cr
Certified polished (export) 38%
Certified polished (domestic) 24%
Non-cert / assorted goods 17%
Lab-grown (CVD) line 13%
Job work for other units 8%

Scheduled reports

Manage
ReportFrequencyTo
Daily production sheetEvery 8:00 PMFactory manager
Lot yield closureOn lot closeOwner, planning
Karigar labour bill1st & 16thAccounts
Stock valuationMonth endOwner, CA
GSTR-1 workings9th monthlyCA — Dave & Co.
Debtor ageingEvery MondaySales desk

Compliance calendar

Sep – Oct
  • GSTR-3B for August filed

    20 Sep 2026 · ready for review
  • Export realisation (EBRC) pending on 2 shipping bills

    Due 30 Sep 2026
  • TDS on job work (194C) deposit

    Due 07 Oct 2026 · ₹1,86,400
  • Half-yearly strong-room stock count

    Scheduled 30 Sep 2026

Unit snapshot

Sep 2026
MeasureValue
Tables running48 of 52
Karigars on roll82
Attendance (avg)90.2%
Rough consumed YTD9,486 ct
Polished produced YTD3,244 ct
Certified stones YTD412
Power cost / polished ct₹412
All figures on this screen are sample data for demonstration only.