What a distribution business actually loses on Google Sheets

First, what Sheets genuinely do well

Worth saying, because most software pitches skip it and it makes them sound like they have never run an operation.

A spreadsheet costs nothing. Everyone in your office already knows how to use one — no training, no rollout, no resistance. You can restructure it on a Tuesday morning because the business changed on Monday night, and no developer is involved. It prints. It emails. It does arithmetic you can see and check.

For a distribution business under roughly ten people, a well-built set of sheets is not a compromise. It is the right answer. Anyone who tells you otherwise is selling something.

Then it fails, in this order

01Two people edit the same row

The first failure is small and everyone shrugs at it. Someone overwrites someone else's entry, you spot it, you fix it, you move on.

What matters is not the lost row. It is the response: everyone makes their own copy so it stops happening. Now there are six sheets, six versions of the truth, and no way to tell which is current without asking the person who made it.

02A question needs two sheets joined

"How much did we deliver to this party last quarter, and how much of it came back?" lives across two files that were never designed to be read together.

Somebody spends an afternoon on it. The answer is probably right. Nobody checks, because checking costs another afternoon.

That is the expensive part, and it is invisible in any accounting. Decisions get made on the questions that are cheap to ask.

03The field stops updating anything

You cannot type into a spreadsheet standing next to a bike in the rain, holding a delivery challan, with a customer waiting.

So the field staff don't. The sheet becomes something a biller types up in the evening, from memory and from WhatsApp messages. At that point it is no longer a record of what happened. It is a record of what somebody remembered.

The gap between those two things is where disputed deliveries, unrecorded returns and mysterious stock differences live.

04The sheet cannot hold the evidence

A signed delivery copy is a photograph. A spreadsheet cell is not a place to put a photograph — so it goes into WhatsApp, and WhatsApp is not a filing system, it is a conveyor belt.

Three weeks later a party disputes a bill and the photo is somewhere above four hundred forwarded messages, on a phone that may have been replaced, belonging to a delivery boy who may have left.

05Reconciliation becomes a monthly job with a name

The last stage is the one you can measure. Somebody's calendar has two days a month blocked out for matching what the godown says against what Tally says.

For us it was two full days, every month, for years, and a meaningful share of it turned out to be one specific matching bug rather than anyone being careless.

When reconciliation has a name and a recurring calendar entry, the spreadsheet stopped being enough some time ago. You just absorbed it.

What we did, and what we would say to anyone at stage four

We did not throw the sheets away. We built a system on top of them, and Stemzo still mirrors to Google Sheets today — because the sheets were never the problem. What the phone can do that a sheet cannot is capture things where they happen: a delivery confirmed at the door, a photo attached and filed automatically, attendance marked at the godown gate rather than in a register.

If you are at stage one or two, don't buy anything. If you are at stage four or five, the thing to fix is not the spreadsheet — it is the gap between where work happens and where it gets recorded.