A simple catalogue system for coin collectors

Collector's Little Helper™ gives you everything you need to build a proper digital record of your coin collection — one that works as a daily reference, an insurance record, and an inheritance document for your family.

The kit's main working files are below. You don't need to be a spreadsheet expert, and you don't need any special software beyond a spreadsheet app (Excel, Google Sheets or LibreOffice) and a web browser.

Four things I wish someone had told me

How to name your coins consistently

Every item in the catalogue should follow this title format. It makes your catalogue sortable, searchable, and readable by anyone — including a coin dealer or executor.

One rule: always write Uncirculated in full — never UNC or Unc.

Column reference guide

The catalogue has many columns, but you only need a few to get started. REQ fields are essential. Everything else you can add over time.

Five steps to add a coin

These are the same five steps shown in the Entry Form's How to Use tab and the catalogue's START HERE tab. One coin or ten — the steps are the same.

Stuck?

• For inherited items with unknown details, the AI can often identify the coin from a description alone and fill in mintage, year, and metal
• eBay "sold" listings (not asking prices) are the most reliable source for current market values — check them yourself and enter your own figure. The AI won't add values for you, because AI price estimates aren't reliable enough to record
• Don't clean your coins — cleaning destroys numismatic value permanently
• Watch out for coin roll scams — a known fraud where a valuable coin sits on top of a roll of worthless ones. You must destroy the roll to check. Buy coin rolls only from the RAM or a trusted dealer.

Key terms at a glance

A plain-English guide to the terms used in this catalogue system and in the world of coin collecting. The full glossary — including pre-decimal terms — is in the Glossary & Resources tab of the Entry Form.

Trusted research sources — ranked by reliability

Full glossary and detailed source notes are in the Glossary & Resources tab of CLH_Entry_Form.html. Also worth bookmarking: australiacoins.org — beginner-friendly guide to identifying and valuing Australian coins.

Finishes, and what a mintage figure really tells you

Three words come up constantly in coin collecting, and they make more difference to what a coin is worth than almost anything else.

You'll also see special treatments — coloured, frosted, gilded, antiqued, domed and high relief. These go in the catalogue's Treatment field, separate from the finish.

Reading a mintage figure

Mintage is simply how many were made. A lower number usually means fewer collectors can own one, so it's a useful guide — but only a guide. Demand matters just as much, and a few questions make the number far more meaningful:

• Is it the number made, or the most that could be made? Many collector issues quote a maximum. The final figure can be lower — the Royal Australian Mint's annual reports carry the actual numbers.
• Does it cover every version? Coloured, gilded and privy-marked versions often have far smaller mintages than the plain coin of the same design.
• Sold out isn't the same as scarce. A low issue price can sell out a large mintage in a day.
• Certificate numbers don't indicate rarity. Certificate No. 12 isn't scarcer than No. 4,812 of the same coin.
• Compare within the series. The coin with the lowest mintage in a run is often the “key date” collectors chase.
• Completeness counts. The coin with its original case, certificate and box is usually worth more than the coin alone.

Record the mintage when you get a coin — certificates have a habit of going missing. The catalogue has a Mintage field for exactly this.

What damages coins, and how to store them

Most damage comes from a handful of everyday causes, and nearly all of it is preventable. It's also permanent — no amount of cleaning brings an original surface back.

Handling

• Hold coins by the edges, over a soft surface such as a folded towel, so a slip doesn't become a dent.
• Cotton or nitrile gloves are worth having for proofs and anything uncirculated.
• Avoid talking or breathing directly over mirror surfaces — tiny droplets can leave spots.
• Don't clean coins, and leave natural toning alone. Many collectors value the toning on old silver, and a cleaned coin is easy for an experienced eye to spot.

Choosing a holder

Good storage is inert — it doesn't react with what it holds. Match the holder to the item and its value:

Where to keep them

• Somewhere cool, dry and dark, with a steady temperature. Garages, roof spaces, bathrooms and outside walls are the usual trouble spots.
• A sachet of silica gel in a closed storage box helps with humidity — replace or dry it out from time to time.
• Keep the original cases, cards, certificates and boxes. They protect the coin and are part of its value.
• Keep your records — your catalogue, photos and receipts — somewhere separate from the coins, with a copy off the premises.
• Discretion is part of security: there's no need to advertise what you own or where you keep it.
• For a valuable collection, check what your home and contents insurance covers. Many policies have low limits for collectables unless items are listed separately.

The storage brands I use myself are listed on the Resources page, under Go Deeper.

Take your time — the coins aren't going anywhere

This is where I went wrong, so it's the part of this guide I care most about. Rushing cost me far more than anything I bought badly. Here's what I'd do differently.

1. 1Pause. Nothing needs to happen quickly. A collection is usually safest left as it is while you get your bearings — somewhere secure, and out of sight.
2. 2Don't clean anything. It's the fastest way to destroy value, and toning on old silver is often a plus.
3. 3Keep sets together, and keep every case, certificate, receipt and note. A handwritten list from the original collector can be the most valuable thing in the box.
4. 4Photograph and catalogue it before anyone else sees it. This kit was built for exactly that, and a record lets you ask informed questions instead of taking someone's word for it.
5. 5Learn the language first. A beginner's guide and the glossary in this kit will make every later conversation easier.
6. 6Be wary of quick offers for the whole lot, especially unsolicited or sight-unseen ones. Get more than one opinion. When a collection looks like it's worth thousands, an independent paid valuation earns its fee.
7. 7Treat apps and AI as a starting point, not a valuation. They're useful for identifying a coin, but they regularly miss varieties and misjudge condition.

The four “values” you'll come across

People quote very different numbers for the same coin. They're usually all correct — they just answer different questions.

My own story — and what I wish I'd known — is at the top of the Resources page.

Your first ten coins

Don't try to catalogue your whole collection at once. Start with ten coins — ideally the most valuable or most meaningful ones. For each, fill in just the required fields and get comfortable with the naming convention before adding more detail.

• Start with your most valuable or meaningful pieces. These matter most for insurance and inheritance purposes.
• Photograph each coin before you put it away — having photos on hand makes research much easier later.
• Record acquisition source and price even if approximate. "Inherited from Dad, est. $40" is far better than nothing for estate purposes.
• Use the Wanted status for coins you're looking for — it turns your catalogue into a shopping list for coin fairs and dealer websites.