Free tool

Free Stock Count Sheet for Shops (Excel and Print)

A stock count only helps if you compare it with something. This sheet takes your opening count, what you received and what you recorded as sold, works out what should be on the shelf, and shows the gap against what you counted, in items and in naira.

Fill it in on this page, print it, or download the Excel version. Nothing you type here is sent or stored.

Prefer Excel?

Download the sheet with the formulas built in. It has space for 50 items and a how-to tab.

Download Excel sheet ↓

Stock count sheet

Items counted0
Items with a gap0
Shortage value₦0
Surplus value₦0
ItemOpening countReceivedSold or usedExpected nowCounted on shelfDifferenceCost per unit (₦)Value of difference

Nothing you type here is sent or stored, so save or print the sheet before you close the page.

How to use it

  • List your fast-moving items first: the ones you sell every day, or that cost the most.
  • Opening count is the quantity you counted at the start of the period. Last week's count is a good start.
  • Received is everything that came in since then. Sold or used is everything that left, taken from your own records.
  • Count the item on the shelf and enter it. The sheet shows the difference.
  • Add the cost price per unit to see what each gap costs you.

How to read a gap

A negative difference is a shortage: fewer on the shelf than your records say. A positive difference is a surplus. Look at the biggest shortage value first, and check the causes in this order.

  • A sale or write-off that was never recorded.
  • A wrong quantity entered.
  • Damage, expiry or spillage.
  • A miscount. Recount before drawing any conclusion.
  • Theft, only after the first four are ruled out.

How often to count

Count a few fast-moving items every week instead of everything once a month, and vary the day. Small, frequent counts find problems while they are small and easy to explain. Save or print each sheet so you keep a history.

Common questions

What does a negative difference mean?

It means fewer items on the shelf than your records say should be there. Check for unrecorded sales, wrong quantities, damage or a miscount before thinking about theft.

Why does my stock count not match my records?

Usually because of unrecorded sales, wrong quantities, damaged or expired goods, or mistakes at the till. Theft is possible, but it is rarely the first cause. Recording every movement and counting weekly shows which it is.

How often should I count my stock?

Count a few fast-moving items every week and do a full count less often. A short weekly count finds problems while they are small, and varying the day makes it harder to predict.

Can I use this sheet for a pharmacy or a restaurant?

It works as a simple count sheet for any shop. It does not track expiry dates, batches or recipes, so use the Notes column for those or keep a separate record.

Is the stock count sheet free?

Yes. Use it on this page, print it or download the Excel file, and share it with your staff. You do not need a BOS Afora account.

Want this done for you every day?

BOS Afora keeps your sales, expenses, stock and debts as you tell it what happened, and sends your profit every evening. The Free plan gives you 75 transactions every month and needs no credit card.