The Year-End Stocktake Checklist: From First Count to Defensible Record

Your purchase invoices cannot prove your year-end inventory exists. Neither can your storefront dashboard.

They can show what you bought and what your software believes remains. Only a count, supported by records for stock elsewhere, can establish what was actually there and in what condition. Once orders resume and damaged units leave the building, that observation cannot be recreated.

This year-end stocktake checklist for small business sellers follows one record: SKU MUG-750-BLK, a black insulated mug, through a fictional 30 June 2026 year end. Amounts are in generic currency units. The process starts before anyone opens a carton and ends when someone questions the balance a year later.

1. Give the stocktake record an identity before counting

• Create a count ID: YE26-MUG-750-BLK. Give each location and condition line its own suffix. Never use a product description as the only identifier; “black mug” will eventually describe two products.
• Record the reporting cutoff: 30 June 2026, 23:59, warehouse local time, including the time-zone identifier. Record the actual count time separately.
• Assign responsibility: name the count lead, counters, reviewer, and person authorised to post inventory adjustments. If you work alone, schedule a second pass without looking at your first totals.
• Open an evidence folder containing raw counts, movements, ownership documents, costs, condition evidence, and approvals.

The count is a record only your business can arrange to create. A fulfilment provider can count on your behalf; an accountant cannot later infer cracked lids from a supplier invoice.

Photos support that record, but a photograph of shelving is not a quantity count. Likewise, a warehouse balance downloaded in July is not automatically evidence of June quantities. Save observations and dated source records while they still describe the same stock.

2. Map every place the mug could be hiding

• List locations before exporting count sheets: main warehouse, overflow storage, home packing area, retail concession, third-party fulfilment centres, returns cage, repair bench, and stock travelling between them.
• Assign each location a code and an owner. Require an explicit “nil stock” confirmation where appropriate; a missing reply is not zero.
• Separate possession from ownership. Label supplier consignment goods, customer-owned repairs, and goods held for another seller so they are counted for control but excluded from your owned-stock valuation.
• Identify stock you own elsewhere: goods held on consignment, supplier-held goods where ownership has transferred, and qualifying goods in transit.

For our mug, the location register contains MAIN, 3PL-NORTH, and TRANSIT-PO884. The transit reference is a shipment, not a physical bin.

Review contracts and shipping documents rather than deciding ownership from payment or tracking status alone. Delivery terms can inform the decision, but risk transfer and accounting control are not always identical. Flag uncertain cases for your accountant under the applicable accounting framework; check local tax-authority guidance separately if tax inventory treatment differs.

Keep excluded items on a separate schedule with the owner and exclusion reason. Otherwise, next year's reviewer cannot distinguish deliberate exclusion from omission.

3. Prepare blind sheets and stop uncontrolled movements

• Export a timestamped system snapshot by SKU, location, and stock status. Preserve it unchanged; hide expected quantities from counters to reduce anchoring.
• Create count columns: count ID, SKU, barcode, location, bin, unit of measure, pack size, sealed packs, loose units, condition, quantity, counter, count time, and evidence reference.
• Resolve selling units now. If a listing sells a two-pack but purchasing records individual mugs, state the conversion explicitly: 1 selling pack = 2 inventory units.
• Choose a movement freeze or a movement log. During a freeze, physically segregate receipts and picked orders. If trading continues, log each receipt, dispatch, transfer, return, and disposal with timestamp, document ID, quantity, and affected count area.
• Mark the last receipt and dispatch references before counting. These become anchors for the cutoff check.

For kits, count components that remain loose and finished kits separately. Do not count a sealed gift set as one kit and also count its contents as loose mugs. Save the bill of materials used for conversion.

Pre-number paper sheets or assign fixed digital row IDs. Account for unused and cancelled sheets, too. Missing sheet 14 should not become a mystery after someone has cleared the packing bench.

4. Capture quantities and condition in the same pass

• Count in a fixed route: aisle, rack, shelf, then bin. Mark completed bins so another person cannot count them again.
• Check product identity against the item, not just the shelf label. Separate similar colours, capacities, and supplier revisions.
• Open suspect cartons. Verify pack quantities rather than assuming every carton is full. Record which sealed cartons were checked and how the remaining carton quantities were established.
• Record damaged stock separately without deleting it from quantity. Photograph representative defects with the SKU and count reference visible; attach inspection notes where defects vary.
• Enter zero for an inspected empty bin. Leave no ambiguous blanks. Add unexpected stock as new rows rather than squeezing it into another SKU.

At 20:00 on 30 June, the main-warehouse observations are:

Total physically counted: 125 units. Keep all three rows. Combining them into “125 mugs” would erase the information needed to value the stock later.

5. Attach warehouse confirmations and transit evidence

• Request a third-party warehouse report for your cutoff, showing SKU, units, location, status, report time, and time zone. Ask whether it represents a physical count or a system balance and obtain the date and results of the latest physical verification.
• Resolve status buckets. Available, reserved, quarantine, returns, and inbound are not interchangeable. Establish which contain physical stock and whether totals overlap.
• Get explanations for unverified or disputed quantities. Retain correspondence and arrange a count or alternative supporting evidence; do not relabel a system export as a physical count.
• Build a transit schedule with purchase or transfer reference, quantity, dispatch date, origin, destination, ownership basis, and subsequent receipt evidence.

3PL-NORTH confirms 40 mugs: 28 available and 12 reserved but still physically held. In this example, the reserved units remain ours under the sales arrangements.

The provider also shows 30 units as “inbound”. These are shipment PO884, dispatched by Alder Housewares on 28 June and received on 3 July. Contract review establishes that we owned them at cutoff. Include them once, under transit—not again as warehouse stock.

For customer returns travelling back, save the return authorisation, tracking, and contractual position. A refund alone does not prove either physical receipt or the inventory recognition date.

6. Bridge the observation to the year-end cutoff

The physical count happened four hours before year end. It needs a movement bridge, not a new timestamp pasted over the original observation.

• Filter movements from each location's count time to cutoff. Match entries to receiving records, dispatch evidence, and transfer documents, not merely order creation times.
• Apply movements to the affected condition rows. A returned defective mug does not increase saleable stock.
• If counting after year end, reverse intervening movements to calculate the cutoff balance. Preserve both the observation and the bridge.

For MAIN, 12 good mugs arrived after counting and seven good mugs were dispatched. The documented recognition points match those movements in this example.

Cutoff quantity = 125 + 12 − 7 = 130 units.

An internal transfer must leave one location and enter another or transit. It must not change the business-wide total.

7. Investigate quantity differences before changing the ledger

• Compare like with like: the same timestamp, ownership scope, unit of measure, and stock statuses.
• Recount variances independently, including neighbouring bins. Keep the original count and add the recount result, date, and counter; never overwrite the evidence.
• Trace differences to documents: receiving errors, unposted dispatches, wrong-SKU picks, pack conversions, transfers, or disposal records.
• Assign a reason and approver to every adjustment. Use “unexplained shortage after recount” when that is the truth. Do not invent breakage to make the report look tidy.

Our system showed 128 mugs at MAIN at 20:00. The physical count was 125. Both the system and movement bridge then add a net five units, producing 133 recorded versus 130 supported at cutoff.

A blind recount confirms the three-unit shortage. Other locations agree. The system therefore contains 203 units, while the supported owned-stock schedule contains 200.

Do not offset this shortage against three extra blue mugs. Investigate a potential variant miscoding first; if confirmed, document both sides of the correction. Netting unrelated differences hides picking and receiving problems.

8. Add supported costs, then assess recoverable value

• Attach the cost source and method: supplier invoice, attributable freight or other qualifying costs, and the approved FIFO, weighted-average, or other permitted basis.
• Separate recoverable taxes from inventory cost where applicable. Cost inclusions and permitted methods depend on the reporting framework and local tax rules; confirm them with your accountant and relevant tax authority.
• Assess damaged, obsolete, expired, and slow-moving lines individually or in justified groups. An old item is not automatically worthless; an active listing is not proof it will sell.

Alder Housewares invoice AH-6814 shows 240 mugs at 10.80 each: 2,592. Allocated inbound freight is 288, giving (2,592 + 288) ÷ 240 = 12.00 per mug. For this example, the approved cost schedule supports 12.00 for every remaining unit.

Scan2Sheet can capture purchase receipt data into your own Google Sheet with linked cloud-stored receipt images. Link those purchase rows to the cost schedule, but review the allocation yourself: receipt capture does not establish stock quantities or choose a valuation policy.

Under the commonly used lower-of-cost-and-net-realisable-value approach:

For scuffed mugs, expected clearance proceeds of 9.00 less necessary repacking and selling costs of 3.00 support 6.00. Save comparable clearance sales and the cost estimate. The cracked mugs failed leak tests and have no supported recovery value; retain the inspection and later disposal evidence.

The 120 write-down is separate from the quantity shortage. Zero-valued goods still physically present remain on the count schedule until disposal.

9. Clear stocktake exceptions before signing off

Use an exception log with issue, affected row, owner, evidence needed, decision, and resolution date.

Set escalation thresholds before review, but investigate every ownership, duplicate, and cutoff issue regardless of value. Those errors often affect more rows than the first discrepancy suggests.

10. Seal the record so next year's question is answerable

• Reconcile the final schedule to the ledger. In our example: 203 × 12 = 2,436 before adjustments; less 3 × 12 = 36 shortage; less 120 write-down; closing inventory 2,280. Have the bookkeeper choose the appropriate accounts and references.
• Save the approval trail: preparer, reviewer, dates, unresolved qualifications, and posted adjustment IDs.
• Export a fixed copy of the signed count, movement bridge, valuation, and reconciliation. Keep editable working files separately with version history and restricted access.
• Package the supporting files, including warehouse reports, contracts supporting ownership decisions, invoices, photographs, and correspondence. Export copies of evidence behind cloud links so account closure cannot break the record.
• Set retention using local tax-authority requirements, applicable company-record rules, and contractual obligations. Document the retention date rather than assuming one universal period.

In June 2027, someone asks why 200 mugs were worth only 2,280. Search YE26-MUG-750-BLK: the answer should lead directly to the condition rows, clearance calculation, failed leak tests, and approval—not to someone's memory.

Test that retrieval before closing the file. Ask a colleague to find the support for the 60 carrying value of the scuffed mugs without your help.

Use Scan2Sheet to keep purchase evidence linked in your Google Sheet, ready for the next stocktake's cost checks.