Stop the extra supply-house runs. Know what's on every truck and what to reorder.
Set a par list for each truck, van and the shop: minimum, target and your last count. Log what comes off the truck and the sheet works out what's on hand and flags REORDER and OUT.
The Restock List builds itself with order quantities and cost, and the Summary breaks stock value and restock cost down by location and by supplier.
What's included:
Truck Stock & Inventory Tracker (.xlsx) with example stock
BLANK copy, ready for your trucks
5 trade example files: plumbing & HVAC, electrical, landscaping, cleaning, painting
2-page quick-start guide (PDF)
Instant download (.zip)
Works in Google Sheets and Excel 2010+. No macros, no add-ons, no subscription
Formulas locked so they can't be typed over; light copper cells are yours to fill in
Built for small trade businesses: electrical, plumbing, HVAC, roofing, landscaping, painting, cleaning, handyman, pest control, general contracting. Rename the job types, crews and items to fit yours. Example data is made up. This is an organizing tool, not accounting, payroll, tax or legal advice.
Want the prices your numbers need? The Flat-Rate Pricing Calculator works out your real hourly rate and flat-rate prices. Or get all 5 spreadsheets in the Trade Business Spreadsheet 5-Pack for $49.



