Stock Register & Inventory Tracker (Barcodes)

About the Stock Register & Inventory Tracker (Barcodes)

A stock register for a shop, a store room or a small warehouse. Keep your items with their code (SKU), barcodes, unit, usual location, low-stock level and cost, and record every movement: stock in (opening stock, purchases, customer returns, count gains), stock out (sales, items used or issued, damaged or expired goods, returns to the supplier, count losses) and transfers between locations. Scan items with the phone's camera or a USB barcode scanner — each scan adds one — or pick them by name.

From those entries the register works out the stock on hand at every location, the low-stock and out-of-stock list, the value of the stock under either cost formula IAS 2 and Ind AS 2 allow — first in, first out (FIFO) or the weighted average — an item ledger with opening and closing balances, and a movement summary for any period. The register is kept in this browser on your device, with an optional passcode and encrypted backups; its item list uses the same columns as POS Billing, and barcode labels print through the Label Sheet Maker.

Without a pass the reports stay a free preview: their counts and first rows are on screen with the quantities and values hidden, and the workbook, PDF and CSV files unlock with a Premium pass. Your entries, imports and backups are never locked.

Common uses

• A shop or chemist keeping the stock of the shelf and the back store, with a list of what to reorder each morning.
• A small warehouse or distributor recording purchases, dispatches and transfers between godowns, valued at FIFO for the books.
• An office, school, hostel or site store issuing consumables to departments and writing off damaged items.
• Starting a register from an existing stock list, then keeping it current by scanning barcodes at the counter.

FIFO or weighted average

Both are cost formulas that IAS 2 — and Ind AS 2, India's version of it — allow for goods that are interchangeable: first in, first out assumes the items bought first are sold first, so what is left is valued at the latest costs; the weighted average values every item at the average cost of the stock, worked out again here as each receipt comes in. Choose the one your accounts use and keep to it; switching the setting works every report out again from the same entries, and your entries do not change.

The standard measures inventories at the lower of cost and net realisable value. The register shows cost: damaged, obsolete or slow-selling stock that is worth less than it cost is a write-down to agree with your accountant (the Inventory Valuation Calculator compares the formulas on one item).

Scanning barcodes

• The camera: press Camera on Stock in & out, hold each barcode in the frame, and each read adds one of that item to the entry. The browser’s own barcode reader is used where it has one, otherwise a decoder that runs on this device; the picture never leaves it.
• A USB or Bluetooth scanner types the code into the scan box and presses Enter, so it works with nothing to set up.
• A code is matched against every item’s barcodes and then its own code (SKU), so items without a printed barcode can carry a code label of your own. An unknown code is reported, and the item can be added with that barcode scanned straight into it.

Locations and transfers

Stock is kept per location: the shop floor, a store room, a warehouse, a van. A transfer takes stock out of one location and into another at its cost — under FIFO with each lot’s own receipt date and cost — so the value does not change and the ageing of the stock stays right. The low-stock level is for all locations together, and the stock report can show one location or all of them.

With POS Billing, labels and the stock-ageing report

• POS Billing: the item file of either tool imports into the other, because both read the same column names (Name, Price, Barcode, Code, Unit, HSN, Low stock at, Category). In the same browser, Settings → Items from POS Billing copies its item list in directly; stock counts are not copied, because opening stock needs a cost.
• Labels: Items → Labels for the Label Sheet Maker writes a file with each item’s name, code, barcode and price; open it in the Label Sheet Maker with its “Stock labels with a Code 128 barcode” design to print each item’s name and SKU as a barcode label on A4 sheets or a label printer; the Barcode and Price columns are there for a design of your own.
• Ageing: the FIFO layers file (each lot still on hand, the day it came in and its cost) is what the Inventory Ageing report reads to age and value the stock.

Where your register is kept

In this browser on this device (its IndexedDB storage), never on a server. An optional passcode stores it encrypted (AES-256) and locks it when you step away. Clearing this browser’s site data deletes it, so download an encrypted backup regularly: a reminder shows while changes are not backed up, and a backup restores the whole register on another device or browser.

Limitations

• One register per browser: to use it on another device, restore a backup there. Two people entering on different devices at the same time do not see each other’s entries.
• Stock is valued at cost. Write-downs to net realisable value (damaged, obsolete or below-cost stock) are for you and your accountant to decide.
• Batches, serial numbers and expiry dates are not tracked lot by lot.
• It does not connect to accounting software or marketplaces: items and moves come in and go out as CSV files.
• Quantities are kept to six decimal places and shown to three; amounts are shown at the currency’s usual decimals.

Privacy

Your items, locations and stock moves stay in this browser on this device; nothing you enter or import is uploaded. Scanning uses the camera on the device only. Files leave the page only when you download them yourself.