View Full Version : Coin Ledgers
05-26-2013, 11:47 AM
I am getting a new ledger put together this weekend to record my coin purchases and am curious what others do for this. I tried to make a spreadsheet on the computer just to have a saved outline with the columns set up but am going back to my old favorite pen, ruler, and 11x17 paper. I like having it all in a binder with the invoices and handwritten notes. It is interesting to go back and review that stuff from time to time. I will have columns for date purchased, denom, year, variety, grade, obv/ rev notes, price paid, etc. Please share what you all do for ledgers!
05-26-2013, 05:51 PM
I do mine in excel so it is easy to sort / keep in year & sheldon number order, but unfortunately, I didn't do it from day 1 so some of my beginning purchases are in a cloud of mystery.
The two items I didn't see you list I put down is who I bought coin from and die state if there is one
05-27-2013, 01:16 AM
I use a Microsoft Works database. I have 36 fields for each coin and am constantly updating as new information comes along. I like that I can easily change the order of the pieces and do searches for specific data.
05-28-2013, 08:51 PM
I'm a bit old fashioned like yourself, Loupe. I use book keeping ledger sheets to keep track of purchases, keep notes, and so on. I tried the computer thing, and it was ok, but not very practical considering how much I travel. There's nothing I hate more than carrying a laptop everywhere I go.
05-28-2013, 09:58 PM
My first electronic record keeping attempt used Lotus123 software. Many years later I moved it to Excel. I track the specifics of the coin itself as well as the date pruchased, date received (if different), seller and cost information. I would print specific areas of the total spreadsheet to carry in Day Planner sized notebook, recently I have moved to an iPad that lets me carry the entire file as well as research materials.
05-29-2013, 03:04 PM
Thanks for the responses. Although I am partial to paper ledgers, I can see the benefit to using computers and spreadsheets. It would be nice to be able to add columns and refine things as it progresses.
05-29-2013, 08:12 PM
I love taking the laptop along on trips! When my wife is driving, I can scour ebay and other websites, doing lookups and research. To me, it's a great thrill to discover a rare counterstamp and win it at auction; especially so, while cruising along I-75 at 75 mph!
06-11-2013, 11:03 PM
I started out using a paper & pencil ledger system 20+ years ago. About a year or two ago I loaded all the records into excel and have been using that. No way would I go back to paper and pencil after having Excel. I love being able to sort by year, denomination, etc. I record date purchased, purchase price, where I bought it, grade, etc. I have pieces I have sold on another tab and track all of the above plus date sold and price realized. I also have my want list on a 3rd tab, the nice thing is I can cut and paste an item from the want list to inventory when I get a new one or move it to the sold tab if I sell one! I am glad I started the ledger system from the very beginning as I have the history of each coin and there is no way I could have remembered that stuff. It is cool to look back and remember which show I bought something at or perhaps it was from a dealer who is no longer around.
06-27-2013, 12:54 PM
You guys all have great ideas for keeping a Coin Ledger on your collections and I know I should as well. This would make it easier for my wife if I should pass away or to our son if we both met our demise. My issue in doing this procedure relates to a capital "P".....Procrastination!!!
Take it easy.....Leo
Powered by vBulletin® Version 4.1.7 Copyright © 2013 vBulletin Solutions, Inc. All rights reserved.