Managing Stock Across Multiple Vans and a Warehouse (Without Spreadsheets)

The setup is familiar. A “master” spreadsheet in the office, three vans running on memory, and a merchant run every second morning for a part somebody already had.

Spreadsheet-based van stock management holds together at one van and falls apart at three, and the cracks show up as unbilled materials, duplicate purchases, and techs standing in a merchant queue on your time.

This guide lays out a spreadsheet-free system for running stock across multiple vans and a warehouse, and takes an honest look at how much stock control a business of your size needs in the first place. Less than the software industry tells you, in most cases.

Why Spreadsheets Break Down Once Stock Lives in More Than One Place

A spreadsheet is a snapshot, and stock moves. The moment materials sit in a warehouse and several vans at once, four failures set in:

• Version drift. The office copy, the foreman's copy, and the one on the warehouse PC each tell a different story within a fortnight.

• Nobody updates it from a job. A tech who has been in a loft since 8 am is not opening Excel at 4 pm to log two metres of 15mm copper. The spreadsheet stays wrong from that point on.

• No link to the job. A cell that says “6 × immersion heater” cannot tell you which job used one, so materials leak out of invoices and job costing runs blind.

• Stocktake shock. With no running record of usage, the annual count becomes an archaeology dig, and the write-off at the end of it is a guess.

Whichever market you trade in, the tax office expects accurate records of stock and materials; the UK's business records guidance is typical of what applies everywhere. So the answer is a better system, not less record keeping.

What You Need to Track (and What You Don't)

Stock control comes in two models, and choosing the wrong one costs you either accuracy or admin.

Perpetual inventory keeps a live count of every item in every location: the warehouse shows 41 elbows, van two shows 9, and each transaction moves the numbers.

It is accurate, and it is hungry. Every delivery, transfer, and usage must be scanned or logged at the moment it happens, or the live count becomes fiction with a timestamp.

Usage-based tracking records what each job consumed rather than counting what remains. Materials are logged against the job, vans are restocked to a standard kit based on what they used, and the warehouse is replenished through purchase orders.

You give up the live count and keep the three numbers that pay: what a job used, what it cost, and what to reorder.

For most trade businesses under about 20 field staff, usage-based tracking wins. The van fleet carries a few hundred product lines, not tens of thousands, and the question that matters daily is “did we bill for what we fitted” rather than “how many washers are in van three right now”.

A Spreadsheet-Free Van Stock Workflow

The system below runs inside job management software rather than alongside it, which is the point: stock data gets captured as a by-product of work your team already does.

• Standardise each van's base kit. Write a par list per vehicle type: what a service plumbing van carries, what the bathroom install van carries. Standard kits make restocking mechanical and let any tech take any van.

• Log materials against the job, not the van. The tech picks items from the price list on their phone as they fit them. That single entry feeds the invoice, the job costing, and the restocking data at once, which is why it gets done when a spreadsheet does not.

• Restock from usage. A van restocking report lists what each tech used across the week. Send it to your merchant as the replenishment order, and the van returns to its par kit without anyone counting shelves in the rain.

• Raise purchase orders for the warehouse. Bulk stock comes in against a purchase order, and goods-in gets checked against it. Unordered and short-delivered items surface at the door instead of at the year-end count.

• Import supplier price books and set margin rules. With current supplier pricing loaded and margins set by supplier or category, the same usage entry that restocks the van also protects the profit on every line.

• Build kitsets for common jobs. A standard boiler service or consumer unit change uses the same materials every time. A kitset drops the whole list onto the job in one tap, so logging usage takes seconds rather than minutes.

Keeping the Warehouse Honest

The warehouse needs less technology and more ownership. Give one person the store. When everyone can take stock and no one signs for it, shrinkage is the predictable result.

• Check goods-in against the purchase order before anything hits a shelf, and chase discrepancies the same day.

• Rotate dated goods. Sealants, adhesives, and consumables carry shelf lives; oldest stock goes out first.

• Count quarterly, not constantly. With usage tracked per job, a quarterly count of high-value lines replaces the annual all-day stocktake, and the variance tells you where the leaks are.

• Store it safely. Racking, manual handling, and vehicle movements around the store carry formal safety obligations in every market; the UK's HSE warehousing and storage guidance is a solid model wherever you trade.

Making the Switch Without Losing a Week

Moving off the spreadsheet is a fortnight of mild discipline, not a systems project. The old spreadsheet is not wasted work either; it becomes your starting data.

• Export the product list. The item names and prices in your spreadsheet become the first price list you load, topped up with your merchants' current price books.

• Start with one van. Pick your most switched-on tech, agree the van's par kit, and run the log-and-restock loop for two weeks before rolling it out to the fleet.

• Count each van once. One honest count per van sets the baseline kit. It is the last full count you should need for months.

• Retire the spreadsheet visibly. Archive the file and say so. As long as it stays open on the office PC, half the team will keep feeding it, and you will run two half-systems instead of one whole one.

The test of success is boring: a month in, invoices carry the materials that were fitted, vans get restocked from a report instead of a shelf stare, and nobody has opened Excel.

When You Genuinely Need Live Perpetual Stock

Some businesses do need the live count, and it is better to know before you buy software than after. The signals:

• Serialised or certified parts that must be traced to a specific installation.

• Asset maintenance contracts where you guarantee first-visit fixes from van stock and carry spares against specific equipment.

• Multiple branches or stores transferring stock between locations weekly.

• Twenty-plus field staff, where the working capital tied up in vans justifies a dedicated inventory role.

If that describes you, platforms built around perpetual inventory, such as AroFlo and simPRO, lead that category, and our iTrade vs AroFlo vs simPRO comparison sets out the differences honestly, including where those two go deeper than we do.

If it does not describe you, a perpetual system means paying enterprise money to scan barcodes all day for a count you rarely consult.

How iTrade Handles Van and Warehouse Stock

At iTrade, we built our materials management around the usage-based workflow above, because that is what we used running our own trade businesses.

You can import as many supplier price books as you need, set margin rules by supplier, product, or category, and control which materials and prices your field team sees. Techs log materials against the job from the app, which feeds invoicing and job costing in the same tap.

The Van Restocking report turns each tech's weekly usage into a merchant order, stock usage reporting shows what moves across jobs, and kitsets handle the repeat work.

To be clear about the boundary: iTrade does not currently run live perpetual stock counts across locations.

For the crews we serve, the workflow above answers the daily questions without the scanning overhead, and every part of it is included in the flat price: £29.00 per field worker per month, office admins free, every feature included.

Frequently Asked Questions

What is the best way to manage van stock without spreadsheets?

Run van stock management through your job management software. Give each van a standard kit, log materials against jobs from the tech's phone, and restock from a usage report each week. One entry then feeds the invoice, the job costing, and the reorder list at once.

How do I keep track of stock across multiple vans?

Standardise each van's kit, then track usage rather than counting contents. When every material is logged against a job, a restocking report per van shows what to replace, and the van returns to its known kit weekly. Counting only becomes necessary for high-value lines, quarterly.

Should each van carry the same stock?

Vans doing the same work should. Build par lists per vehicle type rather than per driver: a service van kit, an install van kit, and so on. Standard kits make restocking mechanical, stop techs hoarding parts, and mean any tech can take any van on any morning.

How often should a trade business do a stocktake?

Quarterly, for most. With usage logged per job, a full annual count adds little beyond what quarterly checks of high-value lines already show, and tax authorities require accurate stock records rather than a fixed counting frequency. Investigate variances when they appear, not once a year.

Do I need barcode scanning for van stock management?

Only if you run live perpetual inventory, where every movement must be captured at the moment it happens. Usage-based tracking needs no scanners: techs pick materials from a price list on their phone as they fit them, which takes seconds and doubles as billing data.

Does iTrade track live stock levels?

No, and we say so plainly. iTrade tracks materials by usage: per-job logging, van restocking reports, stock usage reporting, purchase orders, and margin control. Businesses needing live perpetual counts across locations are better served by AroFlo or simPRO, and our comparison page covers that honestly.

Ready to Get Stock Out of the Spreadsheet?

Stock control for a trade business is not a counting problem; it is a billing, costing, and restocking problem.

Solve those three and the spreadsheet retires itself. Curious how many admin hours the spreadsheet is costing you each week? Our time-savings calculator puts a number on it.

If you want to see the workflow on your own jobs, start a free 30-day trial, no card required, with a free one-hour training session included. Or book a free consultation call with our team or email support@itrade.net, and we will talk through whether our approach to van stock management fits the way your business runs.