Gold and silver are among the most common long-term holdings, yet most people have no clear record of what they own, what they paid, or where it's kept. This free Gold & Precious Metals Tracker gives you a single inventory of every coin, bar and piece of jewellery — useful for tracking your investment and for insurance records.
How to use it: add each item with its weight and purity and record what you paid. Update the Current Value column periodically using the prevailing rate so the total reflects today's worth, and note where each item is stored. A TOTAL row sums purchase price and current value so your unrealised gain is visible at a glance.
Built from real-world business experience by the ExcelGurukul team. Tested across multiple industries and roles.
Yes, it's free to download with no sign-up.
Yes — a Metal column lets you record gold, silver or any other.
No, you update the current value manually; it keeps the sheet simple and offline.
Yes, the item, value and storage columns make it ideal for insurance documentation.