FREE WORKBOOK
FREE WORKBOOK count your stock the way your accountant needs it
Counting stock is the easy part. Valuing it is where people go wrong, and because closing stock sits inside the cost of sales calculation, getting it wrong changes your profit and your tax bill pound for pound.
Three sheets, no macros, a full worked count already filled in.
WHAT’S INSIDE
From the shelf to the profit and loss
A count sheet you can take to the shelf
One row per line of stock, with quantity, landed cost and where it sits. Print it, count it, type it up. The count date, who counted and who checked are on the sheet, because a stocktake that nobody signed is hard to defend later.
The valuation rule, applied for you
Stock is carried at the lower of what it cost you and what you could actually sell it for. Enter a realistic selling price and the workbook applies the rule line by line, showing the write-down separately, which is exactly how your accountant wants to see it.
The bridge into your accounts
Opening stock plus purchases minus closing stock gives cost of sales, and from there gross profit and margin. The sheet also shows what your profit would have been without the write-down, so you can see what dead stock actually did to your accounts.
