Year-End Stock Count: How to Do It and Fix Differences

Why count stock?

System balances show what was recorded. A count shows what is actually there. Differences appear because of damage, theft, receiving or issuing errors, and sales that were never recorded. If these differences stay in the books, your cost of goods sold, profit, and the stock value on the balance sheet will all be off.

A count also helps you:

• Spot slow-moving or expired items before they become a loss.
• Decide which items need reordering.
• Find control gaps, such as who holds the store keys or who records receipts.
• Give your accountant, bank, or partners numbers they can trust.

Types of stock count

For a small shop, the practical approach is a full count once or twice a year, plus a monthly spot check of a few high-value or frequently missing items.

Preparing before count day

Big count errors usually come from poor preparation, not from the counting itself. Get ready as follows:

• Pick the date: choose a quiet day, ideally close to your closing date.
• Form teams: two people per area, one counting and one recording. Nobody should count the section they are responsible for alone.
• Organize the store: group identical items together and keep damaged or returned goods in a clearly marked area.
• Finish pending documents: record all purchase invoices, goods receipts, sales invoices, and returns up to the moment before counting.
• Print the count sheet: include item name, code, location, and unit. Ideally hide the system quantity so counters are not influenced by it.
• Prepare tools: stickers for counted shelves, pens, and barcode scanners if you have them.

Steps

1. Stop movement: pause sales, receiving, and issuing during the count, or log any movement on a separate sheet with its time.
2. Print or export system balances: keep a dated copy of balances at the moment the count starts so you can compare later.
3. Count physically: count each shelf or area completely, then mark it "counted" with a sticker. Record quantities in the unit used in your system, and watch for opened packs.
4. Recount doubtful items: a second team recounts items with large differences, without seeing the first team's result.
5. Compare with the system: calculate the difference for each item: actual quantity minus system quantity.
6. Analyze the causes: review the item's movements for the period and look for unrecorded invoices, wrong units, or similar items swapped.
7. Value and approve: multiply each difference by the unit cost and send the list to the decision-maker for approval before adjusting.
8. Record the adjustment: post the adjustment entries dated on the count date, with the count sheets and the reason attached.
9. Fix the causes: change the procedures that caused the differences, then close the period using your usual steps.

How to handle stock count differences

Before any entry, understand the type of difference:

Example

An item shows 120 units in the system at a unit cost of 25, so its value is 3,000. The physical count finds 112 units: a shortage of 8 units worth 200 (8 × 25). Another item shows 40 units at a cost of 15, and the count finds 44: a surplus of 4 units worth 60 (4 × 15).

After verification and approval, the entries are as follows, in your company currency:

• Shortage: debit "Inventory shortage loss" 200, credit "Inventory" 200.
• Surplus: debit "Inventory" 60, credit "Inventory count gains" 60.

The net effect on profit is a loss of 140. Account names differ between companies depending on your chart of accounts, so ask your accountant which account fits best.

Practical rules for adjustments

• Do not hide a shortage by editing quantities without an entry and documentation, because that erases the trace of the problem.
• Set an internal tolerance for acceptable differences and escalate anything above it to management.
• Do not offset differences between two different items to make the result look like zero. Each item has its own cost.
• Keep signed count sheets together with the adjustment documents.

Stock counts and VAT

Some treatments of differences and of goods leaving without payment may be affected by tax rules in your country. In Saudi Arabia, for example, the VAT Implementing Regulations treat giving goods away without consideration as a deemed supply in certain cases, with exceptions such as promotional gifts and samples that meet the conditions set out in the regulations. Check the current text of the regulations for the exact conditions.

So if a difference comes from gifts, samples, or goods taken for personal use, document it when it happens rather than leaving it for the count to reveal. For tax details specific to your country, consult your tax authority or accountant. If you operate in Saudi Arabia, you can also read how to calculate 15% VAT in Saudi Arabia.

Common count mistakes

• Counting while sales and receiving continue without logging the movements.
• Forgetting goods held outside the store, such as consignment stock at customers or goods in transit.
• Mixing units, such as cartons and pieces, on the same sheet.
• Leaving damaged or expired goods in stock at full value.
• Adjusting differences before investigating their causes.
• Not checking batch-tracked or serial-numbered items by batch and serial number.

How the Inventory app helps

For more, read inventory management for small shops and businesses and the year-end closing checklist for small businesses.

Summary

• A count starts with preparation: finish pending documents, organize the store, and assign teams.
• Recount when in doubt, and compare the result with a dated copy of system balances.
• Find the cause of each difference before adjusting, then value it at unit cost, approve it, and post a documented entry.
• Check how differences and goods leaving without payment affect tax under your country's rules.
• Make spot checks a monthly habit. It costs far less than discovering the problem at year-end.