Two ready-to-use templates: one tells you what to take from the warehouse before your route, the other whether the cash adds up every time you empty a machine. They come with a made-up example so you can see how they work.
Free, no sign-up No macros Excel, LibreOffice, Numbers or Google Sheets
You enter what is left in each slot and it tells you how many units of each product to load, in full cases and loose units, for the machines you visit today.
From the counters, what was paid by card and the cash you count, it works out what should be in the cash box and turns red when money is missing.
The load list, step by step
In the «Products» sheet, one row per product with the units each case holds. You only do this once.
In each «Machine» sheet, one row per slot: the code, the product (picked from a list), the price and the capacity.
Enter in «Left» what is in each slot, or what you estimate is there. The «To load» column fills itself in.
In «Load list», put «Yes» under the ones you are visiting. It tells you how many units of each product to take and how many full cases that makes.
An example
This is the example the template comes with: a gym and an office. The list adds up what is missing in both and turns it into cases.
| Product | Gym | Office | To load | From the warehouse |
|---|---|---|---|---|
| Water 50 cl | 7 | 7 | 14 | 1 case of 12 and 2 loose |
| Crisps | 7 | 8 | 15 | 15 loose |
| Cola, can | 6 | 3 | 9 | 9 loose |
| Biscuits | 6 | 3 | 9 | 9 loose |
| Orange juice | 2 | — | 2 | 2 loose |
| Total | 28 | 21 | 49 |
The cereal bar does not appear: its slot was full.
To be honest
The sheet does not know how fast each slot sells: either you count in front of the machine or you guess. Repónlo works it out from what you left on the last visit and each slot's sales rate.
You can write dates down, but nobody reminds you on the day. Repónlo flags the lots that expire in the next 30 days.
If there are two of you, you end up with two versions of the file. In Repónlo everyone signs in with their own user and works on the same data.
Questions
No. Only ordinary formulas (IF, SUMIF, COUNTIF), so they open without security warnings and work the same in Excel, LibreOffice, Numbers or Google Sheets.
Upload the file to Google Drive and open it with Google Sheets. The formulas and drop-down lists are kept.
Duplicate a «Machine» sheet, rename it and add its column in «Load list» by copying the formula from the one next to it.
From the machine's sales counter, which shows the total sold in money. Your payment provider tells you what was paid by card. We explain it in how to reconcile the cash.
No. Click and the file downloads: no email and no account.
Yes. The «Products» and «Machine» sheets have the columns its import recognises: you upload the same file, first for the products and then for each machine.
More things that eat into the route
Repónlo works out what each machine is missing from its sales rate and gives you the list ready before you leave. Free for one machine.
Start free with one machine