The driver's daily settlement: how to reconcile cash, product and water jugs in 15 minutes

The driver's daily settlement is reconciled by comparing three balances when the truck comes back: expected cash (the cash float plus cash collected minus approved expenses paid with that cash) against what the driver hands over, product loaded against product sold, returned and wasted, and recorded water jugs against the empties the driver brings back. If the route's sales are already recorded and synced, reviewing all three takes about 15 minutes. Any difference gets a note that same day instead of being argued from memory the following week.

The water jugs here are garrafones, the 20-liter returnable jugs that Mexican water businesses swap empty for full at each stop. We keep the word garrafón below.

The three balances you need to reconcile

A settlement that only counts bills is half done. The driver handles three things of value: money, product and containers. If you check only one, differences hide in the other two.

Expected cash

The formula is simple:

Expected cash = cash float + cash collected − approved expenses paid with route cash

Suppose, as an example, that the driver left with a $500 float to give change, collected $6,800 in cash between sales and payments on store credit, and bought $600 of gas with route cash, keeping the receipt. If the expense is approved, expected cash is $500 + $6,800 − $600 = $6,700.

Notice what does not go into that calculation:

• Bank transfers, which land in the bank and are reconciled separately.
• Sales on credit, which raise the customer's balance but bring in no money.
• Card payments, which are settled by the payment processor.
• Expenses paid with a gas voucher or a petty-cash card, because they did not come out of route cash.

Product

The rule is that everything loaded has to be somewhere:

Loaded = sold + leftovers coming back + waste + shortage

For example: the truck left with 60 full garrafones. The driver sold 52, brings 7 full ones back and one broke on the route. 52 + 7 + 1 = 60, so it balances. If the driver brought back 6 full ones, one would be missing, and that gets recorded.

Customer returns count too. If a corner store sent back six bags of agua fresca, a sweetened fruit or flower drink, because they arrived warm, those bags go back to the truck's stock or are recorded as waste, depending on their condition.

Garrafones

The empties the driver brings must match the container returns recorded on the route. If 30 returns were recorded and the driver brings 27 empties, there are three garrafones to clear up. If you want to go deeper into tracking per customer, we explain it in how to keep track of the jugs you lend.

Before you start: route closed and nothing pending

The settlement is only reliable if everything that happened on the street is already recorded. If the driver's phone still holds unsynced sales because it was out of signal, the office sees incomplete numbers:

• Expected cash comes out lower than reality and it looks like there is extra money.
• Product sold comes out lower and it looks like merchandise is missing.
• Store credit and garrafón balances for those customers are wrong.

That is why the first rule is to never close the settlement with sales still waiting to sync. Ask the driver to connect to the business wifi and confirm nothing is pending. In Repartamos the settlement does not close while the phone has unsynced sales; it can only be forced with a reason, which is recorded. To understand why a delivery app must save everything even without signal, see a delivery app that works without signal.

The step-by-step routine when the truck returns

This is a routine of about 15 minutes per truck, always in the same order and in front of the driver:

1. Close the route, 2 minutes. The driver marks the route as finished and confirms there are no sales, payments or expenses left to send.
2. Review expenses, 3 minutes. The office reviews each expense of the day with its receipt and approves or rejects it. Now expected cash is final.
3. Count the cash, 3 minutes. The money is counted in front of the driver and the declared cash is recorded. The difference against expected cash shows up on its own.
4. Count the product, 4 minutes. Leftovers are counted by product size and, if you track expiry, by batch. Waste is recorded with its reason.
5. Count the garrafones, 2 minutes. The empties are counted and compared with the recorded returns.
6. Close, 1 minute. Differences get a clear note and the settlement is closed. Leftover product goes back to the warehouse.

Order matters. If you count the cash before reviewing expenses, the expected number can still change and the conversation gets complicated.

Expenses with receipts: no more "I spent it on gas"

Many arguments at the end of a route come from expenses nobody wrote down: gas, tolls, a tire, lunch. If the driver mentions them from memory at the end of the day, the office has doubts and the driver feels accused.

The fix is to record every expense the moment it happens, with a photo of the receipt or the note. Clear rules prevent half of the arguments:

• No receipt, no approval.
• An approved expense paid with route cash lowers expected cash.
• A rejected expense does not lower it, and the rejection comes with a reason the driver can see.
• Whatever is paid with a gas voucher or a petty-cash card is reviewed separately and does not change expected cash.
• The settlement is not closed while any expense is still waiting for review.

What to do when there is a difference

A difference is not automatically theft or carelessness. Before talking about blame, check the most common causes:

• A sale the phone has not sent yet.
• A payment recorded as cash that was actually a transfer, or the other way around.
• A payment on store credit that was collected but not recorded.
• An expense that was not entered, or was entered with the wrong amount.
• Product that was miscounted when loading in the morning.
• Wrong change given at some stop.

If the difference remains after that review, record it with a specific note: how much, of what and what was agreed. Do not close with a silent difference. If the cause turns up days later, for example a transfer that arrived late, reopen the settlement with a reason and correct it, instead of "making up for it" in another day's settlement.

Agree with your team in advance on how differences are handled. Decisions made in the heat of the moment, in front of a shortage, almost always end badly.

How to avoid blaming the driver

The driver wants the same thing you do: finish the route and not pay out of pocket for mistakes they did not make. A few practices help keep the settlement fair:

• The cash float is handed over and recorded in the morning, and the driver confirms how much they received.
• The load is counted with the driver before leaving. If the starting point is wrong, everything after it is wrong too.
• Each customer's special prices are already on the driver's phone, so they do not depend on memory.
• The settlement happens in front of the driver, who can see the summary of their own route: float, cash collected, approved expenses and rejected expenses with their reason.
• One difference is an event; a repeated one is a pattern. If the same shortage shows up with different drivers on the same route, review the process before the person.

If you still run all of this in a notebook, in notebook, Excel or software for your water business we compare the options calmly.

Quick checklist

• Reconcile three balances: cash, product and garrafones.
• Expected cash = float + cash collected − approved expenses paid with that cash.
• Do not close with unsynced sales.
• Review expenses before counting the money.
• Count cash, product and empties in front of the driver.
• Record every difference with a note; never hide it.
• Correct with a reopening, not by compensating on another day.
• Look for patterns before looking for culprits.