Coin Records

Discussion in 'Coin Chat' started by Mike Drop, Apr 10, 2018.

  1. LA_Geezer

    LA_Geezer Well-Known Member

    Ditto... one for each denomination, so Morgans and Peace Dollars in one, IHCs and Lincolns in another, and so on. I keep a separate sheet for ASEs, too, but do not consider these as coins. In Quicken the ASEs are an asset, but collectible coins are an expense.
     
  2. Avatar

    Guest User Guest



    to hide this ad.
  3. iPen

    iPen Well-Known Member

    I have a spreadsheet with 52 columns of data - some are manual inputs, others are automatically calculated based on those inputs. They include everything from the precious metal content and its present value, to the inflation adjusted original purchase price and date of purchase.
     
  4. PlanoSteve

    PlanoSteve Well-Known Member

    That's what I do too! Also have the sister software for bank notes/paper money. It's great, easy & gives you "current", updated "values". You can tweak it if you want & add stuff that is not already in their vast catalog.

    At the time I bought it, I didn't want to take the time to develop my own & this was & still is perfect! I think I paid $35 or $45 for both. I think they still do a free trial version.

    Whatever you do, start as soon as possible, because if you wait until your collection gets too large, you won't want to spend the time to input all the information. (This software may be overkill for those who want something really simple.

    Have fun!!!
     
    Stevearino likes this.
  5. Jeepfreak81

    Jeepfreak81 Well-Known Member

    I've been mulling this over for a couple of weeks now also. I started building a spreadsheet, then played with some free coin software, I think I may go back to the spreadsheet though. I can make it exactly how I want to and I don't have to worry about it down the line. With the software, you need the software to view it. Sure it exports some data but I think I've decided an Excel (or openoffice in my case) spreadsheet will work best.

    I wanna get it started now before my collection grows more than it has. Right now the task isn't too daunting.
     
  6. Joshua Lemons

    Joshua Lemons Well-Known Member Supporter

    I collect silver world coins for the most part. I keep a couple index card boxes with alphabetical dividers. I write the country, date, denomination, ASW and mintage of each coin on an index card and any notes. Then I file the card away. Not very advanced, but it works for me. And when I sell a coin, I simply trash the card!
     
    Stevearino likes this.
  7. Paul_62

    Paul_62 Just takin' it one day at a time

    I've been using it since 2015, upgraded twice. It's pretty good although support from the owners of the software -- LibertyStreet dot com is terrible, almost non-existent. The database is good, the reporting module has a medium to steep learning curve, and sorting on the fly is challenging. One feature I've been using a lot lately is having a report dump into an excel spreadsheet rather than printing. That way I can sort by different pieces of data such as the year of the coin or the date of the purchase or the mint mark or whatever (which you can't do in the reports). I have to admit, I keep an excel spreadsheet (I've been using excel since before it became part of MSOffice) current, a separate spiral notebook, and then CoinManage, with photos. I keep the standard information, created my own catalog numbering system, and photograph all purchases. The spreadsheets are also good to give to the insurance agent for my home owners insurance. I might check out the wall space next to my desk, I kind of like that idea...
     
    PlanoSteve likes this.
  8. Browns Fan

    Browns Fan Active Member

    I currently use four separate excel spreadsheets. US coins, foreign coins, foreign currency and US currency. Info I keep has changed from time to time.
     
  9. STU

    STU Active Member

    when I first started to inventory I used database 3 then went to Microsoft exell works great I can I set it up for the coin the grade what I paid for it or how I received it then a shot description and if it is graded by a company the serial number
     
  10. Trish

    Trish Well-Known Member

    Is there a database for world coins like CoinManage 2017? I have more world coins than anything else and CoinManage only covers US, Canada and the UK. If not, I'll have to use Excel....
     
  11. PlanoSteve

    PlanoSteve Well-Known Member

    According to Liberty Street latest web site info, you can track world bullion, but not world coins in general.

    You might pose this question on the World Coin forum to see what they say/use.
     
    Trish likes this.
  12. Paul_62

    Paul_62 Just takin' it one day at a time

    You can add coins from other countries to CoinManage Deluxe 2017. I currently have 9 countries. The database includes over 20 although I don't know how far back the coin records go, I have mostly all recent (last 150 years) items. I don't know if it includes ancient coins. You can add a country if it is not on the list, I had to add British Palestine - British Mandate to include a couple of collections I have. There is a specific video on YouTube about this, among the ones they have online.
     
    Trish likes this.
  13. Alok Verma

    Alok Verma Explorer

    Thanks to all seniors for providing very useful information for all new collectors.
     
    Silversloth and Santinidollar like this.
  14. Seattlite86

    Seattlite86 Outspoken Member

    Excel and going down is my row order across:
    Country
    Catalog number
    Year
    Mint
    Notes (error, variety, die crack, corroded)
    Grade (wish I had started putting grades at the start)
    Location
     
  15. Stork

    Stork I deliver Supporter

    I'm starting to look at Exact Change http://www.exactchange.info/index.htm

    It looks to have all the functionality, plus some nice features that would be a pain in Excel (KM#s, size, precious metal component auto added). It will link to the Krause catalogs (if you have them in e-format). It's a bit pricier ($80) but looks pretty user friendly for the world coin collectors, it works on a Mac, and looks pretty expandable for medals.

    My main worry is regarding what happens when the developer eventually stops supporting it...my main criteria is that s/he is at least a decade younger than me and comes from a family blessed with longevity and mental acuity well into old age. Plus a few younger relatives who will carry support for the program into the next 50 years. Okay, I am not QUITE serious, but much as I like the program for it's 'extras', I keep thinking I need to find a more open system.

    I like the Airtable site, but same concerns for longevity. I'm also not super thrilled with the idea of keeping my records on a cloud based program. Excel specifically (or maybe Pages as I have a Mac) would allow me to keep it 'local'.

    I'm starting to ever-so-slowly creep into Ancients, so I'm also curious how people keep records there efficiently...
     
  16. V. Kurt Bellman

    V. Kurt Bellman Yes, I'm blunt! Get over your "feeeeelings".

    I didn't realize you were a Mac guy. I knew I like you for good reasons.
    <iframe width="645" height="363" src="https://www.youtube.com/embed/tjgtLSHhTPg" frameborder="0" allow="autoplay; encrypted-media" allowfullscreen></iframe>
     
    Last edited: Jun 13, 2018
    Santinidollar likes this.
  17. I use an Excel spreadsheet with very specific details on the coin plus all info on purchase, including purchase price and any basis.
     
  18. xlrcable

    xlrcable Active Member

    Excel. I suspect, maybe unfairly, that no canned software would allow me to arrange things exactly the way my OCD brain wants them.

    (BTW, entiendo su alusión, Berlin.)
     
  19. Mike Drop

    Mike Drop Active Member

  20. JCro57

    JCro57 Making Errors Great Again

    I started writing a catalogue and am now literally writing a book!
     
  21. V. Kurt Bellman

    V. Kurt Bellman Yes, I'm blunt! Get over your "feeeeelings".

    I've been watching what you collect. You have "a mission". Put me down as a book customer.
     
    JCro57 likes this.
Draft saved Draft deleted

Share This Page