Step 1 of 4 · Stock and wastage

Weekly stock count: same items, same day, every week

Pick the 20 to 40 items that hold most of your money, count them on one fixed day each week, and compare with what you bought and sold to see what goes missing.

Choose a short list of items that matter most, count them on the same day and at the same time every week, and write the numbers in one sheet. The count only becomes useful when you compare it: opening stock plus purchases minus sales should equal what's on the shelf. The gap is your loss, and it tells you where to look.

Why it matters

Without a count, stock is a feeling. The owner thinks there's enough rice, oil or shampoo until the day there isn't, and nobody can say whether last month's high bills came from more customers, price rises or things walking out of the back door.

Purchase invoices, a few months of bills and staff who know where things are kept turn a count into a check. A business before opening can only guess usage; you can measure it, item by item, and see which ones don't add up.

The weekly rhythm is what makes it work. A monthly count is too far apart to remember what happened, and a daily full count is too tiring to keep up. Once a week, on a short list, is a habit most owners can actually sustain.

How to do it

Set aside an hour for the first count. After three or four weeks, the same list usually takes 20 to 30 minutes with two people.

  1. Pick the items that hold your money

    Go through two months of purchase invoices and list items by what you spent on them. Usually 20 to 40 items make up most of the spend: milk, paneer, oil and coffee beans for a cafe; hair colour, developer and keratin for a salon; fast-moving packs and loose staples for a kirana. Count those. Ignore tissues and pens for now.

  2. Fix the day, the time and the unit

    Pick a quiet slot before a delivery arrives, for example Monday at 10 am before the vegetable supply comes. Write the unit next to each item (kg, litre, packet, bottle, tray) and stick to it. Half-used bottles and open bags count as a fraction or by weight on a kitchen scale; decide once and write the rule down.

  3. Count in shelf order, with two people

    Arrange the sheet in the order things sit: front store, back store, fridge, freezer. One person counts aloud, one writes. Rotate who counts across weeks, and do it yourself at least once a month, so the count doesn't depend on one staff member's honesty or memory.

  4. Compare with purchases and sales

    For each item: last week's count + what came in (from invoices or the delivery book) − what should have been used (from your billing app, or recipe quantity × dishes sold) = expected stock. Expected minus actual is the gap. A billing app with stock can do most of this sum for you; a Google Sheet works fine too.

  5. Ask about the three biggest gaps only

    Don't chase every 100 grams. Each week, look at the three items with the largest gap in rupees and ask what happened: wrong portions, unbilled sales, spoilage, a short delivery, or theft. Write the answer next to the item. If an item keeps showing a gap, that's where to change a process.

A made-up week in a small cafe, to show the layout. Put the rupee value of each gap in an extra column.
Item (unit)Last countBoughtUsed per billsExpectedCountedGap
Milk (litre)12140138149−5
Paneer (kg)31011220
Coffee beans (kg)45632.5−0.5

Thrown-away stock also shows up as a gap. If you want to separate spoilage from other losses, keep the two-week wastage log described in measuring wastage alongside the count.

Your result

A fixed list, a weekly slot and a sheet that shows the gap in rupees.

Count day and time: ______  before/after delivery: ______
Counted by: ______ and ______ (owner counts every ___ week)
Items on the list: ____ (covering most of my monthly spend)
Where the sheet lives: notebook / Google Sheet / billing app
This week's three biggest gaps (item, ₹):
1.
2.
3.
Likely reason and what I'll change:

Fill it in on your checklist, next to this topic. It stays in this browser.

Time and cost

Time
An hour to build the list from invoices, an hour for the first count, then 20 to 40 minutes a week. The comparison takes another 15 minutes once the sheet has formulas.
Cost
Free on paper or Google Sheets. A kitchen or platform scale for loose items is a small one-time cost if you don't have one. Billing software with stock is a monthly fee; see the billing step before buying.

Ballparks to verify: prices and fees change by city and over time, so check current rates before you budget.

Common mistakes

  • Counting everything

    A full count of 400 items lasts two weeks and then stops. Start with the items that hold the money and add more only once the habit sticks.

  • Changing the day

    Counting on Monday one week and Thursday the next mixes in a different number of deliveries and sales. The comparison stops meaning anything.

  • Counting but never comparing

    A column of numbers with no expected figure next to it only tells you what's on the shelf, not what went missing.

  • Using it to blame staff

    If every gap becomes an accusation, counts quietly start matching. Treat gaps as questions first; most turn out to be portions or unbilled items.

Go deeper

The playbooks are written for one business each. Start with the full playbook or find yours.

Questions people ask

Do I need software to count stock?

No. A printed sheet in shelf order and a Google Sheet for the sums are enough for most small businesses. Software helps once you're billing everything through it and want expected stock worked out for you; see moving to a billing system with GST and stock.

How do I count stock in a kitchen where things are half used?

Weigh open packs on a scale, or count in fractions (half bag, quarter bottle) and stay consistent. For prepared items such as gravies or batter, count them in containers of a known size.

What size of gap should worry me?

There's no single number. Watch the trend: an item whose gap is the same small amount every week is usually portions or rounding; one that jumps suddenly, or grows every week, needs a closer look.

← All business basics

Menu

Read

Ask an expert Ask an expertFree, real peopleHub
Ask an expert