How to Track Vending Inventory Across Multiple Machines
A simple system to track vending inventory across machines: know what is in each one, what to bring next trip and where product disappears.
Key takeaways
- Treat every machine as its own profit center. Route totals hide the machines that lose money.
- On every restock, record units loaded and cost. At the next visit, compare to units sold. The gap is shrinkage.
- Keep a warehouse count too, so you know what to buy before you shop.
- Restock from sell-through data, not a fixed calendar.
Spreadsheets work for one machine and start to crack at three. The beginner-mistakes list from Vending.com includes not monitoring performance: without sales data you cannot tell which products sell or restock the right items. Here is a system that scales.
1. Make each machine its own profit center
A route-bookkeeping guide makes the point well: route-wide totals can hide a money-losing machine. For every machine, track gross sales, product cost, commission, processing fees, service costs like mileage and supplies, and shrinkage. Use the machine's actual product costs, not a route average.
2. Record what goes in, every time
- Units loaded by product, and what they cost
- Date, and any expiration or best-by date
- Anything you pulled out as expired or damaged
3. Compare to what sold
At the next visit, compare units loaded against units sold and revenue recorded. The gap is shrinkage: theft, spoilage, jams, miscounts. Do it every visit and you will see problems in weeks instead of quarters.
4. Restock from sell-through
Skip the fixed schedule. One trading-card operator example restocks the fastest movers weekly and the slowest monthly, and drops products that barely move. The same logic works for snacks: top sellers need frequent attention, slow sellers can wait, and anything that does not sell should be replaced.
5. Keep a warehouse count
Most stockouts happen at home, not in the machine. Count what you keep in storage, set a reorder level for each item, and keep batches with best-by dates so the oldest goes out first. When an item drops below its reorder level it goes on your shopping list automatically.
6. Watch for the common mistakes
- Mixing personal and business money
- Re-entering data between systems, which invites errors. Keep one source of truth
- Averaging costs across the route
- Skipping reconciliation against your bank
What this looks like in practice
Before a route day: open your machines, see which are low, check your warehouse for what you have, and print or open the load list. At the machine: load, record, note anything wrong. After: reconcile. If that sounds like a lot, it should take minutes once the tool is set up. Our lessons on restocking and warehouse stock show exactly how.
For the money side, read how much a machine really makes.
Quick answers
How do I track inventory across multiple vending machines?
Track each machine separately, record units loaded and their cost at each restock, compare against units sold at the next visit to find shrinkage, and keep a separate warehouse count with reorder levels.
How often should I restock a vending machine?
Restock from sell-through data instead of a fixed calendar: fast movers more often, slow movers less often, and replace products that barely sell.
Sources
- Beancount.io: Vending machine route bookkeeping, per-machine commission and cashless fees
- Vending.com: Top beginner mistakes to avoid in the vending business
- VTM Vending: Pokémon machine, $922 profit in 28 days (restock cadence example)
Keep reading
Track every machine and your warehouse
MyVendbook keeps stock, restocks and your warehouse count in one place.
Watch the restock lessonMyVendbook shares general business information, not legal, tax or financial advice. Figures from sellers and vendors are their own claims and examples, not guarantees. Check current rules and prices yourself and talk to a qualified professional before you act.