Jewellery GST invoice (Excel)
Tax invoice with HUID, purity, weight, wastage, making (% / per gram / fixed), stones, hallmark, CGST + SGST and old gold — all calculated.
Scan the tag, and the bill fills itself: rate × weight + wastage + making + stones + hallmark, 3% GST and old gold exchange.
Start a sales invoice (or an estimate) and pick the customer.
Scan the tag — the item, purity and weights fill in from stock.
The line amount is (net weight + wastage) × rate, plus making (per gram, % or fixed), stone charges and hallmark.
Add old gold (URD) on the same invoice; the customer pays only the balance.
GST is added on the taxable value (3% on jewellery). Convert an estimate to a GST bill whenever needed.
Take payment, print the invoice and settle any due later with a receipt. Returns are handled from the same screen.
Tax invoice with HUID, purity, weight, wastage, making (% / per gram / fixed), stones, hallmark, CGST + SGST and old gold — all calculated.
One row per piece with the same fields you print on a tag: code, purity, gross / less / net weight, HUID, design code, making, wastage, price.
11 + 1 scheme register: monthly payments, total paid, shop bonus, maturity value, maturity date and status for every card.
A passbook card to give the customer: 11 instalments + the bonus 12th, due date, paid date, receipt and signature.
Add or remove GST on any amount — gold & silver jewellery 3%, making charges 5% and other rates.
Final price from gold rate, purity, weight, wastage, making charges, stones, hallmark and 3% GST.
Value of old gold from weight, touch (purity), rate and deduction — and the balance on a new bill.
Maturity value of a monthly gold scheme — bonus instalment, % bonus or saving in grams.
Set up your stock, print labels and make your first GST bill today — our team helps you import your data.