Jewellery Showroom Excel Dashboard | Old Gold Exchange Hallmarking Tracker | Goldsmith Stock | Jeweller Template

Old gold exchange becomes complicated when weight checks, purity testing, deductions, and hallmarking status are tracked manually. This Jewellery Showroom Old Gold Exchange & Hallmarking Tracker helps jewellery businesses track old gold buyback/exchange transactions, purity and melting deductions, hallmarking workflow, and final billing in one centralized system—so you keep tracking in one place, reduce calculation errors, and improve profitability control.

This is a ready-to-use, professionally designed, and fully customizable Excel dashboard created to simplify showroom operations. It enables you to record customer details, old gold item details, gross/net weights, karat/purity results, rate applied, deduction % (stone/wastage/melting), and settlement method (cash/adjustment against new purchase). Everything is organized to give you at-a-glance visibility of pending hallmarking, exchange pipeline, and daily transaction summaries.

Whether you handle 22K/18K exchanges, ornaments with stones, or bullion buyback, this dashboard supports stronger documentation and smoother customer service.

What’s Included:

• Customer exchange register (name, phone, ID reference—customizable)
• Old gold item log (item type, description, karat/purity, gross weight)
• Stone/impurity deduction fields (stone weight, wastage %, melting loss—customizable)
• Net payable weight calculation (auto net weight after deductions)
• Rate and valuation section (rate/gm, value, making charges adjustment—optional)
• Settlement tracking (cash paid / adjusted / voucher issued, reference)
• Hallmarking workflow tracker (sent date, vendor/lab, received date, status)
• New jewellery sale linkage (invoice no., new item details, balance payable—optional)
• Daily exchange summary dashboard (total weight, total value, counts)
• Pending hallmarking and pending settlement follow-up list

Key Benefits:

• Centralizes old gold exchange and hallmarking tracking in one place
• Reduces valuation errors with structured weight/purity/deduction records
• Improves transparency with clear deductions and net payable calculations
• Tracks hallmarking status to prevent missed pending jobs
• Improves cash flow control with settlement and adjustment tracking
• Saves time with daily summaries and pending follow-up lists
• Supports audit-ready documentation of exchange transactions
• Ideal for jewellery showrooms and gold exchange counters

Get your Old Gold Exchange & Hallmarking Tracker today and streamline your venue operations while maximizing revenue and customer satisfaction.