Have you ever used a spreadsheet? I have a Mac and use Microsoft
Xcel for my gemstone inventory. I know there are software programs
specifically designed for the jewelry industry, but I like the way
you can customize with MS Xcel and I already had experience with it.
I've designed my inventory with several columns of such
as an ID#, gemstone name, color, cut, size, weight, purchase price
and date, and source. I also have a remarks column for information
such as where it is stored, if it has been used in a particular
piece of jewelry, and if it has been sold, etc. I can easily do
sorting and searches on each of my categories/columns.