Stock count sheet template

Count what is on the shelf against what the system says, line by line; the sheet computes the variance and values it at cost for the adjustment.

Excel, Word and PDF, free, in Arabic and English.

Preview with sample figures

The preview is the file as it downloads in this language; the figures are samples to replace with your own.

Stock Count Sheet

Number
SC-2026-004
Date
2026-10-31
Warehouse
Main warehouse, Riyadh
Company name
Al Noor Trading Est.
SKUDescriptionUnitSystem qtyCountedVarianceUnit costVariance valueremarks
SHELF-5TSteel shelving unit, 5 tierspc4038-2620.00-1,240.00
PJ-25Pallet jack, 2.5 tpc6601,850.000.00
PAPER-A4Printer paper, A4, boxbox120123368.00204.003 found in office
Total-1,036.00
Counted byApproved by

Counted against the system quantity; the variance, at cost, is posted as a stock adjustment once approved.

Counting what the books say you have

A stock count (جرد) compares the quantity the system carries for each item with what is physically on the shelf. The sheet lists the SKU, the description, the unit, the system quantity, the counted quantity, the variance and its value at cost. Count blind where you can, with the system quantity hidden from the counter, and have a second person recount every variance before it is posted.

  • The count number and date, and the warehouse or location.
  • Per item: SKU, description, unit, system quantity, counted quantity.
  • The variance (counted minus system) and its value (variance × unit cost).
  • Remarks for every difference: found elsewhere, damaged, miscounted, missing.
  • Who counted and who approved.

What happens to the variance

Once approved, the variance is posted as a stock adjustment: a shortage debits an inventory loss account and credits inventory; a surplus does the reverse. The sample shows two shelving units short (−1,240.00 at cost), six pallet jacks exact, and three boxes of paper found in the office (+204.00). The net adjustment is −1,036.00. A year-end count, or a reliable perpetual system with cycle counts, is what the auditor and the zakat return rely on for the inventory figure.

SHELF-5T: 40 on system, 38 counted−2 × 620.00 = −1,240.00
PJ-25: 6 and 60
PAPER-A4: 120 on system, 123 counted+3 × 68.00 = 204.00
Net variance at cost−1,036.00

Questions

How often should I count?

At least once a year, at the financial year end, with movements frozen. Businesses with many lines count a slice every week (cycle counting) so every item is counted several times a year and the year-end count is a formality.

At what cost is the variance valued?

At the item's carrying cost: the weighted average or FIFO cost the system uses. The adjustment then matches what inventory was carried at. Selling price is never used.

Does a stock loss affect VAT?

Input VAT already recovered on goods that are lost or stolen is generally not clawed back, provided the loss is documented. Goods taken for private use or given away are a deemed supply on which output VAT is due. Keep the signed count sheet as the record.

Should the counter see the system quantity?

Preferably not. A blind count, with the expected quantity hidden, removes the temptation to write down what the screen says. Print the sheet without the system column for the counters, and compare afterwards.

Your first compliant invoice is minutes away

Start now for free No credit card needed — invoice in minutes