Gemstone · Avirat

Gemstone inventory software

Coloured stones with the fields the trade actually asks for.

What does Avirat’s gemstone software do?

Avirat’s gemstone software tracks coloured stones — rubies, sapphires, emeralds and more — with the details buyers ask about: variety, origin, treatment, colour grade, cutting type, dimensions and every certificate a stone has (GRS, SSEF, Gübelin, GIA or any lab). It follows stones sent for recut or to a lab and back, with the weight lost and the new report, and uses the same purchase, sale, memo, transfer, accounts and report screens as diamonds, so one system runs both.

Avirat stock list with diamonds and coloured gemstones, their lab and certificate numbers
Features

What you get for gemstone

Gemstone-specific fields

Variety, origin, treatment, cutting type, colour grade, dimensions, lab and certificate number.

Every certificate a stone has

A ruby with a GRS and an SSEF report keeps both, each with what it says, its dates and where the paper is kept — and a list shows certificates expired or running out.

Recut and lab, tracked

Send stones to a cutter to recut or repolish, or to a lab to certify: they stay your stock, marked At cutter / lab. Receive them back with the carat lost, the new shape and size, what the lab found and its certificate.

Weight loss priced in

What a stone cost stays on what comes back, and the cutter’s or lab’s charge is added on top — so the cost per carat after a recut is the real one, and the charge is a bill you owe them.

The same trading workflow

Purchase, sale, memo, returns and transfers work exactly as they do for diamonds — one system, not two.

Parcels and single stones

Track a parcel by pieces and carats, or one stone at a time — pieces and carats checked together on every sale, memo and transfer.

Many stones at once

Tick stones to set the same details or put them on hold for a customer; update certificates and prices stone by stone from an Excel sheet.

Your own reference lists

Varieties, origins, treatments and grades are lists you control, not fixed ones.

Reports and Excel

Stock, ageing and margin reports filtered for gemstones, exported in one click.

Details recorded for every gemstone

Variety and category
Ruby, sapphire, emerald, tanzanite …
Origin
Burma, Sri Lanka, Colombia, Madagascar …
Treatment
Heated, unheated, oiled …
Colour and colour grade
e.g. pigeon blood, royal blue.
Cutting type and shape
From your own lists.
Dimensions
As measured.
Lab and certificate number
GRS, Gübelin, SSEF, GIA or any lab — more than one per stone.
Pieces and carats
Single stones or parcels.
Cost and selling rate
Kept apart, so margin is real.
Also included

Accounts, reports and the rest

Parties and accounts

Customers, suppliers and brokers with full details, payments, credit and debit notes, ledger and outstanding.

Multi-branch, multi-currency

Work across branches and currencies; a branch user sees only their own branch.

Users and permissions

Roles for sale, purchase, memo and accounts staff, with per-person overrides, and optional two-factor sign-in.

Print, PDF and email

Four invoice looks you can edit, a PDF for every document, and one click to email it with the PDF attached.

Reports

Margin, stock ageing, memo ageing and client reports, all exportable to Excel.

Import and export

Bring parties and stock in from Excel; take all of your data out whenever you like.

Make it yours

Add your own fields, rename, hide and reorder what is on each entry screen, and arrange every stock and report grid your way.

A full audit trail

Who changed what, and when — for every stone and document.

Stock you can trust

A stone that is sold, on memo or in transit can’t be sold again — Avirat refuses and names the stone. Memo credit limits and overdue limits are checked on the server, and an override tells the Owner.

Who sees cost, who sees selling

Choose per role or per person who sees cost and who sees selling prices — in stock, reports, labels, scans and exports.

Share stones by link

Send one stone or a whole selection as a catalogue link: photos and details, never your cost. A buyer can register interest, and you are told.

Listings for trading networks

Give your available stock to RapNet and other networks as a listing file or an hourly FTP upload; sold, held and memo stones drop off by themselves.

Real accounts

Trial balance, profit & loss, balance sheet, day book and cash & bank book, straight from your trading entries.

Undo a delete

Deleted an invoice by mistake? Put it back with its number within 90 days.

Reminders that find you

Memos due, payments overdue, holds running out, transfers waiting — in the bell, and in a morning email if you want it.

Deal in more than gemstone? Add diamond or jewellery to the same account — one system, one price that follows what you choose.

Questions

Gemstone software — questions & answers

Can I record treatment and origin?
Yes. Every gemstone stores its variety, origin, treatment, colour grade, cutting type and dimensions, plus the lab and certificate number.
Can a gemstone have two certificates, say GRS and SSEF?
Yes. A stone keeps every certificate it has, each with its lab, number, issue and valid-until dates, the carat, colour, origin and treatment it states, and where the paper is kept. One is the main certificate, shown on labels and prints; search and the scanner find the stone by any of the numbers.
Can I track stones sent for recut or to a lab?
Yes. A send-out takes the stones to the cutter or lab; they stay in your stock as At cutter / lab and can’t be sold or sent on memo meanwhile. When they come back you enter the carat back and lost, the new shape and measurements, what the lab found (colour, variety, origin, treatment) and its certificate. Part of a parcel can come back now and the rest later.
How does weight lost in a recut change the cost?
What the stone cost stays on the smaller stone, and the charge is added. A 1.00 ct stone that cost 1,000 and comes back at 0.90 ct with a 45 charge costs 1,045 — 1,161.11 a carat — so margin on its sale is worked out from the real cost.
Can I run gemstones and diamonds together?
Yes. Choose both products when you sign up; each keeps its own fields, and stock, sales and reports can be filtered by product or seen together.
Can I add my own varieties and origins?
Yes. The lists of varieties, origins, treatments and grades are yours to edit, and you can add a new value right from the entry screen.

Try Avirat for gemstone

14 days free, everything switched on, no card needed.

WhatsApp us