Here's my system for tracking personal gear history

mike3996

Hall of Famer
Apr 2, 2018
Finland
BeginEndBuySellSystemTypeFL equivGear
2006-Dec0Compact35-140Canon PowerShot A530
2017-Jun2019-Sep3000(2750)Compact28Leica Q
2019-Sep2020-Jan(2350)1900Canon EFILCCanon EOS 5D Mark IV
2019-Sep2020-Jan(150)140Canon EFLens40Canon EF 40mm f/2.8 STM
2019-Sep2020-Jan(250)250Canon EFLens50Canon EF 50mm f/1.4 USM
2020-Mar230Compact35Fujifilm X100S

This is a table format that I use to track my gear, with some sample items.

Begin: when you got or bought or received in trade the specific piece of gear.
End: when you sold or traded the gear. If this is empty it means you still own it.
Buy/Sell: how much you paid or got for the gear. Zero means you received/gave it away as a gift. Sometimes you trade more for one, now you have to apply creative accounting and imagine how the trade was constructed. Usually bodies devalue more than the lenses. I mark these trades in parentheses.
System: camera system if it's a system camera or lens.
Type: compact, ILC, Lens, flash, whatever.
FL Equiv: fill this in and play in Excel to get funny graphs of your FL coverage. You can split the range into two columns, perhaps easier that way.
Gear: description of the gear.

In this example I bought Leica Q for $3k and then traded it for a 5Dm4 setup. That is implied by the dates and the parens.

In this example I own two cameras (or pieces of gear more generically), those that don't have an "End" date.


This is one way to keep track of your actual expenses because it's all bought minus all sold that's your expense for this hobby/profession. In my mind if you buy $3k worth of gear you're not $3k in the hole. The final cost is formed the minute you sell it for money probably less than $3k and you subtract what the gear actually cost you.

Further improvements possible:

I also mark in mine if it was bought brand new or preowned.

You may also expand this idea by describing condition perhaps.
 

mike3996

Hall of Famer
Apr 2, 2018
Finland
I originally started to track my finances using double accounting because of my hifi gear hobby. It has been a tremendous success to my financial life.

Aside keeping that double ledger I started this camera gear specific table on the side.

I like the fact that this will also track my history down the road. So these dates are important to me. Older entries are year-month accuracy but all recent ones I account to the day. I can build timelines as I accumulate things and data. I could also study this history to see for example what point in time I had the widest coverage of focal lengths.
 

Latest posts

Latest threads

Top Bottom