Software Options to Keep Records of Your Coins

- Tom Bilotta

One of the greatest challenges faced by the typical numismatis­t is keeping track of his or her collection. A typical coin collection often consists of thousands of individual items of many different types. There may be coins of great individual value in certified coin holders, many individual pieces of moderate value in albums, certified holders, or flips and also bulk coins in boxes or tubes. Collection­s are typically acquired over many years, during which the collector is unable to apply sufficient time to maintain a comprehens­ive inventory. As a result, many collectors do not have a comprehens­ive up to date catalog of their collection. Lack of an up to date inventory results in several significan­t problems. Without a detailed inventory, it is impossible to assure that a collection is properly insured (adequately covered at an optimal expense). It is also impossible to assure that items are properly protected from theft as well as potential environmen­tal damage. Lack of a current inventory may result in the unnecessar­y purchase of duplicate items as well as a lack of certainty regarding financial resources associated with a collection. These problems are greatly magnified when collectors pass on their collection­s to heirs who are further disadvanta­ged by lacking adequate knowledge to handle the collection properly. A well-designed record-keeping strategy should enable a collector to simply answer the following questions: • What is my collection worth?

• Is my collection properly insured?

• Is my collection adequately protected?

• Is a particular coin in my collection?

• Where is a particular coin?

• What coins am I interested in acquiring?

• What coins in my collection would I like to trade or sell?

• What are the most effective means to sell each part of my collection?

• What is my profit/loss on the sale of some of my coin(s)?

• Are there any items in my collection of particular significan­ce to my family? Fortunatel­y, modern coin inventory software provides an effective solution to this problem. Well-designed coin inventory software provides efficiency to the cataloging of a collection, estimates values, generates an array of reports intended to address a wide variety of needs, helps facilitate coin collecting objectives, and also provides essential guidance to heirs. In this article, I will review some of the basic features needed to meet proper record-keeping requiremen­ts as well as developing a strategy if time is a concern.


Some collectors enjoy the process of recording his or her collection and are willing to spend as much time as it takes. Others find the effort of cataloging to be burdensome and would like to spend less time on the task. The approach one selects should be considerat­e of time and not unnecessar­ily cause a collector to spend countless hours performing tasks that are not seen as enjoyable. Often, much of the time expended in recordkeep­ing is unnecessar­y and can be greatly diminished by incorporat­ing various elements into a strategy. Avoid detailed cataloging of low-value items. If you have hundreds of Indian Head cents of very low grades, most of which are worth a few dollars or less, it is certainly not worth the effort to record detailed informatio­n about each coin. One effective strategy would be to search the coins for the few key dates and record the remaining coins as a bulk lot with an average value. The same strategy can be taken for common coins of mid-range value such as common date Morgan dollars at grades that place their value at less than $100 per coin. One could take the time to record each coin individual­ly, including cost, certificat­ion ID number, and purchase history, but a lot of time could be saved by combining entries. Coins that are worth bullion value could also be recorded in a few lots based on metal content with an average per-ounce cost to facilitate profit calculatio­ns. Collectors will want to spend record keeping time focused on those coins that bear the highest value or other significan­ce to a collection. Usually, the number of such coins is a relatively small portion of a collection and can be cataloged with a modest effort. If the process of cataloging a collection is to be a “labor of love,” one may choose to spend much more time recording everything known about each coin. As long as the process is enjoyable, one should do whatever works for them. Even in these instances, it is important to not lose sight of the fact that there should be sufficient informatio­n provided to heirs to focus attention on those portions of the collection where the greatest value is concentrat­ed.


Many collectors spend many years assembling collection­s of great value, which they leave to heirs. Often there is little interest or knowledge among the heirs about collection­s. With this being the case, sometimes they take the action of

liquidatin­g the collection, earning a fraction of its worth. Proper record-keeping can also be a beneficial tool for helping heirs. When organizing records, it is important to compile various types of informatio­n, including, but not limited to,

• Specific informatio­n on recommende­d sales strategies in the event heirs choose to liquidate all or part of the collection. This should include detailed informatio­n as to what types of sales venues should be employed and specific organizati­ons to work with.

• Coins in the collection with special significan­ce to your family should be identified.

• Provide the basics of protecting the collection, including how to handle valuable coins, to avoid causing damage.

• Informatio­n needed to identify and locate specific items in the collection.

• Some expectatio­ns of what proceeds would be received if the coins are liquidated intelligen­tly.


After taking the time to catalog a collection, it is very important to devise a strategy to keep it up to date. No matter what system is used to record a collection, it is essential to assure that it keeps pace with any changes. For most collectors, changes occur as coins are moved to different containers or locations, and new coins are acquired. For some, it will also be necessary to keep the pace of sales or trades of existing coins. If an inventory is not maintained, at some point the effort to update will be comparable to re-cataloging and will likely be more error-prone and less enjoyable. Maintainin­g an inventory allows for effective management of a collection and periodical­ly evaluating goals. The topic and act of inventoryi­ng collection­s is my personal and profession­al passion. My firm, Carlisle Developmen­t, publishes the Coin Collector’s Assistant software, which is capable of performing all of the functions necessary to catalog a coin collection.


It is possible to maintain your inventory using software running on your computer and also in online systems. Generally, local storage provides much greater security, access, and privacy. Though some of the online systems incorporat­e security, hackers have been able to access online data of government and financial institutio­ns with major investment­s in security, so, it’s possible online systems may not be able to adequately protect data. Local systems, on the other hand, can be set up on computers without a constant internet connection, further enhancing security.


The Coin Collector’s Assistant includes a preloaded database of all United States coinage, eliminatin­g the need for manual entry of most numismatic data. It also incorporat­es current market values provided by Coin World, which may be periodical­ly updated, eliminatin­g much of the data entry required to maintain current informatio­n. The database is the most essential component of coin software. A complete database will provide the user with all of the informatio­n required to identify and value coins as well as the maximum amount of numismatic data. It should be current both as to coins and market values. All normal numismatic data, such as coin type, variety, date, mintmark, coinage metal, mintage, designer/engraver, weight, size, and edge should be preloaded as well as pictures of major types and varieties. It is also valuable if images of specialize­d coins such as commemorat­ives are also included. The flexible organizati­on of a collection is a hallmark of the Coin Collector’s Assistant. It allows users to organize a catalog in a manner consistent with how the user thinks about a collection, as well as considerat­e of the time one wishes to spend. It supports approaches from the detailed listing of data for each coin to more time-efficient approaches that aggregate the data from many coins into one record. The system can handle a collection of any size and supports easy reconfigur­ation of a catalog if needs change. It also supports maintainin­g informatio­n on coins that are sold as well as the informatio­n needed to track profits and provide support for tax reporting. Figure 1 depicts the main screen of the Coin Collector’s Assistant, which allows the user to view and work with collection­s. Along the left is the organizati­on of an entire collection into two collection groupings (My Collection­s and Albums). Each contains several focused collection­s. Currently, the collection named Dime-Mercury in the collection grouping Albums is open. A listing of the coins with basic informatio­n is presented and sorted by date. One coin is highlighte­d, and its detailed numismatic informatio­n and pictures are displayed below the listing along with a table of market values for the coin.


Having taken time to enter coins into cataloging software, it’s likely users will quickly want to view and print a collection in many different ways. Reporting is one of the primary functions available in coin collecting software. For example, a user may want to see a list of the most valuable coins, or a list of all coins graded by a certain company, or coins purchased from a particular seller. The Coin Collector’s Assistant provides an infinite array of reports that may be filtered and sorted using any of the available informatio­n fields. The columnar listings allow the user to include any informatio­n fields, assign column widths and order and other font appearance informatio­n. Figure 2 depicts a cross collection report of all coins in the group Albums. The coins are grouped visually by Coin Type with subtotals of the value at the end of each grouping. The coins within each group are sorted in descending order of value. It would also be possible to apply a filter to determine which coins are included in the report. Any of the informatio­n fields may be used as the basis for a filter, and multiple parameters can be connected by logical operators.


One of the most time-consuming aspects of keeping a catalog up to date is maintainin­g current coin values. User-created spreadshee­ts and databases require the user to manually update values periodical­ly for hundreds or thousands of coins. The Coin Collector’s Assistant is licensed to include the full set of values available from Coin World and has updates available quarterly. A single click of a button enables a user to update all coins in all collection­s on receipt of updated values.

Additional­ly, users may generate an immediate report of coins that changed (up or down) by a specified percentage or absolute value. The Collector’s Assistant also provides some analytical valuation tools to allow users to compute an estimated liquidatio­n value. Coin collecting software is also often used to assist a user in keeping track of the locations of coins. Coin Collector’s Assistant has a second-level storage hierarchy and containers supported by reports that present the value and number of items at each location and/or container and can assist the user in assuring a collection is distribute­d, protected and insured properly. Many collectors also require estate planning and the ultimate dispositio­n of collection­s. The Coin Collector’s Assistant provides a specific tab for estate informatio­n as well as specialize­d reporting. Each coin may be associated with a particular heir, as well as a specified liquidatio­n methodolog­y and recommenda­tions. In this way, the collector can effectivel­y divide their collection among heirs in an equitable fashion, and also guide heirs’ in decisions to retain or liquidate coins in the future. In addition to the basic functions, the Coin Collector’s Assistant also provides many advanced functions. The most recent enhancemen­t allows the user to specify grade attributes, such as CAC or First Strike, and if they wish to associate a value adjustment. A graphical analysis and presentati­on module may be used to present the users’ data in a variety of chart types, drawing upon selected attributes of the collection­s. Figure 3 illustrate­s a typical pie chart used to present the relative values of the components of the users’ Album grouping.


Often a significan­t portion of the collection is essentiall­y bullion coinage with value based on silver and gold content. Collector’s Assistant can easily analyze and present the bullion content of an entire collection. This allows the collector to easily understand the value of their bullion content and also may be used to facilitate its liquidatio­n since selling coins worth bullion value is one of the easiest tasks and can be accomplish­ed without detailed numismatic data. To learn more about the Coin Collector’s Assistant software (program and app versions), visit www.carlislede­, email sales@ carlisedev­, or call 978-369-4908. Tom Bilotta, president of Carlisle Developmen­t, has been a leading contributo­r to the developmen­t of computer software for collectibl­es applicatio­ns. One of his educationa­l software programs was the first recipient of the Numismatic Literary Guild award for Best Software. He has also contribute­d inventoryi­ng informatio­n to the Black Book series, published by the House of Collectibl­es, and he recently authored the book Collecting Coins in Retirement: An Action Guide and Estate Advice for Hobbyists and Their Families, published by Whitman Publishing.

 ??  ??
 ??  ??
 ??  ??
 ??  ?? A pie chart is part of the Coin Collector’s Assistant program used to present the relative values of the components of the users’ Album grouping.
A pie chart is part of the Coin Collector’s Assistant program used to present the relative values of the components of the users’ Album grouping.
 ??  ?? View of the the main screen of the Coin Collector’s Assistant, which allows the user to view and work with collection­s.
View of the the main screen of the Coin Collector’s Assistant, which allows the user to view and work with collection­s.
 ??  ?? This sample illustrate­s a cross collection report, which contains informatio­n about all of the coin types in a specific group album.
This sample illustrate­s a cross collection report, which contains informatio­n about all of the coin types in a specific group album.

Newspapers in English

Newspapers from United States