Annual stocktake guide: steps, count sheet template and adjustment entries
A practical guide to the year-end physical stock count: how to plan it, control the cut-off, organise counting teams and blind counts, investigate variances and post the adjustment entries, with a simple count sheet you can copy and a note on cycle counting.
The year-end stocktake is the one day when the numbers in your system meet the boxes on your shelves. For most trading and retail businesses, inventory is one of the largest figures on the balance sheet, and auditors expect evidence that it exists and is in a sellable condition. A well-run count takes planning more than effort: most problems come from goods moving during the count, unclear locations or counters who simply confirm what the system already says. This guide walks through the steps, gives you a count sheet template, and shows the entries that close the loop. If you are setting up a system for this, our inventory software page explains how stocktakes work in Aspirations.
Step 1: Plan two to three weeks ahead
- Fix the date and time. Ideally the last day of the financial year after closing, or the nearest weekend. If you count on a different date, you will need to roll the results forward or back to the year-end, and auditors will test the movements in between.
- Tell your auditor. Under ISA 501, where inventory is material the auditor normally attends the count to observe procedures and perform test counts. Agree the date with them early.
- Map the locations. Every warehouse, room, shelf and bin gets a code. Include stock held by third parties, stock in transit and consignment stock, and decide how each is handled.
- Tidy up first. Group identical items together, separate damaged and expired goods, and label anything that does not belong to you (customer goods awaiting collection, supplier consignment).
- Write instructions. One page: start and end times, who counts where, how to record, what to do with unlabelled items, and who has authority to resolve questions.
Step 2: Control the cut-off
Cut-off is the most common source of stocktake errors. Every receipt and dispatch must fall clearly on one side of the count. In practice:
- Stop receiving and dispatching during the count, or move incoming goods to a separate "not yet counted" area.
- Record the number of the last goods received note, delivery note and invoice before the count. Goods invoiced to customers but not yet collected should not be counted as your stock.
- Post all receipts, transfers and returns in the system before you print or export the count list, so that the system quantity reflects the same moment as the physical count.
Step 3: Organise counting teams
Work in pairs: one person counts, the other records. Assign each pair specific locations, and rotate people away from the areas they manage every day; a storekeeper counting his own shelves is less likely to spot his own errors. Give each team pre-numbered count sheets and keep a register of which sheets were issued and returned, so no area is missed or counted twice. Mark each counted location with a tag or sticker.
Blind counts
In a blind count, the sheet shows the item and location but not the system quantity. Counters write what they actually see. It takes slightly longer but removes the temptation to "agree" with the system, and it is what makes the variance report meaningful. Where scanners are used, the same principle applies: the device records the scan without showing the expected figure.
Batches, expiry dates and units
Where items carry batch numbers and expiry dates, as in pharmacies, food and cosmetics, count by batch rather than by item total. A correct total with the wrong batch split still leaves you selling stock the system thinks has expired, or missing stock that is about to. Record near-expiry batches on the sheet so they can be discounted, returned to the supplier where the agreement allows, or written down. For items sold in more than one unit, such as pieces and cartons, agree in advance which unit is counted.
Count sheet template
A simple layout that works on paper or in a spreadsheet. The last three columns are filled in only after the count, by someone other than the counters.
| Sheet no. | Location | Item code | Description | Unit | Batch / expiry | Counted qty | Condition | Counter / recorder | System qty | Variance | Recount qty |
|---|---|---|---|---|---|---|---|---|---|---|---|
| 017 | WH1-A-03 | CL-0145 | Floor cleaner 4 L | Bottle | B2311 / 06-2027 | 118 | Good | R.K. / S.M. | 130 | -12 | 118 |
| 017 | WH1-A-03 | CL-0152 | Glass cleaner 750 ml | Carton (12) | B2402 / 02-2027 | 41 | 2 damaged | R.K. / S.M. | 40 | +1 | |
Rules that keep the sheet reliable: write in pen, cross out errors with a single line and initial them rather than overwriting, record the unit you counted (bottle or carton), and record damaged or expired units separately so they can be written down.
Step 4: Review variances and recount
Once the sheets are in, someone outside the counting teams compares counted and system quantities. Set a threshold, for example any variance above a set value or a set percentage of the item's quantity, and send those items for a recount by a different team. Then investigate what remains. Typical causes:
- Receipts or dispatches posted on the wrong side of the cut-off.
- Unit of measure confusion: cartons counted as pieces, or the reverse.
- Items stored in two locations, with one location missed.
- Sales or transfers not posted, or posted twice.
- Genuine loss: theft, breakage, expiry or evaporation.
Only after this review should the counts be approved. Keep the signed sheets and the variance report; they are the audit trail.
Step 5: Post the adjustment entries
Approved variances are posted as stock adjustments at cost, using the same valuation method you use for the rest of your stock (see our FIFO and weighted average guide).
- Shortage: Dr Inventory shortages and losses (expense); Cr Inventory.
- Surplus: Dr Inventory; Cr Inventory shortages and losses (or a separate surplus account).
- Damaged or expired stock: write down to net realisable value or write off, as IAS 2 requires inventory to be carried at no more than it can be sold for.
Repeated large adjustments in the same items are a signal to look at controls, not just to post entries. The tax treatment of losses and write-offs, including any sales tax implications, is a question for your accountant.
Cycle counting: smaller counts all year
Cycle counting replaces, or supplements, one big count with small, frequent counts. A common approach is ABC classification: the A items (high value or fast moving) are counted monthly, B items quarterly, and C items once or twice a year. Benefits: errors are found while they are fresh, the warehouse does not have to close, and the year-end count becomes a confirmation rather than a discovery. Cycle counting only works if every count follows the same cut-off and blind-count discipline, and if your auditor agrees that the system is reliable enough to rely on. Retailers and supermarkets with thousands of items often find it the only practical approach; our retail and supermarket software page covers that setting.
Stocktakes in Aspirations
Aspirations handles stocktakes per warehouse, compares counted and system quantities, and posts the approved differences to the general ledger as adjustments at cost. It supports multiple warehouses and transfers, batch numbers with expiry dates, weighted average or FIFO valuation and reorder alerts, and it fits with landed costs on purchases. Plans are being finalised; a free trial is available.
This guide is general information. Agree the count procedures with your auditor, and check the accounting and tax treatment of adjustments with your accountant.
