How to Count Stock with QRGold and Export the Count to Excel

QRGold turns your phone into an inventory counter for a shop, warehouse, pharmacy or home. Everything works offline and no account is needed.

Step 1: Create a count list

1. Open Inventory and tap New list.
2. Give it a List name (for example "Shelf A – November") and an optional note.
3. Tap Use for scanning. The scanner now shows "Scans now go into …" with your list's name.

Step 2: Scan to count

• Switch the scanner to Inventory count mode and point the camera at the barcodes.
• When a barcode is already in the list, the app adds +1 or asks How many more?, depending on your settings.
• Several codes in view? Tap Count all.
• Bluetooth and USB barcode scanners work too: open the list and just scan, no camera needed.
• No barcode? Tap Add manually.

In Settings › Inventory you can set how many seconds pass before the same code counts again.

Step 3: Check and edit the lines

Tap a line to edit the Quantity, Unit price and Note. In the quantity field you can type a calculation such as 12*4+3. The top of the list shows the totals of lines, pieces and value. You can add your own columns such as Shelf, Lot number, Expiry date or Checked.

Step 4: Export to Excel

1. Tap Export.
2. Choose the Format: Excel (.xlsx), CSV, PDF, JSON or TXT.
3. Choose the Columns you need. Turn on Also save to Downloads to keep a copy on the phone.
4. Tap Export, then open or share the file.

Count again

Make an Empty copy for a recount (quantities 0): the same products and locations, ready to be counted again. Then use Compare with another list to see the differences line by line.

Get QR Barcode Scanner & Inventory (QRGold) on Google Play