The quick answer
Opening stock is the starting point of a new inventory record. Use a dated physical count and a consistent item list rather than importing an old spreadsheet total without checking it. Every later movement depends on this baseline.
Choose a migration cutoff so transactions are not entered in both the old and new records. Stock quantity, stock valuation and customer or supplier opening balances are different inputs and should not be mixed into one upload.
Before you begin
- A migration date and a plan for counter activity during the count.
- Distinct item identifiers, units, prices and verified quantities.
- The valuation basis and any relevant batch, serial or location detail.
See how the pieces connect
Cutoff
Decide which system owns transactions from a date.
Clean
Resolve item and unit inconsistencies.
Count
Verify physical stock and supporting values.
Reconcile
Check the imported baseline before live billing.
Work through the steps
Set the cutoff and responsibilities
Choose when the new system begins owning sales and purchases. Pause or separately record movements during the count. Assign who prepares, imports and reviews the opening data.
Clean the item list
Remove duplicate records and separate variants or pack sizes. Preserve leading zeros in barcodes. Standardise units and identifiers so one physical item does not appear under several names.
Count the stock by location
Count actual quantities and identify damaged, expired or held goods. Where tracking applies, capture the relevant batch or serial identities. Do not import restricted goods as ordinary saleable stock.
Determine the supported valuation input
Use the appropriate documented cost basis and fields. Do not substitute selling price for cost or invent a value merely to make the total look neat. Get accounting valuation decisions reviewed when needed.
Import through the supported format
Use the actual import template and field requirements. Test a small representative set, check validation results and correct the source data. Avoid repeating the same opening upload if it would duplicate quantities.
Reconcile the opening records
Compare item count, quantities by location and valuation totals with the approved baseline. Check identifiers and tracking details. Record any difference before the first live sale.
Start live transactions once approved
Keep the original file, import result and review record. Enter only post-cutoff movements in the new workflow. Customer credit and supplier dues need their separate opening-balance process.
A worked example
A migration baseline has separate checks
Illustrative physical count with simple supported costs; use your actual valuation method.
| Item | Opening quantity | Illustrative unit cost | Opening value |
|---|---|---|---|
| Notebook A | 20 pieces | ₹30 | ₹600 |
| Pen pack B | 12 packs | ₹40 | ₹480 |
| Folder C | 8 pieces | ₹25 | ₹200 |
| Total | Different units kept separate | Do not total unit costs | ₹1,280 |
Compare value totals, but do not add unlike quantities into a meaningful stock count. The item-level quantities remain the inventory baseline.
Common mistakes to avoid
- Importing the same opening quantities twice.
- Using selling price as cost without a valid basis.
- Counting while sales continue without recording the intervening movements.
- Combining stock, customer balances and supplier dues in one field.
Questions you might have
Can I use an old Excel inventory file directly?
First map it to the supported template, clean units and identifiers, and verify quantities. A familiar spreadsheet can still contain stale or duplicate data.
What if I find a mistake after going live?
Investigate the original baseline and later movements, then use the supported authorised correction process. Preserve the explanation and avoid silently rewriting history.
Dukanam
A smart, low-cost choice for small-business GST billing
Dukanam brings billing, purchases, stock, customer balances, payments and reports together. It is built for Indian small businesses that want clear records without a complicated setup.
Best suited to shops that want connected everyday billing and bookkeeping, web and mobile access, and nine product languages. Choose the plan that includes the features you need.
GST-aware billing and preparation depend on your plan. Review records before filing on the GST portal; Dukanam does not directly submit GST returns, government e-invoices or e-way bills.
Current plans with GST preparation
- Advanced Plan₹299.00 per month
Check annual prices, limits, applicable taxes and checkout terms. Paid plans do not include a free trial.
Sources and further reading
Official rules and portal screens can change. Use the linked authority for the current requirements; the figures in our worked examples are illustrative.