Inventory management is the process of knowing what stock a business owns, where it is, what is reserved, what can be sold or used, and when replenishment is needed. A small Indian retailer, wholesaler, manufacturer or D2C seller can begin with a disciplined stock register, documented movement records and regular physical counts; software becomes useful when variants, locations, batches or order channels make manual control unreliable. This guide explains a practical system, the calculations behind reorder decisions and the GST recordkeeping point registered businesses should not overlook.
1. What a useful inventory system must tell you
A stock figure is useful only when it answers the right question. “We have 100 units” is incomplete if 20 are damaged, 15 are reserved for confirmed orders and 10 are sitting at a third-party warehouse. Separate physical quantity, saleable quantity, committed quantity and incoming quantity so the team does not promise stock that is unavailable.
Inventory management connects purchasing, receiving, storage, production, sales, returns and finance. The objective is not to hold the maximum stock or to eliminate every stockout. It is to make deliberate trade-offs between availability, supplier lead time, storage cost, expiry risk, cash tied up in stock and the service level customers need.
| Stock view | Meaning | Use it for |
|---|---|---|
| On hand | Quantity physically recorded at a location | Reconciliation and warehouse checks |
| Reserved / allocated | On-hand stock committed to accepted orders or jobs | Avoiding double-selling |
| Saleable / usable | On-hand quantity less damaged, quarantined or otherwise unavailable stock | Promising customer orders or production |
| Incoming | Purchase orders or transfers not yet received and checked | Planning, not claiming stock is already on hand |
| Inventory position | A planning view that combines usable stock, reliable incoming supply and committed demand | Reorder decisions |
2. Create one item master before buying more software
Start with a single, controlled item master. Every product, raw material, spare part or finished good needs a stable identifier. If the same item appears as “250 ml bottle”, “250ML” and “bottle small” in different sheets, stock balances will split across names and purchasing decisions will be unreliable.
Use a SKU or internal item code that stays consistent across purchase orders, goods-received records, sales orders, invoices, stock counts and warehouse labels. Keep variants separate when size, colour, pack quantity, batch or other attributes change how the item is stored or sold.
- Unique SKU or item code and a clear description.
- Category, variant, unit of measure and pack conversion where needed.
- Preferred supplier, usual purchase unit and realistic replenishment lead time.
- Purchase cost and the valuation method configured with the accountant or inventory system.
- Storage location, bin or godown, and whether the item is raw material, work-in-progress, finished good or resale stock.
- Batch, serial number, expiry or manufacturing date fields where the product requires them.
- Reorder point, minimum order quantity and review owner, with the date the settings were last checked.
3. Record every stock movement at the moment it happens
A spreadsheet or software package cannot correct a process in which goods move first and records are updated days later. Assign a movement record to every receipt, sale, return, transfer, production issue, finished-goods receipt, sample, damage, write-off or other adjustment. The record should identify the item, quantity, unit, date, source document, location, person recording it and reason.
Use the document that proves the movement. A purchase order records what was ordered; it does not prove that the supplier delivered it. A goods-received note or receiving record captures what was actually counted and accepted. A sales order may reserve stock; dispatch or delivery evidence records what left the location. Keep those events separate.
| Movement | Minimum evidence | Control |
|---|---|---|
| Purchase receipt | Purchase order, supplier document and receiving count | Record shortages, excess and damage before accepting the receipt |
| Customer dispatch | Sales order, pick list, invoice or delivery document as applicable | Deduct the quantity actually dispatched, not merely quoted |
| Customer return | Return reference, condition check and disposition | Do not automatically put damaged or uninspected returns back into saleable stock |
| Warehouse transfer | Transfer note with sending and receiving locations | Record dispatch and receipt so stock is not duplicated in transit |
| Production issue / completion | Material issue record, bill of materials and output record | Reconcile input, finished goods, scrap and wastage |
| Damage, loss or write-off | Incident note, count, approval and supporting evidence | Use a reason-coded adjustment and retain the audit trail |
4. Separate locations and stock conditions
A multi-location business should not treat all stock as if it were on one shelf. Create a location list for the shop, warehouse, godown, factory, branch, fulfilment partner and stock held in transit. Use a transfer process even when goods move between two rooms if the move affects picking or responsibility.
Also separate stock by condition. Damaged, expired, returned-pending-inspection, quality-hold and customer-reserved quantities should not silently remain in the same saleable total. This simple distinction prevents a website, salesperson or store employee from promising a unit that cannot actually be fulfilled.
- Use one location code for each place where stock is physically controlled.
- Record the dispatch time and receipt time for inter-location transfers.
- Keep goods in transit visible but separate from physically received stock.
- Use a quarantine or hold status for goods awaiting quality inspection.
- Restrict who can move stock between saleable, damaged and write-off categories.
5. Prioritise attention with ABC analysis
ABC analysis groups items by their contribution to annual inventory consumption value, usually calculated as annual quantity consumed multiplied by unit cost. It helps a business spend more control effort on items with greater financial impact. It is not a substitute for checking demand volatility, expiry, supplier risk or strategic importance.
A items normally receive the tightest review because errors or shortages can have a larger financial effect. B items receive a regular control routine. C items may need simpler controls, but a low-value item can still stop production or disappoint a customer if it is essential. Choose thresholds from your own item data; published 80/15/5 or similar splits are examples, not mandatory universal rules.
| Group | Typical management response | Do not assume |
|---|---|---|
| A | Frequent review, stronger receiving/count controls and supplier follow-up | That every A item has the highest unit price |
| B | Scheduled review and ordinary approval controls | That B items can be ignored |
| C | Simpler replenishment and periodic checks | That a low-value critical spare is unimportant |
6. Calculate a reorder point from demand and lead time
A reorder point is the stock position at which the business should start replenishment, allowing for demand while the supplier or production process takes time to deliver. A simple planning formula is: reorder point = average daily usage × replenishment lead time in days + safety stock. Calculate it item by item rather than applying one minimum quantity to every SKU.
For example, assume a product sells an average of 8 units per day, the supplier normally takes 6 days to deliver, and the business chooses 18 units of safety stock after reviewing demand and lead-time variability. The illustrative reorder point is (8 × 6) + 18 = 66 units. This is a worked example, not a recommended buffer for every business.
Compare the reorder point with inventory position, not just the shelf count. A practical planning view is usable on-hand stock + reliable confirmed incoming stock − committed demand. If purchase orders are often late or partially delivered, do not treat every open order as guaranteed supply.
| Input | Illustrative value | Why it matters |
|---|---|---|
| Average daily usage | 8 units | Expected demand during normal conditions |
| Supplier lead time | 6 days | Time between placing an order and usable receipt |
| Safety stock | 18 units | Chosen buffer for uncertainty |
| Reorder point | 66 units | 8 × 6 + 18 |
7. Set safety stock using real variability
Safety stock protects against uncertainty in demand, delivery time or both. It is not a fixed percentage that should be added to every purchase. Review actual supplier lead times, demand peaks, minimum order quantities, shelf life, storage capacity and the financial cost of holding extra stock.
A simple small-business method is to compare average demand and average lead time with the higher-but-plausible demand and delivery delays observed in the business's own records. More formal statistical models can be useful when demand history is stable and sufficiently detailed, but false precision is worse than a transparent estimate.
Revisit the buffer after a supplier changes, a product becomes seasonal, a new sales channel opens, a promotion is planned or stockouts repeatedly occur. For perishable or regulated goods, expiry and storage constraints may matter more than a generic safety-stock formula.
- Measure supplier lead time from confirmed order to usable receipt, not from an optimistic promise.
- Separate routine demand from one-off bulk orders and promotions.
- Review stockout history and the cost of missed sales or interrupted production.
- Set a maximum stock or expiry review so the buffer does not become dead stock.
- Record who approved a change to the buffer and when it should be reviewed.
8. Use cycle counts to catch errors before year-end
A cycle count is a planned physical check of a selected group of items while the business continues operating. Instead of waiting for one large annual count to discover every mismatch, count smaller groups on a risk-based schedule and investigate differences close to when they occur.
A practical policy may count high-value, fast-moving or high-shrinkage items more often than low-risk items. The frequency should be set from the business's own risk and capacity; a weekly, monthly or quarterly cadence is an example to test, not a statutory rule.
Use a blind count where the counter does not see the expected system quantity before counting. Recount material differences, check recent receipts and dispatches, review transfers and returns, then approve a reason-coded adjustment. Never change a number merely to make the report match.
- Select items and locations for the count; pause or control movements in the count area.
- Count the physical quantity and unit, including open packs or loose units.
- Compare with the system balance and identify the difference.
- Check source documents, cut-off timing, unposted transactions and location errors.
- Obtain approval for material adjustments and preserve the original count and reason.
- Track repeated variances by item, location, shift or process so the root cause can be fixed.
9. Handle returns, damage, expiry and stock adjustments separately
Returns and damaged goods are common sources of false stock availability. A returned product may be unopened and saleable, or it may require inspection, repair, repacking or disposal. Record the physical receipt first, then record its condition and final disposition.
For expiry-controlled items, use FEFO—first expiry, first out—where the product's shelf life makes expiry date more important than receipt date. For ordinary non-expiring goods, FIFO—first in, first out—may be a suitable physical-flow method. The appropriate inventory valuation method is a separate accounting decision and should be confirmed with the accountant.
Every quantity adjustment should have a date, item, location, before-and-after quantity, reason, supporting reference and approver. Zoho's inventory documentation illustrates separate quantity adjustments for differences such as damage, theft and data-entry error; the control principle applies regardless of the software chosen.
10. Manufacturers need a raw-material-to-finished-goods view
A manufacturer should not track only the finished product. The stock picture may include raw materials, packaging, work-in-progress, finished goods, scrap, by-products and wastage. A bill of materials or production recipe describes the expected inputs for a finished unit; a production issue and completion record show what was actually consumed and produced.
For a simple example, a packaged food unit may use a measured quantity of ingredients, a pouch, a label and an outer carton. If the finished quantity differs from the planned output, record the actual input, output, rejected units and wastage with a reason. Do not force the variance into a generic stock adjustment without understanding the cause.
Separate production planning from financial valuation. The quantity record helps operations understand material use; costing and accounting treatment should be reviewed with the qualified accounting professional responsible for the business.
| Stock class | What to record | Typical control question |
|---|---|---|
| Raw materials | Receipts, issues, returns to store and remaining quantity | Was the right material issued to the right production batch? |
| Work in progress | Stage, batch/job, quantity and material already consumed | Where is the unfinished stock and who owns the next step? |
| Finished goods | Completed quantity, quality status and location | How many units are actually saleable? |
| Scrap / wastage | Quantity, reason, recovery or disposal route | Is the loss normal, unusual or evidence of a process problem? |
11. Review ageing and slow-moving stock before it becomes dead stock
An ageing report groups inventory by how long it has been held or since it last moved. It helps identify items that are tying up cash, consuming storage space, approaching expiry or becoming obsolete. Age alone does not prove that an item is unsellable: seasonal goods, critical spares and products bought for a confirmed order need context.
For each slow-moving item, check remaining demand, expiry, return rights, supplier replacement options, bundle opportunities, alternative uses and realistic resale value. Do not reorder simply because the item has reached a historical minimum if the demand pattern has changed.
A monthly review should identify the owner and next decision for each material ageing issue: retain, transfer, return, rework, discount, use in production or write off after the appropriate approval. Accounting valuation and write-off treatment should be confirmed with the accountant.
12. GST stock records: what registered businesses should know
GST recordkeeping is not the same as an optional stock dashboard. Section 35 of the CGST Act requires a registered person to keep true and correct accounts that include production or manufacture, inward and outward supplies, stock, input tax credit and output tax payable and paid, subject to the Act and applicable rules.
CBIC's account-record rules state that a registered person other than a person paying tax under section 10 must maintain stock accounts for goods received and supplied. The prescribed particulars include opening balance, receipts, supplies, goods lost, stolen, destroyed, written off or disposed of as gifts or free samples, and the stock balance including raw materials, finished goods, scrap and wastage. The rule also addresses related records and electronic backups.
Do not assume that a spreadsheet alone proves compliance. The records need to reconcile with source documents and the accounting/GST records for the business. Applicability, the composition-scheme position, additional sector-specific records, retention and the treatment of a particular adjustment should be checked against current law and with a qualified GST professional.
- Keep item-wise opening and closing balances and record receipts and supplies.
- Record losses, damage, destruction, write-offs, gifts and free samples with supporting documents.
- Maintain separate records for relevant business activities and locations as required by the applicable rules.
- Preserve invoices, delivery challans, credit/debit notes and other documents that explain stock movements.
- Back up electronic records and ensure they can be restored and produced when required.
- Have a CA or qualified GST professional review the business's actual recordkeeping and return position.
13. Spreadsheet, accounting software or inventory system?
A spreadsheet can be a sensible starting point when there are few SKUs, one location, low transaction volume and one person responsible for updates. It becomes fragile when multiple people edit the same file, sales happen across channels, variants or batches multiply, or a stock transfer is not recorded promptly.
Accounting and inventory systems can link purchases, sales, locations, stock counts and reports. TallyPrime documentation describes Stock Summary and Godown Summary views for stock quantity, value and location-level information. Zoho ERP documentation describes replenishment thresholds and quantity/value adjustments. Shopify's inventory guide covers stock visibility across online and physical channels. These are examples of vendor capabilities, not endorsements or claims that every feature is included in every plan.
Choose a tool only after mapping the workflow. Check whether it supports the required units, variants, warehouses, batch/serial/expiry fields, purchase orders, sales channels, returns, approvals, audit history, exports and backup. Verify current pricing, plan limits, data export and integration costs directly with the vendor before committing.
| Option | Can fit when | Main limitation to check |
|---|---|---|
| Controlled spreadsheet | Few items, one location and low transaction volume | Concurrent edits, formula errors, audit history and delayed updates |
| Accounting software with stock features | Purchases, sales and accounts need a common record | Batch, multi-location and production requirements may be limited |
| Dedicated inventory / ERP | Multiple locations, variants, batches, purchasing or production need connected workflows | Setup effort, user permissions, data migration and plan-specific features |
| E-commerce platform inventory | Online catalogue and order availability need to stay aligned | Physical stores, wholesale orders and third-party warehouses may need integrations |
14. Measure stock accuracy and inventory health
Do not measure inventory management only by the total value of stock. A business can have a large stock balance and still be out of the one item needed to fulfil orders. Use a small set of measures that reveal availability, accuracy, cash tied up and the quality of the replenishment process.
Define each measure consistently. Inventory turnover is commonly calculated as cost of goods sold divided by average inventory value for the same period. Days inventory on hand is often estimated as average inventory divided by cost of goods sold, multiplied by the number of days in the period. These are management measures; accounting policy and the selected valuation basis affect the result.
| Metric | Simple calculation | What it helps reveal |
|---|---|---|
| Inventory accuracy | Correctly matched counted units ÷ units counted | Reliability of system balances |
| Stockout frequency | Number of item/location stockout events in a period | Availability and replenishment problems |
| Inventory turnover | Cost of goods sold ÷ average inventory value | How quickly inventory is consumed or sold |
| Days inventory on hand | Average inventory value ÷ period COGS × period days | Approximate time stock is held |
| Ageing exposure | Value or quantity in defined age bands | Slow-moving and obsolete stock |
| Adjustment rate | Adjusted units or value ÷ relevant stock movement or balance | Where records or processes repeatedly fail |
15. A practical 30-day inventory-control rollout
Do not attempt to digitise every warehouse process on day one. Start with the items and locations that create the largest operational or financial risk, prove that movements are recorded, then expand the system.
| Period | Work to complete | Evidence of progress |
|---|---|---|
| Days 1–5 | List SKUs, variants, units, suppliers and locations; remove duplicate item names | Approved item master and location list |
| Days 6–10 | Define receiving, dispatch, returns, transfer and adjustment records | One documented movement workflow with owners |
| Days 11–15 | Perform a baseline physical count and reconcile differences | Signed count sheet and reason-coded variances |
| Days 16–20 | Calculate initial reorder points for priority items and identify ageing stock | Reviewed reorder list and slow-moving action list |
| Days 21–25 | Start risk-based cycle counts and a weekly stock review | Count calendar and exception log |
| Days 26–30 | Evaluate spreadsheet or software fit; confirm GST recordkeeping with the accountant | Tool decision, export/backup test and control checklist |
16. Weekly and monthly review checklist
A short routine is more useful than a large report that nobody reviews. Give each exception an owner and a due date.
- Review items below reorder point and confirm whether open purchase orders are reliable.
- Check negative stock, unposted receipts, dispatches and transfers.
- Review damaged, returned, expired and quarantined stock separately.
- Investigate material cycle-count differences and repeated adjustment reasons.
- Review ageing stock, supplier lead-time changes and upcoming seasonal demand.
- Compare physical stock, inventory records and accounting/GST records with the responsible professional.
- Back up the item master and transaction records; test that an export can be opened and restored.
- Approve changes to reorder levels, minimum quantities and stock write-offs.
17. Frequently asked questions
What is the simplest inventory system for a small business? Start with a unique item code, one movement register, location tracking and regular physical counts. A spreadsheet may be enough at low volume, provided one owner controls edits and backups.
How do I calculate a reorder point? Multiply average daily usage by replenishment lead time in days, then add a safety-stock buffer chosen from actual demand and supplier variability. Reorder against inventory position, not just shelf quantity.
How often should stock be counted? Set a risk-based cycle-count schedule. High-value, fast-moving, expiry-sensitive or historically inaccurate items usually deserve more frequent checks. There is no single frequency suitable for every business.
Does GST require stock records? Section 35 of the CGST Act and the applicable account-record rules require registered persons to maintain specified accounts, including stock records, subject to the statutory provisions and exceptions. A qualified GST professional should confirm the business's exact position.
Can I use Excel for inventory management? Yes, for a small and controlled operation. Use protected formulas, unique SKUs, transaction-level entries, restricted editing, backups and regular reconciliation. Move to a suitable system when locations, variants, channels or users make the spreadsheet unreliable.
What is the difference between FIFO and FEFO? FIFO issues the oldest received stock first. FEFO issues stock with the earliest expiry first. Use the physical-flow method that fits the product and its shelf-life risk; inventory valuation is a separate accounting decision.
Should incoming purchase orders be counted as available stock? No. Keep them visible as incoming supply, but do not label them physically available until the goods have been received and checked. For planning, include only confirmed and sufficiently reliable incoming quantities.
What should I do when physical stock does not match the system? Recount, check cut-off timing and source documents, investigate receipts, dispatches, returns and transfers, then make an approved reason-coded adjustment. Do not overwrite the original record without an audit trail.
- CBIC — CGST Act, Section 35: Accounts and other records
- CBIC — Accounts and Records Rules, including stock accounts and electronic records
- Shopify India — Inventory Management: How it Works and Tools
- Shopify India — ABC Analysis: Categorize and Optimize Inventory
- TallyHelp — Track Your Inventory Using Stock Summary in TallyPrime
- TallyHelp — Stock Details for Each Godown in TallyPrime
- Zoho ERP — Replenishments and reorder levels
- Zoho ERP — Inventory Adjustments
- FIN.SWITCH — MSME TEAM and ONDC seller onboarding guide
- FIN.SWITCH — E-commerce website compliance checklist
- FIN.SWITCH — GST invoice compliance checklist
- FIN.SWITCH — Accounts receivable and invoice-to-cash guide
A reliable inventory system is built from accurate item identities, timely movement records, separate stock statuses, physical reconciliation and replenishment rules based on actual demand and supplier lead time. Start with the smallest process your team can maintain consistently, then add software only when the workflow needs it. GST-registered businesses should align stock records with the current CGST Act and applicable rules, with a qualified professional checking the business-specific position.