← All articles

Stock Value and Consumption: The Numbers to Track

Published on 4 min read
Share
A smiling tradesman sitting at a bright desk in his workshop, looking at charts on a tablet, a white van visible through the open door
What the stock is worth and how much you use: two numbers that change the way you order.

Ask a tradesperson how much the stock in their vans is worth and the answer is almost always "no idea". Yet several thousand euros often sit in each vehicle. Knowing how much, and how fast that stock turns over, helps you buy better and prepare the year-end accounts without stress.

Why know the value of your stock

Stock is tied-up cash. Every part sitting on a shelf has been paid for, and earns nothing until it is invoiced to a customer. Knowing the value of this stock serves three purposes:

  • Managing cash flow: growing stock is money not coming into the till.
  • Preparing the year-end accounts: at the end of the financial year, your accountant asks for the stock value at the closing date.
  • Knowing what you are carrying: useful for the vehicle's insurance in case of theft.

1. Enter the purchase price of each item

It all starts here: the value of the stock is the quantity of each item multiplied by its purchase price. Enter it in the item record, preferably at the time of import or creation. If your list comes from a supplier's Excel file, the price is often already there: it imports with the rest.

The record can also hold a margin coefficient and a selling price: handy for pricing a quote without reopening the supplier's catalogue.

Hands holding a supplier invoice next to a tablet on a light desk, in a bright workshop
Enter the purchase price once in the item record, and the stock value calculates itself.

2. Track the value in real time

Once prices are entered, the value calculates itself. The summary shows the total value of the stock, and each vehicle or workshop has its own. You see at a glance where the money is: often the workshop holds most of it, and one vehicle carries far more than the others.

Fleet summary in VanStock showing the stock value per vehicle
The summary: status of each vehicle, alerts and stock value.

3. Measure consumption

Value tells you how much you have. Consumption tells you what you really use. A monthly consumption report, by vehicle, workshop, category or item, answers very concrete questions:

  • which parts go the fastest, and deserve a higher alert threshold;
  • which vehicle uses the most, and why;
  • which part families weigh the most in your purchases.

If you enter the job number with each exit, you also find what went out on each job: a way to check that everything was invoiced.

4. Spot the dead stock

By crossing value and consumption, you quickly spot items that do not move: held in quantity, not taken out for months. These are the first ones not to reorder, to bring back to the workshop, or even to return to the supplier. In a van, freeing up space is a gain too.

5. Prepare the year-end accounts

At the close of the financial year, you need a reliable stock value on a specific date. The method:

  1. Run a stocktake of each vehicle and the workshop just before the close (see the 15-minute stocktake).
  2. Check that purchase prices are up to date, especially on the most expensive items.
  3. Produce the stock valuation report at the closing date, as PDF or Excel, and send it to your accountant.

Stock valuation can be calculated at a past date: if the stocktake is done a few days after the close, you still get the value on the right day. Reports and Excel export are part of the Pro and Enterprise subscriptions.

A smiling tradeswoman and her accountant sitting at a table in a bright office, looking together at a printed report and a laptop
At the close, a stocktake and a stock valuation on the right date: the meeting with the accountant is quickly dealt with.

In short

  • A purchase price in every item record.
  • Stock value tracked by vehicle and by workshop.
  • A consumption report every month to adjust thresholds and purchases.
  • A stocktake and a stock valuation at the close for the accountant.

And to keep these numbers accurate day to day: How to manage your van stock as a tradesperson: a simple method.

Frequently asked questions

How do you calculate the value of a vehicle's stock?

Multiply the quantity of each item by its purchase price, then add it all up. A stock app does it automatically once purchase prices are entered.

What stock value should you give your accountant?

The value at purchase price of the stock present on the closing date, established after a stocktake. A stock valuation report at that date, as PDF or Excel, is generally enough.

How do you spot parts that are not being used?

Compare stock and consumption over several months: items held in quantity but never taken out are dead stock, not to be reordered.

Found this article useful? Share it with a colleague.

Share

Read next

← Back to all articles

Article published on the VanStock blog: https://vanstock.app/en/blog/stock-value-consumption-reports/