ScanSheet
Run an inventory count with just your phone (no scanner needed)
You can finish a 500-item inventory count in under 90 minutes using a phone camera and a laptop browser. This guide walks through the exact workflow used by small retail shops, churches, and school supply rooms.
Open ScanSheet FreeProduct walkthrough
60-second walkthrough — recording this week.
A short demo of the steps described in this article.
On this page (6 sections)
When a phone is enough
If your barcodes are in good condition and printed at retail size (Code 128, EAN, UPC, QR), a modern phone reads them in any orientation and in moderate lighting. Phone scanning struggles with very small, damaged, or glossy barcodes — for those, a dedicated scanner is still the right tool. For most small-team counts under 5,000 items, the phone is faster and cheaper.
What you need
- A laptop with Chrome, Edge, Firefox, or Safari
- A phone with a working camera (iPhone 7+ or Android 8+)
- ScanSheet open in the laptop browser (no account required for counts under 1,000 unique items)
- A printed list of bin locations, optional but recommended
Step-by-step: 500-item count in 90 minutes
- Open ScanSheet on the laptop. Pick the Inventory template from the top bar.
- Click Create session. A QR code appears.
- Scan the QR with the phone camera. The phone opens a scan viewfinder.
- Walk the bins in order. Tap Start camera and start scanning. Each beep means a successful read.
- For items without a barcode (handwritten tags, fresh produce), type the SKU manually into the laptop table.
- For any quantity mismatch, double-click the row and edit the quantity cell.
- Press Export XLSX when the count is done. Hand the file to the inventory lead.
Tips to halve your count time
- Group items by bin before you start. Bounce-counting is the #1 time sink.
- Pre-print a count sheet so two people can scan in parallel and reconcile later.
- If you have a ring light, set it up over the work area. Phone cameras struggle with shadows.
- Scan in the same direction each pass. Tilting the camera 30° on the same barcode can give different reads.
After the count: what to do with the file
The exported XLSX has barcode, quantity, note, first scan time, and last scan time. Pivot by note to see counts per bin, or filter by first scan time to find items that were missed on the first pass. Pro users can click Export to Google Sheets and have the data land directly in a shared sheet.
Phone scanning vs other no-scanner approaches
| Method | Time for 500 items | Hardware needed | Quantity on re-scan |
|---|---|---|---|
| Phone + ScanSheet (this guide) | 75–90 min | Phone + laptop | Auto-incremented |
| Pen and paper, then type up | 5–6 hours | Printer + laptop | Manual count |
| Voice notes, then type up | 4–5 hours | Phone (voice) | Manual count |
| Hire a temp with their own scanner | 2–3 hours | $150–$300 fee | Manual count |
Common use cases
- Quarterly cycle counts for retail and small warehouses
- Sunday school supply room and church asset audits
- Classroom and lab equipment inventories
Frequently asked questions
Quick answers to what teams ask before they switch to ScanSheet.
How long does a 500-item count actually take?
About 75–90 minutes for a first-time user, including setup. A practiced counter can do it in 40 minutes. The 5-minute warm-up at the start (orientation, lighting, phone grip) is the biggest time saver.
What if the barcode is damaged?
Type the SKU manually into the laptop table. Damaged barcodes are usually under 5% of a typical count. You can also use the note column to flag the location for replacement labels.
Can two people scan into the same sheet at once?
Each browser tab creates a separate session. For multi-user counts, open one tab per scanner, export each tab separately, and combine the CSVs in a spreadsheet.
Ready to scan your first barcode?
No app to install, no credit card to start. Pair your phone with ScanSheet in 60 seconds.
Open ScanSheet Free