Independent stories for modern IndiaAbout · Contact · Write for us

Small Shop Inventory Spreadsheet: Start With a Stock Count

·

Shop counter with product boxes, an inventory spreadsheet and stock-count notebook

A small shop inventory spreadsheet works best when it records real stock movements consistently. A beautiful dashboard cannot correct an opening balance that was guessed. Begin with a small, countable product group and a clear rule for who records changes.

Define one row per distinct item

Give each distinct size, colour or pack quantity a recognizable internal identifier. Do not combine two items just because customers call them by the same name. A blue medium shirt and a blue large shirt need separate records if you need to know which one can be sold.

For an Indian neighbourhood shop, decide how you will represent units and packs. If purchases arrive in boxes but sales happen by piece, record the conversion explicitly. A change from one supplier’s pack size to another should not silently change the meaning of the quantity column.

Create a simple movement log

Field Purpose
Date and reference Connect the movement with its record
Item identifier Keep variants separate
Quantity in or out Record the physical movement
Reason Sale, receipt, return or approved adjustment

Keep the item list separate from the transaction log. A simple running balance starts with opening quantity, adds receipts and subtracts issues. Treat this as an operational count; it is not a replacement for accounting, tax records or a valuation method.

Reconcile a sample week

  1. Count the chosen items physically.
  2. Record movements during a short trial.
  3. Count them again at the agreed time.
  4. Compare the expected and actual quantities.
  5. Investigate differences before entering an adjustment.

Do not overwrite a wrong balance without leaving a reason. A returned item, damaged unit or unrecorded receipt can explain the difference. Keeping the original movement trail helps identify whether the process needs training or the sheet needs a clearer field.

Choose software after testing the routine

If several people edit concurrently, access controls and change history matter. Keep a recoverable copy and restrict formula editing where your tool supports it. Before importing data into an inventory app, test a handful of items and confirm that an export remains usable.

Compare the wider workflow with our SME business app guide and export and exit checklist. Your first success measure is a count another person can reproduce, not the number of charts in the workbook.