How to migrate from Excel to inventory software — opening stock done right

The migration in seven steps

Moving stock control from Excel to inventory software comes down to seven steps: freeze scope and pick a cut-off date; clean the item master; define stores and locations; physically count opening stock; import opening balances (with lot and expiry detail where batches apply); go live with document discipline from day one; and reconcile with a first cycle count before formally retiring the sheet. The software part is genuinely the easy half — the migration succeeds or fails on data cleanliness and the opening count.

This guide is written for the most common case: an Indian SME running stock on spreadsheets (often alongside Tally for the books) moving to a proper system for the first time. If you are still weighing the decision itself, start with the pillar guide, what is inventory management software — this page assumes the decision is made and gets you live.

When the spreadsheet has reached its limit

Excel fails predictably, and the symptoms arrive in a familiar order: the sheet and the shelf disagree and nobody knows which is right; only one person understands the file; month-end stock valuation takes days and still gets challenged; fast movers stock out while the godown fills with items nobody remembers buying; and expiry is discovered as a write-off rather than a warning. Underneath all of them is one structural fact — a spreadsheet stores typed balances, not movements, so it cannot tell you how any number came to be. The full failure pattern (and its cousins, like Tally-only quantity tracking) is covered in 10 inventory management mistakes Indian SMEs make; if three or more sound familiar, it is time.

Step 1 — Freeze scope and pick a cut-off date

Three decisions before any data is touched:

• The cut-off date. Opening balances will be true as of one moment. Pick a naturally quiet one — a month-end, a weekend, a festival shutdown — and plan the count around it.
• One data owner. A single named person owns the item list, resolves duplicate disputes and signs off the opening figures. Committees produce three versions of the truth — which is what you are escaping.
• Scope. Which stores, which item categories, day one. Better to go live cleanly on the main store and add the branch godown in week three than to go live everywhere half-checked.

Step 2 — Clean the item master (the real work)

Budget more time here than anywhere else. Export the item list from the sheet and work it column by column:

Freeze new-item creation in the sheet while this runs, or the target moves under you. The cleaned list becomes the item & material master — and if you plan to barcode (recommended — see the barcode system guide), assign barcode values now, in the same pass.

Step 3 — Define stores and storage locations

Decide the physical structure the system will track: which stores (main store, production store, branch godown, scrap yard) and, within them, which storage locations. Follow the real building — locations people can point to — rather than an aspirational scheme nobody will maintain. Opening balances, every future movement and every report will hang off this structure, and store-wise visibility is what later enables transfer-before-buy savings (see reducing carrying costs).

Step 4 — Count opening stock physically

The single most important decision in the whole migration: opening balances come from a physical count, not from the sheet. The sheet's balances are the reason you are migrating — seeding the new system with them imports every historical error and destroys trust in week one.

Count close to the cut-off date. A wall-to-wall count over the quiet weekend is simplest; if that is impossible, phase it by ABC class with A items counted last, nearest to go-live. Record, per item: quantity, location, and — for batch-controlled items — lot number and expiry date (pull expiry from cartons and supplier documents now; it is far cheaper than reconstructing it later). Two-person teams, count sheets or scanned entry, and the discipline that nobody "adjusts" a count to match the sheet — where count and sheet disagree, the physical count wins, every time.

Step 5 — Import opening balances, with lot detail

With the master loaded and the count signed off, seed the system: opening balances import per item, per location, and for batch-controlled items the lot detail — lot number, quantity, expiry — goes in with them, so FEFO and the expiry dashboard work from the first day. Fast Inventory does this through its opening-balance import (spreadsheet in, balances seeded), which writes the opening stock the same way every future movement is written — as records the ledger can trace.

Then verify before go-live: run the item-wise stock report and spot-check twenty items against the count sheets; run the valuation report and sanity-check the total against what finance expects. Fix import errors now, while "now" is still cheap.

Step 6 — Go live with document discipline

Go-live is a change of habit, not just of tool. From the cut-off moment, every movement is a document: goods in through a GRN, material out on an issue slip, returns on a return slip, store-to-store moves as transfers, corrections as adjustments — no exceptions, including urgent ones. This is the discipline that makes the running balance true (the mechanics are in Stock Movements & Transactions), and it is precisely what the spreadsheet could never enforce.

Practical go-live week: station the most confident user at receiving, keep laminated cheat-sheets at the counter (which document for which situation), and hold a 15-minute end-of-day huddle to clear questions while they are small. If books live in Tally, switch on the Tally sync so movements post as stock journals from day one — the accountant sees aligned books immediately, which converts the last sceptic.

Step 7 — Reconcile, then retire the sheet

Two to four weeks after go-live, run the first cycle count on a sample — all A items plus a slice of B and C. The count records book-versus-physical variance only; reconcile each variance with a documented adjustment, and investigate causes in the stock ledger (a missed slip? a UOM slip-up? an import error?). This first reconciliation loop — count, variance, adjustment, cause — is the system proving itself, and it is the habit that keeps accuracy climbing from here (the full method is in how to improve inventory accuracy).

A short parallel run with the old sheet is fine — but give it an explicit end date and one rule: the system is the truth; the sheet is a shadow. After the first clean reconciliation, retire the spreadsheet formally — announce it, archive it read-only, and let the reports (the essential report stack — reorder alerts, valuation, non-moving, expiry) take over the jobs the sheet used to fake.

The four pitfalls that sink migrations

• Seeding from the sheet instead of a count. Imports every historical error; the system is born distrusted.
• Skipping the UOM conversions. The box-versus-pieces error multiplies balances by pack size and surfaces weeks later as an unexplainable variance.
• Open-ended parallel running. Double entry exhausts the team, and the sheet quietly wins. Set the retirement date before go-live.
• Using the system like a fancier Excel. If admin users still "correct" balances directly instead of posting adjustments, you have migrated the tool and kept the disease.

How Fast Inventory Software handles go-live

Fast Inventory Software is built for exactly this journey — it is the migration path its typical customer takes:

• Item master with everything in one place — codes, barcodes, multiple UOMs with conversions, tax groups, cost price, min/max levels, shelf life and issue method (Item & Material Master).
• Opening-balance import that seeds per-item, per-location balances — with lot and expiry detail for batch stock — so day-one reports are correct.
• Every movement as a document on one engine — GRN, issue, return, transfer, gate pass, adjustment — each writing an immutable ledger row.
• Physical stock taking (annual, quarterly, perpetual) recording variance only, reconciled by documented adjustments — your post-go-live proof loop (Stock Taking & Reconciliation).
• Reports from day one — item-wise stock, valuation, reorder alerts, non-moving and the expiry dashboard (Reports & Analytics) — plus barcode labels and scanning when you are ready for step two.

Straightforward INR commercials are on the pricing page, and the team that implements it has walked hundreds of stockrooms off spreadsheets — talk to us about your cut-off date.

Frequently asked questions