Stock Taking Guide: How to Count and Reconcile Stock in a Shop or Warehouse

A stock take is the day you find out whether the shop’s records tell the truth. Done carelessly, it produces a new set of wrong numbers and a lot of arguments. Done with a plan, it gives you a stock figure you can trust, a clear list of losses in shillings, and clues about where those losses come from. This guide walks through the whole process for a duka, a mini-supermarket, a hardware store or a warehouse, from the week before the count to posting the final adjustments.

If you want the day-to-day habits that keep stock accurate between counts, our article on stopping stock losses covers receiving, barcodes and weekly spot checks. This guide focuses on the count itself.

When to do a stock take

Plan a full count:

• At your financial year end, so your accountant has a closing stock value
• When you switch to a new POS or ERP, so opening stock is correct from day one
• When a manager or storekeeper hands over to someone new
• After a break-in, flood or anything that may have damaged or removed goods
• When sales and stock figures stop making sense

Between full counts, run cycle counts: a few lines each week, chosen so high-value and fast-moving items come round often.

Before the count: one week to one day ahead

Set the cut-off

The cut-off is the exact moment your count represents. Everything sold before it should be out of the system; everything received before it should be in. Pick a time, such as Saturday at 6pm after the last sale, and tell everyone.

At cut-off:

• Finish entering every sale, including credit sales written in a book
• Receive every delivery that has physically arrived, against its purchase order
• Hold any goods that arrive after cut-off in a separate, marked area and do not count them
• Pause branch transfers, or record goods in transit separately

Tidy the stock

Counting a messy store takes twice as long and produces mistakes. In the days before:

• Put each product in one place where possible. Three half-open cartons of the same nails in three corners invite double counting.
• Separate damaged, expired and returned goods, and label them.
• Agree the unit for every product. A carton of 24 bar soaps is counted either as 1 carton or as 24 pieces, never a mix.
• Label shelves, racks or bins with a location code, for example A1, A2, B1.

Prepare count sheets

Print one sheet per location, listing the products expected there, with columns for the counted quantity, the counter’s initials and a note. Leave the system quantity off the sheet. That is what makes the count blind.

If your system can export the product list to Excel, use that as the starting point. SmartBiashara, for example, exports to Excel, so you can delete the quantity column before printing.

Organise teams

Work in pairs: one person counts, the other writes. Swap roles at intervals. Where possible, do not let a person count the section they are responsible for every day. A fresh pair of eyes finds what familiarity misses.

During the count

Count by location, not by product

Walk the store shelf by shelf, location code by location code. Counting by product means hunting for the same item in different places and losing track of what has been counted.

Rules for counters

• Count what you see. Do not guess what is at the back of a full shelf; open it.
• Open any carton that looks lighter than it should, or has been resealed.
• Count part-cartons and loose units separately and write both.
• Mark each counted area with a sticker or chalk tick so nobody counts it twice.
• Write a note for anything odd: torn packaging, expiry close, product not on the sheet.

Special cases

Goods sold by weight or length. Rice from an open bag, nails sold by the kilo, cable sold by the metre. Weigh or measure what is left and record the unit used.

Batch and expiry items. In a pharmacy or food shop, count each batch separately and record the expiry date. A product can be right in total and wrong by batch, which matters when stock expires.

Serialised items. Phones and electronics should be counted by IMEI or serial number, not just quantity. Check each number against the list.

Goods on display or at the till. Do not forget the items near the cashier, in the window, or out on loan to a customer for approval.

After the count: reconcile

Step 1: Enter counted quantities

Enter the counted figures into your system or spreadsheet against each product and location. Only now compare them with what the system expected.

Step 2: Recount large gaps

Set a tolerance before you look at results. Any line outside tolerance gets a second count by a different pair. Many apparent losses disappear at this stage: a carton counted as pieces, a box hidden behind another, a product put back in the wrong place.

Step 3: Value the variance in shillings

A difference of 50 screws and a difference of 2 phones are not the same problem. Multiply each gap by the cost price, then sort from largest to smallest value. Here is an illustrative example from a hardware store:

Item	Unit	System qty	Counted qty	Gap	Cost per unit (TSh)	Value of gap (TSh)
Cement 50 kg	Bag	180	172	-8	16,500	-132,000
Iron sheet gauge 30	Sheet	95	95	0	24,000	0
PVC pipe 1/2 inch	Length	240	236	-4	4,200	-16,800
Wood screws 2 inch	Box of 100	64	66	+2	3,500	+7,000
Paint 4 L white	Tin	38	35	-3	32,000	-96,000
Padlock 50 mm	Piece	52	52	0	7,800	0
Net variance						-237,800

The net figure is useful for the books. The line-by-line figures are what you investigate.

Step 4: Find the cause of each gap

For every line above tolerance, check the likely causes in this order, from the easiest to rule out to the hardest:

Check	What to look at	What it often finds
Unit errors	Was a carton counted as a piece, or a box as single items?	Large gaps that are exact multiples of the pack size
Timing	Were sales or deliveries entered after cut-off?	Gaps that match one specific invoice or receipt
Receiving	Compare goods received notes with supplier invoices	Short deliveries accepted without counting
Transfers	Did stock leave for another branch without being recorded?	A shortage here, a surplus there
Adjustments	Damaged or expired goods thrown away without a record	Steady small losses in fragile or perishable lines
Sales records	Cash or mobile money sales never entered	Stock falling faster than sales, often on specific shifts
Theft	Pattern by product, shift or person	Repeated losses in small, valuable, easy-to-carry items

In the hardware example, the 8 missing cement bags might match a delivery note for a contractor’s credit order that was loaded but never invoiced. The paint might be three tins used to repaint the shop front and never recorded. Both would be honest mistakes, and both still mean goods left the business without a record.

Step 5: Post adjustments with reasons

Once you have an explanation, or have accepted that you cannot find one, post a stock adjustment for each line. Give every adjustment a reason: damaged, expired, own use, counting error corrected, unexplained loss. Recording adjustments in your system, for example in SmartBiashara’s inventory management, keeps a history you can review next quarter to see whether the same causes keep appearing.

Have someone who did not do the count approve the adjustments.

Step 6: Record the closing stock value

After adjustments, your system stock and the shelves agree. The value of that stock at cost becomes your closing stock for the period, which feeds directly into the cost of goods sold and your profit. Our profit and loss guide explains how.

Warehouses and multi-branch businesses

A warehouse adds a few extra steps:

• Count by bin or bay and record the location for every line, so you can fix stock that is right in total but in the wrong place.
• Count goods in transit between warehouse and branches as a separate list, matched to transfer documents.
• Stagger branch counts if you have few people, but use the same cut-off rules for each. Counting the warehouse on Saturday and the branch on Monday without a cut-off at each makes transfers between them impossible to reconcile.
• Compare branch results. If one branch always shows losses on the same products and others do not, look at that branch’s receiving and cash handling first.

With branches in different towns, a system that holds stock per location and records transfers between them makes the reconciliation far shorter. You see what was sent, what was received, and where the gap sits.

Stock take checklist

One week before

• Choose the date and cut-off time
• Tell staff and suppliers about the count
• Label locations and tidy shelves
• Separate damaged, expired and returned goods

Day before

• Print blind count sheets by location
• Assign counting pairs and areas
• Prepare stickers, pens, calculators and a scale if needed

Count day

• Enter all sales and deliveries up to cut-off
• Move late deliveries to a separate area
• Count every location and mark it done
• Collect and check every sheet is complete and initialled

After the count

• Enter counted quantities
• Recount every line outside tolerance
• Value gaps in TSh and investigate the biggest first
• Post adjustments with reasons, approved by a manager
• Record the closing stock value for the books
• Write down the three main causes found and one action for each

Doing it with software

You can run a stock take with paper and Excel. It becomes easier when sales, deliveries and transfers are already recorded as they happen, because the system quantity is then worth comparing against. SmartBiashara covers real-time stock, adjustments, batch and expiry tracking and, once you have more than one location, inter-store transfers. Plans start at TSh 15,000 a month on Starter for a single location. See the pricing page for branch and product limits, or the POS software overview to see how sales at the counter update stock.