It took me a couple of months but I went through all my old emails, found all the eBay notices and all the emails from the bullion dealers and pieced it all together. Added in all the Personal Messages I could find from this site and have managed to trace about 90% of all my purchases. All new purchases go straight into the spreadsheet with all the info I can find.
I have put them all into a Google spreadsheet which automatically updates the spot for gold and silver. I then started to add columns for profit, percentage profit, annualised percentage profit etc. Along with purchase dates, purchase prices, order numbers, basically all the info I could pull from the emails.
Once that was up and running I added all my cryptocurrency and cash / bank holdings and just for fun, the real estate. The crypto also updates automatically.
Then I found all the records for the SMSF and added them in a separate table.
I stuck a dashboard at the top so I can see a summary of all my holdings and now I just stare at it every couple of minutes in disbelief.
Most of my silver and gold was bought as coins for under $500 as part of my hobby of coin collecting so I think that is a get out of tax free situation but I have never tested it. I also give away silver as gifts at Christmas and birthdays so that gets complicated as I don't keep track of that and there are no records. Apparently I have 20 x 1/10g Valaurum gold notes from 2014 but I have no idea what happened to them.