Notebook, Excel or software: what fits a water or aguas frescas business of 1 to 20 people

For a water or aguas frescas business of 1 to 2 people, a well-kept notebook is usually enough. From 3 to 8 people, with one or two routes, Excel starts costing more hours than it saves. And from 9 to 20 people, with several routes, customer credit and loaned jugs, software built for delivery pays for itself with what you stop losing. The useful question is not which tool is best, but how much the one you use today costs you every night.

What fits each business size

1 to 2 people

You produce, you deliver and you collect. You know every customer and who owes you. A notebook works well here because there is only one person writing and one person reading.

What you do need is discipline: one page per day, credit recorded per customer and a count of loaned garrafones (the 20-liter returnable water jugs your customers keep at home). If you can reconcile every night in ten minutes, you do not need anything else.

The sign that you have left this stage is clear: you hire the first person who will sell or collect without you.

3 to 8 people

You now have one or two drivers, someone at the plant and maybe someone in the office. The first serious problem shows up: the information is created by one person on the street and needed by another person in the office.

Many businesses move to Excel or Google Sheets at this point. It is a step forward, but with a hidden cost: someone has to transfer the driver's notes into the spreadsheet. This is the stage to start evaluating software, especially if you sell to stores on credit.

A simple test: for one week, measure how much time someone spends typing and reconciling. If it is more than three or four hours, multiply those hours by what that person's hour is worth and compare it with what software would cost.

9 to 20 people

Three or more routes, several drivers, special orders, daily production and a customer base with credit. At this size, the notebook and Excel no longer control anything: they only record what someone remembered to write down.

The typical symptom is that the owner finds out about shortages days later and cannot tell which route they came from. Another symptom: nobody can quickly answer how much you are owed in total or how many garrafones are out on the street.

The real cost of each option

Notebooks and Excel look free. They are not. You pay for them in hours, mistakes and arguments.

Suppose someone spends an hour and a half every night adding up notes and typing in sales. Over six days that is nine hours a week, almost 40 a month. That is a full work week spent moving data from one place to another.

Add the mistakes on top. A payment nobody recorded, a special price the driver forgot, ten jugs nobody knows who has. For example, if $300 MXN a week slips away between forgotten credit and wrongly charged prices, that is more than $15,000 a year, and nobody sees it because it never shows up anywhere.

Then come the arguments at settlement time, which wear down trust with your team even when nothing is actually missing. A good driver who feels constantly suspected ends up looking for another job.

What a notebook does well

• It costs almost nothing and never breaks down.
• It works without signal or battery.
• There is nothing to learn.
• It is flexible: you write whatever you want however you want.

Its limits: manual sums, illegible handwriting, a lost or soaked notebook, and no history per customer without flipping through weeks of pages.

Where Excel breaks

• Double entry: the driver writes on paper and someone else types it into the sheet.
• A 24-hour delay: today you learn what happened yesterday.
• No access control: anyone can delete a formula, and you do not know who changed what.
• Versions: "sales final", "sales final 2", "sales good one".
• It is not at the stop: the driver cannot see the customer's balance or prices in the sheet while selling.

What software for this trade must have

If you are going to pay for software, it has to solve what is specific to your business. This is the minimum list:

• Batches with expiry dates, especially if you make aguas frescas or juices.
• Returnable containers: how many garrafones each customer has.
• Customer credit with a limit and a balance per customer.
• Special prices per customer that the driver cannot change.
• Fixed routes by day of the week with a stop order.
• A driver app that works without signal. We explain why in your driver's app must work without signal.
• A daily settlement per truck: cash, product and jugs.
• Permissions by job: the driver sees their route, the plant sees production and the office sees collections.
• Supplies and recipes, so you know what each batch costs to produce.
• Sales and collections reports, plus a way to export your data.

You do not need everything else. Software with a hundred features you never use is harder to learn than one with the ten you do.

What a generic point of sale is missing

A retail point of sale is designed for a counter: the customer walks in, pays and leaves. It knows nothing about routes, does not load a truck, does not track loaned jugs and does not settle a driver's day. It may work for sales at the plant, but it leaves out exactly the part where the most money moves.

Red flags when evaluating software

• Per-user pricing. Every new driver raises your monthly bill, and you end up sharing accounts to save money, which is exactly what destroys control.
• It does not work without signal. If they cannot complete a sale in airplane mode during the demo, do not buy it.
• You cannot export your data. Your customers and your sales belong to you.
• There is no trial period, or the contract is annual from day one.
• Setup costs more than several months of use.
• Nobody can explain how a day with credit and jugs gets reconciled.

Repartamos, for example, charges a flat price per business with no per-user fees and offers a 14-day trial; you can review the plans and pricing before deciding.

How to switch without stopping the operation

The most common mistake is trying to change everything on a Monday. This works better:

1. Enter your catalog, your prices and the customers of a single route, with their current credit balance and jugs.
2. Pick the route of the driver most willing to try, not the most complicated one.
3. For two weeks, that route uses the software and the notebook side by side.
4. Compare every night: sales, cash, balances and jugs. Fix prices and balances that were entered wrong.
5. If two weeks in a row match, that route drops the notebook and you move on to the next.
6. The office drops Excel last, once every route is in.

Do not try to move years of history. Today's balances are enough: what each customer owes and how many jugs they have. Keep the old notebooks in case a dispute comes up.

What helps most during the transition is settling with the software from the first day of the trial. We cover how in the driver's daily settlement.

When not to buy software yet

Software does not fix a disorganized business; it only makes the disorder visible faster. Wait if:

• You are one or two people, have few customers and reconcile every night without trouble.
• You do not yet have the habit of settling every day. Start there, even on paper.
• Your drivers do not have a smartphone and you cannot provide one.
• You are about to change how you operate, for example from counter sales to delivery, and do not yet know what your routes will look like.
• Your real problem is selling more, not controlling what you already sell.

Quick checklist

• 1 to 2 people: an organized notebook and a daily reconciliation.
• 3 to 8: measure how many hours go into data entry and evaluate software if you sell on credit.
• 9 to 20: software built for delivery, with a driver app that works offline.
• Ask for a sale in airplane mode during the demo.
• Avoid per-user pricing and software that does not export your data.
• Switch one route at a time, with two weeks running in parallel.