How to Record Stock In and Out (Simple Method for Small Shops)

By InventAsset · 2026-10-07 · Written with AI assistance, reviewed by InventAsset

Most small shops do not have a stock problem. They have a recording problem. Stock comes in on a busy afternoon and nobody writes it down. Three items break and get thrown away. A friend borrows a box "for a day". A week later, the numbers on paper and the numbers on the shelf have drifted apart, and nobody trusts either.

The fix is not complicated software. It is a simple, consistent way of recording every time stock moves. This guide gives you that method. It works in a notebook, a spreadsheet, or any tool you like.

Step 1: Agree what counts as a movement

A "movement" is anything that changes how much is on the shelf. Write down a short, fixed list and stick to it:

Keeping these separate matters. If everything is just "out", you can't tell whether stock is leaving through sales or through breakage, and those need very different fixes.

Step 2: Record every movement with the same five details

Each line should have:

1. Date.
2. Item (exactly the same name every time).
3. Movement type from the list above.
4. Quantity.
5. Reference: invoice number, order number, or a short note.

A line missing any of these is not finished. An unfinished line is worse than no line, because it may be counted wrongly or not at all.

Step 3: Decide when you record

The best time is as it happens, but that is not always realistic at the counter. Pick a rule that fits your day and write it on the wall:

• Deliveries: record when you unpack and check the box, not when the invoice arrives.
• Sales: record at the end of each day from your receipts, order list, or sales app.
• Damage and loss: record the moment you throw something away or notice it missing.

A fixed routine beats good intentions. Ten minutes at closing time is enough for most small shops.

Step 4: Keep one running balance per item

For each item, the balance is:

Opening quantity + all ins - all outs = On hand

On paper, write the new balance on every line. In a spreadsheet, let a formula do it, for example with SUMIFS across your movement list for that item and movement type. Either way, check the balance against a reorder level: the number at which you want to buy more.

Step 5: Count the shelf regularly

Records drift. People forget, miscount or mistype. A short, regular count catches it early:

1. Each week, count a few items, starting with your fastest sellers.
2. Compare the shelf with your balance.
3. If they differ, add an Adjustment in or Adjustment out line with a note. Don't overwrite the old numbers.
4. If the same item keeps going wrong, look for the cause: unrecorded sales, staff using stock, or theft.

Common mistakes

• Recording only purchases. Many owners write down what they buy and nothing else. You then know what you spent, not what you have.
• Editing old lines. Crossing out or changing past entries hides what went wrong. Always add a new correcting line.
• Different names for the same item. "Tape", "packing tape" and "tape 48mm" become three items. Keep a master list and choose from it.
• Ignoring negative balances. If your balance goes below zero, something was not recorded. Find it rather than writing over it.

Paper or spreadsheet?

Paper is fine if you have a few items and a quiet shop. Once you have more items or more than one person recording, a spreadsheet helps: it adds up for you, can stop typos with dropdowns, and can show which items need reordering. Our stock in/out Google Sheets template guide shows a full do-it-yourself build.

Related guides

• How to make a stock register
• How to track inventory in Google Sheets

Quick recap

• Use a short, fixed list of movement types, including damaged and lost.
• Every line needs date, item, type, quantity and reference.
• Record at fixed times; don't rely on memory.
• On hand = opening + ins - outs. Compare it with the shelf every week.
• Fix mistakes with new lines, never by erasing.