Inventory & Stock Management in Excel

Ankeshan's Inventory module tracks your stock in real time inside Excel — across multiple godowns, with batch and expiry management, reorder alerts, and proper valuation — and keeps it accurate automatically as you bill. Every sale reduces stock, every purchase adds it back, so what your workbook shows is what's actually on the shelf, without a separate stock system to maintain.

Ankeshan adds this inside the Excel you already use — nothing new to learn, nothing leaves your PC.

What it does

Maintains a stock master — SKU, barcode, description, unit, category, HSN, and current stock per item.
Updates stock automatically — sales invoices reduce stock, purchase entries add it, tightly linked to the Invoicing module.
Raises reorder alerts — a configurable reorder point per item, with visual flags and a dashboard widget, plus suggested purchase quantities.
Tracks batches and lots — batch number, manufacture and expiry dates, with FIFO or FEFO selection at the time of sale (critical for pharma, FMCG, food, and chemicals).
Manages expiry — alerts for items expiring in 30, 60, or 90 days, which also feed Compliance Reminders.
Supports multiple locations — stock per godown, inter-godown transfers, and location-specific reorder points.
Values stock properly — FIFO or Weighted Average Cost, with opening stock entry at FY start.
Prevents overselling — configurable negative-stock warning or block, so you don't bill what you don't have.
Handles physical verification — bulk count entry with an auto-adjustment journal when the count differs from the book.
Reports what you need — current stock, low stock, dead stock (no movement in 90/180 days), stock ageing, batch-wise stock with expiry, stock movement day book, and valuation by item, location, or total.
Supports USB barcode/QR scanning at billing and multi-unit conversion (Box/Dozen/Piece).

How it works in Excel

You keep a Products master and, if you need them, a list of Locations. Ankeshan records every stock movement automatically — the Stock_Movements sheet fills in as you raise invoices and enter purchases — so you never hand-post stock in and out. When a sale is saved, stock drops (and picks the right batch under FIFO/FEFO if batches are enabled); when a purchase is entered, stock rises.

From that movement history, Ankeshan generates the reports as sheets in your workbook and flags anything below its reorder point or nearing expiry. Because it's all in Excel and offline, warehouse and counter staff work from one live picture without waiting on a cloud sync.

Who it's for

This module fits retailers, wholesalers, distributors, and small manufacturers who carry stock — especially the 67% of Indian SMBs operating across two or more locations. It's particularly valuable for pharma, FMCG, food, and chemical traders who must manage batches and expiry, and for anyone who has lost money to dead stock, overselling, or a stock count that never matches the books.

Good to know

Accuracy starts at the invoice. Auto-reduction is only as right as your billing — bill through Ankeshan and stock stays correct.
LIFO is available but not for tax. Ankeshan offers FIFO and Weighted Average for valuation; LIFO isn't permitted for Indian tax reporting.
Batches are opt-in per item. Turn on batch and expiry tracking only for the items that need it, to keep entry fast for the rest.
Offline. Stock lives in your workbook on your PC — no external inventory service.

Learn more

Launching soon

Pricing is announced at launch. Join the waitlist to keep stock honest and in sync.