Khata, Excel or POS App for Shop Stock?

For shop stock management, a paper khata is fine at the very beginning, Excel is better for a small and simple product list, but a POS app like Tukri is usually the best option once stock changes every day, multiple people sell, and you need live stock, stock movement history, low-stock alerts and reliable stock valuation.

In Bangladesh, many small shop owners start with what is already in hand: a notebook, then maybe an Excel file on a laptop, and only later a proper retail inventory app. That path is normal. The real question is not which method sounds modern. The real question is which one still works at 10 pm, after a busy day, when one staff member sold on the counter, another received stock, and you are trying to remember whether a missing box was sold, damaged or never entered.

What is the difference between khata, Excel and a POS app for stock?

The difference is how stock gets updated, checked and trusted.

• Khata means you write purchases, sales and counts by hand.
• Excel means you keep product rows and stock numbers in a spreadsheet.
• POS app means stock updates automatically when you sell, receive, return or adjust products.

Here is the practical comparison many shop owners ask for:

A notebook is honest and familiar. Many owners still trust it because they can touch it. But once the product count grows, the main weakness appears: the number on the page is not always the number on the shelf.

Excel is a step up because you can sort items, search names and total columns. But Excel still depends on disciplined manual entry. If a pharmacy sells a strip from a box, or a grocery buys in a carton and sells by piece, spreadsheets become fragile unless someone updates every movement correctly.

When is a paper khata still enough?

A paper khata is still enough if all of these are true:

1. You sell a small number of items.
2. One person mainly handles buying and selling.
3. Stock changes are not frequent.
4. You do not need exact profit or stock valuation.
5. You can physically count items quickly.

For example, a very new roadside shop with a limited selection may not need software on day one. Writing down what came in and what went out can be enough for a while.

But shop owners commonly find that the pain starts when:

• the same item comes in different sizes or colours
• stock is bought in packs but sold loose
• staff forget to update the notebook during busy hours
• you need to know which items are about to finish
• you want to see whether missing stock was due to sale, damage or a counting mistake

At that point, khata becomes a memory test, not a stock system.

Is Excel good enough for inventory tracking in Bangladesh?

Excel is good enough for basic inventory tracking in Bangladesh if your shop has a modest catalog, one careful operator and low transaction volume. It is much better than guessing.

For some shops, Excel is a sensible middle step because it helps with:

• product lists
• simple stock counts
• filtering by category
• basic reorder planning
• rough stock value calculations

Still, the common problems are easy to recognise in real shops:

• one file lives on one device
• formulas break when rows change
• staff overwrite numbers
• sales happen first and entry happens later
• there is no clean stock movement history
• returns, damaged goods and count corrections become messy

This is where a POS app is different. In Tukri, stock is not just a single editable number. There is a live stock balance with an immutable history of every movement. If you receive stock, sell it, return it, or make a stock adjustment for damage, loss or count correction, that trail remains visible.

That matters in everyday retail. In a busy muri or grocery shop at closing time, the owner often does not ask, "What number is written?" The owner asks, "Why is this number different from the shelf?" A movement history answers that better than a spreadsheet cell.

Why do many small shops switch to a POS app for stock?

Many small shops switch because a POS app reduces manual stock work at the same point where selling happens.

With Tukri, the stock side connects to daily retail tasks:

• Quick billing reduces missed entries because selling and stock deduction happen together.
• Fast product search by name, SKU or barcode helps at the counter.
• Barcode scanning works with a USB scanner or phone camera.
• Product variants let each size or colour have its own price, barcode and stock.
• Pack and loose units let you buy in a box, carton or sack and sell in pieces or weighed units with automatic conversion.
• Low-stock alerts show what is running out.
• Stock valuation helps you see what your current stock is worth.
• Sale returns restore stock correctly.
• Purchase receiving updates cost when new stock arrives.

This is especially useful in Bangladesh for pharmacies, groceries, hardware and clothing shops where the same item may come in batches, units or variants.

A pharmacy is a good example. Shop owners commonly need to receive medicine by batch, track expiry, and sell the earliest-expiry stock first. Tukri supports batch numbers, expiry dates and FEFO, so the stock method matches how perishable and medicine inventory is actually handled.

Which stock features matter most once a shop grows?

Once a shop grows, the best stock system is the one that answers operational questions quickly and accurately.

The features that matter most are usually these:

1. Live stock
   You need to know current stock without waiting for tonight's manual update.

2. Stock movement history
   You need a checkable trail for every sale, purchase, return and adjustment.

3. Low-stock alert
   You need to know what to reorder before customers hear "finished" too often.

4. Stock adjustment
   Real shops have damage, loss, expiry and count correction. These should be recorded clearly, not hidden by overwriting a number.

5. Stock valuation
   You need to know how much money is sitting in stock, not only how many pieces are on the shelf.

6. Team controls
   If staff sell and receive stock, permissions matter. In Tukri, staff can sell and receive stock but cannot see profit or settings.

7. Offline reliability
   Internet is not always stable. Tukri works offline and syncs when back online, which matters on inexpensive phones in local shop conditions.

So which option is the best for a small shop?

The best option depends on the shop stage, but for most growing shops, a POS app is the most reliable way to keep stock correctly.

Use this rule of thumb:

• Choose khata if your shop is brand new and very small.
• Choose Excel if you want a basic digital list and transactions are still limited.
• Choose a POS app like Tukri if you sell daily, carry many items, have staff, need barcode use, want low-stock alerts, or need dependable inventory tracking in Bangladesh.

For many owners, the switch becomes worthwhile earlier than expected. Not because software is fashionable, but because missing stock costs real money. A silent stock mistake repeats itself: you reorder late, overbuy slow items, or think you made a profit when the shelf says otherwise.

If you want to move beyond notebook guesses and spreadsheet corrections, try Tukri at tukri.bd. It is built for Bangladeshi small shops, works offline, and gives you stock records that are easier to trust at the end of a long business day.