How to Run a Stocktake With an iPhone

You can run a full stocktake — the annual physical inventory count — with the iPhones and Android phones your team already carries. The method: divide the space into zones, give every counter DataScan with identical export settings, count each zone with Single Value Scan, then merge every counter's file in one spreadsheet and compare counted stock with book stock. No rented scanner hardware, no counting service.

The stocktake problem: one day, all hands, no room for error

A stocktake (physical inventory count, stock count, annual count — the word varies by side of the Atlantic) compresses a year of record-keeping truth into one high-pressure day. The traditional versions both hurt: clipboards mean a second full pass of typing handwriting into a spreadsheet, and rented scanner terminals mean cost, training the night before, and hardware nobody has used since last year. Meanwhile every counter on your team is already carrying a phone that can scan barcodes.

The phones are not the hard part of a stocktake. Coordination is — which is why most of this guide is about preparation and merging, not scanning.

The year-end stocktake: count everything once

In Germany, § 240 HGB requires merchants (Kaufleute) to draw up an inventory at the end of each financial year. In its classic form, the year-end count (Stichtagsinventur), every item is counted physically once, at or close to the balance sheet date — for many businesses 31 December. Whether that form or another one applies to you, and which records you have to keep, is a question for your tax advisor. For the count itself, three habits help: every shelf belongs to exactly one zone, nothing moves in or out while you count, and every export file is kept.

Before count day: preparation that decides the outcome

• Freeze movement. Count outside trading hours, or cordon receiving and dispatch. Stock that moves mid-count is the classic source of unexplainable variance.
• Tidy first. Returns in the right bin, overstock pulled forward, mystery boxes opened before the count. Counting a messy shelf is slower than tidying and then counting it.
• Label the unlabeled. Bulk goods and house-made items need house barcodes printed ahead of time, or a plan for a short manual list.
• Brief the counters. Ten minutes: how to scan, how to enter quantities, what to do with damaged stock, who to ask. The app itself needs no training beyond that.

Stocktake with iPhones, step by step

1. Divide the space into zones Cut the store or warehouse into zones one person can count in 30-60 minutes — an aisle, a wall of shelving, the back room. Draw it on a floor plan and assign names. Every shelf belongs to exactly one zone: gaps and overlaps are how items get counted zero or two times.
2. Prepare the phones Every counter installs DataScan — on iPhone or Android — and gets the same settings: export format, column headers, date format. In the Single Value Scan settings, switch on Summarize Quantities: each counter's file then already has one row per barcode with its total. A settings file copies the configuration to every phone, so this is minutes, not an evening. The 7-day free trial is enough for a test count before the real one.
3. Count zone by zone with Single Value Scan Single Value Scan is the stocktake mode: scan the product's barcode, count the shelf, type the quantity, next product. One zone per scan session: export the zone, then tap Start New Scan and choose Delete before you count the next zone, so each file holds exactly one zone (file it as zone-A3 2026-12-31). Every scan is saved on the phone the moment you take it — no signal needed in the basement or the cold room.
4. Export every zone as CSV Finished counters export each zone as CSV to one collection point (not as Excel: the app's Excel file stores every value as text, and SUMIF skips text quantities): a shared mailbox by email (through the Mail app or your own SMTP server), an FTP server, or the share sheet. Because each phone exports its own file, there is no mid-count server dependency and no sync to fail.
5. Merge the files into one count Identical columns make merging mechanical: paste every file into the Scans sheet of the free inventory count sheet template, and its count sheet adds up counted stock per EAN with SUMIF — also for an item found in two zones. A pivot table by barcode does the same job. If iPhones and Android phones count side by side and you stock UPC-coded products, bring the barcode column to 13 digits with =TEXT(A2,"0000000000000") first (spreadsheets with a decimal comma, such as German Excel, separate the arguments with a semicolon: TEXT(A2;"0000000000000")), so each product ends up in one row. Spot-check a few rows per counter before moving on.
6. Compare and book the results Compare counted stock with book stock: the count sheet shows the difference per item (the cycle counting guide shows the same with VLOOKUP). Recount large differences the same day while access is easy, then book the counted stock. Using JTL-Wawi? The guide JTL-Wawi: import a DataScan stocktake CSV shows the import with JTL-Ameise. Keep every exported file and ask your tax advisor which records of the count you need.

How long does a phone stocktake take?

Budget from the zones: scanning is quick, and counting the facing is what takes the time. Time a test zone before count day, then divide the zones among your counters so everyone finishes at about the same time. Leave time afterwards for the desk work — pasting the files, the count sheet and the review of differences — which replaces the typing pass of a paper count.

Accuracy tips

• Count blind — never show counters the expected quantity; it magnetizes results.
• Recount hot spots by a different person. A second counter repeating the same error is rare; the same counter repeating it is common.
• Watch case-versus-unit quantities. The classic stocktake bug: scanning a case barcode and entering 1 when it holds 12. Decide the rule per category in the briefing.
• Don't split a zone between people. Fatigue-splitting an aisle produces double counts at the seam; reassign whole zones instead.

Alternatives, weighed honestly

Professional stocktaking services count fast and bring their own hardware; for very large estates or when staff time is the scarcest resource, they are worth the per-count fee — but you learn nothing about where your errors come from, and the data ends up in their format. Rented scanner terminals put the tooling in your hands at rental-plus-shipping cost and one more system to learn annually. Clipboards are free and slow, and the transcription pass adds errors precisely where you were trying to remove them. Phones with a purpose-built app sit in the practical middle: hardware you own, data in your format, and skills that carry over to receiving checks and audits the rest of the year. See what else the same setup covers on the DataScan homepage.