Every month, tens of thousands of Indian shop owners search Google for an Excel billing format. Far fewer search for billing software, and fewer still for a POS.
That tells you something honest about how this decision actually gets made. Nobody wakes up wanting a point of sale system. They want today's bill to go out correctly, and Excel is the nearest thing that works.
It does work, for a while. This article is about the point where it stops, how to recognise that point, and what it is quietly costing you before you notice.
First, what a POS system actually is
Strip out the jargon. A POS, short for point of sale, is the system that records the moment a sale happens. In a shop it usually means billing software plus whatever hardware you point at it: a screen, a barcode scanner, a receipt printer, a cash drawer.
The important part is not the hardware. It is this: a POS records the sale as a list of products, not as a total.
That single difference is the whole argument. A calculator gives you ₹42,000. A notebook gives you ₹42,000 and a date. A POS gives you ₹42,000 and the 63 items that made it up, each with its quantity, rate, tax and time of day. Everything useful that follows, every stock count and every reorder decision, is built out of that list.
What the gap costs
These are industry figures, not our estimates. They describe retail at every scale, but small shops feel them hardest, because a small shop has no buffer.
Read the last two together, because that is the argument in one line. Roughly a third of inventory records are wrong at any given moment, and close to half of small businesses have no system that would tell them.
You are not running out of stock because you are unlucky. You are running out of stock because nobody is counting.
Where the money actually goes
When retailers finally measure the leak, it is never one dramatic loss. It is four or five medium ones that nobody was watching.
Look at the biggest bar. It is not theft. It is empty shelves, which means a customer who came in wanting to give you money and left because the item was not there.
That is the loss with no trace. Theft leaves a gap you eventually notice at stock take. A lost sale leaves nothing at all, and it is the single largest line in the chart.
The same study splits the total into $1.2 trillion of out of stocks and $572 billion of overstocks. Both are the same disease: you do not know what you have.
The four things a POS does
Everything a vendor will show you is a feature sitting on top of these four.
- Records every sale as a line item
Not a total, a list. This product, this quantity, this rate, this GST slab, at this time. The total becomes a by product.
- Moves stock automatically
Every sale takes the count down, every purchase takes it up. You stop walking to the shelf to find out what you have, because the number was never lost.
- Produces a compliant GST bill
The right HSN code, the right CGST and SGST or IGST split, the right invoice sequence, generated rather than typed. The record that serves the customer also serves your filing.
- Turns that history into decisions
Once a year of itemised sales exists, questions that used to be guesses become arithmetic. What actually sells? What should I reorder on Thursday? Which supplier's line is dead?
Step four is the one that pays for the system, and it is the one you cannot skip to. It only works because steps one to three ran honestly, every day, for months. A POS is not a report you buy. It is a record you accumulate.
Excel and the notebook, honestly
Neither of these is stupid. A notebook has run Indian retail for a century, and Excel is genuinely good software. Both simply have a ceiling.
The specific failure mode of a spreadsheet is worth naming, because it is not obvious. A spreadsheet lets you overwrite a number. Somebody corrects a stock figure in March, nobody records why, and from that moment your file is confidently wrong. A notebook at least stays honestly uncertain. That is the trap: the spreadsheet feels like a system while quietly behaving like a guess.
The GST argument, specifically
Indian retail carries a compliance floor that rises with turnover. This is not optional, and it is not something a handwritten book survives past a certain size.
| Aggregate annual turnover | What is required |
|---|---|
| Below ₹5 crore | GST invoices with correct HSN and rate, returns filed from your own records |
| ₹5 crore and above | Mandatory e-invoicing on B2B, export, SEZ and deemed export supplies, every invoice registered on the IRP |
| ₹10 crore and above | E-invoicing plus the 30 day reporting rule, so an invoice must reach the IRP within 30 days of its date |
The ₹5 crore e-invoicing threshold has been in force since 1 August 2023. The trap owners miss: if you crossed ₹5 crore even once in any year since 2017-18, you stay in scope permanently, even if turnover later falls back below it.
Types of POS systems, and which one a shop needs
The category is broader than it looks, and most of it is not aimed at you.
| Type | What it is | Who it suits |
|---|---|---|
| Legacy on premise | Software installed on one billing PC, data stored locally | Shops with no reliable internet, but backups are your problem |
| Cloud POS | Runs in a browser or app, data synced to a server | Most retail shops, and anyone who wants reports from home |
| Mobile POS | Billing on a phone or tablet | Small counters, pop ups, market stalls |
| Self checkout or kiosk | Customer scans and pays without a cashier | Large format stores, rarely worth it below that |
| Restaurant POS | Table management, KOT printing, course timing | Food service, not retail |
For a kirana, supermarket, apparel or electronics shop, the practical answer is a cloud POS that keeps billing when the internet drops and syncs when it returns. Treat continuous connectivity as a thing that will fail, because it will.
The reorder problem is the real prize
Everything above is hygiene. This is the part that changes what the shop earns.
Every reorder decision you make is a forecast. You are predicting demand already. You are just doing it from memory, under time pressure, with a distributor waiting at the counter.
Memory is biased in a specific direction. You vividly remember the item you ran out of last week. You completely forget the twelve slow items sitting in the back, financed by you, taking up the cash you needed for the first one.
Once itemised history exists, the forecast becomes measurable:
- Velocity, what each SKU actually sells per week rather than what it feels like it sells
- Days of cover, how much stock you are holding right now, per item
- Dead lines, what has not moved in 60 days and is currently your money sitting on a shelf
- Seasonality, what moves at festivals, at month end, at the start of school term
And the discipline that keeps all of it honest: stock should be an append only ledger. Every movement, whether sale, purchase, return, damage or correction, gets written down as an event, and the current count is derived from those events rather than typed by a person. The moment somebody can overwrite the stock number, you are back to ghost stock, which is a system that is confidently wrong. That is worse than a notebook, because you trust it.
Be honest: do you need one yet?
Not every shop does. Here is a straight test rather than a sales pitch.
| You are probably still fine | You have outgrown manual billing |
|---|---|
| Under roughly 50 items you know by heart | Hundreds of SKUs, with sizes, variants or batches |
| You are the only person who bills | Staff bill when you are not in the shop |
| Turnover well below the e-invoicing threshold | At or approaching ₹5 crore |
| One shop | More than one, or planning a second |
| One or two suppliers, ordered weekly | Several suppliers on staggered lead times |
| Stock take never surprises you | Counts regularly disagree with what you expected |
| You never wonder what sold last month | You are making buying decisions from memory |
If you are reading mostly the right hand column, the notebook is no longer saving you money. It is costing you margin you cannot see.
What to look for, and what to ignore
And the things that sell POS systems but rarely change a shop's economics: loyalty schemes before you have the footfall to use them, a dozen dashboards nobody opens, and any AI claim made without the sales history to justify it. Intelligence comes after the record, never instead of it.
Common questions
Is billing software the same as a POS?
Mostly yes, in practice. Billing software is the part that produces the invoice. A POS is that plus stock, payments and reporting tied to the same record. Many Indian vendors use the words interchangeably.
Can I just use a free billing software or an Excel format?
For a very small shop, yes, and there is no shame in it. The limits arrive in a predictable order: invoice numbering gets messy, stock stops matching reality, and then you cannot answer what sold last month. When two of those three have happened, you have outgrown it.
Do I need a barcode scanner?
Only once your item count makes typing names slow, usually somewhere past a few hundred SKUs. It is an accuracy tool as much as a speed one, because it removes the wrong item being billed.
Does a POS handle GST filing for me?
It prepares the data, it does not file for you. The value is that your returns get built from records captured at the time of sale rather than reconstructed weeks later.
What about UPI?
You do not need a POS to accept UPI. You need one to reconcile it. When most of the day arrives as notifications on a phone, the question of whether a given bill was actually paid becomes a hunt through screenshots. A POS answers it structurally, by closing a bill only when the recorded payments sum exactly to the total.
The one line version
A POS does not make you money on the day you install it. It starts a record, and three months later that record is the only thing standing between a decision and a guess.