The Jewelry Management System Web App runs an entire jewellery showroom from 19 connected screens inside one Google Sheets app, tracking gold by purity and weight across sales, old gold exchange, inventory and karigar job work. It supports 8 user roles, costs a one-time $39.99 instead of $25–$90 per user per month, and runs entirely in your own Google account with no servers to manage.
Most small and mid-size jewellers still juggle manual bill books, separate stock registers and a karigar diary, which makes it hard to know real-time receivables, active stock value or which pieces are still with the karigar. This Jewellery Shop Software brings billing, old gold, purity-wise inventory, accounts and reports together so the whole showroom works from a single source of truth.
🚀 Try the Live Demo Before You Buy
We have deployed this web app in our own Google account so you can test every page, every role — with real sample data — before purchasing. No signup, no email required.
🔑 Test Login Credentials
Sign in as admin for full system access, or explore role-specific permissions as manager, sales, purchase, inventory, karigar, accounts, or read-only viewer.
💡 What you get after purchase: The full source code (Code.gs + Index.html) plus a step-by-step deployment guide so you can deploy your own private instance in your own Google account in under 15 minutes.
Key Features of the Jewelry Management System Web App
Built on Google Sheets and Google Apps Script, every screen in the Jewelry Management System Web App is connected, so a sale, an old gold entry or a karigar job updates inventory, accounts and reports automatically.
- 🔐 Eight role-based logins: Admin, Manager, Sales, Purchase, Inventory, Karigar, Accounts and Viewer each see only the screens relevant to their job.
- 📊 Live dashboard: 8 KPI cards (Today Sales, Today Purchase, Today Old Gold, Today Expenses, Receivables, Payables, Active Stock Value, Pending Karigar Jobs) plus charts for Revenue by Day, Sales and Purchase by Date, Inventory by Category, Gold Weight by Purity and Sales by Category.
- 💰 Sales, billing and old gold: Create invoices with net, paid and balance amounts, manage customer orders and repairs, and record old gold purchase and exchange with purity, net weight and final value.
- 🏷️ Tagged inventory: Track each piece by tag number, metal, purity, net weight and sale rate, with purity-wise stock showing gross, stone, net, fine, reserved, in-karigar and sold weight.
- 🔨 Karigar job work: Issue, receive and track workshop jobs with issue weight, expected return date and status, plus a karigar master with labour rates.
- 🧾 Accounts and reports: Record receipts and payments, log expenses, set daily rate master values and generate filterable reports you can export and print.
Dashboard Pages Explanation
The Jewelry Management System Web App opens with a secure login and then gives you 19 connected screens. Here is what each screen does.
Dashboard – KPI Cards
The dashboard opens with date and metal filters and eight KPI cards covering Today Sales, Today Purchase, Today Old Gold, Today Expenses, Receivables, Payables, Active Stock Value and Pending Karigar Jobs.
Dashboard – Charts
The charts section visualises the business with Revenue by Day, Sales and Purchase by Date, Inventory by Category, Gold Weight by Purity and Sales by Category.
Sales and Billing
Create and manage every sales invoice with Sales ID, bill date, customer, sales type, net, paid and balance amounts and payment status, then print, email or edit each bill.
Customer Orders
👉 Click here to purchase the Jewelry Management System Web App.
Handle custom orders, bookings and repairs with Order ID, date, customer, order type, metal type, delivery date and status such as Open and In Production.
Old Gold and Exchange
Record old gold purchase and exchange with Old Gold ID, date, customer, transaction type, purity, net weight, final value and approval status.
Customers
Keep the full customer master and history with Customer ID, name, mobile, city, customer type, outstanding balance and active status.
Purchases
Track supplier purchases and inward stock with Purchase ID, date, supplier, invoice number, purchase type, total amount, balance amount and payment status.
Suppliers
Maintain your vendor master and ledger with Supplier ID, name, contact person, mobile, city, outstanding balance and active status.
Item Master
👉 Click here to purchase the Jewelry Management System Web App.
Manage tagged jewellery inventory with Item Code, tag number, product name, category, metal type, purity, net weight, sale rate, location and status.
Inventory and Stock
See purity-wise stock with cards for Total Pieces, Net Weight, Fine Weight and Stock Valuation, plus gross, stone, net, fine, reserved, in-karigar and sold weight and a stock adjustment option.
Rate Master
Set daily metal and purity rates with Rate ID, date, metal type, purity, purchase rate, sale rate and old gold rate so every bill uses the correct rate.
Karigar Job Work
Issue, receive and track workshop jobs with Job ID, date, karigar, job type, issue weight, expected return date and status such as Issued, In Process and Returned.
Karigars
👉 Click here to purchase the Jewelry Management System Web App.
Hold your workshop and karigar master with Karigar ID, name, mobile, skill, labour type and default labour rate.
Receipts
Record customer and party receipts with Receipt ID, date, party type, party name, amount, payment mode and the linked document.
Payments
Record supplier and karigar payments with Payment ID, date, party type, party name, amount, payment mode and the linked document.
Expenses
Track business expenses with Expense ID, date, category, paid to, amount and payment mode for a clear view of showroom spending.
Reports
Generate filterable business reports by selecting a report type such as Sales Person-wise, setting a date range and customer or supplier filter, then generate, export and print.
User Management
Control users, roles and access with User ID, name, username, role, active status and last login across all eight roles.
List Management
Control every dropdown value used across the app with List Type such as Category, value, sort order and active status.
Jewelry Management System Web App vs. Excel/Desktop Jewellery Software vs. Paid Jewellery POS SaaS — Feature Comparison
| Feature | Jewelry Management System Web App | Excel / Desktop Jewellery Software | Paid Jewellery POS SaaS |
|---|---|---|---|
| Cost | $39.99 one-time | $0–$300 one-time | $25–$90 / user / month |
| Platform | Google Sheets (web, any device) | Windows desktop only | Vendor cloud |
| Setup time | Under 15 minutes (Make a Copy) | Manual install | Onboarding + training |
| Real-time team access | ✅ Yes — 8 roles | ❌ One file at a time | ✅ Yes |
| Old gold & exchange | ✅ Built in | ⚠️ Limited | Higher tier |
| Karigar job work | ✅ Built in | ❌ Rarely | Add-on |
| Purity-wise inventory | ✅ Built in | ⚠️ Manual | ✅ Yes |
| Owns the data | ✅ Your Google account | ✅ Your PC | ❌ Vendor servers |
| Year-1 cost at 5 users | $39.99 total | Varies | $1,500–$5,400 |
For jewellers who want billing, old gold, inventory and karigar control without paying $25–$90 per user every month, the Jewelry Management System Web App sits in the sweet spot.
Who Should Use This Template
Perfect for:
- Single-showroom and family-run jewellers with 1–20 staff who want sales, billing and stock in one place
- Owners who buy and exchange old gold and need purity, weight and final value against each customer
- Shops that issue work to karigars and track issue weight, returns and labour by job
- Jewellers who prefer a one-time Google Sheets app over monthly POS software
Not a fit if:
- You are a multi-branch chain needing barcode/RFID hardware, BIS hallmark integration and full ERP
- You require offline desktop software with no Google account
- You need SOC 2, SSO and enterprise audit certification out of the box
Real-World Use Cases
👉 Click here to purchase the Jewelry Management System Web App.
Suresh runs a single-counter gold showroom in Jaipur. He bills sales, records old gold exchange at the day’s rate from Rate Master, and watches Receivables and Active Stock Value on the dashboard — without paying a monthly jewellery software fee.
Meena owns a jewellery shop with three karigars. She issues job work with issue weight and expected return dates, sees which pieces are in-karigar versus sold in purity-wise inventory, and settles karigar labour through the Payments screen.
Arjun manages a family store with separate sales and accounts staff. He gives each person a role-based login, updates daily metal rates, and runs sales person-wise and outstanding-dues reports for his accountant every month.
Advantages of the Jewelry Management System Web App
Because the Jewelry Management System Web App runs on Google Sheets and Google Apps Script, your data stays in your own Google account, the app works on any device with a browser, and there are no per-user fees. A single $39.99 purchase replaces software that often costs $1,500–$5,400 per year for a 5-user shop, and the connected design means a sale or old gold entry updates inventory and accounts instantly.
Opportunities for Improvement
The Jewelry Management System Web App is built for small and mid-size showrooms, so it does not include barcode or RFID scanning hardware, automated BIS hallmark registry integration, or multi-branch consolidation out of the box. Very high-volume chains may eventually outgrow a Sheets backend, and shops that need fully offline use without a Google account should consider a desktop tool instead.
Best Practices
Set your daily rates in Rate Master each morning so every bill and old gold entry uses the correct value. Keep the Item Master tagged and up to date so purity-wise inventory stays accurate, and reconcile Receipts, Payments and Expenses weekly so Receivables and Payables on the dashboard always reflect reality. Assign the narrowest role each staff member needs to keep your data secure.
Explore Relevant Templates
If you run other retail or service shops, these Google Sheets web apps pair well with the Jewelry Management System Web App:
- Tailor Shop and Stitching Management System Web App
- Salon and Spa Management System Web App
- Vehicle Movement Register Management System Web App
- Customer Address Book Web App
Frequently Asked Questions
👉 Click here to purchase the Jewelry Management System Web App.
What does the Jewelry Management System Web App include?
The Jewelry Management System Web App includes 19 connected screens — login, dashboard, sales and billing, customer orders, old gold exchange, customers, purchases, suppliers, item master, inventory, rate master, karigar job work, karigars, receipts, payments, expenses, reports, user management and list management.
How many user roles does it support?
The Jewelry Management System Web App supports eight roles: Admin, Manager, Sales, Purchase, Inventory, Karigar, Accounts and Viewer, so each person only sees the screens and data relevant to their job.
Can it handle old gold exchange and karigar job work?
Yes. The Jewelry Management System Web App records old gold purchase and exchange with purity, net weight and final value, and tracks karigar job work with issue weight, expected return date and status such as Issued, In Process and Returned.
Do I need coding or a server to run it?
No. The Jewelry Management System Web App runs on Google Sheets and Google Apps Script. You make a copy, deploy it as a web app from your own Google account, and start using it — no server or coding required.
How does this compare to paid jewellery POS software?
Paid jewellery POS SaaS usually costs $25–$90 per user each month. The Jewelry Management System Web App is a one-time $39.99 purchase with no per-user fees, and your data stays in your own Google account.
How long does setup take?
Most showrooms are running in under 15 minutes. You copy the file, set your shop profile, add staff and roles, fill the item, rate, supplier and karigar masters, and begin billing the same day.
About the Author
Built by PK — Microsoft Certified Professional with 15+ years of Excel, Google Sheets, and Power BI experience. Founder of NextGenTemplates, reaching 300K+ subscribers across YouTube channels. Every template is hand-built and tested before release.
Conclusion
The Jewelry Management System Web App gives a jewellery showroom one connected place for billing, old gold, purity-wise inventory, karigar job work and accounts — without monthly per-user fees. 👉 Click here to purchase the Jewelry Management System Web App.
✅ Instant download · One-time payment · No subscription. 🎥 For step-by-step tutorials, visit YouTube.com/@NeoTechNavigators.
Last updated: June 2026
