How to keep track of stock without the hassle in a small shop

· 6 min read

The easiest way to keep track of stock is to build three habits: record every delivery when the goods arrive, reduce stock every time you make a sale, and count what's actually on the shelves now and then, adjusting your records with a clear reason. No big ledger, no recounting every day. What matters is that every record is in one place and nothing is ever deleted.

"Is this still in stock?" is the question buyers ask most, and the one that most often sends shop owners running to the storeroom. Untracked stock means one of two things: items run out without you noticing, or items pile up and your capital is tied up without you knowing how much. This article goes through the steps one by one, with worked numbers.

Why stock needs recording, even in a small shop

Many stall owners feel they know their shop by heart. That's true while there are only a few items and one person minding the shop. Once you have staff, online sales, or a second storeroom at home, memory can't keep up with how fast goods move.

A stock record answers three questions that come up every day. Which items are running low and need restocking? Which items are piling up and shouldn't be bought again for now? And how much money is actually sitting on the shelves in the form of goods?

The third question is often forgotten. Yet if you know the value of your stock, you know how much capital can be put back to work, and you can calculate profit properly.

Step 1: Record goods coming in when they arrive

Every time you buy from a supplier, record the purchase straight away: what item, how many, and the purchase price per unit. Don't wait until the end of the week, because receipts get lost and quantities get forgotten.

This purchase record is what increases your stock, and it also lets you work out the cost of each item. Because purchase prices go up and down, a common method is average cost: the total value of the goods you hold divided by the number of items. That way you still know the real cost per item, even when you bought at different prices.

If you're just starting to keep records, first count everything you have now and record it as opening stock, with its purchase price. This is your starting point.

Step 2: Let sales reduce stock on their own

Stock should go down when an item is sold, not when you remember to cross it off. If every sale is recorded on a receipt or invoice, that record is what reduces stock. Record it once and two jobs are done: the bill for the buyer and the stock reduction.

Don't forget goods that come back. If a buyer returns an item and it's still fit to sell, record it as a return and add it back to stock. If it's damaged, record that too, but don't put it into sellable stock.

One more thing: services have no stock. Shipping charges, installation, or gift wrapping fees are best recorded as services, so they don't show up as goods with negative stock.

Step 3: Count physically now and then, and adjust with a reason

Once a month, or whenever something feels off, count what is actually on the shelves. This is usually called a stock take (stok opname). You don't have to count everything at once; start with the best sellers or the most expensive items.

If the count differs from your records, adjust the records and write down the reason: damaged, lost, expired, or miscounted earlier. A difference recorded with its reason is far more useful than a record quietly corrected.

Why? Because the reasons show you the pattern. If a sack tears every month, maybe the way you stack them needs to change. If small items keep going missing, maybe they're too close to the door.

A simple example: rice stock at Toko Berkah Jaya

Say Toko Berkah Jaya buys 10 sacks of 25 kg rice at Rp 300,000 a sack. Recorded stock is 10 sacks, worth 10 x Rp 300,000 = Rp 3,000,000, so the average cost is Rp 300,000 a sack.

The following week the price rises, and the shop buys another 10 sacks at Rp 320,000. The second purchase is worth 10 x Rp 320,000 = Rp 3,200,000. Stock is now 20 sacks worth Rp 3,000,000 + Rp 3,200,000 = Rp 6,200,000, so the average cost is Rp 6,200,000 ÷ 20 = Rp 310,000 a sack.

Then 5 sacks are sold on receipts. Stock becomes 20 - 5 = 15 sacks. At the end of the month, during the stock take, it turns out 1 sack has torn and can't be sold. The record is adjusted to 14 sacks with the reason "damaged, sack torn".

From this record you know two things straight away. The value of the remaining stock is 14 x Rp 310,000 = Rp 4,340,000. And the loss from the torn sack is 1 x Rp 310,000 = Rp 310,000, large enough to be a reason to improve how you store them.

Common mistakes

Recording in two places

One in a notebook, another on your phone. Over time the two drift apart and you don't know which is right. Choose one place, and make sure everyone in the shop records in the same place.

Deleting old records

When the numbers in your records don't match the shelves, the temptation is to delete and rewrite. Don't. A complete stock history answers "why was it 20 yesterday and 14 now?" without guesswork.

Forgetting the second storeroom

If goods are in the shop and some are kept at home, record stock by location. When goods move from home to the shop, record it as a transfer rather than trying to remember it. Otherwise stock in the shop looks sold out when there's still some at home.

Putting off the recording

Records that are put off usually never get written. A quick note on the spot is better than a neat record that waits until later.

Tracking stock with Tekomata

When a notebook or spreadsheet starts to feel heavy, an app can do the tedious part. In Tekomata, purchase invoices from suppliers add to stock and sales invoices reduce it, with the weighted average cost calculated for you. Returns that go back on the shelf can add to stock again, following rules you set.

Every adjustment from a stock count must have a reason, and every movement goes into the stock history. If you have more than one warehouse, stock and average cost are recorded per warehouse, and transfers between warehouses are recorded too. The product list can be filtered by stock, so items that have run out are easy to find.

If your item list is already in Excel, products and opening stock can be imported from an Excel or CSV file, with a preview before saving. The Basic plan is free with no monthly fee for up to 200 active products, enough to try the three habits above in your own shop.