Coin Community Family of Web Sites
Like us on Facebook! Subscribe to our Youtube Channel! Check out our Twitter! Check out our Pinterest!
Username:
Password:
Save Password
Forgot your Password?


Welcome Guest! Need help? Got a question? Inherit some coins?
Our coin forum is completely free! Register Now!

How Do You Track Your Collection?

First Page
Showing last 15 replies.
 
To participate in the forum you must log in or register.
Author Previous TopicReplies: 22 / Views: 762Next Topic Page 2 of 2
New Member
Bulgaria
27 Posts
 Posted 02/16/2021  10:02 am  Show Profile   Bookmark this reply Add MichaelSH to your friends list Get a Link to this Reply
In a small notebook and a large Excel spreadsheet that I've been too lazy to update it since the 2nd of December.
Moderator
Learn More...
United States
99300 Posts
 Posted 02/16/2021  11:57 am  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply

Quote:
Perhaps Excel will be the best solution for me, but unfortunately I do not know how to use it. How is your table designed ?
I have a separate worksheet for each album. Some columns vary, but most US sheets have Year, Mint, Variety, Value, Purchase Date, Paid, Grade, and Notes. The "world coin" sheets add columns for Country and KM#. Not all cells have information though.
Pillar of the Community
United States
3687 Posts
 Posted 02/16/2021  11:57 am  Show Profile   Bookmark this reply Add KenKat to your friends list Get a Link to this Reply
Excel

I keep track of date/mint mark, denomination/series, grade, current value, acquisition price, notes

If the coins are in an album, I group them by that. I also have sections for single coins and proof/mint sets.
Moderator
Learn More...
United States
99300 Posts
 Posted 02/16/2021  12:15 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply

Quote:
I also have sections for single coins and proof/mint sets.
Yes, I have a worksheet just for all the OGP items in my collection. It has grown a lot the last ten years.
Pillar of the Community
United States
1317 Posts
 Posted 02/16/2021  2:02 pm  Show Profile   Bookmark this reply Add Dearborn to your friends list Get a Link to this Reply
Excel spread sheet. 2 different file one for mint /uncirculated coins and one for coins taken out of circulation and placed in albums or folders.

all listed by date/mint mark, # of coins minted, purchase date, Purchase price, bought from who, grade, then current value

All collums with prices are then totaled up for a grand total.
Collecting since 1972. Learning from then on
"Tell me and I forget. Teach me and I remember. Involve me and I learn." -Benjamin Franklin
My Dansco 7070 type set coin count: 31/76
My Dansco 8176 Eisenhower set coin count: 36/36
Valued Member
United States
237 Posts
 Posted 02/19/2021  08:49 am  Show Profile   Bookmark this reply Add Gary to your friends list Get a Link to this Reply
I have used the coin elite software for years. Easy to use and you can make your own formats to add anything you want. I would highly recommend it.
Pillar of the Community
Australia
2937 Posts
 Posted 02/19/2021  7:44 pm  Show Profile   Bookmark this reply Add triggersmob to your friends list Get a Link to this Reply
I store images of all my coins in the CCF gallery and that is a tool I can refer to from anywhere. It's also handy to refer other people to when looking for trades. The images are also stored on my computer and backed up on second remote storage device. Also keep information on every coin on an Excel spreadsheet.

Steve :)
View my Coins here, (NOW WITH OVER 15,000 IMAGES).... http://www.coincommunity.org/galler...hp?cat=10048
OFEC count = 237
Valued Member
United States
287 Posts
 Posted 02/20/2021  5:46 pm  Show Profile   Bookmark this reply Add jason39305 to your friends list Get a Link to this Reply
I catalog my coins on numista, which I find very easy to use. You can download an excel spreadsheet anytime you'd like. You can enter private info about each coin when you catalog it.

I would love to get around to photographing my collection some day.
Pillar of the Community
United States
530 Posts
 Posted 02/21/2021  12:55 am  Show Profile   Bookmark this reply Add deadmunny to your friends list Get a Link to this Reply

Quote:
Perhaps Excel will be the best solution for me, but unfortunately I do not know how to use it. How is your table designed ?


There are lots of Excel tutorials online (ie - Youtube). Very simple to learn. I like this spreadsheet a lot not only to keep inventory of coins but for financial tracking too.
Pillar of the Community
Canada
569 Posts
 Posted 02/21/2021  10:33 am  Show Profile   Bookmark this reply Add Cdncoins to your friends list Get a Link to this Reply
I use Excel and Numista
Pillar of the Community
Canada
1200 Posts
 Posted 02/21/2021  10:38 am  Show Profile   Bookmark this reply Add purelywasted to your friends list Get a Link to this Reply
I use excel with a few different tables to keep things organized.

1. Master ledger. Inventory of all coins (work in progress), listed by country, date, grade, variety, issues, cert, price paid, value, date purchased/sold/sale price, inventory number.

I wish I would have been more detailed on where I purchased. It is just ebay, bank, other. Best thing I did was list some bulk lots as one item (eg. Box of pennies of 5000 coins). No time to catalog and number each coin.

2. Collection list. Basically a table that shows me highest grade of each coin I am collecting and associated tables for each monarch to summarize each type set by denomination. This is pulled from master ledger.

3. The scary table. Pulls data on cost, value, sold and profit from master ledger. It's surprising how quick it adds up. I might not want to show this to my significant other...

Overall it is kind of neat to see how far I have come, looking at some of the winners/losers and it has inspired me to sell duplicates to reduce investment and free up space for stuff.

Next stage is to photograph permanent collection and label with inv number. Hopefully when it comes time to sell/pass it on, it will be an easier process as all cataloging and photos are done. The hardest part I find in selling off excess coins is taking time to photograph and price, once that part is done, listing becomes a lot easier.
Edited by purelywasted
02/21/2021 12:41 pm
Pillar of the Community
United States
1002 Posts
 Posted 02/21/2021  11:27 am  Show Profile   Bookmark this reply Add atticguy to your friends list Get a Link to this Reply
Unfortunately, I just recently paying better attention to my collection. I should have begun years and years ago.

Right now I'm just using paper. I have used Excel in the past but now any of that info is in two or three computers that crashed/died and are now stacked in my garage unusable. I actually did back up some stuff on floppy disks (yes, from the golden ages) but my new computers can't read them.

I am basically just keeping tabs on the prices I've paid for my coins. I've told my kids that when I pass I hope they can get at least half of my costs back.
Moderator
Learn More...
United States
99300 Posts
 Posted 02/22/2021  11:38 am  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply

Quote:
I actually did back up some stuff on floppy disks (yes, from the golden ages) but my new computers can't read them.
If your time is worth more than $25...

https://www.amazon.com/External-Por...p/B07PNHF548
Pillar of the Community
United States
1002 Posts
 Posted 02/22/2021  3:21 pm  Show Profile   Bookmark this reply Add atticguy to your friends list Get a Link to this Reply
Thank-you jbuck! If I knew those things were so inexpensive I would have bought one years ago.

Moderator
Learn More...
United States
99300 Posts
 Posted 02/22/2021  4:04 pm  Show Profile   Bookmark this reply Add jbuck to your friends list Get a Link to this Reply
No problem.

I have had a USB floppy for years. Now I have a USB DVD because the new laptop is too thin for a built-in.
Page 2 of 2   Previous TopicReplies: 22 / Views: 762Next Topic  
First Page
Showing last 15 replies.
 
To participate in the forum you must log in or register.





Disclaimer: While a tremendous amount of effort goes into ensuring the accuracy of the information contained in this site, Coin Community assumes no liability for errors. Copyright 2005 - 2021 Coin Community Family- all rights reserved worldwide. Use of any images or content on this website without prior written permission of Coin Community or the original lender is strictly prohibited.
Contact Us  |  Advertise Here  |  Privacy Policy / Terms of Use

Coin Community Forum © 2005 - 2021 Coin Community Forums
It took 0.42 seconds to rattle this change. Powered By: Snitz Forums 2000 Version 3.4.05