Tracking your stock

[Maundy]

How does everyone track their stack? I'm looking at getting a document together a bit like a spreadsheet and wondered what titles they use on Colums?

 

My focus is to track items and ensure maximum profit over future years.

[Money2Metal]

I use Excel for my gold. Its got columns for coin type/gold weight/cost.Then at the bottom it tots up the total amount spent, amount of gold in oz and the average cost per oz. I did it years ago and had to watch a youtube video to use the correct formula to make it do the right thing. 

[Blockhead]

I do this too. I also put the spot price at the time of purchase so I can see what premium I paid per gram (or ozt) and have a basic record of how the price has moved since I started on this slippery slope! 

[kiskelo]

Simple spreadsheet, you can track whatever you want, amount, cost, weight, where from, total spent (that bit can get scary) etc. Different pages etc

[Maundy]

Thanks all. I was thinking of designing a hard book but seems spreadsheet is the way forward. Guess its easier to edit in future.

[CadmiumGreen]

@BackyardBullion has a spreadsheet format that he has made available...

http://backyardbullion.com/product/bullion-stacking-record-keeping-spreadsheet/

[Maundy]

5 minutes ago, CadmiumGreen said:

@BackyardBullion has a spreadsheet format that he has made available...

http://backyardbullion.com/product/bullion-stacking-record-keeping-spreadsheet/

Awesome thank you. I will get onto that tomorrow evening after work.

[AppleZippoandMetronome]

Another spreadsheet user here 👍

[Pritchard]

i have a sliced tree and a ink filled plastic cylinder.

because that stops google accessing it.