A notebook is hard to beat when a vending round is small. It starts instantly, works without a signal and fits in the van. A spreadsheet can then tidy the numbers when you get home.
The trouble rarely arrives as one dramatic failure. It shows up as ten small jobs: entering the same collection twice, checking which commission rate applies, finding an old receipt, correcting a total and trying to remember whether cash from Friday has been banked.
At that point, the issue is not that notebooks or spreadsheets are bad tools. They are being asked to run a process they were never designed to manage.
The notebook works until somebody else needs the answer
Handwritten records make sense to the person who wrote them. That is often enough when one operator services a handful of familiar sites. It becomes less reliable when a driver helps with the round, a site owner asks about an earlier collection or the operator needs to compare two machines over several months.
The same shorthand that feels quick on site can take time to decode later. A figure may be clear, but does it show the gross collection, commission deducted or cash returned to the safe? If a number was corrected, which version is right?
A useful vending record needs context as well as a total. It should identify the site, machine, visit, operator and commission arrangement without relying on somebody’s memory.
Spreadsheets are good at sums, not vending rounds
Spreadsheets remain useful for analysis. They can total columns, compare periods and help with forecasts. They are less comfortable at the point of collection.
On a working round, the operator may need to count coins, apply a site-specific commission rate, record a charity contribution, issue a receipt and move to the next stop. A spreadsheet can be built to handle some of this, but it normally depends on careful cell selection, formulas that nobody accidentally overwrites and a later process for receipts and corrections.
That creates two versions of the job: what happened at the machine and what eventually reached the spreadsheet. Every gap between those versions is another opportunity for delay or error.
Five signs the system is starting to strain
- Cash-ups are entered twice. Figures are written on site and typed into another system later.
- Commission needs checking elsewhere. The current rate lives in a note, message, contract or somebody’s head.
- Corrections replace the original figure. There is no clear history showing what changed and why.
- Site questions interrupt the day. Finding an old collection or receipt means searching through paper, files or email.
- The safe balance is an estimate. Collections and bank deposits are recorded in different places, so the current cash position is never quite certain.
One of these problems may be manageable. Several together usually mean the round has outgrown its record-keeping method.
What should replace them?
The answer is not a bigger spreadsheet. A better system should fit the order in which the work happens.
- Select the site and machine being serviced.
- Record the collection while still at the machine.
- Apply the correct commission or charity arrangement.
- Check the result before saving it.
- Give the site a clear receipt or collection record.
- Carry the cash movement into a running balance.
It should also keep corrections visible. Mistakes happen on busy rounds; the important point is being able to see what changed rather than silently replacing the first entry.
Keep the spreadsheet, but give it a smaller job
Moving to dedicated vending records does not mean every spreadsheet must disappear. A spreadsheet can still be useful for one-off analysis or planning. It simply stops being the main record of what happened on the round.
VendMetrix is designed around that distinction. It records cash-ups, commission, receipts, routes, safe movements and reports in a browser-based system built for UK vending work. The VendMetrix features page explains the current tools in detail.
The software was shaped by day-to-day vending work rather than adapted from generic stock software. You can read more about that background on the Our Story page.
Make the change before the paperwork becomes the round
A growing round creates more collections, more commission records and more questions. If the administration grows at the same rate, extra sites do not always feel like progress.
The right time to change is when the current method still works, but only because one person is spending too much time holding it together. A cleaner record made at the machine gives the rest of the business something dependable to work from.