What records do you keep of your collection?

Kmaddock · 18th June 2019, 11:21 AM

Hi Ian

I too keep a similar excel sheet but I do not include the name of the buyer

I also keep a records of trades and swaps of items along with restoration costs of items.

As it is also a means of recording spend I have a few formula built into the excel with profit (or loss) on the sale and a running total of if i am running at a profit or not.

I generally turn a reasonable profit per year (I buy and sell all sorts of items not just weapons) which i solely use for family events and holidays so this is recorded in a separate section of excel so i can see where I have spent profit.

I do not need to do this financially but it can be nice to go for a weekend away in Europe and have a it all paid for from a good sale.

However my wife is adamant i do not sell what i like which i greatly appreciate.

Regards

Ken

Ian · 18th June 2019, 12:52 PM

Thanks Ken.

I have a similar approach to accounting for expenditures and sales. Because this information may be audited at some time (I've been audited twice by the IRS already), I put the tax accounting stuff into additional files and simply refer to the individual items by their alpha-numeric identifiers (e.g. AFR 1076; MSEA 1134; MISC 1081; etc.). No doubt there are many effective systems.

Ian

Battara · 18th June 2019, 10:36 PM

Ian I do just about everything you do, but some info in excel and some in the info sheets I do for each piece, plus a picture of said piece.

This was more than they needed for insurance purposes, but glad I do such for research purposes too.

18th June 2019, 11:21 AM	#1
Kmaddock Member Join Date: May 2014 Location: Ireland Posts: 543	Hi Ian I too keep a similar excel sheet but I do not include the name of the buyer I also keep a records of trades and swaps of items along with restoration costs of items. As it is also a means of recording spend I have a few formula built into the excel with profit (or loss) on the sale and a running total of if i am running at a profit or not. I generally turn a reasonable profit per year (I buy and sell all sorts of items not just weapons) which i solely use for family events and holidays so this is recorded in a separate section of excel so i can see where I have spent profit. I do not need to do this financially but it can be nice to go for a weekend away in Europe and have a it all paid for from a good sale. However my wife is adamant i do not sell what i like which i greatly appreciate. Regards Ken

18th June 2019, 12:52 PM	#2
Ian Vikingsword Staff Join Date: Dec 2004 Location: The Aussie Bush Posts: 4,469	Thanks Ken. I have a similar approach to accounting for expenditures and sales. Because this information may be audited at some time (I've been audited twice by the IRS already), I put the tax accounting stuff into additional files and simply refer to the individual items by their alpha-numeric identifiers (e.g. AFR 1076; MSEA 1134; MISC 1081; etc.). No doubt there are many effective systems. Ian

18th June 2019, 10:36 PM	#3
Battara EAAF Staff Join Date: Dec 2004 Location: Louisville, KY Posts: 7,320	Ian I do just about everything you do, but some info in excel and some in the info sheets I do for each piece, plus a picture of said piece. This was more than they needed for insurance purposes, but glad I do such for research purposes too.