Excel vs POS software: when a spreadsheet stops being enough

Is Excel good enough for a shop?

For many shops, yes. Excel is good enough when one person enters all the data, the product list is short enough to check by eye, credit is paid back within days, and nobody needs a printed receipt or a tax invoice. It costs nothing extra, works with the internet off, the file belongs to you, and no company can change the price or shut it down. A spreadsheet a shopkeeper keeps up to date is better than POS software they gave up on in month two.

What does Excel do better?

Excel has real advantages, and no POS matches all of them:

• It's already there. No signup, no trial, no decision: open it and start typing today.
• It costs nothing beyond the computer you already bought, so there's no monthly fee in a slow month.
• Most people know a bit of it. Your accountant, your son, the shop next door can all help, so you're never waiting on support.
• It fits your shop's habits. Odd units, an unusual discount rule, a column only you understand: Excel allows all of it, where software often pushes back.
• It works with no internet at all, permanently, with no sync to wait for.
• The file is yours. Copy it to a USB, email it, open it in ten years. Nobody can lock you out.

Who should stay on Excel?

Stay on the spreadsheet if your shop has one counter, one person entering everything, a product list you can scroll through in a minute, little udhaar left unpaid beyond a week, no staff to keep an eye on, and no customer who has ever asked for a tax invoice. For that shop the sheet is the right tool, and a monthly fee would pay for a problem you don't have.

Where does a shop spreadsheet actually break?

A spreadsheet breaks in specific, ordinary ways, because it holds numbers instead of recording what happened. At a counter, that looks like this:

Two people, one file

Once a second person enters sales, the file itself becomes the problem. One of you has it open and the other can't save. So a second copy appears, "hisab-final.xlsx", then "hisab-final-2", and now there are two versions with no way to merge them. Cloud editing helps, but it needs a connection at the counter, which many shops don't have.

A formula that gets overwritten without warning

Someone types a number into a cell that held a formula. Nothing warns anyone. The sheet still shows a figure, the figure is now wrong, and you won't find out until something doesn't match weeks later. This is the most common way a shop sheet goes wrong.

Stock that's only right on the day it was typed

A "current stock" column shows the last time someone remembered to update it. Every sale you don't type in makes it more wrong, always in the same direction. A number that was right on Monday and hasn't been touched since is still Monday's number, whatever today's date is.

No record of who changed what

A spreadsheet holds a cell's current value, not its history. If a total looks wrong, you can't see who changed it, when, or what it said before. With one person that's fine. With three people and a shortfall, it's the one question you need answered, and the sheet can't answer it.

Udhaar without dates

Most shop sheets keep credit as one number per customer, updated by hand. That tells you what Ahmed owes, but not since when or which sales make up the total. So when he says "itna nahin tha", you have a number and he has a memory. You can keep dated lines per customer in a sheet, but it's a lot of typing, every day.

Two more common problems

• A VLOOKUP against a fixed column, or a sum over a fixed range, breaks without warning when someone inserts a row or sorts the wrong selection. The sheet still calculates, but it's adding up the wrong cells.
• Excel prints a page. It doesn't print a till receipt or a sales tax invoice, so a customer who wants an itemised bill, or a business buyer who needs the tax shown separately, can't get one from the sheet.

When does a spreadsheet start costing money?

When it starts giving you numbers you can't act on. If three or more of these are true, the sheet now costs more than it saves:

1. 1More than one person needs to enter sales, and you've made a second copy of the file at least once.
2. 2You've found a wrong total and couldn't work out when or how it went wrong.
3. 3You order stock you already have, or run out of something the sheet says you're holding.
4. 4You can't say what one customer owes, with dates, without adding it up yourself.
5. 5Someone asked for an itemised receipt or a tax invoice and the sheet couldn't produce one.
6. 6You spend more than twenty minutes a day typing into the file. That time is what the sheet really costs you.

What does moving off Excel involve?

The real cost is mostly typing: your product list has to be in the new system, with prices, before you can bill from it. For a few hundred products that's an evening or two. The good news is that a spreadsheet is the easiest thing to move from, because the products are already in rows and columns, the shape an import needs.

1. 1Tidy the product sheet: one row per product, with a name, a selling price, a cost price if you have it, and a barcode if it has one.
2. 2Bring in the products you actually sell every week, not the whole old list. Items that no longer sell can wait.
3. 3Count your fast movers by hand and enter those as opening quantities. If you skip this, the stock is wrong from day one.
4. 4Enter your regular udhaar customers with their current balance as an opening amount. That's the only history worth typing.
5. 5Run both for a week: sell through the new system and keep the sheet alongside only as a check.
6. 6Compare at the end of the week. If the numbers agree, stop updating the sheet, but keep the file.

Who should not move yet?

Some shops should keep their money and their sheet:

• A one-person shop with a short product list and credit that's paid back within days. The sheet does the job, and a monthly fee buys nothing you'd notice.
• A shop where the sheet is accurate and updated daily by someone who doesn't mind doing it. If it works, switching costs money and saves nothing.
• A shop about to change owners, close or move premises. Don't start a move you won't finish.
• A shop that needs a higher plan than it can afford. Multi-branch and stock transfers are on Scale at Rs 11,999 a month. Restaurant mode (recipes, food cost, tables, the kitchen display) and pharmacy batch and expiry tracking both start on Growth at Rs 6,999. The AI assistant isn't on Starter at all. Check the price of the plan that has what you need, and if that number doesn't work today, wait.

What do you get in exchange?

You give up total flexibility and a zero monthly cost. In return, every sale is recorded as it happens: one entry lowers the stock, raises the customer's balance and adds to the day's total. NexusTill does this offline, prints the receipt or the tax invoice from the same sale, and keeps each customer's khata dated where you bill. Starter is Rs 2,999 a month for one till and two users, each with their own login, which solves the "two people, one file" problem. Growth at Rs 6,999 goes up to 5 tills and 5 staff.

Test it against your own sheet: the trial is 7 days, needs no card to start, and doesn't turn into a paid plan on its own. Run both for the week and compare the numbers at the end. If the spreadsheet wins, you've spent a week and learned something useful.

Excel records what you remembered to type. Whether that's enough depends on whether your shop still fits in one person's memory.

Written by The NexusTill team.