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.
This template is designed for individual investors and personal finance enthusiasts who track portfolios, returns and investment performance — without the need for expensive specialist software.
The Gold Precious Metals Tracker is part of our Personal Finance & Budgeting collection — downloaded 7 times and counting. Built from real-world experience by the ExcelGurukul team and 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.