Back to blog
Jobs, stock and customers

Jewelry inventory software: what it costs, and when a spreadsheet stops working

Jewelry inventory software compared: six tools and what they cost, a spreadsheet to copy, memo and consignment tracking, and when to switch.

Start from the inventory template

Know what's in stock and reorder in time.

Use the template, free
On this page

Jewelry inventory software keeps one record for every piece: its stock keeping unit (SKU), metal, weight, stones, cost, price and the case it’s in. A spreadsheet can do that for a small stock. Software earns its price when several people sell, when memo and consignment pieces get mixed in with yours, or when the case count never matches.

This guide is for owners of small jewelry stores and makers who sell at shows and online. You get a record for one piece, a spreadsheet layout to copy, a routine for counting a tray, six tools and what they cost, and the signs a spreadsheet has run out.

How we researched this: in November 2026 we checked every price, plan and feature below on each vendor’s own pages. Prices change often, and some vendors only quote on request.

Your jewelry businessStart with
A small stock, one or two peopleA spreadsheet, laid out as below
You make the pieces and sell at shows and onlineMaker software such as Stocksmith
A store with a till, repairs and appraisalsA jewelry store system such as The Edge or Jewel360
You sell mostly online, on several marketplacesValigara
Plain stock tracking with photos and labelsSortly or SalesBinder
One-of-a-kind pieces, memo, a few staff, no tillAn app you build with GoodTaco

Prices run from free to $600 a month in November 2026. See what each costs.

What should you record for each piece of jewelry?

Most pieces are one of one, so each gets its own record rather than a line in a count of identical things. Write down:

  • SKU. One number per piece, written on its tag.
  • What it is. Type, metal and karat (K), such as 14K white gold, total weight in grams (g), ring size or chain length.
  • Stones. Kind, carat weight (ct), shape and grade for each stone, any treatment such as a heated sapphire, and the lab report number for a certified stone.
  • Cost and price. What you paid, what the tag says, the margin between them, and the appraised value if it has one.
  • Where it is. The case, tray or safe it sits in right now.
  • Whose it is. Yours, on memo from a vendor, or on consignment from a maker.
  • Where it came from. The vendor, maker or estate, with the invoice or purchase order (PO) number.
  • A photo. One clear picture of the piece.

A spreadsheet can hold every one of those facts in a column. What a single row can’t hold is the history: where the piece has been, and who moved it. You need that on the day a ring isn’t where the sheet says it is.

Not everything is one of one. Stock bands in sizes 5 to 10, studs, chain and gift boxes are bought in quantity, so they get a count, not a record each.

Tag every piece with its SKU as a barcode. A USB or Bluetooth scanner types the code into a search box like a keyboard, so scanning a tag finds the piece. Counting with radio-frequency identification (RFID) tags is a store-system feature; The Edge lists it.

Already keep these in a spreadsheet? You don’t have to retype them. Upload the file on our spreadsheet to app page, with no account needed to try, and GoodTaco builds an app with a record for each piece.

How do you track jewelry inventory in a spreadsheet?

Use one row for each piece, and never delete a row when a piece sells. Here is a jewelry inventory template to copy. Cost, Price, Date in and Date out are what they say.

ColumnWhat goes in it
SKUThe number on the tag, such as RNG-204
PieceWhat it is, such as Oval sapphire halo ring
TypeRing, earrings, necklace, bracelet or pendant
Metal14K white gold, platinum or sterling silver
Weight (g)Total weight in grams
StonesKind, carat weight and shape, such as Sapphire 1.20 ct oval
MarginWorked out by a formula, below
WhereThe case or tray, such as Case 2
OwnershipOwn, Memo or Consignment
FromThe vendor, maker or estate it came from
StatusIn stock, Sold or Returned
Due backFor a memo piece, the date to pay or return it
NotesRing size, lab report number, invoice or PO number

Make Type, Metal, Ownership and Status dropdown lists, so nobody types memo five ways. Excel and Google Sheets both call this Data validation (Microsoft, Google).

To start without typing, paste this into cell A1 of a new sheet, then split it. In Excel, choose Data > Text to Columns, pick Delimited and tick Comma (steps). In Google Sheets, choose Data > Split text to columns (steps). Dates are month, day, year. If Date in doesn’t line up on the right, as dates do, format the column as a date.

SKU,Piece,Type,Metal,Weight (g),Stones,Cost,Price,Margin,Where,Ownership,From,Status,Date in,Date out,Due back,Notes
RNG-204,Oval sapphire halo ring,Ring,14K white gold,3.4,Sapphire 1.20 ct oval; diamonds 0.32 ct total,1180,2950,,Case 2,Own,Meridian Gem Co.,In stock,10/3/2026,,,Size 6.5
RNG-211,Solitaire engagement ring,Ring,Platinum,4.1,Round diamond 0.70 ct; G color; SI1 clarity,2900,5800,,Case 2,Memo,Meridian Gem Co.,In stock,10/15/2026,,12/15/2026,
EAR-118,Freshwater pearl studs,Earrings,14K yellow gold,1.1,Pearls 7 mm,84,240,,Case 1,Own,Harbor Pearl,Sold,9/12/2026,10/24/2026,,Invoice 3382

Five formulas do the sums, the same in Excel and Google Sheets. Type the first in I2 and fill it down, and the others in empty cells to the right, such as S2 to S5. They read whole columns, so new rows count:

  • Margin on a piece (I2): =IF(H2>0,(H2-G2)/H2,""), shown as a percent
  • What you own, at cost: =SUMIFS(G:G,M:M,"In stock",K:K,"Own")
  • Pieces in Case 2 right now: =COUNTIFS(J:J,"Case 2",M:M,"In stock")
  • Pieces that have sat for a year: =COUNTIFS(M:M,"In stock",N:N,"<"&TODAY()-365)
  • Memo pieces due back within a week, or late: =COUNTIFS(K:K,"Memo",M:M,"In stock",P:P,"<="&TODAY()+7)

With the three example rows, RNG-204’s margin is 60%, what you own at cost is $1,180 (the memo ring and sold studs don’t count), and Case 2 holds 2 pieces.

For findings, bands in a run of sizes and other things you buy by the dozen, count a quantity instead, as our guide to inventory management in Excel shows.

When does a spreadsheet stop working for jewelry inventory?

Stay on a spreadsheet while one person keeps it, the stock is small and you’ve never found a piece in the wrong case. It starts costing you when:

  • Two people sell from one list. A sheet won’t stop the same one-of-one piece being promised twice, once at the counter and once on the phone.
  • Nobody can say who moved a piece. A sheet shows where a piece is now, not where it’s been. When RNG-211 is gone, you want to know who last had it.
  • Memo and consignment pieces blur into your own. The stock total counts what you don’t own, and nobody remembers the return date.
  • Pieces leave the shop. At a show, on approval or in a bag going to a customer’s house, the sheet stays on a desk. On a phone, a 17-column sheet is hard to read and easy to break.
  • The count never matches. Corrections overwrite the cell instead of saying what happened, so the same piece goes missing again.

Two or more of these? Move to software, and bring your SKUs, metal, stones and prices with you. For the wider question, see our guide to database vs spreadsheet.

How much does jewelry inventory software cost?

Jewelry inventory software runs from free to $600 a month and up. In November 2026, general stock apps started free, maker tools at $24, Jewel360’s store system at $199, and Valigara at $600. The Edge quotes on request. Setup fees, hardware and card fees are extra.

An example: a shop with three staff and 2,500 pieces would pay about $19 a month on SalesBinder, $49 on GoodTaco or Stocksmith, $199 on Jewel360 and $299 on Sortly. SalesBinder and Sortly cap how many records or items they hold, and 2,500 pieces outgrow their cheaper plans.

These tools do different jobs. Jewel360 and The Edge run a store with a till, Valigara runs online selling, and the others keep stock only. For general stock software priced for three and eight people, see inventory management for small business. The text version, with each pricing page:

ToolPrice, November 2026
SalesBinderBronze $19 (5 users, 5,000 records); free plan holds 100
Stocksmith (formerly Craftybase)Pro $24 ($20 billed annually); Studio $49; Indie $99
GoodTaco (our product)Free to start; Pro $49 a month includes 10 users
Jewel360Startup $199 ($299 crossed out), plus $750 setup; Core on request
SortlyPremium $299 (5,000 items); Ultra $149 holds 2,000
ValigaraFrom $600 a month, plus a one-time setup fee
The EdgeNo price listed; a quote from its calculator or a demo

Which jewelry inventory software should you choose?

Jewelry software falls into four kinds, and the right one depends on how you sell. Here are six products, described from their own websites, in no particular order.

Jewelry store systems with a till

These run the whole counter: sales, repairs, customers and stock.

  • The Edge is a retail platform for jewelry stores, with point of sale (POS), inventory, repairs and custom work, and e-commerce. Its inventory page lists each piece tracked on its own, with diamond details, cost, margin and aged stock, barcode and RFID counts, and memo and consignment kept apart from owned stock (The Edge).
  • Jewel360 is a jewelry system for stores. Startup includes unlimited users and products, point of sale, payments and basic purchasing. Core adds tracking of each piece on its own, memo, consignment, repairs and appraisals, and has no published price. Jewel360 says it rebates the $750 setup fee once you go live and process payments with it.

Software for selling jewelry online

  • Valigara is built for jewelers, brands and diamond sellers who list online. It handles listings on marketplaces such as Amazon, eBay and Etsy, keeps stock in step across channels, and prints barcodes, with gemstone fields (Valigara features).

Tools for makers

  • Stocksmith, formerly Craftybase, tracks the wire, stones and findings you buy, works out what each piece costs to make, and syncs stock from Etsy and Shopify. Its own jewelry page says it isn’t designed for retail-only jewelry stores (Stocksmith jewelry page, plans).

General inventory apps

  • Sortly adds custom fields and photos to each item. Its jewelry page mentions one-of-a-kind pieces, a vault or safe, and scanning barcodes from a smartphone. Each piece counts as a unique item, and each plan caps how many it holds (Sortly jewelry page).
  • SalesBinder is general inventory with invoices, estimates and purchase orders. Its jewelry page covers tracking rings, necklaces and gems, locations and zones, and scanning barcodes. Its record limit counts every SKU, customer and invoice (SalesBinder jewelry page).

Other lists also name Lightspeed Retail and wJewel. We haven’t priced those.

What free jewelry inventory software is there?

Free plans are general stock tools, not jewelry systems. In November 2026, Zoho Inventory’s covered 1 user, 1 location and 50 orders (Zoho Inventory pricing). Sortly’s covered 100 unique items for 1 user, and SalesBinder’s 100 active records for 1 user. Stocksmith and SalesBinder offer free trials, and a spreadsheet costs nothing if you have Excel or Google Sheets. The jewelry store systems list no free plan. GoodTaco is free to start.

How do you count a jewelry case or tray?

Count by tray, against a list of the SKUs that belong in it. A count of “about 20 rings” tells you nothing. Whichever tool you use, here is a routine that works for most shops. Print this page if you want it on paper.

  1. Print the list for one tray. Every SKU that should be in it, with its name, size and price. For bands and studs bought in quantity, list each size with its count.
  2. Use two people. One reads each tag aloud, and the other ticks it off. Nobody counts a tray alone.
  3. Count your most valuable cases before opening and after closing. Count the rest once a week.
  4. Look elsewhere before you call a piece missing. Check the bench, the window, the safe, the sold list and any piece out on approval.
  5. Fix the record the same day. Write down what was missing and who found it, rather than quietly changing the sheet.
  6. Count everything once a year, and keep the records. Jewelers Mutual advises a detailed, itemized yearly count, keeping inventory records for at least seven years, and says good records help a claim settle faster (Jewelers Mutual).

How do you handle memo, consignment and repairs?

Memo means a vendor lent you a piece. It usually comes with a date to pay for it or send it back, and you answer for it while it’s in your case. Consignment means a maker or private seller left a piece with you. It usually runs until the piece sells, and then you owe the maker their share. Either way, it sits in your case but isn’t yours. Keep both in the same list, mark each one, name who owns it, give memo pieces a due-back date, and leave them out of your stock value (The Edge’s help treats both as owed once sold).

A customer’s ring left for sizing isn’t your stock either. Give it a repair ticket, not an inventory record: the customer and phone, the piece and its condition, the work, the quote, the deposit and the date promised.

Can you build your own jewelry inventory app?

Yes, when a till system is more than you need but a spreadsheet has stopped being enough. Our guide to an inventory app without code covers the idea. It opens in a browser on a phone or a computer, as a web app link.

An app like this fits a shop with no till system, a maker selling at shows, or a store that wants its own list of memo pieces and counts.

The inventory management template tracks items by quantity across locations, with stock moves and purchase orders. Its sample is a plumbing and heating shop, so you rename things: items become pieces, locations become cases, suppliers become vendors. A one-of-a-kind piece is an item with a quantity of 1 in a case. You get:

  • A record for each piece. SKU, category, cost and price with the margin worked out, notes, the count in each case, and a history of each Take out, Receive, Move and Count with who made it, from their sign-in, and when. Undo removes the line it takes back.
  • Search by name, SKU, vendor’s part number or category. A USB or Bluetooth scanner types like a keyboard, so it can enter a code in the search box.
  • Cases. Each case is a location, and the locations page shows what’s in each and what it cost. Make Show bag or Out on approval a location too, so a piece that leaves is a move, not a hole in a case.
  • Four buttons on every piece. Take out for a sale asks how many, then an optional note such as the invoice number. Receive, Move between cases, and Count, to fix one piece’s number in one case, do the rest. Each save has an Undo, and nobody can take out a piece the app says isn’t there.
  • Vendors and purchase orders. Order with a purchase order and receive the pieces into a case.

When a piece sells, archive it from the piece’s menu, which keeps its history, or ask GoodTaco to archive a piece as soon as you take it out.

Ask GoodTaco to add the jewelry details. Type this first; the scene shows it done:

Turn this into a jewelry stock app: pieces, cases, metal, weight and stones.

Then ask for the rest, one request at a time. The second:

Add an Ownership column to every piece: own, memo or consignment. Give memo pieces a due-back date, and leave memo and consignment pieces out of the stock value.

You can also ask for a barcode made from each SKU as a customer’s app has, a printable page of each case’s pieces, and appraisals or repair tickets. Ask GoodTaco to hide cost and margin from roles that shouldn’t see them. Make the app private so only people you invite can sign in.

Track your jewelry stock with GoodTaco

Picture a store with three cases and a safe. The sapphire ring in Case 2 sells, and the sale is a few taps on Take out, with the invoice number in the note. On Friday morning two people count tray 3 against its list, and the missing memo ring gets caught before the vendor calls for it.

GoodTaco builds apps like this in minutes. You change them by chatting, and every version is saved with one-click rollback. One of our paying customers keeps its jewelry stock in a GoodTaco app, with a SKU and a barcode for each piece. There are two ways to start:

  • Start from your spreadsheet. If your columns are already right, with metal, weight and stones, upload the file. GoodTaco brings your pieces into the app’s own built-in database, turns columns of repeated choices such as Type, Ownership and Status into dropdowns, and rebuilds the formulas it can reproduce exactly. Start with one case and see it work.
  • Or start from the inventory management template, which adds the history and the Take out, Move and Count buttons. Your copy comes with plumbing and heating sample records: rename them, or clear the sample and start empty, then ask for your columns.

Staff sign in through your GoodTaco workspace, or you invite them to a private app. A stock list shows what you own and where it is, so keep it private. Set a part-timer’s role to Viewer in the Users tab and they can look a piece up but not change it. GoodTaco is free to start. Paid plans start at $9 a month, and Pro at $49 a month includes 10 users; bigger teams talk to us about Enterprise.

Know what’s in every case, and whose it is. Start free, no credit card needed.

Frequently asked questions

What is the best jewelry inventory software?

It depends on how you sell. Jewelry store systems such as The Edge and Jewel360 suit a store with a till, repairs and appraisals. Valigara suits sellers who list on several online marketplaces, and Stocksmith (formerly Craftybase) suits makers who track materials and cost per piece. Sortly and SalesBinder are general inventory tools. A spreadsheet or an app of your own fits a small stock with memo and consignment pieces and no till.

How do jewelers keep track of inventory?

Each piece gets its own stock keeping unit (SKU) on a tag and its own record with metal, weight, stones, cost, price and the case it's in. Cases or trays are counted against a list, the whole stock is counted once a year, memo and consignment pieces are kept apart from the shop's own stock, and every move is written down. Small shops do this in a spreadsheet, and larger ones use software.

Is there free jewelry inventory software?

Yes, with limits. In November 2026, Zoho Inventory's free plan covered 1 user, 1 location and 50 orders, Sortly's covered 100 unique items for 1 user, and SalesBinder's covered 100 active records for 1 user. All three are general stock tools. Stocksmith offered a 14-day trial and SalesBinder a 30-day one, and a spreadsheet costs nothing if you already have Excel or Google Sheets. Jewel360 and The Edge don't list a free plan. GoodTaco is free to start.

How much does jewelry inventory software cost?

Jewelry inventory software runs from free to $600 a month and up. In November 2026, Jewel360's Startup plan showed $199 a month with $299 crossed out, plus a $750 setup fee that its page says is rebated once you go live and process payments with it. Valigara started at $600 a month plus a one-time setup fee, Sortly's Ultra plan was $149 a month, Stocksmith's Studio plan was $49 and SalesBinder's paid plans started at $9. The Edge lists no price and quotes on request. GoodTaco's Pro plan is $49 a month and includes 10 users.

Can I use a spreadsheet for jewelry inventory?

Yes, while the stock is small and one or two people keep the sheet. Give every piece one row with its SKU, metal, weight, stones, cost, price, case and status, never delete a sold piece's row, and count each case or tray against the sheet. It stops working when several people sell from it, when memo and consignment pieces blur into your stock value, or when you need to know who moved a piece.

How do you track memo and consignment jewelry?

Keep them in the same list as your own pieces, but mark each one Own, Memo or Consignment and name the vendor or maker. Give memo pieces a due-back date, leave memo and consignment pieces out of your stock value, and count them with the rest of the case.

Can I scan barcodes for jewelry inventory?

Yes. A USB or Bluetooth barcode scanner types the code into a search box the way a keyboard does, so a tag with the SKU as a barcode finds the piece. A GoodTaco app can show a barcode made from each SKU if you ask.

Customer story Active Trailers turned five spreadsheets into one app for 350+ trailers. “Every time a unit got wrote up, we had to fill out all the spreadsheets, and then we had a checklist for the checklist.” MW Myka Ware Active Trailers Read their story
Free template

Start from the inventory template

Get your own copy of a working inventory app with sample records, ready to make yours. Free to start.

Use the template, free

Or turn your own sheet into an app

Keep exploring

Related guides and templates

View all articles

Guide

Medical supply inventory: par levels and expiry dates

Medical supply inventory for a clinic: a supply list to copy, how to set par levels, an expiry routine, recall checks and what the tools cost.

Guide

No-code inventory management app from a Google Sheet

How to keep track of inventory as it grows, and how to turn your inventory spreadsheet into an app your team can update from a phone or tablet.

Guide

Inventory management in Excel: a free 7-step stock system

Set up inventory management in Excel for free: two sheets to copy, the SUMIFS formula for stock on hand, a reorder flag, and when to move to an app.

Customer story

How Active Trailers stopped trailers leaving the yard uninsured

Five spreadsheets and software that charged $1,600 per change became one app for 350+ trailers.