I'm putting together a coin inventory, and I was wondering what software & websites everyone else uses. What are the features you look for? Does your insurance co. require any special format?
Heritage, NGC and PCGS all provide online services similar to what you're asking. There are other packages that allow you to do so on your PC. Personally, I use an Excel spreadsheet. My insurance company requires receipts.
I have a Mac and so I can't use the Coin inventory software that is available unless I use virtualization software or install Windos on my Mac, which I won't be doing . What I do use is a software called Bento. It's basically a database software program for people who don't know how to create databases. It's more drag and drop data fields and elements to set up the database so it's easy to use. They also have an online template exchange where user can post template databases they created to share with others.
Are there any windows based programs that aren't too expensive? I've also been throwing the idea of inventorying my collection in a more organized way.
I just use excel. I make different tabs for different coins, and list the years I have as well as each coin individually
I hope I'm not hi-jacking your post George, I do apologize if I am. I bunch of questions just hit me like a truck. Is there anyway the EXCEL users can post their layouts? I have been kicking the idea around for a while as well but don't know where to start. I really don't have the money to spend on a program to do it. I have TONS of coins most aren't worth a whole lot but in total they are. I would just like to see how you have chosen to do the layout. Do you have ALL your coins listed even commons? If not what criteria are you using? Do you enter values? If so, where are you getting them from, RedBook or other sources. I know this is a bunch of questions at once sorry. Thanks George this is a really good topic!
I use coin elite, but if you search for excel on this site I think a couple attached their formats to their post. Maybe search on coin inventory or something like that also. Anyway I like coin elite and I pay for an upgrade every 2 years or so.
I currently use excel, with a different tab (aka worksheet) for each binder, lockbox, or storage box. I use a slightly different page layout for medals vs. coins, but my general layout looks like: A: Country of Origin B: Date C: Mintmark D: Denomination E: Notes (ie; slabbed, rim dings, rotated reverse, etc) F: Condition / Grade G: Purchase Price (if recorded) H: Estimated Purchase Price (if not recorded, otherwise I copy G over) I: Date of purchase J: Estimated value K: ASW L: AGW M: Index number (a 1 copied down) At the bottom of each worksheet, I total up and average the columns (using the =AVERAGE and =SUM formulas). I'm currently creating a separate photo inventory system, but I understand that some software allows you to integrate photos and scans of receipts.
Can you use those programs to index coins that aren't registered or purchased through them though? I thought you could only index NGC slabbed coins on the NGC site.
That sounds a lot like using Excel. Are there any additional benefits to Bento? What do you like about using it vs. other alternatives?
I use a program from a company called Data Village, It is called Data tracker for coins. I picked it up on ebay for $10.00. You could download a trial version that is good for 30 days. http://www.datavillage.com/VTCoins.htm I really like it, all of its fields are changeable . Very easy to use and customize.
I use paper and a pen , spreadsheet and a home and Bank safe . I really don't want my personal financial information out there in cyberspace .
I have to agree with you on that one. We have 7 pc's one of which doesn't connect to the internet at all. We keep photo's and other important info on it. That PC gets backed up on a 2T external drive on a daily basis. When I finally figure out what I'm going to use it will be on that pc. Thanks for the info George and everybody else!
I came across this website while researching a coin - anyone familiar with Numista's inventory program? I can already see a problem in that it doesn't track varieties very well (try adding a Type 3 1853 penny): http://en.numista.com/catalogue/pieces4721.html
Always remember, Convenience always has a price tag . More often than not, it's a fairly hefty one , once you figure and tag all the potential " Risks " .
It's similar but not the same Except that the setup is so easy and if you don't want to set up the initial template you can download one from the Bento Template Exchange and customize it. It also let's you add Media Fields so you can have pictures of the coins with each record or video or audio notes if you like as well. It also let's you use the Apple OS Address book as a source of data that you can then use on the coin record to indicate what dealer you bought it from with just a few clicks. In terms of what I like compared to the other alternatives is that Bento is specifically designed for the Mac and takes advantage of the OS a lot more than Excel can or any other PC only program that I would have to use via virtualization. I know there is Excel version for Macs but I like the graphical interface that I created with Bento a lot more than inputting data in cells plus I was able to set up a lot of drop down boxes so not as much to input by typing. If I ever needed to I can export my Bento database into an Excel format. It all really comes down to personal preference. There is no right or wrong way, generally speaking, to track your coins. It's what works best for you
I use the Heritage site for my inventory. I like the fact it is updated automatically with new retail and wholesale pricing, plus access to all of their auction records. You can print out anything if you need a hard copy for your records. Certain information stays in your own computer and the program uses it to complete your spreadsheets. You can also participate and share, at your discretion, with other services they offer. All at no cost to the individual. I have used their program for about three years now, and I am very pleased with it.
Here are my column headers: Year Variety Type Denom. Descr. Strike Metal Value Grade TPG TPG # Price Source Date SoldFor SoldTo Notes