Vending Machine Business Spreadsheet, Vending Route Tracker, Restock Inventory and Profit Tracker, Printable PDF

Instant digital download: vending machine business spreadsheet. You get 2 .xlsx files (blank and filled-in example), a printable PDF and a quick start guide. Nothing physical ships.

A vending machine business spreadsheet for a small snack or drink route. Log each service visit with the cash and card you collected and the units you loaded, and it works out what each machine earns, what to bring on your next route and what you owe each site.

WHAT YOU GET
- Vending-Route_Blank.xlsx: empty, ready for your own route
- Vending-Route_Example.xlsx: the same workbook filled in with 4 sample machines, 8 products and 19 service visits
- Vending-Route_Printable.pdf: 2 pages on US Letter paper, a blank visit sheet and a blank refill sheet to fill in by hand on the route
- README.txt: quick start

HOW IT WORKS
1. Settings: your card fee, a restock cushion, the weekly profit that flags a weak spot and a cash gap warning.
2. Products: each product with the case price, units per case and what it sells for. Unit cost and margin are worked out.
3. Machines: each machine with its location, the site's share of sales, any monthly fee, the date you placed it, and Yes if it is on your next route.
4. Visits: one row per service visit with the cash and card collected. Expected sales come from the units you loaded, and a visit turns pink when you collected less than expected.
5. Refills: one row per product you loaded on that visit.
6. Restock List: units to bring for every machine marked Yes, cases to open and the cost of the load.
7. Commission: pick From and To dates to see what each site is owed.
8. Profit by Machine: sales, product cost, fees, profit and profit per week for each machine, with a Move? flag for machines under your weekly target.

WHAT MAKES IT DIFFERENT
- Profit per machine per week, so you can see which spots earn their place.
- A restock list built from what each machine actually sells.
- A cash gap check on every visit, worked out from the units you loaded.
- Site commission for any date range, worked out for each location.

THE FILES
9 tabs: Start Here, Settings, Products, Machines, Visits, Refills, Restock List, Commission, Profit by Machine. Up to 30 machines, 40 products, 300 visits and 1,000 refill rows. Cream cells are for typing and white cells calculate. Formula cells are protected with no password, so you can unprotect them in Excel with Review > Unprotect Sheet. No macros. The sample locations and products are made up and generic.

THE PRINTABLE PDF
Two pages, US Letter: a blank visit sheet (date, machine, cash, card, total) and a blank refill sheet (date, machine, product, units added).

WORKS IN: Microsoft Excel 2016 or newer, and Google Sheets (File > Import > Upload > Replace spreadsheet; layout may look slightly different). Apple Numbers: not tested. The tabs are laid out narrow for phone screens, but it has not been tested on a real iPhone or Android phone, so a computer is easiest for setup.

THIS IS NOT an app and it does not connect to your machines or card reader. It tracks products per machine, not slot by slot. Units sold are taken as the units you load to fill each machine back up, so start logging from the first service visit, not the first fill. Commission uses sales before card fees; check your site contract.

PHOTOS: the listing photos are screenshots of the actual files and the actual PDF. They are not mockups.

INSTANT DOWNLOAD. Nothing physical ships. For personal use only. Please do not share or resell the files.

Designed with the help of AI tools, then reviewed and tested by me.