Suggestion for a coin inventory log.

I just decided I need to work on inventorying my rather small but growing collection. Yes, I know I can use a spiral bound notebook but I would really rather have a real coin inventory journal. I am working on a rather tight budget, so that comes in to play also. Any suggestions? Thanks all.

 

Log in or Sign up to hide this ad.

I use an Excel spreadsheet. I can track whatever coin information I want to see and change it to meet circumstances.

 

I'm in the same situation where I want to inventory my coins before my collection gets big enough that it's overwhelming, lol. At first I thought about buying software or using something online, USAcoinbook for example I think is one I looked at.

In the end, I started making Excel spreadsheets, it's just the easiest way and I can include or exclude as much info as I like. As far as cost, I don't actually use Excel I use the OpenOffice software pack which is totally free to download and will read Microsoft documents and sheets no problem.

 

Excell works well for me, took a while to work out a system but once you have one stick with it.

 

I prefer MS Excel worksheets... you're able to sort your input based on how you designed your columns and then "insert", "copy" your input of coin-data as you feel comfortable... it's also easier to store onto a "flash drive" or CD-Rom disc. I just wonder what will come in our future for such programming, I'm not fond of iCloud programming... that's 'cause I'm old-fashioned !

 

I use excel too.
I've owned it for years, so it's been paid for a long time ago.

 

I downloaded this software to help me since i had a ton of world coins and it was free.

 

Thanks for the input guys. I guess I figured out my own answer. I had a new empty binder and then I did a search on the internet and found these very useful free coin inventory sheets to print out. Will work out fine. They print very well and easily. That is good for an old poot like me. I like free. Here is the sight if anyone is interested.
http://libertycoinservice.com/collector-checklists/

 

Thanks for the link.

 

I've been using WPS spreadsheets, from Kingsoft. It's a freeware clone of excel.

 

I use Google Sheets.

I put in some raw data, and it spits out a bunch of other interesting info.

 

Like most of the others, I use an excel sheet. I also have clickable links for a photo of that specific coin, and a link to the PCGS/NGC page for that coin (where applicable).

The sheets in the link are ok, but if you have multiples of a coin, it can be lacking.

 

I use Excel. I created one sheet i liked than copied it for the other denominations. I also created some crazy Morgan sheets (2) to track my collection. they are complicated and OCD driven.

 

This looks sort of promising actually, of course I already started making up spreadsheets but I was playing with this software and it's pretty neat.

 

Its easy access too on the go.

 

I started a paper log about 40 years ago. I log every coin as soon as I get it. About once a year, I'll load the coins into the software I use. I'm using Coin Elite because I was too lazy to build a spreadsheet.

 

It is more fun if you just go through all your coins every five years or so. You always find something different.

 

As an "old-timer" who has used "spreadsheets" since VisiCalc was introduced in the late 70s, through Lotus123, Multiplan, Qpro, Excel, Suncalc, etc, still using Qpro which I found to be the most versatile. Syntax since Lotus123 has been very similar between "spreadsheets", and Qpro has general capability of Excel without complexity.

It's believed that Microsoft will eventually destroy a good concept as done since developing NTFS, generally eliminating backwards compatibility with Fat32, Dos, etc.. The older spreadsheets can't be converted/updated to Excel, or even printed after XP/Vista became unsupported or compatible with browsers or newer Microsoft seeming more incompatible Operating Systems.

I strongly suggest that whatever is used as a library/index for possessions, a "hard copy" should be generated, as I found necessary for my 7 figure "collection", documented on numerous inter-linked spreadsheets which can hardly be accessed or even printed.

Just think of the future negative potential with "cloud technology" where your data is possibly available/owned controlled by ?

JMHO