Inventory Management for Bangladesh SMEs: Systems That Work Without Big Software Budgets

Picture a typical shop in Kawran Bazar, Chawkbazar or a district-town market. Ask the owner how much stock is sitting in the back room and you may well get a confident estimate rather than a figure written down somewhere.

That gap between estimate and record is where money tends to leak: expired medicine written off, a fast seller running out the week before Eid, cash sitting in cartons nobody has touched for months.

Inventory management for Bangladesh SMEs does not need an ERP licence or an IT team. It needs a few honest numbers, written down every day, and a routine for checking them. The country's SME sector runs largely on thin margins and supplier credit, which makes stock control one of the cheapest ways to protect profit.

This guide covers the stock movements every system must record, how to set reorder points and order quantities, three low-cost systems (with a working spreadsheet example), controls for different business types, counting and expiry routines, the measures that show whether the system is working, the VAT records that overlap with stock tracking, and a 30-day setup plan.

Why Stock Problems Hit Small Businesses Harder

A large company can absorb a bad stock decision. A small one usually cannot, because stock is often its single biggest use of cash. When a wholesaler gives 30 days of baki and the goods sit unsold for 60, the owner pays the supplier from somewhere else, often personal savings or a costly informal loan.

Four patterns show up again and again in Bangladeshi SMEs:

• Dead stock: items bought in bulk for a discount that never sell through, especially in fashion, mobile accessories and seasonal goods.

• Stockouts on bestsellers: the product customers ask for most runs out because nobody noticed it dropping.

• Shrinkage: goods that leave without a sale, through staff theft, damage, short deliveries or free samples nobody records.

• Overselling online: an f-commerce page takes orders for items that sold out in the physical shop that morning.

Each of these starts as a record-keeping problem before it becomes a technology problem. Better records will not stop theft, damage or supplier failures on their own, but they make losses visible early enough to act on.

Good stock data also feeds directly into cash flow planning, since every taka sitting in the godown is a taka you cannot spend on rent, salaries or growth.

Inventory Management for Bangladesh SMEs Starts With a Stock Ledger

Every inventory system, from a khata to a full ERP, rests on one equation per product: closing stock equals opening stock plus everything that came in, minus everything that went out. Record every movement that changes physical stock, not only purchases and sales, and check the result against regular physical counts.

Purchases and sales are only part of the picture. A usable ledger records each of these movement types separately:

Every adjustment needs a written reason and the name of the person who approved it. Without that, the ledger quietly absorbs theft and errors.

Track movements per SKU (stock keeping unit), so every variant gets its own line. Size 32 and size 34 jeans are two items; so are a 500 ml and a 1 litre bottle of the same oil. Fix one base unit per item as well. If you buy biscuits by the carton of 24 and sell by the packet, record everything in packets, or convert the same way every time.

Setting a Reorder Point

A reorder point tells you when to place the next order, before the shelf is empty:

Reorder point = (average daily sales × supplier lead time in days) + safety stock

Take a pharmacy in Mirpur that sells about 12 strips of a common antacid a day. Its distributor delivers within 3 days, and the owner keeps 2 days of sales as safety stock. The reorder point is (12 × 3) + 24 = 60 strips.

Compare the reorder point with your inventory position, not just the shelf: usable stock on hand, plus stock already on order, minus anything reserved for customers. Otherwise you may place a duplicate order while a delivery is still on the way. Damaged, expired or quarantined units never count as usable.

Choosing Safety Stock

The two-day buffer above is an example, not a rule. Set safety stock per product based on how much daily demand swings, how reliably the supplier delivers, how much the item matters to customers and what running out would cost you.

A supplier who usually delivers in 3 days but sometimes takes 5 needs a bigger buffer than one who is never late. Averages from a quiet month also understate peak demand: sales of sugar, oil and semai before Eid can run at several times the normal rate, so recalculate using the same weeks last year and this year's sales trend.

Deciding How Much to Order

The reorder point answers when to order. The order-up-to method answers how much:

Order quantity = Target stock level − Inventory position

• Target stock level = expected demand during the review period and the supplier lead time, plus safety stock

• Inventory position = usable stock on hand + confirmed stock on order − backorders (sales already promised but not yet supplied)

Say a product sells 5 units a day, you review stock every 7 days, the supplier takes 3 days, and safety stock is 10 units. The target is (5 × 10) + 10 = 60 units. With 35 usable units on hand, 10 already on order and no backorders, the inventory position is 45, so you order 15.

Then adjust for the real world: round up to the supplier's pack size or minimum order quantity, order less of anything close to expiry, and raise the target ahead of known seasonal peaks. These methods assume reasonably steady demand and delivery; for erratic items, review more often and hold a larger buffer.

Bulk discounts are worth taking only on items that sell steadily. A small discount seldom pays for stock that sits for months, ties up cash and risks damage or expiry.

Three Low-Cost Inventory Systems That Work

The best system is the simplest one your team will update every single day. A capable app that staff ignore is worse than a notebook they fill in faithfully.

The Structured Khata (Stock Register Method)

Most Bangladeshi traders already keep a khata for credit sales. Add a separate stock register with one page per product and columns for date, movement type, reference (challan or memo number), quantity in, quantity out and running balance.

This only works if sales are captured item by item, through itemised cash memos or a product-wise tally sheet at the counter. A day's total cash figure cannot tell you which SKU sold. Every delivery is counted and written in before it reaches the shelf, and the day's item-wise sales are posted at closing.

The cost is a register and a short daily routine, which grows with the number of items you sell each day. The weakness is analysis: a paper register cannot easily rank products by value or age, and it is only as safe as the drawer it sits in.

Google Sheets or Excel

A spreadsheet is the most flexible low-cost option. Google Sheets is free with a personal Google account and works in a phone browser or app, so the owner can check stock away from the shop. Excel licensing depends on the version and plan you use. Either way, test the setup on the actual phones your staff use, with the shop's real internet connection, before relying on it.

Set it up with three tabs: Items (one row per SKU), Movements (one row per stock movement) and Stock (a calculated summary). Here is a small worked example, with illustrative prices.

Items tab

Movements tab

Stock tab

Staff always type a positive quantity and pick the movement type from a dropdown (Data validation). A helper column in Movements (column G here) turns that into a signed quantity, and the Stock tab does the rest:

Movements!G2 signed qty: =IF(OR(C2="Purchase receipt",C2="Customer return",C2="Transfer in",C2="Adjustment in"),D2,-D2)

Stock!C2 net movement: =SUMIFS(Movements!G:G,Movements!B:B,A2)

Stock!D2 balance: =B2+C2

Stock!F2 flag: =IF(D2<0,"CHECK: negative",IF(D2<=E2,"REORDER",""))

Items!G2 duplicates: =IF(COUNTIF(A:A,A2)>1,"Duplicate SKU","")

Stock columns B and E pull opening stock and the reorder point from the Items tab with a lookup, for example =VLOOKUP(A2,Items!A:F,5,FALSE) and =VLOOKUP(A2,Items!A:F,6,FALSE). Copy each formula down its column. The flag compares shelf balance only, so add an On order column and compare balance plus on-order stock if you order often. For more than one location, add a Location column to Movements and a matching condition to the SUMIFS.

Protect the Items and Stock tabs so staff can only add rows to Movements, and route every adjustment through the owner. Version history helps you see and undo changes, but it is a backup, not a control system: tight permissions, written adjustment reasons, regular backups and physical counts do that job.

Spreadsheets have no fixed capacity limit you will hit on a given day. Move on when formulas slow down on your devices, several people need to edit at once, or you spend more time fixing errors than reading the numbers.

Low-Cost Apps and Open-Source Software

The next step up is a dedicated app. TallyKhata, a digital ledger built for local merchants, has already moved many shopkeepers from paper to phone, and its website says it supports recording sales, purchases, stock and expenses. That makes it a natural first stop, but a bookkeeping app will not necessarily offer everything dedicated inventory software does.

Other options include point-of-sale apps with stock modules, international inventory tools with free tiers capped by usage, and open-source systems such as ERPNext or Odoo Community. Open-source software is free to download but needs someone technical to host, back up and maintain it. Pricing and free-tier limits change often, so check current plans before committing.

Before choosing any app, check it against this list:

• Exports SKU-level movements to a spreadsheet, so your data stays yours

• Works offline or tolerates patchy connections

• Backs up automatically, and you have actually tested a restore

• Lets you give staff limited permissions

• Handles the features you need: batches and expiry dates, barcodes, multiple locations, stock reservations for online orders

Move to an app when several staff record sales at once, you run more than one location, your products carry barcodes, or an online store needs stock to update automatically.

Matching the Controls to Your Business Type

The ledger principles above apply everywhere, but a grocery shop, a pharmacy, an online seller and a workshop each need a few extra controls.

Retail Shops

High item counts and frequent small sales are the challenge. A spreadsheet or POS app with item-wise sales works well; count fast movers weekly and record the full expiry date for packaged food.

Pharmacies

A product name and expiry month are not enough. Different batches of the same medicine carry different expiry dates, and a recall means finding every unit of one batch. Record product, batch number, expiry date, quantity and supplier for each receipt, and sell by batch. Check the current requirements of the Directorate General of Drug Administration (DGDA) for storage, records and disposal of expired medicine, since a general retail stock sheet may not meet them.

F-commerce and Online Sellers

The biggest risk is promising stock you do not have. Track four figures for each SKU rather than one:

• On hand: units physically in your shop or godown

• Reserved: units promised to confirmed orders that have not shipped

• Available to sell: on hand minus reserved

• On order: units ordered from suppliers but not yet received

If you hold 10 units and 4 are reserved, you can sell 6, not 10. Release a reservation when an order is cancelled or goes unconfirmed past a cut-off you set. Failed cash-on-delivery parcels come back as customer returns, but inspect them before they rejoin available stock.

If you sell across a Facebook page, a website and a physical outlet, keep one master stock record for all channels, and move to an app that syncs them once manual updates fall behind orders.

Small Manufacturers and Workshops

Track raw materials, work in progress and finished goods as separate stocks, and write a simple bill of materials for each product: how much of each material one unit should use, and the expected yield after normal process loss.

At the end of each batch or week, reconcile material issued to the floor against finished output, material still in work in progress, expected process loss, rejects and any by-products. Only the gap left after all of that is unexplained loss:

Material loss rate (%) = Unexplained material loss ÷ Material issued × 100

A garment subcontractor or small food processor that tracks this per batch can tell normal cutting or cooking loss from wastage, mis-measurement or theft, instead of lumping them together.

Wholesalers and Distributors

Volumes are large, product lines fewer and credit heavy, so stock and receivables need to sit side by side. Supply routes are also changing: B2B platforms like ShopUp, through its Mokam service, now connect manufacturers directly with neighbourhood shops. Whichever route you buy through, set reorder points from the lead times and fill rates you actually observe, not the ones promised.

Use ABC Analysis to Decide What Deserves Attention

Not every product needs the same care. ABC analysis ranks items by annual consumption value, which is the number of units sold or used in a year multiplied by unit cost. It measures how much money each item moves through your stock, which is different from sales revenue.

To run it:

1. Take each SKU's units sold or used over the last 12 months.

2. Multiply by its unit cost to get annual consumption value.

3. Sort from highest to lowest.

4. Add a column showing each SKU's cumulative share of the total.

5. Assign categories using cutoffs that suit your business.

A common starting point is that A items, often around the top 20 percent of SKUs, account for roughly 70 to 80 percent of consumption value; B items are the middle group; C items are the long tail. Treat these as heuristics, not targets your business must hit.

Give A items the most attention: count them weekly, set a high service level so stockouts are rare, and negotiate hardest with their suppliers. Count B items monthly and C items quarterly. Override the ranking where needed: a cheap item with a short shelf life, a critical spare part or an item with a long supplier lead time may deserve A-level care.

Then check slow sellers against typical margins in your industry. A slow item with a high margin, or one that brings customers through the door, can earn its shelf space. The rest should be discounted, returned or dropped.

Stock Counts Your Team Will Actually Do

The annual stocktake before closing the books helps the accounts but does little for running the shop. By the time a gap shows up, the trail is cold. Cycle counting works better: count a small rotating set of items every day or week, so every product is checked regularly without shutting the shop.

A few rules make counts more reliable:

• Blind counts: the person counting writes down what they find without seeing the recorded figure first.

• Two-person receiving: one person counts the delivery, another checks it against the supplier's challan.

• Investigate, then adjust: never correct a balance without a written reason and an approver.

• Separate duties: the person who records sales should not be the only person who counts stock.

Log every count difference the same way, so patterns show up over time:

Once a month, measure the loss you cannot explain. Value it at cost, and keep documented damage, expiry and write-offs out of it, since those are known losses with their own causes:

Shrinkage-to-sales ratio (%) = Value of unexplained stock loss at cost ÷ Sales value for the period × 100

Use the same valuation method every month so the figures compare. A rising ratio is an early warning that receiving, storage or staff behaviour needs attention.

FIFO, FEFO and Expiry Control

First in, first out (FIFO) means older stock sells before newer stock. For anything with a shelf life, use first expired, first out (FEFO) instead, because a later delivery can carry an earlier expiry date.

For packaged food, the packaged food labelling regulations made in 2017 under the Food Safety Act 2013 require expiry or use-by dates on labels. A replacement, the draft Safe Food (Packaged Food Labelling) Regulations 2026, was still awaiting finalisation at the Ministry of Food in October 2026, so check which version applies to what you sell. Expired goods found on shelves during enforcement drives can lead to fines and damage a shop's reputation.

Record the full expiry date, and the batch number where there is one, when goods arrive. Shelve new stock behind old. Writing the expiry month in large marker on cartons helps as a visual reminder, but the record should hold the exact date. Each month, list everything expiring within 60 days so it can be discounted, returned to the distributor or moved before it becomes a write-off.

Measuring Whether Your Inventory System Works

Records are only useful if they change decisions. Four measures, tracked monthly or quarterly with stock valued at cost, show whether you are holding too much, running out too often or collecting stock that no longer sells:

For example, if a shop's cost of goods sold for a quarter is Tk 9 lakh and its average stock at cost is Tk 3 lakh, turnover is 3 and stock sits for about 30 days on average (3 ÷ 9 × 90). Measuring the stockout rate needs a simple habit: staff note every request they could not fill.

Read these together, not alone. Faster turnover is good until stockouts rise, and a slow item is not automatically bad if its margin is high.

Bangladesh Context: VAT Records, Peak Seasons and Supplier Credit

Stock control here overlaps with tax compliance, but the two are not the same record. Under the VAT and SD Rules 2016, which have been amended several times since (most recently with the FY 2026-27 budget), businesses keep purchase and sales accounts in prescribed Mushak forms, including Mushak 6.1 for purchases and Mushak 6.2 for sales, with a combined Mushak 6.2.1 register used in some cases. Which forms apply depends on your VAT status and business activity, so confirm yours against the current rules.

These registers are a useful foundation, because they already capture purchases and sales by invoice, and they can be kept electronically, including through ERP or NBR-approved VAT software. Build your stock ledger on the same invoice numbers and your VAT return reconciles against records you trust. Note that from FY 2026-27, VAT returns are filed after every three tax periods rather than every month, and registered traders file the new Mushak 9.1.1 instead of Mushak 9.1.

But tax registers do not capture everything an inventory needs. Damage, expiry, theft, samples, transfers between branches, materials issued to production and count adjustments usually sit outside them, so keep a separate operational stock record for those. Equally, a stock spreadsheet is not a VAT compliance system on its own.

Whether you need VAT registration or turnover tax enlistment depends on annual turnover, and the Finance Act 2026 changed these rules again, including how turnover tax is set. Check the current position in NBR's 2026-27 VAT instructions (in Bangla) or with a VAT consultant, rather than relying on thresholds quoted in older articles. This article gives an overview, not complete VAT guidance.

For the wider picture of what a young company owes, our guide to tax for startups covers income tax, VAT and filing basics.

Seasonality is the second local factor. Eid-ul-Fitr, Eid-ul-Adha, Pohela Boishakh, school openings and the winter wedding season each shift demand sharply in different categories. Decide when to raise reorder points by working back from the peak: use last year's sales for the same weeks, this year's trend, each supplier's lead time and how much storage space you have. Book delivery slots early for items where every other shop will be ordering at the same time, and see our guide to SME supply chains for the sourcing side.

Larger local companies show what disciplined stock control makes possible. Chaldal built its online grocery business around warehouses it runs itself, where knowing exactly what sits on each shelf is what makes a fast delivery promise believable. A neighbourhood shop does not need that scale, but it needs the same principle: the record must match the shelf.

Finally, supplier credit. Many SMEs buy on baki and sell on baki. Compare your days of inventory on hand with how long you have to pay suppliers. If stock routinely outlasts your credit period, you are financing inventory with borrowed money, and ordering smaller and more often usually helps more than chasing bigger discounts.

A 30-Day Plan to Set Up Your Inventory System

Before starting, name three roles, even if one person holds two of them: a system owner who keeps the item list and backups, the staff who enter movements, and an approver for adjustments and write-offs.

Week 1: Build the Item List

List every product variant with a SKU code, base unit, pack size, cost price and sale price. Merge duplicates and give each item a name your staff recognise on sight. Decide where the records will live: register, spreadsheet or app.

Week 2: Count Everything Once

Do one full physical count, ideally after closing or on a weekly holiday, recording batch and expiry where relevant. This becomes your opening stock. Expect it to differ from what you assumed, sometimes by a wide margin.

Week 3: Record Every Movement

From the day after the count, every receipt, sale, return, damage and transfer goes into the system the same day. The system owner reviews entries each evening for the first two weeks and takes the first weekly backup.

Week 4: Add the Controls

Run the ABC analysis, set reorder points and target stock levels for A and B items, and schedule weekly cycle counts plus the monthly expiry check. At month end, count your A items again, log every difference in the variance log, have the approver sign off adjustments, and confirm a backup can actually be restored.

Start With Your Top Twenty Products

You do not need to fix everything at once, and you do not need to buy software this week. Pick the 20 products with the highest annual consumption value. Count them today, set a reorder point and target stock level for each, and record every movement for one month, including returns, damage and adjustments.

That single habit will tell you a lot about your business: which items really move, where stock goes missing, and how much cash is resting on shelves instead of working for you.

In a market shaped by supplier credit, festival peaks, and tight margins, accurate stock records help Bangladeshi SMEs plan purchases, prepare for Eid rushes and support conversations with suppliers and lenders alongside their other financial documents. They will not guarantee better terms or a loan, but they replace guesses with numbers.

When the 20-item routine runs smoothly, extend it to the rest of the range, then decide whether a spreadsheet still fits or an app has earned its place. The system can grow later. The discipline has to start now.