Our Stock Tracker is remarkably simple to use. Simply open it and save yourself a copy on your device and then you can fill in the columns accordingly:

Column A: Item Name – enter the name/model of the item here. If you are selling items in varying conditions, you may wish to include the grade, for example “Apple iPhone – grade B” would mean a fully functioning phone but there may be scratches and scuffs affecting the cosmetics.

Column B: Date Bought – enter the date you bought the item.

Column C: Hammer Price – enter the winning bid amount that secured you the item.

Column D: Total Cost – take the Hammer Price and add the fees (these are added after you have won the bid and will normally consist of VAT on the item if applicable, an auction buyer’s premium plus VAT on the same). If you made a journey to attend the auction live, you should also include your transport cost.

Column E: Status – enter the status such as “Listed”, “Repairing” or “SOLD”.

Column F: Date Sold – enter the date you sold the item.

Column G: Sale Price – enter the gross amount that the customer paid you.

Column H: Selling Fees – enter all the costs associated with selling the item, for example, eBay listing and final value fees as well as postage and packaging costs.

Column I: Net Profit – the Stock Tracker calculates this automatically for you (remember to fill down the formula each time you add a new line). This is your final take-home amount.

Column J: ROI – the Stock Tracker calculates this automatically for you (remember to fill down the formula each time you add a new line). This is the amount of net profit you made as a percentage of what you invested (in purchasing the item).