Setting minimums that actually work
Start with how many of each part a tech uses in a typical week. Set Full load to that number and Minimum to about a third of it.
Adjust after a month — parts that run out often need a higher minimum.
Free template · Excel & Google Sheets
Free van stock template for service trucks
Keep every van loaded with the right parts. List what each truck should carry, set minimum and full levels, and let the sheet tell you what to restock.
The Excel file includes working formulas in the “Restock” column, filters and 50 ready-to-fill rows. Open it in Excel or upload it to Google Sheets.
| Van / tech | Part name | SKU | On van | Minimum | Full load | Restock |
|---|---|---|---|---|---|---|
| Van 1 – Sam | 1/2" copper elbow | CU-ELB-12 | 4 | 10 | 30 | auto |
| Van 1 – Sam | PTFE thread tape | PTFE-12 | 12 | 5 | 20 | auto |
| Van 2 – Lee | Run capacitor 45/5 µF | CAP-455 | 1 | 2 | 6 | auto |
| Van 2 – Lee | Wire nuts (box) | WN-BOX | 3 | 2 | 4 | auto |
A simple restock routine
- Tech updates On van at the end of the day.
- Filter the Restock column for RESTOCK.
- Load the quantity shown before the next shift.
Running more than one van? Stop chasing spreadsheets.
In StockSimple each van is a location. Techs scan parts out on their phone, restock from the warehouse in a few taps, and you can see which van has a part before anyone drives to the supplier. 14-day free trial.
Try StockSimple freeFrequently asked questions
What is a van stock list?
A van stock list is the agreed set of parts and quantities each service vehicle should carry, with a minimum level that triggers a restock from the warehouse.
How does the reorder flag work?
The Excel file compares On van with Minimum for each row. When stock is at or below the minimum, the Restock column shows RESTOCK and how many to load to reach the full level.
How often should van stock be checked?
Most service businesses do a quick check weekly and a full count monthly. High-use parts are best restocked at the end of every day.
Can I use this in Google Sheets?
Yes. Download the CSV and import it, or upload the Excel file to Google Drive — the formulas carry over.
When should I move van stock into an app?
When you run more than one or two vans, or techs forget to update the sheet. StockSimple tracks each van as its own location, lets techs scan parts out from their phone, and shows which van has a part right now.
More free inventory tools
Free SKU generator
Clean, consistent product codes with CSV export.
QR code inventory labels
Printable QR label sheets for bins and products.
Asset tag generator
Numbered QR asset tags for tools and equipment.
Bin location generator
Zone-aisle-rack-shelf codes for every shelf.
Inventory spreadsheet template
Excel & Google Sheets stock sheet with formulas.
Tool checkout sheet
Sign tools out and back in by person and job.
Formulas guide
Worked examples of every formula, in plain language.